eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_WC_VIEW_CANCEL_PVT dependencies on RCV_HEADERS_INTERFACE

Line 162: -- table RCV_HEADERS_INTERFACE; or SHIPMENT_HEADER_ID

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)

Line 658: RCV_HEADERS_INTERFACE RHI

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

Line 684: RCV_HEADERS_INTERFACE RHI

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

Line 782: -- the table RCV_HEADERS_INTERFACE

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

Line 824: RCV_HEADERS_INTERFACE RHI,

820: SELECT SUM(NVL(RTI.REQUESTED_AMOUNT, RTI.QUANTITY*POLL.PRICE_OVERRIDE)),
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

Line 834: RCV_HEADERS_INTERFACE RHI,

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

Line 892: -- the table RCV_HEADERS_INTERFACE.

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

Line 940: FROM RCV_HEADERS_INTERFACE

936: IF (p_wc_stage = 'INTERFACE') then
937:
938: SELECT processing_status_code, transaction_type
939: INTO l_header_processing_status, l_header_transaction_type
940: FROM RCV_HEADERS_INTERFACE
941: WHERE HEADER_INTERFACE_ID = p_wc_id;
942:
943: IF(l_header_processing_status = 'DRAFT' and
944: l_header_transaction_type = 'DRAFT') THEN

Line 1112: -- the table RCV_HEADERS_INTERFACE.

1108: --Function : To retrieve the cancellation status of a WC
1109: --Parameter :
1110: --IN : p_wc_id IN VARCHAR2 Required
1111: -- corresponds to the column SHIPMENT_NUM in
1112: -- the table RCV_HEADERS_INTERFACE.
1113: --OUT : OUT VARCHAR2 Required
1114: -- returns the cancellation status of the WC
1115: -----------------------------------------------------------------------------
1116:

Line 1189: -- the table RCV_HEADERS_INTERFACE.

1185: --Function : Cancel a WC
1186: --Parameter :
1187: --IN : p_wc_num IN VARCHAR2 Required
1188: -- corresponds to the column SHIPMENT_NUM in
1189: -- the table RCV_HEADERS_INTERFACE.
1190: --IN : p_wc_id IN NUMBER Required
1191: -- corresponds to the column HEADER_INTERFACE_ID in
1192: -- the table RCV_HEADERS_INTERFACE.
1193: -- p_wc_stage IN VARCHAR2 Required

Line 1192: -- the table RCV_HEADERS_INTERFACE.

1188: -- corresponds to the column SHIPMENT_NUM in
1189: -- the table RCV_HEADERS_INTERFACE.
1190: --IN : p_wc_id IN NUMBER Required
1191: -- corresponds to the column HEADER_INTERFACE_ID in
1192: -- the table RCV_HEADERS_INTERFACE.
1193: -- p_wc_stage IN VARCHAR2 Required
1194: -- indicates if the information in the INTERFACE tables.
1195: -- or the SHIPMENT tables
1196: -- p_po_header_id IN NUMBER Required

Line 1262: UPDATE RCV_HEADERS_INTERFACE

1258: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1259: WHERE HEADER_INTERFACE_ID = p_wc_id;
1260:
1261:
1262: UPDATE RCV_HEADERS_INTERFACE
1263: SET PROCESSING_STATUS_CODE = 'CANCELLED'
1264: WHERE HEADER_INTERFACE_ID = p_wc_id;
1265:
1266:

Line 1754: -- the table RCV_HEADERS_INTERFACE.

1750: --Function : Delete a WC
1751: --Parameter :
1752: --IN : p_wc_id IN NUMBER Required
1753: -- corresponds to the column HEADER_INTERFACE_ID in
1754: -- the table RCV_HEADERS_INTERFACE.
1755: --OUT : x_return_status OUT VARCHAR2
1756: -- return status of the procedure.
1757: -- x_return_msg OUT VARCHAR2
1758: -- return message of the procedure.

Line 1779: FROM RCV_HEADERS_INTERFACE

1775:
1776: CURSOR l_header_interface_csr
1777: IS
1778: SELECT HEADER_INTERFACE_ID
1779: FROM RCV_HEADERS_INTERFACE
1780: WHERE HEADER_INTERFACE_ID = p_wc_id;
1781:
1782:
1783: --Before removing the WC from the interface tables,

Line 1838: DELETE FROM RCV_HEADERS_INTERFACE

1834: END LOOP;
1835: CLOSE l_header_interface_csr;
1836:
1837: -- Delete records in header interface table.
1838: DELETE FROM RCV_HEADERS_INTERFACE
1839: WHERE header_interface_id = l_header_interface_id;
1840:
1841: COMMIT;
1842: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1862: -- the table RCV_HEADERS_INTERFACE.

1858: -- a WC yet.
1859: --Parameter :
1860: --IN : p_wc_id IN NUMBER Required
1861: -- corresponds to the column HEADER_INTERFACE_ID in
1862: -- the table RCV_HEADERS_INTERFACE.
1863: --OUT : x_approvers OUT PO_TBL_VARCHAR2000
1864: -- return all "future" approvers
1865: -- x_return_status OUT VARCHAR2
1866: -- return status of the procedure.