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_TABLES

Line 119: hr_dm_tables t

115: cursor csr_get_lr_info (p_table_id number,
116: p_hierarchy_type varchar2) is
117: select 1
118: from hr_dm_hierarchies hir,
119: hr_dm_tables t
120: where hir.table_id = t.table_id
121: and t.table_name = (
122: select nvl(upload_table_name, table_name)
123: from hr_dm_tables

Line 123: from hr_dm_tables

119: hr_dm_tables t
120: where hir.table_id = t.table_id
121: and t.table_name = (
122: select nvl(upload_table_name, table_name)
123: from hr_dm_tables
124: where table_id = p_table_id)
125: and hir.hierarchy_type = p_hierarchy_type;
126:
127:

Line 196: from hr_dm_tables

192: select 1
193: from hr_dm_hierarchies hir
194: where hir.hierarchy_type = 'L'
195: and hir.parent_table_id = (select table_id
196: from hr_dm_tables
197: where table_name = (
198: select nvl(upload_table_name, table_name)
199: from hr_dm_tables
200: where table_id = p_table_id));

Line 199: from hr_dm_tables

195: and hir.parent_table_id = (select table_id
196: from hr_dm_tables
197: where table_name = (
198: select nvl(upload_table_name, table_name)
199: from hr_dm_tables
200: where table_id = p_table_id));
201: begin
202: hr_dm_utility.message('ROUT','entry:hr_dm_gen_main.chk_ins_resolve_pk', 5);
203: hr_dm_utility.message('PARA','(p_table_id - ' || p_table_id ||

Line 264: from hr_dm_tables tbl,

260: ,upper(tbl.short_name) short_name
261: ,upper(tbl.table_name) table_name
262: ,itm.phase_item_id
263: ,phs.phase_id
264: from hr_dm_tables tbl,
265: hr_dm_phase_items itm,
266: hr_dm_phases phs
267: where phs.migration_id = p_migration_id
268: and phs.phase_name = 'R'

Line 456: l_generator_version hr_dm_tables.generator_version%type;

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;
455:
456: l_generator_version hr_dm_tables.generator_version%type;
457:
458: l_current_phase_status varchar2(30);
459: e_fatal_error exception;
460: l_fatal_error_message varchar2(200);

Line 488: from hr_dm_tables tbl,

484: ,upper(nvl(tbl.global_data,'N')) global_data
485: ,phs.migration_id
486: ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
487: ,sequence_name
488: from hr_dm_tables tbl,
489: hr_dm_phases phs,
490: hr_dm_phase_items itm
491: where itm.phase_item_id = p_phase_item_id
492: and itm.phase_id = phs.phase_id

Line 685: from hr_dm_tables

681: fetch csr_get_table_hierarchy into l_parent_table_id;
682: exit when csr_get_table_hierarchy%notfound;
683: select datetrack
684: into l_datetrack
685: from hr_dm_tables
686: where table_id = l_parent_table_id;
687: if (l_datetrack = 'Y') then
688: l_datetrack_parent := 'Y';
689: end if;

Line 801: -- update the last generated date for TUP/TDS for this table in hr_dm_tables

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: --
803: update hr_dm_tables
804: set last_generated_date = sysdate,
805: generator_version = l_generator_version

Line 803: update hr_dm_tables

799:
800: --
801: -- update the last generated date for TUP/TDS for this table in hr_dm_tables
802: --
803: update hr_dm_tables
804: set last_generated_date = sysdate,
805: generator_version = l_generator_version
806: where table_id = l_csr_get_table_rec.table_id;
807:

Line 901: l_generator_version hr_dm_tables.generator_version%type;

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;
904: l_aol_parameters_tbl hr_dm_library.t_varchar2_tbl;
905:

Line 951: from hr_dm_tables tbl,

947: ,tbl.always_check_row
948: ,upper(nvl(tbl.global_data,'N')) global_data
949: ,lower(nvl(tbl.upload_table_name, tbl.table_name)) upload_table_name
950: ,sequence_name
951: from hr_dm_tables tbl,
952: hr_dm_phase_items itm,
953: hr_dm_phases phs
954: where phs.migration_id = p_migration_id
955: and phs.phase_name = 'G'

Line 1211: from hr_dm_tables

1207: fetch csr_get_table_hierarchy into l_parent_table_id;
1208: exit when csr_get_table_hierarchy%notfound;
1209: select datetrack
1210: into l_datetrack
1211: from hr_dm_tables
1212: where table_id = l_parent_table_id;
1213: if (l_datetrack = 'Y') then
1214: l_datetrack_parent := 'Y';
1215:

Line 1387: -- update the last generated date for TUP/TDS for this table in hr_dm_tables

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
1390: set last_generated_date = sysdate,
1391: generator_version = l_generator_version

Line 1389: update hr_dm_tables

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
1390: set last_generated_date = sysdate,
1391: generator_version = l_generator_version
1392: where table_id = l_csr_get_table_rec.table_id;
1393: