com.retek.component.customerorder.impl.persistence.db.oracle
Class OracleCustomerOrderDao

java.lang.Object
  extended bycom.retek.commons.domain.core.persistence.db.oracle.AbstractOracleDao
      extended bycom.retek.component.customerorder.impl.persistence.db.oracle.OracleCustomerOrderDao
All Implemented Interfaces:
CustomerOrderDao

public class OracleCustomerOrderDao
extends AbstractOracleDao
implements CustomerOrderDao


Constructor Summary
OracleCustomerOrderDao()
           
 
Method Summary
 ReferenceCache createReferenceCache(java.lang.Class businessInterface)
          Creates a reference for a new given businessInterface.
 void deleteECDDRecalculationItem(DistributedReference ref)
          Deletes all the ECDDRecalculationItems from the database.
 java.util.Set findAccommodationReasons(AccommodationReasonSearchCriteria criteria)
          Retrieves accomodation reason based on the search criteria.
 java.util.Set findAllSupplierReturnDispositions()
          Retrieves all supplier return dispositions within the system.
 java.util.Set findCustomerOrderReferences(OrderSearchCriteria criteria)
          Retrives all customer order references based on the search criteria.
 java.util.Set findCustomerOrderReferences(OrderSearchCriteria criteria, java.util.Map tenderTypeAuthPeriodMap, RDate expirationCompareDate)
          Retrives all customer order references based on the search criteria.
 java.util.Set findCustomerOrderReferencesForSalesAuditExport()
          Retrives all customer order references that are ready for Sales Audit Export
 java.util.Set findCustomerOrders(OrderSearchCriteria criteria)
          Retrives all customer orders based on the search criteria.
 java.util.Set findCustomerOrders(OrderSearchCriteria criteria, java.util.Map tenderTypeAuthPeriodMap, RDate expirationCompareDate)
          Retrives all customer orders based on the search criteria.
 java.util.Set findCustomerOrdersWithBackorderedLinesForSellingSkuRefs(java.util.Set sellingSkuRefs)
          Retrieves all Order that have an OrderLine with any of the SellingItem that are backordered.
 java.util.Set findECDDRecalculationItems(ECDDRecalculationItemSearchCriteria criteria)
          Retrieves all the ECDDRecalculationItems from the database based on the search criteria.
 java.util.Set findRecalculateBOLineECDDRecords(RecalculateBOLineECDDRecordSearchCriteria criteria)
          Retrieves RecalculateBOLineECDDRecords ready to be processed in RecalculateBOLineECDDBatch.
 java.util.Set findReleaseBackorderLineRecords()
          Retrieves ReleaseBackorderLineRecords ready to be processed in ReleaseBackorderedLinesBatch.
 java.util.Set getAllOrderPendReasons()
          Retrieves all persisted order pend reasons
 int getCustomerOrderSalesAuditTransactionCount(RDate transactionDate)
          Calculate the number of customer orders that are ready for Resa export on a specified date.
protected  java.lang.String getDaoResourceProperty()
           
 java.lang.String getNextSettlementFileNumber()
          Generetes next unique settlementFileNumber
 CustomerOrderDto persist(CustomerOrderDto orderDto, DistributedReference userRef)
          Persists a CustomerOrderDto.
 OrderPendReasonDto persist(OrderPendReasonDto dto)
          Persists a specific Order Pend Reason
 OriginalOrderSummaryDto persist(OriginalOrderSummaryDto dto)
          Persists a OriginalOrderSummaryDto.
 SupplierReturnDispositionDto persist(SupplierReturnDispositionDto dto)
          Persists a SupplierReturnDisposition.
 java.util.Set persistECDDRecalcItems(java.util.Set ecddReclaclItemDtos)
           
 CustomerOrderDto persistOrderForSalesAuditExport(CustomerOrderDto customerOrderDto, DistributedReference userRef)
          Persists a CustomerOrderDto for Sales Audit.
 CustomerOrderDto read(DistributedReference ref)
          Retrives a specific customer order based on the reference
 java.util.Set read(java.util.Set refs)
          Retrives a set of customer orders based on the reference set
 AccommodationReasonDto readAccommodationReason(DistributedReference ref)
          Retrieves a specific accommodation reason based on the reference.
 CustomerOrderPaymentDto readCustomerOrderPayment(DistributedReference reference)
          Retrives a specific CustomerOrderPaymentDto based on the reference
 CustomerOrderTransactionGroupDto readCustomerOrderTransactionGroup(DistributedReference reference)
          Retrives a specific CustomerOrderTransactionGroup based on the reference
 SupplierReturnDispositionDto readDisposition(DistributedReference reference)
          Retrives a specific supplier return disposition based on the reference
 OrderPendReasonDto readOrderPendReason(DistributedReference ref)
          Retrieves a specific orderPendReason based on the reference.
 OriginalOrderSummaryDto readOriginalOrderSummary(DistributedReference ref)
           
 ReturnLineDto readReturnLine(DistributedReference returnLineRef)
          Retrives a specific return line based on the reference
 ShipmentRequestDto readShipmentRequest(DistributedReference ref)
          Retrives a specific shipment request based on the reference
 
Methods inherited from class com.retek.commons.domain.core.persistence.db.oracle.AbstractOracleDao
buildReferenceCache
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

OracleCustomerOrderDao

public OracleCustomerOrderDao()
Method Detail

getDaoResourceProperty

protected java.lang.String getDaoResourceProperty()
Overrides:
getDaoResourceProperty in class AbstractOracleDao

persist

public CustomerOrderDto persist(CustomerOrderDto orderDto,
                                DistributedReference userRef)
                         throws SystemException
Description copied from interface: CustomerOrderDao
Persists a CustomerOrderDto. Determines whether the order needs to created or updated. Also responsible for persisting everything the customer order contains (i.e. customerOrderLine, customerOrderTransactionGroups, customerOrderPromotions, ShipTo, ...)

Specified by:
persist in interface CustomerOrderDao
Parameters:
orderDto - customerOrder to be persisted
userRef - reference to the current user
Returns:
customerOrderDto that was persisted
Throws:
SystemException

persist

public OrderPendReasonDto persist(OrderPendReasonDto dto)
                           throws SystemException
Description copied from interface: CustomerOrderDao
Persists a specific Order Pend Reason

Specified by:
persist in interface CustomerOrderDao
Parameters:
dto - the dto to be persisted
Returns:
OrderPendReasonDto the persisted dto
Throws:
SystemException

persist

public SupplierReturnDispositionDto persist(SupplierReturnDispositionDto dto)
                                     throws SystemException
Description copied from interface: CustomerOrderDao
Persists a SupplierReturnDisposition. Determines whether the order needs to created or updated.

Specified by:
persist in interface CustomerOrderDao
Returns:
SupplierReturnDispositionDto that was persisted
Throws:
SystemException

persist

public OriginalOrderSummaryDto persist(OriginalOrderSummaryDto dto)
                                throws SystemException
Description copied from interface: CustomerOrderDao
Persists a OriginalOrderSummaryDto. Determines whether the order needs to created or updated. Also responsible for persisting everything the customer order contains (i.e. customerOrderLine, customerOrderTransactionGroups, customerOrderPromotions, ShipTo, ...)

Specified by:
persist in interface CustomerOrderDao
Parameters:
dto - customerOrder to be persisted
Returns:
originalOrderSummaryDto that was persisted
Throws:
SystemException

findCustomerOrders

public java.util.Set findCustomerOrders(OrderSearchCriteria criteria)
                                 throws SystemException
Description copied from interface: CustomerOrderDao
Retrives all customer orders based on the search criteria.

Specified by:
findCustomerOrders in interface CustomerOrderDao
Parameters:
criteria - filters the customerOrders that are returned
Returns:
Set of customerOrderDtos
Throws:
SystemException

findCustomerOrders

public java.util.Set findCustomerOrders(OrderSearchCriteria criteria,
                                        java.util.Map tenderTypeAuthPeriodMap,
                                        RDate expirationCompareDate)
                                 throws SystemException
Description copied from interface: CustomerOrderDao
Retrives all customer orders based on the search criteria.

Specified by:
findCustomerOrders in interface CustomerOrderDao
Parameters:
criteria - filters the customerOrders that are returned
tenderTypeAuthPeriodMap - filters customerOrders with payment tender type's authorization period
expirationCompareDate - to be used to filter customerOrders with payment tender type's authorization period
Returns:
Set of customerOrderDtos
Throws:
SystemException

findCustomerOrderReferences

public java.util.Set findCustomerOrderReferences(OrderSearchCriteria criteria)
                                          throws SystemException
Description copied from interface: CustomerOrderDao
Retrives all customer order references based on the search criteria.

Specified by:
findCustomerOrderReferences in interface CustomerOrderDao
Parameters:
criteria - filters the customerOrders that are returned
Returns:
Set of DistributedReferences for the orders
Throws:
SystemException

findCustomerOrderReferences

public java.util.Set findCustomerOrderReferences(OrderSearchCriteria criteria,
                                                 java.util.Map tenderTypeAuthPeriodMap,
                                                 RDate expirationCompareDate)
                                          throws SystemException
Description copied from interface: CustomerOrderDao
Retrives all customer order references based on the search criteria.

Specified by:
findCustomerOrderReferences in interface CustomerOrderDao
Parameters:
criteria - filters the customerOrders that are returned
tenderTypeAuthPeriodMap - filters customerOrders with payment tender type's authorization period
expirationCompareDate - to be used to filter customerOrders with payment tender type's authorization period
Returns:
Set of DistributedReferences for the orders
Throws:
SystemException

getCustomerOrderSalesAuditTransactionCount

public int getCustomerOrderSalesAuditTransactionCount(RDate transactionDate)
                                               throws SystemException
Description copied from interface: CustomerOrderDao
Calculate the number of customer orders that are ready for Resa export on a specified date.

Specified by:
getCustomerOrderSalesAuditTransactionCount in interface CustomerOrderDao
Parameters:
transactionDate - the date used to find Resa ready customer orders
Returns:
int Count of customer orders that are ready for Resa export
Throws:
SystemException

getAllOrderPendReasons

public java.util.Set getAllOrderPendReasons()
                                     throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves all persisted order pend reasons

Specified by:
getAllOrderPendReasons in interface CustomerOrderDao
Returns:
set of all persisted OrderPendReasonDto
Throws:
SystemException

read

public CustomerOrderDto read(DistributedReference ref)
                      throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific customer order based on the reference

Specified by:
read in interface CustomerOrderDao
Parameters:
ref - reference of customerOrder to be retrieved
Returns:
CustomerOrderDto specified by the reference
Throws:
SystemException

read

public java.util.Set read(java.util.Set refs)
                   throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a set of customer orders based on the reference set

Specified by:
read in interface CustomerOrderDao
Parameters:
refs - reference set of customerOrders to be retrieved
Returns:
Set set of CustomerOrderDtos specified by the reference set
Throws:
SystemException

createReferenceCache

public ReferenceCache createReferenceCache(java.lang.Class businessInterface)
                                    throws SystemException
Description copied from interface: CustomerOrderDao
Creates a reference for a new given businessInterface. Responsible for retrieving the next unique CustomerOrderAddress id.

Specified by:
createReferenceCache in interface CustomerOrderDao
Returns:
reference to a new businessInterface
Throws:
SystemException

getNextSettlementFileNumber

public java.lang.String getNextSettlementFileNumber()
                                             throws SystemException
Description copied from interface: CustomerOrderDao
Generetes next unique settlementFileNumber

Specified by:
getNextSettlementFileNumber in interface CustomerOrderDao
Returns:
next unique settlementFilenumber
Throws:
SystemException

readShipmentRequest

public ShipmentRequestDto readShipmentRequest(DistributedReference ref)
                                       throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific shipment request based on the reference

Specified by:
readShipmentRequest in interface CustomerOrderDao
Parameters:
ref - reference of shipmentRequest to be retrieved
Returns:
ShipmentRequestDto specified by the reference
Throws:
SystemException

readOrderPendReason

public OrderPendReasonDto readOrderPendReason(DistributedReference ref)
                                       throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves a specific orderPendReason based on the reference.

Specified by:
readOrderPendReason in interface CustomerOrderDao
Parameters:
ref - reference of the specific orderPendReason to be retrived.
Returns:
OrderPendReasonDto specified by the reference
Throws:
SystemException

readCustomerOrderPayment

public CustomerOrderPaymentDto readCustomerOrderPayment(DistributedReference reference)
                                                 throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific CustomerOrderPaymentDto based on the reference

Specified by:
readCustomerOrderPayment in interface CustomerOrderDao
Returns:
CustomerOrderPaymentDto specified by the reference
Throws:
SystemException

readReturnLine

public ReturnLineDto readReturnLine(DistributedReference returnLineRef)
                             throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific return line based on the reference

Specified by:
readReturnLine in interface CustomerOrderDao
Returns:
ReturnLineDto specified by the reference
Throws:
SystemException

readDisposition

public SupplierReturnDispositionDto readDisposition(DistributedReference reference)
                                             throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific supplier return disposition based on the reference

Specified by:
readDisposition in interface CustomerOrderDao
Returns:
ShipmentRequestDto specified by the reference
Throws:
SystemException

findCustomerOrderReferencesForSalesAuditExport

public java.util.Set findCustomerOrderReferencesForSalesAuditExport()
                                                             throws SystemException
Description copied from interface: CustomerOrderDao
Retrives all customer order references that are ready for Sales Audit Export

Specified by:
findCustomerOrderReferencesForSalesAuditExport in interface CustomerOrderDao
Returns:
Set of CustomerOrderDtos
Throws:
SystemException

findReleaseBackorderLineRecords

public java.util.Set findReleaseBackorderLineRecords()
                                              throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves ReleaseBackorderLineRecords ready to be processed in ReleaseBackorderedLinesBatch.

Specified by:
findReleaseBackorderLineRecords in interface CustomerOrderDao
Returns:
Set ReleaseBackorderLineRecords objects found
Throws:
SystemException

findAllSupplierReturnDispositions

public java.util.Set findAllSupplierReturnDispositions()
                                                throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves all supplier return dispositions within the system.

Specified by:
findAllSupplierReturnDispositions in interface CustomerOrderDao
Returns:
Set SupplierReturnDispositionDto objects found
Throws:
SystemException

readCustomerOrderTransactionGroup

public CustomerOrderTransactionGroupDto readCustomerOrderTransactionGroup(DistributedReference reference)
                                                                   throws SystemException
Description copied from interface: CustomerOrderDao
Retrives a specific CustomerOrderTransactionGroup based on the reference

Specified by:
readCustomerOrderTransactionGroup in interface CustomerOrderDao
Returns:
CustomerOrderTransactionGroupDto specified by the reference
Throws:
SystemException

readOriginalOrderSummary

public OriginalOrderSummaryDto readOriginalOrderSummary(DistributedReference ref)
                                                 throws SystemException
Specified by:
readOriginalOrderSummary in interface CustomerOrderDao
Throws:
SystemException

findAccommodationReasons

public java.util.Set findAccommodationReasons(AccommodationReasonSearchCriteria criteria)
                                       throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves accomodation reason based on the search criteria.

Specified by:
findAccommodationReasons in interface CustomerOrderDao
Returns:
Set AccommodationReasonDto objects found
Throws:
SystemException

readAccommodationReason

public AccommodationReasonDto readAccommodationReason(DistributedReference ref)
                                               throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves a specific accommodation reason based on the reference.

Specified by:
readAccommodationReason in interface CustomerOrderDao
Parameters:
ref - reference of the specific accommodationReason to be retrived.
Returns:
AccommodationReasonDto specified by the reference
Throws:
SystemException

findCustomerOrdersWithBackorderedLinesForSellingSkuRefs

public java.util.Set findCustomerOrdersWithBackorderedLinesForSellingSkuRefs(java.util.Set sellingSkuRefs)
                                                                      throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves all Order that have an OrderLine with any of the SellingItem that are backordered.

Specified by:
findCustomerOrdersWithBackorderedLinesForSellingSkuRefs in interface CustomerOrderDao
Returns:
Set CustomerOrder objects found
Throws:
SystemException

persistOrderForSalesAuditExport

public CustomerOrderDto persistOrderForSalesAuditExport(CustomerOrderDto customerOrderDto,
                                                        DistributedReference userRef)
                                                 throws SystemException
Description copied from interface: CustomerOrderDao
Persists a CustomerOrderDto for Sales Audit. Also responsible for persisting everything the customer order contains that needs to be updated for sales audit

Specified by:
persistOrderForSalesAuditExport in interface CustomerOrderDao
Parameters:
customerOrderDto - customerOrder to be persisted
userRef - reference to the current user
Returns:
customerOrderDto that was persisted
Throws:
SystemException

findECDDRecalculationItems

public java.util.Set findECDDRecalculationItems(ECDDRecalculationItemSearchCriteria criteria)
                                         throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves all the ECDDRecalculationItems from the database based on the search criteria.

Specified by:
findECDDRecalculationItems in interface CustomerOrderDao
Returns:
Set ECDDRecalculationItem
Throws:
SystemException

deleteECDDRecalculationItem

public void deleteECDDRecalculationItem(DistributedReference ref)
                                 throws SystemException
Description copied from interface: CustomerOrderDao
Deletes all the ECDDRecalculationItems from the database.

Specified by:
deleteECDDRecalculationItem in interface CustomerOrderDao
Throws:
SystemException

findRecalculateBOLineECDDRecords

public java.util.Set findRecalculateBOLineECDDRecords(RecalculateBOLineECDDRecordSearchCriteria criteria)
                                               throws SystemException
Description copied from interface: CustomerOrderDao
Retrieves RecalculateBOLineECDDRecords ready to be processed in RecalculateBOLineECDDBatch.

Specified by:
findRecalculateBOLineECDDRecords in interface CustomerOrderDao
Returns:
Set RecalculateBOLineECDDRecords objects found
Throws:
SystemException

persistECDDRecalcItems

public java.util.Set persistECDDRecalcItems(java.util.Set ecddReclaclItemDtos)
                                     throws SystemException
Specified by:
persistECDDRecalcItems in interface CustomerOrderDao
Throws:
SystemException


Copyright © 2004 Retek Inc. All Rights Reserved. - Generated at Fri, 10/22/2004 07:28