[Home] [Help]
158: --Function : Retrieve all calculated WC information
159: --Parameter :
160: --IN : p_wc_id IN NUMBER Required
161: -- corresponds to the column HEADER_INTERFACE_ID for
162: -- table RCV_HEADERS_INTERFACE; or SHIPMENT_HEADER_ID
163: -- for table RCV_SHIPMENT_HEADERS. It identifies the
164: -- WC for which the information should be retrieved.
165: -- p_wc_stage IN VARCHAR2 Required
166: -- specifies the stage of the WC (INTERFACE or SHIPMENT)
654: INTO l_wc_intf_prev_submitted
655: FROM
656: PO_LINE_LOCATIONS_ALL POLL,
657: RCV_TRANSACTIONS_INTERFACE RTI,
658: RCV_HEADERS_INTERFACE RHI
659: WHERE
660: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
661: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
662: RTI.PROCESSING_STATUS_CODE = 'PENDING' AND
680: INTO l_wc_intf_prev_delivered
681: FROM
682: PO_LINE_LOCATIONS_ALL POLL,
683: RCV_TRANSACTIONS_INTERFACE RTI,
684: RCV_HEADERS_INTERFACE RHI
685: WHERE
686: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
687: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
688: RTI.PROCESSING_STATUS_CODE = 'PENDING' AND
778: --Function : Retrieve requested amount/qty and material stored amount of a WC
779: --Parameter :
780: --IN : p_wc_id IN NUMBER Required
781: -- corresponds to the column HEADER_INTERFACE_ID in
782: -- the table RCV_HEADERS_INTERFACE
783: -- p_wc_stage IN VARCHAR2 Required
784: -- indicates if the information in the INTERFACE tables
785: -- or the SHIPMENT tables
786: --OUT : x_wc_requested OUT NUMBER
820: SELECT SUM(NVL(RTI.REQUESTED_AMOUNT, Round(RTI.QUANTITY*POLL.PRICE_OVERRIDE,get_currency_precision(poll.po_header_id)))),
821: SUM(NVL(RTI.MATERIAL_STORED_AMOUNT,0))
822: INTO l_requested, l_material
823: FROM RCV_TRANSACTIONS_INTERFACE RTI,
824: RCV_HEADERS_INTERFACE RHI,
825: PO_LINE_LOCATIONS_ALL POLL
826: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
827: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
828: POLL.PAYMENT_TYPE in ('MILESTONE', 'LUMPSUM', 'RATE') AND
830:
831: SELECT SUM(NVL(RTI.AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE))
832: INTO l_delivery
833: FROM RCV_TRANSACTIONS_INTERFACE RTI,
834: RCV_HEADERS_INTERFACE RHI,
835: PO_LINE_LOCATIONS_ALL POLL
836: WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
837: RTI.PO_LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND
838: POLL.PAYMENT_TYPE = 'DELIVERY' AND
888: --Function : Retrieve the status of a WC
889: --Parameter :
890: --IN : p_wc_id IN NUMBER Required
891: -- corresponds to the column HEADER_INTERFACE_ID in
892: -- the table RCV_HEADERS_INTERFACE.
893: -- p_wc_stage IN VARCHAR2 Required
894: -- indicates if the information in the INTERFACE tables.
895: -- or the SHIPMENT tables
896: --OUT : x_wc_status OUT VARCHAR2
937: IF (p_wc_stage = 'INTERFACE') then
938:
939: SELECT processing_status_code, transaction_type
940: INTO l_header_processing_status, l_header_transaction_type
941: FROM RCV_HEADERS_INTERFACE
942: WHERE HEADER_INTERFACE_ID = p_wc_id;
943:
944: IF(l_header_processing_status = 'DRAFT' and
945: l_header_transaction_type = 'DRAFT') THEN
1136: --Function : To retrieve the cancellation status of a WC
1137: --Parameter :
1138: --IN : p_wc_id IN VARCHAR2 Required
1139: -- corresponds to the column SHIPMENT_NUM in
1140: -- the table RCV_HEADERS_INTERFACE.
1141: --OUT : OUT VARCHAR2 Required
1142: -- returns the cancellation status of the WC
1143: -----------------------------------------------------------------------------
1144:
1213: --Function : Cancel a WC
1214: --Parameter :
1215: --IN : p_wc_num IN VARCHAR2 Required
1216: -- corresponds to the column SHIPMENT_NUM in
1217: -- the table RCV_HEADERS_INTERFACE.
1218: --IN : p_wc_id IN NUMBER Required
1219: -- corresponds to the column HEADER_INTERFACE_ID in
1220: -- the table RCV_HEADERS_INTERFACE.
1221: -- p_wc_stage IN VARCHAR2 Required
1216: -- corresponds to the column SHIPMENT_NUM in
1217: -- the table RCV_HEADERS_INTERFACE.
1218: --IN : p_wc_id IN NUMBER Required
1219: -- corresponds to the column HEADER_INTERFACE_ID in
1220: -- the table RCV_HEADERS_INTERFACE.
1221: -- p_wc_stage IN VARCHAR2 Required
1222: -- indicates if the information in the INTERFACE tables.
1223: -- or the SHIPMENT tables
1224: -- p_po_header_id IN NUMBER Required
1286: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1287: WHERE HEADER_INTERFACE_ID = p_wc_id;
1288:
1289:
1290: UPDATE RCV_HEADERS_INTERFACE
1291: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1292: WHERE HEADER_INTERFACE_ID = p_wc_id;
1293:
1294:
1788: --Function : Delete a WC
1789: --Parameter :
1790: --IN : p_wc_id IN NUMBER Required
1791: -- corresponds to the column HEADER_INTERFACE_ID in
1792: -- the table RCV_HEADERS_INTERFACE.
1793: --OUT : x_return_status OUT VARCHAR2
1794: -- return status of the procedure.
1795: -- x_return_msg OUT VARCHAR2
1796: -- return message of the procedure.
1813:
1814: CURSOR l_header_interface_csr
1815: IS
1816: SELECT HEADER_INTERFACE_ID
1817: FROM RCV_HEADERS_INTERFACE
1818: WHERE HEADER_INTERFACE_ID = p_wc_id;
1819:
1820:
1821: --Before removing the WC from the interface tables,
1872: END LOOP;
1873: CLOSE l_header_interface_csr;
1874:
1875: -- Delete records in header interface table.
1876: DELETE FROM RCV_HEADERS_INTERFACE
1877: WHERE header_interface_id = l_header_interface_id;
1878:
1879: COMMIT;
1880: x_return_status := FND_API.G_RET_STS_SUCCESS;
1896: -- a WC yet.
1897: --Parameter :
1898: --IN : p_wc_id IN NUMBER Required
1899: -- corresponds to the column HEADER_INTERFACE_ID in
1900: -- the table RCV_HEADERS_INTERFACE.
1901: --OUT : x_approvers OUT PO_TBL_VARCHAR2000
1902: -- return all "future" approvers
1903: -- x_return_status OUT VARCHAR2
1904: -- return status of the procedure.