1 package hr_dm_gen_tds AUTHID CURRENT_USER as
2 /* $Header: perdmgnd.pkh 120.0 2005/05/31 17:08:44 appldev noship $ */
3 -- ------------------------- create_tds_pacakge ------------------------
4 -- Description: Create the TDS package and relevant procedures for the table.
5 -- Input Parameters :
6 -- p_table_info - Information about table for which TDS to be generated. Info
7 -- like Datetrack, Global Data, Surrogate Primary key etc about
8 -- the table is passed as a record type.
9 -- p_columns_tbl - All the columns of the table stored as a list.
10 -- p_parameters_tbl - All the columns of the table stored with data type are
11 -- stored as a list. e.g p_business_group_id number
12 -- This is used to create the procedure parameter list for
13 -- TDS procedure.
14 -- p_aol_columns_tbl - All the columns of the table which have foreign key to
15 -- AOL table are stored as a list.
16 -- p_aol_parameters_tbl - All the columns of the table which have foreign key to
17 -- AOL table are stored with data type as a list. This is
18 -- used as a parameter list for the procedure generated to
19 -- get the AOL developer key for the given ID value
20 -- e.g p_user_id number
21 -- p_fk_to_aol_columns_tbl - It stores the list of all the columns which have
22 -- foreign on AOL table and corresponding name of the AOL
23 -- table.
24 -- ------------------------------------------------------------------------
25 procedure create_tds_pacakge
26 (
27 p_table_info in hr_dm_gen_main.t_table_info,
28 p_columns_tbl in hr_dm_library.t_varchar2_tbl,
29 p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
30 p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
31 p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
32 p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
33 );
34
35 -- ----------------------- get_cursor_from_clause -------------------------
36 -- Description:
37 -- Get the list of all the tables required to get the download from clause.
38 -- if the business group_id field does not exist in the table to be downloaded
39 -- then it is derived from the table hierarchy table.
40 -- ------------------------------------------------------------------------
41 procedure get_cursor_from_clause
42 (
43 p_table_info in hr_dm_gen_main.t_table_info,
44 p_from_clause out nocopy varchar2 ,
45 p_lpad_spaces in number default 2
46 );
47 end hr_dm_gen_tds;
[Home] [Help]