APPS.AHL_OSP_RCV_PVT dependencies on DUAL

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 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 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

Line 1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;

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
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;

Line 1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;

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
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;

Line 1921: SELECT FND_GLOBAL.USER_ID INTO l_user_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
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

Line 1922: SELECT FND_GLOBAL.LOGIN_ID INTO l_login_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
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

Line 1923: SELECT FND_GLOBAL.EMPLOYEE_ID INTO l_employee_id from sys.dual;

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