APPS.PER_VAC_UPD dependencies on HR_API

Line 129: When hr_api.check_integrity_violated then

125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 10);
127: --
128: Exception
129: When hr_api.check_integrity_violated then
130: -- A check constraint has been violated
131: per_vac_shd.g_api_dml := false; -- Unset the dml status
132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

129: When hr_api.check_integrity_violated then
130: -- A check constraint has been violated
131: per_vac_shd.g_api_dml := false; -- Unset the dml status
132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error

Line 134: When hr_api.parent_integrity_violated then

130: -- A check constraint has been violated
131: per_vac_shd.g_api_dml := false; -- Unset the dml status
132: per_vac_shd.constraint_error
133: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

134: When hr_api.parent_integrity_violated then
135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error

Line 139: When hr_api.unique_integrity_violated then

135: -- Parent integrity has been violated
136: per_vac_shd.g_api_dml := false; -- Unset the dml status
137: per_vac_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

139: When hr_api.unique_integrity_violated then
140: -- Unique integrity has been violated
141: per_vac_shd.g_api_dml := false; -- Unset the dml status
142: per_vac_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When Others then
145: per_vac_shd.g_api_dml := false; -- Unset the dml status
146: Raise;
147: End update_dml;

Line 437: when hr_api.cannot_find_prog_unit then

433: );
434: --
435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'PER_ALL_VACANCIES'
441: ,p_hook_type => 'AU');

Line 439: hr_api.cannot_find_prog_unit_error

435: exception
436: --
437: when hr_api.cannot_find_prog_unit then
438: --
439: hr_api.cannot_find_prog_unit_error
440: (p_module_name => 'PER_ALL_VACANCIES'
441: ,p_hook_type => 'AU');
442: --
443: end;

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

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

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

502: if (p_rec.business_group_id = hr_api.g_number) then
503: p_rec.business_group_id :=
504: per_vac_shd.g_old_rec.business_group_id;
505: end if;
506: if (p_rec.position_id = hr_api.g_number) then
507: p_rec.position_id :=
508: per_vac_shd.g_old_rec.position_id;
509: end if;
510: if (p_rec.job_id = hr_api.g_number) then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

666: if (p_rec.vacancy_category = hr_api.g_varchar2) then
667: p_rec.vacancy_category :=
668: per_vac_shd.g_old_rec.vacancy_category;
669: end if;
670: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
671: p_rec.budget_measurement_type :=
672: per_vac_shd.g_old_rec.budget_measurement_type;
673: end if;
674: if (p_rec.budget_measurement_value = hr_api.g_number) then

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

670: if (p_rec.budget_measurement_type = hr_api.g_varchar2) then
671: p_rec.budget_measurement_type :=
672: per_vac_shd.g_old_rec.budget_measurement_type;
673: end if;
674: if (p_rec.budget_measurement_value = hr_api.g_number) then
675: p_rec.budget_measurement_value :=
676: per_vac_shd.g_old_rec.budget_measurement_value;
677: end if;
678: if (p_rec.manager_id = hr_api.g_number) then

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

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

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

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

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

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

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

686: if (p_rec.primary_posting_id = hr_api.g_number) then
687: p_rec.primary_posting_id :=
688: per_vac_shd.g_old_rec.primary_posting_id;
689: end if;
690: if (p_rec.assessment_id = hr_api.g_number) then
691: p_rec.assessment_id :=
692: per_vac_shd.g_old_rec.assessment_id;
693: end if;
694: --

Line 758: ,p_business_group_id in number default hr_api.g_number

754: Procedure upd
755: (p_effective_date in date
756: ,p_vacancy_id in number
757: ,p_object_version_number in out nocopy number
758: ,p_business_group_id in number default hr_api.g_number
759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number

Line 759: ,p_requisition_id in number default hr_api.g_number

755: (p_effective_date in date
756: ,p_vacancy_id in number
757: ,p_object_version_number in out nocopy number
758: ,p_business_group_id in number default hr_api.g_number
759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number

Line 760: ,p_date_from in date default hr_api.g_date

756: ,p_vacancy_id in number
757: ,p_object_version_number in out nocopy number
758: ,p_business_group_id in number default hr_api.g_number
759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number

Line 761: ,p_name in varchar2 default hr_api.g_varchar2

757: ,p_object_version_number in out nocopy number
758: ,p_business_group_id in number default hr_api.g_number
759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number

Line 762: ,p_position_id in number default hr_api.g_number

758: ,p_business_group_id in number default hr_api.g_number
759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number

Line 763: ,p_job_id in number default hr_api.g_number

759: ,p_requisition_id in number default hr_api.g_number
760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number

Line 764: ,p_grade_id in number default hr_api.g_number

760: ,p_date_from in date default hr_api.g_date
761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number

Line 765: ,p_organization_id in number default hr_api.g_number

761: ,p_name in varchar2 default hr_api.g_varchar2
762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2

Line 766: ,p_people_group_id in number default hr_api.g_number

762: ,p_position_id in number default hr_api.g_number
763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date

Line 767: ,p_location_id in number default hr_api.g_number

763: ,p_job_id in number default hr_api.g_number
764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2

Line 768: ,p_recruiter_id in number default hr_api.g_number

764: ,p_grade_id in number default hr_api.g_number
765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number

Line 769: ,p_comments in varchar2 default hr_api.g_varchar2

765: ,p_organization_id in number default hr_api.g_number
766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2

Line 770: ,p_date_to in date default hr_api.g_date

766: ,p_people_group_id in number default hr_api.g_number
767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2
774: ,p_request_id in number default hr_api.g_number

Line 771: ,p_description in varchar2 default hr_api.g_varchar2

767: ,p_location_id in number default hr_api.g_number
768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2
774: ,p_request_id in number default hr_api.g_number
775: ,p_program_application_id in number default hr_api.g_number

Line 772: ,p_number_of_openings in number default hr_api.g_number

768: ,p_recruiter_id in number default hr_api.g_number
769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2
774: ,p_request_id in number default hr_api.g_number
775: ,p_program_application_id in number default hr_api.g_number
776: ,p_program_id in number default hr_api.g_number

Line 773: ,p_status in varchar2 default hr_api.g_varchar2

769: ,p_comments in varchar2 default hr_api.g_varchar2
770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2
774: ,p_request_id in number default hr_api.g_number
775: ,p_program_application_id in number default hr_api.g_number
776: ,p_program_id in number default hr_api.g_number
777: ,p_program_update_date in date default hr_api.g_date

Line 774: ,p_request_id in number default hr_api.g_number

770: ,p_date_to in date default hr_api.g_date
771: ,p_description in varchar2 default hr_api.g_varchar2
772: ,p_number_of_openings in number default hr_api.g_number
773: ,p_status in varchar2 default hr_api.g_varchar2
774: ,p_request_id in number default hr_api.g_number
775: ,p_program_application_id in number default hr_api.g_number
776: ,p_program_id in number default hr_api.g_number
777: ,p_program_update_date in date default hr_api.g_date
778: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 775: ,p_program_application_id in number default hr_api.g_number

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

Line 776: ,p_program_id in number default hr_api.g_number

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

Line 777: ,p_program_update_date in date default hr_api.g_date

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

Line 778: ,p_attribute_category in varchar2 default hr_api.g_varchar2

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

Line 779: ,p_attribute1 in varchar2 default hr_api.g_varchar2

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

Line 780: ,p_attribute2 in varchar2 default hr_api.g_varchar2

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

Line 781: ,p_attribute3 in varchar2 default hr_api.g_varchar2

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

Line 782: ,p_attribute4 in varchar2 default hr_api.g_varchar2

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

Line 783: ,p_attribute5 in varchar2 default hr_api.g_varchar2

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

Line 784: ,p_attribute6 in varchar2 default hr_api.g_varchar2

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

Line 785: ,p_attribute7 in varchar2 default hr_api.g_varchar2

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

Line 786: ,p_attribute8 in varchar2 default hr_api.g_varchar2

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

Line 787: ,p_attribute9 in varchar2 default hr_api.g_varchar2

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

Line 788: ,p_attribute10 in varchar2 default hr_api.g_varchar2

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

Line 789: ,p_attribute11 in varchar2 default hr_api.g_varchar2

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

Line 790: ,p_attribute12 in varchar2 default hr_api.g_varchar2

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

Line 791: ,p_attribute13 in varchar2 default hr_api.g_varchar2

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

Line 792: ,p_attribute14 in varchar2 default hr_api.g_varchar2

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

Line 793: ,p_attribute15 in varchar2 default hr_api.g_varchar2

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

Line 794: ,p_attribute16 in varchar2 default hr_api.g_varchar2

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

Line 795: ,p_attribute17 in varchar2 default hr_api.g_varchar2

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

Line 796: ,p_attribute18 in varchar2 default hr_api.g_varchar2

792: ,p_attribute14 in varchar2 default hr_api.g_varchar2
793: ,p_attribute15 in varchar2 default hr_api.g_varchar2
794: ,p_attribute16 in varchar2 default hr_api.g_varchar2
795: ,p_attribute17 in varchar2 default hr_api.g_varchar2
796: ,p_attribute18 in varchar2 default hr_api.g_varchar2
797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2

Line 797: ,p_attribute19 in varchar2 default hr_api.g_varchar2

793: ,p_attribute15 in varchar2 default hr_api.g_varchar2
794: ,p_attribute16 in varchar2 default hr_api.g_varchar2
795: ,p_attribute17 in varchar2 default hr_api.g_varchar2
796: ,p_attribute18 in varchar2 default hr_api.g_varchar2
797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number

Line 798: ,p_attribute20 in varchar2 default hr_api.g_varchar2

794: ,p_attribute16 in varchar2 default hr_api.g_varchar2
795: ,p_attribute17 in varchar2 default hr_api.g_varchar2
796: ,p_attribute18 in varchar2 default hr_api.g_varchar2
797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number

Line 799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2

795: ,p_attribute17 in varchar2 default hr_api.g_varchar2
796: ,p_attribute18 in varchar2 default hr_api.g_varchar2
797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2

Line 800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2

796: ,p_attribute18 in varchar2 default hr_api.g_varchar2
797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number

Line 801: ,p_budget_measurement_value in number default hr_api.g_number

797: ,p_attribute19 in varchar2 default hr_api.g_varchar2
798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number
805: ,p_assessment_id in number default hr_api.g_number

Line 802: ,p_manager_id in number default hr_api.g_number

798: ,p_attribute20 in varchar2 default hr_api.g_varchar2
799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number
805: ,p_assessment_id in number default hr_api.g_number
806: ,p_inv_pos_grade_warning out nocopy boolean

Line 803: ,p_security_method in varchar2 default hr_api.g_varchar2

799: ,p_vacancy_category in varchar2 default hr_api.g_varchar2
800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number
805: ,p_assessment_id in number default hr_api.g_number
806: ,p_inv_pos_grade_warning out nocopy boolean
807: ,p_inv_job_grade_warning out nocopy boolean

Line 804: ,p_primary_posting_id in number default hr_api.g_number

800: ,p_budget_measurement_type in varchar2 default hr_api.g_varchar2
801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number
805: ,p_assessment_id in number default hr_api.g_number
806: ,p_inv_pos_grade_warning out nocopy boolean
807: ,p_inv_job_grade_warning out nocopy boolean
808: ) is

Line 805: ,p_assessment_id in number default hr_api.g_number

801: ,p_budget_measurement_value in number default hr_api.g_number
802: ,p_manager_id in number default hr_api.g_number
803: ,p_security_method in varchar2 default hr_api.g_varchar2
804: ,p_primary_posting_id in number default hr_api.g_number
805: ,p_assessment_id in number default hr_api.g_number
806: ,p_inv_pos_grade_warning out nocopy boolean
807: ,p_inv_job_grade_warning out nocopy boolean
808: ) is
809: --