APPS.PER_SPINAL_POINTS_PKG dependencies on PER_SPINAL_POINTS

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 12: from per_spinal_points

8: l_exists VARCHAR2(1);
9:
10: cursor c1 is
11: select 'x'
12: from per_spinal_points
13: where spinal_point = p_spoint
14: and parent_spine_id = p_pspine_id
15: and ((p_rowid is null)
16: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));

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 45: from per_spinal_points

41: l_exists VARCHAR2(1);
42:
43: cursor c2 is
44: select 'x'
45: from per_spinal_points
46: where sequence = p_seq
47: and parent_spine_id = p_pspine_id
48: and ((p_rowid is null)
49: or (p_rowid is not null and chartorowid(p_rowid) <> rowid));

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 100: select per_spinal_points_s.nextval

96:
97: procedure get_id(p_spoint_id IN OUT NUMBER) is
98:
99: cursor c3 is
100: select per_spinal_points_s.nextval
101: from sys.dual;
102: --
103: begin
104: --

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;