APPS.PER_SPINAL_POINTS_PKG dependencies on PER_SPINAL_POINTS_PKG

Line 1: package body PER_SPINAL_POINTS_PKG as

1: package body PER_SPINAL_POINTS_PKG as
2: /* $Header: pespo01t.pkb 115.1 99/07/18 15:08:24 porting ship $ */
3:
4:
5: procedure chk_unq_point(p_spoint IN VARCHAR2,

Line 20: hr_utility.set_location('per_spinal_points_pkg.chk_unq_point',1);

16: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
17: --
18: begin
19: --
20: hr_utility.set_location('per_spinal_points_pkg.chk_unq_point',1);
21: --
22: open c1;
23: --
24: fetch c1 into l_exists;

Line 53: hr_utility.set_location('per_spinal_points_pkg.chk_unq_seq',1);

49: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));
50: --
51: begin
52: --
53: hr_utility.set_location('per_spinal_points_pkg.chk_unq_seq',1);
54: --
55: open c2;
56: --
57: fetch c2 into l_exists;

Line 105: hr_utility.set_location('per_spinal_points_pkg.get_id',1);

101: from sys.dual;
102: --
103: begin
104: --
105: hr_utility.set_location('per_spinal_points_pkg.get_id',1);
106: --
107: open c3;
108: --
109: fetch c3 into p_spoint_id;

Line 138: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',1);

134: and rate_type = 'SP';
135: --
136: begin
137: --
138: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',1);
139: --
140: open c4;
141: --
142: fetch c4 into l_exists1;

Line 151: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',2);

147: END IF;
148: --
149: close c4;
150: --
151: hr_utility.set_location('per_spinal_points_pkg.stb_del_validation',2);
152: --
153: open c5;
154: --
155: fetch c5 into l_exists2;

Line 168: end PER_SPINAL_POINTS_PKG;

164: end stb_del_validation;
165:
166:
167:
168: end PER_SPINAL_POINTS_PKG;