DBA Data[Home] [Help]

APPS.PER_CAREER_PATH_ELEMENTS_PKG dependencies on PER_CAREER_PATH_ELEMENTS_PKG

Line 1: package body PER_CAREER_PATH_ELEMENTS_PKG as

1: package body PER_CAREER_PATH_ELEMENTS_PKG as
2: /* $Header: pecpe01t.pkb 120.0 2005/05/31 07:11:08 appldev noship $ */
3:
4: procedure navigate_path(p_child_id IN NUMBER,
5: p_child_name IN OUT nocopy VARCHAR2,

Line 30: hr_utility.set_location('per_career_path_elements_pkg.navigate_path',1);

26: --
27: --
28: begin
29: --
30: hr_utility.set_location('per_career_path_elements_pkg.navigate_path',1);
31: --
32: open c1;
33: --
34: fetch c1 into p_child_name;

Line 38: hr_utility.set_location('per_career_path_elements_pkg.navigate_path',2);

34: fetch c1 into p_child_name;
35: --
36: close c1;
37: --
38: hr_utility.set_location('per_career_path_elements_pkg.navigate_path',2);
39: --
40: open c2;
41: --
42: fetch c2 into p_parent_id,

Line 60: hr_utility.set_location('per_career_path_elements_pkg.get_id',1);

56: from sys.dual;
57: --
58: begin
59: --
60: hr_utility.set_location('per_career_path_elements_pkg.get_id',1);
61: --
62: open c3;
63: --
64: fetch c3 into p_cpath_ele_id;

Line 87: hr_utility.set_location('per_career_path_elements_pkg.stb_del_validation',1);

83: and parent_job_id = p_sjob_id;
84: --
85: begin
86: --
87: hr_utility.set_location('per_career_path_elements_pkg.stb_del_validation',1);
88: --
89: open c4;
90: --
91: fetch c4 into l_exists;

Line 116: hr_utility.set_location('per_career_path_elements_pkg.get_name',1);

112: where job_id = p_sjob_id;
113: --
114: begin
115: --
116: hr_utility.set_location('per_career_path_elements_pkg.get_name',1);
117: --
118: open c5;
119: --
120: fetch c5 into p_sjob_name;

Line 127: end PER_CAREER_PATH_ELEMENTS_PKG;

123:
124: end get_name;
125:
126:
127: end PER_CAREER_PATH_ELEMENTS_PKG;