[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK3
Source
1 package GHR_CPDF_CHECK3 as
2 /* $Header: ghcpdf03.pkh 120.2.12010000.1 2008/07/28 10:25:45 appldev ship $ */
3
4
5 -- <Precedure Info>
6 -- Name:
7 -- Nature of Action
8 -- Sections in CPDF:
9 -- C37 - C40
10 -- Note:
11 --
12 --
13
14
15
16 procedure chk_Nature_of_Action
17 (p_First_NOAC_Lookup_Code in varchar2
18 ,p_Second_NOAC_Lookup_code in varchar2
19 ,p_First_Action_NOA_Code1 in varchar2
20 ,p_First_Action_NOA_Code2 in varchar2
21 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
22 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
23 ,p_Employee_Date_of_Birth in date
24 ,p_Duty_Station_Lookup_Code in varchar2
25 ,p_Employee_First_Name in varchar2
26 ,p_Employee_Last_Name in varchar2
27 ,p_Handicap in varchar2 --non SF52 item
28 ,p_Organ_Component in varchar2 --non SF52 item
29 ,p_Personal_Office_ID in varchar2 --non SF52 item
30 ,p_Position_Occ_Code in varchar2
31 ,p_Race_National_Region in varchar2 --non SF52 item
32 ,p_Retirement_Plan_Code in varchar2
33 ,p_Service_Computation_Date in Date
34 ,p_Sex in varchar2 --non SF52 item
35 ,p_Supervisory_Status_Code in varchar2
36 ,p_Tenure_Group_Code in varchar2
37 ,p_Veterans_Pref_Code in varchar2
38 ,p_Veterans_Status_Code in varchar2
39 ,p_Occupation in varchar2 --non SF52 item
40 ,p_To_Pay_Basis in varchar2
41 ,p_To_Grade_Or_Level in varchar2
42 ,p_To_Pay_Plan in varchar2
43 ,p_pay_rate_determinant_code in varchar2
44 ,p_To_Basic_Pay in varchar2
45 ,p_To_Step_Or_Rate in varchar2
46 ,p_Work_Sche_Code in varchar2
47 ,p_Prior_Occupation in varchar2 --non SF52 item
48 ,p_Prior_To_Pay_Basis in varchar2 --non SF52 item
49 ,p_Prior_To_Grade_Or_Level in varchar2 --non SF52 item
50 ,p_Prior_To_Pay_Plan in varchar2 --non SF52 item
51 ,p_Prior_Pay_Rate_Det_Code in varchar2 --non SF52 item
52 ,p_Prior_To_Basic_Pay in varchar2 --non SF52 item
53 ,p_Prior_To_Step_Or_Rate in varchar2 --non SF52 item
54 ,p_Prior_Work_Sche_Code in varchar2 --non SF52 item
55 ,p_prior_duty_station in varchar2
56 ,p_Retention_Allowance in varchar2 --non SF52 item
57 ,p_Staff_Diff in varchar2 --non SF52 item
58 ,p_Supervisory_Diff in varchar2 --non SF52 item
59 ,p_To_Locality_Adj in varchar2
60 ,p_Prior_To_Locality_Adj in varchar2 --non SF52 item
61 ,p_noa_family_code in varchar2
62 ,p_effective_date in date
63 ,p_agency_subelement in varchar2
64 ,p_ethnic_race_info in varchar2
65 );
66
67 -- <Precedure Info>
68 -- Name:
69 -- Occupation
70 -- Sections in CPDF:
71 -- C40 - C41
72 -- Note:
73 --
74 --
75
76 procedure chk_occupation
77 (p_to_pay_plan in varchar2
78 ,p_occ_code in varchar2
79 ,p_agency_sub in varchar2 -- non SF52 item
80 ,p_duty_station_lookup_code in varchar2
81 ,p_effective_date in date
82
83 );
84
85 -- -- Name:
86 -- Pay Basis
87 -- Sections in CPDF:
88 -- C42
89 -- Note:
90 --
91 --
92
93 procedure chk_pay_basis
94 (p_to_pay_plan in varchar2
95 ,p_pay_basis in varchar2
96 ,p_basic_pay in varchar2
97 ,p_agency_subelement in varchar2 --non SF52 item
98 ,p_occ_code in varchar2 --Bug# 5745356
99 ,p_effective_date in date
100 ,p_pay_rate_determinant_code in varchar2
101 );
102
103 -- Name:
104 -- Pay Grade
105 -- Sections in CPDF:
106 -- C43 - C46
107 -- Note:
108 --
109
110 procedure chk_pay_grade
111 (p_to_pay_plan in varchar2
112 ,p_to_grade_or_level in varchar2
113 ,p_pay_rate_determinant_code in varchar2
114 ,p_first_action_noa_la_code1 in varchar2
115 ,p_first_action_noa_la_code2 in varchar2
116 ,p_First_NOAC_Lookup_Code in varchar2
117 ,p_Second_NOAC_Lookup_code in varchar2
118 ,p_effective_date in date
119 );
120
121
122
123 -- <Precedure Info>
124 -- Name:
125 -- Pay Plan
126 -- Sections in CPDF:
127 -- C-47 - C-50
128 -- Note:
129 --
130
131 procedure chk_pay_plan
132 (p_to_pay_plan in varchar2
133 ,p_agency_subelement in varchar2 --non SF52
134 ,p_pers_office_identifier in varchar2 --non SF52
135 ,p_to_grade_or_level in varchar2
136 ,p_first_action_noa_la_code1 in varchar2
137 ,p_first_action_noa_la_code2 in varchar2
138 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
139 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
140 ,p_first_NOAC_Lookup_Code in varchar2
141 ,p_Pay_Rate_Determinant_Code in varchar2
142 ,p_Effective_Date in date
143 ,p_prior_pay_plan in varchar2 --non SF52
144 ,p_prior_grade in varchar2 --non SF52
145 ,p_Agency in varchar2 --non SF52
146 ,p_Supervisory_status_code in varchar2
147 );
148 --
149 -- <Precedure Info>
150 -- Name:
151 -- Pay Rate Determinant
152 -- Sections in CPDF:
153 -- C-51, C-52
154 -- Note:
155 --
156
157 procedure chk_pay_rate_determinant
158 (p_pay_rate_determinant_code in varchar2
159 ,p_prior_pay_rate_det_code in varchar2 --non SF52
160 ,p_to_pay_plan in varchar2
161 ,p_first_noa_lookup_code in varchar2
162 ,p_duty_station_lookup_code in varchar2
163 ,p_agency in varchar2
164 ,p_effective_date in date
165 );
166
167 end GHR_CPDF_CHECK3;