[Home] [Help]
24: p_message_name in ghr_process_log.message_name%type,
25: p_log_date in ghr_process_log.log_date%type
26: );
27:
28: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
29: p_result out nocopy Boolean);
30:
31: /*Procedure fetch_update_routing_details
32: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
193: l_result varchar2(30);
194: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
195: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
196: l_sf52_shadow ghr_pa_requests%rowtype;
197: l_shadow_data ghr_pa_request_shadow%rowtype;
198: l_sf52_data ghr_pa_requests%rowtype;
199: l_proc varchar2(30):='single_action_sf52';
200: l_capped_other_pay number;
201:
341: l_sf52_data ghr_pa_requests%rowtype;
342: l_sf52_data_save ghr_pa_requests%rowtype;
343: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
344: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
345: l_shadow_data ghr_pa_request_shadow%rowtype;
346: l_session_var ghr_history_api.g_session_var_type;
347: l_result varchar2(30);
348: l_proc varchar2(30):='dual_action_sf52';
349: l_new_assignment_id per_all_assignments_f.assignment_id%type;
5158: -- This procedure can be used for refresh before update to database and for correction.
5159: --
5160: Procedure refresh_req_shadow (
5161: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
5162: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
5163: p_process_type in varchar2 default 'CURRENT'
5164: ) is
5165:
5166: l_sf52_shadow ghr_pa_requests%rowtype;
5163: p_process_type in varchar2 default 'CURRENT'
5164: ) is
5165:
5166: l_sf52_shadow ghr_pa_requests%rowtype;
5167: l_shadow_data ghr_pa_request_shadow%rowtype;
5168: l_sf52_refresh_data ghr_pa_requests%rowtype;
5169: l_changed boolean := FALSE;
5170: l_proc varchar2(30):='refresh_req_shadow';
5171: l_bef_basic_pay number;
5178: l_sf52_data ghr_pa_requests%rowtype;
5179:
5180: cursor c_sf52_shadow (c_pa_request_id in number) is
5181: select *
5182: from ghr_pa_request_shadow
5183: where pa_request_id = c_pa_request_id ;
5184:
5185: -- Sundar 2112935 Added the variables below for Output
5186: l_sf52_out_shadow ghr_pa_requests%rowtype;
5759: End redo_pay_calc;
5760:
5761:
5762: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
5763: p_shadow_data in ghr_pa_request_shadow%rowtype) is
5764: cursor get_par_ovn is
5765: select
5766: object_version_number
5767: from ghr_pa_requests
6041: RAISE;
6042:
6043: End Update_rfrs_values;
6044:
6045: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype) is
6046: Begin
6047: Insert into ghr_pa_request_shadow
6048: (pa_request_id
6049: ,academic_discipline
6043: End Update_rfrs_values;
6044:
6045: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype) is
6046: Begin
6047: Insert into ghr_pa_request_shadow
6048: (pa_request_id
6049: ,academic_discipline
6050: ,annuitant_indicator
6051: ,appropriation_code1
6136: end create_shadow_row;
6137:
6138: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype) is
6139: Begin
6140: Insert into ghr_pa_request_shadow
6141: (pa_request_id
6142: ,academic_discipline
6143: ,annuitant_indicator
6144: ,appropriation_code1
6227: ,p_sf52_data.year_degree_attained
6228: );
6229: end create_shadow_row;
6230:
6231: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
6232: p_result out nocopy Boolean) is
6233: Begin
6234: Update ghr_pa_request_shadow
6235: Set
6230:
6231: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
6232: p_result out nocopy Boolean) is
6233: Begin
6234: Update ghr_pa_request_shadow
6235: Set
6236: pa_request_id = p_shadow_data.pa_request_id
6237: ,academic_discipline = p_shadow_data.academic_discipline
6238: ,annuitant_indicator = p_shadow_data.annuitant_indicator