APPS.OTA_RUD_BUS dependencies on OTA_RUD_SHD

Line 193: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_PK');

189: open c1;
190: fetch c1
191: into l_ok;
192: if (c1%found) then
193: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_PK');
194: end if;
195: close c1;
196: --
197: hr_utility.set_location (' leaving:' || l_proc, 10);

Line 222: ota_rud_shd.constraint_error ('OTA_RUD_DATES');

218: hr_utility.set_location ('entering:' || l_proc, 5);
219: --
220: if (p_start_date
221: > nvl (p_end_date, to_date ('31-12-4712', 'DD-MM-YYYY'))) then
222: ota_rud_shd.constraint_error ('OTA_RUD_DATES');
223: end if;
224: --
225: hr_utility.set_location (' leaving:' || l_proc, 5);
226: --

Line 263: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK2');

259: fetch c1
260: into l_off_start_date,
261: l_off_end_date;
262: if (c1%notfound) then
263: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK2');
264: end if;
265: close c1;
266: --
267: -- Start date in range ?

Line 272: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');

268: --
269: if (p_start_date
270: not between l_off_start_date
271: and nvl (l_off_end_date, hr_general.end_of_time)) then
272: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');
273: end if;
274: --
275: -- End date in range ?
276: --

Line 281: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');

277: if ( (p_end_date is not null)
278: and (p_end_date
279: not between l_off_start_date
280: and nvl (l_off_end_date, hr_general.end_of_time))) then
281: ota_rud_shd.constraint_error ('OTA_RUD_TAV_DATES');
282: end if;
283: --
284: hr_utility.set_location (' leaving:' || l_proc, 5);
285: --

Line 320: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK1');

316: fetch c1
317: into l_tsr_start_date,
318: l_tsr_end_date;
319: if (c1%notfound) then
320: ota_rud_shd.constraint_error ('OTA_RESOURCE_USAGES_FK1');
321: end if;
322: close c1;
323: --
324: -- Start date in range ?

Line 329: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');

325: --
326: if (p_start_date
327: not between l_tsr_start_date
328: and nvl (l_tsr_end_date, hr_general.end_of_time)) then
329: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');
330: end if;
331: --
332: -- End date in range ?
333: --

Line 338: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');

334: if ( (p_end_date is not null)
335: and (p_end_date
336: not between l_tsr_start_date
337: and nvl (l_tsr_end_date, hr_general.end_of_time))) then
338: ota_rud_shd.constraint_error ('OTA_RUD_TSR_DATES');
339: end if;
340: --
341: hr_utility.set_location (' leaving:' || l_proc, 10);
342: --

Line 377: ota_rud_shd.constraint_error ('OTA_RUD_BUSINESS_GROUPS');

373: fetch c1
374: into l_ok;
375: if (c1%notfound) then
376: close c1;
377: ota_rud_shd.constraint_error ('OTA_RUD_BUSINESS_GROUPS');
378: end if;
379: close c1;
380: --
381: hr_utility.set_location (' Leaving:' || l_proc, 10);

Line 434: ota_rud_shd.constraint_error ('OTA_RUD_RESOURCE_ROLE');

430: hr_utility.set_location ('Entering' || l_proc, 10);
431: --
432: If p_role_to_play is not null then
433: If p_resource_type is not null and p_resource_type <> 'T' then
434: ota_rud_shd.constraint_error ('OTA_RUD_RESOURCE_ROLE');
435: Else
436: --
437: open cur_res_type;
438: fetch cur_res_type into l_res_type;

Line 442: ota_rud_shd.constraint_error ('OTA_RUD_RESOURCE_ROLE');

438: fetch cur_res_type into l_res_type;
439: close cur_res_type;
440: --
441: If l_res_type is not null and l_res_type <> 'T' then
442: ota_rud_shd.constraint_error ('OTA_RUD_RESOURCE_ROLE');
443: End If;
444: --
445: End If;
446: --

Line 529: (p_rec in ota_rud_shd.g_rec_type

525: -- ------------------------------< validity_checks >--------------------------|
526: -- ----------------------------------------------------------------------------
527: --
528: procedure validity_checks
529: (p_rec in ota_rud_shd.g_rec_type
530: ) is
531: --
532: l_proc varchar2 (72) := g_package || 'check_usage_reason';
533: l_resource_type ota_suppliable_resources.resource_type%Type;

Line 576: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');

572: -- specified resource ?
573: --
574: if (p_rec.supplied_resource_id is not null) then
575: if (p_rec.resource_type is not null) then
576: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');
577: end if;
578: --
579: check_tsr
580: (p_supplied_resource_id => p_rec.supplied_resource_id

Line 594: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');

590: -- Type of resource ?
591: --
592: elsif (p_rec.resource_type is not null) then
593: if (p_rec.supplied_resource_id is not null) then
594: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');
595: end if;
596: --
597: check_resource_type
598: (p_resource_type => p_rec.resource_type

Line 602: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');

598: (p_resource_type => p_rec.resource_type
599: );
600: --
601: else
602: ota_rud_shd.constraint_error ('OTA_RUD_EXCLUSIVITY');
603: end if;
604: --
605: check_role
606: (p_role_to_play => p_rec.role_to_play

Line 614: ota_rud_shd.constraint_error ('OTA_RUD_REQUIRED');

610: --
611: -- Required ?
612: --
613: if (p_rec.required_flag not in ('Y', 'N')) then
614: ota_rud_shd.constraint_error ('OTA_RUD_REQUIRED');
615: end if;
616: --
617: -- Reason
618: --

Line 656: (p_rec in ota_rud_shd.g_rec_type

652: -- Internal Row Handler Use Only.
653: --
654: -- ----------------------------------------------------------------------------
655: procedure chk_ddf
656: (p_rec in ota_rud_shd.g_rec_type
657: ) is
658: --
659: l_proc varchar2(72) := g_package || 'chk_ddf';
660: --

Line 665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>

661: begin
662: hr_utility.set_location('Entering:'||l_proc,10);
663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>

Line 667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>

663: --
664: if ((p_rec.resource_usage_id is not null) and (
665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>

Line 669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>

665: nvl(ota_rud_shd.g_old_rec.rud_information_category, hr_api.g_varchar2) <>
666: nvl(p_rec.rud_information_category, hr_api.g_varchar2) or
667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>

Line 671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>

667: nvl(ota_rud_shd.g_old_rec.rud_information1, hr_api.g_varchar2) <>
668: nvl(p_rec.rud_information1, hr_api.g_varchar2) or
669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>

Line 673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>

669: nvl(ota_rud_shd.g_old_rec.rud_information2, hr_api.g_varchar2) <>
670: nvl(p_rec.rud_information2, hr_api.g_varchar2) or
671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>

Line 675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>

671: nvl(ota_rud_shd.g_old_rec.rud_information3, hr_api.g_varchar2) <>
672: nvl(p_rec.rud_information3, hr_api.g_varchar2) or
673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>

Line 677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>

673: nvl(ota_rud_shd.g_old_rec.rud_information4, hr_api.g_varchar2) <>
674: nvl(p_rec.rud_information4, hr_api.g_varchar2) or
675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>

Line 679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>

675: nvl(ota_rud_shd.g_old_rec.rud_information5, hr_api.g_varchar2) <>
676: nvl(p_rec.rud_information5, hr_api.g_varchar2) or
677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>

Line 681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>

677: nvl(ota_rud_shd.g_old_rec.rud_information6, hr_api.g_varchar2) <>
678: nvl(p_rec.rud_information6, hr_api.g_varchar2) or
679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>

Line 683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>

679: nvl(ota_rud_shd.g_old_rec.rud_information7, hr_api.g_varchar2) <>
680: nvl(p_rec.rud_information7, hr_api.g_varchar2) or
681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>

Line 685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>

681: nvl(ota_rud_shd.g_old_rec.rud_information8, hr_api.g_varchar2) <>
682: nvl(p_rec.rud_information8, hr_api.g_varchar2) or
683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>

Line 687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>

683: nvl(ota_rud_shd.g_old_rec.rud_information9, hr_api.g_varchar2) <>
684: nvl(p_rec.rud_information9, hr_api.g_varchar2) or
685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>

Line 689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>

685: nvl(ota_rud_shd.g_old_rec.rud_information10, hr_api.g_varchar2) <>
686: nvl(p_rec.rud_information10, hr_api.g_varchar2) or
687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>

Line 691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>

687: nvl(ota_rud_shd.g_old_rec.rud_information11, hr_api.g_varchar2) <>
688: nvl(p_rec.rud_information11, hr_api.g_varchar2) or
689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>

Line 693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>

689: nvl(ota_rud_shd.g_old_rec.rud_information12, hr_api.g_varchar2) <>
690: nvl(p_rec.rud_information12, hr_api.g_varchar2) or
691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>

Line 695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>

691: nvl(ota_rud_shd.g_old_rec.rud_information13, hr_api.g_varchar2) <>
692: nvl(p_rec.rud_information13, hr_api.g_varchar2) or
693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>

Line 697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>

693: nvl(ota_rud_shd.g_old_rec.rud_information14, hr_api.g_varchar2) <>
694: nvl(p_rec.rud_information14, hr_api.g_varchar2) or
695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>

Line 699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>

695: nvl(ota_rud_shd.g_old_rec.rud_information15, hr_api.g_varchar2) <>
696: nvl(p_rec.rud_information15, hr_api.g_varchar2) or
697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>

Line 701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>

697: nvl(ota_rud_shd.g_old_rec.rud_information16, hr_api.g_varchar2) <>
698: nvl(p_rec.rud_information16, hr_api.g_varchar2) or
699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>

Line 703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>

699: nvl(ota_rud_shd.g_old_rec.rud_information17, hr_api.g_varchar2) <>
700: nvl(p_rec.rud_information17, hr_api.g_varchar2) or
701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then

Line 705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>

701: nvl(ota_rud_shd.g_old_rec.rud_information18, hr_api.g_varchar2) <>
702: nvl(p_rec.rud_information18, hr_api.g_varchar2) or
703: nvl(ota_rud_shd.g_old_rec.rud_information19, hr_api.g_varchar2) <>
704: nvl(p_rec.rud_information19, hr_api.g_varchar2) or
705: nvl(ota_rud_shd.g_old_rec.rud_information20, hr_api.g_varchar2) <>
706: nvl(p_rec.rud_information20, hr_api.g_varchar2) ))
707: or (p_rec.resource_usage_id is null) then
708: --
709: -- Only execute the validation if absolutely necessary:

Line 793: ,p_rec in ota_rud_shd.g_rec_type

789: -- {End Of Comments}
790: -- ----------------------------------------------------------------------------
791: Procedure chk_non_updateable_args
792: (p_effective_date in date
793: ,p_rec in ota_rud_shd.g_rec_type
794: ) IS
795: --
796: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
797: --

Line 803: IF NOT ota_rud_shd.api_updating

799: --
800: -- Only proceed with the validation if a row exists for the current
801: -- record in the HR Schema.
802: --
803: IF NOT ota_rud_shd.api_updating
804: (p_resource_usage_id => p_rec.resource_usage_id
805: ,p_object_version_number => p_rec.object_version_number
806: ) THEN
807: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 823: ,p_rec in ota_rud_shd.g_rec_type

819: -- |---------------------------< insert_validate >----------------------------|
820: -- ----------------------------------------------------------------------------
821: Procedure insert_validate
822: (p_effective_date in date
823: ,p_rec in ota_rud_shd.g_rec_type
824: ) is
825: --
826: l_proc varchar2(72) := g_package||'insert_validate';
827: --

Line 853: ,p_rec in ota_rud_shd.g_rec_type

849: -- |---------------------------< update_validate >----------------------------|
850: -- ----------------------------------------------------------------------------
851: Procedure update_validate
852: (p_effective_date in date
853: ,p_rec in ota_rud_shd.g_rec_type
854: ) is
855: --
856: l_proc varchar2(72) := g_package||'update_validate';
857: --

Line 865: <> nvl (ota_rud_shd.g_old_rec.SUPPLIED_RESOURCE_ID, 0))

861: -- Call all supporting business operations
862: ota_off_bus.set_security_group_id(p_rec.offering_id);
863: --
864: if ( (nvl (P_REC.SUPPLIED_RESOURCE_ID, 0)
865: <> nvl (ota_rud_shd.g_old_rec.SUPPLIED_RESOURCE_ID, 0))
866: or (nvl (P_REC.OFFERING_ID, 0)
867: <> nvl (ota_rud_shd.g_old_rec.OFFERING_ID, 0))) then
868: ota_rud_shd.constraint_error ('OTA_RUD_NON_TRANSFER');
869: end if;

Line 867: <> nvl (ota_rud_shd.g_old_rec.OFFERING_ID, 0))) then

863: --
864: if ( (nvl (P_REC.SUPPLIED_RESOURCE_ID, 0)
865: <> nvl (ota_rud_shd.g_old_rec.SUPPLIED_RESOURCE_ID, 0))
866: or (nvl (P_REC.OFFERING_ID, 0)
867: <> nvl (ota_rud_shd.g_old_rec.OFFERING_ID, 0))) then
868: ota_rud_shd.constraint_error ('OTA_RUD_NON_TRANSFER');
869: end if;
870: --
871: VALIDITY_CHECKS (

Line 868: ota_rud_shd.constraint_error ('OTA_RUD_NON_TRANSFER');

864: if ( (nvl (P_REC.SUPPLIED_RESOURCE_ID, 0)
865: <> nvl (ota_rud_shd.g_old_rec.SUPPLIED_RESOURCE_ID, 0))
866: or (nvl (P_REC.OFFERING_ID, 0)
867: <> nvl (ota_rud_shd.g_old_rec.OFFERING_ID, 0))) then
868: ota_rud_shd.constraint_error ('OTA_RUD_NON_TRANSFER');
869: end if;
870: --
871: VALIDITY_CHECKS (
872: p_rec => p_rec);

Line 890: (p_rec in ota_rud_shd.g_rec_type

886: -- ----------------------------------------------------------------------------
887: -- |---------------------------< delete_validate >----------------------------|
888: -- ----------------------------------------------------------------------------
889: Procedure delete_validate
890: (p_rec in ota_rud_shd.g_rec_type
891: ) is
892: --
893: l_proc varchar2(72) := g_package||'delete_validate';
894: --