414: p_drctry_name,
415: p_apnd_rqst_id_flag,
416: p_kickoff_wrt_prc_flag,
417: p_use_eff_dt_for_chgs_flag,
418: ben_ext_person.g_upd_cm_sent_dt_flag,
419: p_ext_post_prcs_rl,
420: p_ext_global_flag,
421: p_output_type ,
422: p_xdo_template_id,
4786:
4787: if g_debug then
4788: hr_utility.set_location ('Entering '||l_proc,5);
4789: end if;
4790: ben_ext_person.g_location_id := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4787: if g_debug then
4788: hr_utility.set_location ('Entering '||l_proc,5);
4789: end if;
4790: ben_ext_person.g_location_id := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4788: hr_utility.set_location ('Entering '||l_proc,5);
4789: end if;
4790: ben_ext_person.g_location_id := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4789: end if;
4790: ben_ext_person.g_location_id := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4790: ben_ext_person.g_location_id := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4791: ben_ext_person.g_location_code := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4792: ben_ext_person.g_location_addr1 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4793: ben_ext_person.g_location_addr2 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4794: ben_ext_person.g_location_addr3 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4795: ben_ext_person.g_location_city := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4796: ben_ext_person.g_location_country := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4797: ben_ext_person.g_location_zip := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4798: ben_ext_person.g_location_region1 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4799: ben_ext_person.g_location_region2 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4800: ben_ext_person.g_location_region3 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4801: ben_ext_person.g_alc_flex_01 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4802: ben_ext_person.g_alc_flex_02 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4803: ben_ext_person.g_alc_flex_03 := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4804: ben_ext_person.g_alc_flex_04 := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4805: ben_ext_person.g_alc_flex_05 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4806: ben_ext_person.g_alc_flex_06 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4807: ben_ext_person.g_alc_flex_07 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4808: ben_ext_person.g_alc_flex_08 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4809: ben_ext_person.g_alc_flex_09 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4810: ben_ext_person.g_alc_flex_10 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4811: ben_ext_person.g_position_id := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4812: ben_ext_person.g_position := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4813: ben_ext_person.g_pos_flex_01 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4814: ben_ext_person.g_pos_flex_02 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4815: ben_ext_person.g_pos_flex_03 := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4816: ben_ext_person.g_pos_flex_04 := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4817: ben_ext_person.g_pos_flex_05 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4818: ben_ext_person.g_pos_flex_06 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4819: ben_ext_person.g_pos_flex_07 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4820: ben_ext_person.g_pos_flex_08 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4821: ben_ext_person.g_pos_flex_09 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4822: ben_ext_person.g_pos_flex_10 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4823: ben_ext_person.g_job_id := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4824: ben_ext_person.g_job := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4825: ben_ext_person.g_job_flex_01 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4826: ben_ext_person.g_job_flex_02 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4827: ben_ext_person.g_job_flex_03 := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4828: ben_ext_person.g_job_flex_04 := null;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4829: ben_ext_person.g_job_flex_05 := null;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4830: ben_ext_person.g_job_flex_06 := null;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4831: ben_ext_person.g_job_flex_07 := null;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4832: ben_ext_person.g_job_flex_08 := null;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4833: ben_ext_person.g_job_flex_09 := null;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4834: ben_ext_person.g_job_flex_10 := null;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4835: ben_ext_person.g_payroll := null;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4836: ben_ext_person.g_payroll_period_type := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4837: ben_ext_person.g_prl_flex_01 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4838: ben_ext_person.g_prl_flex_02 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4839: ben_ext_person.g_prl_flex_03 := null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4840: ben_ext_person.g_prl_flex_04 := null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4841: ben_ext_person.g_prl_flex_05 := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4842: ben_ext_person.g_prl_flex_06 := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4843: ben_ext_person.g_prl_flex_07 := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4844: ben_ext_person.g_prl_flex_08 := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4845: ben_ext_person.g_prl_flex_09 := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4846: ben_ext_person.g_prl_flex_10 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4847: ben_ext_person.g_payroll_period_number:= null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4848: ben_ext_person.g_payroll_period_strtdt:= null ;
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4849: ben_ext_person.g_payroll_period_enddt := null ;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4850: ben_ext_person.g_payroll_costing := null ;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4851: ben_ext_person.g_payroll_costing_id := null ;
4852: ben_ext_person.g_payroll_consolidation_set := null ;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4853: ben_ext_person.g_payroll_consolidation_set_id := null ;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4854: ben_ext_person.g_group_elmt_value1 := null ;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4855: ben_ext_person.g_group_elmt_value2 := null ;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4856: --
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4857: ben_ext_person.g_employee_grade_id := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4858: ben_ext_person.g_employee_grade := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4859: ben_ext_person.g_grd_flex_01 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4860: ben_ext_person.g_grd_flex_02 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4868: ben_ext_person.g_grd_flex_10 := null;
4861: ben_ext_person.g_grd_flex_03 := null;
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4868: ben_ext_person.g_grd_flex_10 := null;
4869:
4862: ben_ext_person.g_grd_flex_04 := null;
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4868: ben_ext_person.g_grd_flex_10 := null;
4869:
4870:
4863: ben_ext_person.g_grd_flex_05 := null;
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4868: ben_ext_person.g_grd_flex_10 := null;
4869:
4870:
4871: if g_debug then
4864: ben_ext_person.g_grd_flex_06 := null;
4865: ben_ext_person.g_grd_flex_07 := null;
4866: ben_ext_person.g_grd_flex_08 := null;
4867: ben_ext_person.g_grd_flex_09 := null;
4868: ben_ext_person.g_grd_flex_10 := null;
4869:
4870:
4871: if g_debug then
4872: hr_utility.set_location ('Exiting '||l_proc,15);
5049: end if ;
5050: --
5051: IF p_ext_crit_prfl_id is not null THEN
5052: --
5053: ben_ext_person.g_effective_date := p_effective_date ;
5054: ben_ext_evaluate_inclusion.Determine_Incl_Crit_To_Check(p_ext_crit_prfl_id);
5055: --
5056: END IF;
5057:
5100: if l_include = 'Y' then
5101:
5102: if ben_extract.g_bg_csr = 'Y' then
5103:
5104: ben_ext_person.g_business_group_id := l_bg.business_group_id ;
5105: ben_extract.g_business_group_name := l_bg.name ;
5106: end if ;
5107:
5108: --- extract organization and postion level
5120: p_effective_date => p_effective_date );
5121: end if ;
5122:
5123: if l_include = 'Y' then
5124: ben_ext_person.g_employee_organization_id := i.organization_id ;
5125: ben_ext_person.g_employee_organization := i.name ;
5126: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5127: p_ext_file_id => p_ext_file_id,
5128: p_data_typ_cd => p_data_typ_cd,
5121: end if ;
5122:
5123: if l_include = 'Y' then
5124: ben_ext_person.g_employee_organization_id := i.organization_id ;
5125: ben_ext_person.g_employee_organization := i.name ;
5126: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5127: p_ext_file_id => p_ext_file_id,
5128: p_data_typ_cd => p_data_typ_cd,
5129: p_ext_typ_cd => p_ext_typ_cd,
5170: end if ;
5171:
5172: -- call the function from per_person_extract
5173: if l_include = 'Y' then
5174: ben_ext_person.g_employee_organization_id := i.organization_id ;
5175: ben_ext_person.g_employee_organization := i.name ;
5176: ben_ext_person.g_position_id := j.position_id ;
5177:
5178: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5171:
5172: -- call the function from per_person_extract
5173: if l_include = 'Y' then
5174: ben_ext_person.g_employee_organization_id := i.organization_id ;
5175: ben_ext_person.g_employee_organization := i.name ;
5176: ben_ext_person.g_position_id := j.position_id ;
5177:
5178: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5179: p_effective_date => p_effective_date) ;
5172: -- call the function from per_person_extract
5173: if l_include = 'Y' then
5174: ben_ext_person.g_employee_organization_id := i.organization_id ;
5175: ben_ext_person.g_employee_organization := i.name ;
5176: ben_ext_person.g_position_id := j.position_id ;
5177:
5178: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5179: p_effective_date => p_effective_date) ;
5180:
5174: ben_ext_person.g_employee_organization_id := i.organization_id ;
5175: ben_ext_person.g_employee_organization := i.name ;
5176: ben_ext_person.g_position_id := j.position_id ;
5177:
5178: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5179: p_effective_date => p_effective_date) ;
5180:
5181: hr_utility.set_location ('position '||j.position_id,10);
5182: ben_ext_fmt.process_ext_recs(
5212: end if ;
5213:
5214: -- call the function from per_person_extract
5215: if l_include = 'Y' then
5216: ben_ext_person.g_employee_organization_id := i.organization_id ;
5217: ben_ext_person.g_employee_organization := i.name ;
5218: ben_ext_person.g_position_id := j.position_id ;
5219: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5220: p_effective_date => p_effective_date ) ;
5213:
5214: -- call the function from per_person_extract
5215: if l_include = 'Y' then
5216: ben_ext_person.g_employee_organization_id := i.organization_id ;
5217: ben_ext_person.g_employee_organization := i.name ;
5218: ben_ext_person.g_position_id := j.position_id ;
5219: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5220: p_effective_date => p_effective_date ) ;
5221:
5214: -- call the function from per_person_extract
5215: if l_include = 'Y' then
5216: ben_ext_person.g_employee_organization_id := i.organization_id ;
5217: ben_ext_person.g_employee_organization := i.name ;
5218: ben_ext_person.g_position_id := j.position_id ;
5219: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5220: p_effective_date => p_effective_date ) ;
5221:
5222: hr_utility.set_location ('position '||j.position_id,10);
5215: if l_include = 'Y' then
5216: ben_ext_person.g_employee_organization_id := i.organization_id ;
5217: ben_ext_person.g_employee_organization := i.name ;
5218: ben_ext_person.g_position_id := j.position_id ;
5219: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5220: p_effective_date => p_effective_date ) ;
5221:
5222: hr_utility.set_location ('position '||j.position_id,10);
5223: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5258: end if ;
5259: --
5260: -- call the function from per_person_extract
5261: if l_include = 'Y' then
5262: ben_ext_person.get_payroll_info(p_payroll_id => j.payroll_id,
5263: p_effective_date => p_effective_date ) ;
5264:
5265: hr_utility.set_location ('payroll id '||j.payroll_id,10);
5266: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5298: end if ;
5299: --
5300: -- call the function from per_person_extract
5301: if l_include = 'Y' then
5302: ben_ext_person.g_job_id := i.job_id ;
5303: ben_ext_person.get_job_info(p_job_id => i.job_id,
5304: p_effective_date => p_effective_date ) ;
5305:
5306: hr_utility.set_location ('job id '||i.job_id,10);
5299: --
5300: -- call the function from per_person_extract
5301: if l_include = 'Y' then
5302: ben_ext_person.g_job_id := i.job_id ;
5303: ben_ext_person.get_job_info(p_job_id => i.job_id,
5304: p_effective_date => p_effective_date ) ;
5305:
5306: hr_utility.set_location ('job id '||i.job_id,10);
5307: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5336: end if ;
5337: --
5338: -- call the function from per_person_extract
5339: if l_include = 'Y' then
5340: ben_ext_person.g_location_id := i.location_id ;
5341: ben_ext_person.get_loc_info(p_location_id => i.location_id,
5342: p_effective_date => p_effective_date ) ;
5343:
5344: hr_utility.set_location ('payroll id '||i.location_id,10);
5337: --
5338: -- call the function from per_person_extract
5339: if l_include = 'Y' then
5340: ben_ext_person.g_location_id := i.location_id ;
5341: ben_ext_person.get_loc_info(p_location_id => i.location_id,
5342: p_effective_date => p_effective_date ) ;
5343:
5344: hr_utility.set_location ('payroll id '||i.location_id,10);
5345: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5373: end if ;
5374: --
5375: -- call the function from per_person_extract
5376: if l_include = 'Y' then
5377: ben_ext_person.g_employee_grade_id := i.grade_id ;
5378: ben_ext_person.get_grade_info(p_grade_id => i.grade_id,
5379: p_effective_date => p_effective_date ) ;
5380:
5381: hr_utility.set_location ('grade id '||i.grade_id,10);
5374: --
5375: -- call the function from per_person_extract
5376: if l_include = 'Y' then
5377: ben_ext_person.g_employee_grade_id := i.grade_id ;
5378: ben_ext_person.get_grade_info(p_grade_id => i.grade_id,
5379: p_effective_date => p_effective_date ) ;
5380:
5381: hr_utility.set_location ('grade id '||i.grade_id,10);
5382: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,