1 PACKAGE HRDU_DO_API_TRANSLATE AUTHID CURRENT_USER AS
2 /* $Header: perduapi.pkh 120.0 2005/05/31 17:20:07 appldev noship $ */
3
4 -- ---------------------------- hrdu_copy_api -------------------------------
5 -- Description:
6 -- This procedure creates a new comma seperated text file for use with the
7 -- HR data uploader. The procedure is passed an API name which it uses to
8 -- create a comma seperated file to be loaded into into the hrdu spreadsheet,
9 -- also the associated database table entries are entered into hr_du_column_mappings
10 --
11 -- Input Parameters
12 -- p_api_name - Database name of the API to find columns for
13 -- p_title_name - Entry to go in the spreadsheet by Title Name
14 -- p_user_key - Entry to go in the spreadsheet by user key
15 -- p_file_name - Name of the file to output to
16 --
17 -- --------------------------------------------------------------------------
18 PROCEDURE hrdu_copy_api( p_api_name IN Varchar2,
19 p_title_name IN VarChar2,
20 p_user_key IN VarChar2,
21 p_file_name IN VarChar2 );
22
23 -- ------------------------ hrdu_insert_mapping ---------------------------
24 -- Description:
25 -- This procedure inserts a record into the hr_du_column_mappings table.
26 -- Most entries are defaulted, and the procedure automatically uses the
27 -- associated sequence. This procedure will be used in a package created
28 -- by hrdu_copy_api.
29 --
30 -- Input Parameters:
31 -- p_api_module - API module mapping references to
32 -- p_column_name - Column name in spreadsheet
33 -- p_mapped_to_name - Column mapped to
34 -- p_mapping_type - Type of mapping - Default 'D'
35 -- p_parent_api_module - Parent API module - Default Null
36 -- p_parent_table - Parent table - Default Null
37 -- p_last_update_date - Last updated date - Default SysDate
38 -- p_last_updated_by - Last updated by - Default 1
39 -- p_last_update_login - Last update login - Default 1
40 -- p_created_by - Created by - Default 1
41 -- p_creation_date - Creation date - Default SysDate
42 --
43 -- -------------------------------------------------------------------------
44 PROCEDURE hrdu_insert_mapping( p_api_module IN VarChar2,
45 p_column_name IN VarChar2,
46 p_mapped_to_name IN VarChar2,
47 p_mapping_type IN VarChar2 DEFAULT 'D',
48 p_parent_api_module IN VarChar2 DEFAULT NULL,
49 p_parent_table IN VarChar2 DEFAULT NULL,
50 p_last_update_date IN Date DEFAULT SYSDATE,
51 p_last_updated_by IN Number DEFAULT 1,
52 p_last_update_login IN Number DEFAULT 1,
53 p_created_by IN Number DEFAULT 1,
54 p_creation_date IN Date DEFAULT SYSDATE);
55
56 END HRDU_DO_API_TRANSLATE;