eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_IOF_UPD dependencies on HR_API

Line 130: when hr_api.check_integrity_violated then

126: --
127: hr_utility.set_location(' leaving:'||l_proc, 10);
128: --
129: exception
130: when hr_api.check_integrity_violated then
131: -- a check constraint has been violated
132: --
133: irc_iof_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

130: when hr_api.check_integrity_violated then
131: -- a check constraint has been violated
132: --
133: irc_iof_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
135: when hr_api.parent_integrity_violated then
136: -- parent integrity has been violated
137: --
138: irc_iof_shd.constraint_error

Line 135: when hr_api.parent_integrity_violated then

131: -- a check constraint has been violated
132: --
133: irc_iof_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
135: when hr_api.parent_integrity_violated then
136: -- parent integrity has been violated
137: --
138: irc_iof_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

135: when hr_api.parent_integrity_violated then
136: -- parent integrity has been violated
137: --
138: irc_iof_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
140: when hr_api.unique_integrity_violated then
141: -- unique integrity has been violated
142: --
143: irc_iof_shd.constraint_error

Line 140: when hr_api.unique_integrity_violated then

136: -- parent integrity has been violated
137: --
138: irc_iof_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
140: when hr_api.unique_integrity_violated then
141: -- unique integrity has been violated
142: --
143: irc_iof_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

Line 144: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));

140: when hr_api.unique_integrity_violated then
141: -- unique integrity has been violated
142: --
143: irc_iof_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(sqlerrm));
145: when others then
146: --
147: raise;
148: end update_dml;

Line 445: when hr_api.cannot_find_prog_unit then

441: );
442: --
443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'irc_offers'
449: ,p_hook_type => 'au');

Line 447: hr_api.cannot_find_prog_unit_error

443: exception
444: --
445: when hr_api.cannot_find_prog_unit then
446: --
447: hr_api.cannot_find_prog_unit_error
448: (p_module_name => 'irc_offers'
449: ,p_hook_type => 'au');
450: --
451: end;

Line 510: if (p_rec.offer_version = hr_api.g_number) then

506: -- p_rec plsql record structure
507: -- to see if a system default is being used. if a system default
508: -- is being used then we must set to the 'current' argument value.
509: --
510: if (p_rec.offer_version = hr_api.g_number) then
511: p_rec.offer_version :=
512: irc_iof_shd.g_old_rec.offer_version;
513: end if;
514: if (p_rec.latest_offer = hr_api.g_varchar2) then

Line 514: if (p_rec.latest_offer = hr_api.g_varchar2) then

510: if (p_rec.offer_version = hr_api.g_number) then
511: p_rec.offer_version :=
512: irc_iof_shd.g_old_rec.offer_version;
513: end if;
514: if (p_rec.latest_offer = hr_api.g_varchar2) then
515: p_rec.latest_offer :=
516: irc_iof_shd.g_old_rec.latest_offer;
517: end if;
518: if (p_rec.offer_status = hr_api.g_varchar2) then

Line 518: if (p_rec.offer_status = hr_api.g_varchar2) then

514: if (p_rec.latest_offer = hr_api.g_varchar2) then
515: p_rec.latest_offer :=
516: irc_iof_shd.g_old_rec.latest_offer;
517: end if;
518: if (p_rec.offer_status = hr_api.g_varchar2) then
519: p_rec.offer_status :=
520: irc_iof_shd.g_old_rec.offer_status;
521: end if;
522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then

Line 522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then

518: if (p_rec.offer_status = hr_api.g_varchar2) then
519: p_rec.offer_status :=
520: irc_iof_shd.g_old_rec.offer_status;
521: end if;
522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then
523: p_rec.discretionary_job_title :=
524: irc_iof_shd.g_old_rec.discretionary_job_title;
525: end if;
526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then

Line 526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then

522: if (p_rec.discretionary_job_title = hr_api.g_varchar2) then
523: p_rec.discretionary_job_title :=
524: irc_iof_shd.g_old_rec.discretionary_job_title;
525: end if;
526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then
527: p_rec.offer_extended_method :=
528: irc_iof_shd.g_old_rec.offer_extended_method;
529: end if;
530: if (p_rec.respondent_id = hr_api.g_number) then

Line 530: if (p_rec.respondent_id = hr_api.g_number) then

526: if (p_rec.offer_extended_method = hr_api.g_varchar2) then
527: p_rec.offer_extended_method :=
528: irc_iof_shd.g_old_rec.offer_extended_method;
529: end if;
530: if (p_rec.respondent_id = hr_api.g_number) then
531: p_rec.respondent_id :=
532: irc_iof_shd.g_old_rec.respondent_id;
533: end if;
534: if (p_rec.expiry_date = hr_api.g_date) then

Line 534: if (p_rec.expiry_date = hr_api.g_date) then

530: if (p_rec.respondent_id = hr_api.g_number) then
531: p_rec.respondent_id :=
532: irc_iof_shd.g_old_rec.respondent_id;
533: end if;
534: if (p_rec.expiry_date = hr_api.g_date) then
535: p_rec.expiry_date :=
536: irc_iof_shd.g_old_rec.expiry_date;
537: end if;
538: if (p_rec.proposed_start_date = hr_api.g_date) then

Line 538: if (p_rec.proposed_start_date = hr_api.g_date) then

534: if (p_rec.expiry_date = hr_api.g_date) then
535: p_rec.expiry_date :=
536: irc_iof_shd.g_old_rec.expiry_date;
537: end if;
538: if (p_rec.proposed_start_date = hr_api.g_date) then
539: p_rec.proposed_start_date :=
540: irc_iof_shd.g_old_rec.proposed_start_date;
541: end if;
542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then

Line 542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then

538: if (p_rec.proposed_start_date = hr_api.g_date) then
539: p_rec.proposed_start_date :=
540: irc_iof_shd.g_old_rec.proposed_start_date;
541: end if;
542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then
543: p_rec.offer_letter_tracking_code :=
544: irc_iof_shd.g_old_rec.offer_letter_tracking_code;
545: end if;
546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then

Line 546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then

542: if (p_rec.offer_letter_tracking_code = hr_api.g_varchar2) then
543: p_rec.offer_letter_tracking_code :=
544: irc_iof_shd.g_old_rec.offer_letter_tracking_code;
545: end if;
546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then
547: p_rec.offer_postal_service :=
548: irc_iof_shd.g_old_rec.offer_postal_service;
549: end if;
550: if (p_rec.offer_shipping_date = hr_api.g_date) then

Line 550: if (p_rec.offer_shipping_date = hr_api.g_date) then

546: if (p_rec.offer_postal_service = hr_api.g_varchar2) then
547: p_rec.offer_postal_service :=
548: irc_iof_shd.g_old_rec.offer_postal_service;
549: end if;
550: if (p_rec.offer_shipping_date = hr_api.g_date) then
551: p_rec.offer_shipping_date :=
552: irc_iof_shd.g_old_rec.offer_shipping_date;
553: end if;
554: if (p_rec.vacancy_id = hr_api.g_number) then

Line 554: if (p_rec.vacancy_id = hr_api.g_number) then

550: if (p_rec.offer_shipping_date = hr_api.g_date) then
551: p_rec.offer_shipping_date :=
552: irc_iof_shd.g_old_rec.offer_shipping_date;
553: end if;
554: if (p_rec.vacancy_id = hr_api.g_number) then
555: p_rec.vacancy_id :=
556: irc_iof_shd.g_old_rec.vacancy_id;
557: end if;
558: if (p_rec.applicant_assignment_id = hr_api.g_number) then

Line 558: if (p_rec.applicant_assignment_id = hr_api.g_number) then

554: if (p_rec.vacancy_id = hr_api.g_number) then
555: p_rec.vacancy_id :=
556: irc_iof_shd.g_old_rec.vacancy_id;
557: end if;
558: if (p_rec.applicant_assignment_id = hr_api.g_number) then
559: p_rec.applicant_assignment_id :=
560: irc_iof_shd.g_old_rec.applicant_assignment_id;
561: end if;
562: if (p_rec.offer_assignment_id = hr_api.g_number) then

Line 562: if (p_rec.offer_assignment_id = hr_api.g_number) then

558: if (p_rec.applicant_assignment_id = hr_api.g_number) then
559: p_rec.applicant_assignment_id :=
560: irc_iof_shd.g_old_rec.applicant_assignment_id;
561: end if;
562: if (p_rec.offer_assignment_id = hr_api.g_number) then
563: p_rec.offer_assignment_id :=
564: irc_iof_shd.g_old_rec.offer_assignment_id;
565: end if;
566: if (p_rec.address_id = hr_api.g_number) then

Line 566: if (p_rec.address_id = hr_api.g_number) then

562: if (p_rec.offer_assignment_id = hr_api.g_number) then
563: p_rec.offer_assignment_id :=
564: irc_iof_shd.g_old_rec.offer_assignment_id;
565: end if;
566: if (p_rec.address_id = hr_api.g_number) then
567: p_rec.address_id :=
568: irc_iof_shd.g_old_rec.address_id;
569: end if;
570: if (p_rec.template_id = hr_api.g_number) then

Line 570: if (p_rec.template_id = hr_api.g_number) then

566: if (p_rec.address_id = hr_api.g_number) then
567: p_rec.address_id :=
568: irc_iof_shd.g_old_rec.address_id;
569: end if;
570: if (p_rec.template_id = hr_api.g_number) then
571: p_rec.template_id :=
572: irc_iof_shd.g_old_rec.template_id;
573: end if;
574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then

Line 574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then

570: if (p_rec.template_id = hr_api.g_number) then
571: p_rec.template_id :=
572: irc_iof_shd.g_old_rec.template_id;
573: end if;
574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then
575: p_rec.offer_letter_file_type :=
576: irc_iof_shd.g_old_rec.offer_letter_file_type;
577: end if;
578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then

Line 578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then

574: if (p_rec.offer_letter_file_type = hr_api.g_varchar2) then
575: p_rec.offer_letter_file_type :=
576: irc_iof_shd.g_old_rec.offer_letter_file_type;
577: end if;
578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then
579: p_rec.offer_letter_file_name :=
580: irc_iof_shd.g_old_rec.offer_letter_file_name;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then

Line 582: if (p_rec.attribute_category = hr_api.g_varchar2) then

578: if (p_rec.offer_letter_file_name = hr_api.g_varchar2) then
579: p_rec.offer_letter_file_name :=
580: irc_iof_shd.g_old_rec.offer_letter_file_name;
581: end if;
582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: irc_iof_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then

Line 586: if (p_rec.attribute1 = hr_api.g_varchar2) then

582: if (p_rec.attribute_category = hr_api.g_varchar2) then
583: p_rec.attribute_category :=
584: irc_iof_shd.g_old_rec.attribute_category;
585: end if;
586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: irc_iof_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then

Line 590: if (p_rec.attribute2 = hr_api.g_varchar2) then

586: if (p_rec.attribute1 = hr_api.g_varchar2) then
587: p_rec.attribute1 :=
588: irc_iof_shd.g_old_rec.attribute1;
589: end if;
590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: irc_iof_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then

Line 594: if (p_rec.attribute3 = hr_api.g_varchar2) then

590: if (p_rec.attribute2 = hr_api.g_varchar2) then
591: p_rec.attribute2 :=
592: irc_iof_shd.g_old_rec.attribute2;
593: end if;
594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: irc_iof_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then

Line 598: if (p_rec.attribute4 = hr_api.g_varchar2) then

594: if (p_rec.attribute3 = hr_api.g_varchar2) then
595: p_rec.attribute3 :=
596: irc_iof_shd.g_old_rec.attribute3;
597: end if;
598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: irc_iof_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then

Line 602: if (p_rec.attribute5 = hr_api.g_varchar2) then

598: if (p_rec.attribute4 = hr_api.g_varchar2) then
599: p_rec.attribute4 :=
600: irc_iof_shd.g_old_rec.attribute4;
601: end if;
602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: irc_iof_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then

Line 606: if (p_rec.attribute6 = hr_api.g_varchar2) then

602: if (p_rec.attribute5 = hr_api.g_varchar2) then
603: p_rec.attribute5 :=
604: irc_iof_shd.g_old_rec.attribute5;
605: end if;
606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: irc_iof_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then

Line 610: if (p_rec.attribute7 = hr_api.g_varchar2) then

606: if (p_rec.attribute6 = hr_api.g_varchar2) then
607: p_rec.attribute6 :=
608: irc_iof_shd.g_old_rec.attribute6;
609: end if;
610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: irc_iof_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then

Line 614: if (p_rec.attribute8 = hr_api.g_varchar2) then

610: if (p_rec.attribute7 = hr_api.g_varchar2) then
611: p_rec.attribute7 :=
612: irc_iof_shd.g_old_rec.attribute7;
613: end if;
614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: irc_iof_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then

Line 618: if (p_rec.attribute9 = hr_api.g_varchar2) then

614: if (p_rec.attribute8 = hr_api.g_varchar2) then
615: p_rec.attribute8 :=
616: irc_iof_shd.g_old_rec.attribute8;
617: end if;
618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: irc_iof_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then

Line 622: if (p_rec.attribute10 = hr_api.g_varchar2) then

618: if (p_rec.attribute9 = hr_api.g_varchar2) then
619: p_rec.attribute9 :=
620: irc_iof_shd.g_old_rec.attribute9;
621: end if;
622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: irc_iof_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then

Line 626: if (p_rec.attribute11 = hr_api.g_varchar2) then

622: if (p_rec.attribute10 = hr_api.g_varchar2) then
623: p_rec.attribute10 :=
624: irc_iof_shd.g_old_rec.attribute10;
625: end if;
626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: irc_iof_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then

Line 630: if (p_rec.attribute12 = hr_api.g_varchar2) then

626: if (p_rec.attribute11 = hr_api.g_varchar2) then
627: p_rec.attribute11 :=
628: irc_iof_shd.g_old_rec.attribute11;
629: end if;
630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: irc_iof_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then

Line 634: if (p_rec.attribute13 = hr_api.g_varchar2) then

630: if (p_rec.attribute12 = hr_api.g_varchar2) then
631: p_rec.attribute12 :=
632: irc_iof_shd.g_old_rec.attribute12;
633: end if;
634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: irc_iof_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then

Line 638: if (p_rec.attribute14 = hr_api.g_varchar2) then

634: if (p_rec.attribute13 = hr_api.g_varchar2) then
635: p_rec.attribute13 :=
636: irc_iof_shd.g_old_rec.attribute13;
637: end if;
638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: irc_iof_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then

Line 642: if (p_rec.attribute15 = hr_api.g_varchar2) then

638: if (p_rec.attribute14 = hr_api.g_varchar2) then
639: p_rec.attribute14 :=
640: irc_iof_shd.g_old_rec.attribute14;
641: end if;
642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: irc_iof_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then

Line 646: if (p_rec.attribute16 = hr_api.g_varchar2) then

642: if (p_rec.attribute15 = hr_api.g_varchar2) then
643: p_rec.attribute15 :=
644: irc_iof_shd.g_old_rec.attribute15;
645: end if;
646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: irc_iof_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then

Line 650: if (p_rec.attribute17 = hr_api.g_varchar2) then

646: if (p_rec.attribute16 = hr_api.g_varchar2) then
647: p_rec.attribute16 :=
648: irc_iof_shd.g_old_rec.attribute16;
649: end if;
650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: irc_iof_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then

Line 654: if (p_rec.attribute18 = hr_api.g_varchar2) then

650: if (p_rec.attribute17 = hr_api.g_varchar2) then
651: p_rec.attribute17 :=
652: irc_iof_shd.g_old_rec.attribute17;
653: end if;
654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: irc_iof_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then

Line 658: if (p_rec.attribute19 = hr_api.g_varchar2) then

654: if (p_rec.attribute18 = hr_api.g_varchar2) then
655: p_rec.attribute18 :=
656: irc_iof_shd.g_old_rec.attribute18;
657: end if;
658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: irc_iof_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then

Line 662: if (p_rec.attribute20 = hr_api.g_varchar2) then

658: if (p_rec.attribute19 = hr_api.g_varchar2) then
659: p_rec.attribute19 :=
660: irc_iof_shd.g_old_rec.attribute19;
661: end if;
662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: irc_iof_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.attribute21 = hr_api.g_varchar2) then

Line 666: if (p_rec.attribute21 = hr_api.g_varchar2) then

662: if (p_rec.attribute20 = hr_api.g_varchar2) then
663: p_rec.attribute20 :=
664: irc_iof_shd.g_old_rec.attribute20;
665: end if;
666: if (p_rec.attribute21 = hr_api.g_varchar2) then
667: p_rec.attribute21 :=
668: irc_iof_shd.g_old_rec.attribute21;
669: end if;
670: if (p_rec.attribute22 = hr_api.g_varchar2) then

Line 670: if (p_rec.attribute22 = hr_api.g_varchar2) then

666: if (p_rec.attribute21 = hr_api.g_varchar2) then
667: p_rec.attribute21 :=
668: irc_iof_shd.g_old_rec.attribute21;
669: end if;
670: if (p_rec.attribute22 = hr_api.g_varchar2) then
671: p_rec.attribute22 :=
672: irc_iof_shd.g_old_rec.attribute22;
673: end if;
674: if (p_rec.attribute23 = hr_api.g_varchar2) then

Line 674: if (p_rec.attribute23 = hr_api.g_varchar2) then

670: if (p_rec.attribute22 = hr_api.g_varchar2) then
671: p_rec.attribute22 :=
672: irc_iof_shd.g_old_rec.attribute22;
673: end if;
674: if (p_rec.attribute23 = hr_api.g_varchar2) then
675: p_rec.attribute23 :=
676: irc_iof_shd.g_old_rec.attribute23;
677: end if;
678: if (p_rec.attribute24 = hr_api.g_varchar2) then

Line 678: if (p_rec.attribute24 = hr_api.g_varchar2) then

674: if (p_rec.attribute23 = hr_api.g_varchar2) then
675: p_rec.attribute23 :=
676: irc_iof_shd.g_old_rec.attribute23;
677: end if;
678: if (p_rec.attribute24 = hr_api.g_varchar2) then
679: p_rec.attribute24 :=
680: irc_iof_shd.g_old_rec.attribute24;
681: end if;
682: if (p_rec.attribute25 = hr_api.g_varchar2) then

Line 682: if (p_rec.attribute25 = hr_api.g_varchar2) then

678: if (p_rec.attribute24 = hr_api.g_varchar2) then
679: p_rec.attribute24 :=
680: irc_iof_shd.g_old_rec.attribute24;
681: end if;
682: if (p_rec.attribute25 = hr_api.g_varchar2) then
683: p_rec.attribute25 :=
684: irc_iof_shd.g_old_rec.attribute25;
685: end if;
686: if (p_rec.attribute26 = hr_api.g_varchar2) then

Line 686: if (p_rec.attribute26 = hr_api.g_varchar2) then

682: if (p_rec.attribute25 = hr_api.g_varchar2) then
683: p_rec.attribute25 :=
684: irc_iof_shd.g_old_rec.attribute25;
685: end if;
686: if (p_rec.attribute26 = hr_api.g_varchar2) then
687: p_rec.attribute26 :=
688: irc_iof_shd.g_old_rec.attribute26;
689: end if;
690: if (p_rec.attribute27 = hr_api.g_varchar2) then

Line 690: if (p_rec.attribute27 = hr_api.g_varchar2) then

686: if (p_rec.attribute26 = hr_api.g_varchar2) then
687: p_rec.attribute26 :=
688: irc_iof_shd.g_old_rec.attribute26;
689: end if;
690: if (p_rec.attribute27 = hr_api.g_varchar2) then
691: p_rec.attribute27 :=
692: irc_iof_shd.g_old_rec.attribute27;
693: end if;
694: if (p_rec.attribute28 = hr_api.g_varchar2) then

Line 694: if (p_rec.attribute28 = hr_api.g_varchar2) then

690: if (p_rec.attribute27 = hr_api.g_varchar2) then
691: p_rec.attribute27 :=
692: irc_iof_shd.g_old_rec.attribute27;
693: end if;
694: if (p_rec.attribute28 = hr_api.g_varchar2) then
695: p_rec.attribute28 :=
696: irc_iof_shd.g_old_rec.attribute28;
697: end if;
698: if (p_rec.attribute29 = hr_api.g_varchar2) then

Line 698: if (p_rec.attribute29 = hr_api.g_varchar2) then

694: if (p_rec.attribute28 = hr_api.g_varchar2) then
695: p_rec.attribute28 :=
696: irc_iof_shd.g_old_rec.attribute28;
697: end if;
698: if (p_rec.attribute29 = hr_api.g_varchar2) then
699: p_rec.attribute29 :=
700: irc_iof_shd.g_old_rec.attribute29;
701: end if;
702: if (p_rec.attribute30 = hr_api.g_varchar2) then

Line 702: if (p_rec.attribute30 = hr_api.g_varchar2) then

698: if (p_rec.attribute29 = hr_api.g_varchar2) then
699: p_rec.attribute29 :=
700: irc_iof_shd.g_old_rec.attribute29;
701: end if;
702: if (p_rec.attribute30 = hr_api.g_varchar2) then
703: p_rec.attribute30 :=
704: irc_iof_shd.g_old_rec.attribute30;
705: end if;
706: --

Line 771: ,p_latest_offer in varchar2 default hr_api.g_varchar2

767: (p_effective_date in date
768: ,p_offer_id in number
769: ,p_object_version_number in out nocopy number
770: ,p_offer_version out nocopy number
771: ,p_latest_offer in varchar2 default hr_api.g_varchar2
772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

Line 772: ,p_applicant_assignment_id in number default hr_api.g_number

768: ,p_offer_id in number
769: ,p_object_version_number in out nocopy number
770: ,p_offer_version out nocopy number
771: ,p_latest_offer in varchar2 default hr_api.g_varchar2
772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

Line 773: ,p_offer_assignment_id in number default hr_api.g_number

769: ,p_object_version_number in out nocopy number
770: ,p_offer_version out nocopy number
771: ,p_latest_offer in varchar2 default hr_api.g_varchar2
772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number

Line 774: ,p_offer_status in varchar2 default hr_api.g_varchar2

770: ,p_offer_version out nocopy number
771: ,p_latest_offer in varchar2 default hr_api.g_varchar2
772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date

Line 775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2

771: ,p_latest_offer in varchar2 default hr_api.g_varchar2
772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date

Line 776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2

772: ,p_applicant_assignment_id in number default hr_api.g_number
773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

Line 777: ,p_respondent_id in number default hr_api.g_number

773: ,p_offer_assignment_id in number default hr_api.g_number
774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

Line 778: ,p_expiry_date in date default hr_api.g_date

774: ,p_offer_status in varchar2 default hr_api.g_varchar2
775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date

Line 779: ,p_proposed_start_date in date default hr_api.g_date

775: ,p_discretionary_job_title in varchar2 default hr_api.g_varchar2
776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number

Line 780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2

776: ,p_offer_extended_method in varchar2 default hr_api.g_varchar2
777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number

Line 781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2

777: ,p_respondent_id in number default hr_api.g_number
778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

Line 782: ,p_offer_shipping_date in date default hr_api.g_date

778: ,p_expiry_date in date default hr_api.g_date
779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

Line 783: ,p_address_id in number default hr_api.g_number

779: ,p_proposed_start_date in date default hr_api.g_date
780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 784: ,p_template_id in number default hr_api.g_number

780: ,p_offer_letter_tracking_code in varchar2 default hr_api.g_varchar2
781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2

781: ,p_offer_postal_service in varchar2 default hr_api.g_varchar2
782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2

782: ,p_offer_shipping_date in date default hr_api.g_date
783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute_category in varchar2 default hr_api.g_varchar2

783: ,p_address_id in number default hr_api.g_number
784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute1 in varchar2 default hr_api.g_varchar2

784: ,p_template_id in number default hr_api.g_number
785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 789: ,p_attribute2 in varchar2 default hr_api.g_varchar2

785: ,p_offer_letter_file_type in varchar2 default hr_api.g_varchar2
786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 790: ,p_attribute3 in varchar2 default hr_api.g_varchar2

786: ,p_offer_letter_file_name in varchar2 default hr_api.g_varchar2
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 791: ,p_attribute4 in varchar2 default hr_api.g_varchar2

787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 792: ,p_attribute5 in varchar2 default hr_api.g_varchar2

788: ,p_attribute1 in varchar2 default hr_api.g_varchar2
789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 793: ,p_attribute6 in varchar2 default hr_api.g_varchar2

789: ,p_attribute2 in varchar2 default hr_api.g_varchar2
790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 794: ,p_attribute7 in varchar2 default hr_api.g_varchar2

790: ,p_attribute3 in varchar2 default hr_api.g_varchar2
791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 795: ,p_attribute8 in varchar2 default hr_api.g_varchar2

791: ,p_attribute4 in varchar2 default hr_api.g_varchar2
792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 796: ,p_attribute9 in varchar2 default hr_api.g_varchar2

792: ,p_attribute5 in varchar2 default hr_api.g_varchar2
793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 797: ,p_attribute10 in varchar2 default hr_api.g_varchar2

793: ,p_attribute6 in varchar2 default hr_api.g_varchar2
794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 798: ,p_attribute11 in varchar2 default hr_api.g_varchar2

794: ,p_attribute7 in varchar2 default hr_api.g_varchar2
795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 799: ,p_attribute12 in varchar2 default hr_api.g_varchar2

795: ,p_attribute8 in varchar2 default hr_api.g_varchar2
796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 800: ,p_attribute13 in varchar2 default hr_api.g_varchar2

796: ,p_attribute9 in varchar2 default hr_api.g_varchar2
797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 801: ,p_attribute14 in varchar2 default hr_api.g_varchar2

797: ,p_attribute10 in varchar2 default hr_api.g_varchar2
798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 802: ,p_attribute15 in varchar2 default hr_api.g_varchar2

798: ,p_attribute11 in varchar2 default hr_api.g_varchar2
799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 803: ,p_attribute16 in varchar2 default hr_api.g_varchar2

799: ,p_attribute12 in varchar2 default hr_api.g_varchar2
800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 804: ,p_attribute17 in varchar2 default hr_api.g_varchar2

800: ,p_attribute13 in varchar2 default hr_api.g_varchar2
801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 805: ,p_attribute18 in varchar2 default hr_api.g_varchar2

801: ,p_attribute14 in varchar2 default hr_api.g_varchar2
802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 806: ,p_attribute19 in varchar2 default hr_api.g_varchar2

802: ,p_attribute15 in varchar2 default hr_api.g_varchar2
803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 807: ,p_attribute20 in varchar2 default hr_api.g_varchar2

803: ,p_attribute16 in varchar2 default hr_api.g_varchar2
804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 808: ,p_attribute21 in varchar2 default hr_api.g_varchar2

804: ,p_attribute17 in varchar2 default hr_api.g_varchar2
805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 809: ,p_attribute22 in varchar2 default hr_api.g_varchar2

805: ,p_attribute18 in varchar2 default hr_api.g_varchar2
806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 810: ,p_attribute23 in varchar2 default hr_api.g_varchar2

806: ,p_attribute19 in varchar2 default hr_api.g_varchar2
807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 811: ,p_attribute24 in varchar2 default hr_api.g_varchar2

807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 812: ,p_attribute25 in varchar2 default hr_api.g_varchar2

808: ,p_attribute21 in varchar2 default hr_api.g_varchar2
809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 813: ,p_attribute26 in varchar2 default hr_api.g_varchar2

809: ,p_attribute22 in varchar2 default hr_api.g_varchar2
810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 814: ,p_attribute27 in varchar2 default hr_api.g_varchar2

810: ,p_attribute23 in varchar2 default hr_api.g_varchar2
811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2
818: ) is

Line 815: ,p_attribute28 in varchar2 default hr_api.g_varchar2

811: ,p_attribute24 in varchar2 default hr_api.g_varchar2
812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2
818: ) is
819: --

Line 816: ,p_attribute29 in varchar2 default hr_api.g_varchar2

812: ,p_attribute25 in varchar2 default hr_api.g_varchar2
813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2
818: ) is
819: --
820: l_rec irc_iof_shd.g_rec_type;

Line 817: ,p_attribute30 in varchar2 default hr_api.g_varchar2

813: ,p_attribute26 in varchar2 default hr_api.g_varchar2
814: ,p_attribute27 in varchar2 default hr_api.g_varchar2
815: ,p_attribute28 in varchar2 default hr_api.g_varchar2
816: ,p_attribute29 in varchar2 default hr_api.g_varchar2
817: ,p_attribute30 in varchar2 default hr_api.g_varchar2
818: ) is
819: --
820: l_rec irc_iof_shd.g_rec_type;
821: l_proc varchar2(72) := g_package||'upd';

Line 832: ,hr_api.g_number -- offer_version

828: --
829: l_rec :=
830: irc_iof_shd.convert_args
831: (p_offer_id
832: ,hr_api.g_number -- offer_version
833: ,p_latest_offer
834: ,p_offer_status
835: ,p_discretionary_job_title
836: ,p_offer_extended_method

Line 843: ,hr_api.g_number -- vacancy_id

839: ,p_proposed_start_date
840: ,p_offer_letter_tracking_code
841: ,p_offer_postal_service
842: ,p_offer_shipping_date
843: ,hr_api.g_number -- vacancy_id
844: ,p_applicant_assignment_id
845: ,p_offer_assignment_id
846: ,p_address_id
847: ,p_template_id