[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, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
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