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_VALIDATE_CHECK dependencies on GHR_PA_REQUESTS

Line 4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE

1: package body GHR_Validate_CHECK AS
2: /* $Header: ghrvalid.pkb 120.46.12020000.11 2013/02/15 09:06:23 utokachi ship $ */
3:
4: procedure Validate_CHECK(p_pa_request_rec IN ghr_pa_requests%ROWTYPE
5: ,p_per_group1 IN ghr_api.per_group1_type
6: ,p_per_retained_grade IN ghr_api.per_retained_grade_type
7: ,p_per_sep_retire in ghr_api.per_sep_retire_type
8: ,p_per_conversions in ghr_api.per_conversions_type

Line 35: l_part_time_hr ghr_pa_requests.part_time_hours%type;

31: l_person_usr_type per_person_types.user_person_type%type;
32: l_person_sys_type per_person_types.system_person_type%type;
33: l_psn_status per_positions.status%type;
34:
35: l_part_time_hr ghr_pa_requests.part_time_hours%type;
36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;

Line 36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

32: l_person_sys_type per_person_types.system_person_type%type;
33: l_psn_status per_positions.status%type;
34:
35: l_part_time_hr ghr_pa_requests.part_time_hours%type;
36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;

Line 38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;

34:
35: l_part_time_hr ghr_pa_requests.part_time_hours%type;
36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;

Line 39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;

35: l_part_time_hr ghr_pa_requests.part_time_hours%type;
36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;

Line 40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;

36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:

Line 41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;

37:
38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;

Line 42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;

38: l_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;

Line 43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;

39: l_To_Basic_Pay ghr_pa_requests.TO_BASIC_PAY%type;
40: l_To_Locality_Adj ghr_pa_requests.TO_LOCALITY_ADJ%type;
41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;
47:

Line 45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;

41: l_To_adj_basic_pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;
47:
48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;
49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;

Line 46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;

42: l_To_other_pay ghr_pa_requests.TO_OTHER_PAY_AMOUNT%type;
43: l_To_total_pay ghr_pa_requests.TO_TOTAL_SALARY%type;
44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;
47:
48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;
49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;
50:

Line 48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;

44:
45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;
47:
48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;
49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;
50:
51: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
52:

Line 49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;

45: l_to_step_or_rate ghr_pa_requests.to_step_or_rate%type;
46: l_from_step_or_rate ghr_pa_requests.from_step_or_rate%type;
47:
48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;
49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;
50:
51: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
52:
53: l_AUO varchar2(30):=null;

Line 51: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;

47:
48: l_Retention_Allowance ghr_pa_requests.TO_RETENTION_ALLOWANCE%type;
49: l_staffing_differential ghr_pa_requests.TO_STAFFING_DIFFERENTIAL%type;
50:
51: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
52:
53: l_AUO varchar2(30):=null;
54: l_Availablility varchar2(30):=null;
55: l_assignment_id ghr_pa_requests.EMPLOYEE_ASSIGNMENT_ID%type;

Line 55: l_assignment_id ghr_pa_requests.EMPLOYEE_ASSIGNMENT_ID%type;

51: l_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
52:
53: l_AUO varchar2(30):=null;
54: l_Availablility varchar2(30):=null;
55: l_assignment_id ghr_pa_requests.EMPLOYEE_ASSIGNMENT_ID%type;
56: l_prem_pay varchar2(30);
57: l_amount number;
58: l_multiple_error_flag boolean;
59: l_session ghr_history_api.g_session_var_type;

Line 74: l_to_supervisor_diff ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type ;

70: l_auo_amount number;
71: l_exists boolean;
72: l_noa_family_code ghr_families.noa_family_code%type;
73: l_to_agency_code per_people_extra_info.pei_information8%type;
74: l_to_supervisor_diff ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type ;
75: l_award_salary ghr_pa_requests.from_basic_pay%type ; -- Bug 3376761
76:
77: l_slr_recur_amount number;
78: l_slr_lumpsum number;

Line 75: l_award_salary ghr_pa_requests.from_basic_pay%type ; -- Bug 3376761

71: l_exists boolean;
72: l_noa_family_code ghr_families.noa_family_code%type;
73: l_to_agency_code per_people_extra_info.pei_information8%type;
74: l_to_supervisor_diff ghr_pa_requests.TO_SUPERVISORY_DIFFERENTIAL%type ;
75: l_award_salary ghr_pa_requests.from_basic_pay%type ; -- Bug 3376761
76:
77: l_slr_recur_amount number;
78: l_slr_lumpsum number;
79:

Line 242: CURSOR c_future_actions(c_person_id ghr_pa_requests.person_id%type, c_effective_date ghr_pa_requests.effective_date%type) IS

238: and ipv.input_value_id = eev.input_value_id
239: and ele.element_entry_id + 0 = eev.element_entry_id ;
240:
241: -- Sundar 3263109 To find out if any future actions exist.
242: CURSOR c_future_actions(c_person_id ghr_pa_requests.person_id%type, c_effective_date ghr_pa_requests.effective_date%type) IS
243: SELECT par.pa_request_id futr_rpa
244: FROM ghr_pa_routing_history prh
245: ,ghr_pa_requests par
246: WHERE prh.pa_request_id = par.pa_request_id

Line 245: ,ghr_pa_requests par

241: -- Sundar 3263109 To find out if any future actions exist.
242: CURSOR c_future_actions(c_person_id ghr_pa_requests.person_id%type, c_effective_date ghr_pa_requests.effective_date%type) IS
243: SELECT par.pa_request_id futr_rpa
244: FROM ghr_pa_routing_history prh
245: ,ghr_pa_requests par
246: WHERE prh.pa_request_id = par.pa_request_id
247: AND par.person_id = c_person_id
248: AND par.effective_date > c_effective_date
249: AND prh.pa_routing_history_id = (SELECT MAX(prh2.pa_routing_history_id)

Line 269: l_futr_actions ghr_pa_requests.pa_request_id%type;

265: AND NVL(par.second_noa_cancel_or_correct,'X') <> 'CANCEL'
266: )
267: );
268:
269: l_futr_actions ghr_pa_requests.pa_request_id%type;
270:
271: --
272: -- Madhuri 3417859 Start fix of variables and cursor
273: --

Line 311: FROM ghr_pa_requests

307: AND information_type = 'GHR_US_PAR_PREMIUM_PAY_IND';
308:
309: CURSOR cur_job_code is
310: SELECT from_occ_code
311: FROM ghr_pa_requests
312: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
313:
314: l_occ_code ghr_pa_requests.from_occ_code%TYPE;
315:

Line 314: l_occ_code ghr_pa_requests.from_occ_code%TYPE;

310: SELECT from_occ_code
311: FROM ghr_pa_requests
312: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
313:
314: l_occ_code ghr_pa_requests.from_occ_code%TYPE;
315:
316: --Begin Bug# 8653508
317: l_detail_type ghr_pa_request_extra_info.rei_information3%type;
318: l_unclassified_duty_ind ghr_pa_request_extra_info.rei_information4%type;

Line 330: p_eff_date ghr_pa_requests.effective_date%TYPE) IS

326: WHERE pa_request_id = p_pa_request_rec.pa_request_id
327: AND information_type = 'GHR_US_PAR_DET_INFO';
328:
329: CURSOR cur_detail_exists(p_asg_id per_assignments_f.assignment_id%TYPE,
330: p_eff_date ghr_pa_requests.effective_date%TYPE) IS
331: SELECT user_status
332: FROM per_assignment_status_types pst, per_assignments_f paf
333: WHERE paf.assignment_status_type_id = pst.assignment_status_type_id
334: AND paf.assignment_type <> 'B'

Line 341: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;

337: and paf.effective_end_date = to_date('31/12/4712','DD/MM/RRRR');
338:
339: --End Bug# 8653508
340: --Begin Bug# 9899054
341: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
342: CURSOR c_detail_first_nte_date is
343: SELECT first_noa_information1
344: FROM ghr_pa_requests
345: WHERE pa_request_id = p_pa_request_rec.pa_request_id;

Line 344: FROM ghr_pa_requests

340: --Begin Bug# 9899054
341: l_detail_nte_date ghr_pa_requests.first_noa_information1%type;
342: CURSOR c_detail_first_nte_date is
343: SELECT first_noa_information1
344: FROM ghr_pa_requests
345: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
346:
347: CURSOR c_detail_second_nte_date is
348: SELECT second_noa_information1

Line 349: FROM ghr_pa_requests

345: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
346:
347: CURSOR c_detail_second_nte_date is
348: SELECT second_noa_information1
349: FROM ghr_pa_requests
350: WHERE pa_request_id = p_pa_request_rec.pa_request_id;
351: --end Bug# 9899054
352:
353: l_asg_extra_info_rec per_assignment_extra_info%rowtype;--Bug# 11776559

Line 386: p_asg_id ghr_pa_requests.employee_assignment_id%type)

382: l_review_date date;
383:
384: CURSOR cur_studloan_ele_end_date(
385: p_ele_name pay_element_types_f.element_name%type,
386: p_asg_id ghr_pa_requests.employee_assignment_id%type)
387: IS
388: select ele.effective_end_date
389: from pay_element_types_f elt,
390: pay_element_links_f ell,

Line 458: p_eff_date ghr_pa_requests.effective_date%TYPE)

454: l_nte_date_flg BOOLEAN:=FALSE;
455:
456: --
457: CURSOR cur_nte_check(p_asg_id per_assignments_f.assignment_id%TYPE,
458: p_eff_date ghr_pa_requests.effective_date%TYPE)
459: IS
460: SELECT user_status
461: FROM per_assignment_status_types pst, per_assignments_f paf
462: WHERE paf.assignment_status_type_id = pst.assignment_status_type_id

Line 597: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_pa_request_rec.to_position_id,

593: hr_utility.set_message(8301,'GHR_38288_POSITION_INVALID');
594: hr_utility.raise_error;
595: end;
596: End If;
597: l_psi := ghr_pa_requests_pkg.get_personnel_system_indicator(p_pa_request_rec.to_position_id,
598: p_pa_request_rec.effective_date);
599:
600: /* Get Person Status and last of DDF retrivals.
601: