[Home] [Help]
341: WHERE eef_new.assignment_id = p_assignment_id
342: and elt_new.element_type_id = eef_new.element_type_id
343: AND eef_new.effective_start_date BETWEEN elt_new.effective_start_date AND elt_new.effective_end_date
344: and eef_new.effective_start_date = trunc(p_effective_date)
345: and eef_new.effective_end_date = hr_api.g_eot
346: AND upper(pqp_fedhr_uspay_int_utils.return_old_element_name(elt_new.element_name,
347: p_business_group_id,
348: eef_new.effective_start_date))
349: IN ('HEALTH BENEFITS PRE TAX'
544: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
545: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
546: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
547: ,p_enrt_cvg_strt_dt => p_effective_date
548: ,p_enrt_cvg_thru_dt => hr_api.g_eot
549: ,p_datetrack_mode => 'INSERT'
550: ,p_suspend_flag => l_suspend_flag
551: ,p_effective_start_date => l_esd
552: ,p_effective_end_date => l_eed
592: --if there was no previous record for the same element entry then pass ZAP else delete to API
593: if l_object_version_number is null then
594: l_object_version_number := p_object_version_number;
595: py_element_entry_api.delete_element_entry(
596: p_datetrack_delete_mode => hr_api.g_zap,
597: p_effective_date => p_effective_date,
598: p_element_entry_id => p_element_entry_id,
599: p_object_version_number => l_object_version_number,
600: p_effective_start_date => l_eff_start_date,
601: p_effective_end_date => l_eff_end_date,
602: p_delete_warning => l_del_warning);
603: Else
604: py_element_entry_api.delete_element_entry(
605: p_datetrack_delete_mode => hr_api.g_delete,
606: p_effective_date => (p_effective_date - 1),
607: p_element_entry_id => p_element_entry_id,
608: p_object_version_number => l_object_version_number,
609: p_effective_start_date => l_eff_start_date,
621: exit;
622: end loop;
623: --dbms_output.put_line ('input_value_id ' ||l_input_val_id3);
624: py_element_entry_api.update_element_entry(
625: p_datetrack_update_mode => hr_api.g_correction
626: ,p_effective_date => p_effective_date
627: ,p_business_group_id => p_business_group_id
628: ,p_element_entry_id => get_new_element_details.element_entry_id
629: ,p_object_version_number => get_new_element_details.object_version_number
985: ,p_enrt_bnft_id => l_enrt_bnft_id
986: ,p_enrt_rt_id1 => l_enrt_rt_id
987: ,p_rt_val1 => p_opt_val
988: ,p_rt_strt_dt1 => l_effective_date
989: ,p_rt_end_dt1 => hr_api.g_eot
990: ,p_prtt_rt_val_id1 => l_prtt_rt_val_id1
991: ,p_prtt_rt_val_id2 => l_prtt_rt_val_id2
992: ,p_prtt_rt_val_id3 => l_prtt_rt_val_id3
993: ,p_prtt_rt_val_id4 => l_prtt_rt_val_id4
997: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
998: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
999: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
1000: ,p_enrt_cvg_strt_dt => p_effective_date
1001: ,p_enrt_cvg_thru_dt => hr_api.g_eot
1002: ,p_datetrack_mode => 'INSERT'
1003: ,p_suspend_flag => l_suspend_flag
1004: ,p_effective_start_date => l_esd
1005: ,p_effective_end_date => l_eed
1337: ,p_enrt_bnft_id => l_enrt_bnft_id
1338: ,p_enrt_rt_id1 => l_enrt_rt_id
1339: ,p_rt_val1 => p_opt_val
1340: ,p_rt_strt_dt1 => l_effective_date
1341: ,p_rt_end_dt1 => hr_api.g_eot
1342: ,p_prtt_rt_val_id1 => l_prtt_rt_val_id1
1343: ,p_prtt_rt_val_id2 => l_prtt_rt_val_id2
1344: ,p_prtt_rt_val_id3 => l_prtt_rt_val_id3
1345: ,p_prtt_rt_val_id4 => l_prtt_rt_val_id4
1349: ,p_prtt_rt_val_id8 => l_prtt_rt_val_id8
1350: ,p_prtt_rt_val_id9 => l_prtt_rt_val_id9
1351: ,p_prtt_rt_val_id10 => l_prtt_rt_val_id10
1352: ,p_enrt_cvg_strt_dt => p_effective_date
1353: ,p_enrt_cvg_thru_dt => hr_api.g_eot
1354: ,p_datetrack_mode => 'INSERT'
1355: ,p_suspend_flag => l_suspend_flag
1356: ,p_effective_start_date => l_esd
1357: ,p_effective_end_date => l_eed