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_GENERIC_HIERARCHY_PACKAGE dependencies on PER_GEN_HIERARCHY

Line 266: From per_gen_hierarchy_nodes

262: --
263: Cursor csr_node_type
264: Is
265: Select Node_Type
266: From per_gen_hierarchy_nodes
267: Where hierarchy_node_id = p_hierarchy_node_id;
268: --
269: l_node_type Varchar2(30);
270: l_proc Varchar2(72);

Line 304: per_gen_hierarchy ghr,

300: Cursor csr_hierarchy_type
301: Is
302: Select ghr.type
303: from
304: per_gen_hierarchy ghr,
305: per_gen_hierarchy_versions gvr,
306: per_gen_hierarchy_nodes gnd
307: where
308: gnd.hierarchy_node_id = p_hierarchy_node_id

Line 305: per_gen_hierarchy_versions gvr,

301: Is
302: Select ghr.type
303: from
304: per_gen_hierarchy ghr,
305: per_gen_hierarchy_versions gvr,
306: per_gen_hierarchy_nodes gnd
307: where
308: gnd.hierarchy_node_id = p_hierarchy_node_id
309: and gnd.hierarchy_version_id = gvr.hierarchy_version_id

Line 306: per_gen_hierarchy_nodes gnd

302: Select ghr.type
303: from
304: per_gen_hierarchy ghr,
305: per_gen_hierarchy_versions gvr,
306: per_gen_hierarchy_nodes gnd
307: where
308: gnd.hierarchy_node_id = p_hierarchy_node_id
309: and gnd.hierarchy_version_id = gvr.hierarchy_version_id
310: and gvr.hierarchy_id = ghr.hierarchy_id;

Line 504: per_gen_hierarchy_versions

500: Cursor csr_version_exists
501: is
502: select '1'
503: from
504: per_gen_hierarchy_versions
505: Where
506: hierarchy_id = p_hierarchy_id
507: and p_effective_date between date_from and nvl(date_to,p_effective_date);
508:

Line 1573: From Per_Gen_Hierarchy

1569: INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
1570: INFORMATION19, INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24,
1571: INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
1572: INFORMATION29, INFORMATION30, INFORMATION_CATEGORY
1573: From Per_Gen_Hierarchy
1574: Where Hierarchy_id = P_Hierarchy_Id;
1575:
1576: Cursor Hierarchy_version is
1577: Select Hierarchy_Version_id, VERSION_NUMBER, HIERARCHY_ID , DATE_FROM , DATE_TO , STATUS

Line 1586: From Per_Gen_Hierarchy_Versions

1582: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
1583: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
1584: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
1585: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
1586: From Per_Gen_Hierarchy_Versions
1587: Where ((P_Hierarchy_Version_Id is not NULL and Hierarchy_Version_Id = p_Hierarchy_Version_Id)
1588: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
1589:
1590: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is

Line 1592: From Per_Gen_Hierarchy_Nodes

1588: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
1589:
1590: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is
1591: Select Hierarchy_Node_id
1592: From Per_Gen_Hierarchy_Nodes
1593: Where Hierarchy_Version_id = C_Hierarchy_version_id
1594: and Parent_Hierarchy_Node_Id is NULL;
1595:
1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;

Line 1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;

1592: From Per_Gen_Hierarchy_Nodes
1593: Where Hierarchy_Version_id = C_Hierarchy_version_id
1594: and Parent_Hierarchy_Node_Id is NULL;
1595:
1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
1598: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
1599:
1600: Begin

Line 1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;

1593: Where Hierarchy_Version_id = C_Hierarchy_version_id
1594: and Parent_Hierarchy_Node_Id is NULL;
1595:
1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
1598: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
1599:
1600: Begin
1601: --

Line 1598: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;

1594: and Parent_Hierarchy_Node_Id is NULL;
1595:
1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
1598: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
1599:
1600: Begin
1601: --
1602: g_debug := hr_utility.debug_enabled;

Line 1857: From Per_Gen_Hierarchy_Nodes

1853: is
1854: --
1855: Cursor csr_node_level is
1856: Select level, node_type
1857: From Per_Gen_Hierarchy_Nodes
1858: Where hierarchy_version_id = p_hierarchy_version_id
1859: Start With parent_hierarchy_node_id is null
1860: Connect By prior hierarchy_node_id = parent_hierarchy_node_id;
1861: --

Line 2056: from per_gen_hierarchy

2052: --
2053: --
2054: CURSOR csr_hexist IS
2055: select 'Y'
2056: from per_gen_hierarchy
2057: where type = p_hierarchy_type
2058: and rownum = 1;
2059: --
2060: l_return Varchar2(1) := null;

Line 2093: From per_gen_hierarchy_versions

2089: --
2090: Cursor csr_hier_versions
2091: Is
2092: Select 'Y'
2093: From per_gen_hierarchy_versions
2094: Where hierarchy_id = p_hierarchy_id
2095: And rownum < 3;
2096: --
2097: l_proc varchar2(72);

Line 2128: From Per_gen_Hierarchy_Nodes

2124: P_Parent_Hierarchy_Id IN Number)
2125: Return Number is
2126: Cursor Seq is
2127: Select Nvl(max(SEQ),0) + 1
2128: From Per_gen_Hierarchy_Nodes
2129: Where Hierarchy_Version_Id = p_Hierarchy_Version_id
2130: and Parent_Hierarchy_Node_Id = P_Parent_Hierarchy_Id;
2131:
2132: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;

Line 2132: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;

2128: From Per_gen_Hierarchy_Nodes
2129: Where Hierarchy_Version_Id = p_Hierarchy_Version_id
2130: and Parent_Hierarchy_Node_Id = P_Parent_Hierarchy_Id;
2131:
2132: l_Seq Per_Gen_hierarchy_nodes.Seq%TYPE;
2133:
2134: Begin
2135: open Seq;
2136: Fetch Seq into l_seq;

Line 2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;

2150: p_Object_Version_Number IN Number Default NULL,
2151: p_Business_group_Id IN Number ,
2152: p_Effective_Date IN Date) Is
2153:
2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

Line 2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;

2151: p_Business_group_Id IN Number ,
2152: p_Effective_Date IN Date) Is
2153:
2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

Line 2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

2152: p_Effective_Date IN Date) Is
2153:
2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2160: l_version_count Number(15);

Line 2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

2153:
2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2160: l_version_count Number(15);
2161:

Line 2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

2154: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2160: l_version_count Number(15);
2161:
2162: Cursor C1 IS

Line 2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2156: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2159: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2160: l_version_count Number(15);
2161:
2162: Cursor C1 IS
2163: Select Hierarchy_Node_id, Object_version_number

Line 2164: From Per_gen_Hierarchy_Nodes a

2160: l_version_count Number(15);
2161:
2162: Cursor C1 IS
2163: Select Hierarchy_Node_id, Object_version_number
2164: From Per_gen_Hierarchy_Nodes a
2165: Start with Hierarchy_Node_Id = P_Hierarchy_Id
2166: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id
2167: Order By Nvl(Parent_Hierarchy_Node_Id,0) Desc;
2168:

Line 2172: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh

2168:
2169: Cursor C2 is
2170: Select Pgh.Hierarchy_id, pgh.Object_version_number hovn,
2171: pgv.Hierarchy_version_id, pgv.Object_Version_number vovn
2172: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh
2173: Where Hierarchy_Version_id = P_Hierarchy_version_id
2174: and pgv.Hierarchy_id = pgh.Hierarchy_id;
2175:
2176: Cursor C3 is

Line 2178: From Per_Gen_Hierarchy_Nodes

2174: and pgv.Hierarchy_id = pgh.Hierarchy_id;
2175:
2176: Cursor C3 is
2177: Select Hierarchy_Node_Id, Object_Version_Number
2178: From Per_Gen_Hierarchy_Nodes
2179: Start With Hierarchy_Version_id = P_Hierarchy_Version_id
2180: and Parent_hierarchy_node_id is NULL
2181: Connect By Parent_hierarchy_Node_id = Prior Hierarchy_Node_id
2182: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;

Line 2186: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh

2182: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;
2183:
2184: Cursor C4 is
2185: Select count(*)
2186: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
2187: Where pgh.Hierarchy_id = (Select Hierarchy_id
2188: From Per_Gen_Hierarchy_Versions
2189: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
2190: and pgv.hierarchy_id = pgh.hierarchy_id;

Line 2188: From Per_Gen_Hierarchy_Versions

2184: Cursor C4 is
2185: Select count(*)
2186: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
2187: Where pgh.Hierarchy_id = (Select Hierarchy_id
2188: From Per_Gen_Hierarchy_Versions
2189: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
2190: and pgv.hierarchy_id = pgh.hierarchy_id;
2191:
2192:

Line 2354: From Per_gen_Hierarchy_Nodes a

2350: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
2351: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
2352: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
2353: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
2354: From Per_gen_Hierarchy_Nodes a
2355: Start with Hierarchy_Node_Id = P_Hierarchy_Id
2356: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id;
2357:
2358: Cursor C2 (P_Parent_Hierarchy_Node_id IN Number) is

Line 2360: from Per_Gen_hierarchy_Nodes

2356: Connect by Parent_Hierarchy_Node_Id = Prior Hierarchy_Node_id;
2357:
2358: Cursor C2 (P_Parent_Hierarchy_Node_id IN Number) is
2359: Select Node_Type, Entity_id
2360: from Per_Gen_hierarchy_Nodes
2361: Where Hierarchy_Node_Id = P_Parent_Hierarchy_Node_id;
2362:
2363: Cursor c3(P_Node_type IN Varchar2,
2364: P_Entity_Id Varchar2) Is

Line 2366: from Per_Gen_Hierarchy_Nodes

2362:
2363: Cursor c3(P_Node_type IN Varchar2,
2364: P_Entity_Id Varchar2) Is
2365: Select hierarchy_Node_Id
2366: from Per_Gen_Hierarchy_Nodes
2367: Where Hierarchy_version_Id = p_Hierarchy_version_id
2368: and Node_type = P_Node_Type
2369: and Entity_Id = P_Entity_Id
2370: and Request_Id = -999;

Line 2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

2368: and Node_type = P_Node_Type
2369: and Entity_Id = P_Entity_Id
2370: and Request_Id = -999;
2371:
2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;

Line 2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;

2369: and Entity_Id = P_Entity_Id
2370: and Request_Id = -999;
2371:
2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
2377:

Line 2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;

2370: and Request_Id = -999;
2371:
2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
2377:
2378: Begin

Line 2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;

2371:
2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
2377:
2378: Begin
2379: l_Parent_hierarchy_Node_Id := NULL;

Line 2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;

2372: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
2373: l_Parent_hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
2374: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2375: l_Node_type Per_Gen_Hierarchy_Nodes.Node_type%TYPE;
2376: l_Entity_Id Per_Gen_Hierarchy_Nodes.Entity_Id%TYPE;
2377:
2378: Begin
2379: l_Parent_hierarchy_Node_Id := NULL;
2380: For C1rec in C1

Line 2542: Update Per_Gen_Hierarchy_Nodes

2538: End If;
2539:
2540: End Loop;
2541:
2542: Update Per_Gen_Hierarchy_Nodes
2543: Set REQUEST_ID = 0
2544: Where REQUEST_ID = -999;
2545: End;
2546: --