[Home] [Help]
22: * friendly BEN error.
23: * 115.5 12-Jan-2004 maagrawa Global Budgeting Change.
24: * 115.6 25-Mar-2004 maagrawa Add a general message before the errors
25: * received from HR apis for SS.
26: * 115.7 29-Mar-2004 maagrawa Update ben_cwb_person_info with perf/promo
27: * ids when called from PP.
28: * 115.8 25-May-2004 maagrawa Splitting of perf/promo record and have
29: * them floating across plans.
30: * 115.9 01-Jul-2004 maagrawa Do not validate data in online mode.(Temp)
169: cursor c_per_in_ler is
170: select inf.group_per_in_ler_id
171: ,inf.group_pl_id pl_id
172: ,inf.lf_evt_ocrd_dt
173: from ben_cwb_person_info inf
174: ,ben_cwb_pl_dsgn pl
175: where inf.assignment_id = p_txn_old.transaction_id
176: and inf.group_pl_id = p_group_pl_id
177: and inf.group_pl_id = pl.pl_id
330: cursor c_per_in_ler is
331: select inf.group_per_in_ler_id
332: ,inf.group_pl_id pl_id
333: ,inf.lf_evt_ocrd_dt
334: from ben_cwb_person_info inf
335: ,ben_cwb_pl_dsgn pl
336: where inf.assignment_id = p_txn_old.transaction_id
337: and inf.group_pl_id = p_group_pl_id
338: and inf.group_pl_id = pl.pl_id
2605: if p_group_per_in_ler_id is not null then
2606: --
2607: l_update_event_id := l_event_id;
2608: l_update_review_id := l_performance_review_id;
2609: update ben_cwb_person_info
2610: set new_perf_event_id = l_update_event_id,
2611: new_perf_review_id = l_update_review_id,
2612: performance_rating = p_txn_rec.attribute3
2613: where group_per_in_ler_id = p_group_per_in_ler_id;
2860: end if;
2861: --
2862: if p_group_per_in_ler_id is not null and l_update_done then
2863: --
2864: update ben_cwb_person_info
2865: set new_assgn_ovn = l_asg_rec.object_version_number
2866: where group_per_in_ler_id = p_group_per_in_ler_id;
2867: --
2868: end if;