[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:
2256: begin
2257: --
2258: l_hv := mod(nvl(p_assignment_id,1)
2259: +nvl(p_element_type_id,2)
2260: +nvl(p_effective_date-hr_api.g_sot,3)
2261: ,ben_hash_utility.get_hash_key);
2262: --
2263: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2264: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2261: ,ben_hash_utility.get_hash_key);
2262: --
2263: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2264: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2265: and nvl(g_get_link_cache(l_hv).session_date,hr_api.g_sot) = nvl(p_effective_date,hr_api.g_sot)
2266: then
2267: --
2268: p_element_link_id := g_get_link_cache(l_hv).element_link_id;
2269: return;
2275: loop
2276: --
2277: if nvl(g_get_link_cache(l_hv).assignment_id,-1) = nvl(p_assignment_id,-1)
2278: and nvl(g_get_link_cache(l_hv).element_type_id,-1) = nvl(p_element_type_id,-1)
2279: and nvl(g_get_link_cache(l_hv).session_date,hr_api.g_sot) = nvl(p_effective_date,hr_api.g_sot)
2280: then
2281: --
2282: exit;
2283: --
2451: -- Only store the
2452: --
2453: l_hv := mod(nvl(p_assignment_id,1)
2454: +nvl(p_element_type_id,2)
2455: +nvl(p_effective_date-hr_api.g_sot,3)
2456: ,ben_hash_utility.get_hash_key
2457: );
2458: --
2459: while g_get_link_cache.exists(l_hv)
2590: end if;
2591: close c_chk_rt;
2592: py_element_entry_api.delete_element_entry
2593: (p_validate =>p_validate
2594: ,p_datetrack_delete_mode =>hr_api.g_zap
2595: ,p_effective_date =>l_future_ee_rec.effective_end_date
2596: ,p_element_entry_id =>l_future_ee_rec.element_entry_id
2597: ,p_object_version_number =>l_future_ee_rec.object_version_number
2598: ,p_effective_start_date =>l_effective_start_date
3070: l_element_name varchar2(80);
3071: l_processing_type varchar2(30);
3072: l_multiple_entries_flag varchar2(1);
3073: l_recurring_entry boolean := false;
3074: l_dummy_varchar2 varchar2(30) := hr_api.g_varchar2;
3075: l_creator_id number;
3076: l_creator_type varchar2(30);
3077: l_dummy_date date;
3078: l_new_element_link_id number;
3516: --
3517: -- reopen the entry if already ended
3518: --
3519: if l_fsa_element_entry_id is not null and
3520: l_fsa_ee_effective_end_date <> hr_api.g_eot and
3521: l_fsa_ee_effective_end_date <> l_element_term_rule_date and
3522: l_fsa_ee_effective_end_date <> l_element_link_end_date then
3523:
3524: begin
3716: --
3717: -- reopen the entry if already ended
3718: --
3719: if l_fsa_element_entry_id is not null and
3720: l_fsa_ee_effective_end_date <> hr_api.g_eot and
3721: l_fsa_ee_effective_end_date <> l_element_term_rule_date and
3722: l_fsa_ee_effective_end_date <> l_element_link_end_date then
3723:
3724: begin
4171:
4172: hr_utility.set_location('Max EE End Date '|| l_max_ee_end_dt, 9999);
4173: --
4174: if l_element_entry_id is not null and
4175: l_max_ee_end_dt <> hr_api.g_eot and -- 5229941
4176: l_ee_effective_end_date <> l_element_term_rule_date and
4177: l_ee_effective_end_date <> l_element_link_end_date then
4178:
4179: begin
5096: if g_debug then
5097: hr_utility.set_location('inserting mode ',90);
5098: end if;
5099: l_update_ee:=false;
5100: l_curr_val:=hr_api.g_number;
5101: end if;
5102: --
5103: -- Do the actual creates/updates to element entry
5104: --
5419: ED
5420: */
5421: py_element_entry_api.update_element_entry
5422: (p_validate => p_validate
5423: ,p_datetrack_update_mode => hr_api.g_correction
5424: ,p_effective_date => l_zero_pp_date
5425: ,p_business_group_id => p_business_group_id
5426: ,p_element_entry_id => l_element_entry_id
5427: ,p_override_user_ent_chk =>'Y'
5525: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
5526: hr_utility.set_location('converted no. value is '||l_curr_val,432);
5527: end if;
5528:
5529: if nvl(l_curr_val,hr_api.g_number) <>l_special_amt then
5530: /*
5531: Before :-
5532: 02-JAN-1994
5533: |-A----------------------------------------------------->
5747: ED
5748: */
5749: py_element_entry_api.update_element_entry
5750: (p_validate => p_validate
5751: ,p_datetrack_update_mode => hr_api.g_correction
5752: ,p_effective_date => l_special_pp_date
5753: ,p_business_group_id => p_business_group_id
5754: ,p_element_entry_id => l_element_entry_id
5755: ,p_override_user_ent_chk =>'Y'
5890: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
5891: hr_utility.set_location('converted no. value is '||l_curr_val,432);
5892: end if;
5893:
5894: if nvl(l_curr_val,hr_api.g_number) <>l_per_pay_amt then
5895: /*
5896: Before :-
5897: 02-JAN-1994
5898: |-A----------------------------------------------------->
6117: ED
6118: */
6119: py_element_entry_api.update_element_entry
6120: (p_validate =>p_validate
6121: ,p_datetrack_update_mode =>hr_api.g_correction
6122: ,p_effective_date =>l_normal_pp_date
6123: ,p_business_group_id =>p_business_group_id
6124: ,p_element_entry_id =>l_element_entry_id
6125: ,p_override_user_ent_chk =>'Y'
6184: hr_utility.set_location('if nvl(l_per_pay_amt,0) <> nvl(l_curr_val,0) then',44333);
6185: --
6186: py_element_entry_api.update_element_entry
6187: (p_validate =>p_validate
6188: ,p_datetrack_update_mode =>hr_api.g_correction
6189: ,p_effective_date =>l_future_ee_rec.effective_start_date
6190: ,p_business_group_id =>p_business_group_id
6191: ,p_element_entry_id =>l_future_ee_rec.element_entry_id
6192: ,p_override_user_ent_chk =>'Y'
6357: -- Change the creator type and id from the default
6358: --
6359: py_element_entry_api.update_element_entry
6360: (p_validate =>p_validate
6361: ,p_datetrack_update_mode =>hr_api.g_correction
6362: ,p_effective_date =>l_effective_date
6363: ,p_business_group_id =>p_business_group_id
6364: ,p_element_entry_id =>l_element_entry_id
6365: ,p_override_user_ent_chk =>'Y'
6374: end loop;
6375:
6376: end if;
6377:
6378: if l_effective_end_date <> hr_api.g_eot and
6379: l_recurring_entry then
6380:
6381: if l_effective_end_date < l_element_term_rule_date then
6382: l_message_name := 'BEN_93454_NO_ELK_TILL_EOT';
6457: if l_normal_pp_end_date is not null then
6458: --
6459: py_element_entry_api.delete_element_entry
6460: (p_validate => p_validate
6461: ,p_datetrack_delete_mode => hr_api.g_delete
6462: ,p_effective_date => l_normal_pp_end_date
6463: ,p_element_entry_id => l_element_entry_id
6464: ,p_object_version_number => l_object_version_number
6465: ,p_effective_start_date => l_effective_start_date
6469: --
6470: -- write to the change event log
6471: --
6472: ben_ext_chlg.log_element_chg
6473: (p_action => hr_api.g_delete
6474: ,p_old_amt => l_per_pay_amt
6475: ,p_input_value_id => l_input_value_id
6476: ,p_element_entry_id => l_element_entry_id
6477: ,p_person_id => p_person_id
6608: ,p_ler_id => l_ler_id
6609: ,p_per_in_ler_id => l_per_in_ler_id
6610: ,p_absence_attendance_id => l_absence_attendance_id
6611: ,p_effective_start_date => l_effective_start_date
6612: ,p_effective_end_date => nvl(l_effective_end_date,hr_api.g_eot)
6613: ,p_formula_outputs => g_outputs
6614: ,p_error_code => l_err_code
6615: ,p_error_message => l_err_mesg
6616: );
6986: fetch c_min_max_dt into l_min_start_date,l_max_end_date;
6987: close c_min_max_dt;
6988:
6989: if l_prv_rec.rt_strt_dt-1 < l_min_start_date then
6990: l_dt_del_mode := hr_api.g_zap;
6991: else
6992: l_dt_del_mode := hr_api.g_delete;
6993: end if;
6994:
6988:
6989: if l_prv_rec.rt_strt_dt-1 < l_min_start_date then
6990: l_dt_del_mode := hr_api.g_zap;
6991: else
6992: l_dt_del_mode := hr_api.g_delete;
6993: end if;
6994:
6995: l_effective_date :=
6996: greatest(l_current_ee_rec.effective_start_date,l_prv_rec.rt_strt_dt -1);
7007: --
7008: -- write to the change event log
7009: --
7010: ben_ext_chlg.log_element_chg(
7011: p_action => hr_api.g_delete,
7012: p_old_amt => null,
7013: p_input_value_id => l_abr_info.input_value_id,
7014: p_element_entry_id => l_current_ee_rec.element_entry_id,
7015: p_person_id => p_person_id,
7192: end if;
7193: --
7194:
7195: --
7196: if l_effective_date <> hr_api.g_eot then
7197: --
7198: -- check if abs ler
7199: --
7200: open c_chk_abs_ler
7251: --
7252: -- write to the change event log
7253: --
7254: ben_ext_chlg.log_element_chg(
7255: p_action => hr_api.g_delete,
7256: p_old_amt => null,
7257: p_input_value_id => l_input_value_id,
7258: p_element_entry_id => l_element_entry_id,
7259: p_person_id => p_person_id,
7386: );
7387:
7388: py_element_entry_api.update_element_entry
7389: (p_validate =>p_validate
7390: ,p_datetrack_update_mode =>hr_api.g_correction
7391: ,p_effective_date =>l_effective_date
7392: ,p_business_group_id =>p_business_group_id
7393: ,p_element_entry_id =>l_element_entry_id
7394: ,p_override_user_ent_chk =>'Y'
7415: l_effective_date := l_effective_end_date;
7416:
7417: end loop;
7418:
7419: if l_effective_date <> hr_api.g_eot then
7420:
7421: if l_effective_date < l_element_term_rule_date then
7422: l_message_name := 'BEN_93454_NO_ELK_TILL_EOT';
7423: else
7481: );
7482:
7483: py_element_entry_api.update_element_entry
7484: (p_validate =>p_validate
7485: ,p_datetrack_update_mode =>hr_api.g_correction
7486: ,p_effective_date =>l_effective_date
7487: ,p_business_group_id =>p_business_group_id
7488: ,p_element_entry_id =>l_element_entry_id
7489: ,p_object_version_number =>l_object_version_number
7761: end if;
7762:
7763: py_element_entry_api.delete_element_entry
7764: (p_validate => p_validate
7765: ,p_datetrack_delete_mode => hr_api.g_zap
7766: ,p_effective_date => p_rt_strt_date
7767: ,p_element_entry_id => p_element_entry_id
7768: ,p_object_version_number => l_object_version_number
7769: ,p_effective_start_date => l_effective_start_date -- out parm
7772: );
7773: -- write to the change event log
7774: --
7775: ben_ext_chlg.log_element_chg(
7776: p_action => hr_api.g_zap,
7777: p_old_amt => p_amt,
7778: p_input_value_id => p_input_value_id,
7779: p_element_entry_id => p_element_entry_id,
7780: p_person_id => p_person_id,
7860: );
7861:
7862: py_element_entry_api.update_element_entry
7863: (p_validate =>p_validate
7864: ,p_datetrack_update_mode =>hr_api.g_correction
7865: ,p_effective_date =>p_rt_strt_date
7866: ,p_business_group_id =>p_business_group_id
7867: ,p_element_entry_id =>l_element_entry_id
7868: ,p_object_version_number =>l_object_version_number
7959: THEN
7960: hr_utility.set_location ('ovn found ending element', 121);
7961: py_element_entry_api.delete_element_entry
7962: (p_validate => p_validate
7963: ,p_datetrack_delete_mode => hr_api.g_delete
7964: ,p_effective_date => p_rt_end_date
7965: ,p_element_entry_id => l_element_entry_id
7966: -- ,p_object_version_number => l_object_version_number
7967: ,p_object_version_number => l_ovn
7980: end if;
7981: -- write to the change event log
7982: --
7983: ben_ext_chlg.log_element_chg(
7984: p_action => hr_api.g_delete,
7985: p_old_amt => p_amt,
7986: p_input_value_id => p_input_value_id,
7987: p_element_entry_id => p_element_entry_id,
7988: p_person_id => p_person_id,
8637: fetch c_min_max_dt into l_min_start_date,l_max_end_date;
8638: close c_min_max_dt;
8639:
8640: if l_rt_end_dt < l_min_start_date then
8641: l_dt_delete_mode := hr_api.g_zap;
8642: elsif l_rt_end_dt < l_max_end_date then
8643: l_dt_delete_mode := hr_api.g_delete;
8644: end if;
8645: --
8639:
8640: if l_rt_end_dt < l_min_start_date then
8641: l_dt_delete_mode := hr_api.g_zap;
8642: elsif l_rt_end_dt < l_max_end_date then
8643: l_dt_delete_mode := hr_api.g_delete;
8644: end if;
8645: --
8646: -- if the entry is to be ended on l_rt_end_dt (or)
8647: -- has already been ended on l_rt_end_dt, then update the extra input vales
8694: OR g_ext_inpval_tab(14).input_value_id IS NOT NULL)
8695: then
8696: pay_element_entry_api.update_element_entry
8697: (p_validate =>p_validate
8698: ,p_datetrack_update_mode =>hr_api.g_correction
8699: ,p_effective_date =>l_element_entry_start_date
8700: ,p_business_group_id =>p_business_group_id
8701: ,p_element_entry_id =>l_element_entry_id
8702: ,p_object_version_number =>l_object_version_number
8759:
8760: end if;
8761:
8762: if l_abs_ler and
8763: l_dt_delete_mode = hr_api.g_delete then
8764: --
8765: -- ABSENCES: ZAP and recreate the element entry if the absence
8766: -- was processed in a payroll and is currently end dated in a
8767: -- period for which payroll has already been run.
8834: ,p_error_code => l_err_code
8835: ,p_error_message => l_err_mesg
8836: );
8837:
8838: elsif l_dt_delete_mode = hr_api.g_zap then
8839: if g_debug then
8840: hr_utility.set_location('ZAP mode',11);
8841: end if;
8842: /*
8849:
8850: */
8851: py_element_entry_api.delete_element_entry
8852: (p_validate => p_validate
8853: ,p_datetrack_delete_mode => hr_api.g_zap
8854: ,p_effective_date => l_element_entry_start_date
8855: ,p_element_entry_id => l_element_entry_id
8856: ,p_object_version_number => l_object_version_number
8857: ,p_effective_start_date => l_effective_start_date
8888: ,p_error_message => l_err_mesg
8889: );
8890: end if;
8891:
8892: elsif l_dt_delete_mode = hr_api.g_delete then
8893: if g_debug then
8894: hr_utility.set_location('DELETE mode',11);
8895: end if;
8896: --
9366: hr_utility.set_location('aft frmt chg '||l_curr_val_char,432);
9367: hr_utility.set_location('converted no. value is '||l_curr_val,432);
9368: end if;
9369:
9370: if nvl(l_curr_val,hr_api.g_number) <>l_special_amt then
9371: /*
9372: Before :-
9373: 02-JAN-1994
9374: |-A----------------------------------------------------->
9497: --
9498: -- write to the change event log
9499: --
9500: ben_ext_chlg.log_element_chg
9501: (p_action => hr_api.g_update
9502: ,p_amt => 0
9503: ,p_old_amt => l_curr_val
9504: ,p_input_value_id => l_input_value_id
9505: ,p_element_entry_id => l_element_entry_id
9574: --
9575: -- write to the change event log
9576: --
9577: ben_ext_chlg.log_element_chg(
9578: p_action => hr_api.g_delete,
9579: p_old_amt => fnd_number.canonical_to_number(l_curr_val_char),
9580: p_input_value_id => l_input_value_id,
9581: p_element_entry_id => l_element_entry_id,
9582: p_person_id => p_person_id,
9658: --
9659: else
9660: py_element_entry_api.delete_element_entry
9661: (p_validate => p_validate
9662: ,p_datetrack_delete_mode => hr_api.g_zap
9663: ,p_effective_date => l_future_ee_rec.effective_start_date
9664: ,p_element_entry_id => l_future_ee_rec.element_entry_id
9665: ,p_object_version_number => l_future_ee_rec.object_version_number
9666: ,p_effective_start_date => l_effective_start_date
9844: if l_processing_type = 'R' then
9845: -- the element should be end dated
9846: py_element_entry_api.delete_element_entry
9847: (p_validate => p_validate
9848: ,p_datetrack_delete_mode => hr_api.g_delete
9849: ,p_effective_date => p_effective_date
9850: ,p_element_entry_id => l_element_entry_id
9851: ,p_object_version_number => l_object_version_number
9852: ,p_effective_start_date => l_effective_start_date
9972: close c_element_entry;
9973: --
9974: py_element_entry_api.delete_element_entry
9975: (p_validate => p_validate
9976: ,p_datetrack_delete_mode => hr_api.g_zap
9977: ,p_effective_date => p_effective_date
9978: ,p_element_entry_id => l_ele_rec.element_entry_id
9979: ,p_object_version_number => l_object_version_number
9980: ,p_effective_start_date => l_effective_start_date