APPS.PER_PGN_INS dependencies on PER_GEN_HIERARCHY_NODES

Line 58: l_identifier_key per_gen_hierarchy_nodes.identifier_key%TYPE := null;

54: (p_rec in out nocopy per_pgn_shd.g_rec_type
55: ) is
56: --
57: l_proc varchar2(72) := g_package||'insert_dml';
58: l_identifier_key per_gen_hierarchy_nodes.identifier_key%TYPE := null;
59: --
60: Begin
61: hr_utility.set_location('Entering:'||l_proc, 5);
62: p_rec.object_version_number := 1; -- Initialise the object version

Line 71: -- Insert the row into: per_gen_hierarchy_nodes

67: END IF;
68: --
69: --
70: --
71: -- Insert the row into: per_gen_hierarchy_nodes
72: --
73: insert into per_gen_hierarchy_nodes
74: (hierarchy_node_id
75: ,business_group_id

Line 73: insert into per_gen_hierarchy_nodes

69: --
70: --
71: -- Insert the row into: per_gen_hierarchy_nodes
72: --
73: insert into per_gen_hierarchy_nodes
74: (hierarchy_node_id
75: ,business_group_id
76: ,entity_id
77: ,hierarchy_version_id

Line 295: Cursor C_Sel1 is select per_gen_hierarchy_nodes_s.nextval from sys.dual;

291: ) is
292: --
293: l_proc varchar2(72) := g_package||'pre_insert';
294: --
295: Cursor C_Sel1 is select per_gen_hierarchy_nodes_s.nextval from sys.dual;
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --

Line 510: (p_module_name => 'PER_GEN_HIERARCHY_NODES'

506: --
507: when hr_api.cannot_find_prog_unit then
508: --
509: hr_api.cannot_find_prog_unit_error
510: (p_module_name => 'PER_GEN_HIERARCHY_NODES'
511: ,p_hook_type => 'AI');
512: --
513: end;
514: --