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_MASS_SEL_NOA dependencies on GHR_MSL_PKG

Line 700: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date

696: hr_utility.set_location ('Org ID PASS', 10);
697:
698: IF p_mnoa_personnel_office_id IS NOT NULL THEN
699: hr_utility.set_location ('POID CHECK', 15);
700: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date
701: , l_pos_grp1_rec);
702: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
703: l_org_structure_id := l_pos_grp1_rec.poei_information5;
704: l_fetch_poid_data := TRUE;

Line 712: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id

708: OR NOT (l_fetch_poid_data) THEN
709: hr_utility.set_location ('POID PASS', 20);
710: IF p_mnoa_agency_code_subelement IS NOT NULL THEN
711: hr_utility.set_location ('Agency CHECK', 25);
712: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id
713: , l_business_group_id, l_assignment_id
714: , l_effective_date, l_sub_element_code
715: , l_position_title, l_position_number
716: , l_position_seq_no);

Line 826: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id

822: , l_pay_rate_determinant, l_work_schedule
823: , l_part_time_hour);
824:
825: IF NOT l_fetch_agency_data THEN
826: ghr_msl_pkg.get_sub_element_code_pos_title (l_position_id, p_person_id
827: , l_business_group_id, l_assignment_id
828: , l_effective_date, l_sub_element_code
829: , l_position_title, l_position_number
830: , l_position_seq_no);

Line 834: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date, l_pos_grp1_rec);

830: , l_position_seq_no);
831: END IF;
832: --Begin Bug# 14726863
833: IF NOT l_fetch_poid_data THEN
834: ghr_msl_pkg.get_pos_grp1_ddf (l_position_id, l_effective_date, l_pos_grp1_rec);
835: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
836: END IF;
837: --End Bug# 14726863
838: BEGIN

Line 839: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id

835: l_personnel_office_id := l_pos_grp1_rec.poei_information3;
836: END IF;
837: --End Bug# 14726863
838: BEGIN
839: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id
840: , l_position_id, l_effective_date
841: , l_grade_id, l_to_grade_id
842: , l_assignment_id, 'SHOW'
843: , l_pay_plan, l_to_pay_plan

Line 1986: WHERE code = ghr_msl_pkg.g_first_noa_code

1982: WHERE nature_of_action_id IN
1983: (
1984: SELECT nature_of_action_id
1985: FROM ghr_nature_of_actions
1986: WHERE code = ghr_msl_pkg.g_first_noa_code
1987: )
1988: )
1989: AND proc_method_flag = 'Y';
1990:

Line 2565: hr_utility.set_location ('Before calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 70);

2561: RAISE mnoa_error;
2562: END;
2563: END IF;
2564: -- End Bug# 14751973
2565: hr_utility.set_location ('Before calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 70);
2566: ghr_msl_pkg.get_from_sf52_data_elements (l_assignment_id, l_effective_date
2567: , l_old_basic_pay, l_old_avail_pay
2568: , l_old_loc_diff, l_tot_old_sal
2569: , l_old_auo_pay, l_old_adj_basic_pay

Line 2566: ghr_msl_pkg.get_from_sf52_data_elements (l_assignment_id, l_effective_date

2562: END;
2563: END IF;
2564: -- End Bug# 14751973
2565: hr_utility.set_location ('Before calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 70);
2566: ghr_msl_pkg.get_from_sf52_data_elements (l_assignment_id, l_effective_date
2567: , l_old_basic_pay, l_old_avail_pay
2568: , l_old_loc_diff, l_tot_old_sal
2569: , l_old_auo_pay, l_old_adj_basic_pay
2570: , l_other_pay, l_auo_premium_pay_indicator

Line 2575: hr_utility.set_location ('After calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 71);

2571: , l_ap_premium_pay_indicator, l_retention_allowance
2572: , l_retention_allow_perc, l_supervisory_differential
2573: , l_supervisory_diff_perc, l_staffing_differential);
2574:
2575: hr_utility.set_location ('After calling ghr_msl_pkg.get_from_sf52_data_elements :'|| l_proc, 71);
2576: --Begin Bug# 14414972, for NON_PAY_DUTY_STATION family pay calc is not required, so skipping
2577: IF l_noa_code NOT IN ('430','460','471','472') THEN
2578: l_pay_calc_in_data.person_id := p_person_id;
2579: l_pay_calc_in_data.position_id := l_position_id;

Line 2843: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id

2839: END;
2840: --Begin Bug# 14414972, for NON_PAY_DUTY_STATION family pay calc is not required
2841: ELSE
2842: BEGIN
2843: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id
2844: , l_position_id, l_effective_date
2845: , l_grade_id, l_assignment_id
2846: , 'SHOW', l_pay_plan
2847: , l_pay_table_id, l_grade_or_level

Line 2853: hr_utility.set_location ('Error in ghr_msl_pkg.get_pay_plan_and_table_id of '|| ' Err is '|| sqlerrm (sqlcode), 20);

2849:
2850: EXCEPTION
2851:
2852: WHEN OTHERS THEN
2853: hr_utility.set_location ('Error in ghr_msl_pkg.get_pay_plan_and_table_id of '|| ' Err is '|| sqlerrm (sqlcode), 20);
2854: l_pay_plan := p_pay_plan;
2855: l_to_pay_plan := p_to_pay_plan;
2856: l_pay_table_id := p_pay_table_id;
2857: l_grade_or_level := p_grade_or_level;

Line 2937: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id

2933: , p_work_schedule => l_work_schedule);
2934: -- End Bug# 14751973
2935: ELSIF upper (p_action) = 'CREATE' THEN
2936: BEGIN
2937: ghr_msl_pkg.get_pay_plan_and_table_id (l_pay_rate_determinant, p_person_id
2938: , l_position_id, l_effective_date
2939: , l_grade_id, l_assignment_id
2940: , 'CREATE', l_pay_plan
2941: , l_pay_table_id, l_grade_or_level

Line 2944: WHEN ghr_msl_pkg.msl_error THEN

2940: , 'CREATE', l_pay_plan
2941: , l_pay_table_id, l_grade_or_level
2942: , l_step_or_rate, l_pay_basis);
2943: EXCEPTION
2944: WHEN ghr_msl_pkg.msl_error THEN
2945: l_noaerrbuf := hr_utility.get_message;
2946: RAISE mnoa_error;
2947: END;
2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);

Line 2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);

2944: WHEN ghr_msl_pkg.msl_error THEN
2945: l_noaerrbuf := hr_utility.get_message;
2946: RAISE mnoa_error;
2947: END;
2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);
2949: ghr_msl_pkg.assign_to_sf52_rec (p_person_id, p_first_name
2950: , p_last_name, p_middle_names
2951: , p_national_identifier, p_date_of_birth
2952: , l_effective_date, l_assignment_id

Line 2949: ghr_msl_pkg.assign_to_sf52_rec (p_person_id, p_first_name

2945: l_noaerrbuf := hr_utility.get_message;
2946: RAISE mnoa_error;
2947: END;
2948: hr_utility.set_location ('Callin ghr_msl_pkg.assign_to_sf52_rec ' || l_sf52_rec.first_noa_information1, 233);
2949: ghr_msl_pkg.assign_to_sf52_rec (p_person_id, p_first_name
2950: , p_last_name, p_middle_names
2951: , p_national_identifier, p_date_of_birth
2952: , l_effective_date, l_assignment_id
2953: , l_tenure, nvl (l_out_grade_id, l_to_grade_id)

Line 3050: ghr_msl_pkg.create_lac_remarks (l_pa_request_id, l_sf52_rec.pa_request_id);

3046: || ' Mass NOA Selectable : '
3047: || p_mass_salary
3048: || ' SF52 Successfully completed');
3049:
3050: ghr_msl_pkg.create_lac_remarks (l_pa_request_id, l_sf52_rec.pa_request_id);
3051:
3052: g_proc := 'update_SEL_FLG';
3053: update_sel_flg (p_person_id, l_effective_date);
3054: COMMIT;

Line 3217: ghr_msl_pkg.g_first_noa_code := l_noa_code;

3213: ELSE
3214: ghr_mto_int.set_log_program_name ('MSNOA_'|| p_mass_salary);
3215: END IF;
3216: get_lac_dtls (l_pa_request_id, l_lac_sf52_rec);
3217: ghr_msl_pkg.g_first_noa_code := l_noa_code;
3218: hr_utility.set_location ('Mass Action name '|| p_action, 52);
3219: --hr_utility.trace_on (NULL, 'raju');
3220: IF l_noa_code IN ('460') THEN
3221: FOR per IN cur_active_people (l_effective_date) LOOP

Line 4753: ghr_msl_pkg.create_lac_remarks (l_pa_request_id, l_can_pa_request_id);

4749: || ' Mass Cancellation : '
4750: || p_mass_salary
4751: || ' SF52 Successfully completed');
4752:
4753: ghr_msl_pkg.create_lac_remarks (l_pa_request_id, l_can_pa_request_id);
4754:
4755: COMMIT;
4756: ELSE
4757: pr ('Error in create sf52', l_errbuf);