[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,
267: l_result varchar2(30);
268: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
269: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
270: l_sf52_shadow ghr_pa_requests%rowtype;
271: l_shadow_data ghr_pa_request_shadow%rowtype;
272: l_sf52_data ghr_pa_requests%rowtype;
273: l_proc varchar2(30):='single_action_sf52';
274: l_capped_other_pay number;
275:
415: l_sf52_data ghr_pa_requests%rowtype;
416: l_sf52_data_save ghr_pa_requests%rowtype;
417: l_sf52_ei_data ghr_pa_request_extra_info%rowtype;
418: l_agency_ei_data ghr_pa_request_extra_info%rowtype;
419: l_shadow_data ghr_pa_request_shadow%rowtype;
420: l_session_var ghr_history_api.g_session_var_type;
421: l_result varchar2(30);
422: l_proc varchar2(30):='dual_action_sf52';
423: l_new_assignment_id per_all_assignments_f.assignment_id%type;
5406: -- This procedure can be used for refresh before update to database and for correction.
5407: --
5408: Procedure refresh_req_shadow (
5409: p_sf52_data in out nocopy ghr_pa_requests%rowtype,
5410: p_shadow_data out nocopy ghr_pa_request_shadow%rowtype,
5411: p_process_type in varchar2 default 'CURRENT'
5412: ) is
5413:
5414: l_sf52_shadow ghr_pa_requests%rowtype;
5411: p_process_type in varchar2 default 'CURRENT'
5412: ) is
5413:
5414: l_sf52_shadow ghr_pa_requests%rowtype;
5415: l_shadow_data ghr_pa_request_shadow%rowtype;
5416: l_sf52_refresh_data ghr_pa_requests%rowtype;
5417: l_changed boolean := FALSE;
5418: l_proc varchar2(30):='refresh_req_shadow';
5419: l_bef_basic_pay number;
5426: l_sf52_data ghr_pa_requests%rowtype;
5427:
5428: cursor c_sf52_shadow (c_pa_request_id in number) is
5429: select *
5430: from ghr_pa_request_shadow
5431: where pa_request_id = c_pa_request_id ;
5432:
5433: -- Sundar 2112935 Added the variables below for Output
5434: l_sf52_out_shadow ghr_pa_requests%rowtype;
6037: End redo_pay_calc;
6038:
6039:
6040: Procedure Update_rfrs_values( p_sf52_data in out nocopy ghr_pa_requests%rowtype,
6041: p_shadow_data in ghr_pa_request_shadow%rowtype) is
6042: cursor get_par_ovn is
6043: select
6044: object_version_number
6045: from ghr_pa_requests
6319: RAISE;
6320:
6321: End Update_rfrs_values;
6322:
6323: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype) is
6324: Begin
6325: Insert into ghr_pa_request_shadow
6326: (pa_request_id
6327: ,academic_discipline
6321: End Update_rfrs_values;
6322:
6323: Procedure create_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype) is
6324: Begin
6325: Insert into ghr_pa_request_shadow
6326: (pa_request_id
6327: ,academic_discipline
6328: ,annuitant_indicator
6329: ,appropriation_code1
6414: end create_shadow_row;
6415:
6416: Procedure create_shadow_row ( p_sf52_data in ghr_pa_requests%rowtype) is
6417: Begin
6418: Insert into ghr_pa_request_shadow
6419: (pa_request_id
6420: ,academic_discipline
6421: ,annuitant_indicator
6422: ,appropriation_code1
6505: ,p_sf52_data.year_degree_attained
6506: );
6507: end create_shadow_row;
6508:
6509: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
6510: p_result out nocopy Boolean) is
6511: Begin
6512: Update ghr_pa_request_shadow
6513: Set
6508:
6509: Procedure Update_shadow_row ( p_shadow_data in ghr_pa_request_shadow%rowtype,
6510: p_result out nocopy Boolean) is
6511: Begin
6512: Update ghr_pa_request_shadow
6513: Set
6514: pa_request_id = p_shadow_data.pa_request_id
6515: ,academic_discipline = p_shadow_data.academic_discipline
6516: ,annuitant_indicator = p_shadow_data.annuitant_indicator