[Home] [Help]
343: WHERE eef_new.assignment_id = p_assignment_id
344: and elt_new.element_type_id = eef_new.element_type_id
345: AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date
346: and eef_new.effective_start_date = trunc(p_effective_date)
347: and eef_new.effective_end_date = hr_api.g_eot
348: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt_new.element_name,
349: p_business_group_id,
350: eef_new.effective_start_date))
351: IN ('HEALTH BENEFITS PRE TAX'
555: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
556: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
557: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
558: ,p_enrt_cvg_strt_dt => p_effective_date
559: ,p_enrt_cvg_thru_dt => hr_api.g_eot
560: ,p_datetrack_mode => 'INSERT'
561: ,p_suspend_flag => l_suspend_flag
562: ,p_effective_start_date => l_esd
563: ,p_effective_end_date => l_eed
603: --if there was no previous record for the same element entry then pass ZAP else delete to API
604: if l_object_version_number is null then
605: l_object_version_number := p_object_version_number;
606: py_element_entry_api.delete_element_entry(
607: p_datetrack_delete_mode => hr_api.g_zap,
608: p_effective_date => p_effective_date,
609: p_element_entry_id => p_element_entry_id,
610: p_object_version_number => l_object_version_number,
611: p_effective_start_date => l_eff_start_date,
612: p_effective_end_date => l_eff_end_date,
613: p_delete_warning => l_del_warning);
614: Else
615: py_element_entry_api.delete_element_entry(
616: p_datetrack_delete_mode => hr_api.g_delete,
617: p_effective_date => (p_effective_date - 1),
618: p_element_entry_id => p_element_entry_id,
619: p_object_version_number => l_object_version_number,
620: p_effective_start_date => l_eff_start_date,
632: exit;
633: end loop;
634: --dbms_output.put_line ('input_value_id ' ||l_input_val_id3);
635: py_element_entry_api.update_element_entry(
636: p_datetrack_update_mode => hr_api.g_correction
637: ,p_effective_date => p_effective_date
638: ,p_business_group_id => p_business_group_id
639: ,p_element_entry_id => get_new_element_details.element_entry_id
640: ,p_object_version_number => get_new_element_details.object_version_number
1008: ,p_enrt_bnft_id => l_enrt_bnft_id
1009: ,p_enrt_rt_id1 => l_enrt_rt_id
1010: ,p_rt_val1 => p_opt_val
1011: ,p_rt_strt_dt1 => l_effective_date
1012: ,p_rt_end_dt1 => hr_api.g_eot
1013: ,p_prtt_rt_val_id1 => l_prtt_rt_val_id1
1014: ,p_prtt_rt_val_id2 => l_prtt_rt_val_id2
1015: ,p_prtt_rt_val_id3 => l_prtt_rt_val_id3
1016: ,p_prtt_rt_val_id4 => l_prtt_rt_val_id4
1020: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
1021: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
1022: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
1023: ,p_enrt_cvg_strt_dt => p_effective_date
1024: ,p_enrt_cvg_thru_dt => hr_api.g_eot
1025: ,p_datetrack_mode => 'INSERT'
1026: ,p_suspend_flag => l_suspend_flag
1027: ,p_effective_start_date => l_esd
1028: ,p_effective_end_date => l_eed
1371: ,p_enrt_bnft_id => l_enrt_bnft_id
1372: ,p_enrt_rt_id1 => l_enrt_rt_id
1373: ,p_rt_val1 => p_opt_val
1374: ,p_rt_strt_dt1 => l_effective_date
1375: ,p_rt_end_dt1 => hr_api.g_eot
1376: ,p_prtt_rt_val_id1 => l_prtt_rt_val_id1
1377: ,p_prtt_rt_val_id2 => l_prtt_rt_val_id2
1378: ,p_prtt_rt_val_id3 => l_prtt_rt_val_id3
1379: ,p_prtt_rt_val_id4 => l_prtt_rt_val_id4
1383: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
1384: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
1385: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
1386: ,p_enrt_cvg_strt_dt => p_effective_date
1387: ,p_enrt_cvg_thru_dt => hr_api.g_eot
1388: ,p_datetrack_mode => 'INSERT'
1389: ,p_suspend_flag => l_suspend_flag
1390: ,p_effective_start_date => l_esd
1391: ,p_effective_end_date => l_eed