1 Package ghr_history_cascade AUTHID CURRENT_USER as
2 /* $Header: ghcascad.pkh 120.0.12010000.1 2008/07/28 10:22:54 appldev ship $ */
3 --
4
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,
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,
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);
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,
30 p_changed in out nocopy boolean);
31
32 End ghr_history_cascade;
33 --