APPS.HR_DM_GEN_MAIN dependencies on HR_DM_HIERARCHIES

Line 111: from hr_dm_hierarchies hir

107:
108: cursor csr_get_hierarchy_info (p_table_id number,
109: p_hierarchy_type varchar2) is
110: select 1
111: from hr_dm_hierarchies hir
112: where hir.table_id = p_table_id
113: and hir.hierarchy_type = p_hierarchy_type;
114:
115: cursor csr_get_lr_info (p_table_id number,

Line 118: from hr_dm_hierarchies hir,

114:
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)

Line 193: from hr_dm_hierarchies hir

189: -- the entries in hr_dm_hierarchy table.
190:
191: cursor csr_chk_ins_resolve_pk (p_table_id number) is
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 = (

Line 498: from hr_dm_hierarchies

494:
495: cursor csr_get_table_hierarchy is
496: select distinct parent_table_id
497: from (select table_id,parent_table_id
498: from hr_dm_hierarchies
499: where hierarchy_type = 'PC')
500: start with table_id = l_table_info.table_id
501: connect by prior parent_table_id = table_id;
502:

Line 628: -- it is allowed if the table has any child table seeded in the hr_dm_hierarchies

624: end if;
625:
626: --
627: -- get the info whether insert into hr_dm_resolve_pk table is allowed or not.
628: -- it is allowed if the table has any child table seeded in the hr_dm_hierarchies
629: -- table with hierarchy type 'L'.
630: --
631: l_table_info.ins_resolve_pk := chk_ins_resolve_pk (l_table_info.table_id);
632:

Line 975: from hr_dm_hierarchies

971:
972: cursor csr_get_table_hierarchy is
973: select distinct parent_table_id
974: from (select table_id,parent_table_id
975: from hr_dm_hierarchies
976: where hierarchy_type = 'PC')
977: start with table_id = l_table_info.table_id
978: connect by prior parent_table_id = table_id;
979:

Line 983: from hr_dm_hierarchies h

979:
980: cursor csr_col_hier
981: (p_table_id number) is
982: select count(*)
983: from hr_dm_hierarchies h
984: where h.table_id = p_table_id
985: and h.hierarchy_type ='A'
986: and h.column_name not in ('CREATED_BY','LAST_UPDATED_BY');
987:

Line 1155: -- it is allowed if the table has any child table seeded in the hr_dm_hierarchies

1151: 'L');
1152: end if;
1153: --
1154: -- get the info whether insert into hr_dm_resolve_pk table is allowed or not.
1155: -- it is allowed if the table has any child table seeded in the hr_dm_hierarchies
1156: -- table with hierarchy type 'L'.
1157: --
1158: l_table_info.ins_resolve_pk := chk_ins_resolve_pk(l_table_info.table_id);
1159: