APPS.HR_DU_DO_DATAPUMP dependencies on HR_DU_DESCRIPTORS

Line 240: FROM hr_du_descriptors des1,

236:
237:
238: CURSOR csr_process_order IS
239: SELECT des2.value
240: FROM hr_du_descriptors des1,
241: hr_du_descriptors des2,
242: hr_api_modules api
243: WHERE des1.upload_id = p_upload_id
244: and upper(des1.descriptor) = 'API'

Line 241: hr_du_descriptors des2,

237:
238: CURSOR csr_process_order IS
239: SELECT des2.value
240: FROM hr_du_descriptors des1,
241: hr_du_descriptors des2,
242: hr_api_modules api
243: WHERE des1.upload_id = p_upload_id
244: and upper(des1.descriptor) = 'API'
245: and upper(des2.descriptor) = 'PROCESS ORDER'

Line 947: FROM HR_DU_DESCRIPTORS

943: --Retrieve the business group for the appropriate HR_DU_UPLOADS
944: BEGIN
945: SELECT VALUE
946: INTO l_business_group
947: FROM HR_DU_DESCRIPTORS
948: WHERE DESCRIPTOR = 'BUSINESS GROUP'
949: AND upload_id = p_upload_id;
950: EXCEPTION
951: WHEN OTHERS THEN

Line 980: -- the HR_DU_DESCRIPTORS table. It is the exact string that was found in

976:
977:
978: -- ------------------------ EXTRACT_USER_KEY ------------------------------
979: -- Description: This function removes the user_key that is stored within
980: -- the HR_DU_DESCRIPTORS table. It is the exact string that was found in
981: -- the flat file in the descriptor block.
982: --
983: -- Input Parameters
984: -- p_upload_id - The upload id to associate the procedure with

Line 996: FROM HR_DU_DESCRIPTORS descr,

992: RETURN VARCHAR2 IS
993:
994: CURSOR csr_user_key IS
995: SELECT descr.VALUE
996: FROM HR_DU_DESCRIPTORS descr,
997: HR_DU_UPLOAD_HEADERS head
998: WHERE head.upload_id = p_upload_id
999: AND head.api_module_id = g_values_table(p_table_id).r_api_id
1000: AND head.upload_header_id = descr.upload_header_id

Line 1079: FROM hr_du_descriptors des,

1075: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS
1076: --in the main header for all API's
1077: CURSOR csr_dollar_key IS
1078: SELECT des.VALUE
1079: FROM hr_du_descriptors des,
1080: hr_du_uploads uplo
1081: WHERE uplo.upload_id = p_upload_id
1082: AND uplo.upload_id = des.upload_id
1083: AND des.upload_header_id IS NULL

Line 1090: FROM hr_du_descriptors des,

1086: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS
1087: --in the specific API header
1088: CURSOR csr_dollar_key_api IS
1089: SELECT des.VALUE
1090: FROM hr_du_descriptors des,
1091: hr_du_upload_headers head
1092: WHERE head.api_module_id = l_api_id
1093: AND head.upload_id = p_upload_id
1094: AND head.upload_header_id = des.upload_header_id

Line 1100: FROM hr_du_descriptors

1096:
1097: --Extracts the referencing type to checks for PC referencing
1098: CURSOR csr_referencing IS
1099: SELECT VALUE
1100: FROM hr_du_descriptors
1101: WHERE upload_header_id = l_upload_header_id
1102: AND upper(descriptor) = 'REFERENCING';
1103:
1104: --Extracts the referencing type to checks for a Starting point

Line 1107: FROM hr_du_descriptors

1103:
1104: --Extracts the referencing type to checks for a Starting point
1105: CURSOR csr_starting_point IS
1106: SELECT VALUE
1107: FROM hr_du_descriptors
1108: WHERE upload_header_id = l_upload_header_id
1109: AND upper(descriptor) = 'STARTING POINT';
1110:
1111:

Line 1417: FROM hr_du_descriptors des2,

1413: IS
1414:
1415: CURSOR csr_apis IS
1416: SELECT api.api_module_id, des1.upload_header_id
1417: FROM hr_du_descriptors des2,
1418: hr_api_modules api,
1419: hr_du_descriptors des1
1420: WHERE des2.upload_id = p_upload_id
1421: AND upper(des2.descriptor) = 'PROCESS ORDER'

Line 1419: hr_du_descriptors des1

1415: CURSOR csr_apis IS
1416: SELECT api.api_module_id, des1.upload_header_id
1417: FROM hr_du_descriptors des2,
1418: hr_api_modules api,
1419: hr_du_descriptors des1
1420: WHERE des2.upload_id = p_upload_id
1421: AND upper(des2.descriptor) = 'PROCESS ORDER'
1422: AND des2.DESCRIPTOR_TYPE = 'D'
1423: AND upper(api.module_name) = upper(des1.VALUE)

Line 1924: FROM hr_du_descriptors

1920:
1921: --This cursor extracts the batch name from the descriptors table
1922: CURSOR csr_batch_name IS
1923: SELECT VALUE
1924: FROM hr_du_descriptors
1925: WHERE upper(DESCRIPTOR) = 'BATCH NAME'
1926: AND UPLOAD_ID = p_upload_id;
1927:
1928: --Returns the upload line and header to be placed in Pump lines