APPS.PER_PARENT_SPINES_PKG dependencies on PER_PARENT_SPINES

Line 1: package body PER_PARENT_SPINES_PKG as

1: package body PER_PARENT_SPINES_PKG as
2: /* $Header: pepsp01t.pkb 115.2 2003/02/10 17:20:43 eumenyio ship $ */
3:
4:
5: procedure chk_unique_name(p_name IN VARCHAR2,

Line 12: from per_parent_spines

8: l_exists VARCHAR2(1);
9:
10: cursor c1 is
11: select 'x'
12: from per_parent_spines
13: where upper(name) = upper(p_name)
14: and (p_rowid is null
15: or (p_rowid is not null and chartorowid(p_rowid) <> rowid))
16: and business_group_id + 0 = p_bgroup_id;

Line 20: hr_utility.set_location('per_parent_spines_pkg.chk_unique_name',1);

16: and business_group_id + 0 = p_bgroup_id;
17: --
18: begin
19: --
20: hr_utility.set_location('per_parent_spines_pkg.chk_unique_name',1);
21: --
22: open c1;
23: --
24: fetch c1 into l_exists;

Line 60: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',1);

56: where parent_spine_id = p_pspine_id;
57: --
58: begin
59: --
60: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',1);
61: --
62: open c2;
63: --
64: fetch c2 into l_exists1;

Line 74: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',2);

70: END IF;
71: --
72: close c2;
73: --
74: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',2);
75: --
76: open c3;
77: --
78: fetch c3 into l_exists2;

Line 88: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',3);

84: END IF;
85: --
86: close c3;
87: --
88: hr_utility.set_location('per_parent_spines_pkg.stb_del_validation',3);
89: --
90: open c4;
91: --
92: fetch c4 into l_exists3;

Line 109: select per_parent_spines_s.nextval

105:
106: procedure get_id(p_pspine_id IN OUT NOCOPY NUMBER) is
107:
108: cursor c5 is
109: select per_parent_spines_s.nextval
110: from sys.dual;
111: --
112: begin
113: --

Line 114: hr_utility.set_location('per_parent_spines_pkg.get_id',1);

110: from sys.dual;
111: --
112: begin
113: --
114: hr_utility.set_location('per_parent_spines_pkg.get_id',1);
115: --
116: open c5;
117: --
118: fetch c5 into p_pspine_id;

Line 137: hr_utility.set_location('per_parent_spines_pkg.get_name',1);

133: and lookup_code = p_incp;
134: --
135: begin
136: --
137: hr_utility.set_location('per_parent_spines_pkg.get_name',1);
138: --
139: open c6;
140: --
141: fetch c6 into p_dinc;

Line 150: end PER_PARENT_SPINES_PKG;

146:
147:
148:
149:
150: end PER_PARENT_SPINES_PKG;