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

Line 8: g_Adj_Base_Pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;

4:
5: g_bypass_cpdf boolean := FALSE;
6:
7: g_academic_discipline varchar2(30);
8: g_Adj_Base_Pay ghr_pa_requests.TO_ADJ_BASIC_PAY%type;
9: g_Agency_Code varchar2(30);
10: g_agency_subelement varchar2(30);
11: g_as_of_date date;
12: g_Benefit_Amount varchar2(30);

Line 13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;

9: g_Agency_Code varchar2(30);
10: g_agency_subelement varchar2(30);
11: g_as_of_date date;
12: g_Benefit_Amount varchar2(30);
13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;
15: g_credit_mil_svc per_people_extra_info.pei_information5%type;
16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;

Line 14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;

10: g_agency_subelement varchar2(30);
11: g_as_of_date date;
12: g_Benefit_Amount varchar2(30);
13: g_bargaining_unit_status_code ghr_pa_requests.BARGAINING_UNIT_STATUS%type;
14: g_citizenship ghr_pa_requests.CITIZENSHIP%type;
15: g_credit_mil_svc per_people_extra_info.pei_information5%type;
16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;

Line 20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;

16: g_Cur_Appt_Auth_1 per_people_extra_info.pei_information8%type;
17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;
19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
22: g_Employee_Date_of_Birth per_people_f.date_of_birth%type;
23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;

Line 21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;

17: g_Cur_Appt_Auth_2 per_people_extra_info.pei_information9%type;
18: g_Duty_Station_ID hr_location_extra_info.lei_information3%type;
19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
22: g_Employee_Date_of_Birth per_people_f.date_of_birth%type;
23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);

Line 23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;

19: g_Duty_Station_Lookup_Code ghr_duty_stations_f.Duty_Station_Code%type;
20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
22: g_Employee_Date_of_Birth per_people_f.date_of_birth%type;
23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;

Line 24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;

20: g_education_level ghr_pa_requests.EDUCATION_LEVEL%type;
21: g_effective_date ghr_pa_requests.EFFECTIVE_DATE%type;
22: g_Employee_Date_of_Birth per_people_f.date_of_birth%type;
23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;
28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;

Line 26: g_fegli_code ghr_pa_requests.FEGLI%type;

22: g_Employee_Date_of_Birth per_people_f.date_of_birth%type;
23: g_Employee_First_Name ghr_pa_requests.EMPLOYEE_FIRST_NAME%type;
24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;
28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);

Line 28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;

24: g_Employee_Last_Name ghr_pa_requests.EMPLOYEE_LAST_NAME%type;
25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;
28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes
32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;

Line 29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;

25: g_employee_National_ID varchar2(30);
26: g_fegli_code ghr_pa_requests.FEGLI%type;
27: g_fers_coverage per_people_extra_info.pei_information3%type;
28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes
32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;
33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;

Line 32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;

28: g_First_Action_NOA_LA_Code1 ghr_pa_requests.FIRST_ACTION_LA_CODE1%type;
29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes
32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;
33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
34: g_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
35: g_health_plan varchar2(30);
36: g_Handicap per_people_extra_info.pei_information11%type;

Line 33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;

29: g_First_Action_NOA_LA_Code2 ghr_pa_requests.FIRST_ACTION_LA_CODE2%type;
30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes
32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;
33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
34: g_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
35: g_health_plan varchar2(30);
36: g_Handicap per_people_extra_info.pei_information11%type;
37: g_Indiv_Award varchar2(30);

Line 34: g_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;

30: g_First_NOAC_Lookup_Code varchar2(30);
31: -- Bug#4486823 RRR Changes
32: g_First_NOAC_Lookup_desc ghr_pa_requests.first_noa_desc%TYPE;
33: g_flsa_category ghr_pa_requests.FLSA_CATEGORY%type;
34: g_functional_class ghr_pa_requests.FUNCTIONAL_CLASS%type;
35: g_health_plan varchar2(30);
36: g_Handicap per_people_extra_info.pei_information11%type;
37: g_Indiv_Award varchar2(30);
38: g_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;

Line 39: g_Occupation_code ghr_pa_requests.to_occ_code%type;

35: g_health_plan varchar2(30);
36: g_Handicap per_people_extra_info.pei_information11%type;
37: g_Indiv_Award varchar2(30);
38: g_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
39: g_Occupation_code ghr_pa_requests.to_occ_code%type;
40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
41: g_Organ_Component per_position_extra_info.poei_information5%type;
42: g_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
43: g_Personnel_Officer_ID per_position_extra_info.poei_information3%type;

Line 40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;

36: g_Handicap per_people_extra_info.pei_information11%type;
37: g_Indiv_Award varchar2(30);
38: g_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
39: g_Occupation_code ghr_pa_requests.to_occ_code%type;
40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
41: g_Organ_Component per_position_extra_info.poei_information5%type;
42: g_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
43: g_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
44: g_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;

Line 42: g_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;

38: g_locality_pay_area ghr_locality_pay_areas_f.Locality_Pay_Area_Code%type;
39: g_Occupation_code ghr_pa_requests.to_occ_code%type;
40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
41: g_Organ_Component per_position_extra_info.poei_information5%type;
42: g_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
43: g_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
44: g_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
45: g_Prior_Basic_Pay varchar2(30); --number;
46: g_prior_duty_station varchar2(30);

Line 44: g_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;

40: g_One_Time_Payment_Amount ghr_pa_requests.AWARD_AMOUNT%type;
41: g_Organ_Component per_position_extra_info.poei_information5%type;
42: g_pay_rate_determinant_code ghr_pa_requests.PAY_RATE_DETERMINANT%type;
43: g_Personnel_Officer_ID per_position_extra_info.poei_information3%type;
44: g_Position_Occ_Code ghr_pa_requests.POSITION_OCCUPIED%type;
45: g_Prior_Basic_Pay varchar2(30); --number;
46: g_prior_duty_station varchar2(30);
47: g_Prior_Grade_Or_Level per_grade_definitions.segment2%type;
48: g_Prior_Locality_Adj varchar2(30); --number;

Line 66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;

62: g_retain_pay_plan per_people_extra_info.pei_information5%type;
63: g_retain_step per_people_extra_info.pei_information4%type;
64: g_temp_step per_people_extra_info.pei_information9%type;
65: g_fw_annualize varchar2(1);
66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
67: g_Retention_Allowance varchar2(30);
68: g_Second_NOAC_Lookup_code varchar2(30);
69: g_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
70: g_Sex per_people_f.sex%type;

Line 69: g_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;

65: g_fw_annualize varchar2(1);
66: g_Retirement_Plan_Code ghr_pa_requests.RETIREMENT_PLAN%type;
67: g_Retention_Allowance varchar2(30);
68: g_Second_NOAC_Lookup_code varchar2(30);
69: g_Service_Computation_Date ghr_pa_requests.SERVICE_COMP_DATE%type;
70: g_Sex per_people_f.sex%type;
71: g_special_pay_table_id per_position_extra_info.poei_information5%type;
72: g_staffing_differential varchar2(30);
73: g_submission_date date;

Line 75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;

71: g_special_pay_table_id per_position_extra_info.poei_information5%type;
72: g_staffing_differential varchar2(30);
73: g_submission_date date;
74: g_supervisory_differential varchar2(30);
75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;

Line 76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;

72: g_staffing_differential varchar2(30);
73: g_submission_date date;
74: g_supervisory_differential varchar2(30);
75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;

Line 77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;

73: g_submission_date date;
74: g_supervisory_differential varchar2(30);
75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;

Line 78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;

74: g_supervisory_differential varchar2(30);
75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);

Line 79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;

75: g_Supervisory_Status_Code ghr_pa_requests.SUPERVISORY_STATUS%type;
76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;

Line 80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;

76: g_Tenure_Group_Code ghr_pa_requests.TENURE%type;
77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

Line 81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;

77: g_To_Basic_Pay varchar2(30); -- ghr_pa_requests.TO_BASIC_PAY%type;
78: g_To_Grade_Or_Level ghr_pa_requests.TO_GRADE_OR_LEVEL%type;
79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;

Line 83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;

79: g_To_Locality_Adj varchar2(30); --ghr_pa_requests.TO_LOCALITY_ADJ%type;
80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

Line 84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;

80: g_To_Pay_Basis ghr_pa_requests.TO_PAY_BASIS%type;
81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;

Line 85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;

81: g_To_Pay_Plan ghr_pa_requests.TO_PAY_PLAN%type;
82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
89: g_race_ethnic_info varchar2(30); -- -- Bug 4724337 Race or National Origin changes

Line 86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;

82: g_To_Pay_Status varchar2(30);
83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
89: g_race_ethnic_info varchar2(30); -- -- Bug 4724337 Race or National Origin changes
90: --Begin Bug# 11726461

Line 87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

83: g_To_Position_ID ghr_pa_requests.TO_Position_ID%type;
84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
89: g_race_ethnic_info varchar2(30); -- -- Bug 4724337 Race or National Origin changes
90: --Begin Bug# 11726461
91: g_scd_leave date;

Line 88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;

84: g_To_Step_Or_Rate ghr_pa_requests.TO_STEP_OR_RATE%type;
85: g_Veterans_Preference_Code ghr_pa_requests.VETERANS_PREFERENCE%type;
86: g_Veterans_Status_Code ghr_pa_requests.VETERANS_STATUS%type;
87: g_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;
88: g_year_degree_attained ghr_pa_requests.YEAR_DEGREE_ATTAINED%type;
89: g_race_ethnic_info varchar2(30); -- -- Bug 4724337 Race or National Origin changes
90: --Begin Bug# 11726461
91: g_scd_leave date;
92: g_scd_retirement date;

Line 98: p_pa_request_rec in ghr_pa_requests%rowtype

94: --
95: --
96: procedure GHRWS52L
97: (
98: p_pa_request_rec in ghr_pa_requests%rowtype
99: ,p_per_group1 in ghr_api.per_group1_type
100: ,p_per_retained_grade in ghr_api.per_retained_grade_type
101: ,p_per_sep_retire in ghr_api.per_sep_retire_type
102: ,p_per_conversions in ghr_api.per_conversions_type