APPS.AHL_OSP_RCV_PVT dependencies on RCV_HEADERS_INTERFACE

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

1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233: CLOSE chk_pending_transaction;
1234:
1235: -- Insert a record in RCV_HEADERS_INTERFACE table as a header of these PO lines.
1236: IF (NOT l_hdr_inserted) THEN
1237: -- Set the l_hdr_inserted flag.
1238: l_hdr_inserted := TRUE;
1239:

Line 1245: INSERT INTO RCV_HEADERS_INTERFACE(

1241: OPEN get_ship_to_org_id(l_po_line_id);
1242: FETCH get_ship_to_org_id INTO l_ship_to_org_id;
1243: CLOSE get_ship_to_org_id;
1244:
1245: INSERT INTO RCV_HEADERS_INTERFACE(
1246: HEADER_INTERFACE_ID,
1247: GROUP_ID,
1248: PROCESSING_STATUS_CODE,
1249: RECEIPT_SOURCE_CODE,

Line 1260: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,

1256: VENDOR_ID,
1257: VENDOR_SITE_ID,
1258: SHIP_TO_ORGANIZATION_ID
1259: ) VALUES (
1260: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,
1261: PO.RCV_INTERFACE_GROUPS_S.NEXTVAL,
1262: 'PENDING',
1263: 'VENDOR',
1264: 'NEW',

Line 1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,

1310: PO_LINE_ID,
1311: SHIP_TO_LOCATION_ID
1312: ) VALUES (
1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1315: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,
1318: FND_GLOBAL.LOGIN_ID,

Line 2183: DELETE FROM RCV_HEADERS_INTERFACE

2179:
2180: DELETE FROM RCV_TRANSACTIONS_INTERFACE
2181: WHERE INTERFACE_TRANSACTION_ID = l_err_intf_trans_id;
2182:
2183: DELETE FROM RCV_HEADERS_INTERFACE
2184: WHERE HEADER_INTERFACE_ID = l_err_intf_hdr_id;
2185:
2186: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2187: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_debug_key, 'Deleted the pending transactions');

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

2188: END IF;
2189: END IF;
2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:

Line 2202: --Insert values into the RCV_HEADERS_INTERFACE

2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;
2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE
2204: (
2205: HEADER_INTERFACE_ID,
2206: GROUP_ID,

Line 2203: INSERT INTO RCV_HEADERS_INTERFACE

2199: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_id from sys.dual;
2200: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;
2201:
2202: --Insert values into the RCV_HEADERS_INTERFACE
2203: INSERT INTO RCV_HEADERS_INTERFACE
2204: (
2205: HEADER_INTERFACE_ID,
2206: GROUP_ID,
2207: PROCESSING_STATUS_CODE,