[Home] [Help]
1: Package Body ghr_history_cascade as
2: /* $Header: ghcascad.pkb 120.4.12020000.2 2012/12/14 04:10:53 vmididho ship $ */
3: --
4: -- forward declare all local procedures/functions
5: Procedure Cascade_People (
71:
72: Procedure cascade_change( p_pre_record in ghr_pa_history%rowtype,
73: p_post_record in ghr_pa_history%rowtype,
74: p_apply_record in out nocopy ghr_pa_history%rowtype,
75: p_true_false in out nocopy ghr_history_cascade.condition_rg_type
76: );
77:
78: Procedure cascade_field_value( p_pre_field in ghr_pa_history.information1%type,
79: p_post_field in ghr_pa_history.information1%type,
81: p_result in out nocopy boolean
82: );
83:
84:
85: Function Stop_cascade( p_true_false ghr_history_cascade.condition_rg_type
86: ) Return boolean;
87:
88:
89: Procedure cascade_dependencies( p_record in ghr_pa_history%rowtype,
168:
169: l_session_var ghr_history_api.g_session_var_type;
170: l_proc varchar2(72) := 'Cascade_History_data';
171: l_record_data ghr_pa_history%rowtype;
172: l_true_false ghr_history_cascade.condition_rg_type;
173: l_stop boolean;
174: l_num number := 1;
175: l_history_id number;
176: l_root_pa_history_id ghr_pa_history.pa_history_id%type;
883: p_interv_on_eff_date in Boolean,
884: p_hist_data_as_of_date in ghr_pa_history%rowtype
885: ) is
886:
887: l_true_false ghr_history_cascade.condition_rg_type;
888: l_people_data per_all_people_f%rowtype;
889: l_hist_peop_data ghr_pa_history%rowtype;
890: l_stop Boolean;
891: l_proc varchar2(30):='Cascade_People';
1027: p_interv_on_eff_date in Boolean,
1028: p_hist_data_as_of_date in ghr_pa_history%rowtype
1029: ) is
1030:
1031: l_true_false ghr_history_cascade.condition_rg_type;
1032: l_asgn_data per_all_assignments_f%rowtype;
1033: l_hist_asgn_data ghr_pa_history%rowtype;
1034: l_stop Boolean;
1035: l_proc varchar2(30):='Cascade_asgn';
1489: p_interv_on_eff_date in Boolean,
1490: p_hist_data_as_of_date in ghr_pa_history%rowtype
1491: ) is
1492:
1493: l_true_false ghr_history_cascade.condition_rg_type;
1494: l_posn_data hr_all_positions_f%rowtype;
1495: l_hist_posn_data ghr_pa_history%rowtype;
1496: l_stop Boolean;
1497: l_proc varchar2(30):='Cascade_posn';
2970: -- ---------------------------------------------------------------------------
2971: Procedure cascade_change(p_pre_record in ghr_pa_history%rowtype,
2972: p_post_record in ghr_pa_history%rowtype,
2973: p_apply_record in out nocopy ghr_pa_history%rowtype,
2974: p_true_false in out nocopy ghr_history_cascade.condition_rg_type)
2975: is
2976:
2977: l_apply_record ghr_pa_history%rowtype;
2978: l_true_false ghr_history_cascade.condition_rg_type;
2974: p_true_false in out nocopy ghr_history_cascade.condition_rg_type)
2975: is
2976:
2977: l_apply_record ghr_pa_history%rowtype;
2978: l_true_false ghr_history_cascade.condition_rg_type;
2979: l_proc varchar2(72) := 'cascade_change';
2980:
2981: Begin
2982: hr_utility.set_location('Entering ' || l_proc,5);
4041: -- Internal Development Use Only.
4042: --
4043: -- {End Of Comments}
4044: -- ---------------------------------------------------------------------------
4045: Function Stop_cascade( p_true_false ghr_history_cascade.condition_rg_type)
4046: Return boolean
4047: is
4048:
4049: l_proc varchar2(72) := 'Stop_cascade';
5020: Raise;
5021:
5022: end cascade_pa_req;
5023:
5024: End ghr_history_cascade;