[Home] [Help]
536: close c_follow_rec;
537:
538: else
539: -- there is a pre record, so apply it to the history table and to the application table.
540: ghr_history_cascade.cascade_history_data (
541: p_table_name => l_hist_rec.table_name,
542: p_person_id => l_hist_rec.person_id,
543: p_pre_record => l_hist_pre,
544: p_post_record => l_hist_rec,
545: p_cascade_type => 'cancel',
546: p_interv_on_table => l_interv_on_table,
547: p_interv_on_eff_date => l_interv_on_eff_date,
548: p_hist_data_as_of_date => l_hist_data_as_of_date);
549: ghr_history_cascade.cascade_appl_table_data (
550: p_table_name => l_hist_rec.table_name,
551: p_person_id => l_hist_rec.person_id,
552: p_pre_record => l_hist_pre,
553: p_post_record => l_hist_rec,
642: end if;
643: close c_follow_rec;
644: else
645: -- there is a pre record, so apply it to the history table and to the application table.
646: ghr_history_cascade.cascade_history_data (
647: p_table_name => l_hist_rec.table_name,
648: p_person_id => l_hist_rec.person_id,
649: p_pre_record => l_hist_pre,
650: p_post_record => l_hist_rec,
652: p_interv_on_table => l_interv_on_table,
653: p_interv_on_eff_date => l_interv_on_eff_date,
654: p_hist_data_as_of_date => l_hist_data_as_of_date);
655: delete_hist_row( l_hist.row_id);
656: ghr_history_cascade.cascade_appl_table_data (
657: p_table_name => l_hist_rec.table_name,
658: p_person_id => l_hist_rec.person_id,
659: p_pre_record => l_hist_pre,
660: p_post_record => l_hist_rec,
1230: END IF;
1231:
1232: IF l_rec_exists THEN
1233:
1234: ghr_history_cascade.cascade_appl_table_data(
1235: p_table_name => l_hist.table_name,
1236: p_person_id => l_hist.person_id,
1237: p_pre_record => null,
1238: p_post_record => l_hist_post,
1270: l_hist_post.person_id := l_add_hist.person_id;
1271: hr_utility.set_location(l_proc || 'l_add_hist.information1: ' || l_add_hist.information1, 1200);
1272: hr_utility.set_location(l_proc || 'l_add_hist.table_name: ' || l_add_hist.table_name, 1210);
1273: hr_utility.set_location(l_proc || 'l_add_hist.person_id: ' || l_add_hist.person_id, 1220);
1274: ghr_history_cascade.cascade_appl_table_data(
1275: p_table_name => l_add_hist.table_name,
1276: p_person_id => l_add_hist.person_id,
1277: p_pre_record => null,
1278: p_post_record => l_hist_post,
2113: end if;
2114: close c_follow_rec;
2115: else
2116: -- there is a pre record, so apply it to the history table and to the application table.
2117: ghr_history_cascade.cascade_history_data (
2118: p_table_name => l_hist_address_rec.table_name,
2119: p_person_id => l_hist_address_rec.person_id,
2120: p_pre_record => l_hist_pre,
2121: p_post_record => l_hist_address_rec,
2123: p_interv_on_table => l_interv_on_table,
2124: p_interv_on_eff_date => l_interv_on_eff_date,
2125: p_hist_data_as_of_date => l_hist_data_as_of_date);
2126: delete_hist_row( l_hist.row_id);
2127: ghr_history_cascade.cascade_appl_table_data (
2128: p_table_name => l_hist_address_rec.table_name,
2129: p_person_id => l_hist_address_rec.person_id,
2130: p_pre_record => l_hist_pre,
2131: p_post_record => l_hist_address_rec,
2341: delete_hist_row ( l_hist_rec.pa_history_id);
2342: else
2343: hr_utility.set_location('Processing non element entry table'|| l_proc,50);
2344: -- cascade changes thru history table
2345: ghr_history_cascade.cascade_history_data (
2346: p_table_name => l_hist_rec.table_name,
2347: p_person_id => l_hist_rec.person_id,
2348: p_pre_record => l_hist_pre,
2349: p_post_record => l_hist_rec,
2489: p_information =>l_hist_rec.information1);
2490: FETCH chk_hist_rec_avl into p_avl;
2491: CLOSE chk_hist_rec_avl;
2492: IF NVL(p_avl,0) <> 1 THEN
2493: ghr_history_cascade.cascade_appl_table_data (
2494: p_table_name => l_hist_rec.table_name,
2495: p_person_id => l_hist_rec.person_id,
2496: p_pre_record => l_hist_pre,
2497: p_post_record => l_hist_rec,