119: --
120: hr_utility.set_location(' Leaving:'||l_proc, 20);
121: --
122: Exception
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_evt_shd.g_api_dml := false; -- Unset the api dml status
126: per_evt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.check_integrity_violated Then
124: -- A check constraint has been violated
125: per_evt_shd.g_api_dml := false; -- Unset the api dml status
126: per_evt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_evt_shd.g_api_dml := false; -- Unset the api dml status
131: per_evt_shd.constraint_error
124: -- A check constraint has been violated
125: per_evt_shd.g_api_dml := false; -- Unset the api dml status
126: per_evt_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_evt_shd.g_api_dml := false; -- Unset the api dml status
131: per_evt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When hr_api.parent_integrity_violated Then
129: -- Parent integrity has been violated
130: per_evt_shd.g_api_dml := false; -- Unset the api dml status
131: per_evt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_evt_shd.g_api_dml := false; -- Unset the api dml status
136: per_evt_shd.constraint_error
129: -- Parent integrity has been violated
130: per_evt_shd.g_api_dml := false; -- Unset the api dml status
131: per_evt_shd.constraint_error
132: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_evt_shd.g_api_dml := false; -- Unset the api dml status
136: per_evt_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
133: When hr_api.unique_integrity_violated Then
134: -- Unique integrity has been violated
135: per_evt_shd.g_api_dml := false; -- Unset the api dml status
136: per_evt_shd.constraint_error
137: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
138: When Others Then
139: per_evt_shd.g_api_dml := false; -- Unset the api dml status
140: Raise;
141: End update_dml;
396: );
397: --
398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'PER_EVENTS'
404: ,p_hook_type => 'AU');
398: exception
399: --
400: when hr_api.cannot_find_prog_unit then
401: --
402: hr_api.cannot_find_prog_unit_error
403: (p_module_name => 'PER_EVENTS'
404: ,p_hook_type => 'AU');
405: --
406: end;
461: -- p_rec plsql record structure
462: -- to see if a system default is being used. If a system default
463: -- is being used then we must set to the 'current' argument value.
464: --
465: If (p_rec.business_group_id = hr_api.g_number) then
466: p_rec.business_group_id :=
467: per_evt_shd.g_old_rec.business_group_id;
468: End If;
469: If (p_rec.location_id = hr_api.g_number) then
465: If (p_rec.business_group_id = hr_api.g_number) then
466: p_rec.business_group_id :=
467: per_evt_shd.g_old_rec.business_group_id;
468: End If;
469: If (p_rec.location_id = hr_api.g_number) then
470: p_rec.location_id :=
471: per_evt_shd.g_old_rec.location_id;
472: End If;
473: If (p_rec.internal_contact_person_id = hr_api.g_number) then
469: If (p_rec.location_id = hr_api.g_number) then
470: p_rec.location_id :=
471: per_evt_shd.g_old_rec.location_id;
472: End If;
473: If (p_rec.internal_contact_person_id = hr_api.g_number) then
474: p_rec.internal_contact_person_id :=
475: per_evt_shd.g_old_rec.internal_contact_person_id;
476: End If;
477: If (p_rec.organization_run_by_id = hr_api.g_number) then
473: If (p_rec.internal_contact_person_id = hr_api.g_number) then
474: p_rec.internal_contact_person_id :=
475: per_evt_shd.g_old_rec.internal_contact_person_id;
476: End If;
477: If (p_rec.organization_run_by_id = hr_api.g_number) then
478: p_rec.organization_run_by_id :=
479: per_evt_shd.g_old_rec.organization_run_by_id;
480: End If;
481: If (p_rec.assignment_id = hr_api.g_number) then
477: If (p_rec.organization_run_by_id = hr_api.g_number) then
478: p_rec.organization_run_by_id :=
479: per_evt_shd.g_old_rec.organization_run_by_id;
480: End If;
481: If (p_rec.assignment_id = hr_api.g_number) then
482: p_rec.assignment_id :=
483: per_evt_shd.g_old_rec.assignment_id;
484: End If;
485: If (p_rec.date_start = hr_api.g_date) then
481: If (p_rec.assignment_id = hr_api.g_number) then
482: p_rec.assignment_id :=
483: per_evt_shd.g_old_rec.assignment_id;
484: End If;
485: If (p_rec.date_start = hr_api.g_date) then
486: p_rec.date_start :=
487: per_evt_shd.g_old_rec.date_start;
488: End If;
489: If (p_rec.type = hr_api.g_varchar2) then
485: If (p_rec.date_start = hr_api.g_date) then
486: p_rec.date_start :=
487: per_evt_shd.g_old_rec.date_start;
488: End If;
489: If (p_rec.type = hr_api.g_varchar2) then
490: p_rec.type :=
491: per_evt_shd.g_old_rec.type;
492: End If;
493: If (p_rec.comments = hr_api.g_varchar2) then
489: If (p_rec.type = hr_api.g_varchar2) then
490: p_rec.type :=
491: per_evt_shd.g_old_rec.type;
492: End If;
493: If (p_rec.comments = hr_api.g_varchar2) then
494: p_rec.comments :=
495: per_evt_shd.g_old_rec.comments;
496: End If;
497: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
493: If (p_rec.comments = hr_api.g_varchar2) then
494: p_rec.comments :=
495: per_evt_shd.g_old_rec.comments;
496: End If;
497: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
498: p_rec.contact_telephone_number :=
499: per_evt_shd.g_old_rec.contact_telephone_number;
500: End If;
501: If (p_rec.date_end = hr_api.g_date) then
497: If (p_rec.contact_telephone_number = hr_api.g_varchar2) then
498: p_rec.contact_telephone_number :=
499: per_evt_shd.g_old_rec.contact_telephone_number;
500: End If;
501: If (p_rec.date_end = hr_api.g_date) then
502: p_rec.date_end :=
503: per_evt_shd.g_old_rec.date_end;
504: End If;
505: If (p_rec.emp_or_apl = hr_api.g_varchar2) then
501: If (p_rec.date_end = hr_api.g_date) then
502: p_rec.date_end :=
503: per_evt_shd.g_old_rec.date_end;
504: End If;
505: If (p_rec.emp_or_apl = hr_api.g_varchar2) then
506: p_rec.emp_or_apl :=
507: per_evt_shd.g_old_rec.emp_or_apl;
508: End If;
509: If (p_rec.event_or_interview = hr_api.g_varchar2) then
505: If (p_rec.emp_or_apl = hr_api.g_varchar2) then
506: p_rec.emp_or_apl :=
507: per_evt_shd.g_old_rec.emp_or_apl;
508: End If;
509: If (p_rec.event_or_interview = hr_api.g_varchar2) then
510: p_rec.event_or_interview :=
511: per_evt_shd.g_old_rec.event_or_interview;
512: End If;
513: If (p_rec.external_contact = hr_api.g_varchar2) then
509: If (p_rec.event_or_interview = hr_api.g_varchar2) then
510: p_rec.event_or_interview :=
511: per_evt_shd.g_old_rec.event_or_interview;
512: End If;
513: If (p_rec.external_contact = hr_api.g_varchar2) then
514: p_rec.external_contact :=
515: per_evt_shd.g_old_rec.external_contact;
516: End If;
517: If (p_rec.time_end = hr_api.g_varchar2) then
513: If (p_rec.external_contact = hr_api.g_varchar2) then
514: p_rec.external_contact :=
515: per_evt_shd.g_old_rec.external_contact;
516: End If;
517: If (p_rec.time_end = hr_api.g_varchar2) then
518: p_rec.time_end :=
519: per_evt_shd.g_old_rec.time_end;
520: End If;
521: If (p_rec.time_start = hr_api.g_varchar2) then
517: If (p_rec.time_end = hr_api.g_varchar2) then
518: p_rec.time_end :=
519: per_evt_shd.g_old_rec.time_end;
520: End If;
521: If (p_rec.time_start = hr_api.g_varchar2) then
522: p_rec.time_start :=
523: per_evt_shd.g_old_rec.time_start;
524: End If;
525: If (p_rec.request_id = hr_api.g_number) then
521: If (p_rec.time_start = hr_api.g_varchar2) then
522: p_rec.time_start :=
523: per_evt_shd.g_old_rec.time_start;
524: End If;
525: If (p_rec.request_id = hr_api.g_number) then
526: p_rec.request_id :=
527: per_evt_shd.g_old_rec.request_id;
528: End If;
529: If (p_rec.program_application_id = hr_api.g_number) then
525: If (p_rec.request_id = hr_api.g_number) then
526: p_rec.request_id :=
527: per_evt_shd.g_old_rec.request_id;
528: End If;
529: If (p_rec.program_application_id = hr_api.g_number) then
530: p_rec.program_application_id :=
531: per_evt_shd.g_old_rec.program_application_id;
532: End If;
533: If (p_rec.program_id = hr_api.g_number) then
529: If (p_rec.program_application_id = hr_api.g_number) then
530: p_rec.program_application_id :=
531: per_evt_shd.g_old_rec.program_application_id;
532: End If;
533: If (p_rec.program_id = hr_api.g_number) then
534: p_rec.program_id :=
535: per_evt_shd.g_old_rec.program_id;
536: End If;
537: If (p_rec.program_update_date = hr_api.g_date) then
533: If (p_rec.program_id = hr_api.g_number) then
534: p_rec.program_id :=
535: per_evt_shd.g_old_rec.program_id;
536: End If;
537: If (p_rec.program_update_date = hr_api.g_date) then
538: p_rec.program_update_date :=
539: per_evt_shd.g_old_rec.program_update_date;
540: End If;
541: If (p_rec.attribute_category = hr_api.g_varchar2) then
537: If (p_rec.program_update_date = hr_api.g_date) then
538: p_rec.program_update_date :=
539: per_evt_shd.g_old_rec.program_update_date;
540: End If;
541: If (p_rec.attribute_category = hr_api.g_varchar2) then
542: p_rec.attribute_category :=
543: per_evt_shd.g_old_rec.attribute_category;
544: End If;
545: If (p_rec.attribute1 = hr_api.g_varchar2) then
541: If (p_rec.attribute_category = hr_api.g_varchar2) then
542: p_rec.attribute_category :=
543: per_evt_shd.g_old_rec.attribute_category;
544: End If;
545: If (p_rec.attribute1 = hr_api.g_varchar2) then
546: p_rec.attribute1 :=
547: per_evt_shd.g_old_rec.attribute1;
548: End If;
549: If (p_rec.attribute2 = hr_api.g_varchar2) then
545: If (p_rec.attribute1 = hr_api.g_varchar2) then
546: p_rec.attribute1 :=
547: per_evt_shd.g_old_rec.attribute1;
548: End If;
549: If (p_rec.attribute2 = hr_api.g_varchar2) then
550: p_rec.attribute2 :=
551: per_evt_shd.g_old_rec.attribute2;
552: End If;
553: If (p_rec.attribute3 = hr_api.g_varchar2) then
549: If (p_rec.attribute2 = hr_api.g_varchar2) then
550: p_rec.attribute2 :=
551: per_evt_shd.g_old_rec.attribute2;
552: End If;
553: If (p_rec.attribute3 = hr_api.g_varchar2) then
554: p_rec.attribute3 :=
555: per_evt_shd.g_old_rec.attribute3;
556: End If;
557: If (p_rec.attribute4 = hr_api.g_varchar2) then
553: If (p_rec.attribute3 = hr_api.g_varchar2) then
554: p_rec.attribute3 :=
555: per_evt_shd.g_old_rec.attribute3;
556: End If;
557: If (p_rec.attribute4 = hr_api.g_varchar2) then
558: p_rec.attribute4 :=
559: per_evt_shd.g_old_rec.attribute4;
560: End If;
561: If (p_rec.attribute5 = hr_api.g_varchar2) then
557: If (p_rec.attribute4 = hr_api.g_varchar2) then
558: p_rec.attribute4 :=
559: per_evt_shd.g_old_rec.attribute4;
560: End If;
561: If (p_rec.attribute5 = hr_api.g_varchar2) then
562: p_rec.attribute5 :=
563: per_evt_shd.g_old_rec.attribute5;
564: End If;
565: If (p_rec.attribute6 = hr_api.g_varchar2) then
561: If (p_rec.attribute5 = hr_api.g_varchar2) then
562: p_rec.attribute5 :=
563: per_evt_shd.g_old_rec.attribute5;
564: End If;
565: If (p_rec.attribute6 = hr_api.g_varchar2) then
566: p_rec.attribute6 :=
567: per_evt_shd.g_old_rec.attribute6;
568: End If;
569: If (p_rec.attribute7 = hr_api.g_varchar2) then
565: If (p_rec.attribute6 = hr_api.g_varchar2) then
566: p_rec.attribute6 :=
567: per_evt_shd.g_old_rec.attribute6;
568: End If;
569: If (p_rec.attribute7 = hr_api.g_varchar2) then
570: p_rec.attribute7 :=
571: per_evt_shd.g_old_rec.attribute7;
572: End If;
573: If (p_rec.attribute8 = hr_api.g_varchar2) then
569: If (p_rec.attribute7 = hr_api.g_varchar2) then
570: p_rec.attribute7 :=
571: per_evt_shd.g_old_rec.attribute7;
572: End If;
573: If (p_rec.attribute8 = hr_api.g_varchar2) then
574: p_rec.attribute8 :=
575: per_evt_shd.g_old_rec.attribute8;
576: End If;
577: If (p_rec.attribute9 = hr_api.g_varchar2) then
573: If (p_rec.attribute8 = hr_api.g_varchar2) then
574: p_rec.attribute8 :=
575: per_evt_shd.g_old_rec.attribute8;
576: End If;
577: If (p_rec.attribute9 = hr_api.g_varchar2) then
578: p_rec.attribute9 :=
579: per_evt_shd.g_old_rec.attribute9;
580: End If;
581: If (p_rec.attribute10 = hr_api.g_varchar2) then
577: If (p_rec.attribute9 = hr_api.g_varchar2) then
578: p_rec.attribute9 :=
579: per_evt_shd.g_old_rec.attribute9;
580: End If;
581: If (p_rec.attribute10 = hr_api.g_varchar2) then
582: p_rec.attribute10 :=
583: per_evt_shd.g_old_rec.attribute10;
584: End If;
585: If (p_rec.attribute11 = hr_api.g_varchar2) then
581: If (p_rec.attribute10 = hr_api.g_varchar2) then
582: p_rec.attribute10 :=
583: per_evt_shd.g_old_rec.attribute10;
584: End If;
585: If (p_rec.attribute11 = hr_api.g_varchar2) then
586: p_rec.attribute11 :=
587: per_evt_shd.g_old_rec.attribute11;
588: End If;
589: If (p_rec.attribute12 = hr_api.g_varchar2) then
585: If (p_rec.attribute11 = hr_api.g_varchar2) then
586: p_rec.attribute11 :=
587: per_evt_shd.g_old_rec.attribute11;
588: End If;
589: If (p_rec.attribute12 = hr_api.g_varchar2) then
590: p_rec.attribute12 :=
591: per_evt_shd.g_old_rec.attribute12;
592: End If;
593: If (p_rec.attribute13 = hr_api.g_varchar2) then
589: If (p_rec.attribute12 = hr_api.g_varchar2) then
590: p_rec.attribute12 :=
591: per_evt_shd.g_old_rec.attribute12;
592: End If;
593: If (p_rec.attribute13 = hr_api.g_varchar2) then
594: p_rec.attribute13 :=
595: per_evt_shd.g_old_rec.attribute13;
596: End If;
597: If (p_rec.attribute14 = hr_api.g_varchar2) then
593: If (p_rec.attribute13 = hr_api.g_varchar2) then
594: p_rec.attribute13 :=
595: per_evt_shd.g_old_rec.attribute13;
596: End If;
597: If (p_rec.attribute14 = hr_api.g_varchar2) then
598: p_rec.attribute14 :=
599: per_evt_shd.g_old_rec.attribute14;
600: End If;
601: If (p_rec.attribute15 = hr_api.g_varchar2) then
597: If (p_rec.attribute14 = hr_api.g_varchar2) then
598: p_rec.attribute14 :=
599: per_evt_shd.g_old_rec.attribute14;
600: End If;
601: If (p_rec.attribute15 = hr_api.g_varchar2) then
602: p_rec.attribute15 :=
603: per_evt_shd.g_old_rec.attribute15;
604: End If;
605: If (p_rec.attribute16 = hr_api.g_varchar2) then
601: If (p_rec.attribute15 = hr_api.g_varchar2) then
602: p_rec.attribute15 :=
603: per_evt_shd.g_old_rec.attribute15;
604: End If;
605: If (p_rec.attribute16 = hr_api.g_varchar2) then
606: p_rec.attribute16 :=
607: per_evt_shd.g_old_rec.attribute16;
608: End If;
609: If (p_rec.attribute17 = hr_api.g_varchar2) then
605: If (p_rec.attribute16 = hr_api.g_varchar2) then
606: p_rec.attribute16 :=
607: per_evt_shd.g_old_rec.attribute16;
608: End If;
609: If (p_rec.attribute17 = hr_api.g_varchar2) then
610: p_rec.attribute17 :=
611: per_evt_shd.g_old_rec.attribute17;
612: End If;
613: If (p_rec.attribute18 = hr_api.g_varchar2) then
609: If (p_rec.attribute17 = hr_api.g_varchar2) then
610: p_rec.attribute17 :=
611: per_evt_shd.g_old_rec.attribute17;
612: End If;
613: If (p_rec.attribute18 = hr_api.g_varchar2) then
614: p_rec.attribute18 :=
615: per_evt_shd.g_old_rec.attribute18;
616: End If;
617: If (p_rec.attribute19 = hr_api.g_varchar2) then
613: If (p_rec.attribute18 = hr_api.g_varchar2) then
614: p_rec.attribute18 :=
615: per_evt_shd.g_old_rec.attribute18;
616: End If;
617: If (p_rec.attribute19 = hr_api.g_varchar2) then
618: p_rec.attribute19 :=
619: per_evt_shd.g_old_rec.attribute19;
620: End If;
621: If (p_rec.attribute20 = hr_api.g_varchar2) then
617: If (p_rec.attribute19 = hr_api.g_varchar2) then
618: p_rec.attribute19 :=
619: per_evt_shd.g_old_rec.attribute19;
620: End If;
621: If (p_rec.attribute20 = hr_api.g_varchar2) then
622: p_rec.attribute20 :=
623: per_evt_shd.g_old_rec.attribute20;
624: End If;
625: If (p_rec.party_id = hr_api.g_number) then
621: If (p_rec.attribute20 = hr_api.g_varchar2) then
622: p_rec.attribute20 :=
623: per_evt_shd.g_old_rec.attribute20;
624: End If;
625: If (p_rec.party_id = hr_api.g_number) then
626: p_rec.party_id :=
627: per_evt_shd.g_old_rec.party_id;
628: End If;
629: --
680: -- ----------------------------------------------------------------------------
681: Procedure upd
682: (p_event_id in number
683: ,p_object_version_number in out nocopy number
684: ,p_date_start in date default hr_api.g_date
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
681: Procedure upd
682: (p_event_id in number
683: ,p_object_version_number in out nocopy number
684: ,p_date_start in date default hr_api.g_date
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
682: (p_event_id in number
683: ,p_object_version_number in out nocopy number
684: ,p_date_start in date default hr_api.g_date
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
683: ,p_object_version_number in out nocopy number
684: ,p_date_start in date default hr_api.g_date
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
684: ,p_date_start in date default hr_api.g_date
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
685: ,p_type in varchar2 default hr_api.g_varchar2
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
686: ,p_business_group_id in number default hr_api.g_number
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
687: ,p_location_id in number default hr_api.g_number
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
688: ,p_internal_contact_person_id in number default hr_api.g_number
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
689: ,p_organization_run_by_id in number default hr_api.g_number
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
690: ,p_assignment_id in number default hr_api.g_number
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
691: ,p_comments in varchar2 default hr_api.g_varchar2
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
692: ,p_contact_telephone_number in varchar2 default hr_api.g_varchar2
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
693: ,p_date_end in date default hr_api.g_date
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
694: ,p_emp_or_apl in varchar2 default hr_api.g_varchar2
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
695: ,p_event_or_interview in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
696: ,p_external_contact in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
697: ,p_time_end in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
698: ,p_time_start in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
699: ,p_request_id in number default hr_api.g_number
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
700: ,p_program_application_id in number default hr_api.g_number
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
701: ,p_program_id in number default hr_api.g_number
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
702: ,p_program_update_date in date default hr_api.g_date
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
703: ,p_attribute_category in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
704: ,p_attribute1 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
705: ,p_attribute2 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
706: ,p_attribute3 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
707: ,p_attribute4 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
708: ,p_attribute5 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
709: ,p_attribute6 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
710: ,p_attribute7 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
711: ,p_attribute8 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
712: ,p_attribute9 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
713: ,p_attribute10 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
714: ,p_attribute11 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
715: ,p_attribute12 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
716: ,p_attribute13 in varchar2 default hr_api.g_varchar2
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
724: ,p_party_id in number default hr_api.g_number
717: ,p_attribute14 in varchar2 default hr_api.g_varchar2
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
724: ,p_party_id in number default hr_api.g_number
725: ) is
718: ,p_attribute15 in varchar2 default hr_api.g_varchar2
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
724: ,p_party_id in number default hr_api.g_number
725: ) is
726: --
719: ,p_attribute16 in varchar2 default hr_api.g_varchar2
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
724: ,p_party_id in number default hr_api.g_number
725: ) is
726: --
727: l_rec per_evt_shd.g_rec_type;
720: ,p_attribute17 in varchar2 default hr_api.g_varchar2
721: ,p_attribute18 in varchar2 default hr_api.g_varchar2
722: ,p_attribute19 in varchar2 default hr_api.g_varchar2
723: ,p_attribute20 in varchar2 default hr_api.g_varchar2
724: ,p_party_id in number default hr_api.g_number
725: ) is
726: --
727: l_rec per_evt_shd.g_rec_type;
728: l_proc varchar2(72) := g_package||'upd';