eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_PERASGADD_RIW dependencies on HR_API

Line 500: l_per_rec.person_type_id := hr_api.g_number;

496: g_number constant number := -987123654;
497: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
498: ==========================================================================
499: */
500: l_per_rec.person_type_id := hr_api.g_number;
501: l_per_rec.vendor_id := hr_api.g_number;
502: --l_per_rec.benefit_group_id := hr_api.g_number;
503: l_per_rec.party_id := hr_api.g_number;
504: l_per_rec.comment_id := hr_api.g_number;

Line 501: l_per_rec.vendor_id := hr_api.g_number;

497: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
498: ==========================================================================
499: */
500: l_per_rec.person_type_id := hr_api.g_number;
501: l_per_rec.vendor_id := hr_api.g_number;
502: --l_per_rec.benefit_group_id := hr_api.g_number;
503: l_per_rec.party_id := hr_api.g_number;
504: l_per_rec.comment_id := hr_api.g_number;
505:

Line 502: --l_per_rec.benefit_group_id := hr_api.g_number;

498: ==========================================================================
499: */
500: l_per_rec.person_type_id := hr_api.g_number;
501: l_per_rec.vendor_id := hr_api.g_number;
502: --l_per_rec.benefit_group_id := hr_api.g_number;
503: l_per_rec.party_id := hr_api.g_number;
504: l_per_rec.comment_id := hr_api.g_number;
505:
506: Hr_Utility.set_location(l_proc_name, 6);

Line 503: l_per_rec.party_id := hr_api.g_number;

499: */
500: l_per_rec.person_type_id := hr_api.g_number;
501: l_per_rec.vendor_id := hr_api.g_number;
502: --l_per_rec.benefit_group_id := hr_api.g_number;
503: l_per_rec.party_id := hr_api.g_number;
504: l_per_rec.comment_id := hr_api.g_number;
505:
506: Hr_Utility.set_location(l_proc_name, 6);
507:

Line 504: l_per_rec.comment_id := hr_api.g_number;

500: l_per_rec.person_type_id := hr_api.g_number;
501: l_per_rec.vendor_id := hr_api.g_number;
502: --l_per_rec.benefit_group_id := hr_api.g_number;
503: l_per_rec.party_id := hr_api.g_number;
504: l_per_rec.comment_id := hr_api.g_number;
505:
506: Hr_Utility.set_location(l_proc_name, 6);
507:
508: --l_per_rec.date_employee_data_verified := hr_api.g_date;

Line 508: --l_per_rec.date_employee_data_verified := hr_api.g_date;

504: l_per_rec.comment_id := hr_api.g_number;
505:
506: Hr_Utility.set_location(l_proc_name, 6);
507:
508: --l_per_rec.date_employee_data_verified := hr_api.g_date;
509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;

Line 509: --l_per_rec.date_of_birth := hr_api.g_date;

505:
506: Hr_Utility.set_location(l_proc_name, 6);
507:
508: --l_per_rec.date_employee_data_verified := hr_api.g_date;
509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;

Line 510: --l_per_rec.original_date_of_hire := hr_api.g_date;

506: Hr_Utility.set_location(l_proc_name, 6);
507:
508: --l_per_rec.date_employee_data_verified := hr_api.g_date;
509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;

Line 511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;

507:
508: --l_per_rec.date_employee_data_verified := hr_api.g_date;
509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;

Line 512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;

508: --l_per_rec.date_employee_data_verified := hr_api.g_date;
509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;

Line 513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;

509: --l_per_rec.date_of_birth := hr_api.g_date;
510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;

Line 514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;

510: --l_per_rec.original_date_of_hire := hr_api.g_date;
511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;

Line 515: --l_per_rec.resume_last_updated := hr_api.g_date;

511: --l_per_rec.dpdnt_adoption_date := hr_api.g_date;
512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;

Line 516: --l_per_rec.last_medical_test_date := hr_api.g_date;

512: --l_per_rec.coord_ben_med_cvg_strt_dt := hr_api.g_date;
513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;

Line 517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;

513: --l_per_rec.coord_ben_med_cvg_end_dt := hr_api.g_date;
514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:

Line 518: --l_per_rec.background_date_check := hr_api.g_date;

514: --l_per_rec.receipt_of_death_cert_date := hr_api.g_date;
515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;

Line 519: --l_per_rec.date_of_death := hr_api.g_date;

515: --l_per_rec.resume_last_updated := hr_api.g_date;
516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;

Line 520: --l_per_rec.projected_start_date := hr_api.g_date;

516: --l_per_rec.last_medical_test_date := hr_api.g_date;
517: --l_per_rec.hold_applicant_date_until := hr_api.g_date;
518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;

Line 522: l_per_rec.last_name := hr_api.g_varchar2;

518: --l_per_rec.background_date_check := hr_api.g_date;
519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;

Line 523: l_per_rec.applicant_number := hr_api.g_varchar2;

519: --l_per_rec.date_of_death := hr_api.g_date;
520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;

Line 524: l_per_rec.email_address := hr_api.g_varchar2;

520: --l_per_rec.projected_start_date := hr_api.g_date;
521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;

Line 525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;

521:
522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;

Line 526: l_per_rec.first_name := hr_api.g_varchar2;

522: l_per_rec.last_name := hr_api.g_varchar2;
523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;

Line 527: l_per_rec.known_as := hr_api.g_varchar2;

523: l_per_rec.applicant_number := hr_api.g_varchar2;
524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;

Line 528: l_per_rec.marital_status := hr_api.g_varchar2;

524: l_per_rec.email_address := hr_api.g_varchar2;
525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;

Line 529: l_per_rec.middle_names := hr_api.g_varchar2;

525: l_per_rec.expense_check_send_to_address := hr_api.g_varchar2;
526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;

Line 530: l_per_rec.nationality := hr_api.g_varchar2;

526: l_per_rec.first_name := hr_api.g_varchar2;
527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;

Line 531: l_per_rec.national_identifier := hr_api.g_varchar2;

527: l_per_rec.known_as := hr_api.g_varchar2;
528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;

Line 532: l_per_rec.previous_last_name := hr_api.g_varchar2;

528: l_per_rec.marital_status := hr_api.g_varchar2;
529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;
536: l_per_rec.work_telephone := hr_api.g_varchar2;

Line 533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;

529: l_per_rec.middle_names := hr_api.g_varchar2;
530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;
536: l_per_rec.work_telephone := hr_api.g_varchar2;
537:

Line 534: l_per_rec.sex := hr_api.g_varchar2;

530: l_per_rec.nationality := hr_api.g_varchar2;
531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;
536: l_per_rec.work_telephone := hr_api.g_varchar2;
537:
538: Hr_Utility.set_location(l_proc_name, 7);

Line 535: l_per_rec.title := hr_api.g_varchar2;

531: l_per_rec.national_identifier := hr_api.g_varchar2;
532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;
536: l_per_rec.work_telephone := hr_api.g_varchar2;
537:
538: Hr_Utility.set_location(l_proc_name, 7);
539:

Line 536: l_per_rec.work_telephone := hr_api.g_varchar2;

532: l_per_rec.previous_last_name := hr_api.g_varchar2;
533: l_per_rec.registered_disabled_flag := hr_api.g_varchar2;
534: l_per_rec.sex := hr_api.g_varchar2;
535: l_per_rec.title := hr_api.g_varchar2;
536: l_per_rec.work_telephone := hr_api.g_varchar2;
537:
538: Hr_Utility.set_location(l_proc_name, 7);
539:
540: l_per_rec.attribute_category := hr_api.g_varchar2;

Line 540: l_per_rec.attribute_category := hr_api.g_varchar2;

536: l_per_rec.work_telephone := hr_api.g_varchar2;
537:
538: Hr_Utility.set_location(l_proc_name, 7);
539:
540: l_per_rec.attribute_category := hr_api.g_varchar2;
541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;

Line 541: l_per_rec.attribute1 := hr_api.g_varchar2;

537:
538: Hr_Utility.set_location(l_proc_name, 7);
539:
540: l_per_rec.attribute_category := hr_api.g_varchar2;
541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;

Line 542: l_per_rec.attribute2 := hr_api.g_varchar2;

538: Hr_Utility.set_location(l_proc_name, 7);
539:
540: l_per_rec.attribute_category := hr_api.g_varchar2;
541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;

Line 543: l_per_rec.attribute3 := hr_api.g_varchar2;

539:
540: l_per_rec.attribute_category := hr_api.g_varchar2;
541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;

Line 544: l_per_rec.attribute4 := hr_api.g_varchar2;

540: l_per_rec.attribute_category := hr_api.g_varchar2;
541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;

Line 545: l_per_rec.attribute5 := hr_api.g_varchar2;

541: l_per_rec.attribute1 := hr_api.g_varchar2;
542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;

Line 546: l_per_rec.attribute6 := hr_api.g_varchar2;

542: l_per_rec.attribute2 := hr_api.g_varchar2;
543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;

Line 547: l_per_rec.attribute7 := hr_api.g_varchar2;

543: l_per_rec.attribute3 := hr_api.g_varchar2;
544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;

Line 548: l_per_rec.attribute8 := hr_api.g_varchar2;

544: l_per_rec.attribute4 := hr_api.g_varchar2;
545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;

Line 549: l_per_rec.attribute9 := hr_api.g_varchar2;

545: l_per_rec.attribute5 := hr_api.g_varchar2;
546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;

Line 550: l_per_rec.attribute10 := hr_api.g_varchar2;

546: l_per_rec.attribute6 := hr_api.g_varchar2;
547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;

Line 551: l_per_rec.attribute11 := hr_api.g_varchar2;

547: l_per_rec.attribute7 := hr_api.g_varchar2;
548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;

Line 552: l_per_rec.attribute12 := hr_api.g_varchar2;

548: l_per_rec.attribute8 := hr_api.g_varchar2;
549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;

Line 553: l_per_rec.attribute13 := hr_api.g_varchar2;

549: l_per_rec.attribute9 := hr_api.g_varchar2;
550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;

Line 554: l_per_rec.attribute14 := hr_api.g_varchar2;

550: l_per_rec.attribute10 := hr_api.g_varchar2;
551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;

Line 555: l_per_rec.attribute15 := hr_api.g_varchar2;

551: l_per_rec.attribute11 := hr_api.g_varchar2;
552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;

Line 556: l_per_rec.attribute16 := hr_api.g_varchar2;

552: l_per_rec.attribute12 := hr_api.g_varchar2;
553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;

Line 557: l_per_rec.attribute17 := hr_api.g_varchar2;

553: l_per_rec.attribute13 := hr_api.g_varchar2;
554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;

Line 558: l_per_rec.attribute18 := hr_api.g_varchar2;

554: l_per_rec.attribute14 := hr_api.g_varchar2;
555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;

Line 559: l_per_rec.attribute19 := hr_api.g_varchar2;

555: l_per_rec.attribute15 := hr_api.g_varchar2;
556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;

Line 560: l_per_rec.attribute20 := hr_api.g_varchar2;

556: l_per_rec.attribute16 := hr_api.g_varchar2;
557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;

Line 561: l_per_rec.attribute21 := hr_api.g_varchar2;

557: l_per_rec.attribute17 := hr_api.g_varchar2;
558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;

Line 562: l_per_rec.attribute22 := hr_api.g_varchar2;

558: l_per_rec.attribute18 := hr_api.g_varchar2;
559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;

Line 563: l_per_rec.attribute23 := hr_api.g_varchar2;

559: l_per_rec.attribute19 := hr_api.g_varchar2;
560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;

Line 564: l_per_rec.attribute24 := hr_api.g_varchar2;

560: l_per_rec.attribute20 := hr_api.g_varchar2;
561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;

Line 565: l_per_rec.attribute25 := hr_api.g_varchar2;

561: l_per_rec.attribute21 := hr_api.g_varchar2;
562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;

Line 566: l_per_rec.attribute26 := hr_api.g_varchar2;

562: l_per_rec.attribute22 := hr_api.g_varchar2;
563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;
570: l_per_rec.attribute30 := hr_api.g_varchar2;

Line 567: l_per_rec.attribute27 := hr_api.g_varchar2;

563: l_per_rec.attribute23 := hr_api.g_varchar2;
564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;
570: l_per_rec.attribute30 := hr_api.g_varchar2;
571:

Line 568: l_per_rec.attribute28 := hr_api.g_varchar2;

564: l_per_rec.attribute24 := hr_api.g_varchar2;
565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;
570: l_per_rec.attribute30 := hr_api.g_varchar2;
571:
572: Hr_Utility.set_location(l_proc_name, 8);

Line 569: l_per_rec.attribute29 := hr_api.g_varchar2;

565: l_per_rec.attribute25 := hr_api.g_varchar2;
566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;
570: l_per_rec.attribute30 := hr_api.g_varchar2;
571:
572: Hr_Utility.set_location(l_proc_name, 8);
573:

Line 570: l_per_rec.attribute30 := hr_api.g_varchar2;

566: l_per_rec.attribute26 := hr_api.g_varchar2;
567: l_per_rec.attribute27 := hr_api.g_varchar2;
568: l_per_rec.attribute28 := hr_api.g_varchar2;
569: l_per_rec.attribute29 := hr_api.g_varchar2;
570: l_per_rec.attribute30 := hr_api.g_varchar2;
571:
572: Hr_Utility.set_location(l_proc_name, 8);
573:
574: l_per_rec.per_information_category := hr_api.g_varchar2;

Line 574: l_per_rec.per_information_category := hr_api.g_varchar2;

570: l_per_rec.attribute30 := hr_api.g_varchar2;
571:
572: Hr_Utility.set_location(l_proc_name, 8);
573:
574: l_per_rec.per_information_category := hr_api.g_varchar2;
575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;

Line 575: l_per_rec.per_information1 := hr_api.g_varchar2;

571:
572: Hr_Utility.set_location(l_proc_name, 8);
573:
574: l_per_rec.per_information_category := hr_api.g_varchar2;
575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;

Line 576: l_per_rec.per_information2 := hr_api.g_varchar2;

572: Hr_Utility.set_location(l_proc_name, 8);
573:
574: l_per_rec.per_information_category := hr_api.g_varchar2;
575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;

Line 577: l_per_rec.per_information3 := hr_api.g_varchar2;

573:
574: l_per_rec.per_information_category := hr_api.g_varchar2;
575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;

Line 578: l_per_rec.per_information4 := hr_api.g_varchar2;

574: l_per_rec.per_information_category := hr_api.g_varchar2;
575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;

Line 579: l_per_rec.per_information5 := hr_api.g_varchar2;

575: l_per_rec.per_information1 := hr_api.g_varchar2;
576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;

Line 580: l_per_rec.per_information6 := hr_api.g_varchar2;

576: l_per_rec.per_information2 := hr_api.g_varchar2;
577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;

Line 581: l_per_rec.per_information7 := hr_api.g_varchar2;

577: l_per_rec.per_information3 := hr_api.g_varchar2;
578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;

Line 582: l_per_rec.per_information8 := hr_api.g_varchar2;

578: l_per_rec.per_information4 := hr_api.g_varchar2;
579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;

Line 583: l_per_rec.per_information9 := hr_api.g_varchar2;

579: l_per_rec.per_information5 := hr_api.g_varchar2;
580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;

Line 584: l_per_rec.per_information10 := hr_api.g_varchar2;

580: l_per_rec.per_information6 := hr_api.g_varchar2;
581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;

Line 585: l_per_rec.per_information11 := hr_api.g_varchar2;

581: l_per_rec.per_information7 := hr_api.g_varchar2;
582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;

Line 586: l_per_rec.per_information12 := hr_api.g_varchar2;

582: l_per_rec.per_information8 := hr_api.g_varchar2;
583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;

Line 587: l_per_rec.per_information13 := hr_api.g_varchar2;

583: l_per_rec.per_information9 := hr_api.g_varchar2;
584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;

Line 588: l_per_rec.per_information14 := hr_api.g_varchar2;

584: l_per_rec.per_information10 := hr_api.g_varchar2;
585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;

Line 589: l_per_rec.per_information15 := hr_api.g_varchar2;

585: l_per_rec.per_information11 := hr_api.g_varchar2;
586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;

Line 590: l_per_rec.per_information16 := hr_api.g_varchar2;

586: l_per_rec.per_information12 := hr_api.g_varchar2;
587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;

Line 591: l_per_rec.per_information17 := hr_api.g_varchar2;

587: l_per_rec.per_information13 := hr_api.g_varchar2;
588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;

Line 592: l_per_rec.per_information18 := hr_api.g_varchar2;

588: l_per_rec.per_information14 := hr_api.g_varchar2;
589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;

Line 593: l_per_rec.per_information19 := hr_api.g_varchar2;

589: l_per_rec.per_information15 := hr_api.g_varchar2;
590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;

Line 594: l_per_rec.per_information20 := hr_api.g_varchar2;

590: l_per_rec.per_information16 := hr_api.g_varchar2;
591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;

Line 595: l_per_rec.per_information21 := hr_api.g_varchar2;

591: l_per_rec.per_information17 := hr_api.g_varchar2;
592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;

Line 596: l_per_rec.per_information22 := hr_api.g_varchar2;

592: l_per_rec.per_information18 := hr_api.g_varchar2;
593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;

Line 597: l_per_rec.per_information23 := hr_api.g_varchar2;

593: l_per_rec.per_information19 := hr_api.g_varchar2;
594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;

Line 598: l_per_rec.per_information24 := hr_api.g_varchar2;

594: l_per_rec.per_information20 := hr_api.g_varchar2;
595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;

Line 599: l_per_rec.per_information25 := hr_api.g_varchar2;

595: l_per_rec.per_information21 := hr_api.g_varchar2;
596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;

Line 600: l_per_rec.per_information26 := hr_api.g_varchar2;

596: l_per_rec.per_information22 := hr_api.g_varchar2;
597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;
604: l_per_rec.per_information30 := hr_api.g_varchar2;

Line 601: l_per_rec.per_information27 := hr_api.g_varchar2;

597: l_per_rec.per_information23 := hr_api.g_varchar2;
598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;
604: l_per_rec.per_information30 := hr_api.g_varchar2;
605:

Line 602: l_per_rec.per_information28 := hr_api.g_varchar2;

598: l_per_rec.per_information24 := hr_api.g_varchar2;
599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;
604: l_per_rec.per_information30 := hr_api.g_varchar2;
605:
606: Hr_Utility.set_location(l_proc_name, 9);

Line 603: l_per_rec.per_information29 := hr_api.g_varchar2;

599: l_per_rec.per_information25 := hr_api.g_varchar2;
600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;
604: l_per_rec.per_information30 := hr_api.g_varchar2;
605:
606: Hr_Utility.set_location(l_proc_name, 9);
607:

Line 604: l_per_rec.per_information30 := hr_api.g_varchar2;

600: l_per_rec.per_information26 := hr_api.g_varchar2;
601: l_per_rec.per_information27 := hr_api.g_varchar2;
602: l_per_rec.per_information28 := hr_api.g_varchar2;
603: l_per_rec.per_information29 := hr_api.g_varchar2;
604: l_per_rec.per_information30 := hr_api.g_varchar2;
605:
606: Hr_Utility.set_location(l_proc_name, 9);
607:
608: l_per_rec.background_check_status := hr_api.g_varchar2;

Line 608: l_per_rec.background_check_status := hr_api.g_varchar2;

604: l_per_rec.per_information30 := hr_api.g_varchar2;
605:
606: Hr_Utility.set_location(l_proc_name, 9);
607:
608: l_per_rec.background_check_status := hr_api.g_varchar2;
609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;

Line 609: l_per_rec.blood_type := hr_api.g_varchar2;

605:
606: Hr_Utility.set_location(l_proc_name, 9);
607:
608: l_per_rec.background_check_status := hr_api.g_varchar2;
609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;

Line 610: l_per_rec.correspondence_language := hr_api.g_varchar2;

606: Hr_Utility.set_location(l_proc_name, 9);
607:
608: l_per_rec.background_check_status := hr_api.g_varchar2;
609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;

Line 611: l_per_rec.fast_path_employee := hr_api.g_varchar2;

607:
608: l_per_rec.background_check_status := hr_api.g_varchar2;
609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;

Line 612: l_per_rec.honors := hr_api.g_varchar2;

608: l_per_rec.background_check_status := hr_api.g_varchar2;
609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;

Line 613: l_per_rec.internal_location := hr_api.g_varchar2;

609: l_per_rec.blood_type := hr_api.g_varchar2;
610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;

Line 614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;

610: l_per_rec.correspondence_language := hr_api.g_varchar2;
611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;

Line 615: l_per_rec.mailstop := hr_api.g_varchar2;

611: l_per_rec.fast_path_employee := hr_api.g_varchar2;
612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;

Line 616: l_per_rec.office_number := hr_api.g_varchar2;

612: l_per_rec.honors := hr_api.g_varchar2;
613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;

Line 617: l_per_rec.on_military_service := hr_api.g_varchar2;

613: l_per_rec.internal_location := hr_api.g_varchar2;
614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;

Line 618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;

614: l_per_rec.last_medical_test_by := hr_api.g_varchar2;
615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;

Line 619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;

615: l_per_rec.mailstop := hr_api.g_varchar2;
616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;

Line 620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;

616: l_per_rec.office_number := hr_api.g_varchar2;
617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;

Line 621: l_per_rec.resume_exists := hr_api.g_varchar2;

617: l_per_rec.on_military_service := hr_api.g_varchar2;
618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;

Line 622: l_per_rec.second_passport_exists := hr_api.g_varchar2;

618: l_per_rec.pre_name_adjunct := hr_api.g_varchar2;
619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;

Line 623: l_per_rec.student_status := hr_api.g_varchar2;

619: l_per_rec.rehire_authorizor := hr_api.g_varchar2;
620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;

Line 624: l_per_rec.work_schedule := hr_api.g_varchar2;

620: l_per_rec.rehire_recommendation := hr_api.g_varchar2;
621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;

Line 625: l_per_rec.rehire_reason := hr_api.g_varchar2;

621: l_per_rec.resume_exists := hr_api.g_varchar2;
622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;

Line 626: l_per_rec.suffix := hr_api.g_varchar2;

622: l_per_rec.second_passport_exists := hr_api.g_varchar2;
623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;

Line 627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;

623: l_per_rec.student_status := hr_api.g_varchar2;
624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;

Line 628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;

624: l_per_rec.work_schedule := hr_api.g_varchar2;
625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;

Line 629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;

625: l_per_rec.rehire_reason := hr_api.g_varchar2;
626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;

Line 630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;

626: l_per_rec.suffix := hr_api.g_varchar2;
627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;

Line 631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;

627: l_per_rec.coord_ben_med_pln_no := hr_api.g_varchar2;
628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;

Line 632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;

628: l_per_rec.coord_ben_no_cvg_flag := hr_api.g_varchar2;
629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;

Line 633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;

629: l_per_rec.coord_ben_med_ext_er := hr_api.g_varchar2;
630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;

Line 634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;

630: l_per_rec.coord_ben_med_pl_name := hr_api.g_varchar2;
631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;

Line 635: l_per_rec.town_of_birth := hr_api.g_varchar2;

631: l_per_rec.coord_ben_med_insr_crr_name := hr_api.g_varchar2;
632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;
639: l_per_rec.npw_number := hr_api.g_varchar2;

Line 636: l_per_rec.region_of_birth := hr_api.g_varchar2;

632: l_per_rec.coord_ben_med_insr_crr_ident := hr_api.g_varchar2;
633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;
639: l_per_rec.npw_number := hr_api.g_varchar2;
640:

Line 637: l_per_rec.country_of_birth := hr_api.g_varchar2;

633: l_per_rec.uses_tobacco_flag := hr_api.g_varchar2;
634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;
639: l_per_rec.npw_number := hr_api.g_varchar2;
640:
641: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 638: l_per_rec.global_person_id := hr_api.g_varchar2;

634: l_per_rec.dpdnt_vlntry_svce_flag := hr_api.g_varchar2;
635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;
639: l_per_rec.npw_number := hr_api.g_varchar2;
640:
641: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
642: return l_per_rec;

Line 639: l_per_rec.npw_number := hr_api.g_varchar2;

635: l_per_rec.town_of_birth := hr_api.g_varchar2;
636: l_per_rec.region_of_birth := hr_api.g_varchar2;
637: l_per_rec.country_of_birth := hr_api.g_varchar2;
638: l_per_rec.global_person_id := hr_api.g_varchar2;
639: l_per_rec.npw_number := hr_api.g_varchar2;
640:
641: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
642: return l_per_rec;
643: exception

Line 973: l_asg_rec.grade_id := hr_api.g_number;

969: g_number constant number := -987123654;
970: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
971: ======================================================================
972: */
973: l_asg_rec.grade_id := hr_api.g_number;
974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;

Line 974: l_asg_rec.position_id := hr_api.g_number;

970: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
971: ======================================================================
972: */
973: l_asg_rec.grade_id := hr_api.g_number;
974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;

Line 975: l_asg_rec.job_id := hr_api.g_number;

971: ======================================================================
972: */
973: l_asg_rec.grade_id := hr_api.g_number;
974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;

Line 976: l_asg_rec.payroll_id := hr_api.g_number;

972: */
973: l_asg_rec.grade_id := hr_api.g_number;
974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;

Line 977: l_asg_rec.location_id := hr_api.g_number;

973: l_asg_rec.grade_id := hr_api.g_number;
974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;

Line 978: l_asg_rec.organization_id := hr_api.g_number;

974: l_asg_rec.position_id := hr_api.g_number;
975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;

Line 979: l_asg_rec.pay_basis_id := hr_api.g_number;

975: l_asg_rec.job_id := hr_api.g_number;
976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;

Line 980: l_asg_rec.employment_category := hr_api.g_varchar2;

976: l_asg_rec.payroll_id := hr_api.g_number;
977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;

Line 981: l_asg_rec.contract_id := hr_api.g_number;

977: l_asg_rec.location_id := hr_api.g_number;
978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;

Line 982: l_asg_rec.establishment_id := hr_api.g_number;

978: l_asg_rec.organization_id := hr_api.g_number;
979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;

Line 983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;

979: l_asg_rec.pay_basis_id := hr_api.g_number;
980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;
987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;

Line 984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;

980: l_asg_rec.employment_category := hr_api.g_varchar2;
981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;
987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
988:

Line 985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;

981: l_asg_rec.contract_id := hr_api.g_number;
982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;
987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
988:
989: Hr_Utility.set_location(l_proc_name, 10);

Line 986: l_asg_rec.people_group_id := hr_api.g_number;

982: l_asg_rec.establishment_id := hr_api.g_number;
983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;
987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
988:
989: Hr_Utility.set_location(l_proc_name, 10);
990:

Line 987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;

983: l_asg_rec.grade_ladder_pgm_id := hr_api.g_number;
984: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
985: l_asg_rec.special_ceiling_step_id := hr_api.g_number;
986: l_asg_rec.people_group_id := hr_api.g_number;
987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
988:
989: Hr_Utility.set_location(l_proc_name, 10);
990:
991: l_asg_rec.supervisor_id := hr_api.g_number;

Line 991: l_asg_rec.supervisor_id := hr_api.g_number;

987: l_asg_rec.soft_coding_keyflex_id := hr_api.g_number;
988:
989: Hr_Utility.set_location(l_proc_name, 10);
990:
991: l_asg_rec.supervisor_id := hr_api.g_number;
992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;

Line 992: l_asg_rec.assignment_number := hr_api.g_varchar2;

988:
989: Hr_Utility.set_location(l_proc_name, 10);
990:
991: l_asg_rec.supervisor_id := hr_api.g_number;
992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;

Line 993: l_asg_rec.change_reason := hr_api.g_varchar2;

989: Hr_Utility.set_location(l_proc_name, 10);
990:
991: l_asg_rec.supervisor_id := hr_api.g_number;
992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;

Line 994: l_asg_rec.assignment_status_type_id := hr_api.g_number;

990:
991: l_asg_rec.supervisor_id := hr_api.g_number;
992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;

Line 995: l_asg_rec.date_probation_end := hr_api.g_date;

991: l_asg_rec.supervisor_id := hr_api.g_number;
992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;

Line 996: l_asg_rec.default_code_comb_id := hr_api.g_number;

992: l_asg_rec.assignment_number := hr_api.g_varchar2;
993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;

Line 997: l_asg_rec.frequency := hr_api.g_varchar2;

993: l_asg_rec.change_reason := hr_api.g_varchar2;
994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;

Line 998: l_asg_rec.internal_address_line := hr_api.g_varchar2;

994: l_asg_rec.assignment_status_type_id := hr_api.g_number;
995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;

Line 999: l_asg_rec.manager_flag := hr_api.g_varchar2;

995: l_asg_rec.date_probation_end := hr_api.g_date;
996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;

Line 1000: l_asg_rec.normal_hours := hr_api.g_number;

996: l_asg_rec.default_code_comb_id := hr_api.g_number;
997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;

Line 1001: l_asg_rec.perf_review_period := hr_api.g_number;

997: l_asg_rec.frequency := hr_api.g_varchar2;
998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;

Line 1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;

998: l_asg_rec.internal_address_line := hr_api.g_varchar2;
999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;

Line 1003: l_asg_rec.probation_period := hr_api.g_number;

999: l_asg_rec.manager_flag := hr_api.g_varchar2;
1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;

Line 1004: l_asg_rec.probation_unit := hr_api.g_varchar2;

1000: l_asg_rec.normal_hours := hr_api.g_number;
1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;

Line 1005: l_asg_rec.sal_review_period := hr_api.g_number;

1001: l_asg_rec.perf_review_period := hr_api.g_number;
1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;

Line 1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;

1002: l_asg_rec.perf_review_period_frequency := hr_api.g_varchar2;
1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;

Line 1007: l_asg_rec.set_of_books_id := hr_api.g_number;

1003: l_asg_rec.probation_period := hr_api.g_number;
1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;

Line 1008: l_asg_rec.source_type := hr_api.g_varchar2;

1004: l_asg_rec.probation_unit := hr_api.g_varchar2;
1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;

Line 1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;

1005: l_asg_rec.sal_review_period := hr_api.g_number;
1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;

Line 1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;

1006: l_asg_rec.sal_review_period_frequency := hr_api.g_varchar2;
1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1014:

Line 1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;

1007: l_asg_rec.set_of_books_id := hr_api.g_number;
1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1014:
1015: Hr_Utility.set_location(l_proc_name, 15);

Line 1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;

1008: l_asg_rec.source_type := hr_api.g_varchar2;
1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1014:
1015: Hr_Utility.set_location(l_proc_name, 15);
1016:

Line 1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;

1009: -- l_asg_rec.time_normal_finish := hr_api.g_varchar2;
1010: -- l_asg_rec.time_normal_start := hr_api.g_varchar2;
1011: l_asg_rec.bargaining_unit_code := hr_api.g_varchar2;
1012: l_asg_rec.labour_union_member_flag := hr_api.g_varchar2;
1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1014:
1015: Hr_Utility.set_location(l_proc_name, 15);
1016:
1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;

Line 1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;

1013: l_asg_rec.hourly_salaried_code := hr_api.g_varchar2;
1014:
1015: Hr_Utility.set_location(l_proc_name, 15);
1016:
1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;

Line 1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;

1014:
1015: Hr_Utility.set_location(l_proc_name, 15);
1016:
1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;

Line 1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;

1015: Hr_Utility.set_location(l_proc_name, 15);
1016:
1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;

Line 1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;

1016:
1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;

Line 1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;

1017: l_asg_rec.ass_attribute_category := hr_api.g_varchar2;
1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;

Line 1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;

1018: l_asg_rec.ass_attribute1 := hr_api.g_varchar2;
1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;

Line 1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;

1019: l_asg_rec.ass_attribute2 := hr_api.g_varchar2;
1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;

Line 1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;

1020: l_asg_rec.ass_attribute3 := hr_api.g_varchar2;
1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;

Line 1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;

1021: l_asg_rec.ass_attribute4 := hr_api.g_varchar2;
1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;

Line 1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;

1022: l_asg_rec.ass_attribute5 := hr_api.g_varchar2;
1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;

Line 1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;

1023: l_asg_rec.ass_attribute6 := hr_api.g_varchar2;
1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;

Line 1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;

1024: l_asg_rec.ass_attribute7 := hr_api.g_varchar2;
1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;

Line 1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;

1025: l_asg_rec.ass_attribute8 := hr_api.g_varchar2;
1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;

Line 1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;

1026: l_asg_rec.ass_attribute9 := hr_api.g_varchar2;
1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;

Line 1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;

1027: l_asg_rec.ass_attribute10 := hr_api.g_varchar2;
1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;

Line 1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;

1028: l_asg_rec.ass_attribute11 := hr_api.g_varchar2;
1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;

Line 1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;

1029: l_asg_rec.ass_attribute12 := hr_api.g_varchar2;
1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;

Line 1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;

1030: l_asg_rec.ass_attribute13 := hr_api.g_varchar2;
1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;

Line 1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;

1031: l_asg_rec.ass_attribute14 := hr_api.g_varchar2;
1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;

Line 1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;

1032: l_asg_rec.ass_attribute15 := hr_api.g_varchar2;
1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;

Line 1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;

1033: l_asg_rec.ass_attribute16 := hr_api.g_varchar2;
1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;

Line 1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;

1034: l_asg_rec.ass_attribute17 := hr_api.g_varchar2;
1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;

Line 1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;

1035: l_asg_rec.ass_attribute18 := hr_api.g_varchar2;
1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;

Line 1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;

1036: l_asg_rec.ass_attribute19 := hr_api.g_varchar2;
1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;

Line 1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;

1037: l_asg_rec.ass_attribute20 := hr_api.g_varchar2;
1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;

Line 1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;

1038: l_asg_rec.ass_attribute21 := hr_api.g_varchar2;
1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;

Line 1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;

1039: l_asg_rec.ass_attribute22 := hr_api.g_varchar2;
1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;

Line 1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;

1040: l_asg_rec.ass_attribute23 := hr_api.g_varchar2;
1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1048:

Line 1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;

1041: l_asg_rec.ass_attribute24 := hr_api.g_varchar2;
1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1048:
1049: Hr_Utility.set_location(l_proc_name, 20);

Line 1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;

1042: l_asg_rec.ass_attribute25 := hr_api.g_varchar2;
1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1048:
1049: Hr_Utility.set_location(l_proc_name, 20);
1050:

Line 1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;

1043: l_asg_rec.ass_attribute26 := hr_api.g_varchar2;
1044: l_asg_rec.ass_attribute27 := hr_api.g_varchar2;
1045: l_asg_rec.ass_attribute28 := hr_api.g_varchar2;
1046: l_asg_rec.ass_attribute29 := hr_api.g_varchar2;
1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1048:
1049: Hr_Utility.set_location(l_proc_name, 20);
1050:
1051: l_asg_rec.title := hr_api.g_varchar2;

Line 1051: l_asg_rec.title := hr_api.g_varchar2;

1047: l_asg_rec.ass_attribute30 := hr_api.g_varchar2;
1048:
1049: Hr_Utility.set_location(l_proc_name, 20);
1050:
1051: l_asg_rec.title := hr_api.g_varchar2;
1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;

Line 1052: l_asg_rec.contract_id := hr_api.g_number;

1048:
1049: Hr_Utility.set_location(l_proc_name, 20);
1050:
1051: l_asg_rec.title := hr_api.g_varchar2;
1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;

Line 1053: l_asg_rec.establishment_id := hr_api.g_number;

1049: Hr_Utility.set_location(l_proc_name, 20);
1050:
1051: l_asg_rec.title := hr_api.g_varchar2;
1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;

Line 1054: l_asg_rec.collective_agreement_id := hr_api.g_number;

1050:
1051: l_asg_rec.title := hr_api.g_varchar2;
1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;
1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;

Line 1055: l_asg_rec.notice_period := hr_api.g_number;

1051: l_asg_rec.title := hr_api.g_varchar2;
1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;
1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1059:

Line 1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;

1052: l_asg_rec.contract_id := hr_api.g_number;
1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;
1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1059:
1060: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 1057: l_asg_rec.employee_category := hr_api.g_varchar2;

1053: l_asg_rec.establishment_id := hr_api.g_number;
1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;
1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1059:
1060: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1061: return l_asg_rec;

Line 1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;

1054: l_asg_rec.collective_agreement_id := hr_api.g_number;
1055: l_asg_rec.notice_period := hr_api.g_number;
1056: l_asg_rec.notice_period_uom := hr_api.g_varchar2;
1057: l_asg_rec.employee_category := hr_api.g_varchar2;
1058: l_asg_rec.supervisor_assignment_id := hr_api.g_number;
1059:
1060: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1061: return l_asg_rec;
1062: exception

Line 1095: -- If yes (i.e. flag is set to 1 ) then initialize to null else to hr_api variable

1091:
1092: begin
1093: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1094: --$ check if secondary assignment is to be created
1095: -- If yes (i.e. flag is set to 1 ) then initialize to null else to hr_api variable
1096: -- type
1097: if g_sec_asg_flag <> 1 then
1098: l_asg_rec := Default_Assignment_Rec;
1099: elsif g_sec_asg_flag = 1 then

Line 1290: hr_api defaults:

1286: begin
1287: Hr_Utility.set_location(' Entering: '||l_proc_name, 5);
1288: /*
1289: ======================================================================
1290: hr_api defaults:
1291: g_varchar2 constant varchar2(9):= '$Sys_Def$';
1292: g_number constant number := -987123654;
1293: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1294: ======================================================================

Line 1296: l_grp_rec.group_name := hr_api.g_varchar2;

1292: g_number constant number := -987123654;
1293: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1294: ======================================================================
1295: */
1296: l_grp_rec.group_name := hr_api.g_varchar2;
1297:
1298: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1299:
1300: l_grp_rec.segment1 := hr_api.g_varchar2;

Line 1300: l_grp_rec.segment1 := hr_api.g_varchar2;

1296: l_grp_rec.group_name := hr_api.g_varchar2;
1297:
1298: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1299:
1300: l_grp_rec.segment1 := hr_api.g_varchar2;
1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;

Line 1301: l_grp_rec.segment2 := hr_api.g_varchar2;

1297:
1298: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1299:
1300: l_grp_rec.segment1 := hr_api.g_varchar2;
1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;

Line 1302: l_grp_rec.segment3 := hr_api.g_varchar2;

1298: Hr_Utility.set_location(' First : Default_PpgFlx_Rec'||l_grp_rec.group_name, 5);
1299:
1300: l_grp_rec.segment1 := hr_api.g_varchar2;
1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;

Line 1303: l_grp_rec.segment4 := hr_api.g_varchar2;

1299:
1300: l_grp_rec.segment1 := hr_api.g_varchar2;
1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;

Line 1304: l_grp_rec.segment5 := hr_api.g_varchar2;

1300: l_grp_rec.segment1 := hr_api.g_varchar2;
1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;

Line 1305: l_grp_rec.segment6 := hr_api.g_varchar2;

1301: l_grp_rec.segment2 := hr_api.g_varchar2;
1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);

Line 1306: l_grp_rec.segment7 := hr_api.g_varchar2;

1302: l_grp_rec.segment3 := hr_api.g_varchar2;
1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;

Line 1307: l_grp_rec.segment8 := hr_api.g_varchar2;

1303: l_grp_rec.segment4 := hr_api.g_varchar2;
1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;

Line 1308: l_grp_rec.segment9 := hr_api.g_varchar2;

1304: l_grp_rec.segment5 := hr_api.g_varchar2;
1305: l_grp_rec.segment6 := hr_api.g_varchar2;
1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;

Line 1310: l_grp_rec.segment10 := hr_api.g_varchar2;

1306: l_grp_rec.segment7 := hr_api.g_varchar2;
1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;

Line 1311: l_grp_rec.segment11 := hr_api.g_varchar2;

1307: l_grp_rec.segment8 := hr_api.g_varchar2;
1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;

Line 1312: l_grp_rec.segment12 := hr_api.g_varchar2;

1308: l_grp_rec.segment9 := hr_api.g_varchar2;
1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;

Line 1313: l_grp_rec.segment13 := hr_api.g_varchar2;

1309: Hr_Utility.set_location('Default_PpgFlx_Rec', 15);
1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;

Line 1314: l_grp_rec.segment14 := hr_api.g_varchar2;

1310: l_grp_rec.segment10 := hr_api.g_varchar2;
1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;

Line 1315: l_grp_rec.segment15 := hr_api.g_varchar2;

1311: l_grp_rec.segment11 := hr_api.g_varchar2;
1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;

Line 1316: l_grp_rec.segment16 := hr_api.g_varchar2;

1312: l_grp_rec.segment12 := hr_api.g_varchar2;
1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);

Line 1317: l_grp_rec.segment17 := hr_api.g_varchar2;

1313: l_grp_rec.segment13 := hr_api.g_varchar2;
1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;

Line 1318: l_grp_rec.segment18 := hr_api.g_varchar2;

1314: l_grp_rec.segment14 := hr_api.g_varchar2;
1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;

Line 1319: l_grp_rec.segment19 := hr_api.g_varchar2;

1315: l_grp_rec.segment15 := hr_api.g_varchar2;
1316: l_grp_rec.segment16 := hr_api.g_varchar2;
1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;

Line 1321: l_grp_rec.segment20 := hr_api.g_varchar2;

1317: l_grp_rec.segment17 := hr_api.g_varchar2;
1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;

Line 1322: l_grp_rec.segment21 := hr_api.g_varchar2;

1318: l_grp_rec.segment18 := hr_api.g_varchar2;
1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;

Line 1323: l_grp_rec.segment22 := hr_api.g_varchar2;

1319: l_grp_rec.segment19 := hr_api.g_varchar2;
1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;

Line 1324: l_grp_rec.segment23 := hr_api.g_varchar2;

1320: Hr_Utility.set_location('Default_PpgFlx_Rec', 20);
1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;

Line 1325: l_grp_rec.segment24 := hr_api.g_varchar2;

1321: l_grp_rec.segment20 := hr_api.g_varchar2;
1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;

Line 1326: l_grp_rec.segment25 := hr_api.g_varchar2;

1322: l_grp_rec.segment21 := hr_api.g_varchar2;
1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;

Line 1327: l_grp_rec.segment26 := hr_api.g_varchar2;

1323: l_grp_rec.segment22 := hr_api.g_varchar2;
1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;
1331: l_grp_rec.segment30 := hr_api.g_varchar2;

Line 1328: l_grp_rec.segment27 := hr_api.g_varchar2;

1324: l_grp_rec.segment23 := hr_api.g_varchar2;
1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;
1331: l_grp_rec.segment30 := hr_api.g_varchar2;
1332:

Line 1329: l_grp_rec.segment28 := hr_api.g_varchar2;

1325: l_grp_rec.segment24 := hr_api.g_varchar2;
1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;
1331: l_grp_rec.segment30 := hr_api.g_varchar2;
1332:
1333: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 1330: l_grp_rec.segment29 := hr_api.g_varchar2;

1326: l_grp_rec.segment25 := hr_api.g_varchar2;
1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;
1331: l_grp_rec.segment30 := hr_api.g_varchar2;
1332:
1333: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1334: return l_grp_rec;

Line 1331: l_grp_rec.segment30 := hr_api.g_varchar2;

1327: l_grp_rec.segment26 := hr_api.g_varchar2;
1328: l_grp_rec.segment27 := hr_api.g_varchar2;
1329: l_grp_rec.segment28 := hr_api.g_varchar2;
1330: l_grp_rec.segment29 := hr_api.g_varchar2;
1331: l_grp_rec.segment30 := hr_api.g_varchar2;
1332:
1333: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1334: return l_grp_rec;
1335:

Line 1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;

1463: g_number constant number := -987123654;
1464: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1465: ======================================================================
1466: */
1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;

Line 1468: l_scl_rec.segment1 := hr_api.g_varchar2;

1464: g_date constant date := to_date('01-01-4712','DD-MM-SYYYY');
1465: ======================================================================
1466: */
1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;

Line 1469: l_scl_rec.segment2 := hr_api.g_varchar2;

1465: ======================================================================
1466: */
1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;

Line 1470: l_scl_rec.segment3 := hr_api.g_varchar2;

1466: */
1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;

Line 1471: l_scl_rec.segment4 := hr_api.g_varchar2;

1467: l_scl_rec.concatenated_segments := hr_api.g_varchar2;
1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;

Line 1472: l_scl_rec.segment5 := hr_api.g_varchar2;

1468: l_scl_rec.segment1 := hr_api.g_varchar2;
1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;

Line 1473: l_scl_rec.segment6 := hr_api.g_varchar2;

1469: l_scl_rec.segment2 := hr_api.g_varchar2;
1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);

Line 1474: l_scl_rec.segment7 := hr_api.g_varchar2;

1470: l_scl_rec.segment3 := hr_api.g_varchar2;
1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;

Line 1475: l_scl_rec.segment8 := hr_api.g_varchar2;

1471: l_scl_rec.segment4 := hr_api.g_varchar2;
1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;

Line 1476: l_scl_rec.segment9 := hr_api.g_varchar2;

1472: l_scl_rec.segment5 := hr_api.g_varchar2;
1473: l_scl_rec.segment6 := hr_api.g_varchar2;
1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;

Line 1478: l_scl_rec.segment10 := hr_api.g_varchar2;

1474: l_scl_rec.segment7 := hr_api.g_varchar2;
1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;

Line 1479: l_scl_rec.segment11 := hr_api.g_varchar2;

1475: l_scl_rec.segment8 := hr_api.g_varchar2;
1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;

Line 1480: l_scl_rec.segment12 := hr_api.g_varchar2;

1476: l_scl_rec.segment9 := hr_api.g_varchar2;
1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;

Line 1481: l_scl_rec.segment13 := hr_api.g_varchar2;

1477: Hr_Utility.set_location(l_proc_name, 15);
1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;

Line 1482: l_scl_rec.segment14 := hr_api.g_varchar2;

1478: l_scl_rec.segment10 := hr_api.g_varchar2;
1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;

Line 1483: l_scl_rec.segment15 := hr_api.g_varchar2;

1479: l_scl_rec.segment11 := hr_api.g_varchar2;
1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;

Line 1484: l_scl_rec.segment16 := hr_api.g_varchar2;

1480: l_scl_rec.segment12 := hr_api.g_varchar2;
1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);

Line 1485: l_scl_rec.segment17 := hr_api.g_varchar2;

1481: l_scl_rec.segment13 := hr_api.g_varchar2;
1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;

Line 1486: l_scl_rec.segment18 := hr_api.g_varchar2;

1482: l_scl_rec.segment14 := hr_api.g_varchar2;
1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;

Line 1487: l_scl_rec.segment19 := hr_api.g_varchar2;

1483: l_scl_rec.segment15 := hr_api.g_varchar2;
1484: l_scl_rec.segment16 := hr_api.g_varchar2;
1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;

Line 1489: l_scl_rec.segment20 := hr_api.g_varchar2;

1485: l_scl_rec.segment17 := hr_api.g_varchar2;
1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;

Line 1490: l_scl_rec.segment21 := hr_api.g_varchar2;

1486: l_scl_rec.segment18 := hr_api.g_varchar2;
1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;

Line 1491: l_scl_rec.segment22 := hr_api.g_varchar2;

1487: l_scl_rec.segment19 := hr_api.g_varchar2;
1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;

Line 1492: l_scl_rec.segment23 := hr_api.g_varchar2;

1488: Hr_Utility.set_location(l_proc_name, 20);
1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;

Line 1493: l_scl_rec.segment24 := hr_api.g_varchar2;

1489: l_scl_rec.segment20 := hr_api.g_varchar2;
1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;

Line 1494: l_scl_rec.segment25 := hr_api.g_varchar2;

1490: l_scl_rec.segment21 := hr_api.g_varchar2;
1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;

Line 1495: l_scl_rec.segment26 := hr_api.g_varchar2;

1491: l_scl_rec.segment22 := hr_api.g_varchar2;
1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;
1499: l_scl_rec.segment30 := hr_api.g_varchar2;

Line 1496: l_scl_rec.segment27 := hr_api.g_varchar2;

1492: l_scl_rec.segment23 := hr_api.g_varchar2;
1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;
1499: l_scl_rec.segment30 := hr_api.g_varchar2;
1500:

Line 1497: l_scl_rec.segment28 := hr_api.g_varchar2;

1493: l_scl_rec.segment24 := hr_api.g_varchar2;
1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;
1499: l_scl_rec.segment30 := hr_api.g_varchar2;
1500:
1501: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 1498: l_scl_rec.segment29 := hr_api.g_varchar2;

1494: l_scl_rec.segment25 := hr_api.g_varchar2;
1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;
1499: l_scl_rec.segment30 := hr_api.g_varchar2;
1500:
1501: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1502: return l_scl_rec;

Line 1499: l_scl_rec.segment30 := hr_api.g_varchar2;

1495: l_scl_rec.segment26 := hr_api.g_varchar2;
1496: l_scl_rec.segment27 := hr_api.g_varchar2;
1497: l_scl_rec.segment28 := hr_api.g_varchar2;
1498: l_scl_rec.segment29 := hr_api.g_varchar2;
1499: l_scl_rec.segment30 := hr_api.g_varchar2;
1500:
1501: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
1502: return l_scl_rec;
1503: exception

Line 2577: --,p_collective_agreement_id in number default hr_api.g_number

2573: ,p_job_post_source_name => l_asg_rec.job_post_source_name
2574: ,p_posting_content_id => l_asg_rec.posting_content_id
2575: ,p_applicant_rank => l_asg_rec.applicant_rank
2576: ,p_cagr_grade_def_id => g_asg_rec.cagr_grade_def_id
2577: --,p_collective_agreement_id in number default hr_api.g_number
2578: ,p_notice_period => l_asg_rec.notice_period
2579: ,p_notice_period_uom => l_asg_rec.notice_period_uom
2580: ,p_employee_category => l_asg_rec.employee_category
2581: ,p_work_at_home => l_asg_rec.work_at_home

Line 7759: from hr_api_modules

7755: -- DP interface tables
7756: cursor csr_get_dp_mode (c_batch_id in number
7757: ,c_link_value in number) is
7758: select 'CREATE'
7759: from hr_api_modules
7760: where module_name = 'CREATE_EMPLOYEE'
7761: and module_package = 'HR_EMPLOYEE_API'
7762: and api_module_id in (select api_module_id
7763: from hr_pump_batch_lines

Line 7772: ,hr_api_modules ham

7768: cursor csr_get_api_names (c_batch_id in number
7769: ,c_link_value in number) is
7770: select module_name
7771: from hr_pump_batch_lines hpbl
7772: ,hr_api_modules ham
7773: where batch_id = c_batch_id
7774: and link_value = c_link_value
7775: and line_status in ('U', 'E')
7776: and hpbl.api_module_id = ham.api_module_id;

Line 7872: l_api_name hr_api_modules.module_name%type;

7868: l_proc_name constant varchar2(150):= g_pkg ||'HR_DataPumpErr';
7869:
7870: l_dp_mode varchar2(40);
7871: l_if_end_dated varchar2(20);
7872: l_api_name hr_api_modules.module_name%type;
7873: l_user_person_type per_person_types.user_person_type%type;
7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.name%type;
7876: l_location_code hr_locations_all.location_code%type;