eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PROCESS_SF52

Line 303: ghr_process_Sf52.Fetch_extra_info(

299: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
300: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
301: ghr_history_api.set_g_session_var(l_session_var);
302:
303: ghr_process_Sf52.Fetch_extra_info(
304: p_pa_request_id => p_sf52_data.pa_request_id,
305: p_noa_id => p_sf52_data.second_noa_id,
306: p_agency_ei => TRUE,
307: p_sf52_ei_data => l_agency_ei_data,

Line 313: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

309:
310: l_sf52_data := p_sf52_data;
311: -- all corrections will have the original sf52 information in the 2nd noa columns, so
312: -- copy that information to 1st noa columns.
313: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
314: -- null the second noa columns since we don't want anything to be done with these now.
315: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
316: ghr_sf52_pre_update.populate_record_groups (
317: p_pa_request_rec => l_sf52_data,

Line 315: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

311: -- all corrections will have the original sf52 information in the 2nd noa columns, so
312: -- copy that information to 1st noa columns.
313: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
314: -- null the second noa columns since we don't want anything to be done with these now.
315: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
316: ghr_sf52_pre_update.populate_record_groups (
317: p_pa_request_rec => l_sf52_data,
318: p_generic_ei_rec => l_agency_ei_data,
319: p_imm_asg_sf52 => l_imm_asg_sf52,

Line 1015: ghr_process_Sf52.Fetch_extra_info(

1011: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
1012:
1013: ghr_history_api.set_g_session_var(l_session_var);
1014:
1015: ghr_process_Sf52.Fetch_extra_info(
1016: p_pa_request_id => p_sf52_data.pa_request_id,
1017: p_noa_id => p_sf52_data.second_noa_id,
1018: p_agency_ei => TRUE,
1019: p_sf52_ei_data => l_agency_ei_data,

Line 1025: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

1021:
1022: l_sf52_data := p_sf52_data;
1023: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1024: -- copy that information to 1st noa columns.
1025: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1026: -- null the second noa columns since we don't want anything to be done with these now.
1027: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1028:
1029: ghr_sf52_pre_update.populate_record_groups (

Line 1027: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

1023: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1024: -- copy that information to 1st noa columns.
1025: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1026: -- null the second noa columns since we don't want anything to be done with these now.
1027: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1028:
1029: ghr_sf52_pre_update.populate_record_groups (
1030: p_pa_request_rec => l_sf52_data,
1031: p_generic_ei_rec => l_agency_ei_data,

Line 1922: ghr_process_Sf52.Fetch_extra_info(

1918: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
1919:
1920: ghr_history_api.set_g_session_var(l_session_var);
1921:
1922: ghr_process_Sf52.Fetch_extra_info(
1923: p_pa_request_id => p_sf52_data.pa_request_id,
1924: p_noa_id => p_sf52_data.second_noa_id,
1925: p_agency_ei => TRUE,
1926: p_sf52_ei_data => l_agency_ei_data,

Line 1932: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

1928:
1929: l_sf52_data := p_sf52_data;
1930: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1931: -- copy that information to 1st noa columns.
1932: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1933: -- null the second noa columns since we don't want anything to be done with these now.
1934: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1935:
1936: ghr_sf52_pre_update.populate_record_groups (

Line 1934: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

1930: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1931: -- copy that information to 1st noa columns.
1932: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1933: -- null the second noa columns since we don't want anything to be done with these now.
1934: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1935:
1936: ghr_sf52_pre_update.populate_record_groups (
1937: p_pa_request_rec => l_sf52_data,
1938: p_generic_ei_rec => l_agency_ei_data,

Line 2821: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_sf52_data,

2817: IF (l_sf52_data.second_noa_code <> '780') then
2818: Refresh_Cascade_Name( p_sf52_rec => l_sf52_data,
2819: p_shadow_rec => l_shadow_data);
2820:
2821: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_sf52_data,
2822: p_shadow_data => l_shadow_data);
2823: END IF;
2824:
2825: l_sf52_data1 := l_sf52_data;

Line 2858: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,

2854: -- Pre-record values of the root SF52 for refresh purpose.
2855: -- It'll be reset after refresh has been done
2856:
2857: ghr_history_api.set_g_session_var(l_session_var);
2858: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2859: p_shadow_data => l_shadow_data);
2860: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2861: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2862: p_shadow_data => l_shadow_data);

Line 2860: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);

2856:
2857: ghr_history_api.set_g_session_var(l_session_var);
2858: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2859: p_shadow_data => l_shadow_data);
2860: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2861: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2862: p_shadow_data => l_shadow_data);
2863:
2864: -- reset pa_history_id in session variable.

Line 2861: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,

2857: ghr_history_api.set_g_session_var(l_session_var);
2858: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2859: p_shadow_data => l_shadow_data);
2860: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2861: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2862: p_shadow_data => l_shadow_data);
2863:
2864: -- reset pa_history_id in session variable.
2865: l_session_var.pa_history_id := null;

Line 2889: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);

2885: -- when this completes, l_sf52_data_result will contain the data of the original
2886: -- sf52, with all corrections in the correction chain applied onto it.
2887: -- apply_noa_corrections ensures that name/dob/ssn are retained from the last correction ie the one being processed.
2888: hr_utility.set_location('from_step_or_rate right before apply_noa_corrections: '|| l_sf52_data.from_step_or_rate || l_proc, 915);
2889: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2890: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2891: -- Bug # 6850492 added the following if condition to call seperate correction
2892: -- procedure for dual actions.
2893: hr_utility.set_location('l_root_sf52.second_noa_code'||l_root_sf52.second_noa_code,100);

Line 2890: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);

2886: -- sf52, with all corrections in the correction chain applied onto it.
2887: -- apply_noa_corrections ensures that name/dob/ssn are retained from the last correction ie the one being processed.
2888: hr_utility.set_location('from_step_or_rate right before apply_noa_corrections: '|| l_sf52_data.from_step_or_rate || l_proc, 915);
2889: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2890: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2891: -- Bug # 6850492 added the following if condition to call seperate correction
2892: -- procedure for dual actions.
2893: hr_utility.set_location('l_root_sf52.second_noa_code'||l_root_sf52.second_noa_code,100);
2894: hr_utility.set_location('l_root_sf52.first_noa_code'||l_root_sf52.first_noa_code,100);

Line 2908: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);

2904: apply_dual_noa_corrections(l_sf52_data, l_sf52_data_result);
2905: else
2906: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2907: end if;
2908: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2909: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2910:
2911: ghr_process_Sf52.Fetch_extra_info(
2912: p_pa_request_id => l_sf52_data.pa_request_id,

Line 2909: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);

2905: else
2906: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2907: end if;
2908: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2909: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2910:
2911: ghr_process_Sf52.Fetch_extra_info(
2912: p_pa_request_id => l_sf52_data.pa_request_id,
2913: p_noa_id => l_sf52_data.second_noa_id,

Line 2911: ghr_process_Sf52.Fetch_extra_info(

2907: end if;
2908: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2909: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2910:
2911: ghr_process_Sf52.Fetch_extra_info(
2912: p_pa_request_id => l_sf52_data.pa_request_id,
2913: p_noa_id => l_sf52_data.second_noa_id,
2914: p_sf52_ei_data => l_sf52_ei_data,
2915: p_result => l_result);

Line 2917: ghr_process_Sf52.Fetch_extra_info(

2913: p_noa_id => l_sf52_data.second_noa_id,
2914: p_sf52_ei_data => l_sf52_ei_data,
2915: p_result => l_result);
2916:
2917: ghr_process_Sf52.Fetch_extra_info(
2918: p_pa_request_id => l_sf52_data.pa_request_id,
2919: p_noa_id => l_sf52_data.second_noa_id,
2920: p_agency_ei => TRUE,
2921: p_sf52_ei_data => l_agency_ei_data,

Line 3596: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,

3592: -- Pre-record values of the root SF52 for refresh purpose.
3593: -- It'll be reset after refresh has been done
3594:
3595: ghr_history_api.set_g_session_var(l_session_var);
3596: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
3597: p_shadow_data => l_shadow_data);
3598: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
3599: p_capped_other_pay => l_capped_other_pay);
3600:

Line 3598: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,

3594:
3595: ghr_history_api.set_g_session_var(l_session_var);
3596: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
3597: p_shadow_data => l_shadow_data);
3598: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
3599: p_capped_other_pay => l_capped_other_pay);
3600:
3601: -- reset pa_history_id in session variable.
3602: l_session_var.pa_history_id := null;

Line 3620: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having

3616: END IF;
3617: -- End of Bug#3543213
3618:
3619: -- check if original action in correction chain was a dual action. If so, determine which of
3620: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having
3621: -- to do with the noa we are correcting.
3622: if (p_sf52_data_result.second_noa_id is not null) then
3623: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
3624: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then

Line 3626: ghr_process_sf52.assign_new_rg(p_action_num => 2,

3622: if (p_sf52_data_result.second_noa_id is not null) then
3623: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
3624: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
3625: hr_utility.set_location('Correcting second action in dual action:'|| l_proc, 12);
3626: ghr_process_sf52.assign_new_rg(p_action_num => 2,
3627: p_pa_req => p_sf52_data_result);
3628: else
3629: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
3630: ghr_process_sf52.assign_new_rg(p_action_num => 1,

Line 3630: ghr_process_sf52.assign_new_rg(p_action_num => 1,

3626: ghr_process_sf52.assign_new_rg(p_action_num => 2,
3627: p_pa_req => p_sf52_data_result);
3628: else
3629: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
3630: ghr_process_sf52.assign_new_rg(p_action_num => 1,
3631: p_pa_req => p_sf52_data_result);
3632: -- if first action is 893, then we need to derive to_columns as both actions of
3633: -- the dual action potentially could have changed the to fields (in particular,
3634: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.

Line 3636: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);

3632: -- if first action is 893, then we need to derive to_columns as both actions of
3633: -- the dual action potentially could have changed the to fields (in particular,
3634: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
3635: if (p_sf52_data_result.first_noa_code = '893') then--Bug# 8926400
3636: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
3637: end if;
3638: end if;
3639: end if;
3640: -- Nullfy columns which must not be passed

Line 3657: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);

3653: hr_utility.set_location('Fetch l_sf52_data_step loop :'|| l_proc, 15);
3654: -- all corrections will have the original sf52 information in the 2nd noa columns, so
3655: -- copy that information to 1st noa columns.
3656: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3657: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
3658: -- null the second noa columns since we don't want anything to be done with these now.
3659: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3660: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
3661: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);

Line 3660: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);

3656: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3657: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
3658: -- null the second noa columns since we don't want anything to be done with these now.
3659: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3660: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
3661: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
3662: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
3663: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3664: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);

Line 3665: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',

3661: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
3662: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
3663: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3664: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
3665: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
3666: l_sf52_data_step );
3667: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
3668: p_sf52_data_result );
3669: -- Start Intervening Actions Processing

Line 3667: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',

3663: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3664: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
3665: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
3666: l_sf52_data_step );
3667: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
3668: p_sf52_data_result );
3669: -- Start Intervening Actions Processing
3670: -- Processing added to assign the From side details to
3671: -- To side if it is a Intervening action and

Line 3707: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',

3703: get_sf52_to_details_for_ia
3704: (p_pa_request_id => p_sf52_data.pa_request_id,
3705: p_retro_eff_date => l_retro_eff_date,
3706: p_sf52_ia_rec => p_sf52_data_result);
3707: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
3708: p_sf52_data_result );
3709: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3710: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
3711: p_sf52_data_result );

Line 3710: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',

3706: p_sf52_ia_rec => p_sf52_data_result);
3707: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
3708: p_sf52_data_result );
3709: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3710: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
3711: p_sf52_data_result );
3712: ELSE
3713: -- Verify whether the original action is one of the salary change actions
3714: -- If yes, check whether the other pay related elements are present or not

Line 3718: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',

3714: -- If yes, check whether the other pay related elements are present or not
3715: -- as on the effective date. If they are not present, set that other pay comp
3716: -- to_value as null.
3717: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3718: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',
3719: p_sf52_data_result );
3720: END IF;
3721:
3722:

Line 5441: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,

5437: -- Bug 3228557 Added the following IF condition. In case of NPA Printing
5438: -- Pass parameter 'NPA' to the procedure call to refresh_req_shadow.
5439: IF NVL(p_called_from,hr_api.g_varchar2) = 'NPA' THEN
5440: hr_utility.set_location('Inside NPA printing',10);
5441: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5442: p_shadow_data=>l_shadow_data,
5443: p_process_type => 'NPA');
5444: ELSE
5445: hr_utility.set_location('Calling Refresh_req_shadow ',10);

Line 5446: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,

5442: p_shadow_data=>l_shadow_data,
5443: p_process_type => 'NPA');
5444: ELSE
5445: hr_utility.set_location('Calling Refresh_req_shadow ',10);
5446: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5447: p_shadow_data=>l_shadow_data);
5448: END IF;
5449: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5450: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN

Line 5451: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,

5447: p_shadow_data=>l_shadow_data);
5448: END IF;
5449: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5450: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN
5451: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
5452: p_capped_other_pay => l_capped_other_pay);
5453: END IF;
5454: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
5455: hr_utility.set_location(l_proc || 'pa_request_id of original= ' || l_sf52_data_step.pa_request_id,26);

Line 5457: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having

5453: END IF;
5454: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
5455: hr_utility.set_location(l_proc || 'pa_request_id of original= ' || l_sf52_data_step.pa_request_id,26);
5456: -- check if original action in correction chain was a dual action. If so, determine which of
5457: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having
5458: -- to do with the noa we are correcting.
5459: if (p_sf52_data_result.second_noa_id is not null) then
5460: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
5461: ---- commented the below if condition because is is compared against NOAC Code

Line 5468: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,

5464: if (p_noa_code_correct = p_sf52_data_result.second_noa_code) then
5465: hr_utility.set_location('Correcting second action in dual action:'|| l_proc, 12);
5466: -- Bug 8264475Modified to comment the code for handling dual actions
5467: -- as both the actions need to consider the same to side information
5468: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
5469: p_pa_req => p_sf52_data_result);*/
5470: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
5471: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
5472: else

Line 5470: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);

5466: -- Bug 8264475Modified to comment the code for handling dual actions
5467: -- as both the actions need to consider the same to side information
5468: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
5469: p_pa_req => p_sf52_data_result);*/
5470: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
5471: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
5472: else
5473: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
5474: -- Bug 8264475Modified to comment the code for handling dual actions

Line 5471: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);

5467: -- as both the actions need to consider the same to side information
5468: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
5469: p_pa_req => p_sf52_data_result);*/
5470: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
5471: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
5472: else
5473: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
5474: -- Bug 8264475Modified to comment the code for handling dual actions
5475: -- as both the actions need to consider the same to side information

Line 5477: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,

5473: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
5474: -- Bug 8264475Modified to comment the code for handling dual actions
5475: -- as both the actions need to consider the same to side information
5476:
5477: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,
5478: p_pa_req => p_sf52_data_result);*/
5479: -- if first action is 893, then we need to derive to_columns as both actions of
5480: -- the dual action potentially could have changed the to fields (in particular,
5481: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.

Line 5483: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);

5479: -- if first action is 893, then we need to derive to_columns as both actions of
5480: -- the dual action potentially could have changed the to fields (in particular,
5481: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
5482: if (p_sf52_data_result.first_noa_code = '893') then--Bug# 8926400
5483: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
5484: end if;
5485: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
5486: end if;
5487: end if;

Line 5485: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);

5481: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
5482: if (p_sf52_data_result.first_noa_code = '893') then--Bug# 8926400
5483: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
5484: end if;
5485: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
5486: end if;
5487: end if;
5488: -- Nullfy columns which must not be passed
5489: p_sf52_data_result.pa_notification_id := NULL;

Line 5503: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);

5499: else
5500: hr_utility.set_location('Fetch l_sf52_data_step loop :'|| l_proc, 15);
5501: -- all corrections will have the original sf52 information in the 2nd noa columns, so
5502: -- copy that information to 1st noa columns.
5503: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
5504: -- null the second noa columns since we don't want anything to be done with these now.
5505: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
5506: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
5507: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);

Line 5505: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);

5501: -- all corrections will have the original sf52 information in the 2nd noa columns, so
5502: -- copy that information to 1st noa columns.
5503: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
5504: -- null the second noa columns since we don't want anything to be done with these now.
5505: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
5506: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
5507: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
5508: -- Start Intervening Actions Processing
5509: -- Processing added to assign the From side details to

Line 5548: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',

5544: (p_pa_request_id => p_pa_request_id,
5545: p_retro_eff_date => l_retro_eff_date,
5546: p_sf52_ia_rec => p_sf52_data_result);
5547: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
5548: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
5549: p_sf52_data_result );
5550: ELSE
5551: -- Verify whether the original action is one of the salary change actions
5552: -- If yes, check whether the other pay related elements are present or not

Line 5556: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',

5552: -- If yes, check whether the other pay related elements are present or not
5553: -- as on the effective date. If they are not present, set that other pay comp
5554: -- to_value as null.
5555: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
5556: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',
5557: p_sf52_data_result );
5558: END IF;
5559: END IF;
5560: END LOOP;

Line 5561: ghr_process_sf52.print_sf52('step aft get_sf52_to_details_for_ia',

5557: p_sf52_data_result );
5558: END IF;
5559: END IF;
5560: END LOOP;
5561: ghr_process_sf52.print_sf52('step aft get_sf52_to_details_for_ia',
5562: l_sf52_data_step);
5563: apply_correction( p_sf52rec_correct => l_sf52_data_step,
5564: p_corr_pa_request_id => p_pa_request_id,
5565: p_sf52rec => p_sf52_data_result );

Line 5662: ghr_process_sf52.print_sf52('Result after apply_correction ' , p_sf52_data_result);

5658: END IF;
5659: END IF;
5660: -- Bug#5435374 End of bug fix.
5661:
5662: ghr_process_sf52.print_sf52('Result after apply_correction ' , p_sf52_data_result);
5663:
5664: hr_utility.set_location(' Leaving:'||l_proc, 25);
5665: exception when others then
5666: --

Line 7421: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,

7417: --8264545
7418: end if;
7419: end if;
7420:
7421: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
7422: p_shadow_data => l_shadow_data);
7423: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
7424: p_capped_other_pay => l_capped_other_pay);
7425: -- reset pa_history_id in session variable.

Line 7423: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,

7419: end if;
7420:
7421: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
7422: p_shadow_data => l_shadow_data);
7423: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
7424: p_capped_other_pay => l_capped_other_pay);
7425: -- reset pa_history_id in session variable.
7426: l_session_var.pa_history_id := null;
7427: ghr_history_api.set_g_session_var(l_session_var);

Line 7443: --the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having

7439: ,p_part_time_hours => l_dummy);
7440: END IF;
7441: --End of Bug#3543213
7442: --check if original action in correction chain was a dual action. If so, determine which of
7443: --the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having
7444: -- to do with the noa we are correcting.
7445: --l_dual_flag := 'N';
7446: if (p_sf52_data_result.second_noa_id is not null) then
7447: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);

Line 7448: ghr_process_sf52.g_dual_action_yn := 'Y';

7444: -- to do with the noa we are correcting.
7445: --l_dual_flag := 'N';
7446: if (p_sf52_data_result.second_noa_id is not null) then
7447: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
7448: ghr_process_sf52.g_dual_action_yn := 'Y';
7449: ghr_process_sf52.g_dual_first_noac := p_sf52_data_result.first_noa_code;
7450: ghr_process_sf52.g_dual_second_noac := p_sf52_data_result.second_noa_code;
7451:
7452: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then

Line 7449: ghr_process_sf52.g_dual_first_noac := p_sf52_data_result.first_noa_code;

7445: --l_dual_flag := 'N';
7446: if (p_sf52_data_result.second_noa_id is not null) then
7447: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
7448: ghr_process_sf52.g_dual_action_yn := 'Y';
7449: ghr_process_sf52.g_dual_first_noac := p_sf52_data_result.first_noa_code;
7450: ghr_process_sf52.g_dual_second_noac := p_sf52_data_result.second_noa_code;
7451:
7452: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
7453: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,

Line 7450: ghr_process_sf52.g_dual_second_noac := p_sf52_data_result.second_noa_code;

7446: if (p_sf52_data_result.second_noa_id is not null) then
7447: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
7448: ghr_process_sf52.g_dual_action_yn := 'Y';
7449: ghr_process_sf52.g_dual_first_noac := p_sf52_data_result.first_noa_code;
7450: ghr_process_sf52.g_dual_second_noac := p_sf52_data_result.second_noa_code;
7451:
7452: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
7453: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
7454: p_pa_req => p_sf52_data_result);*/

Line 7453: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,

7449: ghr_process_sf52.g_dual_first_noac := p_sf52_data_result.first_noa_code;
7450: ghr_process_sf52.g_dual_second_noac := p_sf52_data_result.second_noa_code;
7451:
7452: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
7453: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
7454: p_pa_req => p_sf52_data_result);*/
7455: -- to change the Family code for second action correction as it is raising errors
7456: -- based on family code
7457: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);

Line 7457: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);

7453: /*ghr_process_sf52.assign_new_rg(p_action_num => 2,
7454: p_pa_req => p_sf52_data_result);*/
7455: -- to change the Family code for second action correction as it is raising errors
7456: -- based on family code
7457: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
7458: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7459: else
7460: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,
7461: p_pa_req => p_sf52_data_result);*/

Line 7458: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);

7454: p_pa_req => p_sf52_data_result);*/
7455: -- to change the Family code for second action correction as it is raising errors
7456: -- based on family code
7457: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
7458: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7459: else
7460: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,
7461: p_pa_req => p_sf52_data_result);*/
7462:

Line 7460: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,

7456: -- based on family code
7457: ghr_process_sf52.copy_2ndNoa_to_1stNoa(p_sf52_data_result);
7458: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7459: else
7460: /*ghr_process_sf52.assign_new_rg(p_action_num => 1,
7461: p_pa_req => p_sf52_data_result);*/
7462:
7463: -- if first action is 893, then we need to derive to_columns as both actions of
7464: -- the dual action potentially could have changed the to fields (in particular,

Line 7467: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);

7463: -- if first action is 893, then we need to derive to_columns as both actions of
7464: -- the dual action potentially could have changed the to fields (in particular,
7465: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
7466: if (p_sf52_data_result.first_noa_code = '893') then--Bug# 8926400
7467: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
7468: end if;
7469: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7470: end if;
7471: -- l_dual_flag := 'Y';

Line 7469: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);

7465: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
7466: if (p_sf52_data_result.first_noa_code = '893') then--Bug# 8926400
7467: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
7468: end if;
7469: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7470: end if;
7471: -- l_dual_flag := 'Y';
7472: end if;
7473: hr_utility.set_location('ghr_process_sf52.g_dual_flag_yn'||ghr_process_sf52.g_dual_action_yn,100);

Line 7473: hr_utility.set_location('ghr_process_sf52.g_dual_flag_yn'||ghr_process_sf52.g_dual_action_yn,100);

7469: ghr_process_sf52.null_2ndNoa_cols(p_sf52_data_result);
7470: end if;
7471: -- l_dual_flag := 'Y';
7472: end if;
7473: hr_utility.set_location('ghr_process_sf52.g_dual_flag_yn'||ghr_process_sf52.g_dual_action_yn,100);
7474: hr_utility.set_location('ghr_process_sf52.g_dual_first_noac'||ghr_process_sf52.g_dual_first_noac,100);
7475: hr_utility.set_location('ghr_process_sf52.g_dual_second_noac'||ghr_process_sf52.g_dual_second_noac,100);
7476: -- Nullfy columns which must not be passed
7477: p_sf52_data_result.pa_notification_id := NULL;

Line 7474: hr_utility.set_location('ghr_process_sf52.g_dual_first_noac'||ghr_process_sf52.g_dual_first_noac,100);

7470: end if;
7471: -- l_dual_flag := 'Y';
7472: end if;
7473: hr_utility.set_location('ghr_process_sf52.g_dual_flag_yn'||ghr_process_sf52.g_dual_action_yn,100);
7474: hr_utility.set_location('ghr_process_sf52.g_dual_first_noac'||ghr_process_sf52.g_dual_first_noac,100);
7475: hr_utility.set_location('ghr_process_sf52.g_dual_second_noac'||ghr_process_sf52.g_dual_second_noac,100);
7476: -- Nullfy columns which must not be passed
7477: p_sf52_data_result.pa_notification_id := NULL;
7478: p_sf52_data_result.agency_code := NULL;

Line 7475: hr_utility.set_location('ghr_process_sf52.g_dual_second_noac'||ghr_process_sf52.g_dual_second_noac,100);

7471: -- l_dual_flag := 'Y';
7472: end if;
7473: hr_utility.set_location('ghr_process_sf52.g_dual_flag_yn'||ghr_process_sf52.g_dual_action_yn,100);
7474: hr_utility.set_location('ghr_process_sf52.g_dual_first_noac'||ghr_process_sf52.g_dual_first_noac,100);
7475: hr_utility.set_location('ghr_process_sf52.g_dual_second_noac'||ghr_process_sf52.g_dual_second_noac,100);
7476: -- Nullfy columns which must not be passed
7477: p_sf52_data_result.pa_notification_id := NULL;
7478: p_sf52_data_result.agency_code := NULL;
7479: p_sf52_data_result.approval_date := NULL;

Line 7493: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);

7489: hr_utility.set_location('Fetch l_sf52_data_step loop :'|| l_proc, 15);
7490: -- all corrections will have the original sf52 information in the 2nd noa columns, so
7491: -- copy that information to 1st noa columns.
7492: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
7493: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
7494: -- null the second noa columns since we don't want anything to be done with these now.
7495: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
7496: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
7497: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);

Line 7496: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);

7492: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
7493: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
7494: -- null the second noa columns since we don't want anything to be done with these now.
7495: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
7496: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
7497: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
7498: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
7499: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
7500: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);

Line 7501: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',

7497: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
7498: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
7499: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
7500: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
7501: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
7502: l_sf52_data_step );
7503: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
7504: p_sf52_data_result );
7505: -- Start Intervening Actions Processing

Line 7503: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',

7499: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
7500: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
7501: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
7502: l_sf52_data_step );
7503: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
7504: p_sf52_data_result );
7505: -- Start Intervening Actions Processing
7506: -- Processing added to assign the From side details to
7507: -- To side if it is a Intervening action and

Line 7546: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',

7542: p_sf52_ia_rec => p_sf52_data_result);
7543:
7544:
7545:
7546: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
7547: p_sf52_data_result );
7548: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
7549: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
7550: p_sf52_data_result );

Line 7549: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',

7545:
7546: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
7547: p_sf52_data_result );
7548: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
7549: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
7550: p_sf52_data_result );
7551: l_retro_action_exists := 'Y';
7552: ELSE
7553:

Line 7559: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',

7555: -- If yes, check whether the other pay related elements are present or not
7556: -- as on the effective date. If they are not present, set that other pay comp
7557: -- to_value as null.
7558: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
7559: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',
7560: p_sf52_data_result );
7561: END IF;
7562: END IF;
7563: --bug #6356058 start