495: g_number constant number := -987123654;
496: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
497: ==========================================================================
498: */
499: l_per_rec.person_type_id := hr_api.g_number;
500: l_per_rec.vendor_id := hr_api.g_number;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
496: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
497: ==========================================================================
498: */
499: l_per_rec.person_type_id := hr_api.g_number;
500: l_per_rec.vendor_id := hr_api.g_number;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
504:
497: ==========================================================================
498: */
499: l_per_rec.person_type_id := hr_api.g_number;
500: l_per_rec.vendor_id := hr_api.g_number;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
498: */
499: l_per_rec.person_type_id := hr_api.g_number;
500: l_per_rec.vendor_id := hr_api.g_number;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
506:
499: l_per_rec.person_type_id := hr_api.g_number;
500: l_per_rec.vendor_id := hr_api.g_number;
501: --l_per_rec.benefit_group_id := hr_api.g_number;
502: l_per_rec.party_id := hr_api.g_number;
503: l_per_rec.comment_id := hr_api.g_number;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
503: l_per_rec.comment_id := hr_api.g_number;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
504:
505: Hr_Utility.set_location(l_proc_name, 6);
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
505: Hr_Utility.set_location(l_proc_name, 6);
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
506:
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
507: --l_per_rec.date_employee_data_verified := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
508: --l_per_rec.date_of_birth := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
509: --l_per_rec.original_date_of_hire := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
510: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
511: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
513: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
514: --l_per_rec.resume_last_updated := hr_api.g_date;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
515: --l_per_rec.last_medical_test_date := hr_api.g_date;
516: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
517: --l_per_rec.background_date_check := hr_api.g_date;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
518: --l_per_rec.date_of_death := hr_api.g_date;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
519: --l_per_rec.projected_start_date := hr_api.g_date;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
520:
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
521: l_per_rec.last_name := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
522: l_per_rec.applicant_number := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
523: l_per_rec.email_address := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
524: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
525: l_per_rec.first_name := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
526: l_per_rec.known_as := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
527: l_per_rec.marital_status := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
528: l_per_rec.middle_names := hr_api.g_varchar2;
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
529: l_per_rec.nationality := hr_api.g_varchar2;
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
530: l_per_rec.national_identifier := hr_api.g_varchar2;
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
538:
531: l_per_rec.previous_last_name := hr_api.g_varchar2;
532: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
533: l_per_rec.sex := hr_api.g_varchar2;
534: l_per_rec.title := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
535: l_per_rec.work_telephone := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
536:
537: Hr_Utility.set_location(l_proc_name, 7);
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
537: Hr_Utility.set_location(l_proc_name, 7);
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
538:
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
539: l_per_rec.attribute_category := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
540: l_per_rec.attribute1 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
541: l_per_rec.attribute2 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
542: l_per_rec.attribute3 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
543: l_per_rec.attribute4 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
544: l_per_rec.attribute5 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
545: l_per_rec.attribute6 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
546: l_per_rec.attribute7 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
547: l_per_rec.attribute8 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
548: l_per_rec.attribute9 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
549: l_per_rec.attribute10 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
550: l_per_rec.attribute11 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
551: l_per_rec.attribute12 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
552: l_per_rec.attribute13 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
553: l_per_rec.attribute14 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
554: l_per_rec.attribute15 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
555: l_per_rec.attribute16 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
556: l_per_rec.attribute17 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
557: l_per_rec.attribute18 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
558: l_per_rec.attribute19 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
559: l_per_rec.attribute20 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
560: l_per_rec.attribute21 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
561: l_per_rec.attribute22 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
562: l_per_rec.attribute23 := hr_api.g_varchar2;
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
563: l_per_rec.attribute24 := hr_api.g_varchar2;
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
564: l_per_rec.attribute25 := hr_api.g_varchar2;
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
572:
565: l_per_rec.attribute26 := hr_api.g_varchar2;
566: l_per_rec.attribute27 := hr_api.g_varchar2;
567: l_per_rec.attribute28 := hr_api.g_varchar2;
568: l_per_rec.attribute29 := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
569: l_per_rec.attribute30 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
570:
571: Hr_Utility.set_location(l_proc_name, 8);
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
571: Hr_Utility.set_location(l_proc_name, 8);
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
572:
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
573: l_per_rec.per_information_category := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
574: l_per_rec.per_information1 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
575: l_per_rec.per_information2 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
576: l_per_rec.per_information3 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
577: l_per_rec.per_information4 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
578: l_per_rec.per_information5 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
579: l_per_rec.per_information6 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
580: l_per_rec.per_information7 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
581: l_per_rec.per_information8 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
582: l_per_rec.per_information9 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
583: l_per_rec.per_information10 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
584: l_per_rec.per_information11 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
585: l_per_rec.per_information12 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
586: l_per_rec.per_information13 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
587: l_per_rec.per_information14 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
588: l_per_rec.per_information15 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
589: l_per_rec.per_information16 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
590: l_per_rec.per_information17 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
591: l_per_rec.per_information18 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
592: l_per_rec.per_information19 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
593: l_per_rec.per_information20 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
594: l_per_rec.per_information21 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
595: l_per_rec.per_information22 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
596: l_per_rec.per_information23 := hr_api.g_varchar2;
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
597: l_per_rec.per_information24 := hr_api.g_varchar2;
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
598: l_per_rec.per_information25 := hr_api.g_varchar2;
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
606:
599: l_per_rec.per_information26 := hr_api.g_varchar2;
600: l_per_rec.per_information27 := hr_api.g_varchar2;
601: l_per_rec.per_information28 := hr_api.g_varchar2;
602: l_per_rec.per_information29 := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
603: l_per_rec.per_information30 := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
604:
605: Hr_Utility.set_location(l_proc_name, 9);
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
605: Hr_Utility.set_location(l_proc_name, 9);
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
606:
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
607: l_per_rec.background_check_status := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
608: l_per_rec.blood_type := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
609: l_per_rec.correspondence_language := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
610: l_per_rec.fast_path_employee := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
611: l_per_rec.honors := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
612: l_per_rec.internal_location := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
613: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
614: l_per_rec.mailstop := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
615: l_per_rec.office_number := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
616: l_per_rec.on_military_service := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
617: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
618: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
619: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
620: l_per_rec.resume_exists := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
621: l_per_rec.second_passport_exists := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
622: l_per_rec.student_status := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
623: l_per_rec.work_schedule := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
624: l_per_rec.rehire_reason := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
625: l_per_rec.suffix := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
626: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
627: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
628: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
639:
632: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
639:
640: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
633: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
639:
640: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
641: return l_per_rec;
634: l_per_rec.town_of_birth := hr_api.g_varchar2;
635: l_per_rec.region_of_birth := hr_api.g_varchar2;
636: l_per_rec.country_of_birth := hr_api.g_varchar2;
637: l_per_rec.global_person_id := hr_api.g_varchar2;
638: l_per_rec.npw_number := hr_api.g_varchar2;
639:
640: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
641: return l_per_rec;
642: exception
968: g_number constant number := -987123654;
969: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
970: ======================================================================
971: */
972: l_asg_rec.grade_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
969: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
970: ======================================================================
971: */
972: l_asg_rec.grade_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
970: ======================================================================
971: */
972: l_asg_rec.grade_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
971: */
972: l_asg_rec.grade_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
972: l_asg_rec.grade_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
973: l_asg_rec.position_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
974: l_asg_rec.job_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
975: l_asg_rec.payroll_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
976: l_asg_rec.location_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
977: l_asg_rec.organization_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
978: l_asg_rec.pay_basis_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
979: l_asg_rec.employment_category := hr_api.g_varchar2;
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
980: l_asg_rec.contract_id := hr_api.g_number;
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
981: l_asg_rec.establishment_id := hr_api.g_number;
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
989:
982: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
983: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
984: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
985: l_asg_rec.people_group_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
986: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
987:
988: Hr_Utility.set_location(l_proc_name, 10);
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
988: Hr_Utility.set_location(l_proc_name, 10);
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
989:
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
990: l_asg_rec.supervisor_id := hr_api.g_number;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
991: l_asg_rec.assignment_number := hr_api.g_varchar2;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
992: l_asg_rec.change_reason := hr_api.g_varchar2;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
993: l_asg_rec.assignment_status_type_id := hr_api.g_number;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
994: l_asg_rec.date_probation_end := hr_api.g_date;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
995: l_asg_rec.default_code_comb_id := hr_api.g_number;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
996: l_asg_rec.frequency := hr_api.g_varchar2;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
997: l_asg_rec.internal_address_line := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
998: l_asg_rec.manager_flag := hr_api.g_varchar2;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
999: l_asg_rec.normal_hours := hr_api.g_number;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1000: l_asg_rec.perf_review_period := hr_api.g_number;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1001: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1002: l_asg_rec.probation_period := hr_api.g_number;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1003: l_asg_rec.probation_unit := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1004: l_asg_rec.sal_review_period := hr_api.g_number;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1006: l_asg_rec.set_of_books_id := hr_api.g_number;
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1007: l_asg_rec.source_type := hr_api.g_varchar2;
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1008: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1010: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1011: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1012: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1013:
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1014: Hr_Utility.set_location(l_proc_name, 15);
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1015:
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1016: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1017: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1040: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1041: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1042: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1047:
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1048: Hr_Utility.set_location(l_proc_name, 20);
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1049:
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1050: l_asg_rec.title := hr_api.g_varchar2;
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1058:
1051: l_asg_rec.contract_id := hr_api.g_number;
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1058:
1059: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1052: l_asg_rec.establishment_id := hr_api.g_number;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1058:
1059: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1060: return l_asg_rec;
1053: l_asg_rec.collective_agreement_id := hr_api.g_number;
1054: l_asg_rec.notice_period := hr_api.g_number;
1055: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1056: l_asg_rec.employee_category := hr_api.g_varchar2;
1057: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1058:
1059: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1060: return l_asg_rec;
1061: exception
1090:
1091: begin
1092: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1093: --$ check if secondary assignment is to be created
1094: -- If yes (i.e. flag is set to 1 ) then initialize to null else to hr_api variable
1095: -- type
1096: if g_sec_asg_flag <> 1 then
1097: l_asg_rec := Default_Assignment_Rec;
1098: elsif g_sec_asg_flag = 1 then
1285: begin
1286: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1287: /*
1288: ======================================================================
1289: hr_api defaults:
1290: g_varchar2 constant varchar2(9):= '$Sys_Def$';
1291: g_number constant number := -987123654;
1292: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1293: ======================================================================
1291: g_number constant number := -987123654;
1292: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1293: ======================================================================
1294: */
1295: l_grp_rec.group_name := hr_api.g_varchar2;
1296:
1297: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1295: l_grp_rec.group_name := hr_api.g_varchar2;
1296:
1297: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1296:
1297: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1297: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1298:
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1299: l_grp_rec.segment1 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1300: l_grp_rec.segment2 := hr_api.g_varchar2;
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1301: l_grp_rec.segment3 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1302: l_grp_rec.segment4 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1303: l_grp_rec.segment5 := hr_api.g_varchar2;
1304: l_grp_rec.segment6 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1305: l_grp_rec.segment7 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1306: l_grp_rec.segment8 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1307: l_grp_rec.segment9 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1308: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1309: l_grp_rec.segment10 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1310: l_grp_rec.segment11 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1311: l_grp_rec.segment12 := hr_api.g_varchar2;
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1312: l_grp_rec.segment13 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1313: l_grp_rec.segment14 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1314: l_grp_rec.segment15 := hr_api.g_varchar2;
1315: l_grp_rec.segment16 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1316: l_grp_rec.segment17 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1317: l_grp_rec.segment18 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1318: l_grp_rec.segment19 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1319: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1320: l_grp_rec.segment20 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1321: l_grp_rec.segment21 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1322: l_grp_rec.segment22 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1323: l_grp_rec.segment23 := hr_api.g_varchar2;
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1331:
1324: l_grp_rec.segment24 := hr_api.g_varchar2;
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1331:
1332: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1325: l_grp_rec.segment25 := hr_api.g_varchar2;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1331:
1332: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1333: return l_grp_rec;
1326: l_grp_rec.segment26 := hr_api.g_varchar2;
1327: l_grp_rec.segment27 := hr_api.g_varchar2;
1328: l_grp_rec.segment28 := hr_api.g_varchar2;
1329: l_grp_rec.segment29 := hr_api.g_varchar2;
1330: l_grp_rec.segment30 := hr_api.g_varchar2;
1331:
1332: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1333: return l_grp_rec;
1334:
1457: g_number constant number := -987123654;
1458: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1459: ======================================================================
1460: */
1461: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1458: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1459: ======================================================================
1460: */
1461: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1459: ======================================================================
1460: */
1461: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1460: */
1461: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1461: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1462: l_scl_rec.segment1 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1463: l_scl_rec.segment2 := hr_api.g_varchar2;
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1464: l_scl_rec.segment3 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1465: l_scl_rec.segment4 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1466: l_scl_rec.segment5 := hr_api.g_varchar2;
1467: l_scl_rec.segment6 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1468: l_scl_rec.segment7 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1469: l_scl_rec.segment8 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1470: l_scl_rec.segment9 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1471: Hr_Utility.set_location(l_proc_name, 15);
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1472: l_scl_rec.segment10 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1473: l_scl_rec.segment11 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1474: l_scl_rec.segment12 := hr_api.g_varchar2;
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1475: l_scl_rec.segment13 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1476: l_scl_rec.segment14 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1477: l_scl_rec.segment15 := hr_api.g_varchar2;
1478: l_scl_rec.segment16 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1479: l_scl_rec.segment17 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1480: l_scl_rec.segment18 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1481: l_scl_rec.segment19 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1482: Hr_Utility.set_location(l_proc_name, 20);
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1483: l_scl_rec.segment20 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1484: l_scl_rec.segment21 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1485: l_scl_rec.segment22 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1486: l_scl_rec.segment23 := hr_api.g_varchar2;
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1494:
1487: l_scl_rec.segment24 := hr_api.g_varchar2;
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1494:
1495: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1488: l_scl_rec.segment25 := hr_api.g_varchar2;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1494:
1495: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1496: return l_scl_rec;
1489: l_scl_rec.segment26 := hr_api.g_varchar2;
1490: l_scl_rec.segment27 := hr_api.g_varchar2;
1491: l_scl_rec.segment28 := hr_api.g_varchar2;
1492: l_scl_rec.segment29 := hr_api.g_varchar2;
1493: l_scl_rec.segment30 := hr_api.g_varchar2;
1494:
1495: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1496: return l_scl_rec;
1497: exception
7351: -- DP interface tables
7352: cursor csr_get_dp_mode (c_batch_id in number
7353: ,c_link_value in number) is
7354: select 'CREATE'
7355: from hr_api_modules
7356: where module_name = 'CREATE_EMPLOYEE'
7357: and module_package = 'HR_EMPLOYEE_API'
7358: and api_module_id in (select api_module_id
7359: from hr_pump_batch_lines
7364: cursor csr_get_api_names (c_batch_id in number
7365: ,c_link_value in number) is
7366: select module_name
7367: from hr_pump_batch_lines hpbl
7368: ,hr_api_modules ham
7369: where batch_id = c_batch_id
7370: and link_value = c_link_value
7371: and line_status in ('U', 'E')
7372: and hpbl.api_module_id = ham.api_module_id;
7464: l_proc_name constant varchar2(150):= g_pkg ||'HR_DataPumpErr';
7465:
7466: l_dp_mode varchar2(40);
7467: l_if_end_dated varchar2(20);
7468: l_api_name hr_api_modules.module_name%type;
7469: l_user_person_type per_person_types.user_person_type%type;
7470: l_pay_basis_name per_pay_bases.name%type;
7471: l_organization_name hr_all_organization_units.name%type;
7472: l_location_code hr_locations_all.location_code%type;