APPS.PER_RAA_UPD dependencies on HR_API

Line 142: When hr_api.check_integrity_violated Then

138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 10);
140: --
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: --
145: per_raa_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: --
145: per_raa_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: --
150: per_raa_shd.constraint_error

Line 147: When hr_api.parent_integrity_violated Then

143: -- A check constraint has been violated
144: --
145: per_raa_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: --
150: per_raa_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

147: When hr_api.parent_integrity_violated Then
148: -- Parent integrity has been violated
149: --
150: per_raa_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: --
155: per_raa_shd.constraint_error

Line 152: When hr_api.unique_integrity_violated Then

148: -- Parent integrity has been violated
149: --
150: per_raa_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: --
155: per_raa_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

152: When hr_api.unique_integrity_violated Then
153: -- Unique integrity has been violated
154: --
155: per_raa_shd.constraint_error
156: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
157: When Others Then
158: --
159: Raise;
160: End update_dml;

Line 443: when hr_api.cannot_find_prog_unit then

439: );
440: --
441: exception
442: --
443: when hr_api.cannot_find_prog_unit then
444: --
445: hr_api.cannot_find_prog_unit_error
446: (p_module_name => 'PER_RECRUITMENT_ACTIVITIES'
447: ,p_hook_type => 'AU');

Line 445: hr_api.cannot_find_prog_unit_error

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

Line 508: If (p_rec.business_group_id = hr_api.g_number) then

504: -- p_rec plsql record structure
505: -- to see if a system default is being used. If a system default
506: -- is being used then we must set to the 'current' argument value.
507: --
508: If (p_rec.business_group_id = hr_api.g_number) then
509: p_rec.business_group_id :=
510: per_raa_shd.g_old_rec.business_group_id;
511: End If;
512: If (p_rec.authorising_person_id = hr_api.g_number) then

Line 512: If (p_rec.authorising_person_id = hr_api.g_number) then

508: If (p_rec.business_group_id = hr_api.g_number) then
509: p_rec.business_group_id :=
510: per_raa_shd.g_old_rec.business_group_id;
511: End If;
512: If (p_rec.authorising_person_id = hr_api.g_number) then
513: p_rec.authorising_person_id :=
514: per_raa_shd.g_old_rec.authorising_person_id;
515: End If;
516: If (p_rec.run_by_organization_id = hr_api.g_number) then

Line 516: If (p_rec.run_by_organization_id = hr_api.g_number) then

512: If (p_rec.authorising_person_id = hr_api.g_number) then
513: p_rec.authorising_person_id :=
514: per_raa_shd.g_old_rec.authorising_person_id;
515: End If;
516: If (p_rec.run_by_organization_id = hr_api.g_number) then
517: p_rec.run_by_organization_id :=
518: per_raa_shd.g_old_rec.run_by_organization_id;
519: End If;
520: If (p_rec.internal_contact_person_id = hr_api.g_number) then

Line 520: If (p_rec.internal_contact_person_id = hr_api.g_number) then

516: If (p_rec.run_by_organization_id = hr_api.g_number) then
517: p_rec.run_by_organization_id :=
518: per_raa_shd.g_old_rec.run_by_organization_id;
519: End If;
520: If (p_rec.internal_contact_person_id = hr_api.g_number) then
521: p_rec.internal_contact_person_id :=
522: per_raa_shd.g_old_rec.internal_contact_person_id;
523: End If;
524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then

Line 524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then

520: If (p_rec.internal_contact_person_id = hr_api.g_number) then
521: p_rec.internal_contact_person_id :=
522: per_raa_shd.g_old_rec.internal_contact_person_id;
523: End If;
524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then
525: p_rec.parent_recruitment_activity_id :=
526: per_raa_shd.g_old_rec.parent_recruitment_activity_id;
527: End If;
528: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 528: If (p_rec.currency_code = hr_api.g_varchar2) then

524: If (p_rec.parent_recruitment_activity_id = hr_api.g_number) then
525: p_rec.parent_recruitment_activity_id :=
526: per_raa_shd.g_old_rec.parent_recruitment_activity_id;
527: End If;
528: If (p_rec.currency_code = hr_api.g_varchar2) then
529: p_rec.currency_code :=
530: per_raa_shd.g_old_rec.currency_code;
531: End If;
532: If (p_rec.date_start = hr_api.g_date) then

Line 532: If (p_rec.date_start = hr_api.g_date) then

528: If (p_rec.currency_code = hr_api.g_varchar2) then
529: p_rec.currency_code :=
530: per_raa_shd.g_old_rec.currency_code;
531: End If;
532: If (p_rec.date_start = hr_api.g_date) then
533: p_rec.date_start :=
534: per_raa_shd.g_old_rec.date_start;
535: End If;
536: If (p_rec.name = hr_api.g_varchar2) then

Line 536: If (p_rec.name = hr_api.g_varchar2) then

532: If (p_rec.date_start = hr_api.g_date) then
533: p_rec.date_start :=
534: per_raa_shd.g_old_rec.date_start;
535: End If;
536: If (p_rec.name = hr_api.g_varchar2) then
537: p_rec.name :=
538: per_raa_shd.g_old_rec.name;
539: End If;
540: If (p_rec.actual_cost = hr_api.g_varchar2) then

Line 540: If (p_rec.actual_cost = hr_api.g_varchar2) then

536: If (p_rec.name = hr_api.g_varchar2) then
537: p_rec.name :=
538: per_raa_shd.g_old_rec.name;
539: End If;
540: If (p_rec.actual_cost = hr_api.g_varchar2) then
541: p_rec.actual_cost :=
542: per_raa_shd.g_old_rec.actual_cost;
543: End If;
544: If (p_rec.comments = hr_api.g_varchar2) then

Line 544: If (p_rec.comments = hr_api.g_varchar2) then

540: If (p_rec.actual_cost = hr_api.g_varchar2) then
541: p_rec.actual_cost :=
542: per_raa_shd.g_old_rec.actual_cost;
543: End If;
544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
546: per_raa_shd.g_old_rec.comments;
547: End If;
548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then

Line 548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then

544: If (p_rec.comments = hr_api.g_varchar2) then
545: p_rec.comments :=
546: per_raa_shd.g_old_rec.comments;
547: End If;
548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
549: p_rec.contact_telephone_number :=
550: per_raa_shd.g_old_rec.contact_telephone_number;
551: End If;
552: If (p_rec.date_closing = hr_api.g_date) then

Line 552: If (p_rec.date_closing = hr_api.g_date) then

548: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
549: p_rec.contact_telephone_number :=
550: per_raa_shd.g_old_rec.contact_telephone_number;
551: End If;
552: If (p_rec.date_closing = hr_api.g_date) then
553: p_rec.date_closing :=
554: per_raa_shd.g_old_rec.date_closing;
555: End If;
556: If (p_rec.date_end = hr_api.g_date) then

Line 556: If (p_rec.date_end = hr_api.g_date) then

552: If (p_rec.date_closing = hr_api.g_date) then
553: p_rec.date_closing :=
554: per_raa_shd.g_old_rec.date_closing;
555: End If;
556: If (p_rec.date_end = hr_api.g_date) then
557: p_rec.date_end :=
558: per_raa_shd.g_old_rec.date_end;
559: End If;
560: If (p_rec.external_contact = hr_api.g_varchar2) then

Line 560: If (p_rec.external_contact = hr_api.g_varchar2) then

556: If (p_rec.date_end = hr_api.g_date) then
557: p_rec.date_end :=
558: per_raa_shd.g_old_rec.date_end;
559: End If;
560: If (p_rec.external_contact = hr_api.g_varchar2) then
561: p_rec.external_contact :=
562: per_raa_shd.g_old_rec.external_contact;
563: End If;
564: If (p_rec.planned_cost = hr_api.g_varchar2) then

Line 564: If (p_rec.planned_cost = hr_api.g_varchar2) then

560: If (p_rec.external_contact = hr_api.g_varchar2) then
561: p_rec.external_contact :=
562: per_raa_shd.g_old_rec.external_contact;
563: End If;
564: If (p_rec.planned_cost = hr_api.g_varchar2) then
565: p_rec.planned_cost :=
566: per_raa_shd.g_old_rec.planned_cost;
567: End If;
568: If (p_rec.recruiting_site_id = hr_api.g_number) then

Line 568: If (p_rec.recruiting_site_id = hr_api.g_number) then

564: If (p_rec.planned_cost = hr_api.g_varchar2) then
565: p_rec.planned_cost :=
566: per_raa_shd.g_old_rec.planned_cost;
567: End If;
568: If (p_rec.recruiting_site_id = hr_api.g_number) then
569: p_rec.recruiting_site_id :=
570: per_raa_shd.g_old_rec.recruiting_site_id;
571: End If;
572: If (p_rec.recruiting_site_response = hr_api.g_varchar2) then

Line 572: If (p_rec.recruiting_site_response = hr_api.g_varchar2) then

568: If (p_rec.recruiting_site_id = hr_api.g_number) then
569: p_rec.recruiting_site_id :=
570: per_raa_shd.g_old_rec.recruiting_site_id;
571: End If;
572: If (p_rec.recruiting_site_response = hr_api.g_varchar2) then
573: p_rec.recruiting_site_response :=
574: per_raa_shd.g_old_rec.recruiting_site_response;
575: Else
576: g_recruiting_site_response:=true;

Line 578: if (p_rec.last_posted_date=hr_api.g_date) then

574: per_raa_shd.g_old_rec.recruiting_site_response;
575: Else
576: g_recruiting_site_response:=true;
577: End If;
578: if (p_rec.last_posted_date=hr_api.g_date) then
579: p_rec.last_posted_date :=
580: per_raa_shd.g_old_rec.last_posted_date;
581: end if;
582: If (p_rec.type = hr_api.g_varchar2) then

Line 582: If (p_rec.type = hr_api.g_varchar2) then

578: if (p_rec.last_posted_date=hr_api.g_date) then
579: p_rec.last_posted_date :=
580: per_raa_shd.g_old_rec.last_posted_date;
581: end if;
582: If (p_rec.type = hr_api.g_varchar2) then
583: p_rec.type :=
584: per_raa_shd.g_old_rec.type;
585: End If;
586: If (p_rec.request_id = hr_api.g_number) then

Line 586: If (p_rec.request_id = hr_api.g_number) then

582: If (p_rec.type = hr_api.g_varchar2) then
583: p_rec.type :=
584: per_raa_shd.g_old_rec.type;
585: End If;
586: If (p_rec.request_id = hr_api.g_number) then
587: p_rec.request_id :=
588: per_raa_shd.g_old_rec.request_id;
589: End If;
590: If (p_rec.program_application_id = hr_api.g_number) then

Line 590: If (p_rec.program_application_id = hr_api.g_number) then

586: If (p_rec.request_id = hr_api.g_number) then
587: p_rec.request_id :=
588: per_raa_shd.g_old_rec.request_id;
589: End If;
590: If (p_rec.program_application_id = hr_api.g_number) then
591: p_rec.program_application_id :=
592: per_raa_shd.g_old_rec.program_application_id;
593: End If;
594: If (p_rec.program_id = hr_api.g_number) then

Line 594: If (p_rec.program_id = hr_api.g_number) then

590: If (p_rec.program_application_id = hr_api.g_number) then
591: p_rec.program_application_id :=
592: per_raa_shd.g_old_rec.program_application_id;
593: End If;
594: If (p_rec.program_id = hr_api.g_number) then
595: p_rec.program_id :=
596: per_raa_shd.g_old_rec.program_id;
597: End If;
598: If (p_rec.program_update_date = hr_api.g_date) then

Line 598: If (p_rec.program_update_date = hr_api.g_date) then

594: If (p_rec.program_id = hr_api.g_number) then
595: p_rec.program_id :=
596: per_raa_shd.g_old_rec.program_id;
597: End If;
598: If (p_rec.program_update_date = hr_api.g_date) then
599: p_rec.program_update_date :=
600: per_raa_shd.g_old_rec.program_update_date;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 602: If (p_rec.attribute_category = hr_api.g_varchar2) then

598: If (p_rec.program_update_date = hr_api.g_date) then
599: p_rec.program_update_date :=
600: per_raa_shd.g_old_rec.program_update_date;
601: End If;
602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_raa_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 606: If (p_rec.attribute1 = hr_api.g_varchar2) then

602: If (p_rec.attribute_category = hr_api.g_varchar2) then
603: p_rec.attribute_category :=
604: per_raa_shd.g_old_rec.attribute_category;
605: End If;
606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_raa_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 610: If (p_rec.attribute2 = hr_api.g_varchar2) then

606: If (p_rec.attribute1 = hr_api.g_varchar2) then
607: p_rec.attribute1 :=
608: per_raa_shd.g_old_rec.attribute1;
609: End If;
610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_raa_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 614: If (p_rec.attribute3 = hr_api.g_varchar2) then

610: If (p_rec.attribute2 = hr_api.g_varchar2) then
611: p_rec.attribute2 :=
612: per_raa_shd.g_old_rec.attribute2;
613: End If;
614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_raa_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 618: If (p_rec.attribute4 = hr_api.g_varchar2) then

614: If (p_rec.attribute3 = hr_api.g_varchar2) then
615: p_rec.attribute3 :=
616: per_raa_shd.g_old_rec.attribute3;
617: End If;
618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_raa_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 622: If (p_rec.attribute5 = hr_api.g_varchar2) then

618: If (p_rec.attribute4 = hr_api.g_varchar2) then
619: p_rec.attribute4 :=
620: per_raa_shd.g_old_rec.attribute4;
621: End If;
622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_raa_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 626: If (p_rec.attribute6 = hr_api.g_varchar2) then

622: If (p_rec.attribute5 = hr_api.g_varchar2) then
623: p_rec.attribute5 :=
624: per_raa_shd.g_old_rec.attribute5;
625: End If;
626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_raa_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 630: If (p_rec.attribute7 = hr_api.g_varchar2) then

626: If (p_rec.attribute6 = hr_api.g_varchar2) then
627: p_rec.attribute6 :=
628: per_raa_shd.g_old_rec.attribute6;
629: End If;
630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_raa_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 634: If (p_rec.attribute8 = hr_api.g_varchar2) then

630: If (p_rec.attribute7 = hr_api.g_varchar2) then
631: p_rec.attribute7 :=
632: per_raa_shd.g_old_rec.attribute7;
633: End If;
634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_raa_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 638: If (p_rec.attribute9 = hr_api.g_varchar2) then

634: If (p_rec.attribute8 = hr_api.g_varchar2) then
635: p_rec.attribute8 :=
636: per_raa_shd.g_old_rec.attribute8;
637: End If;
638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_raa_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 642: If (p_rec.attribute10 = hr_api.g_varchar2) then

638: If (p_rec.attribute9 = hr_api.g_varchar2) then
639: p_rec.attribute9 :=
640: per_raa_shd.g_old_rec.attribute9;
641: End If;
642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_raa_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 646: If (p_rec.attribute11 = hr_api.g_varchar2) then

642: If (p_rec.attribute10 = hr_api.g_varchar2) then
643: p_rec.attribute10 :=
644: per_raa_shd.g_old_rec.attribute10;
645: End If;
646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_raa_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 650: If (p_rec.attribute12 = hr_api.g_varchar2) then

646: If (p_rec.attribute11 = hr_api.g_varchar2) then
647: p_rec.attribute11 :=
648: per_raa_shd.g_old_rec.attribute11;
649: End If;
650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_raa_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 654: If (p_rec.attribute13 = hr_api.g_varchar2) then

650: If (p_rec.attribute12 = hr_api.g_varchar2) then
651: p_rec.attribute12 :=
652: per_raa_shd.g_old_rec.attribute12;
653: End If;
654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_raa_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 658: If (p_rec.attribute14 = hr_api.g_varchar2) then

654: If (p_rec.attribute13 = hr_api.g_varchar2) then
655: p_rec.attribute13 :=
656: per_raa_shd.g_old_rec.attribute13;
657: End If;
658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_raa_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 662: If (p_rec.attribute15 = hr_api.g_varchar2) then

658: If (p_rec.attribute14 = hr_api.g_varchar2) then
659: p_rec.attribute14 :=
660: per_raa_shd.g_old_rec.attribute14;
661: End If;
662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_raa_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 666: If (p_rec.attribute16 = hr_api.g_varchar2) then

662: If (p_rec.attribute15 = hr_api.g_varchar2) then
663: p_rec.attribute15 :=
664: per_raa_shd.g_old_rec.attribute15;
665: End If;
666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_raa_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 670: If (p_rec.attribute17 = hr_api.g_varchar2) then

666: If (p_rec.attribute16 = hr_api.g_varchar2) then
667: p_rec.attribute16 :=
668: per_raa_shd.g_old_rec.attribute16;
669: End If;
670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_raa_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 674: If (p_rec.attribute18 = hr_api.g_varchar2) then

670: If (p_rec.attribute17 = hr_api.g_varchar2) then
671: p_rec.attribute17 :=
672: per_raa_shd.g_old_rec.attribute17;
673: End If;
674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_raa_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 678: If (p_rec.attribute19 = hr_api.g_varchar2) then

674: If (p_rec.attribute18 = hr_api.g_varchar2) then
675: p_rec.attribute18 :=
676: per_raa_shd.g_old_rec.attribute18;
677: End If;
678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_raa_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 682: If (p_rec.attribute20 = hr_api.g_varchar2) then

678: If (p_rec.attribute19 = hr_api.g_varchar2) then
679: p_rec.attribute19 :=
680: per_raa_shd.g_old_rec.attribute19;
681: End If;
682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_raa_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.posting_content_id = hr_api.g_number) then

Line 686: If (p_rec.posting_content_id = hr_api.g_number) then

682: If (p_rec.attribute20 = hr_api.g_varchar2) then
683: p_rec.attribute20 :=
684: per_raa_shd.g_old_rec.attribute20;
685: End If;
686: If (p_rec.posting_content_id = hr_api.g_number) then
687: p_rec.posting_content_id :=
688: per_raa_shd.g_old_rec.posting_content_id;
689: End If;
690: If (p_rec.status = hr_api.g_varchar2) then

Line 690: If (p_rec.status = hr_api.g_varchar2) then

686: If (p_rec.posting_content_id = hr_api.g_number) then
687: p_rec.posting_content_id :=
688: per_raa_shd.g_old_rec.posting_content_id;
689: End If;
690: If (p_rec.status = hr_api.g_varchar2) then
691: p_rec.status :=
692: per_raa_shd.g_old_rec.status;
693: End If;
694: --

Line 754: ,p_business_group_id in number default hr_api.g_number

750: -- ----------------------------------------------------------------------------
751: Procedure upd
752: (p_recruitment_activity_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_business_group_id in number default hr_api.g_number
755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number

Line 755: ,p_date_start in date default hr_api.g_date

751: Procedure upd
752: (p_recruitment_activity_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_business_group_id in number default hr_api.g_number
755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number

Line 756: ,p_name in varchar2 default hr_api.g_varchar2

752: (p_recruitment_activity_id in number
753: ,p_object_version_number in out nocopy number
754: ,p_business_group_id in number default hr_api.g_number
755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number

Line 757: ,p_authorising_person_id in number default hr_api.g_number

753: ,p_object_version_number in out nocopy number
754: ,p_business_group_id in number default hr_api.g_number
755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 758: ,p_run_by_organization_id in number default hr_api.g_number

754: ,p_business_group_id in number default hr_api.g_number
755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2

Line 759: ,p_internal_contact_person_id in number default hr_api.g_number

755: ,p_date_start in date default hr_api.g_date
756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2

Line 760: ,p_parent_recruitment_activity in number default hr_api.g_number

756: ,p_name in varchar2 default hr_api.g_varchar2
757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2

Line 761: ,p_currency_code in varchar2 default hr_api.g_varchar2

757: ,p_authorising_person_id in number default hr_api.g_number
758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date

Line 762: ,p_actual_cost in varchar2 default hr_api.g_varchar2

758: ,p_run_by_organization_id in number default hr_api.g_number
759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date

Line 763: ,p_comments in varchar2 default hr_api.g_varchar2

759: ,p_internal_contact_person_id in number default hr_api.g_number
760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2

Line 764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2

760: ,p_parent_recruitment_activity in number default hr_api.g_number
761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2

Line 765: ,p_date_closing in date default hr_api.g_date

761: ,p_currency_code in varchar2 default hr_api.g_varchar2
762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number

Line 766: ,p_date_end in date default hr_api.g_date

762: ,p_actual_cost in varchar2 default hr_api.g_varchar2
763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2

Line 767: ,p_external_contact in varchar2 default hr_api.g_varchar2

763: ,p_comments in varchar2 default hr_api.g_varchar2
764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date

Line 768: ,p_planned_cost in varchar2 default hr_api.g_varchar2

764: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2

Line 769: ,p_recruiting_site_id in number default hr_api.g_number

765: ,p_date_closing in date default hr_api.g_date
766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number

Line 770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2

766: ,p_date_end in date default hr_api.g_date
767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number

Line 771: ,p_last_posted_date in date default hr_api.g_date

767: ,p_external_contact in varchar2 default hr_api.g_varchar2
768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number

Line 772: ,p_type in varchar2 default hr_api.g_varchar2

768: ,p_planned_cost in varchar2 default hr_api.g_varchar2
769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date

Line 773: ,p_request_id in number default hr_api.g_number

769: ,p_recruiting_site_id in number default hr_api.g_number
770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 774: ,p_program_application_id in number default hr_api.g_number

770: ,p_recruiting_site_response in varchar2 default hr_api.g_varchar2
771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 775: ,p_program_id in number default hr_api.g_number

771: ,p_last_posted_date in date default hr_api.g_date
772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 776: ,p_program_update_date in date default hr_api.g_date

772: ,p_type in varchar2 default hr_api.g_varchar2
773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 777: ,p_attribute_category in varchar2 default hr_api.g_varchar2

773: ,p_request_id in number default hr_api.g_number
774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 778: ,p_attribute1 in varchar2 default hr_api.g_varchar2

774: ,p_program_application_id in number default hr_api.g_number
775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 779: ,p_attribute2 in varchar2 default hr_api.g_varchar2

775: ,p_program_id in number default hr_api.g_number
776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 780: ,p_attribute3 in varchar2 default hr_api.g_varchar2

776: ,p_program_update_date in date default hr_api.g_date
777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 781: ,p_attribute4 in varchar2 default hr_api.g_varchar2

777: ,p_attribute_category in varchar2 default hr_api.g_varchar2
778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 782: ,p_attribute5 in varchar2 default hr_api.g_varchar2

778: ,p_attribute1 in varchar2 default hr_api.g_varchar2
779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 783: ,p_attribute6 in varchar2 default hr_api.g_varchar2

779: ,p_attribute2 in varchar2 default hr_api.g_varchar2
780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 784: ,p_attribute7 in varchar2 default hr_api.g_varchar2

780: ,p_attribute3 in varchar2 default hr_api.g_varchar2
781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 785: ,p_attribute8 in varchar2 default hr_api.g_varchar2

781: ,p_attribute4 in varchar2 default hr_api.g_varchar2
782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 786: ,p_attribute9 in varchar2 default hr_api.g_varchar2

782: ,p_attribute5 in varchar2 default hr_api.g_varchar2
783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 787: ,p_attribute10 in varchar2 default hr_api.g_varchar2

783: ,p_attribute6 in varchar2 default hr_api.g_varchar2
784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 788: ,p_attribute11 in varchar2 default hr_api.g_varchar2

784: ,p_attribute7 in varchar2 default hr_api.g_varchar2
785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 789: ,p_attribute12 in varchar2 default hr_api.g_varchar2

785: ,p_attribute8 in varchar2 default hr_api.g_varchar2
786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 790: ,p_attribute13 in varchar2 default hr_api.g_varchar2

786: ,p_attribute9 in varchar2 default hr_api.g_varchar2
787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 791: ,p_attribute14 in varchar2 default hr_api.g_varchar2

787: ,p_attribute10 in varchar2 default hr_api.g_varchar2
788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 792: ,p_attribute15 in varchar2 default hr_api.g_varchar2

788: ,p_attribute11 in varchar2 default hr_api.g_varchar2
789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 793: ,p_attribute16 in varchar2 default hr_api.g_varchar2

789: ,p_attribute12 in varchar2 default hr_api.g_varchar2
790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 794: ,p_attribute17 in varchar2 default hr_api.g_varchar2

790: ,p_attribute13 in varchar2 default hr_api.g_varchar2
791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number

Line 795: ,p_attribute18 in varchar2 default hr_api.g_varchar2

791: ,p_attribute14 in varchar2 default hr_api.g_varchar2
792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2

Line 796: ,p_attribute19 in varchar2 default hr_api.g_varchar2

792: ,p_attribute15 in varchar2 default hr_api.g_varchar2
793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2
800: ) is

Line 797: ,p_attribute20 in varchar2 default hr_api.g_varchar2

793: ,p_attribute16 in varchar2 default hr_api.g_varchar2
794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2
800: ) is
801: --

Line 798: ,p_posting_content_id in number default hr_api.g_number

794: ,p_attribute17 in varchar2 default hr_api.g_varchar2
795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2
800: ) is
801: --
802: l_rec per_raa_shd.g_rec_type;

Line 799: ,p_status in varchar2 default hr_api.g_varchar2

795: ,p_attribute18 in varchar2 default hr_api.g_varchar2
796: ,p_attribute19 in varchar2 default hr_api.g_varchar2
797: ,p_attribute20 in varchar2 default hr_api.g_varchar2
798: ,p_posting_content_id in number default hr_api.g_number
799: ,p_status in varchar2 default hr_api.g_varchar2
800: ) is
801: --
802: l_rec per_raa_shd.g_rec_type;
803: l_proc varchar2(72) := g_package||'upd';