[Home] [Help]
961: p_update_override => l_update_override,
962: p_update_change_insert => l_update_change_insert);
963:
964: if l_update then
965: l_upd_mode := hr_api.g_update;
966: elsif l_update_override then
967: l_upd_mode := hr_api.g_update_override;
968: else
969: l_upd_mode := hr_api.g_correction;
963:
964: if l_update then
965: l_upd_mode := hr_api.g_update;
966: elsif l_update_override then
967: l_upd_mode := hr_api.g_update_override;
968: else
969: l_upd_mode := hr_api.g_correction;
970: end if;
971:
965: l_upd_mode := hr_api.g_update;
966: elsif l_update_override then
967: l_upd_mode := hr_api.g_update_override;
968: else
969: l_upd_mode := hr_api.g_correction;
970: end if;
971:
972: return l_upd_mode;
973:
2290: begin
2291: --
2292: l_hv := mod(nvl(p_assignment_id,1)
2293: +nvl(p_element_type_id,2)
2294: +nvl(p_effective_date-hr_api.g_sot,3)
2295: ,ben_hash_utility.get_hash_key);
2296: --
2297: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2298: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2295: ,ben_hash_utility.get_hash_key);
2296: --
2297: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2298: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2299: and nvl(g_get_link_cache(l_hv).session_date,hr_api.g_sot) = nvl(p_effective_date,hr_api.g_sot)
2300: then
2301: --
2302: p_element_link_id := g_get_link_cache(l_hv).element_link_id;
2303: return;
2309: loop
2310: --
2311: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2312: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2313: and nvl(g_get_link_cache(l_hv).session_date,hr_api.g_sot) = nvl(p_effective_date,hr_api.g_sot)
2314: then
2315: --
2316: exit;
2317: --
2485: -- Only store the
2486: --
2487: l_hv := mod(nvl(p_assignment_id,1)
2488: +nvl(p_element_type_id,2)
2489: +nvl(p_effective_date-hr_api.g_sot,3)
2490: ,ben_hash_utility.get_hash_key
2491: );
2492: --
2493: while g_get_link_cache.exists(l_hv)
2624: end if;
2625: close c_chk_rt;
2626: py_element_entry_api.delete_element_entry
2627: (p_validate =>p_validate
2628: ,p_datetrack_delete_mode =>hr_api.g_zap
2629: ,p_effective_date =>l_future_ee_rec.effective_end_date
2630: ,p_element_entry_id =>l_future_ee_rec.element_entry_id
2631: ,p_object_version_number =>l_future_ee_rec.object_version_number
2632: ,p_effective_start_date =>l_effective_start_date
3268: l_element_name varchar2(80);
3269: l_processing_type varchar2(30);
3270: l_multiple_entries_flag varchar2(1);
3271: l_recurring_entry boolean := false;
3272: l_dummy_varchar2 varchar2(30) := hr_api.g_varchar2;
3273: l_creator_id number;
3274: l_creator_type varchar2(30);
3275: l_dummy_date date;
3276: l_new_element_link_id number;
3761: --
3762: -- reopen the entry if already ended
3763: --
3764: if l_fsa_element_entry_id is not null and
3765: l_fsa_ee_effective_end_date <> hr_api.g_eot and
3766: l_fsa_ee_effective_end_date <> l_element_term_rule_date and
3767: l_fsa_ee_effective_end_date <> l_element_link_end_date then
3768:
3769: begin
4022: --
4023: -- reopen the entry if already ended
4024: --
4025: if l_fsa_element_entry_id is not null and
4026: l_fsa_ee_effective_end_date <> hr_api.g_eot and
4027: l_fsa_ee_effective_end_date <> l_element_term_rule_date and
4028: l_fsa_ee_effective_end_date <> l_element_link_end_date then
4029:
4030: begin
4477:
4478: hr_utility.set_location('Max EE End Date '|| l_max_ee_end_dt, 9999);
4479: --
4480: if l_element_entry_id is not null and
4481: l_max_ee_end_dt <> hr_api.g_eot and -- 5229941
4482: l_ee_effective_end_date <> l_element_term_rule_date and
4483: l_ee_effective_end_date <> l_element_link_end_date then
4484:
4485: begin
5442: if g_debug then
5443: hr_utility.set_location('inserting mode ',90);
5444: end if;
5445: l_update_ee:=false;
5446: l_curr_val:=hr_api.g_number;
5447: end if;
5448: --
5449: -- Do the actual creates/updates to element entry
5450: --
5765: ED
5766: */
5767: py_element_entry_api.update_element_entry
5768: (p_validate => p_validate
5769: ,p_datetrack_update_mode => hr_api.g_correction
5770: ,p_effective_date => l_zero_pp_date
5771: ,p_business_group_id => p_business_group_id
5772: ,p_element_entry_id => l_element_entry_id
5773: ,p_override_user_ent_chk =>'Y'
5871: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
5872: hr_utility.set_location('converted no. value is '||l_curr_val,432);
5873: end if;
5874:
5875: if nvl(l_curr_val,hr_api.g_number) <>l_special_amt then
5876: /*
5877: Before :-
5878: 02-JAN-1994
5879: |-A----------------------------------------------------->
6093: ED
6094: */
6095: py_element_entry_api.update_element_entry
6096: (p_validate => p_validate
6097: ,p_datetrack_update_mode => hr_api.g_correction
6098: ,p_effective_date => l_special_pp_date
6099: ,p_business_group_id => p_business_group_id
6100: ,p_element_entry_id => l_element_entry_id
6101: ,p_override_user_ent_chk =>'Y'
6258: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
6259: hr_utility.set_location('converted no. value is '||l_curr_val,432);
6260: end if;
6261:
6262: if nvl(l_curr_val,hr_api.g_number) <>l_per_pay_amt then
6263: /*
6264: Before :-
6265: 02-JAN-1994
6266: |-A----------------------------------------------------->
6492: ED
6493: */
6494: py_element_entry_api.update_element_entry
6495: (p_validate =>p_validate
6496: ,p_datetrack_update_mode =>hr_api.g_correction
6497: ,p_effective_date =>l_normal_pp_date
6498: ,p_business_group_id =>p_business_group_id
6499: ,p_element_entry_id =>l_element_entry_id
6500: ,p_override_user_ent_chk =>'Y'
6536:
6537: hr_utility.set_location('deleting the element ',44333);
6538: py_element_entry_api.delete_element_entry
6539: (p_validate => p_validate
6540: ,p_datetrack_delete_mode => hr_api.g_zap
6541: ,p_effective_date => l_entry_exists.effective_start_date
6542: ,p_element_entry_id => l_entry_exists.element_entry_id
6543: ,p_object_version_number => l_entry_exists.object_version_number
6544: ,p_effective_start_date => l_effective_start_date
6549: -- write to the change event log
6550: --
6551: /*hr_utility.set_location('Writing to log ',44333);
6552: ben_ext_chlg.log_element_chg
6553: (p_action => hr_api.g_delete
6554: ,p_old_amt => l_per_pay_amt
6555: ,p_input_value_id => l_input_value_id
6556: ,p_element_entry_id => l_element_entry_id
6557: ,p_person_id => p_person_id
6617: );
6618:
6619: py_element_entry_api.update_element_entry
6620: (p_validate =>p_validate
6621: ,p_datetrack_update_mode =>hr_api.g_correction
6622: ,p_effective_date =>l_normal_pp_date
6623: ,p_business_group_id =>p_business_group_id
6624: ,p_element_entry_id =>l_element_entry_id
6625: ,p_override_user_ent_chk =>'Y'
6694: hr_utility.set_location('if nvl(l_per_pay_amt,0) <> nvl(l_curr_val,0) then',44333);
6695: --
6696: py_element_entry_api.update_element_entry
6697: (p_validate =>p_validate
6698: ,p_datetrack_update_mode =>hr_api.g_correction
6699: ,p_effective_date =>l_future_ee_rec.effective_start_date
6700: ,p_business_group_id =>p_business_group_id
6701: ,p_element_entry_id =>l_future_ee_rec.element_entry_id
6702: ,p_override_user_ent_chk =>'Y'
6918: -- Change the creator type and id from the default
6919: --
6920: py_element_entry_api.update_element_entry
6921: (p_validate =>p_validate
6922: ,p_datetrack_update_mode =>hr_api.g_correction
6923: ,p_effective_date =>l_effective_date
6924: ,p_business_group_id =>p_business_group_id
6925: ,p_element_entry_id =>l_element_entry_id
6926: ,p_override_user_ent_chk =>'Y'
6935: end loop;
6936:
6937: end if;
6938:
6939: if l_effective_end_date <> hr_api.g_eot and
6940: l_recurring_entry then
6941:
6942: if l_effective_end_date < l_element_term_rule_date then
6943: l_message_name := 'BEN_93454_NO_ELK_TILL_EOT';
7018: if l_normal_pp_end_date is not null then
7019: --
7020: py_element_entry_api.delete_element_entry
7021: (p_validate => p_validate
7022: ,p_datetrack_delete_mode => hr_api.g_delete
7023: ,p_effective_date => l_normal_pp_end_date
7024: ,p_element_entry_id => l_element_entry_id
7025: ,p_object_version_number => l_object_version_number
7026: ,p_effective_start_date => l_effective_start_date
7030: --
7031: -- write to the change event log
7032: --
7033: ben_ext_chlg.log_element_chg
7034: (p_action => hr_api.g_delete
7035: ,p_old_amt => l_per_pay_amt
7036: ,p_input_value_id => l_input_value_id
7037: ,p_element_entry_id => l_element_entry_id
7038: ,p_person_id => p_person_id
7169: ,p_ler_id => l_ler_id
7170: ,p_per_in_ler_id => l_per_in_ler_id
7171: ,p_absence_attendance_id => l_absence_attendance_id
7172: ,p_effective_start_date => l_effective_start_date
7173: ,p_effective_end_date => nvl(l_effective_end_date,hr_api.g_eot)
7174: ,p_formula_outputs => g_outputs
7175: ,p_error_code => l_err_code
7176: ,p_error_message => l_err_mesg
7177: );
7547: fetch c_min_max_dt into l_min_start_date,l_max_end_date;
7548: close c_min_max_dt;
7549:
7550: if l_prv_rec.rt_strt_dt-1 < l_min_start_date then
7551: l_dt_del_mode := hr_api.g_zap;
7552: else
7553: l_dt_del_mode := hr_api.g_delete;
7554: end if;
7555:
7549:
7550: if l_prv_rec.rt_strt_dt-1 < l_min_start_date then
7551: l_dt_del_mode := hr_api.g_zap;
7552: else
7553: l_dt_del_mode := hr_api.g_delete;
7554: end if;
7555:
7556: l_effective_date :=
7557: greatest(l_current_ee_rec.effective_start_date,l_prv_rec.rt_strt_dt -1);
7568: --
7569: -- write to the change event log
7570: --
7571: ben_ext_chlg.log_element_chg(
7572: p_action => hr_api.g_delete,
7573: p_old_amt => null,
7574: p_input_value_id => l_abr_info.input_value_id,
7575: p_element_entry_id => l_current_ee_rec.element_entry_id,
7576: p_person_id => p_person_id,
7753: end if;
7754: --
7755:
7756: --
7757: if l_effective_date <> hr_api.g_eot then
7758: --
7759: -- check if abs ler
7760: --
7761: open c_chk_abs_ler
7812: --
7813: -- write to the change event log
7814: --
7815: ben_ext_chlg.log_element_chg(
7816: p_action => hr_api.g_delete,
7817: p_old_amt => null,
7818: p_input_value_id => l_input_value_id,
7819: p_element_entry_id => l_element_entry_id,
7820: p_person_id => p_person_id,
7947: );
7948:
7949: py_element_entry_api.update_element_entry
7950: (p_validate =>p_validate
7951: ,p_datetrack_update_mode =>hr_api.g_correction
7952: ,p_effective_date =>l_effective_date
7953: ,p_business_group_id =>p_business_group_id
7954: ,p_element_entry_id =>l_element_entry_id
7955: ,p_override_user_ent_chk =>'Y'
7976: l_effective_date := l_effective_end_date;
7977:
7978: end loop;
7979:
7980: if l_effective_date <> hr_api.g_eot then
7981:
7982: if l_effective_date < l_element_term_rule_date then
7983: l_message_name := 'BEN_93454_NO_ELK_TILL_EOT';
7984: else
8042: );
8043:
8044: py_element_entry_api.update_element_entry
8045: (p_validate =>p_validate
8046: ,p_datetrack_update_mode =>hr_api.g_correction
8047: ,p_effective_date =>l_effective_date
8048: ,p_business_group_id =>p_business_group_id
8049: ,p_element_entry_id =>l_element_entry_id
8050: ,p_object_version_number =>l_object_version_number
8322: end if;
8323:
8324: py_element_entry_api.delete_element_entry
8325: (p_validate => p_validate
8326: ,p_datetrack_delete_mode => hr_api.g_zap
8327: ,p_effective_date => p_rt_strt_date
8328: ,p_element_entry_id => p_element_entry_id
8329: ,p_object_version_number => l_object_version_number
8330: ,p_effective_start_date => l_effective_start_date -- out parm
8333: );
8334: -- write to the change event log
8335: --
8336: ben_ext_chlg.log_element_chg(
8337: p_action => hr_api.g_zap,
8338: p_old_amt => p_amt,
8339: p_input_value_id => p_input_value_id,
8340: p_element_entry_id => p_element_entry_id,
8341: p_person_id => p_person_id,
8421: );
8422:
8423: py_element_entry_api.update_element_entry
8424: (p_validate =>p_validate
8425: ,p_datetrack_update_mode =>hr_api.g_correction
8426: ,p_effective_date =>p_rt_strt_date
8427: ,p_business_group_id =>p_business_group_id
8428: ,p_element_entry_id =>l_element_entry_id
8429: ,p_object_version_number =>l_object_version_number
8520: THEN
8521: hr_utility.set_location ('ovn found ending element', 121);
8522: py_element_entry_api.delete_element_entry
8523: (p_validate => p_validate
8524: ,p_datetrack_delete_mode => hr_api.g_delete
8525: ,p_effective_date => p_rt_end_date
8526: ,p_element_entry_id => l_element_entry_id
8527: -- ,p_object_version_number => l_object_version_number
8528: ,p_object_version_number => l_ovn
8541: end if;
8542: -- write to the change event log
8543: --
8544: ben_ext_chlg.log_element_chg(
8545: p_action => hr_api.g_delete,
8546: p_old_amt => p_amt,
8547: p_input_value_id => p_input_value_id,
8548: p_element_entry_id => p_element_entry_id,
8549: p_person_id => p_person_id,
8915: and pen.business_group_id = p_business_group_id
8916: and pen.person_id = p_person_id
8917: and pen.prtt_enrt_rslt_stat_cd is null
8918: and pen.per_in_ler_id = p_pil_id
8919: and pen.effective_end_Date = hr_api.g_eot
8920: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
8921:
8922: l_check_current_pen c_check_current_pen%rowtype;
8923: --------------------Bug 9235544
8916: and pen.person_id = p_person_id
8917: and pen.prtt_enrt_rslt_stat_cd is null
8918: and pen.per_in_ler_id = p_pil_id
8919: and pen.effective_end_Date = hr_api.g_eot
8920: and pen.enrt_cvg_thru_dt = hr_api.g_eot;
8921:
8922: l_check_current_pen c_check_current_pen%rowtype;
8923: --------------------Bug 9235544
8924: --
9316: fetch c_min_max_dt into l_min_start_date,l_max_end_date;
9317: close c_min_max_dt;
9318:
9319: if l_rt_end_dt < l_min_start_date then
9320: l_dt_delete_mode := hr_api.g_zap;
9321: elsif l_rt_end_dt < l_max_end_date then
9322: l_dt_delete_mode := hr_api.g_delete;
9323: end if;
9324:
9318:
9319: if l_rt_end_dt < l_min_start_date then
9320: l_dt_delete_mode := hr_api.g_zap;
9321: elsif l_rt_end_dt < l_max_end_date then
9322: l_dt_delete_mode := hr_api.g_delete;
9323: end if;
9324:
9325: /*Bug 12382133: If the element type is Non recurring, ZAP the element*/
9326: if l_non_recurring_entry then
9323: end if;
9324:
9325: /*Bug 12382133: If the element type is Non recurring, ZAP the element*/
9326: if l_non_recurring_entry then
9327: l_dt_delete_mode := hr_api.g_zap;
9328: end if;
9329: hr_utility.set_location('l_dt_delete_mode ' || l_dt_delete_mode,1200);
9330: --
9331: -- if the entry is to be ended on l_rt_end_dt (or)
9379: OR g_ext_inpval_tab(14).input_value_id IS NOT NULL)
9380: then
9381: pay_element_entry_api.update_element_entry
9382: (p_validate =>p_validate
9383: ,p_datetrack_update_mode =>hr_api.g_correction
9384: ,p_effective_date =>l_element_entry_start_date
9385: ,p_business_group_id =>p_business_group_id
9386: ,p_element_entry_id =>l_element_entry_id
9387: ,p_object_version_number =>l_object_version_number
9444:
9445: end if;
9446:
9447: if l_abs_ler and
9448: l_dt_delete_mode = hr_api.g_delete then
9449: --
9450: -- ABSENCES: ZAP and recreate the element entry if the absence
9451: -- was processed in a payroll and is currently end dated in a
9452: -- period for which payroll has already been run.
9520: ,p_error_code => l_err_code
9521: ,p_error_message => l_err_mesg
9522: );
9523:
9524: elsif l_dt_delete_mode = hr_api.g_zap then
9525: if g_debug then
9526: hr_utility.set_location('ZAP mode',11);
9527: end if;
9528: /*
9535:
9536: */
9537: py_element_entry_api.delete_element_entry
9538: (p_validate => p_validate
9539: ,p_datetrack_delete_mode => hr_api.g_zap
9540: ,p_effective_date => l_element_entry_start_date
9541: ,p_element_entry_id => l_element_entry_id
9542: ,p_object_version_number => l_object_version_number
9543: ,p_effective_start_date => l_effective_start_date
9574: ,p_error_message => l_err_mesg
9575: );
9576: end if;
9577:
9578: elsif l_dt_delete_mode = hr_api.g_delete then
9579: if g_debug then
9580: hr_utility.set_location('DELETE mode',11);
9581: end if;
9582: --
10098: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
10099: hr_utility.set_location('converted no. value is '||l_curr_val,432);
10100: end if;
10101:
10102: if nvl(l_curr_val,hr_api.g_number) <>l_special_amt then
10103: /*
10104: Before :-
10105: 02-JAN-1994
10106: |-A----------------------------------------------------->
10229: --
10230: -- write to the change event log
10231: --
10232: ben_ext_chlg.log_element_chg
10233: (p_action => hr_api.g_update
10234: ,p_amt => 0
10235: ,p_old_amt => l_curr_val
10236: ,p_input_value_id => l_input_value_id
10237: ,p_element_entry_id => l_element_entry_id
10313: --
10314: -- write to the change event log
10315: --
10316: ben_ext_chlg.log_element_chg(
10317: p_action => hr_api.g_delete,
10318: p_old_amt => fnd_number.canonical_to_number(l_curr_val_char),
10319: p_input_value_id => l_input_value_id,
10320: p_element_entry_id => l_element_entry_id,
10321: p_person_id => p_person_id,
10397: --
10398: else
10399: py_element_entry_api.delete_element_entry
10400: (p_validate => p_validate
10401: ,p_datetrack_delete_mode => hr_api.g_zap
10402: ,p_effective_date => l_future_ee_rec.effective_start_date
10403: ,p_element_entry_id => l_future_ee_rec.element_entry_id
10404: ,p_object_version_number => l_future_ee_rec.object_version_number
10405: ,p_effective_start_date => l_effective_start_date
10583: if l_processing_type = 'R' then
10584: -- the element should be end dated
10585: py_element_entry_api.delete_element_entry
10586: (p_validate => p_validate
10587: ,p_datetrack_delete_mode => hr_api.g_delete
10588: ,p_effective_date => p_effective_date
10589: ,p_element_entry_id => l_element_entry_id
10590: ,p_object_version_number => l_object_version_number
10591: ,p_effective_start_date => l_effective_start_date
10711: close c_element_entry;
10712: --
10713: py_element_entry_api.delete_element_entry
10714: (p_validate => p_validate
10715: ,p_datetrack_delete_mode => hr_api.g_zap
10716: ,p_effective_date => p_effective_date
10717: ,p_element_entry_id => l_ele_rec.element_entry_id
10718: ,p_object_version_number => l_object_version_number
10719: ,p_effective_start_date => l_effective_start_date