[Home] [Help]
PACKAGE: APPS.PO_DOCUMENT_FUNDS_GRP
Source
1 PACKAGE PO_DOCUMENT_FUNDS_GRP AUTHID CURRENT_USER AS
2 -- $Header: POXGENCS.pls 120.2.12020000.2 2013/02/10 17:12:19 vegajula ship $
3
4 -- Global Variables
5
6 g_doc_type_REQUISITION CONSTANT
7 PO_DOCUMENT_TYPES.document_type_code%TYPE
8 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_REQUISITION;
9 g_doc_type_PO CONSTANT
10 PO_DOCUMENT_TYPES.document_type_code%TYPE
11 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PO;
12 g_doc_type_PA CONSTANT
13 PO_DOCUMENT_TYPES.document_type_code%TYPE
14 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_PA;
15 g_doc_type_RELEASE CONSTANT
16 PO_DOCUMENT_TYPES.document_type_code%TYPE
17 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_RELEASE;
18 g_doc_type_MIXED_PO_RELEASE CONSTANT
19 PO_DOCUMENT_TYPES.document_type_code%TYPE
20 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_MIXED_PO_RELEASE;
21 g_doc_type_ANY CONSTANT
22 PO_DOCUMENT_TYPES.document_type_code%TYPE
23 := PO_DOCUMENT_FUNDS_PVT.g_doc_type_ANY;
24
25 g_doc_subtype_STANDARD CONSTANT
26 PO_HEADERS_ALL.type_lookup_code%TYPE
27 := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_STANDARD;
28 g_doc_subtype_PLANNED CONSTANT
29 PO_HEADERS_ALL.type_lookup_code%TYPE
30 := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_PLANNED;
31 g_doc_subtype_BLANKET CONSTANT
32 PO_RELEASES_ALL.release_type%TYPE
33 := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_BLANKET;
34 g_doc_subtype_SCHEDULED CONSTANT
35 PO_RELEASES_ALL.release_type%TYPE
36 := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_SCHEDULED;
37 g_doc_subtype_MIXED_PO_RELEASE CONSTANT
38 PO_HEADERS_ALL.type_lookup_code%TYPE
39 := PO_DOCUMENT_FUNDS_PVT.g_doc_subtype_MIXED_PO_RELEASE;
40
41 g_doc_level_HEADER CONSTANT VARCHAR2(25)
42 := PO_DOCUMENT_FUNDS_PVT.g_doc_level_HEADER;
43 g_doc_level_LINE CONSTANT VARCHAR2(25)
44 := PO_DOCUMENT_FUNDS_PVT.g_doc_level_LINE;
45 g_doc_level_SHIPMENT CONSTANT VARCHAR2(25)
46 := PO_DOCUMENT_FUNDS_PVT.g_doc_level_SHIPMENT;
47 g_doc_level_DISTRIBUTION CONSTANT VARCHAR2(25)
48 := PO_DOCUMENT_FUNDS_PVT.g_doc_level_DISTRIBUTION;
49
50 g_dist_type_STANDARD CONSTANT
51 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
52 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_STANDARD;
53 g_dist_type_PLANNED CONSTANT
54 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
55 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_PLANNED;
56 g_dist_type_SCHEDULED CONSTANT
57 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
58 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_SCHEDULED;
59 g_dist_type_BLANKET CONSTANT
60 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
61 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_BLANKET;
62 g_dist_type_AGREEMENT CONSTANT
63 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
64 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_AGREEMENT;
65 g_dist_type_REQUISITION CONSTANT
66 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
67 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_REQUISITION;
68 g_dist_type_MIXED_PO_RELEASE CONSTANT
69 PO_DISTRIBUTIONS_ALL.distribution_type%TYPE
70 := PO_DOCUMENT_FUNDS_PVT.g_dist_type_MIXED_PO_RELEASE;
71
72 g_adjustment_status_OLD CONSTANT
73 PO_ENCUMBRANCE_GT.adjustment_status%TYPE
74 := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_OLD;
75 g_adjustment_status_NEW CONSTANT
76 PO_ENCUMBRANCE_GT.adjustment_status%TYPE
77 := PO_DOCUMENT_FUNDS_PVT.g_adjustment_status_NEW;
78
79 g_parameter_YES CONSTANT VARCHAR2(1)
80 := PO_DOCUMENT_FUNDS_PVT.g_parameter_YES;
81 g_parameter_NO CONSTANT VARCHAR2(1)
82 := PO_DOCUMENT_FUNDS_PVT.g_parameter_NO;
83 g_parameter_USE_PROFILE CONSTANT VARCHAR2(1)
84 := PO_DOCUMENT_FUNDS_PVT.g_parameter_USE_PROFILE;
85
86 g_return_SUCCESS CONSTANT VARCHAR2(10)
87 := PO_DOCUMENT_FUNDS_PVT.g_return_SUCCESS;
88 g_return_WARNING CONSTANT VARCHAR2(10)
89 := PO_DOCUMENT_FUNDS_PVT.g_return_WARNING;
90 g_return_PARTIAL CONSTANT VARCHAR2(10)
91 := PO_DOCUMENT_FUNDS_PVT.g_return_PARTIAL;
92 g_return_FAILURE CONSTANT VARCHAR2(10)
93 := PO_DOCUMENT_FUNDS_PVT.g_return_FAILURE;
94 g_return_FATAL CONSTANT VARCHAR2(10)
95 := PO_DOCUMENT_FUNDS_PVT.g_return_FATAL;
96
97 g_action_FINAL_CLOSE CONSTANT VARCHAR2(30)
98 := PO_DOCUMENT_FUNDS_PVT.g_action_FINAL_CLOSE;
99 g_action_RESERVE CONSTANT VARCHAR2(30)
100 := PO_DOCUMENT_FUNDS_PVT.g_action_RESERVE;
101 g_action_CANCEL CONSTANT VARCHAR2(30)
102 := PO_DOCUMENT_FUNDS_PVT.g_action_CANCEL;
103 g_action_ADJUST CONSTANT VARCHAR2(30)
104 := PO_DOCUMENT_FUNDS_PVT.g_action_ADJUST;
105 g_action_UNRESERVE CONSTANT VARCHAR2(30)
106 := PO_DOCUMENT_FUNDS_PVT.g_action_UNRESERVE;
107 g_action_REJECT CONSTANT VARCHAR2(30)
108 := PO_DOCUMENT_FUNDS_PVT.g_action_REJECT;
109 g_action_RETURN CONSTANT VARCHAR2(30)
110 := PO_DOCUMENT_FUNDS_PVT.g_action_RETURN;
111
112
113 g_MAIN CONSTANT VARCHAR2(10)
114 := PO_DOCUMENT_FUNDS_PVT.g_MAIN;
115 g_BACKING CONSTANT VARCHAR2(10)
116 := PO_DOCUMENT_FUNDS_PVT.g_BACKING;
117
118 PROCEDURE check_reserve(
119 p_api_version IN NUMBER
123 , x_return_status OUT NOCOPY VARCHAR2
120 , p_commit IN VARCHAR2 default FND_API.G_FALSE
121 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
122 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
124 , p_doc_type IN VARCHAR2
125 , p_doc_subtype IN VARCHAR2
126 , p_doc_level IN VARCHAR2
127 , p_doc_level_id IN NUMBER
128 , p_use_enc_gt_flag IN VARCHAR2
129 , p_override_funds IN VARCHAR2
130 , p_report_successes IN VARCHAR2
131 , x_po_return_code OUT NOCOPY VARCHAR2
132 , x_detailed_results OUT NOCOPY po_fcout_type
133 );
134
135
136 PROCEDURE check_adjust(
137 p_api_version IN NUMBER
138 , p_commit IN VARCHAR2 default FND_API.G_FALSE
139 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
140 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
141 , x_return_status OUT NOCOPY VARCHAR2
142 , p_doc_type IN VARCHAR2
143 , p_doc_subtype IN VARCHAR2
144 , p_override_funds IN VARCHAR2
145 , p_use_gl_date IN VARCHAR2
146 , p_override_date IN DATE
147 , p_report_successes IN VARCHAR2
148 , x_po_return_code OUT NOCOPY VARCHAR2
149 , x_detailed_results OUT NOCOPY po_fcout_type
150 );
151
152
153 PROCEDURE do_reserve(
154 p_api_version IN NUMBER
155 , p_commit IN VARCHAR2
156 default FND_API.G_FALSE
157 , p_init_msg_list IN VARCHAR2
158 default FND_API.G_FALSE
159 , p_validation_level IN NUMBER
160 default FND_API.G_VALID_LEVEL_FULL
161 , x_return_status OUT NOCOPY VARCHAR2
162 , p_doc_type IN VARCHAR2
163 , p_doc_subtype IN VARCHAR2
164 , p_doc_level IN VARCHAR2
165 , p_doc_level_id_tbl IN po_tbl_number
166 , p_prevent_partial_flag IN VARCHAR2
167 , p_employee_id IN NUMBER
168 , p_override_funds IN VARCHAR2
169 , p_report_successes IN VARCHAR2
170 , x_po_return_code OUT NOCOPY VARCHAR2
171 , x_detailed_results OUT NOCOPY po_fcout_type
172 );
173
174
175 PROCEDURE do_unreserve(
176 p_api_version IN NUMBER
177 , p_commit IN VARCHAR2
178 default FND_API.G_FALSE
179 , p_init_msg_list IN VARCHAR2
180 default FND_API.G_FALSE
181 , p_validation_level IN NUMBER
182 default FND_API.G_VALID_LEVEL_FULL
183 , x_return_status OUT NOCOPY VARCHAR2
184 , p_doc_type IN VARCHAR2
185 , p_doc_subtype IN VARCHAR2
186 , p_doc_level IN VARCHAR2
187 , p_doc_level_id_tbl IN po_tbl_number
188 , p_employee_id IN NUMBER
189 , p_override_funds IN VARCHAR2
190 , p_use_gl_date IN VARCHAR2
191 , p_override_date IN DATE
192 , p_report_successes IN VARCHAR2
193 , x_po_return_code OUT NOCOPY VARCHAR2
194 , x_detailed_results OUT NOCOPY po_fcout_type
195 );
196
197 PROCEDURE do_liquidate(
198 p_api_version IN NUMBER
199 , p_commit IN VARCHAR2
200 default FND_API.G_FALSE
201 , p_init_msg_list IN VARCHAR2
202 default FND_API.G_FALSE
203 , p_validation_level IN NUMBER
204 default FND_API.G_VALID_LEVEL_FULL
205 , x_return_status OUT NOCOPY VARCHAR2
206 , p_doc_level IN VARCHAR2
207 , p_doc_level_id_tbl IN po_tbl_number
208 , p_employee_id IN NUMBER
209 , p_override_funds IN VARCHAR2
210 , p_use_gl_date IN VARCHAR2
211 , p_override_date IN DATE
212 , p_report_successes IN VARCHAR2
213 , x_po_return_code OUT NOCOPY VARCHAR2
214 , x_detailed_results OUT NOCOPY po_fcout_type
215 ); -- Bug#13587378: Encumbrance changes for Line Structure changes.
216
217 PROCEDURE do_return(
218 p_api_version IN NUMBER
219 , p_commit IN VARCHAR2 default FND_API.G_FALSE
220 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
221 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
222 , x_return_status OUT NOCOPY VARCHAR2
223 , p_doc_type IN VARCHAR2
224 , p_doc_subtype IN VARCHAR2
225 , p_doc_level IN VARCHAR2
226 , p_doc_level_id IN NUMBER
227 , p_override_date IN DATE
228 , p_use_gl_date IN VARCHAR2
229 , p_report_successes IN VARCHAR2
230 , x_po_return_code OUT NOCOPY VARCHAR2
231 , x_detailed_results OUT NOCOPY po_fcout_type
232 );
233
234
235 PROCEDURE do_reject(
236 p_api_version IN NUMBER
240 , x_return_status OUT NOCOPY VARCHAR2
237 , p_commit IN VARCHAR2 default FND_API.G_FALSE
238 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
239 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
241 , p_doc_type IN VARCHAR2
242 , p_doc_subtype IN VARCHAR2
243 , p_doc_level IN VARCHAR2
244 , p_doc_level_id IN NUMBER
245 , p_override_funds IN VARCHAR2
246 , p_use_gl_date IN VARCHAR2
247 , p_override_date IN DATE
248 , p_report_successes IN VARCHAR2
249 , x_po_return_code OUT NOCOPY VARCHAR2
250 , x_detailed_results OUT NOCOPY po_fcout_type
251 );
252
253
254 PROCEDURE do_cancel(
255 p_api_version IN NUMBER
256 , p_commit IN VARCHAR2 default FND_API.G_FALSE
257 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
258 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
259 , x_return_status OUT NOCOPY VARCHAR2
260 , p_doc_type IN VARCHAR2
261 , p_doc_subtype IN VARCHAR2
262 , p_doc_level IN VARCHAR2
263 , p_doc_level_id IN NUMBER
264 , p_override_funds IN VARCHAR2
265 , p_use_gl_date IN VARCHAR2
266 , p_override_date IN DATE
267 , p_report_successes IN VARCHAR2
268 , x_po_return_code OUT NOCOPY VARCHAR2
269 , x_detailed_results OUT NOCOPY po_fcout_type
270 );
271
272
273 PROCEDURE do_adjust(
274 p_api_version IN NUMBER
275 , p_commit IN VARCHAR2 default FND_API.G_FALSE
276 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
277 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
278 , x_return_status OUT NOCOPY VARCHAR2
279 , p_doc_type IN VARCHAR2
280 , p_doc_subtype IN VARCHAR2
281 , p_employee_id IN NUMBER
282 , p_override_funds IN VARCHAR2
283 , p_use_gl_date IN VARCHAR2
284 , p_override_date IN DATE
285 , p_report_successes IN VARCHAR2
286 , x_po_return_code OUT NOCOPY VARCHAR2
287 , x_detailed_results OUT NOCOPY po_fcout_type
288 );
289
290
291 PROCEDURE do_final_close(
292 p_api_version IN NUMBER
293 , p_commit IN VARCHAR2 default FND_API.G_FALSE
294 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
295 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
296 , x_return_status OUT NOCOPY VARCHAR2
297 , p_doc_type IN VARCHAR2
298 , p_doc_subtype IN VARCHAR2
299 , p_doc_level IN VARCHAR2
300 , p_doc_level_id IN NUMBER
301 , p_override_date IN DATE
302 , p_use_gl_date IN VARCHAR2
303 , p_report_successes IN VARCHAR2
304 , x_po_return_code OUT NOCOPY VARCHAR2
305 , x_detailed_results OUT NOCOPY po_fcout_type
306 );
307
308
309 PROCEDURE reinstate_po_encumbrance(
310 p_api_version IN NUMBER,
311 p_commit IN VARCHAR2 default FND_API.G_FALSE,
312 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
313 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
314 p_distribution_id IN NUMBER,
315 p_invoice_id IN NUMBER,
316 p_encumbrance_amt IN NUMBER,
317 p_qty_cancelled IN NUMBER,
318 p_budget_account_id IN NUMBER,
319 p_gl_date IN DATE,
320 p_period_name IN VARCHAR2,
321 p_period_year IN VARCHAR2,
322 p_period_num IN VARCHAR2,
323 p_quarter_num IN VARCHAR2,
324 p_tax_line_flag IN VARCHAR2 default NULL, -- Bug 3480949
325 x_packet_id OUT NOCOPY NUMBER,
326 x_return_status OUT NOCOPY VARCHAR2
327 );
328
329
330 PROCEDURE is_agreement_encumbered(
331 p_api_version IN NUMBER
332 , p_commit IN VARCHAR2 default FND_API.G_FALSE
333 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
334 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
335 , x_return_status OUT NOCOPY VARCHAR2
336 , p_agreement_id_tbl IN PO_TBL_NUMBER
337 , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
338 );
339
340
341 PROCEDURE is_reservable(
342 p_api_version IN NUMBER
343 , p_commit IN VARCHAR2 default FND_API.G_FALSE
344 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
345 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
346 , x_return_status OUT NOCOPY VARCHAR2
347 , p_doc_type IN VARCHAR2
348 , p_doc_subtype IN VARCHAR2
349 , p_doc_level IN VARCHAR2
350 , p_doc_level_id IN NUMBER
351 , x_reservable_flag OUT NOCOPY VARCHAR2
352 );
353
354 PROCEDURE is_unreservable(
355 p_api_version IN NUMBER
356 , p_commit IN VARCHAR2 default FND_API.G_FALSE
357 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
358 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
359 , x_return_status OUT NOCOPY VARCHAR2
360 , p_doc_type IN VARCHAR2
361 , p_doc_subtype IN VARCHAR2
362 , p_doc_level IN VARCHAR2
363 , p_doc_level_id IN NUMBER
364 , x_unreservable_flag OUT NOCOPY VARCHAR2
365 );
366
367 PROCEDURE populate_encumbrance_gt(
368 p_api_version IN NUMBER
369 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
370 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
371 , x_return_status OUT NOCOPY VARCHAR2
372 , p_doc_type IN VARCHAR2
373 , p_doc_level IN VARCHAR2
374 , p_doc_level_id_tbl IN po_tbl_number
375 , p_make_old_copies_flag IN VARCHAR2
376 , p_make_new_copies_flag IN VARCHAR2
377 , p_check_only_flag IN VARCHAR2
378 );
379 --<bug#5010001 START>
380
381 FUNCTION get_online_report_id RETURN NUMBER;
382
383 --<bug#5010001 END>
384 END PO_DOCUMENT_FUNDS_GRP;