1 Package pay_kr_aei_api AUTHID CURRENT_USER as
2 /* $Header: pykraei.pkh 115.3 2002/12/11 11:44:16 krapolu noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< ins_yea_tax_break_info>-------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 -- Alternative interface to call insert api for Assignment Extra Info table
11 -- to create a KR_YEA_TAX_BREAK_INFO context record for the assignment
12 --
13 -- Prerequisites : None
14 --
15 -- In Parameters:
16 -- Name Reqd Type Description
17 -- p_validate No Boolean Validate Only flag
18 -- p_assignment_id Yes Number The ID of the assignment
19 -- p_business_group_id Yes Number The ID of the Business Group
20 -- p_information_type Yes Varchar2 Context fo the Assignment
21 -- Extra Info Row
22 -- p_aei_information_category No Varchar2
23 -- p_aei_information1 No Varchar2 EFFECTIVE_DATE
24 -- p_aei_information2 No Varchar2 HOUSING_LOAN_INTEREST_REPAY
25 -- p_aei_information3 No varchar2 STOCK_SAVING
26 -- p_aei_information4 No varchar2 LT_STOCK_SAVING
27 --
28 -- Post Success:
29 --
30 -- KR_YEA_TAX_BREAK_INFO record will be created for assignment
31 -- New object version number should be returned
32 -- p_some_warning returned as null
33 --
34 -- Post Failure:
35 --
36 -- KR_YEA_TAX_BREAK_INFO record will not be created,
37 -- error message will be returned
38 --
39 -- Access Status:
40 -- Internal Development Use Only.
41 --
42 -- {End Of Comments}
43 --
44 procedure ins_yea_tax_break_info
45 (p_validate in boolean default null
46 ,p_assignment_id in number
47 ,p_business_group_id in number
48 ,p_information_type in varchar2
49 ,p_aei_information_category in varchar2 default null
50 ,p_aei_information1 in varchar2 default null
51 ,p_aei_information2 in varchar2 default null
52 ,p_aei_information3 in varchar2 default null
53 ,p_aei_information4 in varchar2 default null
54 ,p_object_version_number out NOCOPY number
55 ,p_assignment_extra_info_id out NOCOPY number
56 );
57 --
58 --
59 -- ----------------------------------------------------------------------------
60 -- |------------------------< upd_yea_tax_break_info>-------------------------|
61 -- ----------------------------------------------------------------------------
62 -- {Start Of Comments}
63 --
64 -- Description:
65 -- Alternative interface to call update api for Assignment Extra Info table
66 -- to create a KR_YEA_TAX_BREAK_INFO context record for the assignment
67 --
68 -- Prerequisites : None
69 --
70 -- In Parameters:
71 -- Name Reqd Type Description
72 -- p_assignment_extra_info_id Yes Number The ID of the assignment
73 -- p_business_group_id Yes Number The ID of the Business Group
74 -- p_aei_information_category No Varchar2
75 -- p_aei_information1 No Varchar2 EFFECTIVE_DATE
76 -- p_aei_information2 No Varchar2 HOUSING_LOAN_INTEREST_REPAY
77 -- p_aei_information3 No Varchar2 STOCK_SAVING
78 -- p_aei_information4 No Varchar2 LT_STOCK_SAVING
79 -- p_object_version_number Yes Number Object Version Number
80 --
81 -- Post Success:
82 --
83 -- KR_YEA_TAX_BREAK_INFO record will be updated for assignment
84 -- New object version number should be returned
85 -- p_some_warning returned as null
86 --
87 -- Post Failure:
88 --
89 -- KR_YEA_TAX_BREAK_INFO record will not be updated,
90 -- error message will be returned
91 --
92 -- Access Status:
93 -- Internal Development Use Only.
94 --
95 -- {End Of Comments}
96 --
97 procedure upd_yea_tax_break_info
98 (p_validate in boolean default null
99 ,p_assignment_extra_info_id in number
100 ,p_business_group_id in number
101 ,p_object_version_number in out NOCOPY number
102 ,p_aei_information_category in varchar2 default null
103 ,p_aei_information1 in varchar2 default null
104 ,p_aei_information2 in varchar2 default null
105 ,p_aei_information3 in varchar2 default null
106 ,p_aei_information4 in varchar2 default null
107 );
108 --
109 -- for TAX_EXEM
110 --
111 procedure ins_yea_tax_exem_info
112 (p_validate in boolean default null
113 ,p_assignment_id in number
114 ,p_business_group_id in number
115 ,p_information_type in varchar2
116 ,p_aei_information_category in varchar2 default null
117 ,p_aei_information1 in varchar2 default null
118 ,p_aei_information2 in varchar2 default null
119 ,p_aei_information3 in varchar2 default null
120 ,p_aei_information4 in varchar2 default null
121 ,p_aei_information5 in varchar2 default null
122 ,p_aei_information6 in varchar2 default null
123 ,p_aei_information7 in varchar2 default null
124 ,p_object_version_number out NOCOPY number
125 ,p_assignment_extra_info_id out NOCOPY number
126 );
127 --
128 procedure upd_yea_tax_exem_info
129 (p_validate in boolean default null
130 ,p_assignment_extra_info_id in number
131 ,p_business_group_id in number
132 ,p_object_version_number in out NOCOPY number
133 ,p_aei_information_category in varchar2 default null
134 ,p_aei_information1 in varchar2 default null
135 ,p_aei_information2 in varchar2 default null
136 ,p_aei_information3 in varchar2 default null
137 ,p_aei_information4 in varchar2 default null
138 ,p_aei_information5 in varchar2 default null
139 ,p_aei_information6 in varchar2 default null
140 ,p_aei_information7 in varchar2 default null
141 );
142 --
143 -- for SP_TAX_EXEM
144 --
145 procedure ins_yea_sp_tax_exem_info
146 (p_validate in boolean default null
147 ,p_assignment_id in number
148 ,p_business_group_id in number
149 ,p_information_type in varchar2
150 ,p_aei_information_category in varchar2 default null
151 ,p_aei_information1 in varchar2 default null
152 ,p_aei_information2 in varchar2 default null
153 ,p_aei_information3 in varchar2 default null
154 ,p_aei_information4 in varchar2 default null
155 ,p_aei_information5 in varchar2 default null
156 ,p_aei_information6 in varchar2 default null
157 ,p_aei_information7 in varchar2 default null
158 ,p_aei_information8 in varchar2 default null
159 ,p_aei_information9 in varchar2 default null
160 ,p_aei_information10 in varchar2 default null
161 ,p_aei_information11 in varchar2 default null
162 ,p_aei_information12 in varchar2 default null
163 ,p_aei_information13 in varchar2 default null
164 ,p_aei_information14 in varchar2 default null
165 ,p_aei_information15 in varchar2 default null
166 ,p_aei_information16 in varchar2 default null
167 ,p_aei_information17 in varchar2 default null
168 ,p_aei_information18 in varchar2 default null
169 ,p_aei_information19 in varchar2 default null
170 ,p_aei_information20 in varchar2 default null
171 ,p_aei_information21 in varchar2 default null
172 ,p_aei_information22 in varchar2 default null
173 ,p_object_version_number out NOCOPY number
174 ,p_assignment_extra_info_id out NOCOPY number
175 );
176 --
177 procedure upd_yea_sp_tax_exem_info
178 (p_validate in boolean default null
179 ,p_assignment_extra_info_id in number
180 ,p_business_group_id in number
181 ,p_object_version_number in out NOCOPY number
182 ,p_aei_information_category in varchar2 default null
183 ,p_aei_information1 in varchar2 default null
184 ,p_aei_information2 in varchar2 default null
185 ,p_aei_information3 in varchar2 default null
186 ,p_aei_information4 in varchar2 default null
187 ,p_aei_information5 in varchar2 default null
188 ,p_aei_information6 in varchar2 default null
189 ,p_aei_information7 in varchar2 default null
190 ,p_aei_information8 in varchar2 default null
191 ,p_aei_information9 in varchar2 default null
192 ,p_aei_information10 in varchar2 default null
193 ,p_aei_information11 in varchar2 default null
194 ,p_aei_information12 in varchar2 default null
195 ,p_aei_information13 in varchar2 default null
196 ,p_aei_information14 in varchar2 default null
197 ,p_aei_information15 in varchar2 default null
198 ,p_aei_information16 in varchar2 default null
199 ,p_aei_information17 in varchar2 default null
200 ,p_aei_information18 in varchar2 default null
201 ,p_aei_information19 in varchar2 default null
202 ,p_aei_information20 in varchar2 default null
203 ,p_aei_information21 in varchar2 default null
204 ,p_aei_information22 in varchar2 default null
205 );
206 --
207 -- for DPNTEDUC_TAX_EXEM
208 --
209 procedure ins_yea_dpnteduc_tax_exem_info
210 (p_validate in boolean default null
211 ,p_assignment_id in number
212 ,p_business_group_id in number
213 ,p_information_type in varchar2
214 ,p_aei_information_category in varchar2 default null
215 ,p_aei_information1 in varchar2 default null
216 ,p_aei_information2 in varchar2 default null
217 ,p_aei_information3 in varchar2 default null
218 ,p_aei_information4 in varchar2 default null
219 ,p_object_version_number out NOCOPY number
220 ,p_assignment_extra_info_id out NOCOPY number
221 );
222 --
223 procedure upd_yea_dpnteduc_tax_exem_info
224 (p_validate in boolean default null
225 ,p_assignment_extra_info_id in number
226 ,p_business_group_id in number
227 ,p_object_version_number in out NOCOPY number
228 ,p_aei_information_category in varchar2 default null
229 ,p_aei_information1 in varchar2 default null
230 ,p_aei_information2 in varchar2 default null
231 ,p_aei_information3 in varchar2 default null
232 ,p_aei_information4 in varchar2 default null
233 );
234 --
235 -- for FW_TAX_BEAK
236 --
237 procedure ins_yea_fw_tax_break_info
238 (p_validate in boolean default null
239 ,p_assignment_id in number
240 ,p_business_group_id in number
241 ,p_information_type in varchar2
242 ,p_aei_information_category in varchar2 default null
243 ,p_aei_information1 in varchar2 default null
244 ,p_aei_information2 in varchar2 default null
245 ,p_aei_information3 in varchar2 default null
246 ,p_aei_information4 in varchar2 default null
247 ,p_aei_information5 in varchar2 default null
248 ,p_aei_information6 in varchar2 default null
249 ,p_object_version_number out NOCOPY number
250 ,p_assignment_extra_info_id out NOCOPY number
251 );
252 --
253 procedure upd_yea_fw_tax_break_info
254 (p_validate in boolean default null
255 ,p_assignment_extra_info_id in number
256 ,p_business_group_id in number
257 ,p_object_version_number in out NOCOPY number
258 ,p_aei_information_category in varchar2 default null
259 ,p_aei_information1 in varchar2 default null
260 ,p_aei_information2 in varchar2 default null
261 ,p_aei_information3 in varchar2 default null
262 ,p_aei_information4 in varchar2 default null
263 ,p_aei_information5 in varchar2 default null
264 ,p_aei_information6 in varchar2 default null
265 );
266 --
267 -- for OVS_TAX_BEAK
268 --
269 procedure ins_yea_ovs_tax_break_info
270 (p_validate in boolean default null
271 ,p_assignment_id in number
272 ,p_business_group_id in number
273 ,p_information_type in varchar2
274 ,p_aei_information_category in varchar2 default null
275 ,p_aei_information1 in varchar2 default null
276 ,p_aei_information2 in varchar2 default null
277 ,p_aei_information3 in varchar2 default null
278 ,p_aei_information4 in varchar2 default null
279 ,p_aei_information5 in varchar2 default null
280 ,p_aei_information6 in varchar2 default null
281 ,p_aei_information7 in varchar2 default null
282 ,p_aei_information8 in varchar2 default null
283 ,p_aei_information9 in varchar2 default null
284 ,p_aei_information10 in varchar2 default null
285 ,p_object_version_number out NOCOPY number
286 ,p_assignment_extra_info_id out NOCOPY number
287 );
288 --
289 procedure upd_yea_ovs_tax_break_info
290 (p_validate in boolean default null
291 ,p_assignment_extra_info_id in number
292 ,p_business_group_id in number
293 ,p_object_version_number in out NOCOPY number
294 ,p_aei_information_category in varchar2 default null
295 ,p_aei_information1 in varchar2 default null
296 ,p_aei_information2 in varchar2 default null
297 ,p_aei_information3 in varchar2 default null
298 ,p_aei_information4 in varchar2 default null
299 ,p_aei_information5 in varchar2 default null
300 ,p_aei_information6 in varchar2 default null
301 ,p_aei_information7 in varchar2 default null
302 ,p_aei_information8 in varchar2 default null
303 ,p_aei_information9 in varchar2 default null
304 ,p_aei_information10 in varchar2 default null
305 );
306 --
307 -- for PREV_ER
308 --
309 procedure ins_yea_prev_er_info
310 (p_validate in boolean default null
311 ,p_assignment_id in number
312 ,p_business_group_id in number
313 ,p_information_type in varchar2
314 ,p_aei_information_category in varchar2 default null
315 ,p_aei_information1 in varchar2 default null
316 ,p_aei_information2 in varchar2 default null
317 ,p_aei_information3 in varchar2 default null
318 ,p_aei_information4 in varchar2 default null
319 ,p_aei_information5 in varchar2 default null
320 ,p_aei_information6 in varchar2 default null
321 ,p_aei_information7 in varchar2 default null
322 ,p_aei_information8 in varchar2 default null
323 ,p_aei_information9 in varchar2 default null
324 ,p_aei_information10 in varchar2 default null
325 ,p_aei_information11 in varchar2 default null
326 ,p_aei_information12 in varchar2 default null
327 ,p_aei_information13 in varchar2 default null
328 ,p_aei_information14 in varchar2 default null
329 ,p_aei_information15 in varchar2 default null
330 ,p_object_version_number out NOCOPY number
331 ,p_assignment_extra_info_id out NOCOPY number
332 );
333
334 --
335 procedure upd_yea_prev_er_info
336 (p_validate in boolean default null
337 ,p_assignment_extra_info_id in number
338 ,p_business_group_id in number
339 ,p_object_version_number in out NOCOPY number
340 ,p_aei_information_category in varchar2 default null
341 ,p_aei_information1 in varchar2 default null
342 ,p_aei_information2 in varchar2 default null
343 ,p_aei_information3 in varchar2 default null
344 ,p_aei_information4 in varchar2 default null
345 ,p_aei_information5 in varchar2 default null
346 ,p_aei_information6 in varchar2 default null
347 ,p_aei_information7 in varchar2 default null
348 ,p_aei_information8 in varchar2 default null
349 ,p_aei_information9 in varchar2 default null
350 ,p_aei_information10 in varchar2 default null
351 ,p_aei_information11 in varchar2 default null
352 ,p_aei_information12 in varchar2 default null
353 ,p_aei_information13 in varchar2 default null
354 ,p_aei_information14 in varchar2 default null
355 ,p_aei_information15 in varchar2 default null
356 );
357 --
358 procedure chk_date_in_current_year
359 (p_session_date in date
360 ,p_entry_date in date
361 );
362 end pay_kr_aei_api;