APPS.HRDU_DO_API_TRANSLATE dependencies on HR_DU_COLUMN_MAPPINGS

Line 6: -- This procedure inserts a record into the hr_du_column_mappings table.

2: /* $Header: perduapi.pkb 120.0 2005/05/31 17:19:43 appldev noship $ */
3:
4: -- ------------------------ hrdu_insert_mapping ---------------------------
5: -- Description:
6: -- This procedure inserts a record into the hr_du_column_mappings table.
7: -- Most entries are defaulted, and the procedure automatically uses the
8: -- associated sequence. This procedure will be used in a package created
9: -- by hrdu_copy_api.
10: --

Line 63: INSERT INTO hr_du_column_mappings( column_mapping_id, api_module_id, column_name,

59: fetch parent_api_id_csr into l_parent_api_id;
60: close parent_api_id_csr;
61: END IF;
62:
63: INSERT INTO hr_du_column_mappings( column_mapping_id, api_module_id, column_name,
64: mapped_to_name, mapping_type, parent_api_module_id,
65: parent_table, last_update_date, last_updated_by,
66: last_update_login, created_by, creation_date )
67: SELECT hr_du_column_mappings_s.NEXTVAL,

Line 67: SELECT hr_du_column_mappings_s.NEXTVAL,

63: INSERT INTO hr_du_column_mappings( column_mapping_id, api_module_id, column_name,
64: mapped_to_name, mapping_type, parent_api_module_id,
65: parent_table, last_update_date, last_updated_by,
66: last_update_login, created_by, creation_date )
67: SELECT hr_du_column_mappings_s.NEXTVAL,
68: l_api_id,
69: p_column_name,
70: p_mapped_to_name,
71: p_mapping_type,

Line 81: (SELECT NULL FROM hr_du_column_mappings

77: p_created_by,
78: p_creation_date
79: FROM dual
80: WHERE NOT EXISTS
81: (SELECT NULL FROM hr_du_column_mappings
82: WHERE api_module_id = l_api_id
83: AND column_name = p_column_name
84: AND NVL(mapped_to_name,'') = NVL(p_mapped_to_name,'')
85: AND mapping_type = p_mapping_type

Line 232: -- also the associated database table entries are entered into hr_du_column_mappings

228: -- Description:
229: -- This procedure creates a new comma seperated text file for use with the
230: -- HR data uploader. The procedure is passed an API name which it uses to
231: -- create a comma seperated file to be loaded into into the hrdu spreadsheet,
232: -- also the associated database table entries are entered into hr_du_column_mappings
233: --
234: -- Input Parameters
235: -- p_api_name - Database name of the API to find columns for
236: -- p_title_name - Entry to go in the spreadsheet by Title Name