APPS.PER_VAC_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
133: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
133: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
138: per_vac_shd.constraint_error

Line 135: When hr_api.parent_integrity_violated then

131: -- A check constraint has been violated
132: per_vac_shd.g_api_dml := false; -- Unset the dml status
133: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
138: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
138: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
143: per_vac_shd.constraint_error

Line 140: When hr_api.unique_integrity_violated then

136: -- Parent integrity has been violated
137: per_vac_shd.g_api_dml := false; -- Unset the dml status
138: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
143: per_vac_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: per_vac_shd.g_api_dml := false; -- Unset the dml status
143: per_vac_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others then
146: per_vac_shd.g_api_dml := false; -- Unset the dml status
147: Raise;
148: End update_dml;

Line 442: when hr_api.cannot_find_prog_unit then

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

Line 444: hr_api.cannot_find_prog_unit_error

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

Line 507: if (p_rec.business_group_id = hr_api.g_number) then

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

Line 511: if (p_rec.position_id = hr_api.g_number) then

507: if (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: per_vac_shd.g_old_rec.business_group_id;
510: end if;
511: if (p_rec.position_id = hr_api.g_number) then
512: p_rec.position_id :=
513: per_vac_shd.g_old_rec.position_id;
514: end if;
515: if (p_rec.job_id = hr_api.g_number) then

Line 515: if (p_rec.job_id = hr_api.g_number) then

511: if (p_rec.position_id = hr_api.g_number) then
512: p_rec.position_id :=
513: per_vac_shd.g_old_rec.position_id;
514: end if;
515: if (p_rec.job_id = hr_api.g_number) then
516: p_rec.job_id :=
517: per_vac_shd.g_old_rec.job_id;
518: end if;
519: if (p_rec.grade_id = hr_api.g_number) then

Line 519: if (p_rec.grade_id = hr_api.g_number) then

515: if (p_rec.job_id = hr_api.g_number) then
516: p_rec.job_id :=
517: per_vac_shd.g_old_rec.job_id;
518: end if;
519: if (p_rec.grade_id = hr_api.g_number) then
520: p_rec.grade_id :=
521: per_vac_shd.g_old_rec.grade_id;
522: end if;
523: if (p_rec.organization_id = hr_api.g_number) then

Line 523: if (p_rec.organization_id = hr_api.g_number) then

519: if (p_rec.grade_id = hr_api.g_number) then
520: p_rec.grade_id :=
521: per_vac_shd.g_old_rec.grade_id;
522: end if;
523: if (p_rec.organization_id = hr_api.g_number) then
524: p_rec.organization_id :=
525: per_vac_shd.g_old_rec.organization_id;
526: end if;
527: if (p_rec.requisition_id = hr_api.g_number) then

Line 527: if (p_rec.requisition_id = hr_api.g_number) then

523: if (p_rec.organization_id = hr_api.g_number) then
524: p_rec.organization_id :=
525: per_vac_shd.g_old_rec.organization_id;
526: end if;
527: if (p_rec.requisition_id = hr_api.g_number) then
528: p_rec.requisition_id :=
529: per_vac_shd.g_old_rec.requisition_id;
530: end if;
531: if (p_rec.people_group_id = hr_api.g_number) then

Line 531: if (p_rec.people_group_id = hr_api.g_number) then

527: if (p_rec.requisition_id = hr_api.g_number) then
528: p_rec.requisition_id :=
529: per_vac_shd.g_old_rec.requisition_id;
530: end if;
531: if (p_rec.people_group_id = hr_api.g_number) then
532: p_rec.people_group_id :=
533: per_vac_shd.g_old_rec.people_group_id;
534: end if;
535: if (p_rec.location_id = hr_api.g_number) then

Line 535: if (p_rec.location_id = hr_api.g_number) then

531: if (p_rec.people_group_id = hr_api.g_number) then
532: p_rec.people_group_id :=
533: per_vac_shd.g_old_rec.people_group_id;
534: end if;
535: if (p_rec.location_id = hr_api.g_number) then
536: p_rec.location_id :=
537: per_vac_shd.g_old_rec.location_id;
538: end if;
539: if (p_rec.recruiter_id = hr_api.g_number) then

Line 539: if (p_rec.recruiter_id = hr_api.g_number) then

535: if (p_rec.location_id = hr_api.g_number) then
536: p_rec.location_id :=
537: per_vac_shd.g_old_rec.location_id;
538: end if;
539: if (p_rec.recruiter_id = hr_api.g_number) then
540: p_rec.recruiter_id :=
541: per_vac_shd.g_old_rec.recruiter_id;
542: end if;
543: if (p_rec.date_from = hr_api.g_date) then

Line 543: if (p_rec.date_from = hr_api.g_date) then

539: if (p_rec.recruiter_id = hr_api.g_number) then
540: p_rec.recruiter_id :=
541: per_vac_shd.g_old_rec.recruiter_id;
542: end if;
543: if (p_rec.date_from = hr_api.g_date) then
544: p_rec.date_from :=
545: per_vac_shd.g_old_rec.date_from;
546: end if;
547: if (p_rec.name = hr_api.g_varchar2) then

Line 547: if (p_rec.name = hr_api.g_varchar2) then

543: if (p_rec.date_from = hr_api.g_date) then
544: p_rec.date_from :=
545: per_vac_shd.g_old_rec.date_from;
546: end if;
547: if (p_rec.name = hr_api.g_varchar2) then
548: p_rec.name :=
549: per_vac_shd.g_old_rec.name;
550: end if;
551: if (p_rec.comments = hr_api.g_varchar2) then

Line 551: if (p_rec.comments = hr_api.g_varchar2) then

547: if (p_rec.name = hr_api.g_varchar2) then
548: p_rec.name :=
549: per_vac_shd.g_old_rec.name;
550: end if;
551: if (p_rec.comments = hr_api.g_varchar2) then
552: p_rec.comments :=
553: per_vac_shd.g_old_rec.comments;
554: end if;
555: if (p_rec.date_to = hr_api.g_date) then

Line 555: if (p_rec.date_to = hr_api.g_date) then

551: if (p_rec.comments = hr_api.g_varchar2) then
552: p_rec.comments :=
553: per_vac_shd.g_old_rec.comments;
554: end if;
555: if (p_rec.date_to = hr_api.g_date) then
556: p_rec.date_to :=
557: per_vac_shd.g_old_rec.date_to;
558: end if;
559: if (p_rec.description = hr_api.g_varchar2) then

Line 559: if (p_rec.description = hr_api.g_varchar2) then

555: if (p_rec.date_to = hr_api.g_date) then
556: p_rec.date_to :=
557: per_vac_shd.g_old_rec.date_to;
558: end if;
559: if (p_rec.description = hr_api.g_varchar2) then
560: p_rec.description :=
561: per_vac_shd.g_old_rec.description;
562: end if;
563: if (p_rec.number_of_openings = hr_api.g_number) then

Line 563: if (p_rec.number_of_openings = hr_api.g_number) then

559: if (p_rec.description = hr_api.g_varchar2) then
560: p_rec.description :=
561: per_vac_shd.g_old_rec.description;
562: end if;
563: if (p_rec.number_of_openings = hr_api.g_number) then
564: p_rec.number_of_openings :=
565: per_vac_shd.g_old_rec.number_of_openings;
566: end if;
567: if (p_rec.status = hr_api.g_varchar2) then

Line 567: if (p_rec.status = hr_api.g_varchar2) then

563: if (p_rec.number_of_openings = hr_api.g_number) then
564: p_rec.number_of_openings :=
565: per_vac_shd.g_old_rec.number_of_openings;
566: end if;
567: if (p_rec.status = hr_api.g_varchar2) then
568: p_rec.status :=
569: per_vac_shd.g_old_rec.status;
570: end if;
571: if (p_rec.request_id = hr_api.g_number) then

Line 571: if (p_rec.request_id = hr_api.g_number) then

567: if (p_rec.status = hr_api.g_varchar2) then
568: p_rec.status :=
569: per_vac_shd.g_old_rec.status;
570: end if;
571: if (p_rec.request_id = hr_api.g_number) then
572: p_rec.request_id :=
573: per_vac_shd.g_old_rec.request_id;
574: end if;
575: if (p_rec.program_application_id = hr_api.g_number) then

Line 575: if (p_rec.program_application_id = hr_api.g_number) then

571: if (p_rec.request_id = hr_api.g_number) then
572: p_rec.request_id :=
573: per_vac_shd.g_old_rec.request_id;
574: end if;
575: if (p_rec.program_application_id = hr_api.g_number) then
576: p_rec.program_application_id :=
577: per_vac_shd.g_old_rec.program_application_id;
578: end if;
579: if (p_rec.program_id = hr_api.g_number) then

Line 579: if (p_rec.program_id = hr_api.g_number) then

575: if (p_rec.program_application_id = hr_api.g_number) then
576: p_rec.program_application_id :=
577: per_vac_shd.g_old_rec.program_application_id;
578: end if;
579: if (p_rec.program_id = hr_api.g_number) then
580: p_rec.program_id :=
581: per_vac_shd.g_old_rec.program_id;
582: end if;
583: if (p_rec.program_update_date = hr_api.g_date) then

Line 583: if (p_rec.program_update_date = hr_api.g_date) then

579: if (p_rec.program_id = hr_api.g_number) then
580: p_rec.program_id :=
581: per_vac_shd.g_old_rec.program_id;
582: end if;
583: if (p_rec.program_update_date = hr_api.g_date) then
584: p_rec.program_update_date :=
585: per_vac_shd.g_old_rec.program_update_date;
586: end if;
587: if (p_rec.attribute_category = hr_api.g_varchar2) then

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

583: if (p_rec.program_update_date = hr_api.g_date) then
584: p_rec.program_update_date :=
585: per_vac_shd.g_old_rec.program_update_date;
586: end if;
587: if (p_rec.attribute_category = hr_api.g_varchar2) then
588: p_rec.attribute_category :=
589: per_vac_shd.g_old_rec.attribute_category;
590: end if;
591: if (p_rec.attribute1 = hr_api.g_varchar2) then

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

587: if (p_rec.attribute_category = hr_api.g_varchar2) then
588: p_rec.attribute_category :=
589: per_vac_shd.g_old_rec.attribute_category;
590: end if;
591: if (p_rec.attribute1 = hr_api.g_varchar2) then
592: p_rec.attribute1 :=
593: per_vac_shd.g_old_rec.attribute1;
594: end if;
595: if (p_rec.attribute2 = hr_api.g_varchar2) then

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

591: if (p_rec.attribute1 = hr_api.g_varchar2) then
592: p_rec.attribute1 :=
593: per_vac_shd.g_old_rec.attribute1;
594: end if;
595: if (p_rec.attribute2 = hr_api.g_varchar2) then
596: p_rec.attribute2 :=
597: per_vac_shd.g_old_rec.attribute2;
598: end if;
599: if (p_rec.attribute3 = hr_api.g_varchar2) then

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

595: if (p_rec.attribute2 = hr_api.g_varchar2) then
596: p_rec.attribute2 :=
597: per_vac_shd.g_old_rec.attribute2;
598: end if;
599: if (p_rec.attribute3 = hr_api.g_varchar2) then
600: p_rec.attribute3 :=
601: per_vac_shd.g_old_rec.attribute3;
602: end if;
603: if (p_rec.attribute4 = hr_api.g_varchar2) then

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

599: if (p_rec.attribute3 = hr_api.g_varchar2) then
600: p_rec.attribute3 :=
601: per_vac_shd.g_old_rec.attribute3;
602: end if;
603: if (p_rec.attribute4 = hr_api.g_varchar2) then
604: p_rec.attribute4 :=
605: per_vac_shd.g_old_rec.attribute4;
606: end if;
607: if (p_rec.attribute5 = hr_api.g_varchar2) then

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

603: if (p_rec.attribute4 = hr_api.g_varchar2) then
604: p_rec.attribute4 :=
605: per_vac_shd.g_old_rec.attribute4;
606: end if;
607: if (p_rec.attribute5 = hr_api.g_varchar2) then
608: p_rec.attribute5 :=
609: per_vac_shd.g_old_rec.attribute5;
610: end if;
611: if (p_rec.attribute6 = hr_api.g_varchar2) then

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

607: if (p_rec.attribute5 = hr_api.g_varchar2) then
608: p_rec.attribute5 :=
609: per_vac_shd.g_old_rec.attribute5;
610: end if;
611: if (p_rec.attribute6 = hr_api.g_varchar2) then
612: p_rec.attribute6 :=
613: per_vac_shd.g_old_rec.attribute6;
614: end if;
615: if (p_rec.attribute7 = hr_api.g_varchar2) then

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

611: if (p_rec.attribute6 = hr_api.g_varchar2) then
612: p_rec.attribute6 :=
613: per_vac_shd.g_old_rec.attribute6;
614: end if;
615: if (p_rec.attribute7 = hr_api.g_varchar2) then
616: p_rec.attribute7 :=
617: per_vac_shd.g_old_rec.attribute7;
618: end if;
619: if (p_rec.attribute8 = hr_api.g_varchar2) then

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

615: if (p_rec.attribute7 = hr_api.g_varchar2) then
616: p_rec.attribute7 :=
617: per_vac_shd.g_old_rec.attribute7;
618: end if;
619: if (p_rec.attribute8 = hr_api.g_varchar2) then
620: p_rec.attribute8 :=
621: per_vac_shd.g_old_rec.attribute8;
622: end if;
623: if (p_rec.attribute9 = hr_api.g_varchar2) then

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

619: if (p_rec.attribute8 = hr_api.g_varchar2) then
620: p_rec.attribute8 :=
621: per_vac_shd.g_old_rec.attribute8;
622: end if;
623: if (p_rec.attribute9 = hr_api.g_varchar2) then
624: p_rec.attribute9 :=
625: per_vac_shd.g_old_rec.attribute9;
626: end if;
627: if (p_rec.attribute10 = hr_api.g_varchar2) then

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

623: if (p_rec.attribute9 = hr_api.g_varchar2) then
624: p_rec.attribute9 :=
625: per_vac_shd.g_old_rec.attribute9;
626: end if;
627: if (p_rec.attribute10 = hr_api.g_varchar2) then
628: p_rec.attribute10 :=
629: per_vac_shd.g_old_rec.attribute10;
630: end if;
631: if (p_rec.attribute11 = hr_api.g_varchar2) then

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

627: if (p_rec.attribute10 = hr_api.g_varchar2) then
628: p_rec.attribute10 :=
629: per_vac_shd.g_old_rec.attribute10;
630: end if;
631: if (p_rec.attribute11 = hr_api.g_varchar2) then
632: p_rec.attribute11 :=
633: per_vac_shd.g_old_rec.attribute11;
634: end if;
635: if (p_rec.attribute12 = hr_api.g_varchar2) then

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

631: if (p_rec.attribute11 = hr_api.g_varchar2) then
632: p_rec.attribute11 :=
633: per_vac_shd.g_old_rec.attribute11;
634: end if;
635: if (p_rec.attribute12 = hr_api.g_varchar2) then
636: p_rec.attribute12 :=
637: per_vac_shd.g_old_rec.attribute12;
638: end if;
639: if (p_rec.attribute13 = hr_api.g_varchar2) then

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

635: if (p_rec.attribute12 = hr_api.g_varchar2) then
636: p_rec.attribute12 :=
637: per_vac_shd.g_old_rec.attribute12;
638: end if;
639: if (p_rec.attribute13 = hr_api.g_varchar2) then
640: p_rec.attribute13 :=
641: per_vac_shd.g_old_rec.attribute13;
642: end if;
643: if (p_rec.attribute14 = hr_api.g_varchar2) then

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

639: if (p_rec.attribute13 = hr_api.g_varchar2) then
640: p_rec.attribute13 :=
641: per_vac_shd.g_old_rec.attribute13;
642: end if;
643: if (p_rec.attribute14 = hr_api.g_varchar2) then
644: p_rec.attribute14 :=
645: per_vac_shd.g_old_rec.attribute14;
646: end if;
647: if (p_rec.attribute15 = hr_api.g_varchar2) then

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

643: if (p_rec.attribute14 = hr_api.g_varchar2) then
644: p_rec.attribute14 :=
645: per_vac_shd.g_old_rec.attribute14;
646: end if;
647: if (p_rec.attribute15 = hr_api.g_varchar2) then
648: p_rec.attribute15 :=
649: per_vac_shd.g_old_rec.attribute15;
650: end if;
651: if (p_rec.attribute16 = hr_api.g_varchar2) then

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

647: if (p_rec.attribute15 = hr_api.g_varchar2) then
648: p_rec.attribute15 :=
649: per_vac_shd.g_old_rec.attribute15;
650: end if;
651: if (p_rec.attribute16 = hr_api.g_varchar2) then
652: p_rec.attribute16 :=
653: per_vac_shd.g_old_rec.attribute16;
654: end if;
655: if (p_rec.attribute17 = hr_api.g_varchar2) then

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

651: if (p_rec.attribute16 = hr_api.g_varchar2) then
652: p_rec.attribute16 :=
653: per_vac_shd.g_old_rec.attribute16;
654: end if;
655: if (p_rec.attribute17 = hr_api.g_varchar2) then
656: p_rec.attribute17 :=
657: per_vac_shd.g_old_rec.attribute17;
658: end if;
659: if (p_rec.attribute18 = hr_api.g_varchar2) then

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

655: if (p_rec.attribute17 = hr_api.g_varchar2) then
656: p_rec.attribute17 :=
657: per_vac_shd.g_old_rec.attribute17;
658: end if;
659: if (p_rec.attribute18 = hr_api.g_varchar2) then
660: p_rec.attribute18 :=
661: per_vac_shd.g_old_rec.attribute18;
662: end if;
663: if (p_rec.attribute19 = hr_api.g_varchar2) then

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

659: if (p_rec.attribute18 = hr_api.g_varchar2) then
660: p_rec.attribute18 :=
661: per_vac_shd.g_old_rec.attribute18;
662: end if;
663: if (p_rec.attribute19 = hr_api.g_varchar2) then
664: p_rec.attribute19 :=
665: per_vac_shd.g_old_rec.attribute19;
666: end if;
667: if (p_rec.attribute20 = hr_api.g_varchar2) then

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

663: if (p_rec.attribute19 = hr_api.g_varchar2) then
664: p_rec.attribute19 :=
665: per_vac_shd.g_old_rec.attribute19;
666: end if;
667: if (p_rec.attribute20 = hr_api.g_varchar2) then
668: p_rec.attribute20 :=
669: per_vac_shd.g_old_rec.attribute20;
670: end if;
671: if (p_rec.vacancy_category = hr_api.g_varchar2) then

Line 671: if (p_rec.vacancy_category = hr_api.g_varchar2) then

667: if (p_rec.attribute20 = hr_api.g_varchar2) then
668: p_rec.attribute20 :=
669: per_vac_shd.g_old_rec.attribute20;
670: end if;
671: if (p_rec.vacancy_category = hr_api.g_varchar2) then
672: p_rec.vacancy_category :=
673: per_vac_shd.g_old_rec.vacancy_category;
674: end if;
675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then

Line 675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then

671: if (p_rec.vacancy_category = hr_api.g_varchar2) then
672: p_rec.vacancy_category :=
673: per_vac_shd.g_old_rec.vacancy_category;
674: end if;
675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then
676: p_rec.vacancy_region_type :=
677: per_vac_shd.g_old_rec.vacancy_region_type;
678: end if;
679: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then

Line 679: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then

675: if (p_rec.vacancy_region_type = hr_api.g_varchar2) then
676: p_rec.vacancy_region_type :=
677: per_vac_shd.g_old_rec.vacancy_region_type;
678: end if;
679: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
680: p_rec.budget_measurement_type :=
681: per_vac_shd.g_old_rec.budget_measurement_type;
682: end if;
683: if (p_rec.budget_measurement_value = hr_api.g_number) then

Line 683: if (p_rec.budget_measurement_value = hr_api.g_number) then

679: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
680: p_rec.budget_measurement_type :=
681: per_vac_shd.g_old_rec.budget_measurement_type;
682: end if;
683: if (p_rec.budget_measurement_value = hr_api.g_number) then
684: p_rec.budget_measurement_value :=
685: per_vac_shd.g_old_rec.budget_measurement_value;
686: end if;
687: if (p_rec.manager_id = hr_api.g_number) then

Line 687: if (p_rec.manager_id = hr_api.g_number) then

683: if (p_rec.budget_measurement_value = hr_api.g_number) then
684: p_rec.budget_measurement_value :=
685: per_vac_shd.g_old_rec.budget_measurement_value;
686: end if;
687: if (p_rec.manager_id = hr_api.g_number) then
688: p_rec.manager_id :=
689: per_vac_shd.g_old_rec.manager_id;
690: end if;
691: if (p_rec.security_method = hr_api.g_varchar2) then

Line 691: if (p_rec.security_method = hr_api.g_varchar2) then

687: if (p_rec.manager_id = hr_api.g_number) then
688: p_rec.manager_id :=
689: per_vac_shd.g_old_rec.manager_id;
690: end if;
691: if (p_rec.security_method = hr_api.g_varchar2) then
692: p_rec.security_method :=
693: per_vac_shd.g_old_rec.security_method;
694: end if;
695: if (p_rec.primary_posting_id = hr_api.g_number) then

Line 695: if (p_rec.primary_posting_id = hr_api.g_number) then

691: if (p_rec.security_method = hr_api.g_varchar2) then
692: p_rec.security_method :=
693: per_vac_shd.g_old_rec.security_method;
694: end if;
695: if (p_rec.primary_posting_id = hr_api.g_number) then
696: p_rec.primary_posting_id :=
697: per_vac_shd.g_old_rec.primary_posting_id;
698: end if;
699: if (p_rec.assessment_id = hr_api.g_number) then

Line 699: if (p_rec.assessment_id = hr_api.g_number) then

695: if (p_rec.primary_posting_id = hr_api.g_number) then
696: p_rec.primary_posting_id :=
697: per_vac_shd.g_old_rec.primary_posting_id;
698: end if;
699: if (p_rec.assessment_id = hr_api.g_number) then
700: p_rec.assessment_id :=
701: per_vac_shd.g_old_rec.assessment_id;
702: end if;
703: --

Line 767: ,p_business_group_id in number default hr_api.g_number

763: Procedure upd
764: (p_effective_date in date
765: ,p_vacancy_id in number
766: ,p_object_version_number in out nocopy number
767: ,p_business_group_id in number default hr_api.g_number
768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number

Line 768: ,p_requisition_id in number default hr_api.g_number

764: (p_effective_date in date
765: ,p_vacancy_id in number
766: ,p_object_version_number in out nocopy number
767: ,p_business_group_id in number default hr_api.g_number
768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number

Line 769: ,p_date_from in date default hr_api.g_date

765: ,p_vacancy_id in number
766: ,p_object_version_number in out nocopy number
767: ,p_business_group_id in number default hr_api.g_number
768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number

Line 770: ,p_name in varchar2 default hr_api.g_varchar2

766: ,p_object_version_number in out nocopy number
767: ,p_business_group_id in number default hr_api.g_number
768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number

Line 771: ,p_position_id in number default hr_api.g_number

767: ,p_business_group_id in number default hr_api.g_number
768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number

Line 772: ,p_job_id in number default hr_api.g_number

768: ,p_requisition_id in number default hr_api.g_number
769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number

Line 773: ,p_grade_id in number default hr_api.g_number

769: ,p_date_from in date default hr_api.g_date
770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number

Line 774: ,p_organization_id in number default hr_api.g_number

770: ,p_name in varchar2 default hr_api.g_varchar2
771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2

Line 775: ,p_people_group_id in number default hr_api.g_number

771: ,p_position_id in number default hr_api.g_number
772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date

Line 776: ,p_location_id in number default hr_api.g_number

772: ,p_job_id in number default hr_api.g_number
773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2

Line 777: ,p_recruiter_id in number default hr_api.g_number

773: ,p_grade_id in number default hr_api.g_number
774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number

Line 778: ,p_comments in varchar2 default hr_api.g_varchar2

774: ,p_organization_id in number default hr_api.g_number
775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2

Line 779: ,p_date_to in date default hr_api.g_date

775: ,p_people_group_id in number default hr_api.g_number
776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number

Line 780: ,p_description in varchar2 default hr_api.g_varchar2

776: ,p_location_id in number default hr_api.g_number
777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number

Line 781: ,p_number_of_openings in number default hr_api.g_number

777: ,p_recruiter_id in number default hr_api.g_number
778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number

Line 782: ,p_status in varchar2 default hr_api.g_varchar2

778: ,p_comments in varchar2 default hr_api.g_varchar2
779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date

Line 783: ,p_request_id in number default hr_api.g_number

779: ,p_date_to in date default hr_api.g_date
780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 784: ,p_program_application_id in number default hr_api.g_number

780: ,p_description in varchar2 default hr_api.g_varchar2
781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
787: ,p_attribute_category in varchar2 default hr_api.g_varchar2
788: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 785: ,p_program_id in number default hr_api.g_number

781: ,p_number_of_openings in number default hr_api.g_number
782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
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_program_update_date in date default hr_api.g_date

782: ,p_status in varchar2 default hr_api.g_varchar2
783: ,p_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
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_request_id in number default hr_api.g_number
784: ,p_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
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_program_application_id in number default hr_api.g_number
785: ,p_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
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_program_id in number default hr_api.g_number
786: ,p_program_update_date in date default hr_api.g_date
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_program_update_date in date default hr_api.g_date
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_vacancy_category 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number

Line 808: ,p_vacancy_category 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number

Line 809: ,p_vacancy_region_type 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2

Line 810: ,p_budget_measurement_type 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_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number

Line 811: ,p_budget_measurement_value in number default hr_api.g_number

807: ,p_attribute20 in varchar2 default hr_api.g_varchar2
808: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number
815: ,p_assessment_id in number default hr_api.g_number

Line 812: ,p_manager_id in number default hr_api.g_number

808: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number
815: ,p_assessment_id in number default hr_api.g_number
816: ,p_inv_pos_grade_warning out nocopy boolean

Line 813: ,p_security_method in varchar2 default hr_api.g_varchar2

809: ,p_vacancy_region_type in varchar2 default hr_api.g_varchar2
810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number
815: ,p_assessment_id in number default hr_api.g_number
816: ,p_inv_pos_grade_warning out nocopy boolean
817: ,p_inv_job_grade_warning out nocopy boolean

Line 814: ,p_primary_posting_id in number default hr_api.g_number

810: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number
815: ,p_assessment_id in number default hr_api.g_number
816: ,p_inv_pos_grade_warning out nocopy boolean
817: ,p_inv_job_grade_warning out nocopy boolean
818: ) is

Line 815: ,p_assessment_id in number default hr_api.g_number

811: ,p_budget_measurement_value in number default hr_api.g_number
812: ,p_manager_id in number default hr_api.g_number
813: ,p_security_method in varchar2 default hr_api.g_varchar2
814: ,p_primary_posting_id in number default hr_api.g_number
815: ,p_assessment_id in number default hr_api.g_number
816: ,p_inv_pos_grade_warning out nocopy boolean
817: ,p_inv_job_grade_warning out nocopy boolean
818: ) is
819: --