[Home] [Help]
284: from ghr_pa_history
285: where pa_history_id = cp_pa_history_id);
286:
287: begin
288: hr_utility.set_location('Entering '|| l_proc,5);
289: hr_utility.set_location('p_table_name '|| p_table_name || l_proc,5);
290: hr_utility.set_location('p_cascade_type '|| p_cascade_type || l_proc,5);
291:
292: p_interv_on_eff_date := FALSE;
285: where pa_history_id = cp_pa_history_id);
286:
287: begin
288: hr_utility.set_location('Entering '|| l_proc,5);
289: hr_utility.set_location('p_table_name '|| p_table_name || l_proc,5);
290: hr_utility.set_location('p_cascade_type '|| p_cascade_type || l_proc,5);
291:
292: p_interv_on_eff_date := FALSE;
293: p_interv_on_table := FALSE;
286:
287: begin
288: hr_utility.set_location('Entering '|| l_proc,5);
289: hr_utility.set_location('p_table_name '|| p_table_name || l_proc,5);
290: hr_utility.set_location('p_cascade_type '|| p_cascade_type || l_proc,5);
291:
292: p_interv_on_eff_date := FALSE;
293: p_interv_on_table := FALSE;
294:
295: ghr_history_api.get_g_session_var( l_session_var);
296:
297: -- Initialize the true_false table with TRUE
298: -- Since only information 4 thru' information101 can be cascaded
299: hr_utility.set_location(l_proc,10);
300: For rowno in 7..101 loop -- Bug 1161542 changed 4..101 to 7..101
301: l_true_false(rowno) := TRUE;
302: End loop;
303:
305: IF p_table_name = 'PER_PEOPLE_F' THEN
306: l_true_false(6) := TRUE;
307: END IF;
308:
309: hr_utility.set_location(l_proc,15);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
306: l_true_false(6) := TRUE;
307: END IF;
308:
309: hr_utility.set_location(l_proc,15);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
307: END IF;
308:
309: hr_utility.set_location(l_proc,15);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
308:
309: hr_utility.set_location(l_proc,15);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
309: hr_utility.set_location(l_proc,15);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
310: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
311: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
312: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
313: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
314: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
315: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
316: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
317: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
318: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
319: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
320:
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
321: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
322: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
323: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
324: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
332:
325: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
332:
333: if (p_post_record.pa_request_id is null) then
326: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
332:
333: if (p_post_record.pa_request_id is null) then
334: hr_utility.set_location('gh: ' || l_proc,1000);
327: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
328: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
329: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
332:
333: if (p_post_record.pa_request_id is null) then
334: hr_utility.set_location('gh: ' || l_proc,1000);
335: --this is a core change, set root pa_history_id is the pa_history_id itself.
330: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
331: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
332:
333: if (p_post_record.pa_request_id is null) then
334: hr_utility.set_location('gh: ' || l_proc,1000);
335: --this is a core change, set root pa_history_id is the pa_history_id itself.
336: l_root_pa_history_id := p_post_record.pa_history_id;
337: else
338: hr_utility.set_location('gh: ' || l_proc,1001);
334: hr_utility.set_location('gh: ' || l_proc,1000);
335: --this is a core change, set root pa_history_id is the pa_history_id itself.
336: l_root_pa_history_id := p_post_record.pa_history_id;
337: else
338: hr_utility.set_location('gh: ' || l_proc,1001);
339: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
340: hr_utility.set_location('gh: ' || l_proc,1002);
341: fetch get_root_hist_id into l_root_pa_history_id;
342: hr_utility.set_location('gh: ' || l_proc,1003);
336: l_root_pa_history_id := p_post_record.pa_history_id;
337: else
338: hr_utility.set_location('gh: ' || l_proc,1001);
339: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
340: hr_utility.set_location('gh: ' || l_proc,1002);
341: fetch get_root_hist_id into l_root_pa_history_id;
342: hr_utility.set_location('gh: ' || l_proc,1003);
343: if l_root_pa_history_id is null then
344: close get_root_hist_id;
338: hr_utility.set_location('gh: ' || l_proc,1001);
339: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
340: hr_utility.set_location('gh: ' || l_proc,1002);
341: fetch get_root_hist_id into l_root_pa_history_id;
342: hr_utility.set_location('gh: ' || l_proc,1003);
343: if l_root_pa_history_id is null then
344: close get_root_hist_id;
345: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
346: hr_utility.raise_error;
341: fetch get_root_hist_id into l_root_pa_history_id;
342: hr_utility.set_location('gh: ' || l_proc,1003);
343: if l_root_pa_history_id is null then
344: close get_root_hist_id;
345: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
346: hr_utility.raise_error;
347: end if;
348: close get_root_hist_id;
349: end if;
342: hr_utility.set_location('gh: ' || l_proc,1003);
343: if l_root_pa_history_id is null then
344: close get_root_hist_id;
345: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
346: hr_utility.raise_error;
347: end if;
348: close get_root_hist_id;
349: end if;
350: hr_utility.set_location('gh: ' || l_proc,1005);
346: hr_utility.raise_error;
347: end if;
348: close get_root_hist_id;
349: end if;
350: hr_utility.set_location('gh: ' || l_proc,1005);
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
347: end if;
348: close get_root_hist_id;
349: end if;
350: hr_utility.set_location('gh: ' || l_proc,1005);
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
355: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
348: close get_root_hist_id;
349: end if;
350: hr_utility.set_location('gh: ' || l_proc,1005);
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
355: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
356:
349: end if;
350: hr_utility.set_location('gh: ' || l_proc,1005);
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
355: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
356:
357: -- Retrieve all root history_ids
350: hr_utility.set_location('gh: ' || l_proc,1005);
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
355: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
356:
357: -- Retrieve all root history_ids
358: For history_data in c_history(p_table_name,
351: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
352: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
353: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
354: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
355: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
356:
357: -- Retrieve all root history_ids
358: For history_data in c_history(p_table_name,
359: p_post_record.information1,
361: P_post_record.effective_date,
362: l_root_pa_history_id
363: ) loop
364: l_history_id := history_data.pa_history_id;
365: hr_utility.set_location(l_proc,20);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
362: l_root_pa_history_id
363: ) loop
364: l_history_id := history_data.pa_history_id;
365: hr_utility.set_location(l_proc,20);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
363: ) loop
364: l_history_id := history_data.pa_history_id;
365: hr_utility.set_location(l_proc,20);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
364: l_history_id := history_data.pa_history_id;
365: hr_utility.set_location(l_proc,20);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
365: hr_utility.set_location(l_proc,20);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
373: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
366: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
373: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
374:
367: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
373: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
374:
375: -- If any record is retrieved then set p_interv_on_table to TRUE
368: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
373: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
374:
375: -- If any record is retrieved then set p_interv_on_table to TRUE
376: p_interv_on_table := TRUE;
369: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
370: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
371: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
372: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
373: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
374:
375: -- If any record is retrieved then set p_interv_on_table to TRUE
376: p_interv_on_table := TRUE;
377: if (history_data.pa_request_id is not null) then
398: else
399: --core change
400: l_record_data := history_data;
401: end if;
402: hr_utility.set_location(l_proc,25);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
399: --core change
400: l_record_data := history_data;
401: end if;
402: hr_utility.set_location(l_proc,25);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
400: l_record_data := history_data;
401: end if;
402: hr_utility.set_location(l_proc,25);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
401: end if;
402: hr_utility.set_location(l_proc,25);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
402: hr_utility.set_location(l_proc,25);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
403: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
404: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
412: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
405: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
412: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
413:
406: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
412: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
413:
414: if l_record_data.effective_date = l_session_var.date_effective then
407: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
412: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
413:
414: if l_record_data.effective_date = l_session_var.date_effective then
415: p_interv_on_eff_date := TRUE;
408: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
409: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
410: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
411: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
412: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
413:
414: if l_record_data.effective_date = l_session_var.date_effective then
415: p_interv_on_eff_date := TRUE;
416: p_hist_data_as_of_date := l_record_data;
419: -- If cascade_type is 'retroactive' the new changes by the current SF52, which is the
420: -- post_record in the history has to be cascaded to all the above fetched records from history
421: if lower(p_cascade_Type) = 'retroactive' then
422:
423: hr_utility.set_location(l_proc,30);
424: cascade_Change(p_pre_record => p_Pre_record,
425: p_post_record => p_Post_record,
426: p_apply_record => l_record_data,
427: p_true_false => l_true_false
425: p_post_record => p_Post_record,
426: p_apply_record => l_record_data,
427: p_true_false => l_true_false
428: );
429: hr_utility.set_location(l_proc,35);
430:
431: elsif lower(p_cascade_Type) = 'cancel' then
432:
433: hr_utility.set_location(l_proc,40);
429: hr_utility.set_location(l_proc,35);
430:
431: elsif lower(p_cascade_Type) = 'cancel' then
432:
433: hr_utility.set_location(l_proc,40);
434: cascade_Change(p_pre_record => p_Post_record,
435: p_post_record => p_Pre_record,
436: p_apply_record => l_record_data,
437: p_true_false => l_true_false
435: p_post_record => p_Pre_record,
436: p_apply_record => l_record_data,
437: p_true_false => l_true_false
438: );
439: hr_utility.set_location(l_proc,45);
440:
441: else
442: hr_utility.set_location(l_proc,50);
443: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
438: );
439: hr_utility.set_location(l_proc,45);
440:
441: else
442: hr_utility.set_location(l_proc,50);
443: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
444: hr_utility.raise_error;
445: -- raise error /* Unknown type */
446: end if;
439: hr_utility.set_location(l_proc,45);
440:
441: else
442: hr_utility.set_location(l_proc,50);
443: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
444: hr_utility.raise_error;
445: -- raise error /* Unknown type */
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
440:
441: else
442: hr_utility.set_location(l_proc,50);
443: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
444: hr_utility.raise_error;
445: -- raise error /* Unknown type */
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
444: hr_utility.raise_error;
445: -- raise error /* Unknown type */
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
444: hr_utility.raise_error;
445: -- raise error /* Unknown type */
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
445: -- raise error /* Unknown type */
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
446: end if;
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
447: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
448: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
449: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
457: -- update history record with changes to be cascaded :
450: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
457: -- update history record with changes to be cascaded :
458: hr_utility.set_location(l_proc,80);
451: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
457: -- update history record with changes to be cascaded :
458: hr_utility.set_location(l_proc,80);
459: ghr_pah_upd.upd
452: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
453: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
457: -- update history record with changes to be cascaded :
458: hr_utility.set_location(l_proc,80);
459: ghr_pah_upd.upd
460: (
454: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
455: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
456: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
457: -- update history record with changes to be cascaded :
458: hr_utility.set_location(l_proc,80);
459: ghr_pah_upd.upd
460: (
461: p_pa_history_id => l_record_data.pa_history_id,
462: p_pa_request_id => l_record_data.pa_request_id,
674: -- Determine whether to continue cascading , which is identified by looking at the
675: -- true_false flag for all the columns that can be cascaded,
676: -- If all of them are set to false, then stop cascading.
677:
678: hr_utility.set_location(l_proc,85);
679: l_stop := Stop_cascade(l_true_false);
680: hr_utility.set_location(l_proc,90);
681: If not l_stop then
682: hr_utility.set_location(l_proc,95);
676: -- If all of them are set to false, then stop cascading.
677:
678: hr_utility.set_location(l_proc,85);
679: l_stop := Stop_cascade(l_true_false);
680: hr_utility.set_location(l_proc,90);
681: If not l_stop then
682: hr_utility.set_location(l_proc,95);
683: exit;
684: End if;
678: hr_utility.set_location(l_proc,85);
679: l_stop := Stop_cascade(l_true_false);
680: hr_utility.set_location(l_proc,90);
681: If not l_stop then
682: hr_utility.set_location(l_proc,95);
683: exit;
684: End if;
685: hr_utility.set_location(l_proc,95);
686: if (history_data.pa_request_id is null) then
681: If not l_stop then
682: hr_utility.set_location(l_proc,95);
683: exit;
684: End if;
685: hr_utility.set_location(l_proc,95);
686: if (history_data.pa_request_id is null) then
687: -- core change, only want to do one iteration of this loop.
688: exit;
689: end if;
691: if (history_data.pa_request_id is not null) then
692: -- this was not a core change,so we opened this cursor.
693: close c_cascade_history;
694: end if;
695: hr_utility.set_location(l_proc,100);
696: End loop; -- End of root loop
697: hr_utility.set_location('Leaving ' || l_proc,105);
698: Exception
699: When Others then
693: close c_cascade_history;
694: end if;
695: hr_utility.set_location(l_proc,100);
696: End loop; -- End of root loop
697: hr_utility.set_location('Leaving ' || l_proc,105);
698: Exception
699: When Others then
700: -- RESET In/Out params and SET Out Params
701: p_interv_on_table :=null;
700: -- RESET In/Out params and SET Out Params
701: p_interv_on_table :=null;
702: p_interv_on_eff_date :=null;
703: p_hist_data_as_of_date :=null;
704: hr_utility.set_location('Leaving ' || l_proc,110);
705: Raise;
706:
707: End cascade_history_data;
708:
762: ) is
763:
764: l_proc varchar2(30):='Cascade_appl_table_data';
765: Begin
766: hr_utility.set_location( 'Entering : ' || l_proc, 10);
767: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
768: hr_utility.set_location( l_proc, 20);
769: Cascade_People(
770: p_pre_record => p_pre_record,
764: l_proc varchar2(30):='Cascade_appl_table_data';
765: Begin
766: hr_utility.set_location( 'Entering : ' || l_proc, 10);
767: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
768: hr_utility.set_location( l_proc, 20);
769: Cascade_People(
770: p_pre_record => p_pre_record,
771: p_post_record => p_post_record,
772: p_cascade_type => p_cascade_type,
773: p_interv_on_eff_date => p_interv_on_eff_date,
774: p_hist_data_as_of_date => p_hist_data_as_of_date);
775:
776: elsif lower(p_table_name) = lower(ghr_history_api.g_asgn_table) then
777: hr_utility.set_location( l_proc, 30);
778: Cascade_asgn (
779: p_pre_record => p_pre_record,
780: p_post_record => p_post_record,
781: p_cascade_type => p_cascade_type,
781: p_cascade_type => p_cascade_type,
782: p_interv_on_eff_date => p_interv_on_eff_date,
783: p_hist_data_as_of_date => p_hist_data_as_of_date);
784: elsif lower(p_table_name) = lower(ghr_history_api.g_eleent_table) then
785: hr_utility.set_location( l_proc, 40);
786: -- this is already handled in cancel/correction procedures
787: -- retroactive actions need not cascade change in element_entry
788: null;
789: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
786: -- this is already handled in cancel/correction procedures
787: -- retroactive actions need not cascade change in element_entry
788: null;
789: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
790: hr_utility.set_location( l_proc, 50);
791: -- this is already handled in cancel/correction procedures
792: -- retroactive actions need not cascade change in element_entry_values
793: null;
794: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
791: -- this is already handled in cancel/correction procedures
792: -- retroactive actions need not cascade change in element_entry_values
793: null;
794: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
795: hr_utility.set_location( l_proc, 60);
796: Cascade_peopleei (
797: p_post_record => p_post_record);
798: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
799: hr_utility.set_location( l_proc, 70);
795: hr_utility.set_location( l_proc, 60);
796: Cascade_peopleei (
797: p_post_record => p_post_record);
798: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
799: hr_utility.set_location( l_proc, 70);
800: Cascade_asgnei (
801: p_post_record => p_post_record);
802: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
803: hr_utility.set_location( l_proc, 80);
799: hr_utility.set_location( l_proc, 70);
800: Cascade_asgnei (
801: p_post_record => p_post_record);
802: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
803: hr_utility.set_location( l_proc, 80);
804: Cascade_addresses (
805: p_post_record => p_post_record);
806: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
807: hr_utility.set_location( l_proc, 90);
803: hr_utility.set_location( l_proc, 80);
804: Cascade_addresses (
805: p_post_record => p_post_record);
806: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
807: hr_utility.set_location( l_proc, 90);
808: Cascade_posnei (
809: p_post_record => p_post_record);
810: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
811: hr_utility.set_location( l_proc, 90);
807: hr_utility.set_location( l_proc, 90);
808: Cascade_posnei (
809: p_post_record => p_post_record);
810: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
811: hr_utility.set_location( l_proc, 90);
812: /*
813: Cascade_posn (
814: p_post_record => p_post_record);
815: */
821: p_hist_data_as_of_date => p_hist_data_as_of_date);
822:
823: elsif lower(p_table_name) in (lower(ghr_history_api.g_perana_table)) then
824: -- This table need not cascade.
825: hr_utility.set_location( l_proc, 95);
826: Cascade_perana (
827: p_post_record => p_post_record);
828: null;
829: else
826: Cascade_perana (
827: p_post_record => p_post_record);
828: null;
829: else
830: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
831: --raise error
832: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
833: hr_utility.raise_error;
834: end if;
828: null;
829: else
830: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
831: --raise error
832: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
833: hr_utility.raise_error;
834: end if;
835: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
836:
829: else
830: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
831: --raise error
832: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
833: hr_utility.raise_error;
834: end if;
835: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
836:
837: End;
831: --raise error
832: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
833: hr_utility.raise_error;
834: end if;
835: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
836:
837: End;
838:
839: -- ---------------------------------------------------------------------------
897: where effective_start_date >= c_date_effective and
898: person_id = c_person_id;
899:
900: Begin
901: hr_utility.set_location( 'Entering : ' || l_proc, 10);
902: For rowno in 4..101 loop
903: l_true_false(rowno) := TRUE;
904: End loop;
905: hr_utility.set_location( l_proc, 15);
901: hr_utility.set_location( 'Entering : ' || l_proc, 10);
902: For rowno in 4..101 loop
903: l_true_false(rowno) := TRUE;
904: End loop;
905: hr_utility.set_location( l_proc, 15);
906: if p_interv_on_eff_date then
907: -- This is to take care of multiple actions on the same date.
908: -- When a correction is made to a SF52 and other process had
909: -- updated the same row on the same date, the data in the
911: -- granularity of a day, and not date and time. So, this will
912: -- re-apply the data from history for the effective date of the current action to the
913: -- core table. This will insure that the core table will contain the correct information
914: -- in all cases.
915: hr_utility.set_location( l_proc, 20);
916: ghr_history_conv_rg.Conv_to_people_rg(
917: p_people_data => l_people_data,
918: p_history_data => p_hist_data_as_of_date);
919: correct_people_row( p_people_data => l_people_data);
916: ghr_history_conv_rg.Conv_to_people_rg(
917: p_people_data => l_people_data,
918: p_history_data => p_hist_data_as_of_date);
919: correct_people_row( p_people_data => l_people_data);
920: hr_utility.set_location( l_proc, 30);
921: elsif (lower(p_cascade_type) = 'cancel') then
922: -- if this is a cancellation and there are no intervening rows on this effective date,
923: -- then apply the pre-record to the core people table for this effective date.
924: hr_utility.set_location( l_proc, 35);
920: hr_utility.set_location( l_proc, 30);
921: elsif (lower(p_cascade_type) = 'cancel') then
922: -- if this is a cancellation and there are no intervening rows on this effective date,
923: -- then apply the pre-record to the core people table for this effective date.
924: hr_utility.set_location( l_proc, 35);
925: ghr_history_conv_rg.Conv_to_people_rg(
926: p_people_data => l_people_data,
927: p_history_data => p_pre_record);
928: correct_people_row( p_people_data => l_people_data);
927: p_history_data => p_pre_record);
928: correct_people_row( p_people_data => l_people_data);
929: end if;
930:
931: hr_utility.set_location( l_proc, 40);
932: -- Fetch all the following rows.
933: open c_people( p_post_record.effective_date, to_number(p_post_record.information1));
934: while true
935: Loop
932: -- Fetch all the following rows.
933: open c_people( p_post_record.effective_date, to_number(p_post_record.information1));
934: while true
935: Loop
936: hr_utility.set_location( l_proc, 50);
937: fetch c_people into l_people_data;
938: exit when not c_people%found;
939: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
940: p_history_data => l_hist_peop_data);
939: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
940: p_history_data => l_hist_peop_data);
941:
942: if lower(p_cascade_Type) = 'retroactive' then
943: hr_utility.set_location( l_proc, 60);
944: -- for retroactive action post-record values have to be cascaded
945: -- whereever pre-record values exist.
946: cascade_Change(p_pre_record => p_Pre_record,
947: p_post_record => p_Post_record,
950:
951: elsif lower(p_cascade_Type) = 'cancel' then
952: -- for cancellation action pre-record values have to be cascaded
953: -- whereever post-record values exist.
954: hr_utility.set_location( l_proc, 70);
955: cascade_Change(p_pre_record => p_Post_record,
956: p_post_record => p_Pre_record,
957: p_apply_record => l_hist_peop_data,
958: p_true_false => l_true_false);
956: p_post_record => p_Pre_record,
957: p_apply_record => l_hist_peop_data,
958: p_true_false => l_true_false);
959: else
960: hr_utility.set_location( l_proc, 80);
961: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
962: hr_utility.raise_error;
963: -- raise error /* Unknown type */
964: end if;
957: p_apply_record => l_hist_peop_data,
958: p_true_false => l_true_false);
959: else
960: hr_utility.set_location( l_proc, 80);
961: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
962: hr_utility.raise_error;
963: -- raise error /* Unknown type */
964: end if;
965:
958: p_true_false => l_true_false);
959: else
960: hr_utility.set_location( l_proc, 80);
961: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
962: hr_utility.raise_error;
963: -- raise error /* Unknown type */
964: end if;
965:
966: -- As a column value
965:
966: -- As a column value
967: l_stop := Stop_cascade(l_true_false);
968: if not l_stop then
969: hr_utility.set_location( l_proc || ' exit loop ', 90);
970: exit;
971: else
972: hr_utility.set_location( l_proc, 100);
973: ghr_history_conv_rg.conv_to_people_rg(
968: if not l_stop then
969: hr_utility.set_location( l_proc || ' exit loop ', 90);
970: exit;
971: else
972: hr_utility.set_location( l_proc, 100);
973: ghr_history_conv_rg.conv_to_people_rg(
974: p_people_data => l_people_data,
975: p_history_data => l_hist_peop_data);
976: correct_people_row( p_people_data => l_people_data);
975: p_history_data => l_hist_peop_data);
976: correct_people_row( p_people_data => l_people_data);
977: end if;
978: end loop;
979: hr_utility.set_location( l_proc, 200);
980: close c_people;
981: End;
982:
983: -- ---------------------------------------------------------------------------
1042: assignment_id = c_asgn_id;
1043:
1044: Begin
1045:
1046: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1047: For rowno in 4..101 loop
1048: l_true_false(rowno) := TRUE;
1049: End loop;
1050: hr_utility.set_location( l_proc, 15);
1046: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1047: For rowno in 4..101 loop
1048: l_true_false(rowno) := TRUE;
1049: End loop;
1050: hr_utility.set_location( l_proc, 15);
1051: if p_interv_on_eff_date then
1052: -- This is to take care of multiple actions on the same date.
1053: -- When a correction is made to a SF52 and other process had
1054: -- updated the same row on the same date, the data in the
1056: -- granularity of a day, and not date and time. So, this will
1057: -- re-apply the data from history for the effective date of the current action to the
1058: -- core table. This will insure that the core table will contain the correct information
1059: -- in all cases.
1060: hr_utility.set_location( l_proc, 20);
1061:
1062: ghr_history_conv_rg.Conv_to_asgn_rg(
1063: p_assignment_data => l_asgn_data,
1064: p_history_data => p_hist_data_as_of_date);
1063: p_assignment_data => l_asgn_data,
1064: p_history_data => p_hist_data_as_of_date);
1065:
1066: correct_asgn_row( p_asgn_data => l_asgn_data);
1067: hr_utility.set_location( l_proc, 30);
1068: elsif (lower(p_cascade_type) = 'cancel') then
1069: -- if this is a cancellation and there are no intervening rows on this effective date,
1070: -- then apply the pre-record to the core people table for this effective date.
1071: hr_utility.set_location( l_proc, 35);
1067: hr_utility.set_location( l_proc, 30);
1068: elsif (lower(p_cascade_type) = 'cancel') then
1069: -- if this is a cancellation and there are no intervening rows on this effective date,
1070: -- then apply the pre-record to the core people table for this effective date.
1071: hr_utility.set_location( l_proc, 35);
1072: ghr_history_conv_rg.Conv_to_asgn_rg(
1073: p_assignment_data => l_asgn_data,
1074: p_history_data => p_pre_record);
1075: correct_asgn_row( p_asgn_data => l_asgn_data);
1074: p_history_data => p_pre_record);
1075: correct_asgn_row( p_asgn_data => l_asgn_data);
1076: end if;
1077:
1078: hr_utility.set_location( l_proc, 40);
1079: -- Fetch all the following rows.
1080: open c_asgn( p_post_record.effective_date, to_number(p_post_record.information1));
1081: while true
1082: Loop
1079: -- Fetch all the following rows.
1080: open c_asgn( p_post_record.effective_date, to_number(p_post_record.information1));
1081: while true
1082: Loop
1083: hr_utility.set_location( l_proc, 50);
1084: fetch c_asgn into l_asgn_data;
1085: exit when not c_asgn%found;
1086:
1087: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
1088: p_assignment_data => l_asgn_data,
1089: p_history_data => l_hist_asgn_data);
1090:
1091: if lower(p_cascade_Type) = 'retroactive' then
1092: hr_utility.set_location( l_proc, 60);
1093: -- for retroactive action post-record values have to be cascaded
1094: -- whereever pre-record values exist.
1095: cascade_Change(p_pre_record => p_Pre_record,
1096: p_post_record => p_Post_record,
1099:
1100: elsif lower(p_cascade_Type) = 'cancel' then
1101: -- for cancellation action pre-record values have to be cascaded
1102: -- whereever post-record values exist.
1103: hr_utility.set_location( l_proc, 70);
1104: cascade_Change(p_pre_record => p_Post_record,
1105: p_post_record => p_Pre_record,
1106: p_apply_record => l_hist_asgn_data,
1107: p_true_false => l_true_false);
1105: p_post_record => p_Pre_record,
1106: p_apply_record => l_hist_asgn_data,
1107: p_true_false => l_true_false);
1108: else
1109: hr_utility.set_location( l_proc, 80);
1110: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1111: hr_utility.raise_error;
1112: -- raise error /* Unknown type */
1113: end if;
1106: p_apply_record => l_hist_asgn_data,
1107: p_true_false => l_true_false);
1108: else
1109: hr_utility.set_location( l_proc, 80);
1110: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1111: hr_utility.raise_error;
1112: -- raise error /* Unknown type */
1113: end if;
1114:
1107: p_true_false => l_true_false);
1108: else
1109: hr_utility.set_location( l_proc, 80);
1110: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1111: hr_utility.raise_error;
1112: -- raise error /* Unknown type */
1113: end if;
1114:
1115: -- As a column value
1114:
1115: -- As a column value
1116: l_stop := Stop_cascade(l_true_false);
1117: if not l_stop then
1118: hr_utility.set_location( l_proc || ' exit loop ', 90);
1119: exit;
1120: else
1121: hr_utility.set_location( l_proc, 100);
1122: ghr_history_conv_rg.conv_to_asgn_rg(
1117: if not l_stop then
1118: hr_utility.set_location( l_proc || ' exit loop ', 90);
1119: exit;
1120: else
1121: hr_utility.set_location( l_proc, 100);
1122: ghr_history_conv_rg.conv_to_asgn_rg(
1123: p_assignment_data => l_asgn_data,
1124: p_history_data => l_hist_asgn_data);
1125:
1125:
1126: correct_asgn_row( p_asgn_data => l_asgn_data);
1127: end if;
1128: end loop;
1129: hr_utility.set_location( l_proc, 200);
1130: close c_asgn;
1131: End cascade_Asgn;
1132:
1133: -- ---------------------------------------------------------------------------
1175:
1176: Begin
1177:
1178:
1179: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1180: -- This procedure will fetch
1181: -- the most recent record from history and update the database.
1182: hr_utility.set_location( l_proc, 20);
1183: Fetch_most_recent_record(
1178:
1179: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1180: -- This procedure will fetch
1181: -- the most recent record from history and update the database.
1182: hr_utility.set_location( l_proc, 20);
1183: Fetch_most_recent_record(
1184: p_table_name => ghr_history_api.g_peopei_table,
1185: p_table_pk_id => p_post_record.information1,
1186: p_person_id => p_post_record.person_id,
1188: p_result_code => l_result_code);
1189: if l_result_code = 'not_found' then
1190: -- this should never be the case
1191: -- raise error.
1192: hr_utility.set_location( l_proc, 30);
1193: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1194: hr_utility.raise_error;
1195: else
1196: hr_utility.set_location( l_proc, 40);
1189: if l_result_code = 'not_found' then
1190: -- this should never be the case
1191: -- raise error.
1192: hr_utility.set_location( l_proc, 30);
1193: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1194: hr_utility.raise_error;
1195: else
1196: hr_utility.set_location( l_proc, 40);
1197: ghr_history_conv_rg.Conv_to_peopleei_rg(
1190: -- this should never be the case
1191: -- raise error.
1192: hr_utility.set_location( l_proc, 30);
1193: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1194: hr_utility.raise_error;
1195: else
1196: hr_utility.set_location( l_proc, 40);
1197: ghr_history_conv_rg.Conv_to_peopleei_rg(
1198: p_people_ei_data => l_peopleei_data,
1192: hr_utility.set_location( l_proc, 30);
1193: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1194: hr_utility.raise_error;
1195: else
1196: hr_utility.set_location( l_proc, 40);
1197: ghr_history_conv_rg.Conv_to_peopleei_rg(
1198: p_people_ei_data => l_peopleei_data,
1199: p_history_data => l_hist_peopleei_data);
1200: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1196: hr_utility.set_location( l_proc, 40);
1197: ghr_history_conv_rg.Conv_to_peopleei_rg(
1198: p_people_ei_data => l_peopleei_data,
1199: p_history_data => l_hist_peopleei_data);
1200: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1201: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1202: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1203: end if;
1204: hr_utility.set_location( l_proc, 90);
1197: ghr_history_conv_rg.Conv_to_peopleei_rg(
1198: p_people_ei_data => l_peopleei_data,
1199: p_history_data => l_hist_peopleei_data);
1200: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1201: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1202: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1203: end if;
1204: hr_utility.set_location( l_proc, 90);
1205:
1200: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1201: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1202: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1203: end if;
1204: hr_utility.set_location( l_proc, 90);
1205:
1206: End cascade_peopleei;
1207:
1208: -- ---------------------------------------------------------------------------
1251:
1252: Begin
1253:
1254:
1255: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1256: -- This procedure will fetch
1257: -- the most recent record from history and update the database.
1258: hr_utility.set_location( l_proc, 20);
1259: Fetch_most_recent_record(
1254:
1255: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1256: -- This procedure will fetch
1257: -- the most recent record from history and update the database.
1258: hr_utility.set_location( l_proc, 20);
1259: Fetch_most_recent_record(
1260: p_table_name => ghr_history_api.g_asgnei_table,
1261: p_table_pk_id => p_post_record.information1,
1262: p_person_id => p_post_record.person_id,
1264: p_result_code => l_result_code);
1265: if l_result_code = 'not_found' then
1266: -- this should never be the case
1267: -- raise error.
1268: hr_utility.set_location( l_proc, 30);
1269: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1270: hr_utility.raise_error;
1271: else
1272: hr_utility.set_location( l_proc, 40);
1265: if l_result_code = 'not_found' then
1266: -- this should never be the case
1267: -- raise error.
1268: hr_utility.set_location( l_proc, 30);
1269: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1270: hr_utility.raise_error;
1271: else
1272: hr_utility.set_location( l_proc, 40);
1273: ghr_history_conv_rg.Conv_to_asgnei_rg(
1266: -- this should never be the case
1267: -- raise error.
1268: hr_utility.set_location( l_proc, 30);
1269: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1270: hr_utility.raise_error;
1271: else
1272: hr_utility.set_location( l_proc, 40);
1273: ghr_history_conv_rg.Conv_to_asgnei_rg(
1274: p_asgnei_data => l_asgnei_data,
1268: hr_utility.set_location( l_proc, 30);
1269: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1270: hr_utility.raise_error;
1271: else
1272: hr_utility.set_location( l_proc, 40);
1273: ghr_history_conv_rg.Conv_to_asgnei_rg(
1274: p_asgnei_data => l_asgnei_data,
1275: p_history_data => l_hist_asgnei_data);
1276: correct_asgnei_row( p_asgnei_data => l_asgnei_data);
1274: p_asgnei_data => l_asgnei_data,
1275: p_history_data => l_hist_asgnei_data);
1276: correct_asgnei_row( p_asgnei_data => l_asgnei_data);
1277: end if;
1278: hr_utility.set_location( l_proc, 90);
1279:
1280: End cascade_asgnei;
1281:
1282: -- ---------------------------------------------------------------------------
1324: l_curr_sess_date fnd_sessions.effective_date%type;
1325:
1326: Begin
1327:
1328: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1329: -- This procedure will fetch
1330: -- the most recent record from history and update the database.
1331: hr_utility.set_location( l_proc, 20);
1332: Fetch_most_recent_record(
1327:
1328: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1329: -- This procedure will fetch
1330: -- the most recent record from history and update the database.
1331: hr_utility.set_location( l_proc, 20);
1332: Fetch_most_recent_record(
1333: p_table_name => ghr_history_api.g_posnei_table,
1334: p_table_pk_id => p_post_record.information1,
1335: p_person_id => p_post_record.person_id,
1337: p_result_code => l_result_code);
1338: if l_result_code = 'not_found' then
1339: -- this should never be the case
1340: -- raise error.
1341: hr_utility.set_location( l_proc, 30);
1342: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1343: hr_utility.raise_error;
1344: else
1345: hr_utility.set_location( l_proc, 40);
1338: if l_result_code = 'not_found' then
1339: -- this should never be the case
1340: -- raise error.
1341: hr_utility.set_location( l_proc, 30);
1342: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1343: hr_utility.raise_error;
1344: else
1345: hr_utility.set_location( l_proc, 40);
1346: GHR_HISTORY_API.get_session_date(l_curr_sess_date);
1339: -- this should never be the case
1340: -- raise error.
1341: hr_utility.set_location( l_proc, 30);
1342: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1343: hr_utility.raise_error;
1344: else
1345: hr_utility.set_location( l_proc, 40);
1346: GHR_HISTORY_API.get_session_date(l_curr_sess_date);
1347:
1341: hr_utility.set_location( l_proc, 30);
1342: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1343: hr_utility.raise_error;
1344: else
1345: hr_utility.set_location( l_proc, 40);
1346: GHR_HISTORY_API.get_session_date(l_curr_sess_date);
1347:
1348: ghr_history_conv_rg.Conv_to_positionei_rg(
1349: p_position_ei_data => l_posnei_data,
1363: --Bug # 9408524 modified to call set_fnd_session_date
1364: ghr_session.set_fnd_session_date(l_curr_sess_date);
1365: --Bug #7646662
1366: end if;
1367: hr_utility.set_location( l_proc, 90);
1368:
1369: End cascade_posnei;
1370:
1371: /*
1414: Begin
1415:
1416: -- This procedure will fetch
1417: -- the most recent record from history and update the database.
1418: hr_utility.set_location( l_proc, 20);
1419: Fetch_most_recent_record(
1420: p_table_name => ghr_history_api.g_posn_table,
1421: p_table_pk_id => p_post_record.information1,
1422: p_person_id => p_post_record.person_id,
1424: p_result_code => l_result_code);
1425: if l_result_code = 'not_found' then
1426: -- this should never be the case
1427: -- raise error.
1428: hr_utility.set_location( l_proc, 30);
1429: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1430: hr_utility.raise_error;
1431: else
1432: hr_utility.set_location( l_proc, 40);
1425: if l_result_code = 'not_found' then
1426: -- this should never be the case
1427: -- raise error.
1428: hr_utility.set_location( l_proc, 30);
1429: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1430: hr_utility.raise_error;
1431: else
1432: hr_utility.set_location( l_proc, 40);
1433: ghr_history_conv_rg.Conv_to_position_rg(
1426: -- this should never be the case
1427: -- raise error.
1428: hr_utility.set_location( l_proc, 30);
1429: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1430: hr_utility.raise_error;
1431: else
1432: hr_utility.set_location( l_proc, 40);
1433: ghr_history_conv_rg.Conv_to_position_rg(
1434: p_position_data => l_posn_data,
1428: hr_utility.set_location( l_proc, 30);
1429: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1430: hr_utility.raise_error;
1431: else
1432: hr_utility.set_location( l_proc, 40);
1433: ghr_history_conv_rg.Conv_to_position_rg(
1434: p_position_data => l_posn_data,
1435: p_history_data => l_hist_posn_data);
1436:
1435: p_history_data => l_hist_posn_data);
1436:
1437: correct_posn_row( p_posn_data => l_posn_data);
1438: end if;
1439: hr_utility.set_location( l_proc, 90);
1440:
1441: End cascade_posn;
1442: */
1443:
1504: position_id = c_posn_id;
1505:
1506: Begin
1507:
1508: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1509: For rowno in 4..101 loop
1510: l_true_false(rowno) := TRUE;
1511: End loop;
1512: hr_utility.set_location( l_proc, 15);
1508: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1509: For rowno in 4..101 loop
1510: l_true_false(rowno) := TRUE;
1511: End loop;
1512: hr_utility.set_location( l_proc, 15);
1513: if p_interv_on_eff_date then
1514: -- This is to take care of multiple actions on the same date.
1515: -- When a correction is made to a SF52 and other process had
1516: -- updated the same row on the same date, the data in the
1518: -- granularity of a day, and not date and time. So, this will
1519: -- re-apply the data from history for the effective date of the current action to the
1520: -- core table. This will insure that the core table will contain the correct information
1521: -- in all cases.
1522: hr_utility.set_location( l_proc, 20);
1523:
1524: ghr_history_conv_rg.Conv_to_position_rg(
1525: p_position_data => l_posn_data,
1526: p_history_data => p_hist_data_as_of_date);
1525: p_position_data => l_posn_data,
1526: p_history_data => p_hist_data_as_of_date);
1527:
1528: correct_posn_row( p_posn_data => l_posn_data);
1529: hr_utility.set_location( l_proc, 30);
1530: elsif (lower(p_cascade_type) = 'cancel') then
1531: -- if this is a cancellation and there are no intervening rows on this effective date,
1532: -- then apply the pre-record to the core people table for this effective date.
1533: hr_utility.set_location( l_proc, 35);
1529: hr_utility.set_location( l_proc, 30);
1530: elsif (lower(p_cascade_type) = 'cancel') then
1531: -- if this is a cancellation and there are no intervening rows on this effective date,
1532: -- then apply the pre-record to the core people table for this effective date.
1533: hr_utility.set_location( l_proc, 35);
1534: ghr_history_conv_rg.Conv_to_position_rg(
1535: p_position_data => l_posn_data,
1536: p_history_data => p_pre_record);
1537: correct_posn_row( p_posn_data => l_posn_data);
1536: p_history_data => p_pre_record);
1537: correct_posn_row( p_posn_data => l_posn_data);
1538: end if;
1539:
1540: hr_utility.set_location( l_proc, 40);
1541: -- Fetch all the following rows.
1542: open c_posn( p_post_record.effective_date, to_number(p_post_record.information1));
1543: while true
1544: Loop
1541: -- Fetch all the following rows.
1542: open c_posn( p_post_record.effective_date, to_number(p_post_record.information1));
1543: while true
1544: Loop
1545: hr_utility.set_location( l_proc, 50);
1546: fetch c_posn into l_posn_data;
1547: exit when not c_posn%found;
1548:
1549: ghr_history_conv_rg.conv_position_rg_to_hist_rg(
1550: p_position_data => l_posn_data,
1551: p_history_data => l_hist_posn_data);
1552:
1553: if lower(p_cascade_Type) = 'retroactive' then
1554: hr_utility.set_location( l_proc, 60);
1555: -- for retroactive action post-record values have to be cascaded
1556: -- whereever pre-record values exist.
1557: cascade_Change(p_pre_record => p_Pre_record,
1558: p_post_record => p_Post_record,
1561:
1562: elsif lower(p_cascade_Type) = 'cancel' then
1563: -- for cancellation action pre-record values have to be cascaded
1564: -- whereever post-record values exist.
1565: hr_utility.set_location( l_proc, 70);
1566: cascade_Change(p_pre_record => p_Post_record,
1567: p_post_record => p_Pre_record,
1568: p_apply_record => l_hist_posn_data,
1569: p_true_false => l_true_false);
1567: p_post_record => p_Pre_record,
1568: p_apply_record => l_hist_posn_data,
1569: p_true_false => l_true_false);
1570: else
1571: hr_utility.set_location( l_proc, 80);
1572: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1573: hr_utility.raise_error;
1574: -- raise error /* Unknown type */
1575: end if;
1568: p_apply_record => l_hist_posn_data,
1569: p_true_false => l_true_false);
1570: else
1571: hr_utility.set_location( l_proc, 80);
1572: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1573: hr_utility.raise_error;
1574: -- raise error /* Unknown type */
1575: end if;
1576:
1569: p_true_false => l_true_false);
1570: else
1571: hr_utility.set_location( l_proc, 80);
1572: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1573: hr_utility.raise_error;
1574: -- raise error /* Unknown type */
1575: end if;
1576:
1577: -- As a column value
1576:
1577: -- As a column value
1578: l_stop := Stop_cascade(l_true_false);
1579: if not l_stop then
1580: hr_utility.set_location( l_proc || ' exit loop ', 90);
1581: exit;
1582: else
1583: hr_utility.set_location( l_proc, 100);
1584: ghr_history_conv_rg.conv_to_position_rg(
1579: if not l_stop then
1580: hr_utility.set_location( l_proc || ' exit loop ', 90);
1581: exit;
1582: else
1583: hr_utility.set_location( l_proc, 100);
1584: ghr_history_conv_rg.conv_to_position_rg(
1585: p_position_data => l_posn_data,
1586: p_history_data => l_hist_posn_data);
1587:
1587:
1588: correct_posn_row( p_posn_data => l_posn_data);
1589: end if;
1590: end loop;
1591: hr_utility.set_location( l_proc, 200);
1592: close c_posn;
1593: End cascade_posn;
1594:
1595: -- ---------------------------------------------------------------------------
1636:
1637: Begin
1638:
1639:
1640: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1641: -- This procedure will fetch
1642: -- the most recent record from history and update the database.
1643: hr_utility.set_location( l_proc, 20);
1644: Fetch_most_recent_record(
1639:
1640: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1641: -- This procedure will fetch
1642: -- the most recent record from history and update the database.
1643: hr_utility.set_location( l_proc, 20);
1644: Fetch_most_recent_record(
1645: p_table_name => ghr_history_api.g_addres_table,
1646: p_table_pk_id => p_post_record.information1,
1647: p_person_id => p_post_record.person_id,
1649: p_result_code => l_result_code);
1650: if l_result_code = 'not_found' then
1651: -- this should never be the case
1652: -- raise error.
1653: hr_utility.set_location( l_proc, 30);
1654: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1655: hr_utility.raise_error;
1656: else
1657: hr_utility.set_location( l_proc, 40);
1650: if l_result_code = 'not_found' then
1651: -- this should never be the case
1652: -- raise error.
1653: hr_utility.set_location( l_proc, 30);
1654: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1655: hr_utility.raise_error;
1656: else
1657: hr_utility.set_location( l_proc, 40);
1658: ghr_history_conv_rg.Conv_to_addresses_rg(
1651: -- this should never be the case
1652: -- raise error.
1653: hr_utility.set_location( l_proc, 30);
1654: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1655: hr_utility.raise_error;
1656: else
1657: hr_utility.set_location( l_proc, 40);
1658: ghr_history_conv_rg.Conv_to_addresses_rg(
1659: p_addresses_data => l_addresses_data,
1653: hr_utility.set_location( l_proc, 30);
1654: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1655: hr_utility.raise_error;
1656: else
1657: hr_utility.set_location( l_proc, 40);
1658: ghr_history_conv_rg.Conv_to_addresses_rg(
1659: p_addresses_data => l_addresses_data,
1660: p_history_data => l_hist_addresses_data);
1661: correct_addresses_row( p_addr_data => l_addresses_data);
1659: p_addresses_data => l_addresses_data,
1660: p_history_data => l_hist_addresses_data);
1661: correct_addresses_row( p_addr_data => l_addresses_data);
1662: end if;
1663: hr_utility.set_location( l_proc, 90);
1664: End cascade_addresses;
1665:
1666: -- ---------------------------------------------------------------------------
1667: -- |--------------------------< cascade_perana>-------------------------------|
1707:
1708: Begin
1709:
1710:
1711: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1712: -- This procedure will fetch
1713: -- the most recent record from history and update the database.
1714: hr_utility.set_location( l_proc, 20);
1715: Fetch_most_recent_record(
1710:
1711: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1712: -- This procedure will fetch
1713: -- the most recent record from history and update the database.
1714: hr_utility.set_location( l_proc, 20);
1715: Fetch_most_recent_record(
1716: p_table_name => ghr_history_api.g_perana_table,
1717: p_table_pk_id => p_post_record.information1,
1718: p_person_id => p_post_record.person_id,
1720: p_result_code => l_result_code);
1721: if l_result_code = 'not_found' then
1722: -- this should never be the case
1723: -- raise error.
1724: hr_utility.set_location( l_proc, 30);
1725: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1726: hr_utility.raise_error;
1727: else
1728: hr_utility.set_location( l_proc, 40);
1721: if l_result_code = 'not_found' then
1722: -- this should never be the case
1723: -- raise error.
1724: hr_utility.set_location( l_proc, 30);
1725: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1726: hr_utility.raise_error;
1727: else
1728: hr_utility.set_location( l_proc, 40);
1729: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1722: -- this should never be the case
1723: -- raise error.
1724: hr_utility.set_location( l_proc, 30);
1725: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1726: hr_utility.raise_error;
1727: else
1728: hr_utility.set_location( l_proc, 40);
1729: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1730: p_peranalyses_data => l_perana_data,
1724: hr_utility.set_location( l_proc, 30);
1725: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1726: hr_utility.raise_error;
1727: else
1728: hr_utility.set_location( l_proc, 40);
1729: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1730: p_peranalyses_data => l_perana_data,
1731: p_history_data => l_hist_perana_data);
1732: correct_perana_row( p_perana_data => l_perana_data);
1730: p_peranalyses_data => l_perana_data,
1731: p_history_data => l_hist_perana_data);
1732: correct_perana_row( p_perana_data => l_perana_data);
1733: end if;
1734: hr_utility.set_location( l_proc, 90);
1735: End cascade_perana;
1736:
1737: -- ---------------------------------------------------------------------------
1738: -- |--------------------------< correct_people_row>---------------------------|
1786: l_date1 per_all_people_f.effective_start_date%type;
1787:
1788: Begin
1789:
1790: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1791: -- Initialise Local Variables
1792: l_people_data:=p_people_data;
1793: --
1794: open c_people_getovn( cp_person_id => p_people_data.person_id,
1796: cp_eff_end_dt => p_people_data.effective_end_date );
1797: Fetch c_people_getovn into p_people_data.object_version_number,p_people_data.npw_number;--Bug# 10195261
1798: if c_people_getovn%notfound then
1799: close c_people_getovn;
1800: hr_utility.set_message(8301, 'GHR_38368_PEOPLE_OVN_NFND');
1801: hr_utility.raise_error;
1802: else
1803: close c_people_getovn;
1804: end if;
1797: Fetch c_people_getovn into p_people_data.object_version_number,p_people_data.npw_number;--Bug# 10195261
1798: if c_people_getovn%notfound then
1799: close c_people_getovn;
1800: hr_utility.set_message(8301, 'GHR_38368_PEOPLE_OVN_NFND');
1801: hr_utility.raise_error;
1802: else
1803: close c_people_getovn;
1804: end if;
1805: l_date1 := p_people_data.effective_start_date;
1936: p_orig_hire_warning => l_orig_hire_warning,
1937: p_npw_number => p_people_data.npw_number,
1938: p_current_npw_flag => p_people_data.current_npw_flag
1939: );
1940: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
1941: Exception
1942: When Others then
1943: -- RESET In/Out Params and SET Out Params
1944: p_people_data:=l_people_data;
1941: Exception
1942: When Others then
1943: -- RESET In/Out Params and SET Out Params
1944: p_people_data:=l_people_data;
1945: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
1946: Raise;
1947:
1948: End Correct_people_row;
1949:
2005:
2006: l_proc varchar2(30):='correct_asgn_row';
2007:
2008: Begin
2009: hr_utility.set_location('Entering : ' || l_proc, 10);
2010:
2011: -- Initialise local variables
2012: l_asgn_data:=p_asgn_data;
2013: --
2016: cp_eff_end_dt => p_asgn_data.effective_end_date );
2017: Fetch c_asgn_getovn into p_asgn_data.object_version_number;
2018: if c_asgn_getovn%notfound then
2019: close c_asgn_getovn;
2020: hr_utility.set_message(8301, 'GHR_38369_ASGN_OVN_NFND');
2021: hr_utility.raise_error;
2022: else
2023: close c_asgn_getovn;
2024: end if;
2017: Fetch c_asgn_getovn into p_asgn_data.object_version_number;
2018: if c_asgn_getovn%notfound then
2019: close c_asgn_getovn;
2020: hr_utility.set_message(8301, 'GHR_38369_ASGN_OVN_NFND');
2021: hr_utility.raise_error;
2022: else
2023: close c_asgn_getovn;
2024: end if;
2025:
2118: p_datetrack_mode => l_datetrack_mode ,
2119: p_validate => l_validate
2120: );
2121:
2122: hr_utility.set_location('Leaving : ' || l_proc, 20);
2123: Exception
2124: When Others then
2125: -- RESET In/Out params and SET Out Params
2126: p_asgn_data:=l_asgn_data;
2123: Exception
2124: When Others then
2125: -- RESET In/Out params and SET Out Params
2126: p_asgn_data:=l_asgn_data;
2127: hr_utility.set_location('Leaving : ' || l_proc,25);
2128: Raise;
2129:
2130: End correct_asgn_row;
2131:
2168:
2169: l_peopleei_data per_people_extra_info%rowtype;
2170: l_proc varchar2(30):='correct_peopleei_row';
2171: Begin
2172: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2173: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2174: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2175:
2176: --Initialise Local Variables
2169: l_peopleei_data per_people_extra_info%rowtype;
2170: l_proc varchar2(30):='correct_peopleei_row';
2171: Begin
2172: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2173: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2174: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2175:
2176: --Initialise Local Variables
2177: l_peopleei_data := p_peopleei_data;
2170: l_proc varchar2(30):='correct_peopleei_row';
2171: Begin
2172: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2173: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2174: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2175:
2176: --Initialise Local Variables
2177: l_peopleei_data := p_peopleei_data;
2178: --
2179:
2180: open c_peopleei_getovn( p_peopleei_data.person_extra_info_id );
2181: Fetch c_peopleei_getovn into p_peopleei_data.object_version_number;
2182: if c_peopleei_getovn%notfound then
2183: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2184: close c_peopleei_getovn;
2185: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2186: hr_utility.raise_error;
2187: else
2181: Fetch c_peopleei_getovn into p_peopleei_data.object_version_number;
2182: if c_peopleei_getovn%notfound then
2183: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2184: close c_peopleei_getovn;
2185: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2186: hr_utility.raise_error;
2187: else
2188: close c_peopleei_getovn;
2189: end if;
2182: if c_peopleei_getovn%notfound then
2183: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2184: close c_peopleei_getovn;
2185: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2186: hr_utility.raise_error;
2187: else
2188: close c_peopleei_getovn;
2189: end if;
2190: pe_pei_upd.upd(
2248: p_pei_information29 => p_peopleei_data.pei_information29 ,
2249: p_pei_information30 => p_peopleei_data.pei_information30 ,
2250: p_object_version_number => p_peopleei_data.object_version_number
2251: );
2252: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2253:
2254: Exception
2255: When Others then
2256: -- RESET In/Out params and SET Out Params
2254: Exception
2255: When Others then
2256: -- RESET In/Out params and SET Out Params
2257: p_peopleei_data:=l_peopleei_data;
2258: hr_utility.set_location('Leaving ' || l_proc,25);
2259: Raise;
2260:
2261: End;
2262:
2302: l_asgnei_data per_assignment_extra_info%rowtype;
2303: l_proc varchar2(30):='Correct_asgnei_Row';
2304:
2305: Begin
2306: hr_utility.set_location( 'Entering : ' || l_proc, 20);
2307: -- Initialise Local variables
2308: l_asgnei_data := p_asgnei_data;
2309: --
2310: open c_asgnei_getovn( p_asgnei_data.assignment_extra_info_id );
2311: Fetch c_asgnei_getovn into p_asgnei_data.object_version_number;
2312: if c_asgnei_getovn%notfound then
2313: close c_asgnei_getovn;
2314: -- raise error
2315: hr_utility.set_message(8301, 'GHR_38371_ASGNEI_OVN_NFND');
2316: hr_utility.raise_error;
2317: else
2318: close c_asgnei_getovn;
2319: end if;
2312: if c_asgnei_getovn%notfound then
2313: close c_asgnei_getovn;
2314: -- raise error
2315: hr_utility.set_message(8301, 'GHR_38371_ASGNEI_OVN_NFND');
2316: hr_utility.raise_error;
2317: else
2318: close c_asgnei_getovn;
2319: end if;
2320: pe_aei_upd.upd(
2376: p_aei_information29 => p_asgnei_data.aei_information29 ,
2377: p_aei_information30 => p_asgnei_data.aei_information30 ,
2378: p_object_version_number => p_asgnei_data.object_version_number
2379: );
2380: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2381: Exception
2382: When Others then
2383: -- RESET In/Out Params and SET Out params
2384: p_asgnei_data:=l_asgnei_data;
2381: Exception
2382: When Others then
2383: -- RESET In/Out Params and SET Out params
2384: p_asgnei_data:=l_asgnei_data;
2385: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2386: Raise;
2387:
2388: End;
2389:
2428: l_posnei_data per_position_extra_info%rowtype;
2429: l_proc varchar2(30):='Correct_posnei_Row';
2430:
2431: Begin
2432: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2433: -- Initialise Local Variables
2434: l_posnei_data := p_posnei_data;
2435: --
2436: open c_posnei_getovn( p_posnei_data.position_extra_info_id );
2437: Fetch c_posnei_getovn into p_posnei_data.object_version_number;
2438: if c_posnei_getovn%notfound then
2439: close c_posnei_getovn;
2440: -- raise error
2441: hr_utility.set_message(8301, 'GHR_38372_POSNEI_OVN_NFND');
2442: hr_utility.raise_error;
2443: else
2444: close c_posnei_getovn;
2445: end if;
2438: if c_posnei_getovn%notfound then
2439: close c_posnei_getovn;
2440: -- raise error
2441: hr_utility.set_message(8301, 'GHR_38372_POSNEI_OVN_NFND');
2442: hr_utility.raise_error;
2443: else
2444: close c_posnei_getovn;
2445: end if;
2446:
2506: p_poei_information30 => p_posnei_data.poei_information30 ,
2507: p_object_version_number => p_posnei_data.object_version_number
2508: );
2509:
2510: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2511:
2512: Exception
2513: When Others then
2514: -- RESET In/Out params and SET Out params
2512: Exception
2513: When Others then
2514: -- RESET In/Out params and SET Out params
2515: p_posnei_data:=l_posnei_data;
2516: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2517: Raise;
2518: End Correct_posnei_Row;
2519:
2520: -- ---------------------------------------------------------------------------
2564: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2565: l_date2 hr_all_positions_f.effective_start_date%type;
2566:
2567: Begin
2568: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2569: --Initialise Local Variables
2570: l_posn_data := p_posn_data;
2571: --
2572:
2576: Fetch c_posn_getovn into p_posn_data.object_version_number;
2577: if c_posn_getovn%notfound then
2578: close c_posn_getovn;
2579: -- raise error
2580: hr_utility.set_message(8301, 'GHR_38492_POSN_OVN_NFND');
2581: hr_utility.raise_error;
2582: else
2583: close c_posn_getovn;
2584: end if;
2577: if c_posn_getovn%notfound then
2578: close c_posn_getovn;
2579: -- raise error
2580: hr_utility.set_message(8301, 'GHR_38492_POSN_OVN_NFND');
2581: hr_utility.raise_error;
2582: else
2583: close c_posn_getovn;
2584: end if;
2585: l_date2 := p_posn_data.effective_start_date;
2722: -- l_position_data_rec.effective_date := p_posn_data.effective_start_date;
2723: -- Changes made by Venkat 30-JAN-2003 for No Copy Changes
2724: -- Assigning l_date1 instaed of p_posn_data.effective_start date because of nocopy changes
2725: l_position_data_rec.effective_date := l_date2;
2726: hr_utility.set_location(l_proc || 'change in data element-pos ' || p_posn_data.job_id,15);
2727:
2728: ghr_sf52_pos_update.update_position_info
2729: (p_pos_data_rec => l_position_data_rec
2730: );
2728: ghr_sf52_pos_update.update_position_info
2729: (p_pos_data_rec => l_position_data_rec
2730: );
2731:
2732: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2733: Exception
2734: When Others then
2735: -- RESET In/Out Params and SET Out Params
2736: p_posn_data:=l_posn_data;
2733: Exception
2734: When Others then
2735: -- RESET In/Out Params and SET Out Params
2736: p_posn_data:=l_posn_data;
2737: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2738: Raise;
2739:
2740: End Correct_posn_Row;
2741:
2780: l_session_var ghr_history_api.g_session_var_type;
2781: l_proc varchar2(30):='correct_addresses_row';
2782:
2783: Begin
2784: hr_utility.set_location(' entering : ' || l_proc, 10);
2785: --Initialise Local Variables
2786: l_addr_data := p_addr_data;
2787: --
2788: ghr_history_api.get_g_session_var( l_session_var);
2785: --Initialise Local Variables
2786: l_addr_data := p_addr_data;
2787: --
2788: ghr_history_api.get_g_session_var( l_session_var);
2789: hr_utility.set_location(l_proc, 20);
2790:
2791: open c_addr;
2792: fetch c_addr into p_addr_data.object_version_number;
2793: if c_addr%notfound then
2790:
2791: open c_addr;
2792: fetch c_addr into p_addr_data.object_version_number;
2793: if c_addr%notfound then
2794: hr_utility.set_location(l_proc, 21);
2795: close c_addr;
2796: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2797: hr_utility.raise_error;
2798: end if;
2792: fetch c_addr into p_addr_data.object_version_number;
2793: if c_addr%notfound then
2794: hr_utility.set_location(l_proc, 21);
2795: close c_addr;
2796: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2797: hr_utility.raise_error;
2798: end if;
2799: close c_addr;
2800: hr_utility.set_location(l_proc, 30);
2793: if c_addr%notfound then
2794: hr_utility.set_location(l_proc, 21);
2795: close c_addr;
2796: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2797: hr_utility.raise_error;
2798: end if;
2799: close c_addr;
2800: hr_utility.set_location(l_proc, 30);
2801:
2796: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2797: hr_utility.raise_error;
2798: end if;
2799: close c_addr;
2800: hr_utility.set_location(l_proc, 30);
2801:
2802: per_add_upd.upd(
2803: p_address_id => p_addr_data.address_id ,
2804: p_date_from => p_addr_data.date_from ,
2818: p_telephone_number_3 => p_addr_data.telephone_number_3 ,
2819: p_town_or_city => p_addr_data.town_or_city ,
2820: p_object_version_number => p_addr_data.object_version_number ,
2821: p_effective_date => l_session_var.date_effective);
2822: hr_utility.set_location(' leaving : ' || l_proc, 40);
2823:
2824: Exception
2825: When Others then
2826: --RESET In/Out Params and SET Out Params
2824: Exception
2825: When Others then
2826: --RESET In/Out Params and SET Out Params
2827: p_addr_data:=l_addr_data;
2828: hr_utility.set_location( 'Leaving : ' || l_proc, 45);
2829: Raise;
2830:
2831: End correct_addresses_row;
2832:
2871: l_session_var ghr_history_api.g_session_var_type;
2872: l_proc varchar2(30):='correct_perana_row';
2873:
2874: Begin
2875: hr_utility.set_location(' entering : ' || l_proc, 10);
2876: -- Initialise Local Variables
2877: l_perana_data := p_perana_data;
2878: --
2879:
2877: l_perana_data := p_perana_data;
2878: --
2879:
2880: ghr_history_api.get_g_session_var( l_session_var);
2881: hr_utility.set_location(l_proc, 20);
2882:
2883: open c_perana;
2884: fetch c_perana into p_perana_data.object_version_number;
2885: if c_perana%notfound then
2882:
2883: open c_perana;
2884: fetch c_perana into p_perana_data.object_version_number;
2885: if c_perana%notfound then
2886: hr_utility.set_location(l_proc, 21);
2887: close c_perana;
2888: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2889: hr_utility.raise_error;
2890: end if;
2884: fetch c_perana into p_perana_data.object_version_number;
2885: if c_perana%notfound then
2886: hr_utility.set_location(l_proc, 21);
2887: close c_perana;
2888: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2889: hr_utility.raise_error;
2890: end if;
2891: close c_perana;
2892: hr_utility.set_location(l_proc, 30);
2885: if c_perana%notfound then
2886: hr_utility.set_location(l_proc, 21);
2887: close c_perana;
2888: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2889: hr_utility.raise_error;
2890: end if;
2891: close c_perana;
2892: hr_utility.set_location(l_proc, 30);
2893:
2888: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2889: hr_utility.raise_error;
2890: end if;
2891: close c_perana;
2892: hr_utility.set_location(l_proc, 30);
2893:
2894: per_pea_upd.upd(
2895: p_person_analysis_id => p_perana_data.person_analysis_id,
2896: p_analysis_criteria_id => p_perana_data.analysis_criteria_id,
2921: p_attribute20 => p_perana_data.attribute20,
2922: p_object_version_number => p_perana_data.object_version_number
2923: );
2924:
2925: hr_utility.set_location(' leaving : ' || l_proc, 40);
2926:
2927: Exception
2928: When Others then
2929: --RESET In/Out Params and SET Out Params
2927: Exception
2928: When Others then
2929: --RESET In/Out Params and SET Out Params
2930: p_perana_data:=l_perana_data;
2931: hr_utility.set_location( 'Leaving : ' || l_proc, 45);
2932: Raise;
2933:
2934: End correct_perana_row;
2935:
2978: l_true_false ghr_history_cascade.condition_rg_type;
2979: l_proc varchar2(72) := 'cascade_change';
2980:
2981: Begin
2982: hr_utility.set_location('Entering ' || l_proc,5);
2983: --Initialise Local variables
2984: l_apply_record:=p_apply_record;
2985: l_true_false:=p_true_false;
2986: --
2988: -- Information1, Information2 and Information3 will not be cascaded as it is reserved for
2989: -- Table Primary Key, effective_start_date and Effective_end_date respectively
2990:
2991: -- Bug 1161542
2992: /* hr_utility.set_location(l_proc,10);
2993: cascade_field_value
2994: (p_pre_field => p_pre_record.information4,
2995: p_post_field => p_post_record.information4,
2996: p_apply_field => p_apply_record.information4,
2996: p_apply_field => p_apply_record.information4,
2997: p_result => p_true_false(4)
2998: );
2999:
3000: hr_utility.set_location(l_proc,15);
3001: cascade_field_value
3002: (p_pre_field => p_pre_record.information5,
3003: p_post_field => p_post_record.information5,
3004: p_apply_field => p_apply_record.information5,
3004: p_apply_field => p_apply_record.information5,
3005: p_result => p_true_false(5)
3006: );*/ -- Bug 1161542
3007:
3008: hr_utility.set_location(l_proc,20);
3009:
3010: --BUG # 14625196 Added as lastname need to be updated and last name is stored
3011: -- in information6 of GHR_PA_HISTORY. with out this last name not getting
3012: -- updated in PER_ALL_PEOPLE_F
3019: p_result => p_true_false(6)
3020: );
3021: END IF;
3022:
3023: hr_utility.set_location(l_proc,25);
3024: ---Added for Bug 3413335
3025: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3026: hr_utility.set_location(l_proc,34);
3027: cascade_field_value
3022:
3023: hr_utility.set_location(l_proc,25);
3024: ---Added for Bug 3413335
3025: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3026: hr_utility.set_location(l_proc,34);
3027: cascade_field_value
3028: (p_pre_field => p_pre_record.information7,
3029: p_post_field => p_post_record.information7,
3030: p_apply_field => p_apply_record.information7,
3031: p_result => p_true_false(7)
3032: );
3033: ELSE
3034: IF p_post_record.information11 is not null THEN
3035: hr_utility.set_location(l_proc,36);
3036: cascade_field_value
3037: (p_pre_field => p_pre_record.information7,
3038: p_post_field => p_post_record.information7,
3039: p_apply_field => p_apply_record.information7,
3041: );
3042: END IF;
3043: END IF;
3044:
3045: hr_utility.set_location(l_proc,30);
3046: ---Added for Bug 3413335
3047: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3048: hr_utility.set_location(l_proc,34);
3049: cascade_field_value
3044:
3045: hr_utility.set_location(l_proc,30);
3046: ---Added for Bug 3413335
3047: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3048: hr_utility.set_location(l_proc,34);
3049: cascade_field_value
3050: (p_pre_field => p_pre_record.information8,
3051: p_post_field => p_post_record.information8,
3052: p_apply_field => p_apply_record.information8,
3053: p_result => p_true_false(8)
3054: );
3055: ELSE
3056: IF p_post_record.information11 is not null THEN
3057: hr_utility.set_location(l_proc,36);
3058: cascade_field_value
3059: (p_pre_field => p_pre_record.information8,
3060: p_post_field => p_post_record.information8,
3061: p_apply_field => p_apply_record.information8,
3086: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3087: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3088: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3089: then
3090: hr_utility.set_location(l_proc,20);
3091: p_apply_record.information9 := p_post_record.information9;
3092: p_apply_record.information10 := p_post_record.information10;
3093: p_apply_record.information11 := p_post_record.information11;
3094: p_apply_record.information14 := p_post_record.information14;
3109: p_true_false(23) := FALSE;
3110: end if;
3111: end if;
3112: else
3113: hr_utility.set_location(l_proc,35);
3114: ---Added for Bug 3413335
3115: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3116: hr_utility.set_location(l_proc,34);
3117: cascade_field_value
3112: else
3113: hr_utility.set_location(l_proc,35);
3114: ---Added for Bug 3413335
3115: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3116: hr_utility.set_location(l_proc,34);
3117: cascade_field_value
3118: (p_pre_field => p_pre_record.information9,
3119: p_post_field => p_post_record.information9,
3120: p_apply_field => p_apply_record.information9,
3121: p_result => p_true_false(9)
3122: );
3123: ELSE
3124: IF p_post_record.information11 is not null THEN
3125: hr_utility.set_location(l_proc,36);
3126: cascade_field_value
3127: (p_pre_field => p_pre_record.information9,
3128: p_post_field => p_post_record.information9,
3129: p_apply_field => p_apply_record.information9,
3131: );
3132: END IF;
3133: END IF;
3134:
3135: hr_utility.set_location(l_proc,40);
3136: ---Added for Bug 3413335
3137: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3138: hr_utility.set_location(l_proc,44);
3139: cascade_field_value
3134:
3135: hr_utility.set_location(l_proc,40);
3136: ---Added for Bug 3413335
3137: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3138: hr_utility.set_location(l_proc,44);
3139: cascade_field_value
3140: (p_pre_field => p_pre_record.information10,
3141: p_post_field => p_post_record.information10,
3142: p_apply_field => p_apply_record.information10,
3143: p_result => p_true_false(10)
3144: );
3145: ELSE
3146: IF p_post_record.information11 is not null THEN
3147: hr_utility.set_location(l_proc,46);
3148: cascade_field_value
3149: (p_pre_field => p_pre_record.information10,
3150: p_post_field => p_post_record.information10,
3151: p_apply_field => p_apply_record.information10,
3155: END IF;
3156:
3157: -- Start processing for Bug 3413335
3158: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3159: hr_utility.set_location(l_proc,45);
3160: cascade_field_value
3161: (p_pre_field => p_pre_record.information11,
3162: p_post_field => p_post_record.information11,
3163: p_apply_field => p_apply_record.information11,
3164: p_result => p_true_false(11)
3165: );
3166: ELSE
3167: IF p_post_record.information11 is not null THEN
3168: hr_utility.set_location(l_proc,45);
3169: cascade_field_value
3170: (p_pre_field => p_pre_record.information11,
3171: p_post_field => p_post_record.information11,
3172: p_apply_field => p_apply_record.information11,
3175: END IF;
3176: END IF;
3177: -- End processing for Bug 3413335
3178:
3179: hr_utility.set_location(l_proc,60);
3180: cascade_field_value
3181: (p_pre_field => p_pre_record.information14,
3182: p_post_field => p_post_record.information14,
3183: p_apply_field => p_apply_record.information14,
3183: p_apply_field => p_apply_record.information14,
3184: p_result => p_true_false(14)
3185: );
3186:
3187: hr_utility.set_location(l_proc,70);
3188: cascade_field_value
3189: (p_pre_field => p_pre_record.information16,
3190: p_post_field => p_post_record.information16,
3191: p_apply_field => p_apply_record.information16,
3191: p_apply_field => p_apply_record.information16,
3192: p_result => p_true_false(16)
3193: );
3194:
3195: hr_utility.set_location(l_proc,75);
3196: cascade_field_value
3197: (p_pre_field => p_pre_record.information17,
3198: p_post_field => p_post_record.information17,
3199: p_apply_field => p_apply_record.information17,
3199: p_apply_field => p_apply_record.information17,
3200: p_result => p_true_false(17)
3201: );
3202:
3203: hr_utility.set_location(l_proc,80);
3204: cascade_field_value
3205: (p_pre_field => p_pre_record.information18,
3206: p_post_field => p_post_record.information18,
3207: p_apply_field => p_apply_record.information18,
3207: p_apply_field => p_apply_record.information18,
3208: p_result => p_true_false(18)
3209: );
3210:
3211: hr_utility.set_location(l_proc,85);
3212: cascade_field_value
3213: (p_pre_field => p_pre_record.information19,
3214: p_post_field => p_post_record.information19,
3215: p_apply_field => p_apply_record.information19,
3215: p_apply_field => p_apply_record.information19,
3216: p_result => p_true_false(19)
3217: );
3218:
3219: hr_utility.set_location(l_proc,101);
3220: cascade_field_value
3221: (p_pre_field => p_pre_record.information23,
3222: p_post_field => p_post_record.information23,
3223: p_apply_field => p_apply_record.information23,
3223: p_apply_field => p_apply_record.information23,
3224: p_result => p_true_false(23)
3225: );
3226: end if;
3227: hr_utility.set_location(l_proc,50);
3228: cascade_field_value
3229: (p_pre_field => p_pre_record.information12,
3230: p_post_field => p_post_record.information12,
3231: p_apply_field => p_apply_record.information12,
3231: p_apply_field => p_apply_record.information12,
3232: p_result => p_true_false(12)
3233: );
3234:
3235: hr_utility.set_location(l_proc,55);
3236: cascade_field_value
3237: (p_pre_field => p_pre_record.information13,
3238: p_post_field => p_post_record.information13,
3239: p_apply_field => p_apply_record.information13,
3239: p_apply_field => p_apply_record.information13,
3240: p_result => p_true_false(13)
3241: );
3242:
3243: hr_utility.set_location(l_proc,65);
3244: cascade_field_value
3245: (p_pre_field => p_pre_record.information15,
3246: p_post_field => p_post_record.information15,
3247: p_apply_field => p_apply_record.information15,
3247: p_apply_field => p_apply_record.information15,
3248: p_result => p_true_false(15)
3249: );
3250:
3251: hr_utility.set_location(l_proc,90);
3252: cascade_field_value
3253: (p_pre_field => p_pre_record.information20,
3254: p_post_field => p_post_record.information20,
3255: p_apply_field => p_apply_record.information20,
3255: p_apply_field => p_apply_record.information20,
3256: p_result => p_true_false(20)
3257: );
3258:
3259: hr_utility.set_location(l_proc,95);
3260: cascade_field_value
3261: (p_pre_field => p_pre_record.information21,
3262: p_post_field => p_post_record.information21,
3263: p_apply_field => p_apply_record.information21,
3263: p_apply_field => p_apply_record.information21,
3264: p_result => p_true_false(21)
3265: );
3266:
3267: hr_utility.set_location(l_proc,100);
3268: cascade_field_value
3269: (p_pre_field => p_pre_record.information22,
3270: p_post_field => p_post_record.information22,
3271: p_apply_field => p_apply_record.information22,
3271: p_apply_field => p_apply_record.information22,
3272: p_result => p_true_false(22)
3273: );
3274:
3275: hr_utility.set_location(l_proc,102);
3276: cascade_field_value
3277: (p_pre_field => p_pre_record.information24,
3278: p_post_field => p_post_record.information24,
3279: p_apply_field => p_apply_record.information24,
3279: p_apply_field => p_apply_record.information24,
3280: p_result => p_true_false(24)
3281: );
3282:
3283: hr_utility.set_location(l_proc,103);
3284: cascade_field_value
3285: (p_pre_field => p_pre_record.information25,
3286: p_post_field => p_post_record.information25,
3287: p_apply_field => p_apply_record.information25,
3287: p_apply_field => p_apply_record.information25,
3288: p_result => p_true_false(25)
3289: );
3290:
3291: hr_utility.set_location(l_proc,104);
3292: cascade_field_value
3293: (p_pre_field => p_pre_record.information26,
3294: p_post_field => p_post_record.information26,
3295: p_apply_field => p_apply_record.information26,
3295: p_apply_field => p_apply_record.information26,
3296: p_result => p_true_false(26)
3297: );
3298:
3299: hr_utility.set_location(l_proc,105);
3300: cascade_field_value
3301: (p_pre_field => p_pre_record.information27,
3302: p_post_field => p_post_record.information27,
3303: p_apply_field => p_apply_record.information27,
3303: p_apply_field => p_apply_record.information27,
3304: p_result => p_true_false(27)
3305: );
3306:
3307: hr_utility.set_location(l_proc,106);
3308: cascade_field_value
3309: (p_pre_field => p_pre_record.information28,
3310: p_post_field => p_post_record.information28,
3311: p_apply_field => p_apply_record.information28,
3311: p_apply_field => p_apply_record.information28,
3312: p_result => p_true_false(28)
3313: );
3314:
3315: hr_utility.set_location(l_proc,107);
3316: cascade_field_value
3317: (p_pre_field => p_pre_record.information29,
3318: p_post_field => p_post_record.information29,
3319: p_apply_field => p_apply_record.information29,
3319: p_apply_field => p_apply_record.information29,
3320: p_result => p_true_false(29)
3321: );
3322:
3323: hr_utility.set_location(l_proc,108);
3324: cascade_field_value
3325: (p_pre_field => p_pre_record.information30,
3326: p_post_field => p_post_record.information30,
3327: p_apply_field => p_apply_record.information30,
3327: p_apply_field => p_apply_record.information30,
3328: p_result => p_true_false(30)
3329: );
3330:
3331: hr_utility.set_location(l_proc,109);
3332: cascade_field_value
3333: (p_pre_field => p_pre_record.information31,
3334: p_post_field => p_post_record.information31,
3335: p_apply_field => p_apply_record.information31,
3335: p_apply_field => p_apply_record.information31,
3336: p_result => p_true_false(31)
3337: );
3338:
3339: hr_utility.set_location(l_proc,110);
3340: cascade_field_value
3341: (p_pre_field => p_pre_record.information32,
3342: p_post_field => p_post_record.information32,
3343: p_apply_field => p_apply_record.information32,
3343: p_apply_field => p_apply_record.information32,
3344: p_result => p_true_false(32)
3345: );
3346:
3347: hr_utility.set_location(l_proc,111);
3348: cascade_field_value
3349: (p_pre_field => p_pre_record.information33,
3350: p_post_field => p_post_record.information33,
3351: p_apply_field => p_apply_record.information33,
3351: p_apply_field => p_apply_record.information33,
3352: p_result => p_true_false(33)
3353: );
3354:
3355: hr_utility.set_location(l_proc,112);
3356: cascade_field_value
3357: (p_pre_field => p_pre_record.information34,
3358: p_post_field => p_post_record.information34,
3359: p_apply_field => p_apply_record.information34,
3359: p_apply_field => p_apply_record.information34,
3360: p_result => p_true_false(34)
3361: );
3362:
3363: hr_utility.set_location(l_proc,113);
3364: cascade_field_value
3365: (p_pre_field => p_pre_record.information35,
3366: p_post_field => p_post_record.information35,
3367: p_apply_field => p_apply_record.information35,
3367: p_apply_field => p_apply_record.information35,
3368: p_result => p_true_false(35)
3369: );
3370:
3371: hr_utility.set_location(l_proc,114);
3372: cascade_field_value
3373: (p_pre_field => p_pre_record.information36,
3374: p_post_field => p_post_record.information36,
3375: p_apply_field => p_apply_record.information36,
3375: p_apply_field => p_apply_record.information36,
3376: p_result => p_true_false(36)
3377: );
3378:
3379: hr_utility.set_location(l_proc,115);
3380: cascade_field_value
3381: (p_pre_field => p_pre_record.information37,
3382: p_post_field => p_post_record.information37,
3383: p_apply_field => p_apply_record.information37,
3383: p_apply_field => p_apply_record.information37,
3384: p_result => p_true_false(37)
3385: );
3386:
3387: hr_utility.set_location(l_proc,116);
3388: cascade_field_value
3389: (p_pre_field => p_pre_record.information38,
3390: p_post_field => p_post_record.information38,
3391: p_apply_field => p_apply_record.information38,
3391: p_apply_field => p_apply_record.information38,
3392: p_result => p_true_false(38)
3393: );
3394:
3395: hr_utility.set_location(l_proc,117);
3396: cascade_field_value
3397: (p_pre_field => p_pre_record.information39,
3398: p_post_field => p_post_record.information39,
3399: p_apply_field => p_apply_record.information39,
3399: p_apply_field => p_apply_record.information39,
3400: p_result => p_true_false(39)
3401: );
3402:
3403: hr_utility.set_location(l_proc,118);
3404: cascade_field_value
3405: (p_pre_field => p_pre_record.information40,
3406: p_post_field => p_post_record.information40,
3407: p_apply_field => p_apply_record.information40,
3407: p_apply_field => p_apply_record.information40,
3408: p_result => p_true_false(40)
3409: );
3410:
3411: hr_utility.set_location(l_proc,119);
3412: cascade_field_value
3413: (p_pre_field => p_pre_record.information41,
3414: p_post_field => p_post_record.information41,
3415: p_apply_field => p_apply_record.information41,
3415: p_apply_field => p_apply_record.information41,
3416: p_result => p_true_false(41)
3417: );
3418:
3419: hr_utility.set_location(l_proc,120);
3420: cascade_field_value
3421: (p_pre_field => p_pre_record.information42,
3422: p_post_field => p_post_record.information42,
3423: p_apply_field => p_apply_record.information42,
3423: p_apply_field => p_apply_record.information42,
3424: p_result => p_true_false(42)
3425: );
3426:
3427: hr_utility.set_location(l_proc,121);
3428: cascade_field_value
3429: (p_pre_field => p_pre_record.information43,
3430: p_post_field => p_post_record.information43,
3431: p_apply_field => p_apply_record.information43,
3431: p_apply_field => p_apply_record.information43,
3432: p_result => p_true_false(43)
3433: );
3434:
3435: hr_utility.set_location(l_proc,122);
3436: cascade_field_value
3437: (p_pre_field => p_pre_record.information44,
3438: p_post_field => p_post_record.information44,
3439: p_apply_field => p_apply_record.information44,
3439: p_apply_field => p_apply_record.information44,
3440: p_result => p_true_false(44)
3441: );
3442:
3443: hr_utility.set_location(l_proc,123);
3444: cascade_field_value
3445: (p_pre_field => p_pre_record.information45,
3446: p_post_field => p_post_record.information45,
3447: p_apply_field => p_apply_record.information45,
3447: p_apply_field => p_apply_record.information45,
3448: p_result => p_true_false(45)
3449: );
3450:
3451: hr_utility.set_location(l_proc,124);
3452: cascade_field_value
3453: (p_pre_field => p_pre_record.information46,
3454: p_post_field => p_post_record.information46,
3455: p_apply_field => p_apply_record.information46,
3455: p_apply_field => p_apply_record.information46,
3456: p_result => p_true_false(46)
3457: );
3458:
3459: hr_utility.set_location(l_proc,125);
3460: cascade_field_value
3461: (p_pre_field => p_pre_record.information47,
3462: p_post_field => p_post_record.information47,
3463: p_apply_field => p_apply_record.information47,
3463: p_apply_field => p_apply_record.information47,
3464: p_result => p_true_false(47)
3465: );
3466:
3467: hr_utility.set_location(l_proc,126);
3468: cascade_field_value
3469: (p_pre_field => p_pre_record.information48,
3470: p_post_field => p_post_record.information48,
3471: p_apply_field => p_apply_record.information48,
3471: p_apply_field => p_apply_record.information48,
3472: p_result => p_true_false(48)
3473: );
3474:
3475: hr_utility.set_location(l_proc,127);
3476: cascade_field_value
3477: (p_pre_field => p_pre_record.information49,
3478: p_post_field => p_post_record.information49,
3479: p_apply_field => p_apply_record.information49,
3479: p_apply_field => p_apply_record.information49,
3480: p_result => p_true_false(49)
3481: );
3482:
3483: hr_utility.set_location(l_proc,128);
3484: cascade_field_value
3485: (p_pre_field => p_pre_record.information50,
3486: p_post_field => p_post_record.information50,
3487: p_apply_field => p_apply_record.information50,
3487: p_apply_field => p_apply_record.information50,
3488: p_result => p_true_false(50)
3489: );
3490:
3491: hr_utility.set_location(l_proc,129);
3492: cascade_field_value
3493: (p_pre_field => p_pre_record.information51,
3494: p_post_field => p_post_record.information51,
3495: p_apply_field => p_apply_record.information51,
3495: p_apply_field => p_apply_record.information51,
3496: p_result => p_true_false(51)
3497: );
3498:
3499: hr_utility.set_location(l_proc,130);
3500: cascade_field_value
3501: (p_pre_field => p_pre_record.information52,
3502: p_post_field => p_post_record.information52,
3503: p_apply_field => p_apply_record.information52,
3503: p_apply_field => p_apply_record.information52,
3504: p_result => p_true_false(52)
3505: );
3506:
3507: hr_utility.set_location(l_proc,131);
3508: cascade_field_value
3509: (p_pre_field => p_pre_record.information53,
3510: p_post_field => p_post_record.information53,
3511: p_apply_field => p_apply_record.information53,
3511: p_apply_field => p_apply_record.information53,
3512: p_result => p_true_false(53)
3513: );
3514:
3515: hr_utility.set_location(l_proc,132);
3516: cascade_field_value
3517: (p_pre_field => p_pre_record.information54,
3518: p_post_field => p_post_record.information54,
3519: p_apply_field => p_apply_record.information54,
3519: p_apply_field => p_apply_record.information54,
3520: p_result => p_true_false(54)
3521: );
3522:
3523: hr_utility.set_location(l_proc,133);
3524: cascade_field_value
3525: (p_pre_field => p_pre_record.information55,
3526: p_post_field => p_post_record.information55,
3527: p_apply_field => p_apply_record.information55,
3527: p_apply_field => p_apply_record.information55,
3528: p_result => p_true_false(55)
3529: );
3530:
3531: hr_utility.set_location(l_proc,134);
3532: cascade_field_value
3533: (p_pre_field => p_pre_record.information56,
3534: p_post_field => p_post_record.information56,
3535: p_apply_field => p_apply_record.information56,
3535: p_apply_field => p_apply_record.information56,
3536: p_result => p_true_false(56)
3537: );
3538:
3539: hr_utility.set_location(l_proc,135);
3540: cascade_field_value
3541: (p_pre_field => p_pre_record.information57,
3542: p_post_field => p_post_record.information57,
3543: p_apply_field => p_apply_record.information57,
3543: p_apply_field => p_apply_record.information57,
3544: p_result => p_true_false(57)
3545: );
3546:
3547: hr_utility.set_location(l_proc,136);
3548: cascade_field_value
3549: (p_pre_field => p_pre_record.information58,
3550: p_post_field => p_post_record.information58,
3551: p_apply_field => p_apply_record.information58,
3551: p_apply_field => p_apply_record.information58,
3552: p_result => p_true_false(58)
3553: );
3554:
3555: hr_utility.set_location(l_proc,137);
3556: cascade_field_value
3557: (p_pre_field => p_pre_record.information59,
3558: p_post_field => p_post_record.information59,
3559: p_apply_field => p_apply_record.information59,
3559: p_apply_field => p_apply_record.information59,
3560: p_result => p_true_false(59)
3561: );
3562:
3563: hr_utility.set_location(l_proc,138);
3564: cascade_field_value
3565: (p_pre_field => p_pre_record.information60,
3566: p_post_field => p_post_record.information60,
3567: p_apply_field => p_apply_record.information60,
3567: p_apply_field => p_apply_record.information60,
3568: p_result => p_true_false(60)
3569: );
3570:
3571: hr_utility.set_location(l_proc,139);
3572: cascade_field_value
3573: (p_pre_field => p_pre_record.information61,
3574: p_post_field => p_post_record.information61,
3575: p_apply_field => p_apply_record.information61,
3575: p_apply_field => p_apply_record.information61,
3576: p_result => p_true_false(61)
3577: );
3578:
3579: hr_utility.set_location(l_proc,140);
3580: cascade_field_value
3581: (p_pre_field => p_pre_record.information62,
3582: p_post_field => p_post_record.information62,
3583: p_apply_field => p_apply_record.information62,
3583: p_apply_field => p_apply_record.information62,
3584: p_result => p_true_false(62)
3585: );
3586:
3587: hr_utility.set_location(l_proc,141);
3588: cascade_field_value
3589: (p_pre_field => p_pre_record.information63,
3590: p_post_field => p_post_record.information63,
3591: p_apply_field => p_apply_record.information63,
3591: p_apply_field => p_apply_record.information63,
3592: p_result => p_true_false(63)
3593: );
3594:
3595: hr_utility.set_location(l_proc,142);
3596: cascade_field_value
3597: (p_pre_field => p_pre_record.information64,
3598: p_post_field => p_post_record.information64,
3599: p_apply_field => p_apply_record.information64,
3599: p_apply_field => p_apply_record.information64,
3600: p_result => p_true_false(64)
3601: );
3602:
3603: hr_utility.set_location(l_proc,143);
3604: cascade_field_value
3605: (p_pre_field => p_pre_record.information65,
3606: p_post_field => p_post_record.information65,
3607: p_apply_field => p_apply_record.information65,
3607: p_apply_field => p_apply_record.information65,
3608: p_result => p_true_false(65)
3609: );
3610:
3611: hr_utility.set_location(l_proc,144);
3612: cascade_field_value
3613: (p_pre_field => p_pre_record.information66,
3614: p_post_field => p_post_record.information66,
3615: p_apply_field => p_apply_record.information66,
3615: p_apply_field => p_apply_record.information66,
3616: p_result => p_true_false(66)
3617: );
3618:
3619: hr_utility.set_location(l_proc,145);
3620: cascade_field_value
3621: (p_pre_field => p_pre_record.information67,
3622: p_post_field => p_post_record.information67,
3623: p_apply_field => p_apply_record.information67,
3623: p_apply_field => p_apply_record.information67,
3624: p_result => p_true_false(67)
3625: );
3626:
3627: hr_utility.set_location(l_proc,146);
3628: cascade_field_value
3629: (p_pre_field => p_pre_record.information68,
3630: p_post_field => p_post_record.information68,
3631: p_apply_field => p_apply_record.information68,
3631: p_apply_field => p_apply_record.information68,
3632: p_result => p_true_false(68)
3633: );
3634:
3635: hr_utility.set_location(l_proc,147);
3636: cascade_field_value
3637: (p_pre_field => p_pre_record.information69,
3638: p_post_field => p_post_record.information69,
3639: p_apply_field => p_apply_record.information69,
3639: p_apply_field => p_apply_record.information69,
3640: p_result => p_true_false(69)
3641: );
3642:
3643: hr_utility.set_location(l_proc,148);
3644: cascade_field_value
3645: (p_pre_field => p_pre_record.information70,
3646: p_post_field => p_post_record.information70,
3647: p_apply_field => p_apply_record.information70,
3647: p_apply_field => p_apply_record.information70,
3648: p_result => p_true_false(70)
3649: );
3650:
3651: hr_utility.set_location(l_proc,149);
3652: cascade_field_value
3653: (p_pre_field => p_pre_record.information71,
3654: p_post_field => p_post_record.information71,
3655: p_apply_field => p_apply_record.information71,
3655: p_apply_field => p_apply_record.information71,
3656: p_result => p_true_false(71)
3657: );
3658:
3659: hr_utility.set_location(l_proc,150);
3660: cascade_field_value
3661: (p_pre_field => p_pre_record.information72,
3662: p_post_field => p_post_record.information72,
3663: p_apply_field => p_apply_record.information72,
3663: p_apply_field => p_apply_record.information72,
3664: p_result => p_true_false(72)
3665: );
3666:
3667: hr_utility.set_location(l_proc,151);
3668: cascade_field_value
3669: (p_pre_field => p_pre_record.information73,
3670: p_post_field => p_post_record.information73,
3671: p_apply_field => p_apply_record.information73,
3671: p_apply_field => p_apply_record.information73,
3672: p_result => p_true_false(73)
3673: );
3674:
3675: hr_utility.set_location(l_proc,152);
3676: cascade_field_value
3677: (p_pre_field => p_pre_record.information74,
3678: p_post_field => p_post_record.information74,
3679: p_apply_field => p_apply_record.information74,
3679: p_apply_field => p_apply_record.information74,
3680: p_result => p_true_false(74)
3681: );
3682:
3683: hr_utility.set_location(l_proc,153);
3684: cascade_field_value
3685: (p_pre_field => p_pre_record.information75,
3686: p_post_field => p_post_record.information75,
3687: p_apply_field => p_apply_record.information75,
3687: p_apply_field => p_apply_record.information75,
3688: p_result => p_true_false(75)
3689: );
3690:
3691: hr_utility.set_location(l_proc,154);
3692: cascade_field_value
3693: (p_pre_field => p_pre_record.information76,
3694: p_post_field => p_post_record.information76,
3695: p_apply_field => p_apply_record.information76,
3695: p_apply_field => p_apply_record.information76,
3696: p_result => p_true_false(76)
3697: );
3698:
3699: hr_utility.set_location(l_proc,155);
3700: cascade_field_value
3701: (p_pre_field => p_pre_record.information77,
3702: p_post_field => p_post_record.information77,
3703: p_apply_field => p_apply_record.information77,
3703: p_apply_field => p_apply_record.information77,
3704: p_result => p_true_false(77)
3705: );
3706:
3707: hr_utility.set_location(l_proc,156);
3708: cascade_field_value
3709: (p_pre_field => p_pre_record.information78,
3710: p_post_field => p_post_record.information78,
3711: p_apply_field => p_apply_record.information78,
3711: p_apply_field => p_apply_record.information78,
3712: p_result => p_true_false(78)
3713: );
3714:
3715: hr_utility.set_location(l_proc,157);
3716: cascade_field_value
3717: (p_pre_field => p_pre_record.information79,
3718: p_post_field => p_post_record.information79,
3719: p_apply_field => p_apply_record.information79,
3719: p_apply_field => p_apply_record.information79,
3720: p_result => p_true_false(79)
3721: );
3722:
3723: hr_utility.set_location(l_proc,158);
3724: cascade_field_value
3725: (p_pre_field => p_pre_record.information80,
3726: p_post_field => p_post_record.information80,
3727: p_apply_field => p_apply_record.information80,
3727: p_apply_field => p_apply_record.information80,
3728: p_result => p_true_false(80)
3729: );
3730:
3731: hr_utility.set_location(l_proc,159);
3732: cascade_field_value
3733: (p_pre_field => p_pre_record.information81,
3734: p_post_field => p_post_record.information81,
3735: p_apply_field => p_apply_record.information81,
3735: p_apply_field => p_apply_record.information81,
3736: p_result => p_true_false(81)
3737: );
3738:
3739: hr_utility.set_location(l_proc,160);
3740: cascade_field_value
3741: (p_pre_field => p_pre_record.information82,
3742: p_post_field => p_post_record.information82,
3743: p_apply_field => p_apply_record.information82,
3743: p_apply_field => p_apply_record.information82,
3744: p_result => p_true_false(82)
3745: );
3746:
3747: hr_utility.set_location(l_proc,161);
3748: cascade_field_value
3749: (p_pre_field => p_pre_record.information83,
3750: p_post_field => p_post_record.information83,
3751: p_apply_field => p_apply_record.information83,
3751: p_apply_field => p_apply_record.information83,
3752: p_result => p_true_false(83)
3753: );
3754:
3755: hr_utility.set_location(l_proc,162);
3756: cascade_field_value
3757: (p_pre_field => p_pre_record.information84,
3758: p_post_field => p_post_record.information84,
3759: p_apply_field => p_apply_record.information84,
3759: p_apply_field => p_apply_record.information84,
3760: p_result => p_true_false(84)
3761: );
3762:
3763: hr_utility.set_location(l_proc,163);
3764: cascade_field_value
3765: (p_pre_field => p_pre_record.information85,
3766: p_post_field => p_post_record.information85,
3767: p_apply_field => p_apply_record.information85,
3767: p_apply_field => p_apply_record.information85,
3768: p_result => p_true_false(85)
3769: );
3770:
3771: hr_utility.set_location(l_proc,164);
3772: cascade_field_value
3773: (p_pre_field => p_pre_record.information86,
3774: p_post_field => p_post_record.information86,
3775: p_apply_field => p_apply_record.information86,
3775: p_apply_field => p_apply_record.information86,
3776: p_result => p_true_false(86)
3777: );
3778:
3779: hr_utility.set_location(l_proc,165);
3780: cascade_field_value
3781: (p_pre_field => p_pre_record.information87,
3782: p_post_field => p_post_record.information87,
3783: p_apply_field => p_apply_record.information87,
3783: p_apply_field => p_apply_record.information87,
3784: p_result => p_true_false(87)
3785: );
3786:
3787: hr_utility.set_location(l_proc,166);
3788: cascade_field_value
3789: (p_pre_field => p_pre_record.information88,
3790: p_post_field => p_post_record.information88,
3791: p_apply_field => p_apply_record.information88,
3791: p_apply_field => p_apply_record.information88,
3792: p_result => p_true_false(88)
3793: );
3794:
3795: hr_utility.set_location(l_proc,167);
3796: cascade_field_value
3797: (p_pre_field => p_pre_record.information89,
3798: p_post_field => p_post_record.information89,
3799: p_apply_field => p_apply_record.information89,
3799: p_apply_field => p_apply_record.information89,
3800: p_result => p_true_false(89)
3801: );
3802:
3803: hr_utility.set_location(l_proc,168);
3804: cascade_field_value
3805: (p_pre_field => p_pre_record.information90,
3806: p_post_field => p_post_record.information90,
3807: p_apply_field => p_apply_record.information90,
3807: p_apply_field => p_apply_record.information90,
3808: p_result => p_true_false(90)
3809: );
3810:
3811: hr_utility.set_location(l_proc,169);
3812: cascade_field_value
3813: (p_pre_field => p_pre_record.information91,
3814: p_post_field => p_post_record.information91,
3815: p_apply_field => p_apply_record.information91,
3815: p_apply_field => p_apply_record.information91,
3816: p_result => p_true_false(91)
3817: );
3818:
3819: hr_utility.set_location(l_proc,170);
3820: cascade_field_value
3821: (p_pre_field => p_pre_record.information92,
3822: p_post_field => p_post_record.information92,
3823: p_apply_field => p_apply_record.information92,
3823: p_apply_field => p_apply_record.information92,
3824: p_result => p_true_false(92)
3825: );
3826:
3827: hr_utility.set_location(l_proc,171);
3828: cascade_field_value
3829: (p_pre_field => p_pre_record.information93,
3830: p_post_field => p_post_record.information93,
3831: p_apply_field => p_apply_record.information93,
3831: p_apply_field => p_apply_record.information93,
3832: p_result => p_true_false(93)
3833: );
3834:
3835: hr_utility.set_location(l_proc,172);
3836: cascade_field_value
3837: (p_pre_field => p_pre_record.information94,
3838: p_post_field => p_post_record.information94,
3839: p_apply_field => p_apply_record.information94,
3839: p_apply_field => p_apply_record.information94,
3840: p_result => p_true_false(94)
3841: );
3842:
3843: hr_utility.set_location(l_proc,173);
3844: cascade_field_value
3845: (p_pre_field => p_pre_record.information95,
3846: p_post_field => p_post_record.information95,
3847: p_apply_field => p_apply_record.information95,
3847: p_apply_field => p_apply_record.information95,
3848: p_result => p_true_false(95)
3849: );
3850:
3851: hr_utility.set_location(l_proc,174);
3852: cascade_field_value
3853: (p_pre_field => p_pre_record.information96,
3854: p_post_field => p_post_record.information96,
3855: p_apply_field => p_apply_record.information96,
3855: p_apply_field => p_apply_record.information96,
3856: p_result => p_true_false(96)
3857: );
3858:
3859: hr_utility.set_location(l_proc,175);
3860: cascade_field_value
3861: (p_pre_field => p_pre_record.information97,
3862: p_post_field => p_post_record.information97,
3863: p_apply_field => p_apply_record.information97,
3863: p_apply_field => p_apply_record.information97,
3864: p_result => p_true_false(97)
3865: );
3866:
3867: hr_utility.set_location(l_proc,180);
3868: cascade_field_value
3869: (p_pre_field => p_pre_record.information98,
3870: p_post_field => p_post_record.information98,
3871: p_apply_field => p_apply_record.information98,
3871: p_apply_field => p_apply_record.information98,
3872: p_result => p_true_false(98)
3873: );
3874:
3875: hr_utility.set_location(l_proc,181);
3876: cascade_field_value
3877: (p_pre_field => p_pre_record.information99,
3878: p_post_field => p_post_record.information99,
3879: p_apply_field => p_apply_record.information99,
3879: p_apply_field => p_apply_record.information99,
3880: p_result => p_true_false(99)
3881: );
3882:
3883: hr_utility.set_location(l_proc,182);
3884: cascade_field_value
3885: (p_pre_field => p_pre_record.information100,
3886: p_post_field => p_post_record.information100,
3887: p_apply_field => p_apply_record.information100,
3887: p_apply_field => p_apply_record.information100,
3888: p_result => p_true_false(100)
3889: );
3890:
3891: hr_utility.set_location(l_proc,183);
3892: cascade_field_value
3893: (p_pre_field => p_pre_record.information101,
3894: p_post_field => p_post_record.information101,
3895: p_apply_field => p_apply_record.information101,
3894: p_post_field => p_post_record.information101,
3895: p_apply_field => p_apply_record.information101,
3896: p_result => p_true_false(101)
3897: );
3898: hr_utility.set_location('Leaving ' ||l_proc,184);
3899:
3900: -- If information101 is supposed to be cascaded, then information102 thru' information125
3901: -- have to be cascaded as well, because of their dependency on the former.
3902:
3900: -- If information101 is supposed to be cascaded, then information102 thru' information125
3901: -- have to be cascaded as well, because of their dependency on the former.
3902:
3903: If p_true_false(101) then
3904: hr_utility.set_location(l_proc,185);
3905: cascade_dependencies(p_record => p_post_record,
3906: p_apply_record => p_apply_record
3907: );
3908: hr_utility.set_location(l_proc,190);
3904: hr_utility.set_location(l_proc,185);
3905: cascade_dependencies(p_record => p_post_record,
3906: p_apply_record => p_apply_record
3907: );
3908: hr_utility.set_location(l_proc,190);
3909: End if;
3910:
3911: Exception
3912: When Others then
3912: When Others then
3913: --RESET In/Out Params and SET Out Params
3914: p_apply_record:=l_apply_record;
3915: p_true_false:=l_true_false;
3916: hr_utility.set_location('Leaving ' ||l_proc,200);
3917: Raise;
3918:
3919: End cascade_change;
3920:
3975:
3976: -- Proceed only if the column still needs to cascaded. i.e if that column was altered by another SF52, we should
3977: -- stop cascading for that column
3978:
3979: hr_utility.set_location('Entering ' ||l_proc,5);
3980: -- Initialise Local Variables
3981: l_apply_field := p_apply_field;
3982: l_result := p_result;
3983: --
3981: l_apply_field := p_apply_field;
3982: l_result := p_result;
3983: --
3984: If p_result then
3985: hr_utility.set_location(l_proc,10);
3986: -- removed following line in order to allow cascading of null values.
3987: -- If p_post_field is not null then
3988: hr_utility.set_location(l_proc,15);
3989: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3984: If p_result then
3985: hr_utility.set_location(l_proc,10);
3986: -- removed following line in order to allow cascading of null values.
3987: -- If p_post_field is not null then
3988: hr_utility.set_location(l_proc,15);
3989: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3990: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3991: hr_utility.set_location(l_proc,20);
3992: p_apply_field := p_post_field;
3987: -- If p_post_field is not null then
3988: hr_utility.set_location(l_proc,15);
3989: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3990: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3991: hr_utility.set_location(l_proc,20);
3992: p_apply_field := p_post_field;
3993: Else
3994: p_result := FALSE;
3995: end if;
3999: p_result := FALSE;
4000: End if;
4001: */
4002: End if;
4003: hr_utility.set_location('Leaving '|| l_proc,25);
4004: Exception
4005: When Others then
4006: --RESET In/Out Params and SET Out Params
4007: p_apply_field:=l_apply_field;
4005: When Others then
4006: --RESET In/Out Params and SET Out Params
4007: p_apply_field:=l_apply_field;
4008: p_result:=l_result;
4009: hr_utility.set_location('Leaving : '||l_proc,30);
4010: Raise;
4011:
4012: End cascade_field_value;
4013:
4053: Begin
4054: -- If the true_false flags for even one of the columns is TRUE, we have to proceed cascade
4055: -- else if all flags are FALSE, then we can stop cascading.
4056:
4057: hr_utility.set_location('Entering ' || l_proc,5);
4058: For rowno in 7..101 loop -- Bug 1161542 changed 4..101 to 7..101
4059: If p_true_false(rowno) then
4060: hr_utility.set_location(l_proc,10);
4061: l_dummy := TRUE;
4056:
4057: hr_utility.set_location('Entering ' || l_proc,5);
4058: For rowno in 7..101 loop -- Bug 1161542 changed 4..101 to 7..101
4059: If p_true_false(rowno) then
4060: hr_utility.set_location(l_proc,10);
4061: l_dummy := TRUE;
4062: exit;
4063: End if;
4064: hr_utility.set_location(l_proc,15);
4060: hr_utility.set_location(l_proc,10);
4061: l_dummy := TRUE;
4062: exit;
4063: End if;
4064: hr_utility.set_location(l_proc,15);
4065: End loop;
4066: hr_utility.set_location(l_proc,20);
4067: Return l_dummy;
4068: hr_utility.set_location(l_proc,25);
4062: exit;
4063: End if;
4064: hr_utility.set_location(l_proc,15);
4065: End loop;
4066: hr_utility.set_location(l_proc,20);
4067: Return l_dummy;
4068: hr_utility.set_location(l_proc,25);
4069: End stop_cascade;
4070:
4064: hr_utility.set_location(l_proc,15);
4065: End loop;
4066: hr_utility.set_location(l_proc,20);
4067: Return l_dummy;
4068: hr_utility.set_location(l_proc,25);
4069: End stop_cascade;
4070:
4071: -- ---------------------------------------------------------------------------
4072: -- |--------------------------< cascade_dependencies>-------------------------|
4112:
4113: -- Since information102 thru' 125 are always dependent on information101,
4114: -- cascade changes to these columns if information101 is supposed to be cascaded.
4115:
4116: hr_utility.set_location('Entering ' || l_proc , 5);
4117: --Initialise Local Variables
4118: l_apply_record := p_apply_record;
4119: --
4120:
4137: p_apply_record.information118 := p_record.information118;
4138: p_apply_record.information119 := p_record.information119;
4139: p_apply_record.information120 := p_record.information120;
4140:
4141: hr_utility.set_location('Leaving ' || l_proc,10);
4142:
4143: Exception
4144: When Others then
4145: --RESET In/Out Params and SET Out Params
4143: Exception
4144: When Others then
4145: --RESET In/Out Params and SET Out Params
4146: p_apply_record:=l_apply_record;
4147: hr_utility.set_location('Leaving ' || l_proc,15);
4148: Raise;
4149:
4150: End cascade_dependencies;
4151:
4199:
4200: Begin
4201: -- This procedure passes sysdate for the most recent record to fetch_history_info
4202: -- Assuming there will be no future action already applied to the extra_information table
4203: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4204: --Initialise local variables
4205: l_history_data := p_history_data;
4206: l_result_code := p_result_code;
4207: --
4212: p_person_id => p_person_id,
4213: p_date_effective => l_date_effective,
4214: p_hist_data => p_history_data,
4215: p_result_code => p_result_code);
4216: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
4217:
4218: Exception
4219: When Others then
4220: --RESET In/Out Params and SET Out Params
4219: When Others then
4220: --RESET In/Out Params and SET Out Params
4221: p_history_data:=l_history_data;
4222: p_result_code:=l_result_code;
4223: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
4224: Raise;
4225:
4226: End fetch_most_recent_record;
4227:
4282:
4283: l_proc varchar2(72) := 'cascade_pa_req_field';
4284:
4285: BEGIN
4286: hr_utility.set_location('entering: ' || l_proc,10);
4287: -- Initialise Local Variables
4288: l_refresh_field := p_refresh_field;
4289: l_shadow_field := p_shadow_field;
4290: l_sf52_field := p_sf52_field;
4314: -- this should take care of refreshing shadow table. As desc. are not in shadow table.
4315: p_shadow_field := p_refresh_field;
4316: end if;
4317: */
4318: hr_utility.set_location('leaving: ' || l_proc,20);
4319: return l_changed;
4320: Exception
4321: When Others then
4322: --Reset In/Out Params and SET Out Params
4323: p_refresh_field :=l_refresh_field;
4324: p_shadow_field :=l_shadow_field;
4325: p_sf52_field :=l_sf52_field;
4326: p_changed :=l_changed_boo;
4327: hr_utility.set_location('leaving: ' || l_proc,25);
4328: Raise;
4329:
4330: END;
4331:
4351: -- function added on 29-oct-1998 to avoid the conversion problems for date
4352: -- fields. This overloading function converts the date to varchar and
4353: -- calls the original cascade_pa_req_field function.
4354: --
4355: hr_utility.set_location('entering: ' || l_proc,10);
4356: --Initialise local variables
4357: l_refresh_field := fnd_date.date_to_canonical(p_refresh_field);
4358: l_shadow_field := fnd_date.date_to_canonical(p_shadow_field);
4359: l_sf52_field := fnd_date.date_to_canonical(p_sf52_field);
4369: p_shadow_field := fnd_date.canonical_to_date(l_shadow_field);
4370: p_sf52_field := fnd_date.canonical_to_date(l_sf52_field);
4371:
4372: return l_changed;
4373: hr_utility.set_location('leaving: ' || l_proc,20);
4374:
4375: Exception
4376: When Others then
4377: --RESET In/Out Params and SET Out Params
4378: p_refresh_field :=l_refresh_field;
4379: p_shadow_field :=l_shadow_field;
4380: p_sf52_field :=l_sf52_field;
4381: p_changed :=l_changed_boo;
4382: hr_utility.set_location('leaving: ' || l_proc,25);
4383: Raise;
4384:
4385: END;
4386:
4398: l_sf52_field varchar2(150);
4399: l_changed_boo BOOLEAN;
4400: BEGIN
4401:
4402: hr_utility.set_location('entering: ' || l_proc,10);
4403: --Initialise Local Variables
4404: l_refresh_field := fnd_date.date_to_canonical(p_refresh_field);
4405: l_sf52_field := fnd_date.date_to_canonical(p_sf52_field);
4406: l_changed_boo := p_changed;
4411:
4412: p_refresh_field := fnd_date.canonical_to_date(l_refresh_field);
4413: p_sf52_field := fnd_date.canonical_to_date(l_sf52_field);
4414:
4415: hr_utility.set_location('leaving: ' || l_proc,20);
4416:
4417: Exception
4418: When Others then
4419: -- RESET In/Out Params and SET Out Params
4419: -- RESET In/Out Params and SET Out Params
4420: p_refresh_field:= l_refresh_field;
4421: p_sf52_field := l_sf52_field;
4422: p_changed := l_changed_boo;
4423: hr_utility.set_location('leaving : ' || l_proc,25);
4424: Raise;
4425:
4426: END;
4427:
4439: l_changed BOOLEAN;
4440: l_proc varchar2(72) := 'copy_pa_req_field (varchar2)';
4441: BEGIN
4442:
4443: hr_utility.set_location('entering: ' || l_proc,10);
4444: -- Initialise local variables
4445: l_refresh_field:= p_refresh_field;
4446: l_sf52_field := p_sf52_field;
4447: l_changed := p_changed;
4451: p_sf52_field := p_refresh_field;
4452: p_changed := TRUE;
4453: end if;
4454:
4455: hr_utility.set_location('leaving: ' || l_proc,20);
4456:
4457: Exception
4458: When Others then
4459: --RESET In/Out Params and SET Out Params
4459: --RESET In/Out Params and SET Out Params
4460: p_refresh_field := l_refresh_field;
4461: p_sf52_field := l_sf52_field;
4462: p_changed := l_changed;
4463: hr_utility.set_location('leaving: ' || l_proc,25);
4464: Raise;
4465:
4466: END;
4467:
4515: -- must not call cascade_pa_req_field to refresh any other field which is not in the
4516: -- shadow table.
4517:
4518:
4519: hr_utility.set_location('par cascade: annuitant_indicator' || l_proc,15);
4520: -- Initialise local variables
4521: l_rfrsh_rec := p_rfrsh_rec;
4522: l_shadow_Rec := p_shadow_rec;
4523: l_sf52_rec := p_sf52_rec;
4528: p_shadow_rec.annuitant_indicator,
4529: p_sf52_rec.annuitant_indicator,
4530: p_changed);
4531:
4532: hr_utility.set_location('par cascade: annuitant_indicator_desc' || l_proc,15);
4533: -- if annuitant_indicator has changed than change annuitant_indicator_desc.
4534: if (l_changed) then
4535: p_sf52_rec.annuitant_indicator_desc := p_rfrsh_rec.annuitant_indicator_desc;
4536: end if;
4534: if (l_changed) then
4535: p_sf52_rec.annuitant_indicator_desc := p_rfrsh_rec.annuitant_indicator_desc;
4536: end if;
4537:
4538: hr_utility.set_location('par cascade: appropriation_code1' || l_proc,15);
4539: l_changed := cascade_pa_req_field(p_rfrsh_rec.appropriation_code1,
4540: p_shadow_rec.appropriation_code1,
4541: p_sf52_rec.appropriation_code1,
4542: p_changed);
4540: p_shadow_rec.appropriation_code1,
4541: p_sf52_rec.appropriation_code1,
4542: p_changed);
4543:
4544: hr_utility.set_location('par cascade: appropriation_code2' || l_proc,15);
4545: l_changed := cascade_pa_req_field(p_rfrsh_rec.appropriation_code2,
4546: p_shadow_rec.appropriation_code2,
4547: p_sf52_rec.appropriation_code2,
4548: p_changed);
4546: p_shadow_rec.appropriation_code2,
4547: p_sf52_rec.appropriation_code2,
4548: p_changed);
4549:
4550: hr_utility.set_location('par cascade: bargaining_unit_status' || l_proc,15);
4551: l_changed := cascade_pa_req_field(p_rfrsh_rec.bargaining_unit_status,
4552: p_shadow_rec.bargaining_unit_status,
4553: p_sf52_rec.bargaining_unit_status,
4554: p_changed);
4552: p_shadow_rec.bargaining_unit_status,
4553: p_sf52_rec.bargaining_unit_status,
4554: p_changed);
4555:
4556: hr_utility.set_location('par cascade: citizenship' || l_proc,15);
4557: l_changed := cascade_pa_req_field(p_rfrsh_rec.citizenship,
4558: p_shadow_rec.citizenship,
4559: p_sf52_rec.citizenship,
4560: p_changed);
4558: p_shadow_rec.citizenship,
4559: p_sf52_rec.citizenship,
4560: p_changed);
4561:
4562: hr_utility.set_location('par cascade: duty_station_id' || l_proc,15);
4563: l_changed := cascade_pa_req_field(p_rfrsh_rec.duty_station_id,
4564: p_shadow_rec.duty_station_id,
4565: p_sf52_rec.duty_station_id,
4566: p_changed);
4572: end if;
4573:
4574: -- if education_level is cascaded, automatically cascade academic discipline and year degree attained. This is
4575: -- so that nulls will be cascaded for academic discipline and year degree attained, if necessary.
4576: hr_utility.set_location('par cascade: education_level' || l_proc,15);
4577: l_changed := cascade_pa_req_field(p_rfrsh_rec.education_level,
4578: p_shadow_rec.education_level,
4579: p_sf52_rec.education_level,
4580: p_changed);
4585: p_sf52_rec.year_degree_attained := p_rfrsh_rec.year_degree_attained;
4586: p_shadow_rec.year_degree_attained := p_rfrsh_rec.year_degree_attained;
4587: end if;
4588:
4589: hr_utility.set_location('par cascade: fegli' || l_proc,15);
4590: l_changed := cascade_pa_req_field(p_rfrsh_rec.fegli,
4591: p_shadow_rec.fegli,
4592: p_sf52_rec.fegli,
4593: p_changed);
4596: if (l_changed) then
4597: p_sf52_rec.fegli_desc := p_rfrsh_rec.fegli_desc ;
4598: end if;
4599:
4600: hr_utility.set_location('par cascade: flsa_category' || l_proc,15);
4601: l_changed := cascade_pa_req_field(p_rfrsh_rec.flsa_category,
4602: p_shadow_rec.flsa_category,
4603: p_sf52_rec.flsa_category,
4604: p_changed);
4602: p_shadow_rec.flsa_category,
4603: p_sf52_rec.flsa_category,
4604: p_changed);
4605:
4606: hr_utility.set_location('par cascade: forwarding_address_line1' || l_proc,15);
4607: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line1,
4608: p_shadow_rec.forwarding_address_line1,
4609: p_sf52_rec.forwarding_address_line1,
4610: p_changed);
4608: p_shadow_rec.forwarding_address_line1,
4609: p_sf52_rec.forwarding_address_line1,
4610: p_changed);
4611:
4612: hr_utility.set_location('par cascade: forwarding_address_line2' || l_proc,15);
4613: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line2,
4614: p_shadow_rec.forwarding_address_line2,
4615: p_sf52_rec.forwarding_address_line2,
4616: p_changed);
4614: p_shadow_rec.forwarding_address_line2,
4615: p_sf52_rec.forwarding_address_line2,
4616: p_changed);
4617:
4618: hr_utility.set_location('par cascade: forwarding_address_line3' || l_proc,15);
4619: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line3,
4620: p_shadow_rec.forwarding_address_line3,
4621: p_sf52_rec.forwarding_address_line3,
4622: p_changed);
4620: p_shadow_rec.forwarding_address_line3,
4621: p_sf52_rec.forwarding_address_line3,
4622: p_changed);
4623:
4624: hr_utility.set_location('par cascade: forwarding_country_short_name' || l_proc,15);
4625: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_country_short_name,
4626: p_shadow_rec.forwarding_country_short_name,
4627: p_sf52_rec.forwarding_country_short_name,
4628: p_changed);
4632: p_sf52_rec.forwarding_country := p_rfrsh_rec.forwarding_country ;
4633: p_shadow_rec.forwarding_country := p_rfrsh_rec.forwarding_country ;
4634: end if;
4635:
4636: hr_utility.set_location('par cascade: forwarding_postal_code' || l_proc,15);
4637: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_postal_code,
4638: p_shadow_rec.forwarding_postal_code,
4639: p_sf52_rec.forwarding_postal_code,
4640: p_changed);
4638: p_shadow_rec.forwarding_postal_code,
4639: p_sf52_rec.forwarding_postal_code,
4640: p_changed);
4641:
4642: hr_utility.set_location('par cascade: forwarding_town_or_city' || l_proc,15);
4643: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_town_or_city,
4644: p_shadow_rec.forwarding_town_or_city,
4645: p_sf52_rec.forwarding_town_or_city,
4646: p_changed);
4644: p_shadow_rec.forwarding_town_or_city,
4645: p_sf52_rec.forwarding_town_or_city,
4646: p_changed);
4647:
4648: hr_utility.set_location('par cascade: forwarding_country' || l_proc,15);
4649: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_region_2,
4650: p_shadow_rec.forwarding_region_2,
4651: p_sf52_rec.forwarding_region_2,
4652: p_changed);
4650: p_shadow_rec.forwarding_region_2,
4651: p_sf52_rec.forwarding_region_2,
4652: p_changed);
4653:
4654: hr_utility.set_location('par cascade: functional_class' || l_proc,15);
4655: l_changed := cascade_pa_req_field(p_rfrsh_rec.functional_class,
4656: p_shadow_rec.functional_class,
4657: p_sf52_rec.functional_class,
4658: p_changed);
4656: p_shadow_rec.functional_class,
4657: p_sf52_rec.functional_class,
4658: p_changed);
4659:
4660: hr_utility.set_location('par cascade: pay_rate_determinant' || l_proc,15);
4661: l_changed := cascade_pa_req_field(p_rfrsh_rec.pay_rate_determinant,
4662: p_shadow_rec.pay_rate_determinant,
4663: p_sf52_rec.pay_rate_determinant,
4664: p_changed);
4662: p_shadow_rec.pay_rate_determinant,
4663: p_sf52_rec.pay_rate_determinant,
4664: p_changed);
4665:
4666: hr_utility.set_location('par cascade: position_occupied' || l_proc,15);
4667: l_changed := cascade_pa_req_field(p_rfrsh_rec.position_occupied,
4668: p_shadow_rec.position_occupied,
4669: p_sf52_rec.position_occupied,
4670: p_changed);
4668: p_shadow_rec.position_occupied,
4669: p_sf52_rec.position_occupied,
4670: p_changed);
4671:
4672: hr_utility.set_location('par cascade: retirement_plan' || l_proc,15);
4673: l_changed := cascade_pa_req_field(p_rfrsh_rec.retirement_plan,
4674: p_shadow_rec.retirement_plan,
4675: p_sf52_rec.retirement_plan,
4676: p_changed);
4679: if (l_changed) then
4680: p_sf52_rec.retirement_plan_desc := p_rfrsh_rec.retirement_plan_desc;
4681: end if;
4682:
4683: hr_utility.set_location('par cascade: supervisory_status' || l_proc,15);
4684: l_changed := cascade_pa_req_field(p_rfrsh_rec.supervisory_status,
4685: p_shadow_rec.supervisory_status,
4686: p_sf52_rec.supervisory_status,
4687: p_changed);
4685: p_shadow_rec.supervisory_status,
4686: p_sf52_rec.supervisory_status,
4687: p_changed);
4688:
4689: hr_utility.set_location('par cascade: tenure' || l_proc,15);
4690: l_changed := cascade_pa_req_field(p_rfrsh_rec.tenure,
4691: p_shadow_rec.tenure,
4692: p_sf52_rec.tenure,
4693: p_changed);
4691: p_shadow_rec.tenure,
4692: p_sf52_rec.tenure,
4693: p_changed);
4694:
4695: hr_utility.set_location('par cascade: veterans_preference' || l_proc,15);
4696: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_preference,
4697: p_shadow_rec.veterans_preference,
4698: p_sf52_rec.veterans_preference,
4699: p_changed);
4697: p_shadow_rec.veterans_preference,
4698: p_sf52_rec.veterans_preference,
4699: p_changed);
4700:
4701: hr_utility.set_location('par cascade: veterans_pref_for_rif' || l_proc,15);
4702: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_pref_for_rif,
4703: p_shadow_rec.veterans_pref_for_rif,
4704: p_sf52_rec.veterans_pref_for_rif,
4705: p_changed);
4703: p_shadow_rec.veterans_pref_for_rif,
4704: p_sf52_rec.veterans_pref_for_rif,
4705: p_changed);
4706:
4707: hr_utility.set_location('par cascade: veterans_status' || l_proc,15);
4708: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_status,
4709: p_shadow_rec.veterans_status,
4710: p_sf52_rec.veterans_status,
4711: p_changed);
4709: p_shadow_rec.veterans_status,
4710: p_sf52_rec.veterans_status,
4711: p_changed);
4712:
4713: hr_utility.set_location('par cascade: work_schedule' || l_proc,15);
4714: l_changed := cascade_pa_req_field(p_rfrsh_rec.work_schedule,
4715: p_shadow_rec.work_schedule,
4716: p_sf52_rec.work_schedule,
4717: p_changed);
4721: p_sf52_rec.work_schedule_desc := p_rfrsh_rec.work_schedule_desc;
4722: p_shadow_rec.work_schedule_desc := p_rfrsh_rec.work_schedule_desc;
4723: end if;
4724:
4725: hr_utility.set_location('par cascade: part_time_hours' || l_proc,15);
4726: l_changed := cascade_pa_req_field(p_rfrsh_rec.part_time_hours,
4727: p_shadow_rec.part_time_hours,
4728: p_sf52_rec.part_time_hours,
4729: p_changed);
4740: end if;
4741: end if;
4742: end if;
4743:
4744: hr_utility.set_location('par cascade: service_comp_date' || l_proc,15);
4745: l_changed := cascade_pa_req_field(p_rfrsh_rec.service_comp_date,
4746: p_shadow_rec.service_comp_date,
4747: p_sf52_rec.service_comp_date,
4748: p_changed);
4746: p_shadow_rec.service_comp_date,
4747: p_sf52_rec.service_comp_date,
4748: p_changed);
4749:
4750: hr_utility.set_location('par cascade: to_position_id' || l_proc,15);
4751: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_position_id,
4752: p_shadow_rec.to_position_id,
4753: p_sf52_rec.to_position_id,
4754: p_changed);
4761: p_changed);
4762: end if;
4763: end if;
4764:
4765: hr_utility.set_location('par cascade: auo premium pay indc' || l_proc,15);
4766: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_auo_premium_pay_indicator,
4767: p_shadow_rec.to_auo_premium_pay_indicator,
4768: p_sf52_rec.to_auo_premium_pay_indicator,
4769: p_changed);
4770:
4771: -- Bug# 1257515: cascading AUO Amount when auo Ind NOT NULL,
4772: -- otherwise copying it.
4773: IF p_sf52_rec.to_auo_premium_pay_indicator IS NOT NULL THEN
4774: hr_utility.set_location('par cascade: auo premium pay amount' || l_proc,15);
4775: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_au_overtime,
4776: p_shadow_rec.to_au_overtime,
4777: p_sf52_rec.to_au_overtime,
4778: p_changed);
4781: p_sf52_rec.to_au_overtime,
4782: p_changed);
4783: END IF;
4784:
4785: hr_utility.set_location('par cascade: to_occ_code' || l_proc,15);
4786: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_occ_code,
4787: p_shadow_rec.to_occ_code,
4788: p_sf52_rec.to_occ_code,
4789: p_changed);
4790: if (l_changed) then
4791: p_sf52_rec.to_job_id := p_rfrsh_rec.to_job_id;
4792: end if;
4793:
4794: hr_utility.set_location('par cascade: Premium Pay Indc' || l_proc,15);
4795: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_ap_premium_pay_indicator,
4796: p_shadow_rec.to_ap_premium_pay_indicator,
4797: p_sf52_rec.to_ap_premium_pay_indicator,
4798: p_changed);
4799:
4800: -- Bug# 2196971 : cascading AP Amount when ap Ind NOT NULL,
4801: -- otherwise copying it.
4802: IF p_sf52_rec.to_ap_premium_pay_indicator IS NOT NULL THEN
4803: hr_utility.set_location('par cascade: ap premium pay amount' || l_proc,15);
4804: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_availability_pay,
4805: p_shadow_rec.to_availability_pay,
4806: p_sf52_rec.to_availability_pay,
4807: p_changed);
4809: copy_pa_req_field(p_rfrsh_rec.to_availability_pay,
4810: p_sf52_rec.to_availability_pay,
4811: p_changed);
4812: END IF;
4813: hr_utility.set_location('par cascade: Retention Allowance' || l_proc,15);
4814: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_retention_allowance,
4815: p_shadow_rec.to_retention_allowance,
4816: p_sf52_rec.to_retention_allowance,
4817: p_changed);
4815: p_shadow_rec.to_retention_allowance,
4816: p_sf52_rec.to_retention_allowance,
4817: p_changed);
4818:
4819: hr_utility.set_location('par cascade: Retention Allowance' || l_proc,15);
4820: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_retention_allow_percentage,
4821: p_shadow_rec.to_retention_allow_percentage,
4822: p_sf52_rec.to_retention_allow_percentage,
4823: p_changed);
4821: p_shadow_rec.to_retention_allow_percentage,
4822: p_sf52_rec.to_retention_allow_percentage,
4823: p_changed);
4824:
4825: hr_utility.set_location('par cascade: Superv. Diff' || l_proc,15);
4826: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_supervisory_differential,
4827: p_shadow_rec.to_supervisory_differential,
4828: p_sf52_rec.to_supervisory_differential,
4829: p_changed);
4827: p_shadow_rec.to_supervisory_differential,
4828: p_sf52_rec.to_supervisory_differential,
4829: p_changed);
4830:
4831: hr_utility.set_location('par cascade: Superv. Diff' || l_proc,15);
4832: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_supervisory_diff_percentage,
4833: p_shadow_rec.to_supervisory_diff_percentage,
4834: p_sf52_rec.to_supervisory_diff_percentage,
4835: p_changed);
4833: p_shadow_rec.to_supervisory_diff_percentage,
4834: p_sf52_rec.to_supervisory_diff_percentage,
4835: p_changed);
4836:
4837: hr_utility.set_location('par cascade: Staffing Diff.' || l_proc,15);
4838: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_staffing_differential,
4839: p_shadow_rec.to_staffing_differential,
4840: p_sf52_rec.to_staffing_differential,
4841: p_changed);
4839: p_shadow_rec.to_staffing_differential,
4840: p_sf52_rec.to_staffing_differential,
4841: p_changed);
4842:
4843: hr_utility.set_location('par cascade: Staffing Diff. Percentage' || l_proc,15);
4844: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_staffing_diff_percentage,
4845: p_shadow_rec.to_staffing_diff_percentage,
4846: p_sf52_rec.to_staffing_diff_percentage,
4847: p_changed);
4845: p_shadow_rec.to_staffing_diff_percentage,
4846: p_sf52_rec.to_staffing_diff_percentage,
4847: p_changed);
4848:
4849: hr_utility.set_location('par cascade: duty_station_location_id' || l_proc,15);
4850: l_changed := cascade_pa_req_field(p_rfrsh_rec.duty_station_location_id,
4851: p_shadow_rec.duty_station_location_id,
4852: p_sf52_rec.duty_station_location_id,
4853: p_changed);
5015: p_rfrsh_rec :=l_rfrsh_rec;
5016: p_shadow_rec :=l_shadow_rec;
5017: p_sf52_rec :=l_sf52_rec;
5018: p_changed :=l_changed_boo;
5019: hr_utility.set_location('leaving: ' || l_proc,25);
5020: Raise;
5021:
5022: end cascade_pa_req;
5023: