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_HIER_NODE_TYPES

Line 77: per_gen_hier_node_types

73: Cursor csr_child_node_types
74: is
75: Select '1'
76: from
77: per_gen_hier_node_types
78: Where
79: ( parent_node_type = p_node_type
80: Or
81: parent_node_type is null and p_node_type is null)

Line 187: From per_gen_hier_node_types

183: p_parent_node_type IN varchar2,
184: p_hierarchy_type IN varchar2)
185: is
186: Select hier_node_type_id
187: From per_gen_hier_node_types
188: Where hierarchy_type = p_hierarchy_type
189: And ( parent_node_type = p_parent_node_type
190: Or
191: (parent_node_type is null and p_parent_node_type is null)

Line 223: --Determine the key in the per_gen_hier_node_types table

219:
220: l_parent_node_type := Get_Node_Type(p_parent_node_id);
221: l_child_node_type := Get_Node_Type(p_child_node_id);
222: --
223: --Determine the key in the per_gen_hier_node_types table
224: --
225: Open csr_node_type_id(l_child_node_type,l_parent_node_type,l_hierarchy_type);
226: Fetch csr_node_type_id into l_hier_node_type_id;
227: close csr_node_type_id;

Line 358: from per_gen_hier_node_types

354:
355: Cursor csr_value_set_name(p_parent_node_type IN Varchar2)
356: IS
357: Select CHILD_VALUE_SET
358: from per_gen_hier_node_types
359: where CHILD_NODE_TYPE = p_child_node_type
360: and ( (PARENT_NODE_TYPE = p_parent_node_type)
361: Or
362: (PARENT_NODE_TYPE is null And p_parent_node_type is null) )

Line 466: From Per_Gen_Hier_Node_Types

462:
463: Cursor csr_chk_structure_exists
464: Is
465: Select 'x'
466: From Per_Gen_Hier_Node_Types
467: Where Hierarchy_Type = p_hierarchy_type;
468:
469: Begin
470: --

Line 1088: from per_gen_hier_node_types

1084:
1085: Cursor csr_chk_duplicate
1086: is
1087: Select '1'
1088: from per_gen_hier_node_types
1089: where
1090: hierarchy_type = p_hierarchy_type
1091: and ( (parent_node_type = p_parent_node_type)
1092: or

Line 1100: From per_gen_hier_node_types

1096:
1097: Cursor Csr_chk_recursion
1098: is
1099: Select Parent_node_type
1100: From per_gen_hier_node_types
1101: Start with child_node_type = p_parent_node_type
1102: And hierarchy_type = p_hierarchy_type
1103: Connect by child_node_type = prior parent_node_type
1104: And hierarchy_type = p_hierarchy_type;

Line 1109: select per_gen_hier_node_types_s.nextval

1105:
1106: --
1107: Cursor csr_next_val
1108: is
1109: select per_gen_hier_node_types_s.nextval
1110: from sys.dual;
1111:
1112: Cursor csr_chk_id_duplicate(p_next_id_val in number)
1113: is

Line 1115: from per_gen_hier_node_types

1111:
1112: Cursor csr_chk_id_duplicate(p_next_id_val in number)
1113: is
1114: select '1'
1115: from per_gen_hier_node_types
1116: where hier_node_type_id = p_next_id_val;
1117:
1118: --
1119: l_proc varchar2(72) ;

Line 1179: l_sql := 'Insert into per_gen_hier_node_types

1175: --
1176: --
1177: -- All validations are passed. Insert values into the table
1178: --
1179: l_sql := 'Insert into per_gen_hier_node_types
1180: (hierarchy_type,
1181: parent_node_type,
1182: child_node_type,
1183: child_value_set,

Line 1191: per_gen_hier_node_types_s.nextval ,

1187: :p_hierarchy_type ,
1188: :p_parent_node_type ,
1189: :p_child_node_type ,
1190: :p_child_value_set ,
1191: per_gen_hier_node_types_s.nextval ,
1192: 1 )';
1193: --
1194: if g_debug then
1195: hr_utility.set_location('Sql Formed', 50);

Line 1229: per_gen_hier_node_types

1225: Cursor csr_node_type_entry
1226: is
1227: Select object_version_number
1228: From
1229: per_gen_hier_node_types
1230: Where
1231: hierarchy_type = p_hierarchy_type
1232: And ( (parent_node_type = p_parent_node_type)
1233: Or

Line 1293: l_sql := 'Update per_gen_hier_node_types

1289: p_object_version_number := p_object_version_number + 1;
1290: --
1291: -- Update the value set info
1292: --
1293: l_sql := 'Update per_gen_hier_node_types
1294: Set child_value_set = :p_child_value_set,
1295: object_version_number = :p_object_version_number
1296: Where hierarchy_type = :p_hierarchy_type
1297: and ( (parent_node_type = :p_parent_node_type)

Line 1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');

1321: hr_utility.set_location('Error: Object Locked', 60);
1322: end if;
1323: --
1324: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1325: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1326: fnd_msg_pub.add;
1327: When others
1328: then
1329: if g_debug then

Line 1350: per_gen_hier_node_types

1346: Cursor csr_node_type_entry
1347: is
1348: Select object_version_number
1349: From
1350: per_gen_hier_node_types
1351: Where
1352: hierarchy_type = p_hierarchy_type
1353: And ( (parent_node_type = p_parent_node_type)
1354: Or

Line 1362: from per_gen_hier_node_types

1358: --
1359: Cursor csr_node_type_hierarchy
1360: is
1361: Select child_node_type,parent_node_type
1362: from per_gen_hier_node_types
1363: start with hierarchy_type = p_hierarchy_type
1364: and ( (parent_node_type = p_parent_node_type)
1365: Or
1366: (parent_node_type is null And p_parent_node_type is null))

Line 1418: l_sql := 'Delete from per_gen_hier_node_types

1414: --
1415: --
1416: --Form the delete sql
1417: --
1418: l_sql := 'Delete from per_gen_hier_node_types
1419: Where
1420: hierarchy_type = :p_hierarchy_type
1421: And ( (parent_node_type = :p_parent_node_type)
1422: Or

Line 1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');

1446: if g_debug then
1447: hr_utility.set_location('Error: Object Locked', 50);
1448: end if;
1449: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1450: fnd_message.set_token('TABLE_NAME', 'per_gen_hier_node_types');
1451: fnd_msg_pub.add;
1452: When others
1453: then
1454: if g_debug then

Line 1474: per_gen_hier_node_types

1470: Cursor csr_top_node_types
1471: is
1472: Select child_node_type
1473: From
1474: per_gen_hier_node_types
1475: where
1476: hierarchy_type = p_hierarchy_type
1477: and parent_node_type is null;
1478: --

Line 1915: FROM per_gen_hier_node_types pgt

1911: SELECT flex_value_set_id
1912: FROM fnd_flex_value_sets
1913: WHERE validation_type = 'F'
1914: AND flex_value_set_name = (SELECT pgt.child_value_set
1915: FROM per_gen_hier_node_types pgt
1916: WHERE pgt.hier_node_type_id = p_node_type_id);
1917:
1918: l_value_set_id NUMBER(15) := NULL;
1919: l_id_column VARCHAR2(200);