APPS.HR_DU_DO_DATAPUMP dependencies on HR_DU_COLUMN_MAPPINGS

Line 179: FROM hr_du_column_mappings

175: l_user_key VARCHAR2(2000);
176:
177: CURSOR csr_user_key IS
178: SELECT mapped_to_name
179: FROM hr_du_column_mappings
180: WHERE API_MODULE_ID = p_api_module_id
181: AND MAPPING_TYPE = 'U';
182:
183: BEGIN

Line 321: FROM hr_du_column_mappings

317: IS
318:
319: CURSOR csr_references IS
320: SELECT mapped_to_name
321: FROM hr_du_column_mappings
322: WHERE api_module_id = p_api_module_id
323: AND mapping_type = 'D'
324: AND column_name = p_user_key;
325:

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

391: --
392: -- Output Parameters
393: --
394: -- l_mapped_name - The name of the field MAPPED_TO_NAME in
395: -- HR_DU_COLUMN_MAPPINGS if a match is found.
396: -- ------------------------------------------------------------------------
397: FUNCTION GENERAL_REFERENCING_COLUMN(p_pval_field IN VARCHAR2,
398: p_api_module_id IN NUMBER,
399: p_mapping_type IN VARCHAR2)

Line 407: FROM hr_du_column_mappings

403: l_mapped_name VARCHAR2(30);
404:
405: CURSOR csr_ref_col IS
406: SELECT mapped_to_name
407: FROM hr_du_column_mappings
408: WHERE api_module_id = p_api_module_id
409: AND mapping_type = p_mapping_type
410: AND column_name = p_pval_field
411: AND PARENT_api_module_ID IS NULL

Line 499: -- p_user_key - Returns the column name from HR_DU_COLUMN_MAPPINGS

495: --
496: -- p_upload_id - Identifies the correct HR_DU_UPLOAD
497: --
498: -- Output Parameters
499: -- p_user_key - Returns the column name from HR_DU_COLUMN_MAPPINGS
500: -- to what the user key is mapped to
501: --
502: -- l_actual_user_key - This is the user key that uniquely identifies a
503: -- record

Line 701: -- p_user_key - Returns the column name from HR_DU_COLUMN_MAPPINGS

697: --
698: -- p_upload_line_id - Identifies the UPLOAD_LINE_ID
699: --
700: -- Output Parameters
701: -- p_user_key - Returns the column name from HR_DU_COLUMN_MAPPINGS
702: -- to what the user key is mapped to
703: --
704: -- l_actual_user_key - This is the user key that uniquely identifies a
705: -- record

Line 1075: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS

1071: l_upload_header_id NUMBER;
1072: l_starting_bool VARCHAR2(50);
1073:
1074:
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,

Line 1086: --Cursor compares the user key word to HR_DU_COLUMN_MAPPINGS

1082: AND uplo.upload_id = des.upload_id
1083: AND des.upload_header_id IS NULL
1084: AND upper(des.descriptor) = upper(l_single_key);
1085:
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,

Line 1153: 'HR_DU_COLUMN_MAPPINGS';

1149: IF l_mapped_name IS NULL THEN
1150: l_fatal_error_message := 'Error occured trying to map part of the '
1151: || 'user key : ' || l_single_key || ' ' ||
1152: 'to a mapped_to_name in ' ||
1153: 'HR_DU_COLUMN_MAPPINGS';
1154: RAISE e_fatal_error;
1155: END IF;
1156:
1157: l_key_pval := RETURN_PVAL(l_mapped_name, l_counter);

Line 1524: FROM hr_du_column_mappings

1520: --calling api_module's id (parent's id) in that column.
1521:
1522: CURSOR csr_parent_api_id IS
1523: SELECT parent_api_module_id
1524: FROM hr_du_column_mappings
1525: WHERE mapping_type = 'D'
1526: AND parent_api_module_id IS NOT null
1527: AND column_name = l_pval_field;
1528:

Line 1535: FROM hr_du_column_mappings

1531: --to store the api_module id and the line id.
1532:
1533: CURSOR csr_parent_table_column IS
1534: SELECT parent_table
1535: FROM hr_du_column_mappings
1536: WHERE mapping_type = 'D'
1537: AND parent_table is not null
1538: AND column_name = l_pval_field;
1539: