DBA Data[Home] [Help]

APPS.GHR_CORR_CANC_SF52 dependencies on GHR_PROCESS_SF52

Line 296: ghr_process_Sf52.Fetch_extra_info(

292: l_session_var.altered_pa_request_id := p_sf52_data.altered_pa_request_id;
293: l_session_var.noa_id_correct := p_sf52_data.second_noa_id;
294: ghr_history_api.set_g_session_var(l_session_var);
295:
296: ghr_process_Sf52.Fetch_extra_info(
297: p_pa_request_id => p_sf52_data.pa_request_id,
298: p_noa_id => p_sf52_data.second_noa_id,
299: p_agency_ei => TRUE,
300: p_sf52_ei_data => l_agency_ei_data,

Line 306: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

302:
303: l_sf52_data := p_sf52_data;
304: -- all corrections will have the original sf52 information in the 2nd noa columns, so
305: -- copy that information to 1st noa columns.
306: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
307: -- null the second noa columns since we don't want anything to be done with these now.
308: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
309: ghr_sf52_pre_update.populate_record_groups (
310: p_pa_request_rec => l_sf52_data,

Line 308: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

304: -- all corrections will have the original sf52 information in the 2nd noa columns, so
305: -- copy that information to 1st noa columns.
306: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
307: -- null the second noa columns since we don't want anything to be done with these now.
308: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
309: ghr_sf52_pre_update.populate_record_groups (
310: p_pa_request_rec => l_sf52_data,
311: p_generic_ei_rec => l_agency_ei_data,
312: p_imm_asg_sf52 => l_imm_asg_sf52,

Line 945: ghr_process_Sf52.Fetch_extra_info(

941: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
942:
943: ghr_history_api.set_g_session_var(l_session_var);
944:
945: ghr_process_Sf52.Fetch_extra_info(
946: p_pa_request_id => p_sf52_data.pa_request_id,
947: p_noa_id => p_sf52_data.second_noa_id,
948: p_agency_ei => TRUE,
949: p_sf52_ei_data => l_agency_ei_data,

Line 955: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

951:
952: l_sf52_data := p_sf52_data;
953: -- all corrections will have the original sf52 information in the 2nd noa columns, so
954: -- copy that information to 1st noa columns.
955: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
956: -- null the second noa columns since we don't want anything to be done with these now.
957: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
958:
959: ghr_sf52_pre_update.populate_record_groups (

Line 957: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

953: -- all corrections will have the original sf52 information in the 2nd noa columns, so
954: -- copy that information to 1st noa columns.
955: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
956: -- null the second noa columns since we don't want anything to be done with these now.
957: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
958:
959: ghr_sf52_pre_update.populate_record_groups (
960: p_pa_request_rec => l_sf52_data,
961: p_generic_ei_rec => l_agency_ei_data,

Line 1729: ghr_process_Sf52.Fetch_extra_info(

1725: l_session_var.assignment_id := p_sf52_data.employee_assignment_id;
1726:
1727: ghr_history_api.set_g_session_var(l_session_var);
1728:
1729: ghr_process_Sf52.Fetch_extra_info(
1730: p_pa_request_id => p_sf52_data.pa_request_id,
1731: p_noa_id => p_sf52_data.second_noa_id,
1732: p_agency_ei => TRUE,
1733: p_sf52_ei_data => l_agency_ei_data,

Line 1739: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);

1735:
1736: l_sf52_data := p_sf52_data;
1737: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1738: -- copy that information to 1st noa columns.
1739: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1740: -- null the second noa columns since we don't want anything to be done with these now.
1741: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1742:
1743: ghr_sf52_pre_update.populate_record_groups (

Line 1741: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);

1737: -- all corrections will have the original sf52 information in the 2nd noa columns, so
1738: -- copy that information to 1st noa columns.
1739: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data);
1740: -- null the second noa columns since we don't want anything to be done with these now.
1741: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data);
1742:
1743: ghr_sf52_pre_update.populate_record_groups (
1744: p_pa_request_rec => l_sf52_data,
1745: p_generic_ei_rec => l_agency_ei_data,

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

2537: IF (l_sf52_data.second_noa_code <> '780') then
2538: Refresh_Cascade_Name( p_sf52_rec => l_sf52_data,
2539: p_shadow_rec => l_shadow_data);
2540:
2541: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_sf52_data,
2542: p_shadow_data => l_shadow_data);
2543: END IF;
2544:
2545: l_sf52_data1 := l_sf52_data;

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

2573: -- Pre-record values of the root SF52 for refresh purpose.
2574: -- It'll be reset after refresh has been done
2575:
2576: ghr_history_api.set_g_session_var(l_session_var);
2577: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2578: p_shadow_data => l_shadow_data);
2579: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2580: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2581: p_shadow_data => l_shadow_data);

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

2575:
2576: ghr_history_api.set_g_session_var(l_session_var);
2577: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2578: p_shadow_data => l_shadow_data);
2579: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2580: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2581: p_shadow_data => l_shadow_data);
2582:
2583: -- reset pa_history_id in session variable.

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

2576: ghr_history_api.set_g_session_var(l_session_var);
2577: ghr_process_sf52.refresh_req_shadow(p_sf52_data => l_root_sf52,
2578: p_shadow_data => l_shadow_data);
2579: ghr_process_sf52.redo_pay_calc( p_sf52_rec => l_root_sf52);
2580: ghr_process_sf52.update_rfrs_values(p_sf52_data => l_root_sf52,
2581: p_shadow_data => l_shadow_data);
2582:
2583: -- reset pa_history_id in session variable.
2584: l_session_var.pa_history_id := null;

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

2604: -- when this completes, l_sf52_data_result will contain the data of the original
2605: -- sf52, with all corrections in the correction chain applied onto it.
2606: -- apply_noa_corrections ensures that name/dob/ssn are retained from the last correction ie the one being processed.
2607: hr_utility.set_location('from_step_or_rate right before apply_noa_corrections: '|| l_sf52_data.from_step_or_rate || l_proc, 915);
2608: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2609: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2610: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2611: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2612: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);

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

2605: -- sf52, with all corrections in the correction chain applied onto it.
2606: -- apply_noa_corrections ensures that name/dob/ssn are retained from the last correction ie the one being processed.
2607: hr_utility.set_location('from_step_or_rate right before apply_noa_corrections: '|| l_sf52_data.from_step_or_rate || l_proc, 915);
2608: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2609: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2610: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2611: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2612: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2613:

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

2607: hr_utility.set_location('from_step_or_rate right before apply_noa_corrections: '|| l_sf52_data.from_step_or_rate || l_proc, 915);
2608: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2609: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2610: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2611: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2612: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2613:
2614: ghr_process_Sf52.Fetch_extra_info(
2615: p_pa_request_id => l_sf52_data.pa_request_id,

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

2608: ghr_process_sf52.print_sf52(' l_sf52_data before apply_noa ',l_sf52_data);
2609: ghr_process_sf52.print_sf52(' l_sf52_data_result before apply_noa ',l_sf52_data_result);
2610: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2611: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2612: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2613:
2614: ghr_process_Sf52.Fetch_extra_info(
2615: p_pa_request_id => l_sf52_data.pa_request_id,
2616: p_noa_id => l_sf52_data.second_noa_id,

Line 2614: ghr_process_Sf52.Fetch_extra_info(

2610: apply_noa_corrections( l_sf52_data, l_sf52_data_result );
2611: ghr_process_sf52.print_sf52(' l_sf52_data after apply_noa ',l_sf52_data);
2612: ghr_process_sf52.print_sf52(' l_sf52_data_result after apply_noa ',l_sf52_data_result);
2613:
2614: ghr_process_Sf52.Fetch_extra_info(
2615: p_pa_request_id => l_sf52_data.pa_request_id,
2616: p_noa_id => l_sf52_data.second_noa_id,
2617: p_sf52_ei_data => l_sf52_ei_data,
2618: p_result => l_result);

Line 2620: ghr_process_Sf52.Fetch_extra_info(

2616: p_noa_id => l_sf52_data.second_noa_id,
2617: p_sf52_ei_data => l_sf52_ei_data,
2618: p_result => l_result);
2619:
2620: ghr_process_Sf52.Fetch_extra_info(
2621: p_pa_request_id => l_sf52_data.pa_request_id,
2622: p_noa_id => l_sf52_data.second_noa_id,
2623: p_agency_ei => TRUE,
2624: p_sf52_ei_data => l_agency_ei_data,

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

3284: -- Pre-record values of the root SF52 for refresh purpose.
3285: -- It'll be reset after refresh has been done
3286:
3287: ghr_history_api.set_g_session_var(l_session_var);
3288: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
3289: p_shadow_data => l_shadow_data);
3290: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
3291: p_capped_other_pay => l_capped_other_pay);
3292:

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

3286:
3287: ghr_history_api.set_g_session_var(l_session_var);
3288: ghr_process_sf52.refresh_req_shadow(p_sf52_data => p_sf52_data_result,
3289: p_shadow_data => l_shadow_data);
3290: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
3291: p_capped_other_pay => l_capped_other_pay);
3292:
3293: -- reset pa_history_id in session variable.
3294: l_session_var.pa_history_id := null;

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

3308: END IF;
3309: -- End of Bug#3543213
3310:
3311: -- check if original action in correction chain was a dual action. If so, determine which of
3312: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having
3313: -- to do with the noa we are correcting.
3314: if (p_sf52_data_result.second_noa_id is not null) then
3315: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
3316: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then

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

3314: if (p_sf52_data_result.second_noa_id is not null) then
3315: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
3316: if (p_sf52_data.second_noa_id = p_sf52_data_result.second_noa_id) then
3317: hr_utility.set_location('Correcting second action in dual action:'|| l_proc, 12);
3318: ghr_process_sf52.assign_new_rg(p_action_num => 2,
3319: p_pa_req => p_sf52_data_result);
3320: else
3321: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
3322: ghr_process_sf52.assign_new_rg(p_action_num => 1,

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

3318: ghr_process_sf52.assign_new_rg(p_action_num => 2,
3319: p_pa_req => p_sf52_data_result);
3320: else
3321: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
3322: ghr_process_sf52.assign_new_rg(p_action_num => 1,
3323: p_pa_req => p_sf52_data_result);
3324: -- if first action is 893, then we need to derive to_columns as both actions of
3325: -- the dual action potentially could have changed the to fields (in particular,
3326: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.

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

3324: -- if first action is 893, then we need to derive to_columns as both actions of
3325: -- the dual action potentially could have changed the to fields (in particular,
3326: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
3327: if (p_sf52_data_result.first_noa_code = 893) then
3328: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
3329: end if;
3330: end if;
3331: end if;
3332: -- Nullfy columns which must not be passed

Line 3349: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);

3345: hr_utility.set_location('Fetch l_sf52_data_step loop :'|| l_proc, 15);
3346: -- all corrections will have the original sf52 information in the 2nd noa columns, so
3347: -- copy that information to 1st noa columns.
3348: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3349: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
3350: -- null the second noa columns since we don't want anything to be done with these now.
3351: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3352: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
3353: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);

Line 3352: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);

3348: hr_utility.set_location('from grd or levelbefcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3349: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
3350: -- null the second noa columns since we don't want anything to be done with these now.
3351: hr_utility.set_location('from grd or levelaftcp2to1 =' || l_sf52_data_step.from_grade_or_level, 14);
3352: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
3353: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
3354: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
3355: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3356: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);

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

3353: hr_utility.set_location('from grd or levelaftnull2noa =' || l_sf52_data_step.from_grade_or_level, 14);
3354: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
3355: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3356: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
3357: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
3358: l_sf52_data_step );
3359: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
3360: p_sf52_data_result );
3361: -- Start Intervening Actions Processing

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

3355: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
3356: hr_utility.set_location('from grd or levelbef appcorr =' || l_sf52_data_step.from_grade_or_level, 14);
3357: ghr_process_sf52.print_sf52('l_sf52_step bef apply_correction',
3358: l_sf52_data_step );
3359: ghr_process_sf52.print_sf52('result bef copy_ia_rec_on_result',
3360: p_sf52_data_result );
3361: -- Start Intervening Actions Processing
3362: -- Processing added to assign the From side details to
3363: -- To side if it is a Intervening action and

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

3395: get_sf52_to_details_for_ia
3396: (p_pa_request_id => p_sf52_data.pa_request_id,
3397: p_retro_eff_date => l_retro_eff_date,
3398: p_sf52_ia_rec => p_sf52_data_result);
3399: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
3400: p_sf52_data_result );
3401: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3402: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
3403: p_sf52_data_result );

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

3398: p_sf52_ia_rec => p_sf52_data_result);
3399: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
3400: p_sf52_data_result );
3401: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3402: ghr_process_sf52.print_sf52('reslt aft get_sf52_to_other_pay_det_for_ia',
3403: p_sf52_data_result );
3404: ELSE
3405: -- Verify whether the original action is one of the salary change actions
3406: -- If yes, check whether the other pay related elements are present or not

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

3406: -- If yes, check whether the other pay related elements are present or not
3407: -- as on the effective date. If they are not present, set that other pay comp
3408: -- to_value as null.
3409: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
3410: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',
3411: p_sf52_data_result );
3412: END IF;
3413:
3414:

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

5095: -- Bug 3228557 Added the following IF condition. In case of NPA Printing
5096: -- Pass parameter 'NPA' to the procedure call to refresh_req_shadow.
5097: IF NVL(p_called_from,hr_api.g_varchar2) = 'NPA' THEN
5098: hr_utility.set_location('Inside NPA printing',10);
5099: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5100: p_shadow_data=>l_shadow_data,
5101: p_process_type => 'NPA');
5102: ELSE
5103: hr_utility.set_location('Calling Refresh_req_shadow ',10);

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

5100: p_shadow_data=>l_shadow_data,
5101: p_process_type => 'NPA');
5102: ELSE
5103: hr_utility.set_location('Calling Refresh_req_shadow ',10);
5104: ghr_process_sf52.refresh_req_shadow(p_sf52_data=>p_sf52_data_result,
5105: p_shadow_data=>l_shadow_data);
5106: END IF;
5107: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5108: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN

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

5105: p_shadow_data=>l_shadow_data);
5106: END IF;
5107: -- Bug 3228557 Skip Pay Calculation in case of NPA report printing.
5108: IF nvl(p_called_from,hr_api.g_varchar2) NOT IN ('FROM_PAYCAL','NPA') THEN
5109: ghr_process_sf52.redo_pay_calc( p_sf52_rec => p_sf52_data_result,
5110: p_capped_other_pay => l_capped_other_pay);
5111: END IF;
5112: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
5113: hr_utility.set_location(l_proc || 'pa_request_id of original= ' || l_sf52_data_step.pa_request_id,26);

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

5111: END IF;
5112: hr_utility.set_location('assignment_id of original =' || l_sf52_data_step.employee_assignment_id, 14);
5113: hr_utility.set_location(l_proc || 'pa_request_id of original= ' || l_sf52_data_step.pa_request_id,26);
5114: -- check if original action in correction chain was a dual action. If so, determine which of
5115: -- the two actions this correction is for and call ghr_process_sf52.assign_new_rg to null out columns not having
5116: -- to do with the noa we are correcting.
5117: if (p_sf52_data_result.second_noa_id is not null) then
5118: hr_utility.set_location('original sf52 is dual action :'|| l_proc, 11);
5119: ---- commented the below if condition because is is compared against NOAC Code

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

5120: ---- Dual action correction need to be tested.
5121: ---- if (p_noa_code_correct = p_sf52_data_result.second_noa_id) then
5122: if (p_noa_code_correct = p_sf52_data_result.second_noa_code) then
5123: hr_utility.set_location('Correcting second action in dual action:'|| l_proc, 12);
5124: ghr_process_sf52.assign_new_rg(p_action_num => 2,
5125: p_pa_req => p_sf52_data_result);
5126: else
5127: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
5128: ghr_process_sf52.assign_new_rg(p_action_num => 1,

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

5124: ghr_process_sf52.assign_new_rg(p_action_num => 2,
5125: p_pa_req => p_sf52_data_result);
5126: else
5127: hr_utility.set_location('Correcting first action in dual action:'|| l_proc, 13);
5128: ghr_process_sf52.assign_new_rg(p_action_num => 1,
5129: p_pa_req => p_sf52_data_result);
5130: -- if first action is 893, then we need to derive to_columns as both actions of
5131: -- the dual action potentially could have changed the to fields (in particular,
5132: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.

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

5130: -- if first action is 893, then we need to derive to_columns as both actions of
5131: -- the dual action potentially could have changed the to fields (in particular,
5132: -- to_step_or_rate) so we need to determine what the to_fields should be or the first action.
5133: if (p_sf52_data_result.first_noa_code = 893) then
5134: ghr_process_sf52.derive_to_columns(p_sf52_data => p_sf52_data_result);
5135: end if;
5136: end if;
5137: end if;
5138: -- Nullfy columns which must not be passed

Line 5153: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);

5149: else
5150: hr_utility.set_location('Fetch l_sf52_data_step loop :'|| l_proc, 15);
5151: -- all corrections will have the original sf52 information in the 2nd noa columns, so
5152: -- copy that information to 1st noa columns.
5153: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
5154: -- null the second noa columns since we don't want anything to be done with these now.
5155: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
5156: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
5157: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);

Line 5155: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);

5151: -- all corrections will have the original sf52 information in the 2nd noa columns, so
5152: -- copy that information to 1st noa columns.
5153: ghr_process_sf52.copy_2ndNoa_to_1stNoa(l_sf52_data_step);
5154: -- null the second noa columns since we don't want anything to be done with these now.
5155: ghr_process_sf52.null_2ndNoa_cols(l_sf52_data_step);
5156: hr_utility.set_location(l_proc || 'pa_request_id before correction= ' || l_sf52_data_step.pa_request_id,16);
5157: hr_utility.set_location(l_proc || 'assignment id before correction= ' || l_sf52_data_step.employee_assignment_id,17);
5158: -- Start Intervening Actions Processing
5159: -- Processing added to assign the From side details to

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

5194: (p_pa_request_id => p_pa_request_id,
5195: p_retro_eff_date => l_retro_eff_date,
5196: p_sf52_ia_rec => p_sf52_data_result);
5197: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
5198: ghr_process_sf52.print_sf52('result aft get_sf52_to_details_for_ia',
5199: p_sf52_data_result );
5200: ELSE
5201: -- Verify whether the original action is one of the salary change actions
5202: -- If yes, check whether the other pay related elements are present or not

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

5202: -- If yes, check whether the other pay related elements are present or not
5203: -- as on the effective date. If they are not present, set that other pay comp
5204: -- to_value as null.
5205: get_sf52_to_othpays_for_ia(p_sf52_ia_rec => p_sf52_data_result);
5206: ghr_process_sf52.print_sf52('Aft get_sf52_to_other_pay_det_for_ia in else',
5207: p_sf52_data_result );
5208: END IF;
5209: END IF;
5210: END LOOP;

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

5207: p_sf52_data_result );
5208: END IF;
5209: END IF;
5210: END LOOP;
5211: ghr_process_sf52.print_sf52('step aft get_sf52_to_details_for_ia',
5212: l_sf52_data_step);
5213: apply_correction( p_sf52rec_correct => l_sf52_data_step,
5214: p_corr_pa_request_id => p_pa_request_id,
5215: p_sf52rec => p_sf52_data_result );

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

5308: END IF;
5309: END IF;
5310: -- Bug#5435374 End of bug fix.
5311:
5312: ghr_process_sf52.print_sf52('Result after apply_correction ' , p_sf52_data_result);
5313:
5314: hr_utility.set_location(' Leaving:'||l_proc, 25);
5315: exception when others then
5316: --