APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_API_MODULES

Line 262: FROM hr_api_modules api,

258: AND mapped_to_name = p_mapped_name;
259:
260: CURSOR csr_api_file IS
261: SELECT des.descriptor
262: FROM hr_api_modules api,
263: hr_du_descriptors des,
264: hr_du_upload_headers head
265: WHERE api.api_module_id = l_parent_api_module_id
266: AND head.upload_header_id = p_upload_header_id

Line 552: -- HR_API_MODULES table, to a string of the PL/SQL row id's. Which in turn

548:
549: -- ----------------------- API_MODULE_ID_TO_TABLE_ID ----------------------
550: -- Description: Works through the column R_REF_COL_APIS in the PL/SQL
551: -- table changing the string of the actual api module id's from the
552: -- HR_API_MODULES table, to a string of the PL/SQL row id's. Which in turn
553: -- relate to the same API.
554: -- ------------------------------------------------------------------------
555: PROCEDURE API_MODULE_ID_TO_TABLE_ID IS
556:

Line 641: -- HR_API_MODULES

637: -- field mapped_to_name.
638: --
639: -- Input Parameters
640: -- p_api_module_id - Identifies a specific api in the
641: -- HR_API_MODULES
642: --
643: -- p_reference_string - String which holds the value to be compared
644: -- to the column mapped_to_name within the
645: -- HR_DU_COLUMN_MAPPINGS table

Line 858: -- p_api_module_id - API Module id relating to HR_API_MODULES

854: --
855: -- p_pval_field - The name of which column the information
856: -- should be in.
857: --
858: -- p_api_module_id - API Module id relating to HR_API_MODULES
859: --
860: -- p_mapping_type - The output target i.e. 'D' (datapump) or
861: -- 'R' (referencing)
862: --

Line 966: -- API Module id's from HR_API_MODULES table. The id's are ordered by

962:
963:
964: -- ------------------------- INSERT_API_MODULE_IDS -------------------------
965: -- Description: The R_API_ID column of the PL/SQL table is populated with
966: -- API Module id's from HR_API_MODULES table. The id's are ordered by
967: -- PROCESS_ORDER.
968: --
969: -- Input Parameters
970: --

Line 983: hr_api_modules api

979: SELECT api.api_module_id, des2.upload_header_id
980: FROM hr_du_descriptors des1,
981: hr_du_descriptors des2,
982: hr_du_descriptors des3,
983: hr_api_modules api
984: WHERE des1.upload_id = p_upload_id
985: and upper(des1.descriptor) = 'API'
986: and des1.descriptor_type = 'D'
987: and des1.value IS NOT null

Line 1124: FROM hr_api_modules api,

1120: WHERE upload_line_id = l_line_id;
1121:
1122: CURSOR csr_api_file IS
1123: SELECT des.value
1124: FROM hr_api_modules api,
1125: hr_du_descriptors des,
1126: hr_du_upload_headers head
1127: WHERE api.api_module_id = p_api_module_id
1128: AND head.upload_header_id = p_upload_header_id