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

Line 10: From Per_gen_Hierarchy_Nodes

6: P_Parent_Hierarchy_Id IN Number)
7: Return Number is
8: Cursor Seq is
9: Select Nvl(max(SEQ),0) + 1
10: From Per_gen_Hierarchy_Nodes
11: Where Hierarchy_Version_Id = p_Hierarchy_Version_id
12: and Parent_Hierarchy_Node_Id = P_Parent_Hierarchy_Id;
13:
14: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;

Line 14: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;

10: From Per_gen_Hierarchy_Nodes
11: Where Hierarchy_Version_Id = p_Hierarchy_Version_id
12: and Parent_Hierarchy_Node_Id = P_Parent_Hierarchy_Id;
13:
14: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;
15:
16: Begin
17: open Seq;
18: Fetch Seq into l_seq;

Line 40: From Per_gen_Hierarchy_Nodes a

36: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
37: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
38: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
39: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
40: From Per_gen_Hierarchy_Nodes a
41: Start with Hierarchy_Node_Id = P_Hierarchy_Id
42: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id;
43:
44: Cursor C2 (P_Parent_Hierarchy_Node_id IN Number) is

Line 46: from Per_Gen_hierarchy_Nodes

42: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id;
43:
44: Cursor C2 (P_Parent_Hierarchy_Node_id IN Number) is
45: Select Node_Type, Entity_id
46: from Per_Gen_hierarchy_Nodes
47: Where Hierarchy_Node_Id = P_Parent_Hierarchy_Node_id;
48:
49: Cursor c3(P_Node_type IN Varchar2,
50: P_Entity_Id Varchar2) Is

Line 52: from Per_Gen_Hierarchy_Nodes

48:
49: Cursor c3(P_Node_type IN Varchar2,
50: P_Entity_Id Varchar2) Is
51: Select hierarchy_Node_Id
52: from Per_Gen_Hierarchy_Nodes
53: Where Hierarchy_version_Id = p_Hierarchy_version_id
54: and Node_type = P_Node_Type
55: and Entity_Id = P_Entity_Id
56: and Request_Id = -999;

Line 58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

54: and Node_type = P_Node_Type
55: and Entity_Id = P_Entity_Id
56: and Request_Id = -999;
57:
58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;

Line 59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;

55: and Entity_Id = P_Entity_Id
56: and Request_Id = -999;
57:
58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
63:

Line 60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

56: and Request_Id = -999;
57:
58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
63:
64: Begin

Line 61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;

57:
58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
63:
64: Begin
65: l_Parent_hierarchy_Node_Id := NULL;

Line 62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;

58: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
59: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
60: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
61: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
62: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
63:
64: Begin
65: l_Parent_hierarchy_Node_Id := NULL;
66: For C1rec in C1

Line 226: Update Per_Gen_Hierarchy_Nodes

222: P_EFFECTIVE_DATE => p_Effective_Date);
223: End If;
224:
225: End Loop;
226: Update Per_Gen_Hierarchy_Nodes
227: Set REQUEST_ID = 0
228: Where REQUEST_ID = -999;
229: End;
230:

Line 244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;

240: p_Object_Version_Number IN Number Default NULL,
241: p_Business_group_Id IN Number ,
242: p_Effective_Date IN Date) Is
243:
244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

Line 245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;

241: p_Business_group_Id IN Number ,
242: p_Effective_Date IN Date) Is
243:
244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

Line 246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

242: p_Effective_Date IN Date) Is
243:
244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
250: /* l_Node_id Pqh_de_operations.Operation_Id%TYPE; */

Line 247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

243:
244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
250: /* l_Node_id Pqh_de_operations.Operation_Id%TYPE; */
251: l_version_count Number(15);

Line 248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
250: /* l_Node_id Pqh_de_operations.Operation_Id%TYPE; */
251: l_version_count Number(15);
252:

Line 249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
250: /* l_Node_id Pqh_de_operations.Operation_Id%TYPE; */
251: l_version_count Number(15);
252:
253: Cursor C1 IS

Line 255: From Per_gen_Hierarchy_Nodes a

251: l_version_count Number(15);
252:
253: Cursor C1 IS
254: Select Hierarchy_Node_id, Object_version_number
255: From Per_gen_Hierarchy_Nodes a
256: Start with Hierarchy_Node_Id = P_Hierarchy_Id
257: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id
258: Order By Nvl(Parent_Hierarchy_Node_Id,0) Desc;
259:

Line 263: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh

259:
260: Cursor C2 is
261: Select Pgh.Hierarchy_id, pgh.Object_version_number hovn,
262: pgv.Hierarchy_version_id, pgv.Object_Version_number vovn
263: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh
264: Where Hierarchy_Version_id = P_Hierarchy_version_id
265: and pgv.Hierarchy_id = pgh.Hierarchy_id;
266:
267: Cursor C3 is

Line 269: From Per_Gen_Hierarchy_Nodes

265: and pgv.Hierarchy_id = pgh.Hierarchy_id;
266:
267: Cursor C3 is
268: Select Hierarchy_Node_Id, Object_Version_Number
269: From Per_Gen_Hierarchy_Nodes
270: Start With Hierarchy_Version_id = P_Hierarchy_Version_id
271: and Parent_hierarchy_node_id is NULL
272: Connect By Parent_hierarchy_Node_id = Prior Hierarchy_Node_id
273: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;

Line 277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh

273: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;
274:
275: Cursor C4 is
276: Select count(*)
277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
278: Where pgh.Hierarchy_id = (Select Hierarchy_id
279: From Per_Gen_Hierarchy_Versions
280: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
281: and pgv.hierarchy_id = pgh.hierarchy_id;

Line 279: From Per_Gen_Hierarchy_Versions

275: Cursor C4 is
276: Select count(*)
277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
278: Where pgh.Hierarchy_id = (Select Hierarchy_id
279: From Per_Gen_Hierarchy_Versions
280: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
281: and pgv.hierarchy_id = pgh.hierarchy_id;
282:
283:

Line 493: From Per_Gen_Hierarchy

489: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
490: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
491: INFORMATION19, INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
492: INFORMATION29, INFORMATION30, INFORMATION_CATEGORY
493: From Per_Gen_Hierarchy
494: Where Hierarchy_id = P_Hierarchy_Id;
495:
496: Cursor Hierarchy_version is
497: Select Hierarchy_Version_id, VERSION_NUMBER, HIERARCHY_ID , DATE_FROM , DATE_TO , STATUS , VALIDATE_FLAG, ATTRIBUTE_CATEGORY,

Line 505: From Per_Gen_Hierarchy_Versions

501: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
502: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
503: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
504: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
505: From Per_Gen_Hierarchy_Versions
506: Where ((P_Hierarchy_Version_Id is not NULL and Hierarchy_Version_Id = p_Hierarchy_Version_Id)
507: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
508:
509: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is

Line 511: From Per_Gen_Hierarchy_Nodes

507: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
508:
509: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is
510: Select Hierarchy_Node_id
511: From Per_Gen_Hierarchy_Nodes
512: Where Hierarchy_Version_id = C_Hierarchy_version_id
513: and Parent_Hierarchy_Node_Id is NULL;
514:
515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;

Line 515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;

511: From Per_Gen_Hierarchy_Nodes
512: Where Hierarchy_Version_id = C_Hierarchy_version_id
513: and Parent_Hierarchy_Node_Id is NULL;
514:
515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
517: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
518:
519: Begin

Line 516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;

512: Where Hierarchy_Version_id = C_Hierarchy_version_id
513: and Parent_Hierarchy_Node_Id is NULL;
514:
515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
517: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
518:
519: Begin
520:

Line 517: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;

513: and Parent_Hierarchy_Node_Id is NULL;
514:
515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
517: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
518:
519: Begin
520:
521: If P_Type = 'H' Then