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