APPS.AHL_OSP_RCV_PVT dependencies on RCV_INTERFACE_GROUPS_S

Line 1031: PO.RCV_INTERFACE_GROUPS_S.NEXTVAL,

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',
1035: SYSDATE,

Line 1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,

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,
1089: SYSDATE,

Line 1132: -- Get the current value of the sequence PO.RCV_INTERFACE_GROUPS_S, required for submitting the request.

1128: FND_LOG.string(FND_LOG.level_statement, l_debug_key,
1129: 'Submitting the request for calling the Concurrent Program RVCTP.');
1130: END IF;
1131:
1132: -- Get the current value of the sequence PO.RCV_INTERFACE_GROUPS_S, required for submitting the request.
1133: SELECT PO.RCV_INTERFACE_GROUPS_S.CURRVAL INTO l_temp FROM DUAL;
1134:
1135: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
1136: application => 'PO',

Line 1133: SELECT PO.RCV_INTERFACE_GROUPS_S.CURRVAL INTO l_temp FROM DUAL;

1129: 'Submitting the request for calling the Concurrent Program RVCTP.');
1130: END IF;
1131:
1132: -- Get the current value of the sequence PO.RCV_INTERFACE_GROUPS_S, required for submitting the request.
1133: SELECT PO.RCV_INTERFACE_GROUPS_S.CURRVAL INTO l_temp FROM DUAL;
1134:
1135: l_req_id := FND_REQUEST.SUBMIT_REQUEST(
1136: application => 'PO',
1137: program => 'RVCTP',

Line 1916: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;

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:
1920: --select the user related ids