[Home] [Help]
111: hr_dm_utility.message('ROUT','entry:hr_dm_library.get_generator_version'
112: , 5);
113:
114: -- get the version of main generator
115: get_package_version ( p_package_name => 'HR_DM_GEN_MAIN',
116: p_package_version => l_package_version);
117:
118: if p_format_output = 'Y' then
119: l_generator_version := priv_indent || l_package_version;
389: -- ------------------------------------------------------------------------
390: procedure get_table_info
391: (
392: p_table_id in number,
393: p_table_info out nocopy hr_dm_gen_main.t_table_info
394: )
395: is
396:
397: --cursor to get the table_info
477: -- list.
478: -----------------------------------------------------------------------------
479: procedure check_col_for_fk_on_aol
480: (
481: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
482: p_column_name in varchar2,
483: p_index out nocopy number
484: ) is
485: l_index number := p_fk_to_aol_columns_tbl.first;
529: -- 'L' - lookup type hierarchy.
530: ----------------------------------------------------------------------------
531: procedure populate_fk_to_aol_cols_info
532: (
533: p_table_info in hr_dm_gen_main.t_table_info,
534: p_fk_to_aol_columns_tbl out nocopy hr_dm_gen_main.t_fk_to_aol_columns_tbl,
535: p_hierarchy_type in varchar2 default 'A'
536: ) is
537:
530: ----------------------------------------------------------------------------
531: procedure populate_fk_to_aol_cols_info
532: (
533: p_table_info in hr_dm_gen_main.t_table_info,
534: p_fk_to_aol_columns_tbl out nocopy hr_dm_gen_main.t_fk_to_aol_columns_tbl,
535: p_hierarchy_type in varchar2 default 'A'
536: ) is
537:
538: cursor csr_get_fk_to_aol_cols is
622: -- in the procedure.
623: -- ------------------------------------------------------------------------
624: procedure populate_columns_list
625: (
626: p_table_info in hr_dm_gen_main.t_table_info,
627: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
628: p_columns_tbl out nocopy t_varchar2_tbl,
629: p_parameter_tbl out nocopy t_varchar2_tbl,
630: p_aol_columns_tbl out nocopy t_varchar2_tbl,
623: -- ------------------------------------------------------------------------
624: procedure populate_columns_list
625: (
626: p_table_info in hr_dm_gen_main.t_table_info,
627: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
628: p_columns_tbl out nocopy t_varchar2_tbl,
629: p_parameter_tbl out nocopy t_varchar2_tbl,
630: p_aol_columns_tbl out nocopy t_varchar2_tbl,
631: p_aol_parameter_tbl out nocopy t_varchar2_tbl,
777: -- primary key.
778: -- ------------------------------------------------------------------------
779: procedure populate_pk_columns_list
780: (
781: p_table_info in hr_dm_gen_main.t_table_info,
782: p_pk_columns_tbl out nocopy t_varchar2_tbl,
783: p_pk_parameter_tbl out nocopy t_varchar2_tbl,
784: p_no_of_pk_columns out nocopy number
785: )
944: -- generator package.
945: -- ------------------------------------------------------------------------
946: procedure populate_hierarchy_cols_list
947: (
948: p_table_info in hr_dm_gen_main.t_table_info,
949: p_hier_columns_tbl out nocopy t_varchar2_tbl,
950: p_hier_parameter_tbl out nocopy t_varchar2_tbl,
951: p_called_from in varchar2
952: )
1307: p_columns_tbl in t_varchar2_tbl,
1308: p_col_length in number default 30,
1309: p_start_terminator in varchar2 default ',',
1310: p_end_terminator in varchar2 default null,
1311: p_overide_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
1312: p_overide_prefix in varchar2 default null
1313: )
1314: return varchar2 is
1315:
1826: p_left_asg_pad_len in number default 30,
1827: p_right_asg_pad_len in number default 30,
1828: p_start_terminator in varchar2 default ',' ,
1829: p_end_terminator in varchar2 default null,
1830: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
1831: p_test_with_nvl in varchar2 default 'N',
1832: p_table_name in varchar2 default null
1833: )
1834: return varchar2 is
2095: p_pad_first_line in varchar2 default 'Y' ,
2096: p_left_asg_pad_len in number default 30,
2097: p_right_asg_pad_len in number default 30,
2098: p_use_aol_id_col in varchar2,
2099: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
2100: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2101: )
2102: return varchar2 is
2103:
2096: p_left_asg_pad_len in number default 30,
2097: p_right_asg_pad_len in number default 30,
2098: p_use_aol_id_col in varchar2,
2099: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl,
2100: p_resolve_pk_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2101: )
2102: return varchar2 is
2103:
2104: l_out_text varchar2(20000) := null;
2991: --
2992: -- ------------------------------------------------------------------------
2993:
2994: --
2995: procedure create_view (p_table_info in hr_dm_gen_main.t_table_info) is
2996: --
2997:
2998: l_string varchar2(32767);
2999: l_columns1 varchar2(32767);
3009: l_owner varchar2(30);
3010: l_cursor_select_from varchar2(32767);
3011: l_cursor_select_where varchar2(32767);
3012: l_nonnull_table_id number;
3013: l_parent_table_info hr_dm_gen_main.t_table_info;
3014: l_apps_name varchar2(30);
3015:
3016: cursor csr_apps_name is
3017: select ORACLE_USERNAME