[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: hr_utility.set_location(l_proc,15);
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: hr_utility.set_location(l_proc,15);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
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: hr_utility.set_location(l_proc,15);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
301: l_true_false(rowno) := TRUE;
302: End loop;
303: hr_utility.set_location(l_proc,15);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
302: End loop;
303: hr_utility.set_location(l_proc,15);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
303: hr_utility.set_location(l_proc,15);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
304: hr_utility.set_location('p_post_record.pa_history_id: ' || p_post_record.pa_history_id || l_proc,2004);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
305: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,2006);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
306: hr_utility.set_location('p_post_record.person_id: ' || p_post_record.person_id || l_proc,2007);
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
307: hr_utility.set_location('p_post_record.effective_date: ' || p_post_record.effective_date || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
308: hr_utility.set_location('p_post_record.information9: ' || p_post_record.information9 || l_proc,2013);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
309: hr_utility.set_location('p_post_record.information10: ' || p_post_record.information10 || l_proc,2014);
310: hr_utility.set_location('p_post_record.information11: ' || p_post_record.information11 || l_proc,2015);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
311: hr_utility.set_location('p_post_record.information12: ' || p_post_record.information12 || l_proc,2016);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
312: hr_utility.set_location('p_post_record.information13: ' || p_post_record.information13 || l_proc,2017);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
313: hr_utility.set_location('p_post_record.information14: ' || p_post_record.information14 || l_proc,2018);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
314:
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
315: hr_utility.set_location('p_pre_record.pa_request_id: ' || p_pre_record.pa_request_id || l_proc,2008);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
316: hr_utility.set_location('p_pre_record.pa_history_id: ' || p_pre_record.pa_history_id || l_proc,2009);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
317: hr_utility.set_location('p_pre_record.information1: ' || p_pre_record.information1 || l_proc,2010);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
318: hr_utility.set_location('p_pre_record.person_id: ' || p_pre_record.person_id || l_proc,2011);
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
326:
319: hr_utility.set_location('p_pre_record.effective_date: ' || p_pre_record.effective_date || l_proc,2012);
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
326:
327: if (p_post_record.pa_request_id is null) then
320: hr_utility.set_location('p_pre_record.information9: ' || p_pre_record.information9 || l_proc,2019);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
326:
327: if (p_post_record.pa_request_id is null) then
328: hr_utility.set_location('gh: ' || l_proc,1000);
321: hr_utility.set_location('p_pre_record.information10: ' || p_pre_record.information10 || l_proc,2020);
322: hr_utility.set_location('p_pre_record.information11: ' || p_pre_record.information11 || l_proc,2021);
323: hr_utility.set_location('p_pre_record.information12: ' || p_pre_record.information12 || l_proc,2022);
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
326:
327: if (p_post_record.pa_request_id is null) then
328: hr_utility.set_location('gh: ' || l_proc,1000);
329: --this is a core change, set root pa_history_id is the pa_history_id itself.
324: hr_utility.set_location('p_pre_record.information13: ' || p_pre_record.information13 || l_proc,2023);
325: hr_utility.set_location('p_pre_record.information14: ' || p_pre_record.information14 || l_proc,2024);
326:
327: if (p_post_record.pa_request_id is null) then
328: hr_utility.set_location('gh: ' || l_proc,1000);
329: --this is a core change, set root pa_history_id is the pa_history_id itself.
330: l_root_pa_history_id := p_post_record.pa_history_id;
331: else
332: hr_utility.set_location('gh: ' || l_proc,1001);
328: hr_utility.set_location('gh: ' || l_proc,1000);
329: --this is a core change, set root pa_history_id is the pa_history_id itself.
330: l_root_pa_history_id := p_post_record.pa_history_id;
331: else
332: hr_utility.set_location('gh: ' || l_proc,1001);
333: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
334: hr_utility.set_location('gh: ' || l_proc,1002);
335: fetch get_root_hist_id into l_root_pa_history_id;
336: hr_utility.set_location('gh: ' || l_proc,1003);
330: l_root_pa_history_id := p_post_record.pa_history_id;
331: else
332: hr_utility.set_location('gh: ' || l_proc,1001);
333: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
334: hr_utility.set_location('gh: ' || l_proc,1002);
335: fetch get_root_hist_id into l_root_pa_history_id;
336: hr_utility.set_location('gh: ' || l_proc,1003);
337: if l_root_pa_history_id is null then
338: close get_root_hist_id;
332: hr_utility.set_location('gh: ' || l_proc,1001);
333: open get_root_hist_id(cp_pa_history_id => p_post_record.pa_history_id);
334: hr_utility.set_location('gh: ' || l_proc,1002);
335: fetch get_root_hist_id into l_root_pa_history_id;
336: hr_utility.set_location('gh: ' || l_proc,1003);
337: if l_root_pa_history_id is null then
338: close get_root_hist_id;
339: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
340: hr_utility.raise_error;
335: fetch get_root_hist_id into l_root_pa_history_id;
336: hr_utility.set_location('gh: ' || l_proc,1003);
337: if l_root_pa_history_id is null then
338: close get_root_hist_id;
339: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
340: hr_utility.raise_error;
341: end if;
342: close get_root_hist_id;
343: end if;
336: hr_utility.set_location('gh: ' || l_proc,1003);
337: if l_root_pa_history_id is null then
338: close get_root_hist_id;
339: hr_utility.set_message(8301,'GHR_38490_ROOT_HISTID_NFND');
340: hr_utility.raise_error;
341: end if;
342: close get_root_hist_id;
343: end if;
344: hr_utility.set_location('gh: ' || l_proc,1005);
340: hr_utility.raise_error;
341: end if;
342: close get_root_hist_id;
343: end if;
344: hr_utility.set_location('gh: ' || l_proc,1005);
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
341: end if;
342: close get_root_hist_id;
343: end if;
344: hr_utility.set_location('gh: ' || l_proc,1005);
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
349: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
342: close get_root_hist_id;
343: end if;
344: hr_utility.set_location('gh: ' || l_proc,1005);
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
349: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
350:
343: end if;
344: hr_utility.set_location('gh: ' || l_proc,1005);
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
349: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
350:
351: -- Retrieve all root history_ids
344: hr_utility.set_location('gh: ' || l_proc,1005);
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
349: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
350:
351: -- Retrieve all root history_ids
352: For history_data in c_history(p_table_name,
345: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
346: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
347: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
348: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
349: hr_utility.set_location('p_post_record.effective_date ' || p_post_record.effective_date || l_proc,2013);
350:
351: -- Retrieve all root history_ids
352: For history_data in c_history(p_table_name,
353: p_post_record.information1,
355: P_post_record.effective_date,
356: l_root_pa_history_id
357: ) loop
358: l_history_id := history_data.pa_history_id;
359: hr_utility.set_location(l_proc,20);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
356: l_root_pa_history_id
357: ) loop
358: l_history_id := history_data.pa_history_id;
359: hr_utility.set_location(l_proc,20);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
357: ) loop
358: l_history_id := history_data.pa_history_id;
359: hr_utility.set_location(l_proc,20);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
358: l_history_id := history_data.pa_history_id;
359: hr_utility.set_location(l_proc,20);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
359: hr_utility.set_location(l_proc,20);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
367: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
360: hr_utility.set_location('l_history_id: ' || l_history_id || l_proc,2002);
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
367: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
368:
361: hr_utility.set_location('l_root_pa_history_id: ' || l_root_pa_history_id || l_proc,2003);
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
367: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
368:
369: -- If any record is retrieved then set p_interv_on_table to TRUE
362: hr_utility.set_location('p_post_record.information1: ' || p_post_record.information1 || l_proc,4010);
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
367: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
368:
369: -- If any record is retrieved then set p_interv_on_table to TRUE
370: p_interv_on_table := TRUE;
363: hr_utility.set_location('p_post_record.person_id : ' || p_post_record.person_id || l_proc,4011);
364: hr_utility.set_location('p_table_name: ' || p_table_name || l_proc,4012);
365: hr_utility.set_location('history_data.pa_history_id : ' || history_data.pa_history_id || l_proc,4019);
366: hr_utility.set_location('history_data.nature_of_action_id : ' || history_data.nature_of_action_id || l_proc,4020);
367: hr_utility.set_location('history_data.pa_request_id : ' || history_data.pa_request_id || l_proc,4021);
368:
369: -- If any record is retrieved then set p_interv_on_table to TRUE
370: p_interv_on_table := TRUE;
371: if (history_data.pa_request_id is not null) then
392: else
393: --core change
394: l_record_data := history_data;
395: end if;
396: hr_utility.set_location(l_proc,25);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
393: --core change
394: l_record_data := history_data;
395: end if;
396: hr_utility.set_location(l_proc,25);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
394: l_record_data := history_data;
395: end if;
396: hr_utility.set_location(l_proc,25);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
395: end if;
396: hr_utility.set_location(l_proc,25);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
396: hr_utility.set_location(l_proc,25);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
397: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2005);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
398: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,3010);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
406: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
399: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,3011);
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
406: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
407:
400: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,3012);
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
406: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
407:
408: if l_record_data.effective_date = l_session_var.date_effective then
401: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,3019);
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
406: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
407:
408: if l_record_data.effective_date = l_session_var.date_effective then
409: p_interv_on_eff_date := TRUE;
402: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,3020);
403: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,3021);
404: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,3022);
405: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,3023);
406: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,3024);
407:
408: if l_record_data.effective_date = l_session_var.date_effective then
409: p_interv_on_eff_date := TRUE;
410: p_hist_data_as_of_date := l_record_data;
413: -- If cascade_type is 'retroactive' the new changes by the current SF52, which is the
414: -- post_record in the history has to be cascaded to all the above fetched records from history
415: if lower(p_cascade_Type) = 'retroactive' then
416:
417: hr_utility.set_location(l_proc,30);
418: cascade_Change(p_pre_record => p_Pre_record,
419: p_post_record => p_Post_record,
420: p_apply_record => l_record_data,
421: p_true_false => l_true_false
419: p_post_record => p_Post_record,
420: p_apply_record => l_record_data,
421: p_true_false => l_true_false
422: );
423: hr_utility.set_location(l_proc,35);
424:
425: elsif lower(p_cascade_Type) = 'cancel' then
426:
427: hr_utility.set_location(l_proc,40);
423: hr_utility.set_location(l_proc,35);
424:
425: elsif lower(p_cascade_Type) = 'cancel' then
426:
427: hr_utility.set_location(l_proc,40);
428: cascade_Change(p_pre_record => p_Post_record,
429: p_post_record => p_Pre_record,
430: p_apply_record => l_record_data,
431: p_true_false => l_true_false
429: p_post_record => p_Pre_record,
430: p_apply_record => l_record_data,
431: p_true_false => l_true_false
432: );
433: hr_utility.set_location(l_proc,45);
434:
435: else
436: hr_utility.set_location(l_proc,50);
437: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
432: );
433: hr_utility.set_location(l_proc,45);
434:
435: else
436: hr_utility.set_location(l_proc,50);
437: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
438: hr_utility.raise_error;
439: -- raise error /* Unknown type */
440: end if;
433: hr_utility.set_location(l_proc,45);
434:
435: else
436: hr_utility.set_location(l_proc,50);
437: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
438: hr_utility.raise_error;
439: -- raise error /* Unknown type */
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
434:
435: else
436: hr_utility.set_location(l_proc,50);
437: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
438: hr_utility.raise_error;
439: -- raise error /* Unknown type */
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
437: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
438: hr_utility.raise_error;
439: -- raise error /* Unknown type */
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
438: hr_utility.raise_error;
439: -- raise error /* Unknown type */
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
439: -- raise error /* Unknown type */
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
440: end if;
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
441: hr_utility.set_location('l_record_data.pa_history_id: ' || l_record_data.pa_history_id || l_proc,2009);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
442: hr_utility.set_location('l_record_data.information1: ' || l_record_data.information1 || l_proc,2010);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
443: hr_utility.set_location('l_record_data.person_id: ' || l_record_data.person_id || l_proc,2011);
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
451: -- update history record with changes to be cascaded :
444: hr_utility.set_location('l_record_data.effective_date: ' || l_record_data.effective_date || l_proc,2012);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
451: -- update history record with changes to be cascaded :
452: hr_utility.set_location(l_proc,80);
445: hr_utility.set_location('l_record_data.information9: ' || l_record_data.information9 || l_proc,2019);
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
451: -- update history record with changes to be cascaded :
452: hr_utility.set_location(l_proc,80);
453: ghr_pah_upd.upd
446: hr_utility.set_location('l_record_data.information10: ' || l_record_data.information10 || l_proc,2020);
447: hr_utility.set_location('l_record_data.information11: ' || l_record_data.information11 || l_proc,2021);
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
451: -- update history record with changes to be cascaded :
452: hr_utility.set_location(l_proc,80);
453: ghr_pah_upd.upd
454: (
448: hr_utility.set_location('l_record_data.information12: ' || l_record_data.information12 || l_proc,2022);
449: hr_utility.set_location('l_record_data.information13: ' || l_record_data.information13 || l_proc,2023);
450: hr_utility.set_location('l_record_data.information14: ' || l_record_data.information14 || l_proc,2024);
451: -- update history record with changes to be cascaded :
452: hr_utility.set_location(l_proc,80);
453: ghr_pah_upd.upd
454: (
455: p_pa_history_id => l_record_data.pa_history_id,
456: p_pa_request_id => l_record_data.pa_request_id,
668: -- Determine whether to continue cascading , which is identified by looking at the
669: -- true_false flag for all the columns that can be cascaded,
670: -- If all of them are set to false, then stop cascading.
671:
672: hr_utility.set_location(l_proc,85);
673: l_stop := Stop_cascade(l_true_false);
674: hr_utility.set_location(l_proc,90);
675: If not l_stop then
676: hr_utility.set_location(l_proc,95);
670: -- If all of them are set to false, then stop cascading.
671:
672: hr_utility.set_location(l_proc,85);
673: l_stop := Stop_cascade(l_true_false);
674: hr_utility.set_location(l_proc,90);
675: If not l_stop then
676: hr_utility.set_location(l_proc,95);
677: exit;
678: End if;
672: hr_utility.set_location(l_proc,85);
673: l_stop := Stop_cascade(l_true_false);
674: hr_utility.set_location(l_proc,90);
675: If not l_stop then
676: hr_utility.set_location(l_proc,95);
677: exit;
678: End if;
679: hr_utility.set_location(l_proc,95);
680: if (history_data.pa_request_id is null) then
675: If not l_stop then
676: hr_utility.set_location(l_proc,95);
677: exit;
678: End if;
679: hr_utility.set_location(l_proc,95);
680: if (history_data.pa_request_id is null) then
681: -- core change, only want to do one iteration of this loop.
682: exit;
683: end if;
685: if (history_data.pa_request_id is not null) then
686: -- this was not a core change,so we opened this cursor.
687: close c_cascade_history;
688: end if;
689: hr_utility.set_location(l_proc,100);
690: End loop; -- End of root loop
691: hr_utility.set_location('Leaving ' || l_proc,105);
692: Exception
693: When Others then
687: close c_cascade_history;
688: end if;
689: hr_utility.set_location(l_proc,100);
690: End loop; -- End of root loop
691: hr_utility.set_location('Leaving ' || l_proc,105);
692: Exception
693: When Others then
694: -- RESET In/Out params and SET Out Params
695: p_interv_on_table :=null;
694: -- RESET In/Out params and SET Out Params
695: p_interv_on_table :=null;
696: p_interv_on_eff_date :=null;
697: p_hist_data_as_of_date :=null;
698: hr_utility.set_location('Leaving ' || l_proc,110);
699: Raise;
700:
701: End cascade_history_data;
702:
756: ) is
757:
758: l_proc varchar2(30):='Cascade_appl_table_data';
759: Begin
760: hr_utility.set_location( 'Entering : ' || l_proc, 10);
761: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
762: hr_utility.set_location( l_proc, 20);
763: Cascade_People(
764: p_pre_record => p_pre_record,
758: l_proc varchar2(30):='Cascade_appl_table_data';
759: Begin
760: hr_utility.set_location( 'Entering : ' || l_proc, 10);
761: if lower(p_table_name) = lower(ghr_history_api.g_peop_table) then
762: hr_utility.set_location( l_proc, 20);
763: Cascade_People(
764: p_pre_record => p_pre_record,
765: p_post_record => p_post_record,
766: p_cascade_type => p_cascade_type,
767: p_interv_on_eff_date => p_interv_on_eff_date,
768: p_hist_data_as_of_date => p_hist_data_as_of_date);
769:
770: elsif lower(p_table_name) = lower(ghr_history_api.g_asgn_table) then
771: hr_utility.set_location( l_proc, 30);
772: Cascade_asgn (
773: p_pre_record => p_pre_record,
774: p_post_record => p_post_record,
775: p_cascade_type => p_cascade_type,
775: p_cascade_type => p_cascade_type,
776: p_interv_on_eff_date => p_interv_on_eff_date,
777: p_hist_data_as_of_date => p_hist_data_as_of_date);
778: elsif lower(p_table_name) = lower(ghr_history_api.g_eleent_table) then
779: hr_utility.set_location( l_proc, 40);
780: -- this is already handled in cancel/correction procedures
781: -- retroactive actions need not cascade change in element_entry
782: null;
783: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
780: -- this is already handled in cancel/correction procedures
781: -- retroactive actions need not cascade change in element_entry
782: null;
783: elsif lower(p_table_name) = lower(ghr_history_api.g_eleevl_table) then
784: hr_utility.set_location( l_proc, 50);
785: -- this is already handled in cancel/correction procedures
786: -- retroactive actions need not cascade change in element_entry_values
787: null;
788: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
785: -- this is already handled in cancel/correction procedures
786: -- retroactive actions need not cascade change in element_entry_values
787: null;
788: elsif lower(p_table_name) = lower(ghr_history_api.g_peopei_table) then
789: hr_utility.set_location( l_proc, 60);
790: Cascade_peopleei (
791: p_post_record => p_post_record);
792: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
793: hr_utility.set_location( l_proc, 70);
789: hr_utility.set_location( l_proc, 60);
790: Cascade_peopleei (
791: p_post_record => p_post_record);
792: elsif lower(p_table_name) = lower(ghr_history_api.g_asgnei_table) then
793: hr_utility.set_location( l_proc, 70);
794: Cascade_asgnei (
795: p_post_record => p_post_record);
796: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
797: hr_utility.set_location( l_proc, 80);
793: hr_utility.set_location( l_proc, 70);
794: Cascade_asgnei (
795: p_post_record => p_post_record);
796: elsif lower(p_table_name) = lower(ghr_history_api.g_addres_table) then
797: hr_utility.set_location( l_proc, 80);
798: Cascade_addresses (
799: p_post_record => p_post_record);
800: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
801: hr_utility.set_location( l_proc, 90);
797: hr_utility.set_location( l_proc, 80);
798: Cascade_addresses (
799: p_post_record => p_post_record);
800: elsif lower(p_table_name) = lower(ghr_history_api.g_posnei_table) then
801: hr_utility.set_location( l_proc, 90);
802: Cascade_posnei (
803: p_post_record => p_post_record);
804: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
805: hr_utility.set_location( l_proc, 90);
801: hr_utility.set_location( l_proc, 90);
802: Cascade_posnei (
803: p_post_record => p_post_record);
804: elsif lower(p_table_name) = lower(ghr_history_api.g_posn_table) then
805: hr_utility.set_location( l_proc, 90);
806: /*
807: Cascade_posn (
808: p_post_record => p_post_record);
809: */
815: p_hist_data_as_of_date => p_hist_data_as_of_date);
816:
817: elsif lower(p_table_name) in (lower(ghr_history_api.g_perana_table)) then
818: -- This table need not cascade.
819: hr_utility.set_location( l_proc, 95);
820: Cascade_perana (
821: p_post_record => p_post_record);
822: null;
823: else
820: Cascade_perana (
821: p_post_record => p_post_record);
822: null;
823: else
824: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
825: --raise error
826: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
827: hr_utility.raise_error;
828: end if;
822: null;
823: else
824: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
825: --raise error
826: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
827: hr_utility.raise_error;
828: end if;
829: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
830:
823: else
824: hr_utility.set_location( 'Unidentified table ' || l_proc, 100);
825: --raise error
826: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
827: hr_utility.raise_error;
828: end if;
829: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
830:
831: End;
825: --raise error
826: hr_utility.set_message(8301, 'GHR_38363_UNKNOWN_TABLE');
827: hr_utility.raise_error;
828: end if;
829: hr_utility.set_location( 'Leaving : ' || l_proc, 200);
830:
831: End;
832:
833: -- ---------------------------------------------------------------------------
891: where effective_start_date >= c_date_effective and
892: person_id = c_person_id;
893:
894: Begin
895: hr_utility.set_location( 'Entering : ' || l_proc, 10);
896: For rowno in 4..101 loop
897: l_true_false(rowno) := TRUE;
898: End loop;
899: hr_utility.set_location( l_proc, 15);
895: hr_utility.set_location( 'Entering : ' || l_proc, 10);
896: For rowno in 4..101 loop
897: l_true_false(rowno) := TRUE;
898: End loop;
899: hr_utility.set_location( l_proc, 15);
900: if p_interv_on_eff_date then
901: -- This is to take care of multiple actions on the same date.
902: -- When a correction is made to a SF52 and other process had
903: -- updated the same row on the same date, the data in the
905: -- granularity of a day, and not date and time. So, this will
906: -- re-apply the data from history for the effective date of the current action to the
907: -- core table. This will insure that the core table will contain the correct information
908: -- in all cases.
909: hr_utility.set_location( l_proc, 20);
910: ghr_history_conv_rg.Conv_to_people_rg(
911: p_people_data => l_people_data,
912: p_history_data => p_hist_data_as_of_date);
913: correct_people_row( p_people_data => l_people_data);
910: ghr_history_conv_rg.Conv_to_people_rg(
911: p_people_data => l_people_data,
912: p_history_data => p_hist_data_as_of_date);
913: correct_people_row( p_people_data => l_people_data);
914: hr_utility.set_location( l_proc, 30);
915: elsif (lower(p_cascade_type) = 'cancel') then
916: -- if this is a cancellation and there are no intervening rows on this effective date,
917: -- then apply the pre-record to the core people table for this effective date.
918: hr_utility.set_location( l_proc, 35);
914: hr_utility.set_location( l_proc, 30);
915: elsif (lower(p_cascade_type) = 'cancel') then
916: -- if this is a cancellation and there are no intervening rows on this effective date,
917: -- then apply the pre-record to the core people table for this effective date.
918: hr_utility.set_location( l_proc, 35);
919: ghr_history_conv_rg.Conv_to_people_rg(
920: p_people_data => l_people_data,
921: p_history_data => p_pre_record);
922: correct_people_row( p_people_data => l_people_data);
921: p_history_data => p_pre_record);
922: correct_people_row( p_people_data => l_people_data);
923: end if;
924:
925: hr_utility.set_location( l_proc, 40);
926: -- Fetch all the following rows.
927: open c_people( p_post_record.effective_date, to_number(p_post_record.information1));
928: while true
929: Loop
926: -- Fetch all the following rows.
927: open c_people( p_post_record.effective_date, to_number(p_post_record.information1));
928: while true
929: Loop
930: hr_utility.set_location( l_proc, 50);
931: fetch c_people into l_people_data;
932: exit when not c_people%found;
933: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
934: p_history_data => l_hist_peop_data);
933: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_people_data,
934: p_history_data => l_hist_peop_data);
935:
936: if lower(p_cascade_Type) = 'retroactive' then
937: hr_utility.set_location( l_proc, 60);
938: -- for retroactive action post-record values have to be cascaded
939: -- whereever pre-record values exist.
940: cascade_Change(p_pre_record => p_Pre_record,
941: p_post_record => p_Post_record,
944:
945: elsif lower(p_cascade_Type) = 'cancel' then
946: -- for cancellation action pre-record values have to be cascaded
947: -- whereever post-record values exist.
948: hr_utility.set_location( l_proc, 70);
949: cascade_Change(p_pre_record => p_Post_record,
950: p_post_record => p_Pre_record,
951: p_apply_record => l_hist_peop_data,
952: p_true_false => l_true_false);
950: p_post_record => p_Pre_record,
951: p_apply_record => l_hist_peop_data,
952: p_true_false => l_true_false);
953: else
954: hr_utility.set_location( l_proc, 80);
955: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
956: hr_utility.raise_error;
957: -- raise error /* Unknown type */
958: end if;
951: p_apply_record => l_hist_peop_data,
952: p_true_false => l_true_false);
953: else
954: hr_utility.set_location( l_proc, 80);
955: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
956: hr_utility.raise_error;
957: -- raise error /* Unknown type */
958: end if;
959:
952: p_true_false => l_true_false);
953: else
954: hr_utility.set_location( l_proc, 80);
955: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
956: hr_utility.raise_error;
957: -- raise error /* Unknown type */
958: end if;
959:
960: -- As a column value
959:
960: -- As a column value
961: l_stop := Stop_cascade(l_true_false);
962: if not l_stop then
963: hr_utility.set_location( l_proc || ' exit loop ', 90);
964: exit;
965: else
966: hr_utility.set_location( l_proc, 100);
967: ghr_history_conv_rg.conv_to_people_rg(
962: if not l_stop then
963: hr_utility.set_location( l_proc || ' exit loop ', 90);
964: exit;
965: else
966: hr_utility.set_location( l_proc, 100);
967: ghr_history_conv_rg.conv_to_people_rg(
968: p_people_data => l_people_data,
969: p_history_data => l_hist_peop_data);
970: correct_people_row( p_people_data => l_people_data);
969: p_history_data => l_hist_peop_data);
970: correct_people_row( p_people_data => l_people_data);
971: end if;
972: end loop;
973: hr_utility.set_location( l_proc, 200);
974: close c_people;
975: End;
976:
977: -- ---------------------------------------------------------------------------
1036: assignment_id = c_asgn_id;
1037:
1038: Begin
1039:
1040: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1041: For rowno in 4..101 loop
1042: l_true_false(rowno) := TRUE;
1043: End loop;
1044: hr_utility.set_location( l_proc, 15);
1040: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1041: For rowno in 4..101 loop
1042: l_true_false(rowno) := TRUE;
1043: End loop;
1044: hr_utility.set_location( l_proc, 15);
1045: if p_interv_on_eff_date then
1046: -- This is to take care of multiple actions on the same date.
1047: -- When a correction is made to a SF52 and other process had
1048: -- updated the same row on the same date, the data in the
1050: -- granularity of a day, and not date and time. So, this will
1051: -- re-apply the data from history for the effective date of the current action to the
1052: -- core table. This will insure that the core table will contain the correct information
1053: -- in all cases.
1054: hr_utility.set_location( l_proc, 20);
1055:
1056: ghr_history_conv_rg.Conv_to_asgn_rg(
1057: p_assignment_data => l_asgn_data,
1058: p_history_data => p_hist_data_as_of_date);
1057: p_assignment_data => l_asgn_data,
1058: p_history_data => p_hist_data_as_of_date);
1059:
1060: correct_asgn_row( p_asgn_data => l_asgn_data);
1061: hr_utility.set_location( l_proc, 30);
1062: elsif (lower(p_cascade_type) = 'cancel') then
1063: -- if this is a cancellation and there are no intervening rows on this effective date,
1064: -- then apply the pre-record to the core people table for this effective date.
1065: hr_utility.set_location( l_proc, 35);
1061: hr_utility.set_location( l_proc, 30);
1062: elsif (lower(p_cascade_type) = 'cancel') then
1063: -- if this is a cancellation and there are no intervening rows on this effective date,
1064: -- then apply the pre-record to the core people table for this effective date.
1065: hr_utility.set_location( l_proc, 35);
1066: ghr_history_conv_rg.Conv_to_asgn_rg(
1067: p_assignment_data => l_asgn_data,
1068: p_history_data => p_pre_record);
1069: correct_asgn_row( p_asgn_data => l_asgn_data);
1068: p_history_data => p_pre_record);
1069: correct_asgn_row( p_asgn_data => l_asgn_data);
1070: end if;
1071:
1072: hr_utility.set_location( l_proc, 40);
1073: -- Fetch all the following rows.
1074: open c_asgn( p_post_record.effective_date, to_number(p_post_record.information1));
1075: while true
1076: Loop
1073: -- Fetch all the following rows.
1074: open c_asgn( p_post_record.effective_date, to_number(p_post_record.information1));
1075: while true
1076: Loop
1077: hr_utility.set_location( l_proc, 50);
1078: fetch c_asgn into l_asgn_data;
1079: exit when not c_asgn%found;
1080:
1081: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
1082: p_assignment_data => l_asgn_data,
1083: p_history_data => l_hist_asgn_data);
1084:
1085: if lower(p_cascade_Type) = 'retroactive' then
1086: hr_utility.set_location( l_proc, 60);
1087: -- for retroactive action post-record values have to be cascaded
1088: -- whereever pre-record values exist.
1089: cascade_Change(p_pre_record => p_Pre_record,
1090: p_post_record => p_Post_record,
1093:
1094: elsif lower(p_cascade_Type) = 'cancel' then
1095: -- for cancellation action pre-record values have to be cascaded
1096: -- whereever post-record values exist.
1097: hr_utility.set_location( l_proc, 70);
1098: cascade_Change(p_pre_record => p_Post_record,
1099: p_post_record => p_Pre_record,
1100: p_apply_record => l_hist_asgn_data,
1101: p_true_false => l_true_false);
1099: p_post_record => p_Pre_record,
1100: p_apply_record => l_hist_asgn_data,
1101: p_true_false => l_true_false);
1102: else
1103: hr_utility.set_location( l_proc, 80);
1104: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1105: hr_utility.raise_error;
1106: -- raise error /* Unknown type */
1107: end if;
1100: p_apply_record => l_hist_asgn_data,
1101: p_true_false => l_true_false);
1102: else
1103: hr_utility.set_location( l_proc, 80);
1104: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1105: hr_utility.raise_error;
1106: -- raise error /* Unknown type */
1107: end if;
1108:
1101: p_true_false => l_true_false);
1102: else
1103: hr_utility.set_location( l_proc, 80);
1104: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1105: hr_utility.raise_error;
1106: -- raise error /* Unknown type */
1107: end if;
1108:
1109: -- As a column value
1108:
1109: -- As a column value
1110: l_stop := Stop_cascade(l_true_false);
1111: if not l_stop then
1112: hr_utility.set_location( l_proc || ' exit loop ', 90);
1113: exit;
1114: else
1115: hr_utility.set_location( l_proc, 100);
1116: ghr_history_conv_rg.conv_to_asgn_rg(
1111: if not l_stop then
1112: hr_utility.set_location( l_proc || ' exit loop ', 90);
1113: exit;
1114: else
1115: hr_utility.set_location( l_proc, 100);
1116: ghr_history_conv_rg.conv_to_asgn_rg(
1117: p_assignment_data => l_asgn_data,
1118: p_history_data => l_hist_asgn_data);
1119:
1119:
1120: correct_asgn_row( p_asgn_data => l_asgn_data);
1121: end if;
1122: end loop;
1123: hr_utility.set_location( l_proc, 200);
1124: close c_asgn;
1125: End cascade_Asgn;
1126:
1127: -- ---------------------------------------------------------------------------
1169:
1170: Begin
1171:
1172:
1173: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1174: -- This procedure will fetch
1175: -- the most recent record from history and update the database.
1176: hr_utility.set_location( l_proc, 20);
1177: Fetch_most_recent_record(
1172:
1173: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1174: -- This procedure will fetch
1175: -- the most recent record from history and update the database.
1176: hr_utility.set_location( l_proc, 20);
1177: Fetch_most_recent_record(
1178: p_table_name => ghr_history_api.g_peopei_table,
1179: p_table_pk_id => p_post_record.information1,
1180: p_person_id => p_post_record.person_id,
1182: p_result_code => l_result_code);
1183: if l_result_code = 'not_found' then
1184: -- this should never be the case
1185: -- raise error.
1186: hr_utility.set_location( l_proc, 30);
1187: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1188: hr_utility.raise_error;
1189: else
1190: hr_utility.set_location( l_proc, 40);
1183: if l_result_code = 'not_found' then
1184: -- this should never be the case
1185: -- raise error.
1186: hr_utility.set_location( l_proc, 30);
1187: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1188: hr_utility.raise_error;
1189: else
1190: hr_utility.set_location( l_proc, 40);
1191: ghr_history_conv_rg.Conv_to_peopleei_rg(
1184: -- this should never be the case
1185: -- raise error.
1186: hr_utility.set_location( l_proc, 30);
1187: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1188: hr_utility.raise_error;
1189: else
1190: hr_utility.set_location( l_proc, 40);
1191: ghr_history_conv_rg.Conv_to_peopleei_rg(
1192: p_people_ei_data => l_peopleei_data,
1186: hr_utility.set_location( l_proc, 30);
1187: hr_utility.set_message(8301, 'GHR_38364_NO_PEOPLE_RECORD');
1188: hr_utility.raise_error;
1189: else
1190: hr_utility.set_location( l_proc, 40);
1191: ghr_history_conv_rg.Conv_to_peopleei_rg(
1192: p_people_ei_data => l_peopleei_data,
1193: p_history_data => l_hist_peopleei_data);
1194: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1190: hr_utility.set_location( l_proc, 40);
1191: ghr_history_conv_rg.Conv_to_peopleei_rg(
1192: p_people_ei_data => l_peopleei_data,
1193: p_history_data => l_hist_peopleei_data);
1194: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1195: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1196: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1197: end if;
1198: hr_utility.set_location( l_proc, 90);
1191: ghr_history_conv_rg.Conv_to_peopleei_rg(
1192: p_people_ei_data => l_peopleei_data,
1193: p_history_data => l_hist_peopleei_data);
1194: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1195: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1196: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1197: end if;
1198: hr_utility.set_location( l_proc, 90);
1199:
1194: hr_utility.set_location( 'l_peopleei_data.person_extra_info_id: ' || l_peopleei_data.person_extra_info_id ||l_proc, 46);
1195: hr_utility.set_location( 'l_peopleei_data.pei_information11: ' || l_peopleei_data.pei_information11 ||l_proc, 47);
1196: correct_peopleei_row( p_peopleei_data => l_peopleei_data);
1197: end if;
1198: hr_utility.set_location( l_proc, 90);
1199:
1200: End cascade_peopleei;
1201:
1202: -- ---------------------------------------------------------------------------
1245:
1246: Begin
1247:
1248:
1249: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1250: -- This procedure will fetch
1251: -- the most recent record from history and update the database.
1252: hr_utility.set_location( l_proc, 20);
1253: Fetch_most_recent_record(
1248:
1249: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1250: -- This procedure will fetch
1251: -- the most recent record from history and update the database.
1252: hr_utility.set_location( l_proc, 20);
1253: Fetch_most_recent_record(
1254: p_table_name => ghr_history_api.g_asgnei_table,
1255: p_table_pk_id => p_post_record.information1,
1256: p_person_id => p_post_record.person_id,
1258: p_result_code => l_result_code);
1259: if l_result_code = 'not_found' then
1260: -- this should never be the case
1261: -- raise error.
1262: hr_utility.set_location( l_proc, 30);
1263: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1264: hr_utility.raise_error;
1265: else
1266: hr_utility.set_location( l_proc, 40);
1259: if l_result_code = 'not_found' then
1260: -- this should never be the case
1261: -- raise error.
1262: hr_utility.set_location( l_proc, 30);
1263: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1264: hr_utility.raise_error;
1265: else
1266: hr_utility.set_location( l_proc, 40);
1267: ghr_history_conv_rg.Conv_to_asgnei_rg(
1260: -- this should never be the case
1261: -- raise error.
1262: hr_utility.set_location( l_proc, 30);
1263: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1264: hr_utility.raise_error;
1265: else
1266: hr_utility.set_location( l_proc, 40);
1267: ghr_history_conv_rg.Conv_to_asgnei_rg(
1268: p_asgnei_data => l_asgnei_data,
1262: hr_utility.set_location( l_proc, 30);
1263: hr_utility.set_message(8301, 'GHR_38365_NO_ASGN_RECORD');
1264: hr_utility.raise_error;
1265: else
1266: hr_utility.set_location( l_proc, 40);
1267: ghr_history_conv_rg.Conv_to_asgnei_rg(
1268: p_asgnei_data => l_asgnei_data,
1269: p_history_data => l_hist_asgnei_data);
1270: correct_asgnei_row( p_asgnei_data => l_asgnei_data);
1268: p_asgnei_data => l_asgnei_data,
1269: p_history_data => l_hist_asgnei_data);
1270: correct_asgnei_row( p_asgnei_data => l_asgnei_data);
1271: end if;
1272: hr_utility.set_location( l_proc, 90);
1273:
1274: End cascade_asgnei;
1275:
1276: -- ---------------------------------------------------------------------------
1316: l_proc varchar2(30):='Cascade_posnei';
1317:
1318: Begin
1319:
1320: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1321: -- This procedure will fetch
1322: -- the most recent record from history and update the database.
1323: hr_utility.set_location( l_proc, 20);
1324: Fetch_most_recent_record(
1319:
1320: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1321: -- This procedure will fetch
1322: -- the most recent record from history and update the database.
1323: hr_utility.set_location( l_proc, 20);
1324: Fetch_most_recent_record(
1325: p_table_name => ghr_history_api.g_posnei_table,
1326: p_table_pk_id => p_post_record.information1,
1327: p_person_id => p_post_record.person_id,
1329: p_result_code => l_result_code);
1330: if l_result_code = 'not_found' then
1331: -- this should never be the case
1332: -- raise error.
1333: hr_utility.set_location( l_proc, 30);
1334: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1335: hr_utility.raise_error;
1336: else
1337: hr_utility.set_location( l_proc, 40);
1330: if l_result_code = 'not_found' then
1331: -- this should never be the case
1332: -- raise error.
1333: hr_utility.set_location( l_proc, 30);
1334: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1335: hr_utility.raise_error;
1336: else
1337: hr_utility.set_location( l_proc, 40);
1338: ghr_history_conv_rg.Conv_to_positionei_rg(
1331: -- this should never be the case
1332: -- raise error.
1333: hr_utility.set_location( l_proc, 30);
1334: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1335: hr_utility.raise_error;
1336: else
1337: hr_utility.set_location( l_proc, 40);
1338: ghr_history_conv_rg.Conv_to_positionei_rg(
1339: p_position_ei_data => l_posnei_data,
1333: hr_utility.set_location( l_proc, 30);
1334: hr_utility.set_message(8301, 'GHR_38366_NO_POSNEI_RECORD');
1335: hr_utility.raise_error;
1336: else
1337: hr_utility.set_location( l_proc, 40);
1338: ghr_history_conv_rg.Conv_to_positionei_rg(
1339: p_position_ei_data => l_posnei_data,
1340: p_history_data => l_hist_posnei_data);
1341: correct_posnei_row( p_posnei_data => l_posnei_data);
1339: p_position_ei_data => l_posnei_data,
1340: p_history_data => l_hist_posnei_data);
1341: correct_posnei_row( p_posnei_data => l_posnei_data);
1342: end if;
1343: hr_utility.set_location( l_proc, 90);
1344:
1345: End cascade_posnei;
1346:
1347: /*
1388: l_proc varchar2(30):='Cascade_posn';
1389:
1390: Begin
1391:
1392: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1393: -- This procedure will fetch
1394: -- the most recent record from history and update the database.
1395: hr_utility.set_location( l_proc, 20);
1396: Fetch_most_recent_record(
1391:
1392: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1393: -- This procedure will fetch
1394: -- the most recent record from history and update the database.
1395: hr_utility.set_location( l_proc, 20);
1396: Fetch_most_recent_record(
1397: p_table_name => ghr_history_api.g_posn_table,
1398: p_table_pk_id => p_post_record.information1,
1399: p_person_id => p_post_record.person_id,
1401: p_result_code => l_result_code);
1402: if l_result_code = 'not_found' then
1403: -- this should never be the case
1404: -- raise error.
1405: hr_utility.set_location( l_proc, 30);
1406: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1407: hr_utility.raise_error;
1408: else
1409: hr_utility.set_location( l_proc, 40);
1402: if l_result_code = 'not_found' then
1403: -- this should never be the case
1404: -- raise error.
1405: hr_utility.set_location( l_proc, 30);
1406: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1407: hr_utility.raise_error;
1408: else
1409: hr_utility.set_location( l_proc, 40);
1410: ghr_history_conv_rg.Conv_to_position_rg(
1403: -- this should never be the case
1404: -- raise error.
1405: hr_utility.set_location( l_proc, 30);
1406: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1407: hr_utility.raise_error;
1408: else
1409: hr_utility.set_location( l_proc, 40);
1410: ghr_history_conv_rg.Conv_to_position_rg(
1411: p_position_data => l_posn_data,
1405: hr_utility.set_location( l_proc, 30);
1406: hr_utility.set_message(8301, 'GHR_38491_NO_POSN_RECORD');
1407: hr_utility.raise_error;
1408: else
1409: hr_utility.set_location( l_proc, 40);
1410: ghr_history_conv_rg.Conv_to_position_rg(
1411: p_position_data => l_posn_data,
1412: p_history_data => l_hist_posn_data);
1413:
1412: p_history_data => l_hist_posn_data);
1413:
1414: correct_posn_row( p_posn_data => l_posn_data);
1415: end if;
1416: hr_utility.set_location( l_proc, 90);
1417:
1418: End cascade_posn;
1419: */
1420:
1481: position_id = c_posn_id;
1482:
1483: Begin
1484:
1485: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1486: For rowno in 4..101 loop
1487: l_true_false(rowno) := TRUE;
1488: End loop;
1489: hr_utility.set_location( l_proc, 15);
1485: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1486: For rowno in 4..101 loop
1487: l_true_false(rowno) := TRUE;
1488: End loop;
1489: hr_utility.set_location( l_proc, 15);
1490: if p_interv_on_eff_date then
1491: -- This is to take care of multiple actions on the same date.
1492: -- When a correction is made to a SF52 and other process had
1493: -- updated the same row on the same date, the data in the
1495: -- granularity of a day, and not date and time. So, this will
1496: -- re-apply the data from history for the effective date of the current action to the
1497: -- core table. This will insure that the core table will contain the correct information
1498: -- in all cases.
1499: hr_utility.set_location( l_proc, 20);
1500:
1501: ghr_history_conv_rg.Conv_to_position_rg(
1502: p_position_data => l_posn_data,
1503: p_history_data => p_hist_data_as_of_date);
1502: p_position_data => l_posn_data,
1503: p_history_data => p_hist_data_as_of_date);
1504:
1505: correct_posn_row( p_posn_data => l_posn_data);
1506: hr_utility.set_location( l_proc, 30);
1507: elsif (lower(p_cascade_type) = 'cancel') then
1508: -- if this is a cancellation and there are no intervening rows on this effective date,
1509: -- then apply the pre-record to the core people table for this effective date.
1510: hr_utility.set_location( l_proc, 35);
1506: hr_utility.set_location( l_proc, 30);
1507: elsif (lower(p_cascade_type) = 'cancel') then
1508: -- if this is a cancellation and there are no intervening rows on this effective date,
1509: -- then apply the pre-record to the core people table for this effective date.
1510: hr_utility.set_location( l_proc, 35);
1511: ghr_history_conv_rg.Conv_to_position_rg(
1512: p_position_data => l_posn_data,
1513: p_history_data => p_pre_record);
1514: correct_posn_row( p_posn_data => l_posn_data);
1513: p_history_data => p_pre_record);
1514: correct_posn_row( p_posn_data => l_posn_data);
1515: end if;
1516:
1517: hr_utility.set_location( l_proc, 40);
1518: -- Fetch all the following rows.
1519: open c_posn( p_post_record.effective_date, to_number(p_post_record.information1));
1520: while true
1521: Loop
1518: -- Fetch all the following rows.
1519: open c_posn( p_post_record.effective_date, to_number(p_post_record.information1));
1520: while true
1521: Loop
1522: hr_utility.set_location( l_proc, 50);
1523: fetch c_posn into l_posn_data;
1524: exit when not c_posn%found;
1525:
1526: ghr_history_conv_rg.conv_position_rg_to_hist_rg(
1527: p_position_data => l_posn_data,
1528: p_history_data => l_hist_posn_data);
1529:
1530: if lower(p_cascade_Type) = 'retroactive' then
1531: hr_utility.set_location( l_proc, 60);
1532: -- for retroactive action post-record values have to be cascaded
1533: -- whereever pre-record values exist.
1534: cascade_Change(p_pre_record => p_Pre_record,
1535: p_post_record => p_Post_record,
1538:
1539: elsif lower(p_cascade_Type) = 'cancel' then
1540: -- for cancellation action pre-record values have to be cascaded
1541: -- whereever post-record values exist.
1542: hr_utility.set_location( l_proc, 70);
1543: cascade_Change(p_pre_record => p_Post_record,
1544: p_post_record => p_Pre_record,
1545: p_apply_record => l_hist_posn_data,
1546: p_true_false => l_true_false);
1544: p_post_record => p_Pre_record,
1545: p_apply_record => l_hist_posn_data,
1546: p_true_false => l_true_false);
1547: else
1548: hr_utility.set_location( l_proc, 80);
1549: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1550: hr_utility.raise_error;
1551: -- raise error /* Unknown type */
1552: end if;
1545: p_apply_record => l_hist_posn_data,
1546: p_true_false => l_true_false);
1547: else
1548: hr_utility.set_location( l_proc, 80);
1549: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1550: hr_utility.raise_error;
1551: -- raise error /* Unknown type */
1552: end if;
1553:
1546: p_true_false => l_true_false);
1547: else
1548: hr_utility.set_location( l_proc, 80);
1549: hr_utility.set_message(8301, 'GHR_38225_UNKNOWN_CASCADE_TYPE');
1550: hr_utility.raise_error;
1551: -- raise error /* Unknown type */
1552: end if;
1553:
1554: -- As a column value
1553:
1554: -- As a column value
1555: l_stop := Stop_cascade(l_true_false);
1556: if not l_stop then
1557: hr_utility.set_location( l_proc || ' exit loop ', 90);
1558: exit;
1559: else
1560: hr_utility.set_location( l_proc, 100);
1561: ghr_history_conv_rg.conv_to_position_rg(
1556: if not l_stop then
1557: hr_utility.set_location( l_proc || ' exit loop ', 90);
1558: exit;
1559: else
1560: hr_utility.set_location( l_proc, 100);
1561: ghr_history_conv_rg.conv_to_position_rg(
1562: p_position_data => l_posn_data,
1563: p_history_data => l_hist_posn_data);
1564:
1564:
1565: correct_posn_row( p_posn_data => l_posn_data);
1566: end if;
1567: end loop;
1568: hr_utility.set_location( l_proc, 200);
1569: close c_posn;
1570: End cascade_posn;
1571:
1572: -- ---------------------------------------------------------------------------
1613:
1614: Begin
1615:
1616:
1617: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1618: -- This procedure will fetch
1619: -- the most recent record from history and update the database.
1620: hr_utility.set_location( l_proc, 20);
1621: Fetch_most_recent_record(
1616:
1617: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1618: -- This procedure will fetch
1619: -- the most recent record from history and update the database.
1620: hr_utility.set_location( l_proc, 20);
1621: Fetch_most_recent_record(
1622: p_table_name => ghr_history_api.g_addres_table,
1623: p_table_pk_id => p_post_record.information1,
1624: p_person_id => p_post_record.person_id,
1626: p_result_code => l_result_code);
1627: if l_result_code = 'not_found' then
1628: -- this should never be the case
1629: -- raise error.
1630: hr_utility.set_location( l_proc, 30);
1631: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1632: hr_utility.raise_error;
1633: else
1634: hr_utility.set_location( l_proc, 40);
1627: if l_result_code = 'not_found' then
1628: -- this should never be the case
1629: -- raise error.
1630: hr_utility.set_location( l_proc, 30);
1631: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1632: hr_utility.raise_error;
1633: else
1634: hr_utility.set_location( l_proc, 40);
1635: ghr_history_conv_rg.Conv_to_addresses_rg(
1628: -- this should never be the case
1629: -- raise error.
1630: hr_utility.set_location( l_proc, 30);
1631: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1632: hr_utility.raise_error;
1633: else
1634: hr_utility.set_location( l_proc, 40);
1635: ghr_history_conv_rg.Conv_to_addresses_rg(
1636: p_addresses_data => l_addresses_data,
1630: hr_utility.set_location( l_proc, 30);
1631: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1632: hr_utility.raise_error;
1633: else
1634: hr_utility.set_location( l_proc, 40);
1635: ghr_history_conv_rg.Conv_to_addresses_rg(
1636: p_addresses_data => l_addresses_data,
1637: p_history_data => l_hist_addresses_data);
1638: correct_addresses_row( p_addr_data => l_addresses_data);
1636: p_addresses_data => l_addresses_data,
1637: p_history_data => l_hist_addresses_data);
1638: correct_addresses_row( p_addr_data => l_addresses_data);
1639: end if;
1640: hr_utility.set_location( l_proc, 90);
1641: End cascade_addresses;
1642:
1643: -- ---------------------------------------------------------------------------
1644: -- |--------------------------< cascade_perana>-------------------------------|
1684:
1685: Begin
1686:
1687:
1688: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1689: -- This procedure will fetch
1690: -- the most recent record from history and update the database.
1691: hr_utility.set_location( l_proc, 20);
1692: Fetch_most_recent_record(
1687:
1688: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1689: -- This procedure will fetch
1690: -- the most recent record from history and update the database.
1691: hr_utility.set_location( l_proc, 20);
1692: Fetch_most_recent_record(
1693: p_table_name => ghr_history_api.g_perana_table,
1694: p_table_pk_id => p_post_record.information1,
1695: p_person_id => p_post_record.person_id,
1697: p_result_code => l_result_code);
1698: if l_result_code = 'not_found' then
1699: -- this should never be the case
1700: -- raise error.
1701: hr_utility.set_location( l_proc, 30);
1702: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1703: hr_utility.raise_error;
1704: else
1705: hr_utility.set_location( l_proc, 40);
1698: if l_result_code = 'not_found' then
1699: -- this should never be the case
1700: -- raise error.
1701: hr_utility.set_location( l_proc, 30);
1702: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1703: hr_utility.raise_error;
1704: else
1705: hr_utility.set_location( l_proc, 40);
1706: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1699: -- this should never be the case
1700: -- raise error.
1701: hr_utility.set_location( l_proc, 30);
1702: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1703: hr_utility.raise_error;
1704: else
1705: hr_utility.set_location( l_proc, 40);
1706: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1707: p_peranalyses_data => l_perana_data,
1701: hr_utility.set_location( l_proc, 30);
1702: hr_utility.set_message(8301, 'GHR_38367_NO_ADDRESS_RECORD');
1703: hr_utility.raise_error;
1704: else
1705: hr_utility.set_location( l_proc, 40);
1706: ghr_history_conv_rg.Conv_to_peranalyses_rg(
1707: p_peranalyses_data => l_perana_data,
1708: p_history_data => l_hist_perana_data);
1709: correct_perana_row( p_perana_data => l_perana_data);
1707: p_peranalyses_data => l_perana_data,
1708: p_history_data => l_hist_perana_data);
1709: correct_perana_row( p_perana_data => l_perana_data);
1710: end if;
1711: hr_utility.set_location( l_proc, 90);
1712: End cascade_perana;
1713:
1714: -- ---------------------------------------------------------------------------
1715: -- |--------------------------< correct_people_row>---------------------------|
1763: l_date1 per_all_people_f.effective_start_date%type;
1764:
1765: Begin
1766:
1767: hr_utility.set_location( 'Entering : ' || l_proc, 10);
1768: -- Initialise Local Variables
1769: l_people_data:=p_people_data;
1770: --
1771: open c_people_getovn( cp_person_id => p_people_data.person_id,
1773: cp_eff_end_dt => p_people_data.effective_end_date );
1774: Fetch c_people_getovn into p_people_data.object_version_number;
1775: if c_people_getovn%notfound then
1776: close c_people_getovn;
1777: hr_utility.set_message(8301, 'GHR_38368_PEOPLE_OVN_NFND');
1778: hr_utility.raise_error;
1779: else
1780: close c_people_getovn;
1781: end if;
1774: Fetch c_people_getovn into p_people_data.object_version_number;
1775: if c_people_getovn%notfound then
1776: close c_people_getovn;
1777: hr_utility.set_message(8301, 'GHR_38368_PEOPLE_OVN_NFND');
1778: hr_utility.raise_error;
1779: else
1780: close c_people_getovn;
1781: end if;
1782: l_date1 := p_people_data.effective_start_date;
1913: p_orig_hire_warning => l_orig_hire_warning,
1914: p_npw_number => p_people_data.npw_number,
1915: p_current_npw_flag => p_people_data.current_npw_flag
1916: );
1917: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
1918: Exception
1919: When Others then
1920: -- RESET In/Out Params and SET Out Params
1921: p_people_data:=l_people_data;
1918: Exception
1919: When Others then
1920: -- RESET In/Out Params and SET Out Params
1921: p_people_data:=l_people_data;
1922: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
1923: Raise;
1924:
1925: End Correct_people_row;
1926:
1982:
1983: l_proc varchar2(30):='correct_asgn_row';
1984:
1985: Begin
1986: hr_utility.set_location('Entering : ' || l_proc, 10);
1987:
1988: -- Initialise local variables
1989: l_asgn_data:=p_asgn_data;
1990: --
1993: cp_eff_end_dt => p_asgn_data.effective_end_date );
1994: Fetch c_asgn_getovn into p_asgn_data.object_version_number;
1995: if c_asgn_getovn%notfound then
1996: close c_asgn_getovn;
1997: hr_utility.set_message(8301, 'GHR_38369_ASGN_OVN_NFND');
1998: hr_utility.raise_error;
1999: else
2000: close c_asgn_getovn;
2001: end if;
1994: Fetch c_asgn_getovn into p_asgn_data.object_version_number;
1995: if c_asgn_getovn%notfound then
1996: close c_asgn_getovn;
1997: hr_utility.set_message(8301, 'GHR_38369_ASGN_OVN_NFND');
1998: hr_utility.raise_error;
1999: else
2000: close c_asgn_getovn;
2001: end if;
2002:
2095: p_datetrack_mode => l_datetrack_mode ,
2096: p_validate => l_validate
2097: );
2098:
2099: hr_utility.set_location('Leaving : ' || l_proc, 20);
2100: Exception
2101: When Others then
2102: -- RESET In/Out params and SET Out Params
2103: p_asgn_data:=l_asgn_data;
2100: Exception
2101: When Others then
2102: -- RESET In/Out params and SET Out Params
2103: p_asgn_data:=l_asgn_data;
2104: hr_utility.set_location('Leaving : ' || l_proc,25);
2105: Raise;
2106:
2107: End correct_asgn_row;
2108:
2145:
2146: l_peopleei_data per_people_extra_info%rowtype;
2147: l_proc varchar2(30):='correct_peopleei_row';
2148: Begin
2149: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2150: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2151: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2152:
2153: --Initialise Local Variables
2146: l_peopleei_data per_people_extra_info%rowtype;
2147: l_proc varchar2(30):='correct_peopleei_row';
2148: Begin
2149: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2150: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2151: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2152:
2153: --Initialise Local Variables
2154: l_peopleei_data := p_peopleei_data;
2147: l_proc varchar2(30):='correct_peopleei_row';
2148: Begin
2149: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2150: hr_utility.set_location( 'p_peopleei_data.person_extra_info_id : ' || p_peopleei_data.person_extra_info_id || l_proc, 11);
2151: hr_utility.set_location( 'p_peopleei_data.pei_information11 : ' || p_peopleei_data.pei_information11 || l_proc, 12);
2152:
2153: --Initialise Local Variables
2154: l_peopleei_data := p_peopleei_data;
2155: --
2156:
2157: open c_peopleei_getovn( p_peopleei_data.person_extra_info_id );
2158: Fetch c_peopleei_getovn into p_peopleei_data.object_version_number;
2159: if c_peopleei_getovn%notfound then
2160: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2161: close c_peopleei_getovn;
2162: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2163: hr_utility.raise_error;
2164: else
2158: Fetch c_peopleei_getovn into p_peopleei_data.object_version_number;
2159: if c_peopleei_getovn%notfound then
2160: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2161: close c_peopleei_getovn;
2162: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2163: hr_utility.raise_error;
2164: else
2165: close c_peopleei_getovn;
2166: end if;
2159: if c_peopleei_getovn%notfound then
2160: hr_utility.set_location( 'Entering : ' || l_proc, 11);
2161: close c_peopleei_getovn;
2162: hr_utility.set_message(8301, 'GHR_38370_PEOPLEEI_OVN_NFND');
2163: hr_utility.raise_error;
2164: else
2165: close c_peopleei_getovn;
2166: end if;
2167: pe_pei_upd.upd(
2225: p_pei_information29 => p_peopleei_data.pei_information29 ,
2226: p_pei_information30 => p_peopleei_data.pei_information30 ,
2227: p_object_version_number => p_peopleei_data.object_version_number
2228: );
2229: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2230:
2231: Exception
2232: When Others then
2233: -- RESET In/Out params and SET Out Params
2231: Exception
2232: When Others then
2233: -- RESET In/Out params and SET Out Params
2234: p_peopleei_data:=l_peopleei_data;
2235: hr_utility.set_location('Leaving ' || l_proc,25);
2236: Raise;
2237:
2238: End;
2239:
2279: l_asgnei_data per_assignment_extra_info%rowtype;
2280: l_proc varchar2(30):='Correct_asgnei_Row';
2281:
2282: Begin
2283: hr_utility.set_location( 'Entering : ' || l_proc, 20);
2284: -- Initialise Local variables
2285: l_asgnei_data := p_asgnei_data;
2286: --
2287: open c_asgnei_getovn( p_asgnei_data.assignment_extra_info_id );
2288: Fetch c_asgnei_getovn into p_asgnei_data.object_version_number;
2289: if c_asgnei_getovn%notfound then
2290: close c_asgnei_getovn;
2291: -- raise error
2292: hr_utility.set_message(8301, 'GHR_38371_ASGNEI_OVN_NFND');
2293: hr_utility.raise_error;
2294: else
2295: close c_asgnei_getovn;
2296: end if;
2289: if c_asgnei_getovn%notfound then
2290: close c_asgnei_getovn;
2291: -- raise error
2292: hr_utility.set_message(8301, 'GHR_38371_ASGNEI_OVN_NFND');
2293: hr_utility.raise_error;
2294: else
2295: close c_asgnei_getovn;
2296: end if;
2297: pe_aei_upd.upd(
2353: p_aei_information29 => p_asgnei_data.aei_information29 ,
2354: p_aei_information30 => p_asgnei_data.aei_information30 ,
2355: p_object_version_number => p_asgnei_data.object_version_number
2356: );
2357: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2358: Exception
2359: When Others then
2360: -- RESET In/Out Params and SET Out params
2361: p_asgnei_data:=l_asgnei_data;
2358: Exception
2359: When Others then
2360: -- RESET In/Out Params and SET Out params
2361: p_asgnei_data:=l_asgnei_data;
2362: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2363: Raise;
2364:
2365: End;
2366:
2405: l_posnei_data per_position_extra_info%rowtype;
2406: l_proc varchar2(30):='Correct_posnei_Row';
2407:
2408: Begin
2409: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2410: -- Initialise Local Variables
2411: l_posnei_data := p_posnei_data;
2412: --
2413: open c_posnei_getovn( p_posnei_data.position_extra_info_id );
2414: Fetch c_posnei_getovn into p_posnei_data.object_version_number;
2415: if c_posnei_getovn%notfound then
2416: close c_posnei_getovn;
2417: -- raise error
2418: hr_utility.set_message(8301, 'GHR_38372_POSNEI_OVN_NFND');
2419: hr_utility.raise_error;
2420: else
2421: close c_posnei_getovn;
2422: end if;
2415: if c_posnei_getovn%notfound then
2416: close c_posnei_getovn;
2417: -- raise error
2418: hr_utility.set_message(8301, 'GHR_38372_POSNEI_OVN_NFND');
2419: hr_utility.raise_error;
2420: else
2421: close c_posnei_getovn;
2422: end if;
2423: pe_poi_upd.upd(
2480: p_poei_information30 => p_posnei_data.poei_information30 ,
2481: p_object_version_number => p_posnei_data.object_version_number
2482: );
2483:
2484: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2485:
2486: Exception
2487: When Others then
2488: -- RESET In/Out params and SET Out params
2486: Exception
2487: When Others then
2488: -- RESET In/Out params and SET Out params
2489: p_posnei_data:=l_posnei_data;
2490: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2491: Raise;
2492: End Correct_posnei_Row;
2493:
2494: -- ---------------------------------------------------------------------------
2538: l_datetrack_mode varchar2(30):=hr_api.g_correction;
2539: l_date2 hr_all_positions_f.effective_start_date%type;
2540:
2541: Begin
2542: hr_utility.set_location( 'Entering : ' || l_proc, 10);
2543: --Initialise Local Variables
2544: l_posn_data := p_posn_data;
2545: --
2546:
2550: Fetch c_posn_getovn into p_posn_data.object_version_number;
2551: if c_posn_getovn%notfound then
2552: close c_posn_getovn;
2553: -- raise error
2554: hr_utility.set_message(8301, 'GHR_38492_POSN_OVN_NFND');
2555: hr_utility.raise_error;
2556: else
2557: close c_posn_getovn;
2558: end if;
2551: if c_posn_getovn%notfound then
2552: close c_posn_getovn;
2553: -- raise error
2554: hr_utility.set_message(8301, 'GHR_38492_POSN_OVN_NFND');
2555: hr_utility.raise_error;
2556: else
2557: close c_posn_getovn;
2558: end if;
2559: l_date2 := p_posn_data.effective_start_date;
2696: -- l_position_data_rec.effective_date := p_posn_data.effective_start_date;
2697: -- Changes made by Venkat 30-JAN-2003 for No Copy Changes
2698: -- Assigning l_date1 instaed of p_posn_data.effective_start date because of nocopy changes
2699: l_position_data_rec.effective_date := l_date2;
2700: hr_utility.set_location(l_proc || 'change in data element-pos ' || p_posn_data.job_id,15);
2701:
2702: ghr_sf52_pos_update.update_position_info
2703: (p_pos_data_rec => l_position_data_rec
2704: );
2702: ghr_sf52_pos_update.update_position_info
2703: (p_pos_data_rec => l_position_data_rec
2704: );
2705:
2706: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
2707: Exception
2708: When Others then
2709: -- RESET In/Out Params and SET Out Params
2710: p_posn_data:=l_posn_data;
2707: Exception
2708: When Others then
2709: -- RESET In/Out Params and SET Out Params
2710: p_posn_data:=l_posn_data;
2711: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
2712: Raise;
2713:
2714: End Correct_posn_Row;
2715:
2754: l_session_var ghr_history_api.g_session_var_type;
2755: l_proc varchar2(30):='correct_addresses_row';
2756:
2757: Begin
2758: hr_utility.set_location(' entering : ' || l_proc, 10);
2759: --Initialise Local Variables
2760: l_addr_data := p_addr_data;
2761: --
2762: ghr_history_api.get_g_session_var( l_session_var);
2759: --Initialise Local Variables
2760: l_addr_data := p_addr_data;
2761: --
2762: ghr_history_api.get_g_session_var( l_session_var);
2763: hr_utility.set_location(l_proc, 20);
2764:
2765: open c_addr;
2766: fetch c_addr into p_addr_data.object_version_number;
2767: if c_addr%notfound then
2764:
2765: open c_addr;
2766: fetch c_addr into p_addr_data.object_version_number;
2767: if c_addr%notfound then
2768: hr_utility.set_location(l_proc, 21);
2769: close c_addr;
2770: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2771: hr_utility.raise_error;
2772: end if;
2766: fetch c_addr into p_addr_data.object_version_number;
2767: if c_addr%notfound then
2768: hr_utility.set_location(l_proc, 21);
2769: close c_addr;
2770: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2771: hr_utility.raise_error;
2772: end if;
2773: close c_addr;
2774: hr_utility.set_location(l_proc, 30);
2767: if c_addr%notfound then
2768: hr_utility.set_location(l_proc, 21);
2769: close c_addr;
2770: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2771: hr_utility.raise_error;
2772: end if;
2773: close c_addr;
2774: hr_utility.set_location(l_proc, 30);
2775:
2770: hr_utility.set_message(8301, 'GHR_38373_ADDRESS_OVN_NFND');
2771: hr_utility.raise_error;
2772: end if;
2773: close c_addr;
2774: hr_utility.set_location(l_proc, 30);
2775:
2776: per_add_upd.upd(
2777: p_address_id => p_addr_data.address_id ,
2778: p_date_from => p_addr_data.date_from ,
2792: p_telephone_number_3 => p_addr_data.telephone_number_3 ,
2793: p_town_or_city => p_addr_data.town_or_city ,
2794: p_object_version_number => p_addr_data.object_version_number ,
2795: p_effective_date => l_session_var.date_effective);
2796: hr_utility.set_location(' leaving : ' || l_proc, 40);
2797:
2798: Exception
2799: When Others then
2800: --RESET In/Out Params and SET Out Params
2798: Exception
2799: When Others then
2800: --RESET In/Out Params and SET Out Params
2801: p_addr_data:=l_addr_data;
2802: hr_utility.set_location( 'Leaving : ' || l_proc, 45);
2803: Raise;
2804:
2805: End correct_addresses_row;
2806:
2845: l_session_var ghr_history_api.g_session_var_type;
2846: l_proc varchar2(30):='correct_perana_row';
2847:
2848: Begin
2849: hr_utility.set_location(' entering : ' || l_proc, 10);
2850: -- Initialise Local Variables
2851: l_perana_data := p_perana_data;
2852: --
2853:
2851: l_perana_data := p_perana_data;
2852: --
2853:
2854: ghr_history_api.get_g_session_var( l_session_var);
2855: hr_utility.set_location(l_proc, 20);
2856:
2857: open c_perana;
2858: fetch c_perana into p_perana_data.object_version_number;
2859: if c_perana%notfound then
2856:
2857: open c_perana;
2858: fetch c_perana into p_perana_data.object_version_number;
2859: if c_perana%notfound then
2860: hr_utility.set_location(l_proc, 21);
2861: close c_perana;
2862: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2863: hr_utility.raise_error;
2864: end if;
2858: fetch c_perana into p_perana_data.object_version_number;
2859: if c_perana%notfound then
2860: hr_utility.set_location(l_proc, 21);
2861: close c_perana;
2862: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2863: hr_utility.raise_error;
2864: end if;
2865: close c_perana;
2866: hr_utility.set_location(l_proc, 30);
2859: if c_perana%notfound then
2860: hr_utility.set_location(l_proc, 21);
2861: close c_perana;
2862: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2863: hr_utility.raise_error;
2864: end if;
2865: close c_perana;
2866: hr_utility.set_location(l_proc, 30);
2867:
2862: hr_utility.set_message(8301, 'GHR_99999_PERANA_OVN_NFND');
2863: hr_utility.raise_error;
2864: end if;
2865: close c_perana;
2866: hr_utility.set_location(l_proc, 30);
2867:
2868: per_pea_upd.upd(
2869: p_person_analysis_id => p_perana_data.person_analysis_id,
2870: p_analysis_criteria_id => p_perana_data.analysis_criteria_id,
2895: p_attribute20 => p_perana_data.attribute20,
2896: p_object_version_number => p_perana_data.object_version_number
2897: );
2898:
2899: hr_utility.set_location(' leaving : ' || l_proc, 40);
2900:
2901: Exception
2902: When Others then
2903: --RESET In/Out Params and SET Out Params
2901: Exception
2902: When Others then
2903: --RESET In/Out Params and SET Out Params
2904: p_perana_data:=l_perana_data;
2905: hr_utility.set_location( 'Leaving : ' || l_proc, 45);
2906: Raise;
2907:
2908: End correct_perana_row;
2909:
2952: l_true_false ghr_history_cascade.condition_rg_type;
2953: l_proc varchar2(72) := 'cascade_change';
2954:
2955: Begin
2956: hr_utility.set_location('Entering ' || l_proc,5);
2957: --Initialise Local variables
2958: l_apply_record:=p_apply_record;
2959: l_true_false:=p_true_false;
2960: --
2962: -- Information1, Information2 and Information3 will not be cascaded as it is reserved for
2963: -- Table Primary Key, effective_start_date and Effective_end_date respectively
2964:
2965: -- Bug 1161542
2966: /* hr_utility.set_location(l_proc,10);
2967: cascade_field_value
2968: (p_pre_field => p_pre_record.information4,
2969: p_post_field => p_post_record.information4,
2970: p_apply_field => p_apply_record.information4,
2970: p_apply_field => p_apply_record.information4,
2971: p_result => p_true_false(4)
2972: );
2973:
2974: hr_utility.set_location(l_proc,15);
2975: cascade_field_value
2976: (p_pre_field => p_pre_record.information5,
2977: p_post_field => p_post_record.information5,
2978: p_apply_field => p_apply_record.information5,
2978: p_apply_field => p_apply_record.information5,
2979: p_result => p_true_false(5)
2980: );
2981:
2982: hr_utility.set_location(l_proc,20);
2983: cascade_field_value
2984: (p_pre_field => p_pre_record.information6,
2985: p_post_field => p_post_record.information6,
2986: p_apply_field => p_apply_record.information6,
2986: p_apply_field => p_apply_record.information6,
2987: p_result => p_true_false(6)
2988: ); */ -- Bug 1161542
2989:
2990: hr_utility.set_location(l_proc,25);
2991: ---Added for Bug 3413335
2992: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
2993: hr_utility.set_location(l_proc,34);
2994: cascade_field_value
2989:
2990: hr_utility.set_location(l_proc,25);
2991: ---Added for Bug 3413335
2992: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
2993: hr_utility.set_location(l_proc,34);
2994: cascade_field_value
2995: (p_pre_field => p_pre_record.information7,
2996: p_post_field => p_post_record.information7,
2997: p_apply_field => p_apply_record.information7,
2998: p_result => p_true_false(7)
2999: );
3000: ELSE
3001: IF p_post_record.information11 is not null THEN
3002: hr_utility.set_location(l_proc,36);
3003: cascade_field_value
3004: (p_pre_field => p_pre_record.information7,
3005: p_post_field => p_post_record.information7,
3006: p_apply_field => p_apply_record.information7,
3008: );
3009: END IF;
3010: END IF;
3011:
3012: hr_utility.set_location(l_proc,30);
3013: ---Added for Bug 3413335
3014: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3015: hr_utility.set_location(l_proc,34);
3016: cascade_field_value
3011:
3012: hr_utility.set_location(l_proc,30);
3013: ---Added for Bug 3413335
3014: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3015: hr_utility.set_location(l_proc,34);
3016: cascade_field_value
3017: (p_pre_field => p_pre_record.information8,
3018: p_post_field => p_post_record.information8,
3019: p_apply_field => p_apply_record.information8,
3020: p_result => p_true_false(8)
3021: );
3022: ELSE
3023: IF p_post_record.information11 is not null THEN
3024: hr_utility.set_location(l_proc,36);
3025: cascade_field_value
3026: (p_pre_field => p_pre_record.information8,
3027: p_post_field => p_post_record.information8,
3028: p_apply_field => p_apply_record.information8,
3053: nvl(p_pre_record.information18,hr_api.g_varchar2) = nvl(p_apply_record.information18,hr_api.g_varchar2) and
3054: nvl(p_pre_record.information19,hr_api.g_varchar2) = nvl(p_apply_record.information19,hr_api.g_varchar2) and
3055: nvl(p_pre_record.information23,hr_api.g_varchar2) = nvl(p_apply_record.information23,hr_api.g_varchar2))
3056: then
3057: hr_utility.set_location(l_proc,20);
3058: p_apply_record.information9 := p_post_record.information9;
3059: p_apply_record.information10 := p_post_record.information10;
3060: p_apply_record.information11 := p_post_record.information11;
3061: p_apply_record.information14 := p_post_record.information14;
3076: p_true_false(23) := FALSE;
3077: end if;
3078: end if;
3079: else
3080: hr_utility.set_location(l_proc,35);
3081: ---Added for Bug 3413335
3082: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3083: hr_utility.set_location(l_proc,34);
3084: cascade_field_value
3079: else
3080: hr_utility.set_location(l_proc,35);
3081: ---Added for Bug 3413335
3082: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3083: hr_utility.set_location(l_proc,34);
3084: cascade_field_value
3085: (p_pre_field => p_pre_record.information9,
3086: p_post_field => p_post_record.information9,
3087: p_apply_field => p_apply_record.information9,
3088: p_result => p_true_false(9)
3089: );
3090: ELSE
3091: IF p_post_record.information11 is not null THEN
3092: hr_utility.set_location(l_proc,36);
3093: cascade_field_value
3094: (p_pre_field => p_pre_record.information9,
3095: p_post_field => p_post_record.information9,
3096: p_apply_field => p_apply_record.information9,
3098: );
3099: END IF;
3100: END IF;
3101:
3102: hr_utility.set_location(l_proc,40);
3103: ---Added for Bug 3413335
3104: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3105: hr_utility.set_location(l_proc,44);
3106: cascade_field_value
3101:
3102: hr_utility.set_location(l_proc,40);
3103: ---Added for Bug 3413335
3104: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3105: hr_utility.set_location(l_proc,44);
3106: cascade_field_value
3107: (p_pre_field => p_pre_record.information10,
3108: p_post_field => p_post_record.information10,
3109: p_apply_field => p_apply_record.information10,
3110: p_result => p_true_false(10)
3111: );
3112: ELSE
3113: IF p_post_record.information11 is not null THEN
3114: hr_utility.set_location(l_proc,46);
3115: cascade_field_value
3116: (p_pre_field => p_pre_record.information10,
3117: p_post_field => p_post_record.information10,
3118: p_apply_field => p_apply_record.information10,
3122: END IF;
3123:
3124: -- Start processing for Bug 3413335
3125: IF p_post_record.table_name <> ghr_history_api.g_perana_table THEN
3126: hr_utility.set_location(l_proc,45);
3127: cascade_field_value
3128: (p_pre_field => p_pre_record.information11,
3129: p_post_field => p_post_record.information11,
3130: p_apply_field => p_apply_record.information11,
3131: p_result => p_true_false(11)
3132: );
3133: ELSE
3134: IF p_post_record.information11 is not null THEN
3135: hr_utility.set_location(l_proc,45);
3136: cascade_field_value
3137: (p_pre_field => p_pre_record.information11,
3138: p_post_field => p_post_record.information11,
3139: p_apply_field => p_apply_record.information11,
3142: END IF;
3143: END IF;
3144: -- End processing for Bug 3413335
3145:
3146: hr_utility.set_location(l_proc,60);
3147: cascade_field_value
3148: (p_pre_field => p_pre_record.information14,
3149: p_post_field => p_post_record.information14,
3150: p_apply_field => p_apply_record.information14,
3150: p_apply_field => p_apply_record.information14,
3151: p_result => p_true_false(14)
3152: );
3153:
3154: hr_utility.set_location(l_proc,70);
3155: cascade_field_value
3156: (p_pre_field => p_pre_record.information16,
3157: p_post_field => p_post_record.information16,
3158: p_apply_field => p_apply_record.information16,
3158: p_apply_field => p_apply_record.information16,
3159: p_result => p_true_false(16)
3160: );
3161:
3162: hr_utility.set_location(l_proc,75);
3163: cascade_field_value
3164: (p_pre_field => p_pre_record.information17,
3165: p_post_field => p_post_record.information17,
3166: p_apply_field => p_apply_record.information17,
3166: p_apply_field => p_apply_record.information17,
3167: p_result => p_true_false(17)
3168: );
3169:
3170: hr_utility.set_location(l_proc,80);
3171: cascade_field_value
3172: (p_pre_field => p_pre_record.information18,
3173: p_post_field => p_post_record.information18,
3174: p_apply_field => p_apply_record.information18,
3174: p_apply_field => p_apply_record.information18,
3175: p_result => p_true_false(18)
3176: );
3177:
3178: hr_utility.set_location(l_proc,85);
3179: cascade_field_value
3180: (p_pre_field => p_pre_record.information19,
3181: p_post_field => p_post_record.information19,
3182: p_apply_field => p_apply_record.information19,
3182: p_apply_field => p_apply_record.information19,
3183: p_result => p_true_false(19)
3184: );
3185:
3186: hr_utility.set_location(l_proc,101);
3187: cascade_field_value
3188: (p_pre_field => p_pre_record.information23,
3189: p_post_field => p_post_record.information23,
3190: p_apply_field => p_apply_record.information23,
3190: p_apply_field => p_apply_record.information23,
3191: p_result => p_true_false(23)
3192: );
3193: end if;
3194: hr_utility.set_location(l_proc,50);
3195: cascade_field_value
3196: (p_pre_field => p_pre_record.information12,
3197: p_post_field => p_post_record.information12,
3198: p_apply_field => p_apply_record.information12,
3198: p_apply_field => p_apply_record.information12,
3199: p_result => p_true_false(12)
3200: );
3201:
3202: hr_utility.set_location(l_proc,55);
3203: cascade_field_value
3204: (p_pre_field => p_pre_record.information13,
3205: p_post_field => p_post_record.information13,
3206: p_apply_field => p_apply_record.information13,
3206: p_apply_field => p_apply_record.information13,
3207: p_result => p_true_false(13)
3208: );
3209:
3210: hr_utility.set_location(l_proc,65);
3211: cascade_field_value
3212: (p_pre_field => p_pre_record.information15,
3213: p_post_field => p_post_record.information15,
3214: p_apply_field => p_apply_record.information15,
3214: p_apply_field => p_apply_record.information15,
3215: p_result => p_true_false(15)
3216: );
3217:
3218: hr_utility.set_location(l_proc,90);
3219: cascade_field_value
3220: (p_pre_field => p_pre_record.information20,
3221: p_post_field => p_post_record.information20,
3222: p_apply_field => p_apply_record.information20,
3222: p_apply_field => p_apply_record.information20,
3223: p_result => p_true_false(20)
3224: );
3225:
3226: hr_utility.set_location(l_proc,95);
3227: cascade_field_value
3228: (p_pre_field => p_pre_record.information21,
3229: p_post_field => p_post_record.information21,
3230: p_apply_field => p_apply_record.information21,
3230: p_apply_field => p_apply_record.information21,
3231: p_result => p_true_false(21)
3232: );
3233:
3234: hr_utility.set_location(l_proc,100);
3235: cascade_field_value
3236: (p_pre_field => p_pre_record.information22,
3237: p_post_field => p_post_record.information22,
3238: p_apply_field => p_apply_record.information22,
3238: p_apply_field => p_apply_record.information22,
3239: p_result => p_true_false(22)
3240: );
3241:
3242: hr_utility.set_location(l_proc,102);
3243: cascade_field_value
3244: (p_pre_field => p_pre_record.information24,
3245: p_post_field => p_post_record.information24,
3246: p_apply_field => p_apply_record.information24,
3246: p_apply_field => p_apply_record.information24,
3247: p_result => p_true_false(24)
3248: );
3249:
3250: hr_utility.set_location(l_proc,103);
3251: cascade_field_value
3252: (p_pre_field => p_pre_record.information25,
3253: p_post_field => p_post_record.information25,
3254: p_apply_field => p_apply_record.information25,
3254: p_apply_field => p_apply_record.information25,
3255: p_result => p_true_false(25)
3256: );
3257:
3258: hr_utility.set_location(l_proc,104);
3259: cascade_field_value
3260: (p_pre_field => p_pre_record.information26,
3261: p_post_field => p_post_record.information26,
3262: p_apply_field => p_apply_record.information26,
3262: p_apply_field => p_apply_record.information26,
3263: p_result => p_true_false(26)
3264: );
3265:
3266: hr_utility.set_location(l_proc,105);
3267: cascade_field_value
3268: (p_pre_field => p_pre_record.information27,
3269: p_post_field => p_post_record.information27,
3270: p_apply_field => p_apply_record.information27,
3270: p_apply_field => p_apply_record.information27,
3271: p_result => p_true_false(27)
3272: );
3273:
3274: hr_utility.set_location(l_proc,106);
3275: cascade_field_value
3276: (p_pre_field => p_pre_record.information28,
3277: p_post_field => p_post_record.information28,
3278: p_apply_field => p_apply_record.information28,
3278: p_apply_field => p_apply_record.information28,
3279: p_result => p_true_false(28)
3280: );
3281:
3282: hr_utility.set_location(l_proc,107);
3283: cascade_field_value
3284: (p_pre_field => p_pre_record.information29,
3285: p_post_field => p_post_record.information29,
3286: p_apply_field => p_apply_record.information29,
3286: p_apply_field => p_apply_record.information29,
3287: p_result => p_true_false(29)
3288: );
3289:
3290: hr_utility.set_location(l_proc,108);
3291: cascade_field_value
3292: (p_pre_field => p_pre_record.information30,
3293: p_post_field => p_post_record.information30,
3294: p_apply_field => p_apply_record.information30,
3294: p_apply_field => p_apply_record.information30,
3295: p_result => p_true_false(30)
3296: );
3297:
3298: hr_utility.set_location(l_proc,109);
3299: cascade_field_value
3300: (p_pre_field => p_pre_record.information31,
3301: p_post_field => p_post_record.information31,
3302: p_apply_field => p_apply_record.information31,
3302: p_apply_field => p_apply_record.information31,
3303: p_result => p_true_false(31)
3304: );
3305:
3306: hr_utility.set_location(l_proc,110);
3307: cascade_field_value
3308: (p_pre_field => p_pre_record.information32,
3309: p_post_field => p_post_record.information32,
3310: p_apply_field => p_apply_record.information32,
3310: p_apply_field => p_apply_record.information32,
3311: p_result => p_true_false(32)
3312: );
3313:
3314: hr_utility.set_location(l_proc,111);
3315: cascade_field_value
3316: (p_pre_field => p_pre_record.information33,
3317: p_post_field => p_post_record.information33,
3318: p_apply_field => p_apply_record.information33,
3318: p_apply_field => p_apply_record.information33,
3319: p_result => p_true_false(33)
3320: );
3321:
3322: hr_utility.set_location(l_proc,112);
3323: cascade_field_value
3324: (p_pre_field => p_pre_record.information34,
3325: p_post_field => p_post_record.information34,
3326: p_apply_field => p_apply_record.information34,
3326: p_apply_field => p_apply_record.information34,
3327: p_result => p_true_false(34)
3328: );
3329:
3330: hr_utility.set_location(l_proc,113);
3331: cascade_field_value
3332: (p_pre_field => p_pre_record.information35,
3333: p_post_field => p_post_record.information35,
3334: p_apply_field => p_apply_record.information35,
3334: p_apply_field => p_apply_record.information35,
3335: p_result => p_true_false(35)
3336: );
3337:
3338: hr_utility.set_location(l_proc,114);
3339: cascade_field_value
3340: (p_pre_field => p_pre_record.information36,
3341: p_post_field => p_post_record.information36,
3342: p_apply_field => p_apply_record.information36,
3342: p_apply_field => p_apply_record.information36,
3343: p_result => p_true_false(36)
3344: );
3345:
3346: hr_utility.set_location(l_proc,115);
3347: cascade_field_value
3348: (p_pre_field => p_pre_record.information37,
3349: p_post_field => p_post_record.information37,
3350: p_apply_field => p_apply_record.information37,
3350: p_apply_field => p_apply_record.information37,
3351: p_result => p_true_false(37)
3352: );
3353:
3354: hr_utility.set_location(l_proc,116);
3355: cascade_field_value
3356: (p_pre_field => p_pre_record.information38,
3357: p_post_field => p_post_record.information38,
3358: p_apply_field => p_apply_record.information38,
3358: p_apply_field => p_apply_record.information38,
3359: p_result => p_true_false(38)
3360: );
3361:
3362: hr_utility.set_location(l_proc,117);
3363: cascade_field_value
3364: (p_pre_field => p_pre_record.information39,
3365: p_post_field => p_post_record.information39,
3366: p_apply_field => p_apply_record.information39,
3366: p_apply_field => p_apply_record.information39,
3367: p_result => p_true_false(39)
3368: );
3369:
3370: hr_utility.set_location(l_proc,118);
3371: cascade_field_value
3372: (p_pre_field => p_pre_record.information40,
3373: p_post_field => p_post_record.information40,
3374: p_apply_field => p_apply_record.information40,
3374: p_apply_field => p_apply_record.information40,
3375: p_result => p_true_false(40)
3376: );
3377:
3378: hr_utility.set_location(l_proc,119);
3379: cascade_field_value
3380: (p_pre_field => p_pre_record.information41,
3381: p_post_field => p_post_record.information41,
3382: p_apply_field => p_apply_record.information41,
3382: p_apply_field => p_apply_record.information41,
3383: p_result => p_true_false(41)
3384: );
3385:
3386: hr_utility.set_location(l_proc,120);
3387: cascade_field_value
3388: (p_pre_field => p_pre_record.information42,
3389: p_post_field => p_post_record.information42,
3390: p_apply_field => p_apply_record.information42,
3390: p_apply_field => p_apply_record.information42,
3391: p_result => p_true_false(42)
3392: );
3393:
3394: hr_utility.set_location(l_proc,121);
3395: cascade_field_value
3396: (p_pre_field => p_pre_record.information43,
3397: p_post_field => p_post_record.information43,
3398: p_apply_field => p_apply_record.information43,
3398: p_apply_field => p_apply_record.information43,
3399: p_result => p_true_false(43)
3400: );
3401:
3402: hr_utility.set_location(l_proc,122);
3403: cascade_field_value
3404: (p_pre_field => p_pre_record.information44,
3405: p_post_field => p_post_record.information44,
3406: p_apply_field => p_apply_record.information44,
3406: p_apply_field => p_apply_record.information44,
3407: p_result => p_true_false(44)
3408: );
3409:
3410: hr_utility.set_location(l_proc,123);
3411: cascade_field_value
3412: (p_pre_field => p_pre_record.information45,
3413: p_post_field => p_post_record.information45,
3414: p_apply_field => p_apply_record.information45,
3414: p_apply_field => p_apply_record.information45,
3415: p_result => p_true_false(45)
3416: );
3417:
3418: hr_utility.set_location(l_proc,124);
3419: cascade_field_value
3420: (p_pre_field => p_pre_record.information46,
3421: p_post_field => p_post_record.information46,
3422: p_apply_field => p_apply_record.information46,
3422: p_apply_field => p_apply_record.information46,
3423: p_result => p_true_false(46)
3424: );
3425:
3426: hr_utility.set_location(l_proc,125);
3427: cascade_field_value
3428: (p_pre_field => p_pre_record.information47,
3429: p_post_field => p_post_record.information47,
3430: p_apply_field => p_apply_record.information47,
3430: p_apply_field => p_apply_record.information47,
3431: p_result => p_true_false(47)
3432: );
3433:
3434: hr_utility.set_location(l_proc,126);
3435: cascade_field_value
3436: (p_pre_field => p_pre_record.information48,
3437: p_post_field => p_post_record.information48,
3438: p_apply_field => p_apply_record.information48,
3438: p_apply_field => p_apply_record.information48,
3439: p_result => p_true_false(48)
3440: );
3441:
3442: hr_utility.set_location(l_proc,127);
3443: cascade_field_value
3444: (p_pre_field => p_pre_record.information49,
3445: p_post_field => p_post_record.information49,
3446: p_apply_field => p_apply_record.information49,
3446: p_apply_field => p_apply_record.information49,
3447: p_result => p_true_false(49)
3448: );
3449:
3450: hr_utility.set_location(l_proc,128);
3451: cascade_field_value
3452: (p_pre_field => p_pre_record.information50,
3453: p_post_field => p_post_record.information50,
3454: p_apply_field => p_apply_record.information50,
3454: p_apply_field => p_apply_record.information50,
3455: p_result => p_true_false(50)
3456: );
3457:
3458: hr_utility.set_location(l_proc,129);
3459: cascade_field_value
3460: (p_pre_field => p_pre_record.information51,
3461: p_post_field => p_post_record.information51,
3462: p_apply_field => p_apply_record.information51,
3462: p_apply_field => p_apply_record.information51,
3463: p_result => p_true_false(51)
3464: );
3465:
3466: hr_utility.set_location(l_proc,130);
3467: cascade_field_value
3468: (p_pre_field => p_pre_record.information52,
3469: p_post_field => p_post_record.information52,
3470: p_apply_field => p_apply_record.information52,
3470: p_apply_field => p_apply_record.information52,
3471: p_result => p_true_false(52)
3472: );
3473:
3474: hr_utility.set_location(l_proc,131);
3475: cascade_field_value
3476: (p_pre_field => p_pre_record.information53,
3477: p_post_field => p_post_record.information53,
3478: p_apply_field => p_apply_record.information53,
3478: p_apply_field => p_apply_record.information53,
3479: p_result => p_true_false(53)
3480: );
3481:
3482: hr_utility.set_location(l_proc,132);
3483: cascade_field_value
3484: (p_pre_field => p_pre_record.information54,
3485: p_post_field => p_post_record.information54,
3486: p_apply_field => p_apply_record.information54,
3486: p_apply_field => p_apply_record.information54,
3487: p_result => p_true_false(54)
3488: );
3489:
3490: hr_utility.set_location(l_proc,133);
3491: cascade_field_value
3492: (p_pre_field => p_pre_record.information55,
3493: p_post_field => p_post_record.information55,
3494: p_apply_field => p_apply_record.information55,
3494: p_apply_field => p_apply_record.information55,
3495: p_result => p_true_false(55)
3496: );
3497:
3498: hr_utility.set_location(l_proc,134);
3499: cascade_field_value
3500: (p_pre_field => p_pre_record.information56,
3501: p_post_field => p_post_record.information56,
3502: p_apply_field => p_apply_record.information56,
3502: p_apply_field => p_apply_record.information56,
3503: p_result => p_true_false(56)
3504: );
3505:
3506: hr_utility.set_location(l_proc,135);
3507: cascade_field_value
3508: (p_pre_field => p_pre_record.information57,
3509: p_post_field => p_post_record.information57,
3510: p_apply_field => p_apply_record.information57,
3510: p_apply_field => p_apply_record.information57,
3511: p_result => p_true_false(57)
3512: );
3513:
3514: hr_utility.set_location(l_proc,136);
3515: cascade_field_value
3516: (p_pre_field => p_pre_record.information58,
3517: p_post_field => p_post_record.information58,
3518: p_apply_field => p_apply_record.information58,
3518: p_apply_field => p_apply_record.information58,
3519: p_result => p_true_false(58)
3520: );
3521:
3522: hr_utility.set_location(l_proc,137);
3523: cascade_field_value
3524: (p_pre_field => p_pre_record.information59,
3525: p_post_field => p_post_record.information59,
3526: p_apply_field => p_apply_record.information59,
3526: p_apply_field => p_apply_record.information59,
3527: p_result => p_true_false(59)
3528: );
3529:
3530: hr_utility.set_location(l_proc,138);
3531: cascade_field_value
3532: (p_pre_field => p_pre_record.information60,
3533: p_post_field => p_post_record.information60,
3534: p_apply_field => p_apply_record.information60,
3534: p_apply_field => p_apply_record.information60,
3535: p_result => p_true_false(60)
3536: );
3537:
3538: hr_utility.set_location(l_proc,139);
3539: cascade_field_value
3540: (p_pre_field => p_pre_record.information61,
3541: p_post_field => p_post_record.information61,
3542: p_apply_field => p_apply_record.information61,
3542: p_apply_field => p_apply_record.information61,
3543: p_result => p_true_false(61)
3544: );
3545:
3546: hr_utility.set_location(l_proc,140);
3547: cascade_field_value
3548: (p_pre_field => p_pre_record.information62,
3549: p_post_field => p_post_record.information62,
3550: p_apply_field => p_apply_record.information62,
3550: p_apply_field => p_apply_record.information62,
3551: p_result => p_true_false(62)
3552: );
3553:
3554: hr_utility.set_location(l_proc,141);
3555: cascade_field_value
3556: (p_pre_field => p_pre_record.information63,
3557: p_post_field => p_post_record.information63,
3558: p_apply_field => p_apply_record.information63,
3558: p_apply_field => p_apply_record.information63,
3559: p_result => p_true_false(63)
3560: );
3561:
3562: hr_utility.set_location(l_proc,142);
3563: cascade_field_value
3564: (p_pre_field => p_pre_record.information64,
3565: p_post_field => p_post_record.information64,
3566: p_apply_field => p_apply_record.information64,
3566: p_apply_field => p_apply_record.information64,
3567: p_result => p_true_false(64)
3568: );
3569:
3570: hr_utility.set_location(l_proc,143);
3571: cascade_field_value
3572: (p_pre_field => p_pre_record.information65,
3573: p_post_field => p_post_record.information65,
3574: p_apply_field => p_apply_record.information65,
3574: p_apply_field => p_apply_record.information65,
3575: p_result => p_true_false(65)
3576: );
3577:
3578: hr_utility.set_location(l_proc,144);
3579: cascade_field_value
3580: (p_pre_field => p_pre_record.information66,
3581: p_post_field => p_post_record.information66,
3582: p_apply_field => p_apply_record.information66,
3582: p_apply_field => p_apply_record.information66,
3583: p_result => p_true_false(66)
3584: );
3585:
3586: hr_utility.set_location(l_proc,145);
3587: cascade_field_value
3588: (p_pre_field => p_pre_record.information67,
3589: p_post_field => p_post_record.information67,
3590: p_apply_field => p_apply_record.information67,
3590: p_apply_field => p_apply_record.information67,
3591: p_result => p_true_false(67)
3592: );
3593:
3594: hr_utility.set_location(l_proc,146);
3595: cascade_field_value
3596: (p_pre_field => p_pre_record.information68,
3597: p_post_field => p_post_record.information68,
3598: p_apply_field => p_apply_record.information68,
3598: p_apply_field => p_apply_record.information68,
3599: p_result => p_true_false(68)
3600: );
3601:
3602: hr_utility.set_location(l_proc,147);
3603: cascade_field_value
3604: (p_pre_field => p_pre_record.information69,
3605: p_post_field => p_post_record.information69,
3606: p_apply_field => p_apply_record.information69,
3606: p_apply_field => p_apply_record.information69,
3607: p_result => p_true_false(69)
3608: );
3609:
3610: hr_utility.set_location(l_proc,148);
3611: cascade_field_value
3612: (p_pre_field => p_pre_record.information70,
3613: p_post_field => p_post_record.information70,
3614: p_apply_field => p_apply_record.information70,
3614: p_apply_field => p_apply_record.information70,
3615: p_result => p_true_false(70)
3616: );
3617:
3618: hr_utility.set_location(l_proc,149);
3619: cascade_field_value
3620: (p_pre_field => p_pre_record.information71,
3621: p_post_field => p_post_record.information71,
3622: p_apply_field => p_apply_record.information71,
3622: p_apply_field => p_apply_record.information71,
3623: p_result => p_true_false(71)
3624: );
3625:
3626: hr_utility.set_location(l_proc,150);
3627: cascade_field_value
3628: (p_pre_field => p_pre_record.information72,
3629: p_post_field => p_post_record.information72,
3630: p_apply_field => p_apply_record.information72,
3630: p_apply_field => p_apply_record.information72,
3631: p_result => p_true_false(72)
3632: );
3633:
3634: hr_utility.set_location(l_proc,151);
3635: cascade_field_value
3636: (p_pre_field => p_pre_record.information73,
3637: p_post_field => p_post_record.information73,
3638: p_apply_field => p_apply_record.information73,
3638: p_apply_field => p_apply_record.information73,
3639: p_result => p_true_false(73)
3640: );
3641:
3642: hr_utility.set_location(l_proc,152);
3643: cascade_field_value
3644: (p_pre_field => p_pre_record.information74,
3645: p_post_field => p_post_record.information74,
3646: p_apply_field => p_apply_record.information74,
3646: p_apply_field => p_apply_record.information74,
3647: p_result => p_true_false(74)
3648: );
3649:
3650: hr_utility.set_location(l_proc,153);
3651: cascade_field_value
3652: (p_pre_field => p_pre_record.information75,
3653: p_post_field => p_post_record.information75,
3654: p_apply_field => p_apply_record.information75,
3654: p_apply_field => p_apply_record.information75,
3655: p_result => p_true_false(75)
3656: );
3657:
3658: hr_utility.set_location(l_proc,154);
3659: cascade_field_value
3660: (p_pre_field => p_pre_record.information76,
3661: p_post_field => p_post_record.information76,
3662: p_apply_field => p_apply_record.information76,
3662: p_apply_field => p_apply_record.information76,
3663: p_result => p_true_false(76)
3664: );
3665:
3666: hr_utility.set_location(l_proc,155);
3667: cascade_field_value
3668: (p_pre_field => p_pre_record.information77,
3669: p_post_field => p_post_record.information77,
3670: p_apply_field => p_apply_record.information77,
3670: p_apply_field => p_apply_record.information77,
3671: p_result => p_true_false(77)
3672: );
3673:
3674: hr_utility.set_location(l_proc,156);
3675: cascade_field_value
3676: (p_pre_field => p_pre_record.information78,
3677: p_post_field => p_post_record.information78,
3678: p_apply_field => p_apply_record.information78,
3678: p_apply_field => p_apply_record.information78,
3679: p_result => p_true_false(78)
3680: );
3681:
3682: hr_utility.set_location(l_proc,157);
3683: cascade_field_value
3684: (p_pre_field => p_pre_record.information79,
3685: p_post_field => p_post_record.information79,
3686: p_apply_field => p_apply_record.information79,
3686: p_apply_field => p_apply_record.information79,
3687: p_result => p_true_false(79)
3688: );
3689:
3690: hr_utility.set_location(l_proc,158);
3691: cascade_field_value
3692: (p_pre_field => p_pre_record.information80,
3693: p_post_field => p_post_record.information80,
3694: p_apply_field => p_apply_record.information80,
3694: p_apply_field => p_apply_record.information80,
3695: p_result => p_true_false(80)
3696: );
3697:
3698: hr_utility.set_location(l_proc,159);
3699: cascade_field_value
3700: (p_pre_field => p_pre_record.information81,
3701: p_post_field => p_post_record.information81,
3702: p_apply_field => p_apply_record.information81,
3702: p_apply_field => p_apply_record.information81,
3703: p_result => p_true_false(81)
3704: );
3705:
3706: hr_utility.set_location(l_proc,160);
3707: cascade_field_value
3708: (p_pre_field => p_pre_record.information82,
3709: p_post_field => p_post_record.information82,
3710: p_apply_field => p_apply_record.information82,
3710: p_apply_field => p_apply_record.information82,
3711: p_result => p_true_false(82)
3712: );
3713:
3714: hr_utility.set_location(l_proc,161);
3715: cascade_field_value
3716: (p_pre_field => p_pre_record.information83,
3717: p_post_field => p_post_record.information83,
3718: p_apply_field => p_apply_record.information83,
3718: p_apply_field => p_apply_record.information83,
3719: p_result => p_true_false(83)
3720: );
3721:
3722: hr_utility.set_location(l_proc,162);
3723: cascade_field_value
3724: (p_pre_field => p_pre_record.information84,
3725: p_post_field => p_post_record.information84,
3726: p_apply_field => p_apply_record.information84,
3726: p_apply_field => p_apply_record.information84,
3727: p_result => p_true_false(84)
3728: );
3729:
3730: hr_utility.set_location(l_proc,163);
3731: cascade_field_value
3732: (p_pre_field => p_pre_record.information85,
3733: p_post_field => p_post_record.information85,
3734: p_apply_field => p_apply_record.information85,
3734: p_apply_field => p_apply_record.information85,
3735: p_result => p_true_false(85)
3736: );
3737:
3738: hr_utility.set_location(l_proc,164);
3739: cascade_field_value
3740: (p_pre_field => p_pre_record.information86,
3741: p_post_field => p_post_record.information86,
3742: p_apply_field => p_apply_record.information86,
3742: p_apply_field => p_apply_record.information86,
3743: p_result => p_true_false(86)
3744: );
3745:
3746: hr_utility.set_location(l_proc,165);
3747: cascade_field_value
3748: (p_pre_field => p_pre_record.information87,
3749: p_post_field => p_post_record.information87,
3750: p_apply_field => p_apply_record.information87,
3750: p_apply_field => p_apply_record.information87,
3751: p_result => p_true_false(87)
3752: );
3753:
3754: hr_utility.set_location(l_proc,166);
3755: cascade_field_value
3756: (p_pre_field => p_pre_record.information88,
3757: p_post_field => p_post_record.information88,
3758: p_apply_field => p_apply_record.information88,
3758: p_apply_field => p_apply_record.information88,
3759: p_result => p_true_false(88)
3760: );
3761:
3762: hr_utility.set_location(l_proc,167);
3763: cascade_field_value
3764: (p_pre_field => p_pre_record.information89,
3765: p_post_field => p_post_record.information89,
3766: p_apply_field => p_apply_record.information89,
3766: p_apply_field => p_apply_record.information89,
3767: p_result => p_true_false(89)
3768: );
3769:
3770: hr_utility.set_location(l_proc,168);
3771: cascade_field_value
3772: (p_pre_field => p_pre_record.information90,
3773: p_post_field => p_post_record.information90,
3774: p_apply_field => p_apply_record.information90,
3774: p_apply_field => p_apply_record.information90,
3775: p_result => p_true_false(90)
3776: );
3777:
3778: hr_utility.set_location(l_proc,169);
3779: cascade_field_value
3780: (p_pre_field => p_pre_record.information91,
3781: p_post_field => p_post_record.information91,
3782: p_apply_field => p_apply_record.information91,
3782: p_apply_field => p_apply_record.information91,
3783: p_result => p_true_false(91)
3784: );
3785:
3786: hr_utility.set_location(l_proc,170);
3787: cascade_field_value
3788: (p_pre_field => p_pre_record.information92,
3789: p_post_field => p_post_record.information92,
3790: p_apply_field => p_apply_record.information92,
3790: p_apply_field => p_apply_record.information92,
3791: p_result => p_true_false(92)
3792: );
3793:
3794: hr_utility.set_location(l_proc,171);
3795: cascade_field_value
3796: (p_pre_field => p_pre_record.information93,
3797: p_post_field => p_post_record.information93,
3798: p_apply_field => p_apply_record.information93,
3798: p_apply_field => p_apply_record.information93,
3799: p_result => p_true_false(93)
3800: );
3801:
3802: hr_utility.set_location(l_proc,172);
3803: cascade_field_value
3804: (p_pre_field => p_pre_record.information94,
3805: p_post_field => p_post_record.information94,
3806: p_apply_field => p_apply_record.information94,
3806: p_apply_field => p_apply_record.information94,
3807: p_result => p_true_false(94)
3808: );
3809:
3810: hr_utility.set_location(l_proc,173);
3811: cascade_field_value
3812: (p_pre_field => p_pre_record.information95,
3813: p_post_field => p_post_record.information95,
3814: p_apply_field => p_apply_record.information95,
3814: p_apply_field => p_apply_record.information95,
3815: p_result => p_true_false(95)
3816: );
3817:
3818: hr_utility.set_location(l_proc,174);
3819: cascade_field_value
3820: (p_pre_field => p_pre_record.information96,
3821: p_post_field => p_post_record.information96,
3822: p_apply_field => p_apply_record.information96,
3822: p_apply_field => p_apply_record.information96,
3823: p_result => p_true_false(96)
3824: );
3825:
3826: hr_utility.set_location(l_proc,175);
3827: cascade_field_value
3828: (p_pre_field => p_pre_record.information97,
3829: p_post_field => p_post_record.information97,
3830: p_apply_field => p_apply_record.information97,
3830: p_apply_field => p_apply_record.information97,
3831: p_result => p_true_false(97)
3832: );
3833:
3834: hr_utility.set_location(l_proc,180);
3835: cascade_field_value
3836: (p_pre_field => p_pre_record.information98,
3837: p_post_field => p_post_record.information98,
3838: p_apply_field => p_apply_record.information98,
3838: p_apply_field => p_apply_record.information98,
3839: p_result => p_true_false(98)
3840: );
3841:
3842: hr_utility.set_location(l_proc,181);
3843: cascade_field_value
3844: (p_pre_field => p_pre_record.information99,
3845: p_post_field => p_post_record.information99,
3846: p_apply_field => p_apply_record.information99,
3846: p_apply_field => p_apply_record.information99,
3847: p_result => p_true_false(99)
3848: );
3849:
3850: hr_utility.set_location(l_proc,182);
3851: cascade_field_value
3852: (p_pre_field => p_pre_record.information100,
3853: p_post_field => p_post_record.information100,
3854: p_apply_field => p_apply_record.information100,
3854: p_apply_field => p_apply_record.information100,
3855: p_result => p_true_false(100)
3856: );
3857:
3858: hr_utility.set_location(l_proc,183);
3859: cascade_field_value
3860: (p_pre_field => p_pre_record.information101,
3861: p_post_field => p_post_record.information101,
3862: p_apply_field => p_apply_record.information101,
3861: p_post_field => p_post_record.information101,
3862: p_apply_field => p_apply_record.information101,
3863: p_result => p_true_false(101)
3864: );
3865: hr_utility.set_location('Leaving ' ||l_proc,184);
3866:
3867: -- If information101 is supposed to be cascaded, then information102 thru' information125
3868: -- have to be cascaded as well, because of their dependency on the former.
3869:
3867: -- If information101 is supposed to be cascaded, then information102 thru' information125
3868: -- have to be cascaded as well, because of their dependency on the former.
3869:
3870: If p_true_false(101) then
3871: hr_utility.set_location(l_proc,185);
3872: cascade_dependencies(p_record => p_post_record,
3873: p_apply_record => p_apply_record
3874: );
3875: hr_utility.set_location(l_proc,190);
3871: hr_utility.set_location(l_proc,185);
3872: cascade_dependencies(p_record => p_post_record,
3873: p_apply_record => p_apply_record
3874: );
3875: hr_utility.set_location(l_proc,190);
3876: End if;
3877:
3878: Exception
3879: When Others then
3879: When Others then
3880: --RESET In/Out Params and SET Out Params
3881: p_apply_record:=l_apply_record;
3882: p_true_false:=l_true_false;
3883: hr_utility.set_location('Leaving ' ||l_proc,200);
3884: Raise;
3885:
3886: End cascade_change;
3887:
3942:
3943: -- Proceed only if the column still needs to cascaded. i.e if that column was altered by another SF52, we should
3944: -- stop cascading for that column
3945:
3946: hr_utility.set_location('Entering ' ||l_proc,5);
3947: -- Initialise Local Variables
3948: l_apply_field := p_apply_field;
3949: l_result := p_result;
3950: --
3948: l_apply_field := p_apply_field;
3949: l_result := p_result;
3950: --
3951: If p_result then
3952: hr_utility.set_location(l_proc,10);
3953: -- removed following line in order to allow cascading of null values.
3954: -- If p_post_field is not null then
3955: hr_utility.set_location(l_proc,15);
3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3951: If p_result then
3952: hr_utility.set_location(l_proc,10);
3953: -- removed following line in order to allow cascading of null values.
3954: -- If p_post_field is not null then
3955: hr_utility.set_location(l_proc,15);
3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3957: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3958: hr_utility.set_location(l_proc,20);
3959: p_apply_field := p_post_field;
3954: -- If p_post_field is not null then
3955: hr_utility.set_location(l_proc,15);
3956: If nvl(p_pre_field,hr_api.g_varchar2) <> nvl(p_post_field,hr_api.g_varchar2) and
3957: nvl(p_pre_field,hr_api.g_varchar2) = nvl(p_apply_field,hr_api.g_varchar2) then
3958: hr_utility.set_location(l_proc,20);
3959: p_apply_field := p_post_field;
3960: Else
3961: p_result := FALSE;
3962: end if;
3966: p_result := FALSE;
3967: End if;
3968: */
3969: End if;
3970: hr_utility.set_location('Leaving '|| l_proc,25);
3971: Exception
3972: When Others then
3973: --RESET In/Out Params and SET Out Params
3974: p_apply_field:=l_apply_field;
3972: When Others then
3973: --RESET In/Out Params and SET Out Params
3974: p_apply_field:=l_apply_field;
3975: p_result:=l_result;
3976: hr_utility.set_location('Leaving : '||l_proc,30);
3977: Raise;
3978:
3979: End cascade_field_value;
3980:
4020: Begin
4021: -- If the true_false flags for even one of the columns is TRUE, we have to proceed cascade
4022: -- else if all flags are FALSE, then we can stop cascading.
4023:
4024: hr_utility.set_location('Entering ' || l_proc,5);
4025: For rowno in 7..101 loop -- Bug 1161542 changed 4..101 to 7..101
4026: If p_true_false(rowno) then
4027: hr_utility.set_location(l_proc,10);
4028: l_dummy := TRUE;
4023:
4024: hr_utility.set_location('Entering ' || l_proc,5);
4025: For rowno in 7..101 loop -- Bug 1161542 changed 4..101 to 7..101
4026: If p_true_false(rowno) then
4027: hr_utility.set_location(l_proc,10);
4028: l_dummy := TRUE;
4029: exit;
4030: End if;
4031: hr_utility.set_location(l_proc,15);
4027: hr_utility.set_location(l_proc,10);
4028: l_dummy := TRUE;
4029: exit;
4030: End if;
4031: hr_utility.set_location(l_proc,15);
4032: End loop;
4033: hr_utility.set_location(l_proc,20);
4034: Return l_dummy;
4035: hr_utility.set_location(l_proc,25);
4029: exit;
4030: End if;
4031: hr_utility.set_location(l_proc,15);
4032: End loop;
4033: hr_utility.set_location(l_proc,20);
4034: Return l_dummy;
4035: hr_utility.set_location(l_proc,25);
4036: End stop_cascade;
4037:
4031: hr_utility.set_location(l_proc,15);
4032: End loop;
4033: hr_utility.set_location(l_proc,20);
4034: Return l_dummy;
4035: hr_utility.set_location(l_proc,25);
4036: End stop_cascade;
4037:
4038: -- ---------------------------------------------------------------------------
4039: -- |--------------------------< cascade_dependencies>-------------------------|
4079:
4080: -- Since information102 thru' 125 are always dependent on information101,
4081: -- cascade changes to these columns if information101 is supposed to be cascaded.
4082:
4083: hr_utility.set_location('Entering ' || l_proc , 5);
4084: --Initialise Local Variables
4085: l_apply_record := p_apply_record;
4086: --
4087:
4104: p_apply_record.information118 := p_record.information118;
4105: p_apply_record.information119 := p_record.information119;
4106: p_apply_record.information120 := p_record.information120;
4107:
4108: hr_utility.set_location('Leaving ' || l_proc,10);
4109:
4110: Exception
4111: When Others then
4112: --RESET In/Out Params and SET Out Params
4110: Exception
4111: When Others then
4112: --RESET In/Out Params and SET Out Params
4113: p_apply_record:=l_apply_record;
4114: hr_utility.set_location('Leaving ' || l_proc,15);
4115: Raise;
4116:
4117: End cascade_dependencies;
4118:
4166:
4167: Begin
4168: -- This procedure passes sysdate for the most recent record to fetch_history_info
4169: -- Assuming there will be no future action already applied to the extra_information table
4170: hr_utility.set_location( 'Entering : ' || l_proc, 10);
4171: --Initialise local variables
4172: l_history_data := p_history_data;
4173: l_result_code := p_result_code;
4174: --
4179: p_person_id => p_person_id,
4180: p_date_effective => l_date_effective,
4181: p_hist_data => p_history_data,
4182: p_result_code => p_result_code);
4183: hr_utility.set_location( 'Leaving : ' || l_proc, 20);
4184:
4185: Exception
4186: When Others then
4187: --RESET In/Out Params and SET Out Params
4186: When Others then
4187: --RESET In/Out Params and SET Out Params
4188: p_history_data:=l_history_data;
4189: p_result_code:=l_result_code;
4190: hr_utility.set_location( 'Leaving : ' || l_proc, 25);
4191: Raise;
4192:
4193: End fetch_most_recent_record;
4194:
4249:
4250: l_proc varchar2(72) := 'cascade_pa_req_field';
4251:
4252: BEGIN
4253: hr_utility.set_location('entering: ' || l_proc,10);
4254: -- Initialise Local Variables
4255: l_refresh_field := p_refresh_field;
4256: l_shadow_field := p_shadow_field;
4257: l_sf52_field := p_sf52_field;
4281: -- this should take care of refreshing shadow table. As desc. are not in shadow table.
4282: p_shadow_field := p_refresh_field;
4283: end if;
4284: */
4285: hr_utility.set_location('leaving: ' || l_proc,20);
4286: return l_changed;
4287: Exception
4288: When Others then
4289: --Reset In/Out Params and SET Out Params
4290: p_refresh_field :=l_refresh_field;
4291: p_shadow_field :=l_shadow_field;
4292: p_sf52_field :=l_sf52_field;
4293: p_changed :=l_changed_boo;
4294: hr_utility.set_location('leaving: ' || l_proc,25);
4295: Raise;
4296:
4297: END;
4298:
4318: -- function added on 29-oct-1998 to avoid the conversion problems for date
4319: -- fields. This overloading function converts the date to varchar and
4320: -- calls the original cascade_pa_req_field function.
4321: --
4322: hr_utility.set_location('entering: ' || l_proc,10);
4323: --Initialise local variables
4324: l_refresh_field := fnd_date.date_to_canonical(p_refresh_field);
4325: l_shadow_field := fnd_date.date_to_canonical(p_shadow_field);
4326: l_sf52_field := fnd_date.date_to_canonical(p_sf52_field);
4336: p_shadow_field := fnd_date.canonical_to_date(l_shadow_field);
4337: p_sf52_field := fnd_date.canonical_to_date(l_sf52_field);
4338:
4339: return l_changed;
4340: hr_utility.set_location('leaving: ' || l_proc,20);
4341:
4342: Exception
4343: When Others then
4344: --RESET In/Out Params and SET Out Params
4345: p_refresh_field :=l_refresh_field;
4346: p_shadow_field :=l_shadow_field;
4347: p_sf52_field :=l_sf52_field;
4348: p_changed :=l_changed_boo;
4349: hr_utility.set_location('leaving: ' || l_proc,25);
4350: Raise;
4351:
4352: END;
4353:
4365: l_sf52_field varchar2(150);
4366: l_changed_boo BOOLEAN;
4367: BEGIN
4368:
4369: hr_utility.set_location('entering: ' || l_proc,10);
4370: --Initialise Local Variables
4371: l_refresh_field := fnd_date.date_to_canonical(p_refresh_field);
4372: l_sf52_field := fnd_date.date_to_canonical(p_sf52_field);
4373: l_changed_boo := p_changed;
4378:
4379: p_refresh_field := fnd_date.canonical_to_date(l_refresh_field);
4380: p_sf52_field := fnd_date.canonical_to_date(l_sf52_field);
4381:
4382: hr_utility.set_location('leaving: ' || l_proc,20);
4383:
4384: Exception
4385: When Others then
4386: -- RESET In/Out Params and SET Out Params
4386: -- RESET In/Out Params and SET Out Params
4387: p_refresh_field:= l_refresh_field;
4388: p_sf52_field := l_sf52_field;
4389: p_changed := l_changed_boo;
4390: hr_utility.set_location('leaving : ' || l_proc,25);
4391: Raise;
4392:
4393: END;
4394:
4406: l_changed BOOLEAN;
4407: l_proc varchar2(72) := 'copy_pa_req_field (varchar2)';
4408: BEGIN
4409:
4410: hr_utility.set_location('entering: ' || l_proc,10);
4411: -- Initialise local variables
4412: l_refresh_field:= p_refresh_field;
4413: l_sf52_field := p_sf52_field;
4414: l_changed := p_changed;
4418: p_sf52_field := p_refresh_field;
4419: p_changed := TRUE;
4420: end if;
4421:
4422: hr_utility.set_location('leaving: ' || l_proc,20);
4423:
4424: Exception
4425: When Others then
4426: --RESET In/Out Params and SET Out Params
4426: --RESET In/Out Params and SET Out Params
4427: p_refresh_field := l_refresh_field;
4428: p_sf52_field := l_sf52_field;
4429: p_changed := l_changed;
4430: hr_utility.set_location('leaving: ' || l_proc,25);
4431: Raise;
4432:
4433: END;
4434:
4482: -- must not call cascade_pa_req_field to refresh any other field which is not in the
4483: -- shadow table.
4484:
4485:
4486: hr_utility.set_location('par cascade: annuitant_indicator' || l_proc,15);
4487: -- Initialise local variables
4488: l_rfrsh_rec := p_rfrsh_rec;
4489: l_shadow_Rec := p_shadow_rec;
4490: l_sf52_rec := p_sf52_rec;
4495: p_shadow_rec.annuitant_indicator,
4496: p_sf52_rec.annuitant_indicator,
4497: p_changed);
4498:
4499: hr_utility.set_location('par cascade: annuitant_indicator_desc' || l_proc,15);
4500: -- if annuitant_indicator has changed than change annuitant_indicator_desc.
4501: if (l_changed) then
4502: p_sf52_rec.annuitant_indicator_desc := p_rfrsh_rec.annuitant_indicator_desc;
4503: end if;
4501: if (l_changed) then
4502: p_sf52_rec.annuitant_indicator_desc := p_rfrsh_rec.annuitant_indicator_desc;
4503: end if;
4504:
4505: hr_utility.set_location('par cascade: appropriation_code1' || l_proc,15);
4506: l_changed := cascade_pa_req_field(p_rfrsh_rec.appropriation_code1,
4507: p_shadow_rec.appropriation_code1,
4508: p_sf52_rec.appropriation_code1,
4509: p_changed);
4507: p_shadow_rec.appropriation_code1,
4508: p_sf52_rec.appropriation_code1,
4509: p_changed);
4510:
4511: hr_utility.set_location('par cascade: appropriation_code2' || l_proc,15);
4512: l_changed := cascade_pa_req_field(p_rfrsh_rec.appropriation_code2,
4513: p_shadow_rec.appropriation_code2,
4514: p_sf52_rec.appropriation_code2,
4515: p_changed);
4513: p_shadow_rec.appropriation_code2,
4514: p_sf52_rec.appropriation_code2,
4515: p_changed);
4516:
4517: hr_utility.set_location('par cascade: bargaining_unit_status' || l_proc,15);
4518: l_changed := cascade_pa_req_field(p_rfrsh_rec.bargaining_unit_status,
4519: p_shadow_rec.bargaining_unit_status,
4520: p_sf52_rec.bargaining_unit_status,
4521: p_changed);
4519: p_shadow_rec.bargaining_unit_status,
4520: p_sf52_rec.bargaining_unit_status,
4521: p_changed);
4522:
4523: hr_utility.set_location('par cascade: citizenship' || l_proc,15);
4524: l_changed := cascade_pa_req_field(p_rfrsh_rec.citizenship,
4525: p_shadow_rec.citizenship,
4526: p_sf52_rec.citizenship,
4527: p_changed);
4525: p_shadow_rec.citizenship,
4526: p_sf52_rec.citizenship,
4527: p_changed);
4528:
4529: hr_utility.set_location('par cascade: duty_station_id' || l_proc,15);
4530: l_changed := cascade_pa_req_field(p_rfrsh_rec.duty_station_id,
4531: p_shadow_rec.duty_station_id,
4532: p_sf52_rec.duty_station_id,
4533: p_changed);
4539: end if;
4540:
4541: -- if education_level is cascaded, automatically cascade academic discipline and year degree attained. This is
4542: -- so that nulls will be cascaded for academic discipline and year degree attained, if necessary.
4543: hr_utility.set_location('par cascade: education_level' || l_proc,15);
4544: l_changed := cascade_pa_req_field(p_rfrsh_rec.education_level,
4545: p_shadow_rec.education_level,
4546: p_sf52_rec.education_level,
4547: p_changed);
4552: p_sf52_rec.year_degree_attained := p_rfrsh_rec.year_degree_attained;
4553: p_shadow_rec.year_degree_attained := p_rfrsh_rec.year_degree_attained;
4554: end if;
4555:
4556: hr_utility.set_location('par cascade: fegli' || l_proc,15);
4557: l_changed := cascade_pa_req_field(p_rfrsh_rec.fegli,
4558: p_shadow_rec.fegli,
4559: p_sf52_rec.fegli,
4560: p_changed);
4563: if (l_changed) then
4564: p_sf52_rec.fegli_desc := p_rfrsh_rec.fegli_desc ;
4565: end if;
4566:
4567: hr_utility.set_location('par cascade: flsa_category' || l_proc,15);
4568: l_changed := cascade_pa_req_field(p_rfrsh_rec.flsa_category,
4569: p_shadow_rec.flsa_category,
4570: p_sf52_rec.flsa_category,
4571: p_changed);
4569: p_shadow_rec.flsa_category,
4570: p_sf52_rec.flsa_category,
4571: p_changed);
4572:
4573: hr_utility.set_location('par cascade: forwarding_address_line1' || l_proc,15);
4574: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line1,
4575: p_shadow_rec.forwarding_address_line1,
4576: p_sf52_rec.forwarding_address_line1,
4577: p_changed);
4575: p_shadow_rec.forwarding_address_line1,
4576: p_sf52_rec.forwarding_address_line1,
4577: p_changed);
4578:
4579: hr_utility.set_location('par cascade: forwarding_address_line2' || l_proc,15);
4580: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line2,
4581: p_shadow_rec.forwarding_address_line2,
4582: p_sf52_rec.forwarding_address_line2,
4583: p_changed);
4581: p_shadow_rec.forwarding_address_line2,
4582: p_sf52_rec.forwarding_address_line2,
4583: p_changed);
4584:
4585: hr_utility.set_location('par cascade: forwarding_address_line3' || l_proc,15);
4586: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_address_line3,
4587: p_shadow_rec.forwarding_address_line3,
4588: p_sf52_rec.forwarding_address_line3,
4589: p_changed);
4587: p_shadow_rec.forwarding_address_line3,
4588: p_sf52_rec.forwarding_address_line3,
4589: p_changed);
4590:
4591: hr_utility.set_location('par cascade: forwarding_country_short_name' || l_proc,15);
4592: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_country_short_name,
4593: p_shadow_rec.forwarding_country_short_name,
4594: p_sf52_rec.forwarding_country_short_name,
4595: p_changed);
4599: p_sf52_rec.forwarding_country := p_rfrsh_rec.forwarding_country ;
4600: p_shadow_rec.forwarding_country := p_rfrsh_rec.forwarding_country ;
4601: end if;
4602:
4603: hr_utility.set_location('par cascade: forwarding_postal_code' || l_proc,15);
4604: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_postal_code,
4605: p_shadow_rec.forwarding_postal_code,
4606: p_sf52_rec.forwarding_postal_code,
4607: p_changed);
4605: p_shadow_rec.forwarding_postal_code,
4606: p_sf52_rec.forwarding_postal_code,
4607: p_changed);
4608:
4609: hr_utility.set_location('par cascade: forwarding_town_or_city' || l_proc,15);
4610: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_town_or_city,
4611: p_shadow_rec.forwarding_town_or_city,
4612: p_sf52_rec.forwarding_town_or_city,
4613: p_changed);
4611: p_shadow_rec.forwarding_town_or_city,
4612: p_sf52_rec.forwarding_town_or_city,
4613: p_changed);
4614:
4615: hr_utility.set_location('par cascade: forwarding_country' || l_proc,15);
4616: l_changed := cascade_pa_req_field(p_rfrsh_rec.forwarding_region_2,
4617: p_shadow_rec.forwarding_region_2,
4618: p_sf52_rec.forwarding_region_2,
4619: p_changed);
4617: p_shadow_rec.forwarding_region_2,
4618: p_sf52_rec.forwarding_region_2,
4619: p_changed);
4620:
4621: hr_utility.set_location('par cascade: functional_class' || l_proc,15);
4622: l_changed := cascade_pa_req_field(p_rfrsh_rec.functional_class,
4623: p_shadow_rec.functional_class,
4624: p_sf52_rec.functional_class,
4625: p_changed);
4623: p_shadow_rec.functional_class,
4624: p_sf52_rec.functional_class,
4625: p_changed);
4626:
4627: hr_utility.set_location('par cascade: pay_rate_determinant' || l_proc,15);
4628: l_changed := cascade_pa_req_field(p_rfrsh_rec.pay_rate_determinant,
4629: p_shadow_rec.pay_rate_determinant,
4630: p_sf52_rec.pay_rate_determinant,
4631: p_changed);
4629: p_shadow_rec.pay_rate_determinant,
4630: p_sf52_rec.pay_rate_determinant,
4631: p_changed);
4632:
4633: hr_utility.set_location('par cascade: position_occupied' || l_proc,15);
4634: l_changed := cascade_pa_req_field(p_rfrsh_rec.position_occupied,
4635: p_shadow_rec.position_occupied,
4636: p_sf52_rec.position_occupied,
4637: p_changed);
4635: p_shadow_rec.position_occupied,
4636: p_sf52_rec.position_occupied,
4637: p_changed);
4638:
4639: hr_utility.set_location('par cascade: retirement_plan' || l_proc,15);
4640: l_changed := cascade_pa_req_field(p_rfrsh_rec.retirement_plan,
4641: p_shadow_rec.retirement_plan,
4642: p_sf52_rec.retirement_plan,
4643: p_changed);
4646: if (l_changed) then
4647: p_sf52_rec.retirement_plan_desc := p_rfrsh_rec.retirement_plan_desc;
4648: end if;
4649:
4650: hr_utility.set_location('par cascade: supervisory_status' || l_proc,15);
4651: l_changed := cascade_pa_req_field(p_rfrsh_rec.supervisory_status,
4652: p_shadow_rec.supervisory_status,
4653: p_sf52_rec.supervisory_status,
4654: p_changed);
4652: p_shadow_rec.supervisory_status,
4653: p_sf52_rec.supervisory_status,
4654: p_changed);
4655:
4656: hr_utility.set_location('par cascade: tenure' || l_proc,15);
4657: l_changed := cascade_pa_req_field(p_rfrsh_rec.tenure,
4658: p_shadow_rec.tenure,
4659: p_sf52_rec.tenure,
4660: p_changed);
4658: p_shadow_rec.tenure,
4659: p_sf52_rec.tenure,
4660: p_changed);
4661:
4662: hr_utility.set_location('par cascade: veterans_preference' || l_proc,15);
4663: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_preference,
4664: p_shadow_rec.veterans_preference,
4665: p_sf52_rec.veterans_preference,
4666: p_changed);
4664: p_shadow_rec.veterans_preference,
4665: p_sf52_rec.veterans_preference,
4666: p_changed);
4667:
4668: hr_utility.set_location('par cascade: veterans_pref_for_rif' || l_proc,15);
4669: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_pref_for_rif,
4670: p_shadow_rec.veterans_pref_for_rif,
4671: p_sf52_rec.veterans_pref_for_rif,
4672: p_changed);
4670: p_shadow_rec.veterans_pref_for_rif,
4671: p_sf52_rec.veterans_pref_for_rif,
4672: p_changed);
4673:
4674: hr_utility.set_location('par cascade: veterans_status' || l_proc,15);
4675: l_changed := cascade_pa_req_field(p_rfrsh_rec.veterans_status,
4676: p_shadow_rec.veterans_status,
4677: p_sf52_rec.veterans_status,
4678: p_changed);
4676: p_shadow_rec.veterans_status,
4677: p_sf52_rec.veterans_status,
4678: p_changed);
4679:
4680: hr_utility.set_location('par cascade: work_schedule' || l_proc,15);
4681: l_changed := cascade_pa_req_field(p_rfrsh_rec.work_schedule,
4682: p_shadow_rec.work_schedule,
4683: p_sf52_rec.work_schedule,
4684: p_changed);
4688: p_sf52_rec.work_schedule_desc := p_rfrsh_rec.work_schedule_desc;
4689: p_shadow_rec.work_schedule_desc := p_rfrsh_rec.work_schedule_desc;
4690: end if;
4691:
4692: hr_utility.set_location('par cascade: part_time_hours' || l_proc,15);
4693: l_changed := cascade_pa_req_field(p_rfrsh_rec.part_time_hours,
4694: p_shadow_rec.part_time_hours,
4695: p_sf52_rec.part_time_hours,
4696: p_changed);
4707: end if;
4708: end if;
4709: end if;
4710:
4711: hr_utility.set_location('par cascade: service_comp_date' || l_proc,15);
4712: l_changed := cascade_pa_req_field(p_rfrsh_rec.service_comp_date,
4713: p_shadow_rec.service_comp_date,
4714: p_sf52_rec.service_comp_date,
4715: p_changed);
4713: p_shadow_rec.service_comp_date,
4714: p_sf52_rec.service_comp_date,
4715: p_changed);
4716:
4717: hr_utility.set_location('par cascade: to_position_id' || l_proc,15);
4718: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_position_id,
4719: p_shadow_rec.to_position_id,
4720: p_sf52_rec.to_position_id,
4721: p_changed);
4728: p_changed);
4729: end if;
4730: end if;
4731:
4732: hr_utility.set_location('par cascade: auo premium pay indc' || l_proc,15);
4733: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_auo_premium_pay_indicator,
4734: p_shadow_rec.to_auo_premium_pay_indicator,
4735: p_sf52_rec.to_auo_premium_pay_indicator,
4736: p_changed);
4737:
4738: -- Bug# 1257515: cascading AUO Amount when auo Ind NOT NULL,
4739: -- otherwise copying it.
4740: IF p_sf52_rec.to_auo_premium_pay_indicator IS NOT NULL THEN
4741: hr_utility.set_location('par cascade: auo premium pay amount' || l_proc,15);
4742: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_au_overtime,
4743: p_shadow_rec.to_au_overtime,
4744: p_sf52_rec.to_au_overtime,
4745: p_changed);
4748: p_sf52_rec.to_au_overtime,
4749: p_changed);
4750: END IF;
4751:
4752: hr_utility.set_location('par cascade: to_occ_code' || l_proc,15);
4753: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_occ_code,
4754: p_shadow_rec.to_occ_code,
4755: p_sf52_rec.to_occ_code,
4756: p_changed);
4757: if (l_changed) then
4758: p_sf52_rec.to_job_id := p_rfrsh_rec.to_job_id;
4759: end if;
4760:
4761: hr_utility.set_location('par cascade: Premium Pay Indc' || l_proc,15);
4762: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_ap_premium_pay_indicator,
4763: p_shadow_rec.to_ap_premium_pay_indicator,
4764: p_sf52_rec.to_ap_premium_pay_indicator,
4765: p_changed);
4766:
4767: -- Bug# 2196971 : cascading AP Amount when ap Ind NOT NULL,
4768: -- otherwise copying it.
4769: IF p_sf52_rec.to_ap_premium_pay_indicator IS NOT NULL THEN
4770: hr_utility.set_location('par cascade: ap premium pay amount' || l_proc,15);
4771: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_availability_pay,
4772: p_shadow_rec.to_availability_pay,
4773: p_sf52_rec.to_availability_pay,
4774: p_changed);
4776: copy_pa_req_field(p_rfrsh_rec.to_availability_pay,
4777: p_sf52_rec.to_availability_pay,
4778: p_changed);
4779: END IF;
4780: hr_utility.set_location('par cascade: Retention Allowance' || l_proc,15);
4781: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_retention_allowance,
4782: p_shadow_rec.to_retention_allowance,
4783: p_sf52_rec.to_retention_allowance,
4784: p_changed);
4782: p_shadow_rec.to_retention_allowance,
4783: p_sf52_rec.to_retention_allowance,
4784: p_changed);
4785:
4786: hr_utility.set_location('par cascade: Retention Allowance' || l_proc,15);
4787: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_retention_allow_percentage,
4788: p_shadow_rec.to_retention_allow_percentage,
4789: p_sf52_rec.to_retention_allow_percentage,
4790: p_changed);
4788: p_shadow_rec.to_retention_allow_percentage,
4789: p_sf52_rec.to_retention_allow_percentage,
4790: p_changed);
4791:
4792: hr_utility.set_location('par cascade: Superv. Diff' || l_proc,15);
4793: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_supervisory_differential,
4794: p_shadow_rec.to_supervisory_differential,
4795: p_sf52_rec.to_supervisory_differential,
4796: p_changed);
4794: p_shadow_rec.to_supervisory_differential,
4795: p_sf52_rec.to_supervisory_differential,
4796: p_changed);
4797:
4798: hr_utility.set_location('par cascade: Superv. Diff' || l_proc,15);
4799: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_supervisory_diff_percentage,
4800: p_shadow_rec.to_supervisory_diff_percentage,
4801: p_sf52_rec.to_supervisory_diff_percentage,
4802: p_changed);
4800: p_shadow_rec.to_supervisory_diff_percentage,
4801: p_sf52_rec.to_supervisory_diff_percentage,
4802: p_changed);
4803:
4804: hr_utility.set_location('par cascade: Staffing Diff.' || l_proc,15);
4805: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_staffing_differential,
4806: p_shadow_rec.to_staffing_differential,
4807: p_sf52_rec.to_staffing_differential,
4808: p_changed);
4806: p_shadow_rec.to_staffing_differential,
4807: p_sf52_rec.to_staffing_differential,
4808: p_changed);
4809:
4810: hr_utility.set_location('par cascade: Staffing Diff. Percentage' || l_proc,15);
4811: l_changed := cascade_pa_req_field(p_rfrsh_rec.to_staffing_diff_percentage,
4812: p_shadow_rec.to_staffing_diff_percentage,
4813: p_sf52_rec.to_staffing_diff_percentage,
4814: p_changed);
4812: p_shadow_rec.to_staffing_diff_percentage,
4813: p_sf52_rec.to_staffing_diff_percentage,
4814: p_changed);
4815:
4816: hr_utility.set_location('par cascade: duty_station_location_id' || l_proc,15);
4817: l_changed := cascade_pa_req_field(p_rfrsh_rec.duty_station_location_id,
4818: p_shadow_rec.duty_station_location_id,
4819: p_sf52_rec.duty_station_location_id,
4820: p_changed);
4982: p_rfrsh_rec :=l_rfrsh_rec;
4983: p_shadow_rec :=l_shadow_rec;
4984: p_sf52_rec :=l_sf52_rec;
4985: p_changed :=l_changed_boo;
4986: hr_utility.set_location('leaving: ' || l_proc,25);
4987: Raise;
4988:
4989: end cascade_pa_req;
4990: