APPS.AHL_OSP_RCV_PVT dependencies on RCV_HEADERS_INTERFACE

Line 1005: -- Insert a record in RCV_HEADERS_INTERFACE table as a header of these PO lines.

1001: RAISE FND_API.G_EXC_ERROR;
1002: END IF;
1003: CLOSE chk_pending_transaction;
1004:
1005: -- Insert a record in RCV_HEADERS_INTERFACE table as a header of these PO lines.
1006: IF (NOT l_hdr_inserted) THEN
1007: -- Set the l_hdr_inserted flag.
1008: l_hdr_inserted := TRUE;
1009:

Line 1015: INSERT INTO RCV_HEADERS_INTERFACE(

1011: OPEN get_ship_to_org_id(l_po_line_id);
1012: FETCH get_ship_to_org_id INTO l_ship_to_org_id;
1013: CLOSE get_ship_to_org_id;
1014:
1015: INSERT INTO RCV_HEADERS_INTERFACE(
1016: HEADER_INTERFACE_ID,
1017: GROUP_ID,
1018: PROCESSING_STATUS_CODE,
1019: RECEIPT_SOURCE_CODE,

Line 1030: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,

1026: VENDOR_ID,
1027: VENDOR_SITE_ID,
1028: SHIP_TO_ORGANIZATION_ID
1029: ) VALUES (
1030: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,
1031: PO.RCV_INTERFACE_GROUPS_S.NEXTVAL,
1032: 'PENDING',
1033: 'VENDOR',
1034: 'NEW',

Line 1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,

1080: PO_LINE_ID,
1081: SHIP_TO_LOCATION_ID
1082: ) VALUES (
1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,
1088: FND_GLOBAL.LOGIN_ID,

Line 1906: DELETE FROM RCV_HEADERS_INTERFACE

1902:
1903: DELETE FROM RCV_TRANSACTIONS_INTERFACE
1904: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;
1905:
1906: DELETE FROM RCV_HEADERS_INTERFACE
1907: WHERE HEADER_INTERFACE_ID = l_err_intf_hdr_id;
1908:
1909: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1910: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Deleted the pending transactions');

Line 1915: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

1911: END IF;
1912: END IF;
1913:
1914: --Initialize the sequences that are to be used.
1915: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1916: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
1919:

Line 1925: --Insert values into the RCV_HEADERS_INTERFACE

1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
1924:
1925: --Insert values into the RCV_HEADERS_INTERFACE
1926: INSERT INTO RCV_HEADERS_INTERFACE
1927: (
1928: HEADER_INTERFACE_ID,
1929: GROUP_ID,

Line 1926: INSERT INTO RCV_HEADERS_INTERFACE

1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
1924:
1925: --Insert values into the RCV_HEADERS_INTERFACE
1926: INSERT INTO RCV_HEADERS_INTERFACE
1927: (
1928: HEADER_INTERFACE_ID,
1929: GROUP_ID,
1930: PROCESSING_STATUS_CODE,