[Home] [Help]
PACKAGE: APPS.GHR_CPDF_CHECK2
Source
1 package GHR_CPDF_CHECK2 as
2 /* $Header: ghcpdf02.pkh 120.1.12000000.2 2007/02/14 11:29:33 utokachi noship $ */
3
4 -- <Precedure Info>
5 -- Name:
6 -- instructional program
7 -- Sections in CPDF:
8 -- C-8 - C-9
9 -- Note:
10 --
11
12 procedure chk_instructional_pgm
13 (p_education_level in varchar2
14 ,p_academic_discipline in varchar2
15 ,p_year_degree_attained in varchar2
16 ,p_first_noac_lookup_code in varchar2
17 ,p_effective_date in date
18 ,p_tenure_group_code in varchar2
19 ,p_to_pay_plan in varchar2
20 ,p_employee_date_of_birth in Date
21 );
22
23 -- <Precedure Info>
24 -- Name:
25 -- Award_Amount
26 -- Sections in CPDF:
27 -- C-10, C-11
28 -- Note:
29 --
30
31 procedure chk_Award_Amount
32 ( p_First_NOAC_Lookup_Code in varchar2
33 -- Bug#4486823 RRR Changes
34 ,p_First_NOAC_Lookup_desc in varchar2
35 ,p_One_Time_Payment_Amount in number
36 ,p_To_Basic_Pay in number
37 ,p_Adj_Base_Pay in number
38 ,p_First_Action_NOA_LA_Code1 in varchar2
39 ,p_First_Action_NOA_LA_Code2 in varchar2
40 ,p_to_pay_plan in varchar2
41 ,p_effective_date in date
42 );
43
44
45 --
46 -- <Precedure Info>
47 -- Name:
48 -- Benefit Amount
49 -- Sections in CPDF:
50 -- C-11
51 -- Note:
52 --
53
54 procedure chk_Benefit_Amount
55 (p_First_NOAC_Lookup_Code in varchar2
56 ,p_Benefit_Amount in varchar2 --non SF52
57 ,p_effective_date in date
58 );
59
60
61 -- <Precedure Info>
62 -- Name:
63 -- Current Appointment Authority
64 -- Sections in CPDF:
65 -- C-12 - C-19
66 -- Note:
67 --
68
69 procedure chk_Cur_Appt_Auth
70 (p_First_Action_NOA_LA_Code1 in varchar2
71 ,p_First_Action_NOA_LA_Code2 in varchar2
72 ,p_Cur_Appt_Auth_1 in varchar2 --non SF52 item
73 ,p_Cur_Appt_Auth_2 in varchar2 --non SF52 item
74 ,p_Agency_Subelement in varchar2 --non SF52
75 ,p_To_OCC_Code in varchar2
76 ,p_First_NOAC_Lookup_Code in varchar2
77 ,p_Position_Occupied_Code in varchar2
78 ,p_To_Pay_Plan in varchar2
79 ,p_Handicap in varchar2 --non SF52
80 ,p_Tenure_Goupe_Code in varchar2
81 ,p_To_Grade_Or_Level in varchar2
82 ,p_Vet_Pref_Code in varchar2
83 ,p_Duty_Station_Lookup_Code in varchar2
84 ,p_Service_Computation_Date in Date
85 ,p_effective_date in date
86 );
87
88 --
89 -- <Precedure Info>
90 -- Name:
91 -- Date_of_Birth
92 -- Sections in CPDF:
93 -- C-20
94 -- Note:
95 --
96
97 procedure chk_Date_of_Birth
98 ( p_First_NOAC_Lookup_Code in varchar2
99 ,p_Effective_Date in date
100 ,p_Employee_Date_of_Birth in date
101 ,p_Duty_Station_Lookup_Code in varchar2
102 ,p_as_of_date in date
103 );
104
105
106 --
107 --
108 -- <Precedure Info>
109 -- Name:
110 -- Duty Station
111 -- Sections in CPDF:
112 -- C-20, C-21
113 -- Note:
114 --
115
116 procedure chk_duty_station
117 (p_to_play_plan in varchar2
118 ,p_agency_sub_element in varchar2
119 ,p_duty_station_lookup in varchar2
120 ,p_First_Action_NOA_LA_Code1 in varchar2
121 ,p_First_Action_NOA_LA_Code2 in varchar2
122 ,p_effective_date in date
123 );
124
125
126 --
127 -- <Precedure Info>
128 -- Name:
129 -- Education Level
130 -- Sections in CPDF:
131 -- C-21
132 -- Note:
133 --
134
135 procedure chk_Education_Level
136 ( p_tenure_group_code in varchar2
137 ,p_education_level in varchar2
138 ,p_pay_plan in varchar2
139 );
140
141 --
142 -- <Precedure Info>
143 -- Name:
144 -- Effective Date
145 -- Sections in CPDF:
146 -- C-22
147 -- Note:
148 --
149
150 procedure chk_effective_date
151 ( p_First_NOAC_Lookup_Code in varchar2
152 ,p_Effective_Date in date
153 ,p_Production_Date in date -- Non SF52 item
154 );
155
156
157
158 -- <Precedure Info>
159 -- Name:
160 -- Handicap
161 -- Sections in CPDF:
162 -- C-23
163 -- Note:
164 --
165
166 procedure chk_Handicap
167 (p_First_Action_NOA_Code1 in varchar2
168 ,p_First_Action_NOA_Code2 in varchar2
169 ,p_First_NOAC_Lookup_Code in varchar2
170 ,p_Effective_Date in date --bug# 5619873
171 ,p_Handicap in varchar2 --non SF52 item
172 );
173
174 --
175 -- <Precedure Info>
176 -- Name:
177 -- Individual/Group Award
178 -- Sections in CPDF:
179 -- C-23
180 -- Note:
181 --
182
183 procedure chk_indiv_Award
184 (p_First_NOAC_Lookup_Code in varchar2
185 ,p_Indiv_Award in varchar2
186 ,p_effective_date in date
187 );
188
189 end GHR_CPDF_CHECK2;