[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK1
Source
1 package GHR_CPDF_CHECK1 AUTHID CURRENT_USER as
2 /* $Header: ghcpdf01.pkh 120.4.12020000.2 2012/12/05 04:58:59 utokachi ship $ */
3
4 -- <Precedure Info>
5 -- Name:
6 -- bargaining unit
7 -- Sections in CPDF:
8 -- B8
9 -- Note:
10 --
11
12 procedure chk_bargaining_unit
13 (p_to_pay_plan in varchar2
14 ,p_agency_sub_element in varchar2 --non SF52
15 ,p_bargaining_unit_status_code in varchar2
16 );
17
18 -- <Precedure Info>
19 -- Name:
20 -- Federal Employees Group Life Insurance
21 -- Sections in CPDF:
22 -- B16
23 -- Note:
24 --
25
26 procedure chk_fegli
27 (p_to_basic_pay in varchar2
28 ,p_to_pay_plan in varchar2
29 ,p_fegli_code in varchar2
30 ,p_effective_date in date
31 );
32
33 -- <Precedure Info>
34 -- Name:
35 -- FSLA Category
36 -- Sections in CPDF:
37 -- B17
38 -- Note:
39 --
40
41 procedure chk_fsla_category
42 (p_duty_station_lookup_code in varchar2
43 ,p_to_pay_plan in varchar2
44 ,p_agency_subelement in varchar2 --non SF52
45 ,p_flsa_category in varchar2
46 ,p_to_grade_or_level in varchar2
47 ,p_effective_date in date --Bug# 5619873
48 );
49
50
51 -- <Precedure Info>
52 -- Name:
53 -- Functional Classification-- Sections in CPDF:
54 -- B18
55 -- Note:
56 --
57 procedure chk_functional_classification
58 (p_to_occ_code in varchar2
59 ,p_functional_class in varchar2
60 ,p_effective_date in date --Bug# 5619873
61 );
62
63 -- <Precedure Info>
64 -- Name:
65 -- HEALTH PLAN
66 -- Sections in CPDF:
67 -- B19
68 -- Note:
69 --
70
71 procedure chk_health_plan
72 (p_health_plan in varchar2 --non SF52
73 ,p_tenure_group_code in varchar2
74 ,p_work_schedule_code in varchar2
75 ,p_to_pay_basis in varchar2
76 ,p_to_pay_status in varchar2
77 ,p_submission_date in date --non SF52
78 ,p_Cur_Appt_Auth_1 in varchar2
79 ,p_Cur_Appt_Auth_2 in varchar2
80
81 );
82
83 -- <Precedure Info>
84 -- Name:
85 -- Retained Grade
86 -- Sections in CPDF:
87 -- B30 - B32
88 -- Note:
89 --
90
91 procedure chk_retain_grade
92 (p_retain_pay_plan in varchar2 --non SF52
93 ,p_retain_grade in varchar2 --non SF52
94 ,p_pay_rate_determinant_code in varchar2
95 ,p_effective_date in date
96 );
97
98
99 -- <Precedure Info>
100 -- Name:
101 -- Retained Pay Plan
102 -- Sections in CPDF:
103 -- B32
104 -- Note:
105 --
106
107 procedure chk_retain_pay_plan
108 (p_retain_grade in varchar2 --non SF52
109 ,p_retain_pay_plan in varchar2 --non SF52
110 ,p_retain_step in varchar2 --non SF52
111 ,p_to_pay_plan in varchar2
112 ,p_pay_rate_determinant_code in varchar2
113 ,p_effective_date in date
114
115 );
116
117 --
118 -- <Precedure Info>
119 -- Name:
120 -- Retained Step
121 -- Sections in CPDF:
122 -- B33
123 -- Note:
124 --
125
126 procedure chk_retain_step
127 (p_pay_rate_determinant_code in varchar2
128 ,p_first_action_noa_la_code1 in varchar2
129 ,p_first_action_noa_la_code2 in varchar2
130 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
131 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
132 ,p_retain_pay_plan in varchar2 --non SF52
133 ,p_retain_grade in varchar2 --non SF52
134 ,p_retain_step in varchar2 --non SF52
135 ,p_effective_date in date
136 );
137
138 -- -- <Precedure Info>
139 -- Name:
140 -- Retirement Plan
141 -- Sections in CPDF:
142 -- B33,B34
143 -- Note:
144 --
145 --Bug# 15941036 added effective date parameter
146 procedure chk_retirement_plan
147 (p_retirement_plan_code in varchar2
148 ,p_fers_coverage in varchar2 --non SF52
149 ,p_effective_date in date
150 );
151
152
153 -- <Precedure Info>
154 -- Name:
155 -- special_pay_table_id
156 -- Sections in CPDF:
157 -- B49
158 -- Note:
159
160
161 procedure chk_special_pay_table_id
162 (p_pay_rate_determinant_code in varchar2
163 ,p_to_pay_plan in varchar2
164 ,p_special_pay_table_id in varchar2 --non SF52
165 -- FWFA Changes Bug#4444609
166 ,p_effective_date in date
167 -- FWFA Changes
168 );
169
170 --
171 -- <Precedure Info>
172 -- Name:
173 -- U.S. Citizenship
174 -- Sections in CPDF:
175 -- B56
176 -- Note:
177
178 procedure chk_us_citizenship
179 (p_citizenship in varchar2
180 ,p_duty_station_lookup_code in varchar2
181 );
182
183 procedure chk_century_info (
184 p_date_of_birth in date
185 ,p_effective_date in date
186 ,p_Service_Computation_Date in date
187 ,p_year_degree_attained in varchar2
188 ,p_rating_of_record_period in varchar2
189 ,p_rating_of_record_per_starts in varchar2
190 );
191
192
193 end GHR_CPDF_CHECK1;