APPS.HR_DU_DP_PC_CONVERSION dependencies on HR_DU_COLUMN_MAPPINGS

Line 31: FROM hr_du_column_mappings

27: l_counter NUMBER := 1 ;
28:
29: CURSOR csr_mapped_to_name IS
30: SELECT mapping_type, mapped_to_name, column_name
31: FROM hr_du_column_mappings
32: WHERE api_module_id = p_api_module_id;
33:
34: BEGIN
35: --

Line 256: FROM hr_du_column_mappings

252: l_fatal_error_message VARCHAR2(2000);
253:
254: CURSOR csr_api_id IS
255: SELECT parent_api_module_id
256: FROM hr_du_column_mappings
257: WHERE api_module_id = p_api_module_id
258: AND mapped_to_name = p_mapped_name;
259:
260: CURSOR csr_api_file IS

Line 438: FROM hr_du_column_mappings

434: --calling api_modules id (parent's id) in that column.
435:
436: CURSOR csr_parent_api_module_id IS
437: SELECT parent_api_module_id
438: FROM hr_du_column_mappings
439: WHERE mapping_type = 'D'
440: AND parent_api_module_id IS NOT null
441: AND column_name = l_pval_field;
442:

Line 449: FROM hr_du_column_mappings

445: --to store the api module id and the line id.
446:
447: CURSOR csr_parent_table_column IS
448: SELECT parent_table
449: FROM hr_du_column_mappings
450: WHERE mapping_type = 'D'
451: AND parent_table is not null
452: AND column_name = l_pval_field;
453:

Line 635: -- Description: Returns the parent_api_module_id from HR_DU_COLUMN_MAPPINGS

631: END API_MODULE_ID_TO_TABLE_ID;
632:
633:
634: -- --------------------- RETURN_PARENT_API_MODULE_ID ----------------------
635: -- Description: Returns the parent_api_module_id from HR_DU_COLUMN_MAPPINGS
636: -- where the p_reference_string matches an entry in HR_DU_COLUMN_MAPPINGS
637: -- field mapped_to_name.
638: --
639: -- Input Parameters

Line 636: -- where the p_reference_string matches an entry in HR_DU_COLUMN_MAPPINGS

632:
633:
634: -- --------------------- RETURN_PARENT_API_MODULE_ID ----------------------
635: -- Description: Returns the parent_api_module_id from HR_DU_COLUMN_MAPPINGS
636: -- where the p_reference_string matches an entry in HR_DU_COLUMN_MAPPINGS
637: -- field mapped_to_name.
638: --
639: -- Input Parameters
640: -- p_api_module_id - Identifies a specific api in the

Line 645: -- HR_DU_COLUMN_MAPPINGS table

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
646: -- Output Parameters
647: --
648: -- l_parent_api_module_id - Parent_api_module_id from the
649: -- HR_DU_COLUMN_MAPPINGS table if match found

Line 649: -- HR_DU_COLUMN_MAPPINGS table if match found

645: -- HR_DU_COLUMN_MAPPINGS table
646: -- Output Parameters
647: --
648: -- l_parent_api_module_id - Parent_api_module_id from the
649: -- HR_DU_COLUMN_MAPPINGS table if match found
650: --
651: -- ------------------------------------------------------------------------
652: FUNCTION RETURN_PARENT_API_MODULE_ID (p_api_module_id IN NUMBER,
653: p_reference_string IN VARCHAR2) RETURN NUMBER

Line 662: FROM hr_du_column_mappings

658: l_parent_api_module_id NUMBER;
659:
660: CURSOR csr_parent_id IS
661: SELECT parent_api_module_id
662: FROM hr_du_column_mappings
663: WHERE api_module_id = p_api_module_id
664: AND mapped_to_name = p_reference_string;
665:
666:

Line 866: -- HR_DU_COLUMN_MAPPINGS if a match is found.

862: --
863: -- Output Parameters
864: --
865: -- l_mapped_name - The name of the field MAPPED_TO_NAME in
866: -- HR_DU_COLUMN_MAPPINGS if a match is found.
867: -- ------------------------------------------------------------------------
868: FUNCTION GENERAL_REFERENCING_COLUMN(p_pval_field IN VARCHAR2,
869: p_api_module_id IN NUMBER,
870: p_mapping_type IN VARCHAR2)

Line 878: FROM hr_du_column_mappings

874: l_mapped_name VARCHAR2(30);
875:
876: CURSOR csr_ref_col IS
877: SELECT mapped_to_name
878: FROM hr_du_column_mappings
879: WHERE api_module_id = p_api_module_id
880: AND mapping_type = p_mapping_type
881: AND upper(column_name) = upper(p_pval_field);
882:

Line 932: -- HR_DU_COLUMN_MAPPINGS if a match is found.

928: --
929: -- Output Parameters
930: --
931: -- l_mapped_name - The name of the field MAPPED_TO_NAME in
932: -- HR_DU_COLUMN_MAPPINGS if a match is found.
933: -- ------------------------------------------------------------------------
934: FUNCTION GENERAL_REFERENCING_COLUMN_2(p_pval_field IN VARCHAR2,
935: p_mapping_type IN VARCHAR2) RETURN VARCHAR2
936: IS

Line 1215: --HR_DU_COLUMN_MAPPINGS

1211: ELSIF l_pval_field IS NULL THEN
1212: exit;
1213: ELSE
1214: --deals with column names that don't match any data within
1215: --HR_DU_COLUMN_MAPPINGS
1216: --the line number of the HR_DU_UPLOAD_LINE relating to the position
1217: --it was in within the spreadsheet is extracted
1218: OPEN csr_DI_LINE_NUMBER;
1219: FETCH csr_DI_LINE_NUMBER INTO l_di_line_number;