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_MAIN dependencies on HR_DM_LIBRARY

Line 446: l_columns_tbl hr_dm_library.t_varchar2_tbl;

442: -- stores table properties or info and is passed to the TDS/TUPS generator.
443: l_table_info t_table_info;
444:
445: -- stores columns and column data info.
446: l_columns_tbl hr_dm_library.t_varchar2_tbl;
447: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
448:
449: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;

Line 447: l_parameters_tbl hr_dm_library.t_varchar2_tbl;

443: l_table_info t_table_info;
444:
445: -- stores columns and column data info.
446: l_columns_tbl hr_dm_library.t_varchar2_tbl;
447: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
448:
449: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
451:

Line 449: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;

445: -- stores columns and column data info.
446: l_columns_tbl hr_dm_library.t_varchar2_tbl;
447: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
448:
449: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
451:
452: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
453: l_phase_item_id hr_dm_phase_items.phase_item_id%type;

Line 450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;

446: l_columns_tbl hr_dm_library.t_varchar2_tbl;
447: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
448:
449: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
450: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
451:
452: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
453: l_phase_item_id hr_dm_phase_items.phase_item_id%type;
454: l_phase_id hr_dm_phases.phase_id%type;

Line 712: hr_dm_library.populate_fk_to_aol_cols_info

708: -- if one or more columns has a foreign key to the AOL table then store the
709: -- information about the column and corresponding AOL table e.t.c for each
710: -- column.
711: if l_table_info.fk_to_aol_table = 'Y' then
712: hr_dm_library.populate_fk_to_aol_cols_info
713: ( p_table_info => l_table_info,
714: p_fk_to_aol_columns_tbl => l_fk_to_aol_columns_tbl);
715: end if;
716:

Line 718: hr_dm_library.populate_columns_list(l_table_info,

714: p_fk_to_aol_columns_tbl => l_fk_to_aol_columns_tbl);
715: end if;
716:
717: -- get the columns and parameter list. store in pl/sql table.
718: hr_dm_library.populate_columns_list(l_table_info,
719: l_fk_to_aol_columns_tbl,
720: l_columns_tbl,
721: l_parameters_tbl,
722: l_aol_columns_tbl,

Line 798: hr_dm_library.get_generator_version(l_generator_version);

794:
795: l_count := l_count + 1;
796:
797: -- get generator version used to generated this TUPS/TDS
798: hr_dm_library.get_generator_version(l_generator_version);
799:
800: --
801: -- update the last generated date for TUP/TDS for this table in hr_dm_tables
802: --

Line 898: l_columns_tbl hr_dm_library.t_varchar2_tbl;

894: -- stores table properties or info and is passed to the TDS/TUPS generator.
895: l_table_info t_table_info;
896:
897: -- stores columns and column data info.
898: l_columns_tbl hr_dm_library.t_varchar2_tbl;
899: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
900:
901: l_generator_version hr_dm_tables.generator_version%type;
902:

Line 899: l_parameters_tbl hr_dm_library.t_varchar2_tbl;

895: l_table_info t_table_info;
896:
897: -- stores columns and column data info.
898: l_columns_tbl hr_dm_library.t_varchar2_tbl;
899: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
900:
901: l_generator_version hr_dm_tables.generator_version%type;
902:
903: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;

Line 903: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;

899: l_parameters_tbl hr_dm_library.t_varchar2_tbl;
900:
901: l_generator_version hr_dm_tables.generator_version%type;
902:
903: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
904: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
905:
906: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
907: l_phase_item_id hr_dm_phase_items.phase_item_id%type;

Line 904: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;

900:
901: l_generator_version hr_dm_tables.generator_version%type;
902:
903: l_aol_columns_tbl hr_dm_library.t_varchar2_tbl;
904: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
905:
906: l_fk_to_aol_columns_tbl t_fk_to_aol_columns_tbl;
907: l_phase_item_id hr_dm_phase_items.phase_item_id%type;
908: l_phase_id hr_dm_phases.phase_id%type;

Line 1238: hr_dm_library.populate_fk_to_aol_cols_info

1234: -- if one or more columns has a foreign key to the AOL table then store the
1235: -- information about the column and corresponding AOL table e.t.c for each
1236: -- column.
1237: if l_table_info.fk_to_aol_table = 'Y' then
1238: hr_dm_library.populate_fk_to_aol_cols_info
1239: ( p_table_info => l_table_info,
1240: p_fk_to_aol_columns_tbl => l_fk_to_aol_columns_tbl);
1241:
1242: -- if the error below is raised we need to make modifications to

Line 1259: hr_dm_library.populate_columns_list(l_table_info,

1255:
1256: end if;
1257:
1258: -- get the columns and parameter list. store in pl/sql table.
1259: hr_dm_library.populate_columns_list(l_table_info,
1260: l_fk_to_aol_columns_tbl,
1261: l_columns_tbl,
1262: l_parameters_tbl,
1263: l_aol_columns_tbl,

Line 1330: hr_dm_library.create_view(l_table_info);

1326:
1327: if l_table_info.upload_table_name <> l_table_info.table_name then
1328: begin
1329:
1330: hr_dm_library.create_view(l_table_info);
1331:
1332: exception
1333: when others then
1334: l_fatal_error_message := 'error in hr_dm_utility.create_view - for ' ||

Line 1385: hr_dm_library.get_generator_version(l_generator_version);

1381:
1382: l_count := l_count + 1;
1383:
1384: -- get generator version used to generated this TUPS/TDS
1385: hr_dm_library.get_generator_version(l_generator_version);
1386: --
1387: -- update the last generated date for TUP/TDS for this table in hr_dm_tables
1388: --
1389: update hr_dm_tables