[Home] [Help]
PACKAGE: APPS.GHR_GHRWS52L
Source
1 package GHR_GHRWS52L AS
2 /* $Header: ghrws52l.pkh 120.4.12000000.1 2007/01/18 14:16:37 appldev ship $ */
3 --
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);
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;
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;
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;
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;
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;
49 g_prior_locality_pay_area varchar2(30);
50 g_Prior_Occupation_code per_job_definitions.segment1%type;
51 g_Prior_Pay_Basis per_position_extra_info.poei_information6%type;
52 g_Prior_Pay_Plan per_grade_definitions.segment1%type;
53 g_Prior_Pay_Rate_Det_Code per_assignment_extra_info.aei_information6%type;
54 g_Prior_Step_Or_Rate per_assignment_extra_info.aei_information3%type;
55 g_prior_work_schedule_code varchar2(30);
56 g_Production_Date date;
57 g_Race_National_Region per_people_extra_info.pei_information5%type;
58 g_rating_of_record_level varchar2(30);
59 g_rating_of_record_pattern varchar2(30);
60 g_rating_of_record_period varchar2(30);
61 g_retain_grade per_people_extra_info.pei_information3%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;
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;
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;
89 g_race_ethnic_info varchar2(30); -- -- Bug 4724337 Race or National Origin changes
90
91 --
92 --
93 procedure GHRWS52L
94 (
95 p_pa_request_rec in ghr_pa_requests%rowtype
96 ,p_per_group1 in ghr_api.per_group1_type
97 ,p_per_retained_grade in ghr_api.per_retained_grade_type
98 ,p_per_sep_retire in ghr_api.per_sep_retire_type
99 ,p_per_conversions in ghr_api.per_conversions_type
100 ,p_per_uniformed_services in ghr_api.per_uniformed_services_type
101 ,p_pos_grp1 in ghr_api.pos_grp1_type
102 ,p_pos_valid_grade in ghr_api.pos_valid_grade_type
103 ,p_loc_info in ghr_api.loc_info_type
104 ,p_sf52_from_data in ghr_api.prior_sf52_data_type
105 ,p_personal_info in ghr_api.personal_info_type
106 ,p_agency_code in varchar2
107 ,p_gov_awards_type in ghr_api.government_awards_type
108 ,p_perf_appraisal_type in ghr_api.performance_appraisal_type
109 ,p_health_plan in varchar2
110 ,p_race_ethnic_info in ghr_api.per_race_ethnic_type -- Bug 4724337 Race or National Origin changes
111 );
112
113 --
114 procedure CPDF_Parameter_Check;
115 --
116 end GHR_GHRWS52L;