[Home] [Help]
PACKAGE: APPS.PO_DOCUMENT_FUNDS_PVT
Source
1 PACKAGE PO_DOCUMENT_FUNDS_PVT AUTHID CURRENT_USER AS
2 -- $Header: POXVENCS.pls 120.7.12020000.3 2013/02/11 01:30:44 vegajula ship $
3
4
5 -------------------------------------------------------------------------------
6 -- Package exceptions
7 -------------------------------------------------------------------------------
8
9 g_NO_VALID_PERIOD_EXC EXCEPTION;
10
11 g_UOM_CONVERSION_EXC EXCEPTION; --<Bug 14152238 Defining an exception when UOM conversion error is occured>--
12
13 -------------------------------------------------------------------------------
14 -- Package constants
15 -------------------------------------------------------------------------------
16
17 -- encumbrance actions
18 g_action_RESERVE CONSTANT
19 PO_ACTION_HISTORY.action_code%TYPE
20 := PO_CONSTANTS_SV.RESERVE
21 ;
22 g_action_UNRESERVE CONSTANT
23 PO_ACTION_HISTORY.action_code%TYPE
24 := PO_CONSTANTS_SV.UNRESERVE
25 ;
26 g_action_ADJUST CONSTANT
27 PO_ACTION_HISTORY.action_code%TYPE
28 := PO_CONSTANTS_SV.ADJUST
29 ;
30 g_action_REQ_SPLIT CONSTANT
31 VARCHAR2(30)
32 := 'REQ_SPLIT'
33 ;
34 g_action_CANCEL CONSTANT
35 PO_ACTION_HISTORY.action_code%TYPE
36 := PO_CONSTANTS_SV.CANCEL
37 ;
38 g_action_FINAL_CLOSE CONSTANT
39 VARCHAR2(30)
40 := 'FINAL CLOSE'
41 ;
42 g_action_UNDO_FINAL_CLOSE CONSTANT
43 VARCHAR2(30)
44 := 'UNDO FINAL CLOSE'
45 ;
46 g_action_REJECT CONSTANT
47 PO_ACTION_HISTORY.action_code%TYPE
48 := PO_CONSTANTS_SV.REJECT
49 ;
50 g_action_RETURN CONSTANT
51 PO_ACTION_HISTORY.action_code%TYPE
52 := PO_CONSTANTS_SV.RETURN
53 ;
54 g_action_CBC_RESERVE CONSTANT
55 PO_ACTION_HISTORY.action_code%TYPE
56 := PO_CONSTANTS_SV.IGC_YEAR_END_RESERVE
57 ;
58 g_action_CBC_UNRESERVE CONSTANT
59 PO_ACTION_HISTORY.action_code%TYPE
60 := PO_CONSTANTS_SV.IGC_YEAR_END_UNRESERVE
61 ;
62
63 g_action_INVOICE_CANCEL CONSTANT
64 VARCHAR2(30)
65 := 'AP INVOICE CANCEL'
66 ;
67
68 g_action_CR_MEMO_CANCEL CONSTANT
69 VARCHAR2(30)
70 := 'AP CREDIT MEMO CANCEL'
71 ;
72
73
74 --standard document types:
75 g_doc_type_REQUISITION CONSTANT
76 PO_DOCUMENT_TYPES.document_type_code%TYPE
77 := PO_CORE_S.g_doc_type_REQUISITION
78 ;
79 g_doc_type_PO CONSTANT
80 PO_DOCUMENT_TYPES.document_type_code%TYPE
81 := PO_CORE_S.g_doc_type_PO
82 ;
83 g_doc_type_PA CONSTANT
84 PO_DOCUMENT_TYPES.document_type_code%TYPE
85 := PO_CORE_S.g_doc_type_PA
86 ;
87 g_doc_type_RELEASE CONSTANT
88 PO_DOCUMENT_TYPES.document_type_code%TYPE
89 := PO_CORE_S.g_doc_type_RELEASE
90 ;
91 -- non-standard doc type:
92 g_doc_type_MIXED_PO_RELEASE CONSTANT
93 PO_DOCUMENT_TYPES.document_type_code%TYPE
94 := 'MIXED_PO_RELEASE'
95 ;
96 g_doc_type_ANY CONSTANT
97 PO_DOCUMENT_TYPES.document_type_code%TYPE
98 := 'ANY'
99 ;
100
101
102 g_doc_subtype_STANDARD CONSTANT
103 PO_HEADERS_ALL.type_lookup_code%TYPE
104 := 'STANDARD'
105 ;
106 g_doc_subtype_PLANNED CONSTANT
107 PO_HEADERS_ALL.type_lookup_code%TYPE
108 := 'PLANNED'
109 ;
110 g_doc_subtype_BLANKET CONSTANT
111 PO_RELEASES_ALL.release_type%TYPE
112 := 'BLANKET'
113 ;
114 g_doc_subtype_SCHEDULED CONSTANT
115 PO_RELEASES_ALL.release_type%TYPE
116 := 'SCHEDULED'
117 ;
118 g_doc_subtype_MIXED_PO_RELEASE CONSTANT
119 PO_HEADERS_ALL.type_lookup_code%TYPE
120 := 'MIXED_PO_RELEASE'
121 ;
122
123
124 g_doc_level_HEADER CONSTANT
125 VARCHAR2(25)
126 := PO_CORE_S.g_doc_level_HEADER
127 ;
128 g_doc_level_LINE CONSTANT
129 VARCHAR2(25)
130 := PO_CORE_S.g_doc_level_LINE
131 ;
132 g_doc_level_SHIPMENT CONSTANT
133 VARCHAR2(25)
134 := PO_CORE_S.g_doc_level_SHIPMENT
135 ;
136 g_doc_level_DISTRIBUTION CONSTANT
137 VARCHAR2(25)
138 := PO_CORE_S.g_doc_level_DISTRIBUTION
139 ;
140
141
142 g_dist_type_STANDARD CONSTANT
143 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
144 := PO_CORE_S.g_dist_type_STANDARD
145 ;
146 g_dist_type_PLANNED CONSTANT
147 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
148 := PO_CORE_S.g_dist_type_PLANNED
149 ;
150 g_dist_type_SCHEDULED CONSTANT
151 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
152 := PO_CORE_S.g_dist_type_SCHEDULED
153 ;
154 g_dist_type_BLANKET CONSTANT
155 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
156 := PO_CORE_S.g_dist_type_BLANKET
157 ;
158 g_dist_type_AGREEMENT CONSTANT
159 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
160 := PO_CORE_S.g_dist_type_AGREEMENT
161 ;
162 --<Complex Work R12>: added prepayment type
163 g_dist_type_PREPAYMENT CONSTANT
164 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
165 := PO_CORE_S.g_dist_type_PREPAYMENT
166 ;
167 -- non-standard distribution types:
168 g_dist_type_REQUISITION CONSTANT
169 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
170 := 'REQUISITION'
171 ;
172 g_dist_type_MIXED_PO_RELEASE CONSTANT
173 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
174 := 'MIXED_PO_RELEASE'
175 ;
176
177
178 g_adjustment_status_OLD CONSTANT
179 PO_ENCUMBRANCE_GT.adjustment_status%TYPE
180 := 'OLD'
181 ;
182 g_adjustment_status_NEW CONSTANT
183 PO_ENCUMBRANCE_GT.adjustment_status%TYPE
184 := 'NEW'
185 ;
186
187 g_parameter_YES CONSTANT
188 VARCHAR2(1)
189 := 'Y'
190 ;
191 g_parameter_NO CONSTANT
192 VARCHAR2(1)
193 := 'N'
194 ;
195 g_parameter_USE_PROFILE CONSTANT
196 VARCHAR2(1)
197 := 'U'
198 ;
199
200 g_return_SUCCESS CONSTANT
201 VARCHAR2(10)
202 := 'SUCCESS'
203 ;
204 g_return_WARNING CONSTANT
205 VARCHAR2(10)
206 := 'WARNING'
207 ;
208 g_return_PARTIAL CONSTANT
209 VARCHAR2(10)
210 := 'PARTIAL'
211 ;
212 g_return_FAILURE CONSTANT
213 VARCHAR2(10)
214 := 'FAILURE'
215 ;
216 g_return_FATAL CONSTANT
217 VARCHAR2(10)
218 := 'FATAL'
219 ;
220
221 -- Result classifications (for online report)
222 g_result_SUCCESS CONSTANT
223 PO_ENCUMBRANCE_GT.result_type%TYPE := 'S';
224
225 g_result_WARNING CONSTANT
226 PO_ENCUMBRANCE_GT.result_type%TYPE := 'W';
227
228 g_result_ERROR CONSTANT
229 PO_ENCUMBRANCE_GT.result_type%TYPE := 'E';
230
231 --<SLA R12 Start>
232 g_event_type_code VARCHAR2(30);
233 g_entity_type_code VARCHAR2(30);
234 --<SLA R12 End>
235
236 -- Global package variables
237
238 g_req_encumbrance_on BOOLEAN;
239 g_po_encumbrance_on BOOLEAN;
240 g_pa_encumbrance_on BOOLEAN;
241
242 g_MAIN CONSTANT VARCHAR2(10) := 'MAIN';
243 g_BACKING CONSTANT VARCHAR2(10) := 'BACKING';
244
245 --<bug#5010001 START>
246 g_ONLINE_REPORT_ID PO_ONLINE_REPORT_TEXT.online_report_id%type;
247 --<bug#5010001 END>
248
249 PROCEDURE check_reserve(
250 x_return_status OUT NOCOPY VARCHAR2
251 , p_doc_type IN VARCHAR2
252 , p_doc_subtype IN VARCHAR2
253 , p_doc_level IN VARCHAR2
254 , p_doc_level_id IN NUMBER
255 , p_use_enc_gt_flag IN VARCHAR2
256 , p_override_funds IN VARCHAR2
257 , p_draft_id IN NUMBER DEFAULT NULL /* <<CLM Partial Funding Code Changes>> */
258 , x_po_return_code OUT NOCOPY VARCHAR2
259 , x_online_report_id OUT NOCOPY NUMBER
260 );
261
262 PROCEDURE check_adjust(
263 x_return_status OUT NOCOPY VARCHAR2
264 , p_doc_type IN VARCHAR2
265 , p_doc_subtype IN VARCHAR2
266 , p_override_funds IN VARCHAR2
267 , p_use_gl_date IN VARCHAR2
268 , p_override_date IN DATE
269 , x_po_return_code OUT NOCOPY VARCHAR2
270 , x_online_report_id OUT NOCOPY NUMBER
271 );
272
273
274 PROCEDURE do_reserve(
275 x_return_status OUT NOCOPY VARCHAR2
276 , p_doc_type IN VARCHAR2
277 , p_doc_subtype IN VARCHAR2
278 , p_doc_level IN VARCHAR2
279 , p_doc_level_id IN NUMBER
280 , p_use_enc_gt_flag IN VARCHAR2
281 , p_prevent_partial_flag IN VARCHAR2
282 , p_validate_document IN VARCHAR2
283 , p_override_funds IN VARCHAR2
284 , p_employee_id IN NUMBER
285 , x_po_return_code OUT NOCOPY VARCHAR2
286 , x_online_report_id OUT NOCOPY NUMBER
287 );
288
289
290 PROCEDURE do_unreserve(
291 x_return_status OUT NOCOPY VARCHAR2
292 , p_doc_type IN VARCHAR2
293 , p_doc_subtype IN VARCHAR2
294 , p_doc_level IN VARCHAR2
295 , p_doc_level_id IN NUMBER
296 , p_use_enc_gt_flag IN VARCHAR2
297 , p_validate_document IN VARCHAR2
298 , p_override_funds IN VARCHAR2
299 , p_use_gl_date IN VARCHAR2
300 , p_override_date IN DATE
301 , p_employee_id IN NUMBER
302 , x_po_return_code OUT NOCOPY VARCHAR2
303 , x_online_report_id OUT NOCOPY NUMBER
304 );
305
306
307 PROCEDURE do_return(
308 x_return_status OUT NOCOPY VARCHAR2
309 , p_doc_type IN VARCHAR2
310 , p_doc_subtype IN VARCHAR2
311 , p_doc_level IN VARCHAR2
312 , p_doc_level_id IN NUMBER
313 , p_use_enc_gt_flag IN VARCHAR2
314 , p_use_gl_date IN VARCHAR2
315 , p_override_date IN DATE
316 , x_po_return_code OUT NOCOPY VARCHAR2
317 , x_online_report_id OUT NOCOPY NUMBER
318 );
319
320
321 PROCEDURE do_reject(
322 x_return_status OUT NOCOPY VARCHAR2
323 , p_doc_type IN VARCHAR2
324 , p_doc_subtype IN VARCHAR2
325 , p_doc_level IN VARCHAR2
326 , p_doc_level_id IN NUMBER
327 , p_use_enc_gt_flag IN VARCHAR2
328 , p_override_funds IN VARCHAR2
329 , p_use_gl_date IN VARCHAR2
330 , p_override_date IN DATE
331 , x_po_return_code OUT NOCOPY VARCHAR2
332 , x_online_report_id OUT NOCOPY NUMBER
333 );
334
335
336 PROCEDURE do_cancel(
337 x_return_status OUT NOCOPY VARCHAR2
338 , p_doc_type IN VARCHAR2
339 , p_doc_subtype IN VARCHAR2
340 , p_doc_level IN VARCHAR2
341 , p_doc_level_id IN NUMBER
342 , p_use_enc_gt_flag IN VARCHAR2
343 , p_override_funds IN VARCHAR2
344 , p_use_gl_date IN VARCHAR2
345 , p_override_date IN DATE
346 , x_po_return_code OUT NOCOPY VARCHAR2
347 , x_online_report_id OUT NOCOPY NUMBER
348 );
349
350
351 PROCEDURE do_adjust(
352 x_return_status OUT NOCOPY VARCHAR2
353 , p_doc_type IN VARCHAR2
354 , p_doc_subtype IN VARCHAR2
355 , p_override_funds IN VARCHAR2
356 , p_use_gl_date IN VARCHAR2
357 , p_validate_document IN VARCHAR2
358 , p_override_date IN DATE
359 , p_employee_id IN NUMBER
360 , x_po_return_code OUT NOCOPY VARCHAR2
361 , x_online_report_id OUT NOCOPY NUMBER
362 );
363
364 PROCEDURE do_req_split(
365 x_return_status OUT NOCOPY VARCHAR2
366 , p_before_dist_ids_tbl IN po_tbl_number
367 , p_after_dist_ids_tbl IN po_tbl_number
368 , p_employee_id IN NUMBER
369 , p_override_funds IN VARCHAR2
370 , p_override_date IN DATE
371 , x_po_return_code OUT NOCOPY VARCHAR2
372 , x_online_report_id OUT NOCOPY NUMBER
373 );
374
375 PROCEDURE do_final_close(
376 x_return_status OUT NOCOPY VARCHAR2
377 , p_doc_type IN VARCHAR2
378 , p_doc_subtype IN VARCHAR2
379 , p_doc_level IN VARCHAR2
380 , p_doc_level_id IN NUMBER
381 , p_use_enc_gt_flag IN VARCHAR2
382 , p_use_gl_date IN VARCHAR2
383 , p_override_date IN DATE
384 , p_invoice_id IN NUMBER DEFAULT NULL
385 , x_po_return_code OUT NOCOPY VARCHAR2
386 , x_online_report_id OUT NOCOPY NUMBER
387 );
388
389 PROCEDURE undo_final_close(
390 x_return_status OUT NOCOPY VARCHAR2
391 , p_doc_type IN VARCHAR2
392 , p_doc_subtype IN VARCHAR2
393 , p_doc_level IN VARCHAR2
394 , p_doc_level_id IN NUMBER
395 , p_use_enc_gt_flag IN VARCHAR2
396 , p_override_funds IN VARCHAR2
397 , p_use_gl_date IN VARCHAR2
398 , p_override_date IN DATE
399 , p_invoice_id IN NUMBER
400 , x_po_return_code OUT NOCOPY VARCHAR2
401 , x_online_report_id OUT NOCOPY NUMBER
402 );
403
404
405 PROCEDURE do_cbc_yearend_reserve(
406 x_return_status OUT NOCOPY VARCHAR2
407 , p_doc_type IN VARCHAR2
408 , p_doc_subtype IN VARCHAR2
409 , p_doc_level IN VARCHAR2
410 , p_doc_level_id IN NUMBER
411 , p_override_funds IN VARCHAR2
412 , p_employee_id IN NUMBER
413 , x_po_return_code OUT NOCOPY VARCHAR2
414 , x_online_report_id OUT NOCOPY NUMBER
415 );
416
417
418 PROCEDURE do_cbc_yearend_unreserve(
419 x_return_status OUT NOCOPY VARCHAR2
420 , p_doc_type IN VARCHAR2
421 , p_doc_subtype IN VARCHAR2
422 , p_doc_level IN VARCHAR2
423 , p_doc_level_id IN NUMBER
424 , p_override_funds IN VARCHAR2
425 , p_use_gl_date IN VARCHAR2
426 , p_override_date IN DATE
427 , p_employee_id IN NUMBER
428 , x_po_return_code OUT NOCOPY VARCHAR2
429 , x_online_report_id OUT NOCOPY NUMBER
430 );
431
432
433 PROCEDURE reinstate_po_encumbrance(
434 x_return_status OUT NOCOPY VARCHAR2,
435 p_distribution_id IN NUMBER,
436 p_invoice_id IN NUMBER,
437 p_encumbrance_amt IN NUMBER,
438 p_qty_cancelled IN NUMBER,
439 p_budget_account_id IN NUMBER,
440 p_gl_date IN DATE,
441 p_period_name IN VARCHAR2,
442 p_period_year IN VARCHAR2,
443 p_period_num IN VARCHAR2,
444 p_quarter_num IN VARCHAR2,
445 p_tax_line_flag IN VARCHAR2, -- But 3480949
446 x_packet_id OUT NOCOPY NUMBER
447 );
448
449
450 PROCEDURE is_agreement_encumbered(
451 x_return_status OUT NOCOPY VARCHAR2
452 , p_agreement_id_tbl IN PO_TBL_NUMBER
453 , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
454 );
455
456
457 PROCEDURE is_agreement_encumbered(
458 x_return_status OUT NOCOPY VARCHAR2
459 , p_agreement_id IN NUMBER
460 , x_agreement_encumbered_flag OUT NOCOPY VARCHAR2
461 );
462
463
464 PROCEDURE is_reservable(
465 x_return_status OUT NOCOPY VARCHAR2
466 , p_doc_type IN VARCHAR2
467 , p_doc_subtype IN VARCHAR2
468 , p_doc_level IN VARCHAR2
469 , p_doc_level_id IN NUMBER
470 , x_reservable_flag OUT NOCOPY VARCHAR2
471 );
472
473
474 PROCEDURE is_unreservable(
475 x_return_status OUT NOCOPY VARCHAR2
476 , p_doc_type IN VARCHAR2
477 , p_doc_subtype IN VARCHAR2
478 , p_doc_level IN VARCHAR2
479 , p_doc_level_id IN NUMBER
480 , x_unreservable_flag OUT NOCOPY VARCHAR2
481 );
482
483
484 PROCEDURE populate_encumbrance_gt(
485 x_return_status OUT NOCOPY VARCHAR2
486 , p_doc_type IN VARCHAR2
487 , p_doc_level IN VARCHAR2
488 , p_doc_level_id_tbl IN po_tbl_number
489 , p_adjustment_status_tbl IN po_tbl_varchar5
490 , p_check_only_flag IN VARCHAR2
491 );
492
493
494 PROCEDURE populate_enc_gt_action_ids(
495 x_return_status OUT NOCOPY VARCHAR2
496 , p_doc_type IN VARCHAR2
497 , p_doc_subtype IN VARCHAR2
498 , p_doc_level IN VARCHAR2
499 , p_doc_level_id_tbl IN po_tbl_number
500 );
501
502 /* <<CLM Partial Funding Code Changes>> */
503 PROCEDURE Populate_Enc_Gt_With_Draft(
504 x_return_status OUT NOCOPY VARCHAR2
505 , p_draft_id IN NUMBER
506 );
507 /* <<CLM Partial Funding Code Changes>> */
508
509 PROCEDURE create_report_object(
510 x_return_status OUT NOCOPY VARCHAR2
511 , p_online_report_id IN NUMBER
512 , p_report_successes IN VARCHAR2
513 , x_report_object OUT NOCOPY po_fcout_type
514 );
515
516 --<R12 SLA Start>
517 PROCEDURE POPULATE_BC_REPORT_EVENTS
518 (
519 x_return_status OUT NOCOPY VARCHAR2,
520 p_online_report_id IN NUMBER,--<bug#5055417>
521 x_events_populated OUT NOCOPY VARCHAR2
522 );
523
524 PROCEDURE POPULATE_AND_CREATE_BC_REPORT
525 (
526 x_return_status OUT NOCOPY VARCHAR2,
527 p_online_report_id IN NUMBER,--<bug#5055417>
528 p_ledger_id IN NUMBER,
529 p_sequence_id IN NUMBER,
530 x_report_created OUT NOCOPY VARCHAR2
531 );
532 --<R12 SLA End>
533 --<bug#5085428 START>
534 FUNCTION is_req_enc_flipped(p_req_dist_id IN NUMBER,
535 p_event_id IN NUMBER)
536 RETURN VARCHAR2;
537 --<bug#5085428 END>
538 END PO_DOCUMENT_FUNDS_PVT;