1 package BEN_DM_GEN_DOWNLOAD as
2 /* $Header: benfdmgndn.pkh 120.0 2006/05/04 04:49:09 nkkrishn 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 type t_ben_dm_table is Record
26 (TABLE_ID NUMBER(15)
27 ,TABLE_NAME VARCHAR2(30)
28 ,UPLOAD_TABLE_NAME VARCHAR2(30)
29 ,TABLE_ALIAS VARCHAR2(4)
30 ,DATETRACK VARCHAR2(1)
31 ,DERIVE_SQL VARCHAR2(4000)
32 ,SURROGATE_PK_COLUMN_NAME VARCHAR2(30)
33 ,SHORT_NAME VARCHAR2(23)
34 ,LAST_GENERATED_DATE DATE
35 ,GENERATOR_VERSION VARCHAR2(2000)
36 ,SEQUENCE_NAME VARCHAR2(30)
37 ,LAST_UPDATE_DATE DATE
38 ) ;
39
40
41
42
43 function indent
44 (
45 p_indent_spaces in number default 0,
46 p_newline in varchar2 default 'Y'
47 ) return varchar2 ;
48
49
50
51 function format_comment
52 (
53 p_comment_text in varchar2,
54 p_indent_spaces in number default 0,
55 p_ins_blank_lines in varchar2 default 'Y'
56 ) return varchar2 ;
57
58
59
60 procedure main
61 (
62 --p_business_group_id in number,
63 --p_person_id in number,
64 --p_group_order in number,
65 --p_business_group_name in varchar2,
66 p_table_alias in varchar2,
67 p_migration_id in number
68 );
69
70 end BEN_DM_GEN_DOWNLOAD;