APPS.HR_CALENDAR_NODE_TYPE_API dependencies on PER_GEN_HIER_NODE_TYPES

Line 28: select per_gen_hier_node_types_s.nextval

24: --
25: -- Declare cursors and local variables
26: --
27: CURSOR csr_sequence IS
28: select per_gen_hier_node_types_s.nextval
29: from sys.dual;
30:
31: --
32: -- Check if the lookup exists already

Line 41: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;

37: where lookup_type = 'HIERARCHY_NODE_TYPE'
38: and lookup_code = p_child_node_type;
39:
40: l_proc varchar2(80) := g_package||'create_node_type';
41: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;
42: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;
43: l_rowid varchar2(255) := null;
44: l_dummy varchar2(1);
45: l_lookup_code varchar2(30);

Line 42: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;

38: and lookup_code = p_child_node_type;
39:
40: l_proc varchar2(80) := g_package||'create_node_type';
41: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;
42: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;
43: l_rowid varchar2(255) := null;
44: l_dummy varchar2(1);
45: l_lookup_code varchar2(30);
46: l_effective_date date;

Line 256: FROM per_gen_hier_node_types

252: SELECT lookup_code, created_by, meaning, description
253: FROM hr_lookups
254: WHERE lookup_type = 'HIERARCHY_NODE_TYPE'
255: AND lookup_code = (SELECT child_node_type
256: FROM per_gen_hier_node_types
257: WHERE hier_node_type_id = p_hier_node_type_id);
258: --
259: --
260: l_lookup_code fnd_lookup_values.lookup_code%type := null;

Line 266: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;

262: l_meaning fnd_lookup_values.meaning%type := null;
263: l_desc fnd_lookup_values.description%type := null;
264: l_update_attempted boolean := false;
265: l_proc varchar2(80) := g_package||'update_node_type';
266: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;
267: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;
268: l_effective_date date;
269: --
270: begin

Line 267: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;

263: l_desc fnd_lookup_values.description%type := null;
264: l_update_attempted boolean := false;
265: l_proc varchar2(80) := g_package||'update_node_type';
266: l_hier_node_type_id per_gen_hier_node_types.hier_node_type_id%TYPE;
267: l_object_version_number per_gen_hier_node_types.object_version_number%TYPE;
268: l_effective_date date;
269: --
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 472: FROM per_gen_hier_node_types

468: --
469: -- Fetch the lookup to be deleted
470: CURSOR csr_get_child_code IS
471: SELECT child_node_type
472: FROM per_gen_hier_node_types
473: WHERE hier_node_type_id = p_hier_node_type_id;
474: --
475: l_proc varchar2(72) := g_package||'delete_node_type';
476: l_child_node_type per_gen_hier_node_types.child_node_type%Type;

Line 476: l_child_node_type per_gen_hier_node_types.child_node_type%Type;

472: FROM per_gen_hier_node_types
473: WHERE hier_node_type_id = p_hier_node_type_id;
474: --
475: l_proc varchar2(72) := g_package||'delete_node_type';
476: l_child_node_type per_gen_hier_node_types.child_node_type%Type;
477: --
478: begin
479: hr_utility.set_location('Entering:'|| l_proc, 5);
480: --

Line 599: select max(level) from per_gen_hier_node_types

595: -- tree walk from supplied child node to top level
596: -- to obtain level of child within the hierarchy
597:
598: CURSOR csr_get_level IS
599: select max(level) from per_gen_hier_node_types
600: where hierarchy_type = p_hierarchy_type
601: connect by child_node_type = prior parent_node_type
602: start with child_node_type = p_child_node_type;
603:

Line 626: from per_gen_hier_node_types

622: -- within the supplied hierarchy.
623:
624: CURSOR csr_exist IS
625: select 'Y'
626: from per_gen_hier_node_types
627: where hierarchy_type = p_hierarchy_type
628: and parent_node_type = p_child_node_type
629: and rownum = 1;
630: