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_TUPS dependencies on HR_DM_HIERARCHIES

Line 347: l_column_name hr_dm_hierarchies.column_name%type;

343: l_proc_body_tbl t_varchar2_32k_tbl;
344:
345: -- variables to store the information about p_pk_columns_tbl elements.
346: -- this is to reduce the variable name and add clarity.
347: l_column_name hr_dm_hierarchies.column_name%type;
348:
349:
350: -- block body of the procedure i.e between begin and end.
351: l_proc_body varchar2(32767) := null;

Line 448: l_column_name hr_dm_hierarchies.column_name%type;

444: l_proc_body_tbl t_varchar2_32k_tbl;
445:
446: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
447: -- this is to reduce the variable name and add clarity.
448: l_column_name hr_dm_hierarchies.column_name%type;
449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

Line 449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;

445:
446: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
447: -- this is to reduce the variable name and add clarity.
448: l_column_name hr_dm_hierarchies.column_name%type;
449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

Line 452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

448: l_column_name hr_dm_hierarchies.column_name%type;
449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
454:
455:
456: -- block body of the procedure i.e between begin and end.

Line 453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

449: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
450: l_parent_table_name hr_dm_tables.table_name%type;
451: l_parent_table_alias hr_dm_tables.table_alias%type;
452: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
453: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
454:
455:
456: -- block body of the procedure i.e between begin and end.
457: l_proc_body varchar2(32767) := null;

Line 575: l_column_name hr_dm_hierarchies.column_name%type;

571: l_proc_body_tbl t_varchar2_32k_tbl;
572:
573: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
574: -- this is to reduce the variable name and add clarity.
575: l_column_name hr_dm_hierarchies.column_name%type;
576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

Line 576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;

572:
573: -- variables to store the information about p_fk_to_aol_columns_tbl elements.
574: -- this is to reduce the variable name and add clarity.
575: l_column_name hr_dm_hierarchies.column_name%type;
576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

Line 579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;

575: l_column_name hr_dm_hierarchies.column_name%type;
576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
581:
582:
583: -- block body of the procedure i.e between begin and end.

Line 580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;

576: l_parent_table_id hr_dm_hierarchies.parent_table_id%type;
577: l_parent_table_name hr_dm_tables.table_name%type;
578: l_parent_table_alias hr_dm_tables.table_alias%type;
579: l_parent_column_name hr_dm_hierarchies.parent_column_name%type;
580: l_parent_id_column_name hr_dm_hierarchies.parent_id_column_name%type;
581:
582:
583: -- block body of the procedure i.e between begin and end.
584: l_proc_body varchar2(32767) := null;

Line 2028: hr_dm_hierarchies hir

2024: tbl.table_name table_name
2025: from all_tab_columns col,
2026: hr_dm_tables tbl,
2027: hr_dm_tables dmt,
2028: hr_dm_hierarchies hir
2029: where tbl.table_name = nvl(dmt.upload_table_name, dmt.table_name)
2030: and dmt.table_id = p_table_info.table_id
2031: and hierarchy_type = 'R'
2032: and tbl.table_id = hir.table_id