[Home] [Help]
PACKAGE: APPS.OTA_FINANCE_HEADER_API
Source
1 PACKAGE OTA_FINANCE_HEADER_API AUTHID CURRENT_USER as
2 /* $Header: ottfhapi.pkh 120.3 2006/08/30 09:49:56 niarora noship $ */
3 /*#
4 * This package contains finance header APIs.
5 * @rep:scope public
6 * @rep:product OTA
7 * @rep:displayname Finance Header
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_finance_header >-----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This package creates a finance header.
17 *
18 *
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Learning Management.
21 *
22 * <p><b>Prerequisites</b><br>
23 * Organization must exist.
24 *
25 * <p><b>Post Success</b><br>
26 * The Finance header is created successfully.
27 *
28 * <p><b>Post Failure</b><br>
29 * The API does not create a Finance Header record, and raises an error.
30 *
31 * @param p_finance_header_id The Unique identifier of the Finance Header.
32 * @param p_object_version_number If p_validate is false, then set to the
33 * version number of the created learning path section. If p_validate is true,
34 * then the value will be null.
35 * @param p_superceding_header_id Foreign key to OTA_FINANCE_HEADERS.
36 * @param p_authorizer_person_id Foreign key to PER_ALL_PEOPLE_F.
37 * @param p_organization_id Foreign key to HR_ALL_ORGANIZATION_UNITS.
38 * @param p_administrator The person who raised the header.
39 * @param p_cancelled_flag An indication of whether the header has been
40 * cancelled. Permissible values Y and N.
41 * @param p_currency_code The currency in which all lines are defined.
42 * @param p_date_raised The date this header was raised.
43 * @param p_payment_status_flag Describes if the invoice has been paid or not.
44 * @param p_transfer_status The Status of the header for external transfer.
45 * @param p_type The type of header. Valid values are: cancellation,payable
46 * and receivable.
47 * @param p_receivable_type The type of receivable header.
48 * @param p_comments Comment text.
49 * @param p_external_reference The identification of this header in the external system.
50 * @param p_invoice_address The address to which the invoice is to be sent.
51 * @param p_invoice_contact The person to which this invoice is to be sent.
52 * @param p_payment_method The payment method by which this header is to be paid.
53 * @param p_pym_information_category The flexfield to hold Payment Method Details.
54 * @param p_pym_attribute1 Payment Method Descriptive flexfield segment.
55 * @param p_pym_attribute2 Payment Method Descriptive flexfield segment.
56 * @param p_pym_attribute3 Payment Method Descriptive flexfield segment.
57 * @param p_pym_attribute4 Payment Method Descriptive flexfield segment.
58 * @param p_pym_attribute5 Payment Method Descriptive flexfield segment.
59 * @param p_pym_attribute6 Payment Method Descriptive flexfield segment.
60 * @param p_pym_attribute7 Payment Method Descriptive flexfield segment.
61 * @param p_pym_attribute8 Payment Method Descriptive flexfield segment.
62 * @param p_pym_attribute9 Payment Method Descriptive flexfield segment.
63 * @param p_pym_attribute10 Payment Method Descriptive flexfield segment.
64 * @param p_pym_attribute11 Payment Method Descriptive flexfield segment.
65 * @param p_pym_attribute12 Payment Method Descriptive flexfield segment.
66 * @param p_pym_attribute13 Payment Method Descriptive flexfield segment.
67 * @param p_pym_attribute14 Payment Method Descriptive flexfield segment.
68 * @param p_pym_attribute15 Payment Method Descriptive flexfield segment.
69 * @param p_pym_attribute16 Payment Method Descriptive flexfield segment.
70 * @param p_pym_attribute17 Payment Method Descriptive flexfield segment.
71 * @param p_pym_attribute18 Payment Method Descriptive flexfield segment.
72 * @param p_pym_attribute19 Payment Method Descriptive flexfield segment.
73 * @param p_pym_attribute20 Payment Method Descriptive flexfield segment.
74 * @param p_transfer_date The date this header was transfered into an external system.
75 * @param p_transfer_message A message to send to the external system with this header.
76 * @param p_vendor_id Foreign key to PO_VENDORS.
77 * @param p_contact_id Foreign key to RA_CONTACTS.
78 * @param p_address_id Foreign key to RA_ADDRESSES.
79 * @param p_customer_id Foreign key to RA_CUSTOMERS.
80 * @param p_tfh_information_category This context value determines
81 * which flexfield structure to use with the descriptive flexfield segments.
82 * @param p_tfh_information1 Descriptive flexfield segment.
83 * @param p_tfh_information2 Descriptive flexfield segment.
84 * @param p_tfh_information3 Descriptive flexfield segment.
85 * @param p_tfh_information4 Descriptive flexfield segment.
86 * @param p_tfh_information5 Descriptive flexfield segment.
87 * @param p_tfh_information6 Descriptive flexfield segment.
88 * @param p_tfh_information7 Descriptive flexfield segment.
89 * @param p_tfh_information8 Descriptive flexfield segment.
90 * @param p_tfh_information9 Descriptive flexfield segment.
91 * @param p_tfh_information10 Descriptive flexfield segment.
92 * @param p_tfh_information11 Descriptive flexfield segment.
93 * @param p_tfh_information12 Descriptive flexfield segment.
94 * @param p_tfh_information13 Descriptive flexfield segment.
95 * @param p_tfh_information14 Descriptive flexfield segment.
96 * @param p_tfh_information15 Descriptive flexfield segment.
97 * @param p_tfh_information16 Descriptive flexfield segment.
98 * @param p_tfh_information17 Descriptive flexfield segment.
99 * @param p_tfh_information18 Descriptive flexfield segment.
100 * @param p_tfh_information19 Descriptive flexfield segment.
101 * @param p_tfh_information20 Descriptive flexfield segment.
102 * @param p_paying_cost_center Paying cost center code for the
103 * resource charge cross transfer.
104 * @param p_receiving_cost_center Receiving cost center code for the
105 * resource charge cross transfer.
106 * @param p_transfer_from_set_of_book_id Transfer from Set of books id.
107 * @param p_transfer_to_set_of_book_id Transfer to Set of books id.
108 * @param p_from_segment1 GL From Descriptive flexfield segment.
109 * @param p_from_segment2 GL From Descriptive flexfield segment.
110 * @param p_from_segment3 GL From Descriptive flexfield segment.
111 * @param p_from_segment4 GL From Descriptive flexfield segment.
112 * @param p_from_segment5 GL From Descriptive flexfield segment.
113 * @param p_from_segment6 GL From Descriptive flexfield segment.
114 * @param p_from_segment7 GL From Descriptive flexfield segment.
115 * @param p_from_segment8 GL From Descriptive flexfield segment.
116 * @param p_from_segment9 GL From Descriptive flexfield segment.
117 * @param p_from_segment10 GL From Descriptive flexfield segment.
118 * @param p_from_segment11 GL From Descriptive flexfield segment.
119 * @param p_from_segment12 GL From Descriptive flexfield segment.
120 * @param p_from_segment13 GL From Descriptive flexfield segment.
121 * @param p_from_segment14 GL From Descriptive flexfield segment.
122 * @param p_from_segment15 GL From Descriptive flexfield segment.
123 * @param p_from_segment16 GL From Descriptive flexfield segment.
124 * @param p_from_segment17 GL From Descriptive flexfield segment.
125 * @param p_from_segment18 GL From Descriptive flexfield segment.
126 * @param p_from_segment19 GL From Descriptive flexfield segment.
127 * @param p_from_segment20 GL From Descriptive flexfield segment.
128 * @param p_from_segment21 GL From Descriptive flexfield segment.
129 * @param p_from_segment22 GL From Descriptive flexfield segment.
130 * @param p_from_segment23 GL From Descriptive flexfield segment.
131 * @param p_from_segment24 GL From Descriptive flexfield segment.
132 * @param p_from_segment25 GL From Descriptive flexfield segment.
133 * @param p_from_segment26 GL From Descriptive flexfield segment.
134 * @param p_from_segment27 GL From Descriptive flexfield segment.
135 * @param p_from_segment28 GL From Descriptive flexfield segment.
136 * @param p_from_segment29 GL From Descriptive flexfield segment.
137 * @param p_from_segment30 GL From Descriptive flexfield segment.
138 * @param p_to_segment1 GL To Descriptive flexfield segment.
139 * @param p_to_segment2 GL To Descriptive flexfield segment.
140 * @param p_to_segment3 GL To Descriptive flexfield segment.
141 * @param p_to_segment4 GL To Descriptive flexfield segment.
142 * @param p_to_segment5 GL To Descriptive flexfield segment.
143 * @param p_to_segment6 GL To Descriptive flexfield segment.
144 * @param p_to_segment7 GL To Descriptive flexfield segment.
145 * @param p_to_segment8 GL To Descriptive flexfield segment.
146 * @param p_to_segment9 GL To Descriptive flexfield segment.
147 * @param p_to_segment10 GL To Descriptive flexfield segment.
148 * @param p_to_segment11 GL To Descriptive flexfield segment.
149 * @param p_to_segment12 GL To Descriptive flexfield segment.
150 * @param p_to_segment13 GL To Descriptive flexfield segment.
151 * @param p_to_segment14 GL To Descriptive flexfield segment.
152 * @param p_to_segment15 GL To Descriptive flexfield segment.
153 * @param p_to_segment16 GL To Descriptive flexfield segment.
154 * @param p_to_segment17 GL To Descriptive flexfield segment.
155 * @param p_to_segment18 GL To Descriptive flexfield segment.
156 * @param p_to_segment19 GL To Descriptive flexfield segment.
157 * @param p_to_segment20 GL To Descriptive flexfield segment.
158 * @param p_to_segment21 GL To Descriptive flexfield segment.
159 * @param p_to_segment22 GL To Descriptive flexfield segment.
160 * @param p_to_segment23 GL To Descriptive flexfield segment.
161 * @param p_to_segment24 GL To Descriptive flexfield segment.
162 * @param p_to_segment25 GL To Descriptive flexfield segment.
163 * @param p_to_segment26 GL To Descriptive flexfield segment.
164 * @param p_to_segment27 GL To Descriptive flexfield segment.
165 * @param p_to_segment28 GL To Descriptive flexfield segment.
166 * @param p_to_segment29 GL To Descriptive flexfield segment.
167 * @param p_to_segment30 GL To Descriptive flexfield segment.
168 * @param p_transfer_from_cc_id Transfer from GL Code Combination Id.
169 * @param p_transfer_to_cc_id Transfer to GL Code Combination Id.
170 * @param p_validate If true, then validation alone will be performed and the
171 * database will remain unchanged. If false and all validation checks pass,
172 * then the database will be modified.
173 * @param p_effective_date Reference date for validating that lookup values
174 * are applicable during the start to end active date range. This date does
175 * not determine when the changes take effect.
176 * @rep:displayname Create Finanace Header
177 * @rep:category BUSINESS_ENTITY OTA_FINANCE_HEADER
178 * @rep:lifecycle active
179 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
180 * @rep:scope public
181 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
182 */
183 --
184 -- {End Of Comments}
185 --
186 procedure CREATE_FINANCE_HEADER
187 (
188 p_finance_header_id out nocopy number,
189 p_object_version_number out nocopy number ,
190 p_superceding_header_id in number,
191 p_authorizer_person_id in number,
192 p_organization_id in number,
193 p_administrator in number,
194 p_cancelled_flag in varchar2,
195 p_currency_code in varchar2,
196 p_date_raised in date,
197 p_payment_status_flag in varchar2,
198 p_transfer_status in varchar2,
199 p_type in varchar2,
200 p_receivable_type in varchar2,
201 p_comments in varchar2,
202 p_external_reference in varchar2,
203 p_invoice_address in varchar2,
204 p_invoice_contact in varchar2,
205 p_payment_method in varchar2,
206 p_pym_information_category in varchar2,
207 p_pym_attribute1 in varchar2,
208 p_pym_attribute2 in varchar2,
209 p_pym_attribute3 in varchar2,
210 p_pym_attribute4 in varchar2,
211 p_pym_attribute5 in varchar2,
212 p_pym_attribute6 in varchar2,
213 p_pym_attribute7 in varchar2,
214 p_pym_attribute8 in varchar2,
215 p_pym_attribute9 in varchar2,
216 p_pym_attribute10 in varchar2,
217 p_pym_attribute11 in varchar2,
218 p_pym_attribute12 in varchar2,
219 p_pym_attribute13 in varchar2,
220 p_pym_attribute14 in varchar2,
221 p_pym_attribute15 in varchar2,
222 p_pym_attribute16 in varchar2,
223 p_pym_attribute17 in varchar2,
224 p_pym_attribute18 in varchar2,
225 p_pym_attribute19 in varchar2,
226 p_pym_attribute20 in varchar2,
227 p_transfer_date in date,
228 p_transfer_message in varchar2,
229 p_vendor_id in number ,
230 p_contact_id in number ,
231 p_address_id in number ,
232 p_customer_id in number ,
233 p_tfh_information_category in varchar2,
234 p_tfh_information1 in varchar2,
235 p_tfh_information2 in varchar2,
236 p_tfh_information3 in varchar2,
237 p_tfh_information4 in varchar2,
238 p_tfh_information5 in varchar2,
239 p_tfh_information6 in varchar2,
240 p_tfh_information7 in varchar2,
241 p_tfh_information8 in varchar2,
242 p_tfh_information9 in varchar2,
243 p_tfh_information10 in varchar2,
247 p_tfh_information14 in varchar2,
244 p_tfh_information11 in varchar2,
245 p_tfh_information12 in varchar2,
246 p_tfh_information13 in varchar2,
248 p_tfh_information15 in varchar2,
249 p_tfh_information16 in varchar2,
250 p_tfh_information17 in varchar2,
251 p_tfh_information18 in varchar2,
252 p_tfh_information19 in varchar2,
253 p_tfh_information20 in varchar2,
254 p_paying_cost_center in varchar2,
255 p_receiving_cost_center in varchar2,
256 p_transfer_from_set_of_book_id in number,
257 p_transfer_to_set_of_book_id in number,
258 p_from_segment1 in varchar2,
259 p_from_segment2 in varchar2,
260 p_from_segment3 in varchar2,
261 p_from_segment4 in varchar2,
262 p_from_segment5 in varchar2,
263 p_from_segment6 in varchar2,
264 p_from_segment7 in varchar2,
265 p_from_segment8 in varchar2,
266 p_from_segment9 in varchar2,
267 p_from_segment10 in varchar2,
268 p_from_segment11 in varchar2,
269 p_from_segment12 in varchar2,
270 p_from_segment13 in varchar2,
271 p_from_segment14 in varchar2,
272 p_from_segment15 in varchar2,
273 p_from_segment16 in varchar2,
274 p_from_segment17 in varchar2,
275 p_from_segment18 in varchar2,
276 p_from_segment19 in varchar2,
277 p_from_segment20 in varchar2,
278 p_from_segment21 in varchar2,
279 p_from_segment22 in varchar2,
280 p_from_segment23 in varchar2,
281 p_from_segment24 in varchar2,
282 p_from_segment25 in varchar2,
283 p_from_segment26 in varchar2,
284 p_from_segment27 in varchar2,
285 p_from_segment28 in varchar2,
286 p_from_segment29 in varchar2,
287 p_from_segment30 in varchar2,
288 p_to_segment1 in varchar2,
289 p_to_segment2 in varchar2,
290 p_to_segment3 in varchar2,
291 p_to_segment4 in varchar2,
292 p_to_segment5 in varchar2,
293 p_to_segment6 in varchar2,
294 p_to_segment7 in varchar2,
295 p_to_segment8 in varchar2,
296 p_to_segment9 in varchar2,
297 p_to_segment10 in varchar2,
298 p_to_segment11 in varchar2,
299 p_to_segment12 in varchar2,
300 p_to_segment13 in varchar2,
301 p_to_segment14 in varchar2,
302 p_to_segment15 in varchar2,
303 p_to_segment16 in varchar2,
304 p_to_segment17 in varchar2,
305 p_to_segment18 in varchar2,
306 p_to_segment19 in varchar2,
307 p_to_segment20 in varchar2,
308 p_to_segment21 in varchar2,
309 p_to_segment22 in varchar2,
310 p_to_segment23 in varchar2,
311 p_to_segment24 in varchar2,
312 p_to_segment25 in varchar2,
313 p_to_segment26 in varchar2,
314 p_to_segment27 in varchar2,
315 p_to_segment28 in varchar2,
316 p_to_segment29 in varchar2,
317 p_to_segment30 in varchar2,
318 p_transfer_from_cc_id in number,
319 p_transfer_to_cc_id in number,
320 P_validate in boolean default false,
321 p_effective_date in date
322
323 );
324 --
325 -- ----------------------------------------------------------------------------
326 -- |--------------------------< update_finance_header >-----------------------|
327 -- ----------------------------------------------------------------------------
328 --
329 -- {Start Of Comments}
330 /*#
331 * This package updates Finance header.
332 *
333 *
334 * <p><b>Licensing</b><br>
335 * This API is licensed for use with Learning Management.
336 *
337 * <p><b>Prerequisites</b><br>
338 * Finance Header with the given object version number should exist.
339 *
340 * <p><b>Post Success</b><br>
341 * The Finance header is updated successfully.
342 *
343 * <p><b>Post Failure</b><br>
344 * The API does not update Finance Header record, and raises an error.
345 *
346 * @param p_finance_header_id The Unique identifier of the Finance Header.
347 * @param p_object_version_number If p_validate is false, then set to the version
351 * @param p_authorizer_person_id Foreign key to PER_ALL_PEOPLE_F.
348 * number of the created learning path section. If p_validate is true, then the value will be null.
349 * @param p_new_object_version_number The new object version number of the record after the update.
350 * @param p_superceding_header_id Foreign key to OTA_FINANCE_HEADERS.
352 * @param p_organization_id Foreign key to HR_ALL_ORGANIZATION_UNITS.
353 * @param p_administrator The person who raised the header.
354 * @param p_cancelled_flag An indication of whether the header has been cancelled.
355 * Permissible values Y and N.
356 * @param p_currency_code The currency in which all lines are defined.
357 * @param p_date_raised The date this header was raised.
358 * @param p_payment_status_flag Describes if the invoice has been paid or not.
359 * @param p_transfer_status The Status of the header for external transfer.
360 * @param p_type The type of header. Valid vlaues are: cancellation,payable,receivable
361 * @param p_receivable_type The type of receivable header.
362 * @param p_comments Comment text.
363 * @param p_external_reference The identification of this header in the external system.
364 * @param p_invoice_address The address to which the invoice is to sent.
365 * @param p_invoice_contact The person to which this invoice is to be sent.
366 * @param p_payment_method The payment Method by which this header is to be paid.
367 * @param p_pym_information_category The flexfield to hold Payment Method Details.
368 * @param p_pym_attribute1 Payment Method Descriptive flexfield segment.
369 * @param p_pym_attribute2 Payment Method Descriptive flexfield segment.
370 * @param p_pym_attribute3 Payment Method Descriptive flexfield segment.
371 * @param p_pym_attribute4 Payment Method Descriptive flexfield segment.
372 * @param p_pym_attribute5 Payment Method Descriptive flexfield segment.
373 * @param p_pym_attribute6 Payment Method Descriptive flexfield segment.
374 * @param p_pym_attribute7 Payment Method Descriptive flexfield segment.
375 * @param p_pym_attribute8 Payment Method Descriptive flexfield segment.
376 * @param p_pym_attribute9 Payment Method Descriptive flexfield segment.
377 * @param p_pym_attribute10 Payment Method Descriptive flexfield segment.
378 * @param p_pym_attribute11 Payment Method Descriptive flexfield segment.
379 * @param p_pym_attribute12 Payment Method Descriptive flexfield segment.
380 * @param p_pym_attribute13 Payment Method Descriptive flexfield segment.
381 * @param p_pym_attribute14 Payment Method Descriptive flexfield segment.
382 * @param p_pym_attribute15 Payment Method Descriptive flexfield segment.
383 * @param p_pym_attribute16 Payment Method Descriptive flexfield segment.
384 * @param p_pym_attribute17 Payment Method Descriptive flexfield segment.
385 * @param p_pym_attribute18 Payment Method Descriptive flexfield segment.
386 * @param p_pym_attribute19 Payment Method Descriptive flexfield segment.
387 * @param p_pym_attribute20 Payment Method Descriptive flexfield segment.
388 * @param p_transfer_date The date this header was transfered into an external system.
389 * @param p_transfer_message A message to send to the external system with this header.
390 * @param p_vendor_id Foreign key to PO_VENDORS.
391 * @param p_contact_id Foreign key to RA_CONTACTS.
392 * @param p_address_id Foreign key to RA_ADDRESSES.
393 * @param p_customer_id Foreign key to RA_CUSTOMERS.
394 * @param p_tfh_information_category This context value determines which flexfield structure
395 * to use with the descriptive flexfield segments.
396 * @param p_tfh_information1 Descriptive flexfield segment.
397 * @param p_tfh_information2 Descriptive flexfield segment.
398 * @param p_tfh_information3 Descriptive flexfield segment.
399 * @param p_tfh_information4 Descriptive flexfield segment.
400 * @param p_tfh_information5 Descriptive flexfield segment.
401 * @param p_tfh_information6 Descriptive flexfield segment.
402 * @param p_tfh_information7 Descriptive flexfield segment.
403 * @param p_tfh_information8 Descriptive flexfield segment.
404 * @param p_tfh_information9 Descriptive flexfield segment.
405 * @param p_tfh_information10 Descriptive flexfield segment.
406 * @param p_tfh_information11 Descriptive flexfield segment.
407 * @param p_tfh_information12 Descriptive flexfield segment.
408 * @param p_tfh_information13 Descriptive flexfield segment.
409 * @param p_tfh_information14 Descriptive flexfield segment.
410 * @param p_tfh_information15 Descriptive flexfield segment.
411 * @param p_tfh_information16 Descriptive flexfield segment.
412 * @param p_tfh_information17 Descriptive flexfield segment.
413 * @param p_tfh_information18 Descriptive flexfield segment.
414 * @param p_tfh_information19 Descriptive flexfield segment.
415 * @param p_tfh_information20 Descriptive flexfield segment.
416 * @param p_paying_cost_center Paying cost center code for the resource charge cross transfer.
417 * @param p_receiving_cost_center Receiving cost center code for the resource charge cross transfer.
418 * @param p_transfer_from_set_of_book_id Transfer from Set of books id.
419 * @param p_transfer_to_set_of_book_id Transfer to Set of books id.
420 * @param p_from_segment1 GL From Descriptive flexfield segment.
421 * @param p_from_segment2 GL From Descriptive flexfield segment.
422 * @param p_from_segment3 GL From Descriptive flexfield segment.
423 * @param p_from_segment4 GL From Descriptive flexfield segment.
424 * @param p_from_segment5 GL From Descriptive flexfield segment.
425 * @param p_from_segment6 GL From Descriptive flexfield segment.
426 * @param p_from_segment7 GL From Descriptive flexfield segment.
427 * @param p_from_segment8 GL From Descriptive flexfield segment.
428 * @param p_from_segment9 GL From Descriptive flexfield segment.
429 * @param p_from_segment10 GL From Descriptive flexfield segment.
430 * @param p_from_segment11 GL From Descriptive flexfield segment.
431 * @param p_from_segment12 GL From Descriptive flexfield segment.
432 * @param p_from_segment13 GL From Descriptive flexfield segment.
433 * @param p_from_segment14 GL From Descriptive flexfield segment.
437 * @param p_from_segment18 GL From Descriptive flexfield segment.
434 * @param p_from_segment15 GL From Descriptive flexfield segment.
435 * @param p_from_segment16 GL From Descriptive flexfield segment.
436 * @param p_from_segment17 GL From Descriptive flexfield segment.
438 * @param p_from_segment19 GL From Descriptive flexfield segment.
439 * @param p_from_segment20 GL From Descriptive flexfield segment.
440 * @param p_from_segment21 GL From Descriptive flexfield segment.
441 * @param p_from_segment22 GL From Descriptive flexfield segment.
442 * @param p_from_segment23 GL From Descriptive flexfield segment.
443 * @param p_from_segment24 GL From Descriptive flexfield segment.
444 * @param p_from_segment25 GL From Descriptive flexfield segment.
445 * @param p_from_segment26 GL From Descriptive flexfield segment.
446 * @param p_from_segment27 GL From Descriptive flexfield segment.
447 * @param p_from_segment28 GL From Descriptive flexfield segment.
448 * @param p_from_segment29 GL From Descriptive flexfield segment.
449 * @param p_from_segment30 GL From Descriptive flexfield segment.
450 * @param p_to_segment1 GL To Descriptive flexfield segment.
451 * @param p_to_segment2 GL To Descriptive flexfield segment.
452 * @param p_to_segment3 GL To Descriptive flexfield segment.
453 * @param p_to_segment4 GL To Descriptive flexfield segment.
454 * @param p_to_segment5 GL To Descriptive flexfield segment.
455 * @param p_to_segment6 GL To Descriptive flexfield segment.
456 * @param p_to_segment7 GL To Descriptive flexfield segment.
457 * @param p_to_segment8 GL To Descriptive flexfield segment.
458 * @param p_to_segment9 GL To Descriptive flexfield segment.
459 * @param p_to_segment10 GL To Descriptive flexfield segment.
460 * @param p_to_segment11 GL To Descriptive flexfield segment.
461 * @param p_to_segment12 GL To Descriptive flexfield segment.
462 * @param p_to_segment13 GL To Descriptive flexfield segment.
463 * @param p_to_segment14 GL To Descriptive flexfield segment.
464 * @param p_to_segment15 GL To Descriptive flexfield segment.
465 * @param p_to_segment16 GL To Descriptive flexfield segment.
466 * @param p_to_segment17 GL To Descriptive flexfield segment.
467 * @param p_to_segment18 GL To Descriptive flexfield segment.
468 * @param p_to_segment19 GL To Descriptive flexfield segment.
469 * @param p_to_segment20 GL To Descriptive flexfield segment.
470 * @param p_to_segment21 GL To Descriptive flexfield segment.
471 * @param p_to_segment22 GL To Descriptive flexfield segment.
472 * @param p_to_segment23 GL To Descriptive flexfield segment.
473 * @param p_to_segment24 GL To Descriptive flexfield segment.
474 * @param p_to_segment25 GL To Descriptive flexfield segment.
475 * @param p_to_segment26 GL To Descriptive flexfield segment.
476 * @param p_to_segment27 GL To Descriptive flexfield segment.
477 * @param p_to_segment28 GL To Descriptive flexfield segment.
478 * @param p_to_segment29 GL To Descriptive flexfield segment.
479 * @param p_to_segment30 GL To Descriptive flexfield segment.
480 * @param p_transfer_from_cc_id Transfer from GL Code Combination Id.
481 * @param p_transfer_to_cc_id Transfer to GL Code Combination Id.
482 * @param p_validate If true, then validation alone will be performed and the
483 * database will remain unchanged. If false and all validation checks pass,
484 * then the database will be modified.
485 * @param p_effective_date Reference date for validating that lookup values are
486 * applicable during the start to end active date range. This date does not
487 * determine when the changes take effect.
488 * @rep:displayname Update Finanace Header
489 * @rep:category BUSINESS_ENTITY OTA_FINANCE_HEADER
490 * @rep:lifecycle active
491 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
492 * @rep:scope public
493 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
494 */
495 --
496 -- {End Of Comments}
497 --
498 procedure UPDATE_FINANCE_HEADER
499 (
500 p_finance_header_id in number,
501 p_object_version_number in out nocopy number,
502 p_new_object_version_number out nocopy number,
503 p_superceding_header_id in number ,
504 p_authorizer_person_id in number ,
505 p_organization_id in number,
506 p_administrator in number,
507 p_cancelled_flag in varchar2,
508 p_currency_code in varchar2,
509 p_date_raised in date,
510 p_payment_status_flag in varchar2,
511 p_transfer_status in varchar2,
512 p_type in varchar2,
513 p_receivable_type in varchar2,
514 p_comments in varchar2,
515 p_external_reference in varchar2,
516 p_invoice_address in varchar2,
517 p_invoice_contact in varchar2,
518 p_payment_method in varchar2,
519 p_pym_information_category in varchar2,
520 p_pym_attribute1 in varchar2,
521 p_pym_attribute2 in varchar2,
522 p_pym_attribute3 in varchar2,
523 p_pym_attribute4 in varchar2,
524 p_pym_attribute5 in varchar2,
525 p_pym_attribute6 in varchar2,
526 p_pym_attribute7 in varchar2,
527 p_pym_attribute8 in varchar2,
528 p_pym_attribute9 in varchar2,
529 p_pym_attribute10 in varchar2,
530 p_pym_attribute11 in varchar2,
531 p_pym_attribute12 in varchar2,
532 p_pym_attribute13 in varchar2,
533 p_pym_attribute14 in varchar2,
534 p_pym_attribute15 in varchar2,
535 p_pym_attribute16 in varchar2,
536 p_pym_attribute17 in varchar2,
537 p_pym_attribute18 in varchar2,
538 p_pym_attribute19 in varchar2,
539 p_pym_attribute20 in varchar2,
540 p_transfer_date in date ,
544 p_address_id in number ,
541 p_transfer_message in varchar2,
542 p_vendor_id in number ,
543 p_contact_id in number ,
545 p_customer_id in number ,
546 p_tfh_information_category in varchar2,
547 p_tfh_information1 in varchar2,
548 p_tfh_information2 in varchar2,
549 p_tfh_information3 in varchar2,
550 p_tfh_information4 in varchar2,
551 p_tfh_information5 in varchar2,
552 p_tfh_information6 in varchar2,
553 p_tfh_information7 in varchar2,
554 p_tfh_information8 in varchar2,
555 p_tfh_information9 in varchar2,
556 p_tfh_information10 in varchar2,
557 p_tfh_information11 in varchar2,
558 p_tfh_information12 in varchar2,
559 p_tfh_information13 in varchar2,
560 p_tfh_information14 in varchar2,
561 p_tfh_information15 in varchar2,
562 p_tfh_information16 in varchar2,
563 p_tfh_information17 in varchar2,
564 p_tfh_information18 in varchar2,
565 p_tfh_information19 in varchar2,
566 p_tfh_information20 in varchar2,
567 p_paying_cost_center in varchar2,
568 p_receiving_cost_center in varchar2,
569 p_transfer_from_set_of_book_id in number,
570 p_transfer_to_set_of_book_id in number,
571 p_from_segment1 in varchar2,
572 p_from_segment2 in varchar2,
573 p_from_segment3 in varchar2,
574 p_from_segment4 in varchar2,
575 p_from_segment5 in varchar2,
576 p_from_segment6 in varchar2,
577 p_from_segment7 in varchar2,
578 p_from_segment8 in varchar2,
579 p_from_segment9 in varchar2,
580 p_from_segment10 in varchar2,
581 p_from_segment11 in varchar2,
582 p_from_segment12 in varchar2,
583 p_from_segment13 in varchar2,
584 p_from_segment14 in varchar2,
585 p_from_segment15 in varchar2,
586 p_from_segment16 in varchar2,
587 p_from_segment17 in varchar2,
588 p_from_segment18 in varchar2,
589 p_from_segment19 in varchar2,
590 p_from_segment20 in varchar2,
591 p_from_segment21 in varchar2,
592 p_from_segment22 in varchar2,
593 p_from_segment23 in varchar2,
594 p_from_segment24 in varchar2,
595 p_from_segment25 in varchar2,
596 p_from_segment26 in varchar2,
597 p_from_segment27 in varchar2,
598 p_from_segment28 in varchar2,
599 p_from_segment29 in varchar2,
600 p_from_segment30 in varchar2,
601 p_to_segment1 in varchar2,
602 p_to_segment2 in varchar2,
603 p_to_segment3 in varchar2,
604 p_to_segment4 in varchar2,
605 p_to_segment5 in varchar2,
606 p_to_segment6 in varchar2,
607 p_to_segment7 in varchar2,
608 p_to_segment8 in varchar2,
609 p_to_segment9 in varchar2,
610 p_to_segment10 in varchar2,
611 p_to_segment11 in varchar2,
612 p_to_segment12 in varchar2,
613 p_to_segment13 in varchar2,
614 p_to_segment14 in varchar2,
615 p_to_segment15 in varchar2,
616 p_to_segment16 in varchar2,
617 p_to_segment17 in varchar2,
618 p_to_segment18 in varchar2,
619 p_to_segment19 in varchar2,
620 p_to_segment20 in varchar2,
621 p_to_segment21 in varchar2,
622 p_to_segment22 in varchar2,
623 p_to_segment23 in varchar2,
624 p_to_segment24 in varchar2,
625 p_to_segment25 in varchar2,
626 p_to_segment26 in varchar2,
627 p_to_segment27 in varchar2,
628 p_to_segment28 in varchar2,
629 p_to_segment29 in varchar2,
630 p_to_segment30 in varchar2,
631 p_transfer_from_cc_id in number,
632 p_transfer_to_cc_id in number ,
633 P_validate in boolean default false,
634 p_effective_date in date
635
636
637 );
638 --
639 -- ----------------------------------------------------------------------------
643 -- {Start Of Comments}
640 -- |--------------------------< delete_finance_header >-----------------------|
641 -- ----------------------------------------------------------------------------
642 --
644 /*#
645 * This package deletes Finance header.
646 *
647 *
648 * <p><b>Licensing</b><br>
649 * This API is licensed for use with Learning Management.
650 *
651 * <p><b>Prerequisites</b><br>
652 * Finance Header with the given object version number should exist.
653 *
654 * <p><b>Post Success</b><br>
655 * The Finance header is deleted successfully.
656 *
657 * <p><b>Post Failure</b><br>
658 * The API does not delete Finance Header record, and raises an error.
659 *
660 * @param p_validate If true, then validation alone will be performed and the
661 * database will remain unchanged. If false and all validation checks pass,
662 * then the database will be modified.
663 * @param p_finance_header_id The Unique identifier of the Finance Header.
664 * @param p_object_version_number If p_validate is false, then set to the
665 * version number of the created learning path section. If p_validate is true,
666 * then the value will be null.
667 * @rep:displayname Delete Finanace Header
668 * @rep:category BUSINESS_ENTITY OTA_FINANCE_HEADER
669 * @rep:lifecycle active
670 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
671 * @rep:scope public
672 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
673 */
674 --
675 -- {End Of Comments}
676 --
677
678 procedure DELETE_FINANCE_HEADER
679 (p_validate in boolean default false
680 ,p_finance_header_id in number
681 ,p_object_version_number in number
682 );
683
684 end ota_FINANCE_HEADER_api;