[Home] [Help]
1: Package Body ghr_history_cascade as
2: /* $Header: ghcascad.pkb 115.31 2004/05/27 10:11:41 ajose 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;
877: p_interv_on_eff_date in Boolean,
878: p_hist_data_as_of_date in ghr_pa_history%rowtype
879: ) is
880:
881: l_true_false ghr_history_cascade.condition_rg_type;
882: l_people_data per_all_people_f%rowtype;
883: l_hist_peop_data ghr_pa_history%rowtype;
884: l_stop Boolean;
885: l_proc varchar2(30):='Cascade_People';
1021: p_interv_on_eff_date in Boolean,
1022: p_hist_data_as_of_date in ghr_pa_history%rowtype
1023: ) is
1024:
1025: l_true_false ghr_history_cascade.condition_rg_type;
1026: l_asgn_data per_all_assignments_f%rowtype;
1027: l_hist_asgn_data ghr_pa_history%rowtype;
1028: l_stop Boolean;
1029: l_proc varchar2(30):='Cascade_asgn';
1466: p_interv_on_eff_date in Boolean,
1467: p_hist_data_as_of_date in ghr_pa_history%rowtype
1468: ) is
1469:
1470: l_true_false ghr_history_cascade.condition_rg_type;
1471: l_posn_data hr_all_positions_f%rowtype;
1472: l_hist_posn_data ghr_pa_history%rowtype;
1473: l_stop Boolean;
1474: l_proc varchar2(30):='Cascade_posn';
2944: -- ---------------------------------------------------------------------------
2945: Procedure cascade_change(p_pre_record in ghr_pa_history%rowtype,
2946: p_post_record in ghr_pa_history%rowtype,
2947: p_apply_record in out nocopy ghr_pa_history%rowtype,
2948: p_true_false in out nocopy ghr_history_cascade.condition_rg_type)
2949: is
2950:
2951: l_apply_record ghr_pa_history%rowtype;
2952: l_true_false ghr_history_cascade.condition_rg_type;
2948: p_true_false in out nocopy ghr_history_cascade.condition_rg_type)
2949: is
2950:
2951: l_apply_record ghr_pa_history%rowtype;
2952: l_true_false ghr_history_cascade.condition_rg_type;
2953: l_proc varchar2(72) := 'cascade_change';
2954:
2955: Begin
2956: hr_utility.set_location('Entering ' || l_proc,5);
4008: -- Internal Development Use Only.
4009: --
4010: -- {End Of Comments}
4011: -- ---------------------------------------------------------------------------
4012: Function Stop_cascade( p_true_false ghr_history_cascade.condition_rg_type)
4013: Return boolean
4014: is
4015:
4016: l_proc varchar2(72) := 'Stop_cascade';
4987: Raise;
4988:
4989: end cascade_pa_req;
4990:
4991: End ghr_history_cascade;