APPS.GHR_CORR_CANC_SF52 dependencies on GHR_HISTORY_CASCADE

Line 519: ghr_history_cascade.cascade_history_data (

515: close c_follow_rec;
516:
517: else
518: -- there is a pre record, so apply it to the history table and to the application table.
519: ghr_history_cascade.cascade_history_data (
520: p_table_name => l_hist_rec.table_name,
521: p_person_id => l_hist_rec.person_id,
522: p_pre_record => l_hist_pre,
523: p_post_record => l_hist_rec,

Line 528: ghr_history_cascade.cascade_appl_table_data (

524: p_cascade_type => 'cancel',
525: p_interv_on_table => l_interv_on_table,
526: p_interv_on_eff_date => l_interv_on_eff_date,
527: p_hist_data_as_of_date => l_hist_data_as_of_date);
528: ghr_history_cascade.cascade_appl_table_data (
529: p_table_name => l_hist_rec.table_name,
530: p_person_id => l_hist_rec.person_id,
531: p_pre_record => l_hist_pre,
532: p_post_record => l_hist_rec,

Line 621: ghr_history_cascade.cascade_history_data (

617: end if;
618: close c_follow_rec;
619: else
620: -- there is a pre record, so apply it to the history table and to the application table.
621: ghr_history_cascade.cascade_history_data (
622: p_table_name => l_hist_rec.table_name,
623: p_person_id => l_hist_rec.person_id,
624: p_pre_record => l_hist_pre,
625: p_post_record => l_hist_rec,

Line 631: ghr_history_cascade.cascade_appl_table_data (

627: p_interv_on_table => l_interv_on_table,
628: p_interv_on_eff_date => l_interv_on_eff_date,
629: p_hist_data_as_of_date => l_hist_data_as_of_date);
630: delete_hist_row( l_hist.row_id);
631: ghr_history_cascade.cascade_appl_table_data (
632: p_table_name => l_hist_rec.table_name,
633: p_person_id => l_hist_rec.person_id,
634: p_pre_record => l_hist_pre,
635: p_post_record => l_hist_rec,

Line 1129: ghr_history_cascade.cascade_appl_table_data(

1125: l_hist_post.person_id := l_hist.person_id;
1126: hr_utility.set_location(l_proc || 'l_hist.information1: ' || l_hist.information1, 1200);
1127: hr_utility.set_location(l_proc || 'l_hist.table_name: ' || l_hist.table_name, 1210);
1128: hr_utility.set_location(l_proc || 'l_hist.person_id: ' || l_hist.person_id, 1220);
1129: ghr_history_cascade.cascade_appl_table_data(
1130: p_table_name => l_hist.table_name,
1131: p_person_id => l_hist.person_id,
1132: p_pre_record => null,
1133: p_post_record => l_hist_post,

Line 1915: ghr_history_cascade.cascade_history_data (

1911: end if;
1912: close c_follow_rec;
1913: else
1914: -- there is a pre record, so apply it to the history table and to the application table.
1915: ghr_history_cascade.cascade_history_data (
1916: p_table_name => l_hist_address_rec.table_name,
1917: p_person_id => l_hist_address_rec.person_id,
1918: p_pre_record => l_hist_pre,
1919: p_post_record => l_hist_address_rec,

Line 1925: ghr_history_cascade.cascade_appl_table_data (

1921: p_interv_on_table => l_interv_on_table,
1922: p_interv_on_eff_date => l_interv_on_eff_date,
1923: p_hist_data_as_of_date => l_hist_data_as_of_date);
1924: delete_hist_row( l_hist.row_id);
1925: ghr_history_cascade.cascade_appl_table_data (
1926: p_table_name => l_hist_address_rec.table_name,
1927: p_person_id => l_hist_address_rec.person_id,
1928: p_pre_record => l_hist_pre,
1929: p_post_record => l_hist_address_rec,

Line 2123: ghr_history_cascade.cascade_history_data (

2119: delete_hist_row ( l_hist_rec.pa_history_id);
2120: else
2121: hr_utility.set_location('Processing non element entry table'|| l_proc,50);
2122: -- cascade changes thru history table
2123: ghr_history_cascade.cascade_history_data (
2124: p_table_name => l_hist_rec.table_name,
2125: p_person_id => l_hist_rec.person_id,
2126: p_pre_record => l_hist_pre,
2127: p_post_record => l_hist_rec,

Line 2253: ghr_history_cascade.cascade_appl_table_data (

2249: CLOSE chk_perana_exists;
2250: END IF;
2251:
2252: IF l_rec_exists THEN
2253: ghr_history_cascade.cascade_appl_table_data (
2254: p_table_name => l_hist_rec.table_name,
2255: p_person_id => l_hist_rec.person_id,
2256: p_pre_record => l_hist_pre,
2257: p_post_record => l_hist_rec,