eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DM_GEN_TDS dependencies on HR_DM_LIBRARY

Line 10: g_columns_tbl hr_dm_library.t_varchar2_tbl;

6: type t_varchar2_32k_tbl is table of varchar2(32767) index by binary_integer;
7:
8:
9: g_table_info hr_dm_gen_main.t_table_info;
10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;

Line 11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;

7:
8:
9: g_table_info hr_dm_gen_main.t_table_info;
10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
15: g_surrogate_pk_col_param varchar2(30);

Line 12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;

8:
9: g_table_info hr_dm_gen_main.t_table_info;
10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
15: g_surrogate_pk_col_param varchar2(30);
16:

Line 13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;

9: g_table_info hr_dm_gen_main.t_table_info;
10: g_columns_tbl hr_dm_library.t_varchar2_tbl;
11: g_parameters_tbl hr_dm_library.t_varchar2_tbl;
12: g_hier_columns_tbl hr_dm_library.t_varchar2_tbl;
13: g_hier_parameters_tbl hr_dm_library.t_varchar2_tbl;
14: g_resolve_pk_columns_tbl hr_dm_gen_main.t_fk_to_aol_columns_tbl;
15: g_surrogate_pk_col_param varchar2(30);
16:
17: -- to store the package body in to array so as to overcome the limit of 32767

Line 46: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,

42: ) return varchar2 is
43: l_spaces varchar2(100);
44: begin
45:
46: l_spaces := hr_dm_library.indent(p_indent_spaces => p_indent_spaces,
47: p_newline => p_newline);
48: return l_spaces;
49: exception
50: when others then

Line 503: hr_dm_library.get_table_info (cst_get_table_rec.parent_table_id,

499: -- has to be derived from table hierarchy i.e parent tables.
500: if p_table_info.table_hierarchy = 'Y' and p_table_info.global_data = 'N' then
501: for cst_get_table_rec in csr_get_table loop
502: -- get the parent table name
503: hr_dm_library.get_table_info (cst_get_table_rec.parent_table_id,
504: l_parent_table_info);
505: p_from_clause := p_from_clause || indent(p_lpad_spaces + 5) || ',' ||
506: l_parent_table_info.table_name ||' ' || l_parent_table_info.alias;
507: end loop;

Line 1153: l_columns_tbl hr_dm_library.t_varchar2_tbl;

1149: l_cursor_defination varchar2(2000);
1150: l_cursor_select_cols varchar2(32767);
1151: l_cursor_select_from varchar2(32767);
1152: l_cursor_select_where varchar2(32767);
1153: l_columns_tbl hr_dm_library.t_varchar2_tbl;
1154: l_prefix_col varchar2(30);
1155:
1156: begin
1157:

Line 1206: l_cursor_select_cols := hr_dm_library.conv_list_to_text( p_rpad_spaces => 8,

1202: -- of the table separated by comma's.
1203:
1204:
1205:
1206: l_cursor_select_cols := hr_dm_library.conv_list_to_text( p_rpad_spaces => 8,
1207: p_columns_tbl => l_columns_tbl,
1208: p_prefix_col => l_prefix_col);
1209:
1210: -- Key combination tables have foreign key on AOL table

Line 1776: l_columns_tbl hr_dm_library.t_varchar2_tbl;

1772: -- indentation for the statements.it specifies number of blank spaces
1773: -- after which the staement should start.
1774:
1775: l_indent number;
1776: l_columns_tbl hr_dm_library.t_varchar2_tbl;
1777:
1778: l_proc_body_tbl t_varchar2_32k_tbl;
1779: l_proc_index number := 1;
1780:

Line 2013: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg (

2009: -- if the columns of the table have foreign key to AOL table then call
2010: -- call assignment function which replaces those columns with developer key.
2011: if p_table_info.fk_to_aol_table = 'N' then
2012:
2013: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg (
2014: p_rpad_spaces => l_indent +1,
2015: p_columns_tbl => l_columns_tbl,
2016: p_prefix_left_asg => 'p_',
2017: p_prefix_right_asg => 'l_table_rec.',

Line 2020: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg_with_dev_key (

2016: p_prefix_left_asg => 'p_',
2017: p_prefix_right_asg => 'l_table_rec.',
2018: p_right_asg_pad_len => 55);
2019: else
2020: l_proc_body_tbl(l_proc_index) := hr_dm_library.get_func_asg_with_dev_key (
2021: p_rpad_spaces => l_indent +1,
2022: p_columns_tbl => l_columns_tbl,
2023: p_prefix_left_asg => 'p_',
2024: p_prefix_right_asg => 'l_table_rec.',

Line 2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,

2803: -- ------------------------------------------------------------------------
2804: procedure create_tds_pacakge
2805: (
2806: p_table_info in hr_dm_gen_main.t_table_info,
2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl

Line 2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,

2804: procedure create_tds_pacakge
2805: (
2806: p_table_info in hr_dm_gen_main.t_table_info,
2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2812: )

Line 2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,

2805: (
2806: p_table_info in hr_dm_gen_main.t_table_info,
2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2812: )
2813: is

Line 2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,

2806: p_table_info in hr_dm_gen_main.t_table_info,
2807: p_columns_tbl in hr_dm_library.t_varchar2_tbl,
2808: p_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2809: p_aol_columns_tbl in hr_dm_library.t_varchar2_tbl,
2810: p_aol_parameters_tbl in hr_dm_library.t_varchar2_tbl,
2811: p_fk_to_aol_columns_tbl in hr_dm_gen_main.t_fk_to_aol_columns_tbl
2812: )
2813: is
2814: l_header varchar2(32767);

Line 2843: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,

2839: -- Get the version of the generator to be appended to the TDS package
2840: -- generated for a table. This will help in finding out which version
2841: -- of Generator is used to generate the TDS package.
2842:
2843: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,
2844: p_format_output => 'Y');
2845:
2846: -- Get the package version of this TDS package body.
2847: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TDS',

Line 2847: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TDS',

2843: hr_dm_library.get_generator_version(p_generator_version => l_generator_version,
2844: p_format_output => 'Y');
2845:
2846: -- Get the package version of this TDS package body.
2847: hr_dm_library.get_package_version ( p_package_name => 'HR_DM_GEN_TDS',
2848: p_package_version => l_package_version,
2849: p_version_type => 'FULL');
2850:
2851:

Line 2858: hr_dm_library.populate_hierarchy_cols_list

2854:
2855: if p_table_info.column_hierarchy = 'Y' then
2856: -- get the columns and parameter list. store in pl/sql table.
2857:
2858: hr_dm_library.populate_hierarchy_cols_list
2859: (p_table_info => p_table_info,
2860: p_hier_columns_tbl => g_hier_columns_tbl,
2861: p_hier_parameter_tbl => g_hier_parameters_tbl,
2862: p_called_from => 'TDS' );

Line 3000: hr_dm_library.run_sql( l_header );

2996: --
2997: -- Compile the header and body.
2998: --
2999:
3000: hr_dm_library.run_sql( l_header );
3001: hr_dm_library.run_sql( g_package_body,
3002: g_package_index);
3003:
3004:

Line 3001: hr_dm_library.run_sql( g_package_body,

2997: -- Compile the header and body.
2998: --
2999:
3000: hr_dm_library.run_sql( l_header );
3001: hr_dm_library.run_sql( g_package_body,
3002: g_package_index);
3003:
3004:
3005: -- check the status of the package

Line 3010: hr_dm_library.check_compile (p_object_name => l_package_name,

3006:
3007:
3008: -- check the status of the package
3009: begin
3010: hr_dm_library.check_compile (p_object_name => l_package_name,
3011: p_object_type => 'PACKAGE BODY' );
3012: exception
3013: when others then
3014: hr_dm_utility.error(SQLCODE,'Error in compiling TDS for ' ||