APPS.OTA_NHS_BUS dependencies on OTA_NHS_SHD

Line 173: (p_rec in ota_nhs_shd.g_rec_type

169: -- Internal Row Handler Use Only.
170: --
171: -- ----------------------------------------------------------------------------
172: procedure chk_df
173: (p_rec in ota_nhs_shd.g_rec_type
174: ) is
175: --
176: l_proc varchar2(72) := g_package || 'chk_df';
177: --

Line 182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>

178: begin
179: hr_utility.set_location('Entering:'||l_proc,10);
180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>

Line 184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>

180: --
181: if ((p_rec.nota_history_id is not null) and (
182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>

Line 186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>

182: nvl(ota_nhs_shd.g_old_rec.nth_information_category, hr_api.g_varchar2) <>
183: nvl(p_rec.nth_information_category, hr_api.g_varchar2) or
184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>

Line 188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>

184: nvl(ota_nhs_shd.g_old_rec.nth_information1, hr_api.g_varchar2) <>
185: nvl(p_rec.nth_information1, hr_api.g_varchar2) or
186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>

Line 190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>

186: nvl(ota_nhs_shd.g_old_rec.nth_information2, hr_api.g_varchar2) <>
187: nvl(p_rec.nth_information2, hr_api.g_varchar2) or
188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>

Line 192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>

188: nvl(ota_nhs_shd.g_old_rec.nth_information3, hr_api.g_varchar2) <>
189: nvl(p_rec.nth_information3, hr_api.g_varchar2) or
190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>

Line 194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>

190: nvl(ota_nhs_shd.g_old_rec.nth_information4, hr_api.g_varchar2) <>
191: nvl(p_rec.nth_information4, hr_api.g_varchar2) or
192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>

Line 196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>

192: nvl(ota_nhs_shd.g_old_rec.nth_information5, hr_api.g_varchar2) <>
193: nvl(p_rec.nth_information5, hr_api.g_varchar2) or
194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>

Line 198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>

194: nvl(ota_nhs_shd.g_old_rec.nth_information6, hr_api.g_varchar2) <>
195: nvl(p_rec.nth_information6, hr_api.g_varchar2) or
196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>

Line 200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>

196: nvl(ota_nhs_shd.g_old_rec.nth_information7, hr_api.g_varchar2) <>
197: nvl(p_rec.nth_information7, hr_api.g_varchar2) or
198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>

Line 202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>

198: nvl(ota_nhs_shd.g_old_rec.nth_information8, hr_api.g_varchar2) <>
199: nvl(p_rec.nth_information8, hr_api.g_varchar2) or
200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>

Line 204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>

200: nvl(ota_nhs_shd.g_old_rec.nth_information9, hr_api.g_varchar2) <>
201: nvl(p_rec.nth_information9, hr_api.g_varchar2) or
202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>

Line 206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>

202: nvl(ota_nhs_shd.g_old_rec.nth_information10, hr_api.g_varchar2) <>
203: nvl(p_rec.nth_information10, hr_api.g_varchar2) or
204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>

Line 208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>

204: nvl(ota_nhs_shd.g_old_rec.nth_information11, hr_api.g_varchar2) <>
205: nvl(p_rec.nth_information11, hr_api.g_varchar2) or
206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>

Line 210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>

206: nvl(ota_nhs_shd.g_old_rec.nth_information12, hr_api.g_varchar2) <>
207: nvl(p_rec.nth_information12, hr_api.g_varchar2) or
208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>

Line 212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>

208: nvl(ota_nhs_shd.g_old_rec.nth_information13, hr_api.g_varchar2) <>
209: nvl(p_rec.nth_information13, hr_api.g_varchar2) or
210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>

Line 214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>

210: nvl(ota_nhs_shd.g_old_rec.nth_information14, hr_api.g_varchar2) <>
211: nvl(p_rec.nth_information14, hr_api.g_varchar2) or
212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>

Line 216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>

212: nvl(ota_nhs_shd.g_old_rec.nth_information15, hr_api.g_varchar2) <>
213: nvl(p_rec.nth_information15, hr_api.g_varchar2) or
214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>

Line 218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>

214: nvl(ota_nhs_shd.g_old_rec.nth_information16, hr_api.g_varchar2) <>
215: nvl(p_rec.nth_information16, hr_api.g_varchar2) or
216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>

Line 220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>

216: nvl(ota_nhs_shd.g_old_rec.nth_information17, hr_api.g_varchar2) <>
217: nvl(p_rec.nth_information17, hr_api.g_varchar2) or
218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317

Line 222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>

218: nvl(ota_nhs_shd.g_old_rec.nth_information18, hr_api.g_varchar2) <>
219: nvl(p_rec.nth_information18, hr_api.g_varchar2) or
220: nvl(ota_nhs_shd.g_old_rec.nth_information19, hr_api.g_varchar2) <>
221: nvl(p_rec.nth_information19, hr_api.g_varchar2) or
222: nvl(ota_nhs_shd.g_old_rec.nth_information20, hr_api.g_varchar2) <>
223: nvl(p_rec.nth_information20, hr_api.g_varchar2) )
224: -- or (p_rec.nota_history_id is not null) ) then Bug 2483317
225: or (p_rec.nota_history_id is null) ) then
226:

Line 312: ,p_rec in ota_nhs_shd.g_rec_type

308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure chk_non_updateable_args
311: (p_effective_date in date
312: ,p_rec in ota_nhs_shd.g_rec_type
313: ) IS
314: --
315: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
316: l_error EXCEPTION;

Line 324: IF NOT ota_nhs_shd.api_updating

320: --
321: -- Only proceed with the validation if a row exists for the current
322: -- record in the HR Schema.
323: --
324: IF NOT ota_nhs_shd.api_updating
325: (p_nota_history_id => p_rec.nota_history_id
326: ,p_object_version_number => p_rec.object_version_number
327: ) THEN
328: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)

331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)
336: then
337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;

Line 341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)

337: l_argument := 'business_group_id';
338: raise l_error;
339: end if;
340: if nvl(p_rec.customer_id,hr_api.g_number) <>
341: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number)
342: then
343: l_argument := 'customer_id';
344: raise l_error;
345: end if;

Line 347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)

343: l_argument := 'customer_id';
344: raise l_error;
345: end if;
346: if nvl(p_rec.organization_id,hr_api.g_number) <>
347: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number)
348: then
349: l_argument := 'organization_id';
350: raise l_error;
351: end if;

Line 353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)

349: l_argument := 'organization_id';
350: raise l_error;
351: end if;
352: if nvl(p_rec.person_id,hr_api.g_number) <>
353: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number)
354: then
355: l_argument := 'person_id';
356: raise l_error;
357: end if;

Line 405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>

401: ota_nhs_bus.get_profile_value(l_cross_business_group,
402: l_business_group_id );
403:
404: if (((p_nota_history_id is not null) and
405: nvl(ota_nhs_shd.g_old_rec.organization_id,hr_api.g_number) <>
406: nvl(p_organization_id,hr_api.g_number))
407: or (p_nota_history_id is null)) then
408: --
409: hr_utility.set_location('Entering:'||l_proc, 10);

Line 466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>

462: Begin
463: hr_utility.set_location('Entering:'||l_proc, 5);
464:
465: if (((p_nota_history_id is not null) and
466: nvl(ota_nhs_shd.g_old_rec.customer_id,hr_api.g_number) <>
467: nvl(p_customer_id,hr_api.g_number))
468: or (p_nota_history_id is null)) then
469: --
470: hr_utility.set_location('Entering:'||l_proc, 10);

Line 554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>

550: l_business_group_id );
551:
552:
553: if (((p_nota_history_id is not null) and
554: nvl(ota_nhs_shd.g_old_rec.person_id,hr_api.g_number) <>
555: nvl(p_person_id,hr_api.g_number))
556: or (p_nota_history_id is null)) then
557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);

Line 654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>

650: Begin
651: hr_utility.set_location('Entering:'||l_proc, 5);
652:
653: if (((p_nota_history_id is not null) and
654: nvl(ota_nhs_shd.g_old_rec.contact_id,hr_api.g_number) <>
655: nvl(p_contact_id,hr_api.g_number))
656: or (p_nota_history_id is null)) then
657: --
658: hr_utility.set_location('Entering:'||l_proc, 10);

Line 716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>

712: ,p_argument_value =>p_effective_date);
713:
714:
715: if (((p_nota_history_id is not null) and
716: nvl(ota_nhs_shd.g_old_rec.status,hr_api.g_varchar2) <>
717: nvl(p_status,hr_api.g_varchar2))
718: or
719: (p_nota_history_id is null)) then
720:

Line 766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>

762: ,p_argument => 'effective_date'
763: ,p_argument_value => p_effective_date);
764:
765: if (((p_nota_history_id is not null) and
766: nvl(ota_nhs_shd.g_old_rec.type,hr_api.g_varchar2) <>
767: nvl(p_type,hr_api.g_varchar2))
768: or
769: (p_nota_history_id is null)) then
770:

Line 819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>

815: ,p_argument_value => p_effective_date);
816:
817:
818: if (((p_nota_history_id is not null) and
819: nvl(ota_nhs_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
820: nvl(p_duration_units,hr_api.g_varchar2))
821: or
822: (p_nota_history_id is null)) then
823:

Line 919: p_rec in ota_nhs_shd.g_rec_type) is

915: -- ----------------------------------------------------------------------------
916: -- |---------------------------< insert_validate >----------------------------|
917: -- ----------------------------------------------------------------------------
918: Procedure insert_validate(p_effective_date in date,
919: p_rec in ota_nhs_shd.g_rec_type) is
920: --
921: l_proc varchar2(72) := g_package||'insert_validate';
922: --
923: Begin

Line 980: p_rec in ota_nhs_shd.g_rec_type) is

976: -- ----------------------------------------------------------------------------
977: -- |---------------------------< update_validate >----------------------------|
978: -- ----------------------------------------------------------------------------
979: Procedure update_validate(p_effective_date in date,
980: p_rec in ota_nhs_shd.g_rec_type) is
981: --
982: l_proc varchar2(72) := g_package||'update_validate';
983: --
984: Begin

Line 1046: Procedure delete_validate(p_rec in ota_nhs_shd.g_rec_type) is

1042: --
1043: -- ----------------------------------------------------------------------------
1044: -- |---------------------------< delete_validate >----------------------------|
1045: -- ----------------------------------------------------------------------------
1046: Procedure delete_validate(p_rec in ota_nhs_shd.g_rec_type) is
1047: --
1048: l_proc varchar2(72) := g_package||'delete_validate';
1049: --
1050: Begin