[Home] [Help]
72: l_draft_exists := 'N';
73:
74: SELECT 'Y' INTO l_draft_exists
75: FROM RCV_HEADERS_INTERFACE RHI,
76: RCV_TRANSACTIONS_INTERFACE RTI
77: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
78: RTI.PO_HEADER_ID = p_po_header_id AND
79: RHI.processing_status_code = 'DRAFT' AND
80: RHI.transaction_type = 'DRAFT' AND
310: IF(p_wc_stage = 'INTERFACE') THEN
311:
312: SELECT SUM(NVL(RTI.AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,POS_WC_VIEW_CANCEL_PVT.get_currency_precision(poll.po_header_id))))
313: INTO l_intf_request
314: FROM RCV_TRANSACTIONS_INTERFACE RTI,
315: RCV_HEADERS_INTERFACE RHI,
316: PO_LINE_LOCATIONS_ALL POLL
317: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID and
318: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
355: --Function : Retrieve the progress on a pay item
356: --Parameter :
357: --IN : p_wc_pay_item_id IN NUMBER Required
358: -- corresponds to the column TRANSACTION_INTERFACE_ID or
359: -- SHIPMENT_LINE_ID in the table RCV_TRANSACTIONS_INTERFACE-- or RCV_SHIPMENT_LINES respectively, depending on the
360: -- p_wc_stage variable. The API is only implemented for
361: -- pay items in 'SHIPMENT' stage at the moment.
362: -- p_wc_stage IN VARCHAR2 Required
363: -- 'INTERFACE' or 'SHIPMENT. Indicates the pay item stage
487:
488: SELECT RHI.request_date, RHI.processing_status_code, RHI.transaction_type
489: INTO l_request_date, l_header_processing_status, l_header_transaction_type
490: FROM RCV_HEADERS_INTERFACE RHI,
491: RCV_TRANSACTIONS_INTERFACE RTI
492: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
493: RTI.INTERFACE_TRANSACTION_ID = p_wc_pay_item_id;
494:
495: IF(l_header_processing_status = 'DRAFT' and
523: BEGIN
524: SELECT sum(NVL(RTI.AMOUNT,RTI.QUANTITY))
525: INTO l_wc_prev_submitted_intf
526: FROM PO_LINE_LOCATIONS_ALL POLL,
527: RCV_TRANSACTIONS_INTERFACE RTI,
528: RCV_HEADERS_INTERFACE RHI
529: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
530: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
531: RTI.PROCESSING_STATUS_CODE = 'PENDING' AND
1011: /* l_interface_amount = amount which is in the interface tables /pending to be approved / rejected before the submission of
1012: current work confirmation for this payitem / distribution */
1013: select nvl(sum(amount),0)
1014: into l_interface_amount
1015: from rcv_transactions_interface
1016: where po_distribution_id= wcr_line_info.po_distribution_id
1017: and processing_status_code='PENDING'
1018: and transaction_status_code = 'PENDING'
1019: and transaction_type = 'RECEIVE';
1119: /* l_interface_quantity = quantity which is in the interface tables /pending to be approved / rejected before the submission of
1120: current work confirmation for this payitem / distribution */
1121: select nvl(sum(quantity),0)
1122: into l_interface_quantity
1123: from rcv_transactions_interface
1124: where po_distribution_id= wcr_line_info.po_distribution_id
1125: and processing_status_code='PENDING'
1126: and transaction_status_code = 'PENDING'
1127: and transaction_type = 'RECEIVE';
1184: If (l_insert_into_rti) then --{
1185:
1186: FOR i IN 1..2 LOOP
1187:
1188: select rcv_transactions_interface_s.nextval
1189: into l_interface_id
1190: from dual;
1191:
1192: IF (i = 1) THEN