5: TYPE condition_rg_type IS TABLE of boolean index by binary_integer;
6: Procedure Cascade_History_data (
7: p_table_name in varchar2,
8: p_person_id in varchar2,
9: p_pre_record in ghr_pa_history%rowtype,
10: p_post_record in ghr_pa_history%rowtype,
11: p_cascade_type in varchar2,
12: p_interv_on_table out nocopy boolean,
13: p_interv_on_eff_date out nocopy boolean,
6: Procedure Cascade_History_data (
7: p_table_name in varchar2,
8: p_person_id in varchar2,
9: p_pre_record in ghr_pa_history%rowtype,
10: p_post_record in ghr_pa_history%rowtype,
11: p_cascade_type in varchar2,
12: p_interv_on_table out nocopy boolean,
13: p_interv_on_eff_date out nocopy boolean,
14: p_hist_data_as_of_date out nocopy ghr_pa_history%rowtype );
10: p_post_record in ghr_pa_history%rowtype,
11: p_cascade_type in varchar2,
12: p_interv_on_table out nocopy boolean,
13: p_interv_on_eff_date out nocopy boolean,
14: p_hist_data_as_of_date out nocopy ghr_pa_history%rowtype );
15:
16:
17: Procedure Cascade_Appl_table_data (
18: p_table_name in varchar2,
16:
17: Procedure Cascade_Appl_table_data (
18: p_table_name in varchar2,
19: p_person_id in varchar2,
20: p_pre_record in ghr_pa_history%rowtype,
21: p_post_record in ghr_pa_history%rowtype,
22: p_cascade_type in varchar2,
23: p_interv_on_table in Boolean,
24: p_interv_on_eff_date in Boolean,
17: Procedure Cascade_Appl_table_data (
18: p_table_name in varchar2,
19: p_person_id in varchar2,
20: p_pre_record in ghr_pa_history%rowtype,
21: p_post_record in ghr_pa_history%rowtype,
22: p_cascade_type in varchar2,
23: p_interv_on_table in Boolean,
24: p_interv_on_eff_date in Boolean,
25: p_hist_data_as_of_date in ghr_pa_history%rowtype);
21: p_post_record in ghr_pa_history%rowtype,
22: p_cascade_type in varchar2,
23: p_interv_on_table in Boolean,
24: p_interv_on_eff_date in Boolean,
25: p_hist_data_as_of_date in ghr_pa_history%rowtype);
26:
27: Procedure cascade_pa_req(p_rfrsh_rec in out nocopy ghr_pa_requests%rowtype,
28: p_shadow_rec in out nocopy ghr_pa_requests%rowtype,
29: p_sf52_rec in out nocopy ghr_pa_requests%rowtype,