DBA Data[Home] [Help]

APPS.PER_CAREER_PATHS_PKG_1 dependencies on PER_CAREER_PATHS_PKG_1

Line 1: package body PER_CAREER_PATHS_PKG_1 as

1: package body PER_CAREER_PATHS_PKG_1 as
2: /* $Header: pecpt01.pkb 115.1 99/07/17 18:51:52 porting ship $ */
3:
4: procedure stb_del_val(p_cpath_id IN NUMBER) IS
5: l_exists VARCHAR2(1);

Line 14: hr_utility.set_location('per_career_paths_pkg_1.stb_del_val',1);

10: where career_path_id = p_cpath_id;
11: --
12: begin
13: --
14: hr_utility.set_location('per_career_paths_pkg_1.stb_del_val',1);
15: --
16: open c1;
17: --
18: fetch c1 into l_exists;

Line 46: hr_utility.set_location('per_career_paths_pkg_1.unique_chk',1);

42: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
43: --
44: begin
45: --
46: hr_utility.set_location('per_career_paths_pkg_1.unique_chk',1);
47: --
48: open c2;
49: --
50: fetch c2 into l_exists2;

Line 71: hr_utility.set_location('per_career_paths_pkg_1.get_id',1);

67: from sys.dual;
68: --
69: begin
70: --
71: hr_utility.set_location('per_career_paths_pkg_1.get_id',1);
72: --
73: open c3;
74: --
75: fetch c3 into p_cpath_id;

Line 83: end PER_CAREER_PATHS_PKG_1;

79: end get_id;
80:
81:
82:
83: end PER_CAREER_PATHS_PKG_1;