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.PER_GENERIC_HIERARCHY_PKG dependencies on PER_GEN_HIERARCHY

Line 47: from per_gen_hierarchy_nodes

43: --
44: cursor c1 is
45: select hierarchy_node_id,
46: node_type
47: from per_gen_hierarchy_nodes
48: where parent_hierarchy_node_id = p_hierarchy_node_id;
49: --
50: cursor c2 is
51: select node_type

Line 52: from per_gen_hierarchy_nodes

48: where parent_hierarchy_node_id = p_hierarchy_node_id;
49: --
50: cursor c2 is
51: select node_type
52: from per_gen_hierarchy_nodes
53: where hierarchy_node_id = p_hierarchy_node_id;
54: --
55: begin
56: --

Line 117: from per_gen_hierarchy_nodes

113: function get_parent_node(p_hierarchy_version_id in number) return number is
114: --
115: cursor c1 is
116: select hierarchy_node_id
117: from per_gen_hierarchy_nodes
118: where hierarchy_version_id = p_hierarchy_version_id
119: and parent_hierarchy_node_id is null;
120: --
121: l_hierarchy_node_id number;

Line 154: from per_gen_hierarchy_nodes

150: -- Bug 1802107 VS 25-MAY-2001
151: --
152: cursor c1 is
153: select max(level)
154: from per_gen_hierarchy_nodes
155: start with parent_hierarchy_node_id is null
156: and hierarchy_version_id = p_hierarchy_version_id
157: connect by prior hierarchy_node_id = parent_hierarchy_node_id
158: and hierarchy_version_id = p_hierarchy_version_id;

Line 163: from per_gen_hierarchy_nodes

159: --
160: /*
161: cursor c1 is
162: select count(distinct nvl(parent_hierarchy_node_id,-1))
163: from per_gen_hierarchy_nodes
164: where hierarchy_version_id = p_hierarchy_version_id;
165: */
166: --
167: begin

Line 243: from per_gen_hierarchy a,

239: l_type varchar2(30);
240: --
241: cursor c1 is
242: select a.type
243: from per_gen_hierarchy a,
244: per_gen_hierarchy_versions b
245: where a.hierarchy_id = b.hierarchy_id
246: and b.hierarchy_version_id = p_hierarchy_version_id;
247: --

Line 244: per_gen_hierarchy_versions b

240: --
241: cursor c1 is
242: select a.type
243: from per_gen_hierarchy a,
244: per_gen_hierarchy_versions b
245: where a.hierarchy_id = b.hierarchy_id
246: and b.hierarchy_version_id = p_hierarchy_version_id;
247: --
248: begin

Line 297: from per_gen_hierarchy

293: l_parent_hierarchy_node_id number := null;
294: --
295: cursor c1 is
296: select *
297: from per_gen_hierarchy
298: where hierarchy_id = p_hierarchy_id;
299: --
300: l_c1 c1%rowtype;
301: --

Line 304: from per_gen_hierarchy_versions

300: l_c1 c1%rowtype;
301: --
302: cursor c2 is
303: select *
304: from per_gen_hierarchy_versions
305: where hierarchy_id = p_hierarchy_id;
306: --
307: l_c2 c2%rowtype;
308: --

Line 311: from per_gen_hierarchy_nodes a

307: l_c2 c2%rowtype;
308: --
309: cursor c3(p_hierarchy_version_id number) is
310: select *
311: from per_gen_hierarchy_nodes a
312: where hierarchy_version_id = p_hierarchy_version_id
313: order by decode(parent_hierarchy_node_id,null,1,2);
314: --
315: l_c3 c3%rowtype;

Line 320: from per_gen_hierarchy_nodes a,

316: --
317: cursor c4 is
318: select d.hierarchy_node_id parent_hierarchy_node_id,
319: a.hierarchy_node_id
320: from per_gen_hierarchy_nodes a,
321: per_gen_hierarchy_nodes b,
322: per_gen_hierarchy_nodes c,
323: per_gen_hierarchy_nodes d
324: where a.hierarchy_version_id = l_hierarchy_version_id

Line 321: per_gen_hierarchy_nodes b,

317: cursor c4 is
318: select d.hierarchy_node_id parent_hierarchy_node_id,
319: a.hierarchy_node_id
320: from per_gen_hierarchy_nodes a,
321: per_gen_hierarchy_nodes b,
322: per_gen_hierarchy_nodes c,
323: per_gen_hierarchy_nodes d
324: where a.hierarchy_version_id = l_hierarchy_version_id
325: and a.entity_id = b.entity_id

Line 322: per_gen_hierarchy_nodes c,

318: select d.hierarchy_node_id parent_hierarchy_node_id,
319: a.hierarchy_node_id
320: from per_gen_hierarchy_nodes a,
321: per_gen_hierarchy_nodes b,
322: per_gen_hierarchy_nodes c,
323: per_gen_hierarchy_nodes d
324: where a.hierarchy_version_id = l_hierarchy_version_id
325: and a.entity_id = b.entity_id
326: and a.node_type = b.node_type

Line 323: per_gen_hierarchy_nodes d

319: a.hierarchy_node_id
320: from per_gen_hierarchy_nodes a,
321: per_gen_hierarchy_nodes b,
322: per_gen_hierarchy_nodes c,
323: per_gen_hierarchy_nodes d
324: where a.hierarchy_version_id = l_hierarchy_version_id
325: and a.entity_id = b.entity_id
326: and a.node_type = b.node_type
327: and b.hierarchy_version_id = l_c2.hierarchy_version_id

Line 621: update per_gen_hierarchy_nodes

617: --
618: fetch c4 into l_c4;
619: exit when c4%notfound;
620: --
621: update per_gen_hierarchy_nodes
622: set parent_hierarchy_node_id = l_c4.parent_hierarchy_node_id
623: where hierarchy_node_id = l_c4.hierarchy_node_id;
624: --
625: end loop;

Line 658: from per_gen_hierarchy_versions

654: l_object_version_number number;
655: --
656: cursor c1 is
657: select *
658: from per_gen_hierarchy_versions
659: where hierarchy_version_id = p_hierarchy_version_id;
660: --
661: l_c1 c1%rowtype;
662: --

Line 665: from per_gen_hierarchy_nodes a

661: l_c1 c1%rowtype;
662: --
663: cursor c2 is
664: select *
665: from per_gen_hierarchy_nodes a
666: where hierarchy_version_id = p_hierarchy_version_id
667: order by decode(parent_hierarchy_node_id,null,1,2);
668: --
669: l_c2 c2%rowtype;

Line 674: from per_gen_hierarchy_nodes a,

670: --
671: cursor c3 is
672: select d.hierarchy_node_id parent_hierarchy_node_id,
673: a.hierarchy_node_id
674: from per_gen_hierarchy_nodes a,
675: per_gen_hierarchy_nodes b,
676: per_gen_hierarchy_nodes c,
677: per_gen_hierarchy_nodes d
678: where a.hierarchy_version_id = l_hierarchy_version_id

Line 675: per_gen_hierarchy_nodes b,

671: cursor c3 is
672: select d.hierarchy_node_id parent_hierarchy_node_id,
673: a.hierarchy_node_id
674: from per_gen_hierarchy_nodes a,
675: per_gen_hierarchy_nodes b,
676: per_gen_hierarchy_nodes c,
677: per_gen_hierarchy_nodes d
678: where a.hierarchy_version_id = l_hierarchy_version_id
679: and a.entity_id = b.entity_id

Line 676: per_gen_hierarchy_nodes c,

672: select d.hierarchy_node_id parent_hierarchy_node_id,
673: a.hierarchy_node_id
674: from per_gen_hierarchy_nodes a,
675: per_gen_hierarchy_nodes b,
676: per_gen_hierarchy_nodes c,
677: per_gen_hierarchy_nodes d
678: where a.hierarchy_version_id = l_hierarchy_version_id
679: and a.entity_id = b.entity_id
680: and a.node_type = b.node_type

Line 677: per_gen_hierarchy_nodes d

673: a.hierarchy_node_id
674: from per_gen_hierarchy_nodes a,
675: per_gen_hierarchy_nodes b,
676: per_gen_hierarchy_nodes c,
677: per_gen_hierarchy_nodes d
678: where a.hierarchy_version_id = l_hierarchy_version_id
679: and a.entity_id = b.entity_id
680: and a.node_type = b.node_type
681: and b.hierarchy_version_id = p_hierarchy_version_id

Line 894: update per_gen_hierarchy_nodes

890: --
891: fetch c3 into l_c3;
892: exit when c3%notfound;
893: --
894: update per_gen_hierarchy_nodes
895: set parent_hierarchy_node_id = l_c3.parent_hierarchy_node_id
896: where hierarchy_node_id = l_c3.hierarchy_node_id;
897: --
898: end loop;