[Home] [Help]
74: from ota_skill_provisions
75: where analysis_criteria_id = p_analysis_criteria_id;
76: --
77: begin
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: if p_person_id is not null then
81: --
82: hr_utility.set_location('Entering:'||l_proc, 10);
78: hr_utility.set_location('Entering:'||l_proc, 5);
79: --
80: if p_person_id is not null then
81: --
82: hr_utility.set_location('Entering:'||l_proc, 10);
83: open c_activity_versions1;
84: fetch c_activity_versions1 into l_exists;
85: if c_activity_versions1%found then
86: close c_activity_versions1;
90: fnd_message.raise_error;
91: end if;
92: close c_activity_versions1;
93: --
94: hr_utility.set_location('Entering:'||l_proc, 15);
95: open c_delegate_bookings1;
96: fetch c_delegate_bookings1 into l_exists;
97: if c_delegate_bookings1%found then
98: close c_delegate_bookings1;
102: fnd_message.raise_error;
103: end if;
104: close c_delegate_bookings1;
105: --
106: hr_utility.set_location('Entering:'||l_proc, 20);
107: open c_delegate_bookings2;
108: fetch c_delegate_bookings2 into l_exists;
109: if c_delegate_bookings2%found then
110: close c_delegate_bookings2;
116: close c_delegate_bookings2;
117: --
118: elsif p_organization_id is not null then
119: --
120: hr_utility.set_location('Entering:'||l_proc, 25);
121: open c_events;
122: fetch c_events into l_exists;
123: if c_events%found then
124: close c_events;
128: fnd_message.raise_error;
129: end if;
130: close c_events;
131: --
132: hr_utility.set_location('Entering:'||l_proc, 30);
133: open c_activity_versions2;
134: fetch c_activity_versions2 into l_exists;
135: if c_activity_versions2%found then
136: close c_activity_versions2;
140: fnd_message.raise_error;
141: end if;
142: close c_activity_versions2;
143: --
144: hr_utility.set_location('Entering:'||l_proc, 35);
145: open c_finance_headers1;
146: fetch c_finance_headers1 into l_exists;
147: if c_finance_headers1%found then
148: close c_finance_headers1;
152: fnd_message.raise_error;
153: end if;
154: close c_finance_headers1;
155: --
156: hr_utility.set_location('Entering:'||l_proc, 40);
157: open c_delegate_bookings3;
158: fetch c_delegate_bookings3 into l_exists;
159: if c_delegate_bookings3%found then
160: close c_delegate_bookings3;
164: fnd_message.raise_error;
165: end if;
166: close c_delegate_bookings3;
167: --
168: hr_utility.set_location('Entering:'||l_proc, 45);
169: open c_event_associations1;
170: fetch c_event_associations1 into l_exists;
171: if c_event_associations1%found then
172: close c_event_associations1;
178: close c_event_associations1;
179: --
180: elsif p_job_id is not null then
181: --
182: hr_utility.set_location('Entering:'||l_proc, 50);
183: open c_event_associations2;
184: fetch c_event_associations2 into l_exists;
185: if c_event_associations2%found then
186: close c_event_associations2;
192: close c_event_associations2;
193: --
194: elsif p_position_id is not null then
195: --
196: hr_utility.set_location('Entering:'||l_proc, 55);
197: open c_event_associations3;
198: fetch c_event_associations3 into l_exists;
199: if c_event_associations3%found then
200: close c_event_associations3;
206: close c_event_associations3;
207: --
208: elsif p_address_id is not null then
209: --
210: hr_utility.set_location('Entering:'||l_proc, 60);
211: open c_delegate_bookings4;
212: fetch c_delegate_bookings4 into l_exists;
213: if c_delegate_bookings4%found then
214: close c_delegate_bookings4;
220: close c_delegate_bookings4;
221: --
222: elsif p_analysis_criteria_id is not null then
223: --
224: hr_utility.set_location('Entering:'||l_proc, 65);
225: open c_skill_provisions;
226: fetch c_skill_provisions into l_exists;
227: if c_skill_provisions%found then
228: close c_skill_provisions;
234: close c_skill_provisions;
235: --
236: end if;
237: --
238: hr_utility.set_location(' Leaving:'||l_proc, 70);
239: end;
240: --
241: end ota_hr_delete;