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