[Home] [Help]
PACKAGE: APPS.PO_DOCUMENT_FUNDS_GRP
Source
1 PACKAGE PO_DOCUMENT_FUNDS_GRP AS
2 -- $Header: POXGENCS.pls 120.1 2006/07/06 11:55:39 asista noship $
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
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
123 , x_return_status OUT NOCOPY VARCHAR2
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
198 PROCEDURE do_return(
199 p_api_version IN NUMBER
200 , p_commit IN VARCHAR2 default FND_API.G_FALSE
201 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
202 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
203 , x_return_status OUT NOCOPY VARCHAR2
204 , p_doc_type IN VARCHAR2
205 , p_doc_subtype IN VARCHAR2
206 , p_doc_level IN VARCHAR2
207 , p_doc_level_id IN NUMBER
208 , p_override_date IN DATE
209 , p_use_gl_date IN VARCHAR2
210 , p_report_successes IN VARCHAR2
211 , x_po_return_code OUT NOCOPY VARCHAR2
212 , x_detailed_results OUT NOCOPY po_fcout_type
213 );
214
215
216 PROCEDURE do_reject(
217 p_api_version IN NUMBER
218 , p_commit IN VARCHAR2 default FND_API.G_FALSE
219 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
220 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
221 , x_return_status OUT NOCOPY VARCHAR2
222 , p_doc_type IN VARCHAR2
223 , p_doc_subtype IN VARCHAR2
224 , p_doc_level IN VARCHAR2
225 , p_doc_level_id IN NUMBER
226 , p_override_funds IN VARCHAR2
227 , p_use_gl_date IN VARCHAR2
228 , p_override_date IN DATE
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_cancel(
236 p_api_version IN NUMBER
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
240 , x_return_status OUT NOCOPY VARCHAR2
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_adjust(
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_employee_id IN NUMBER
263 , p_override_funds IN VARCHAR2
264 , p_use_gl_date IN VARCHAR2
265 , p_override_date IN DATE
266 , p_report_successes IN VARCHAR2
267 , x_po_return_code OUT NOCOPY VARCHAR2
268 , x_detailed_results OUT NOCOPY po_fcout_type
269 );
270
271
272 PROCEDURE do_final_close(
273 p_api_version IN NUMBER
274 , p_commit IN VARCHAR2 default FND_API.G_FALSE
275 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
276 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
277 , x_return_status OUT NOCOPY VARCHAR2
278 , p_doc_type IN VARCHAR2
279 , p_doc_subtype IN VARCHAR2
280 , p_doc_level IN VARCHAR2
281 , p_doc_level_id IN NUMBER
282 , p_override_date IN DATE
283 , p_use_gl_date IN VARCHAR2
284 , p_report_successes IN VARCHAR2
285 , x_po_return_code OUT NOCOPY VARCHAR2
286 , x_detailed_results OUT NOCOPY po_fcout_type
287 );
288
289
290 PROCEDURE reinstate_po_encumbrance(
291 p_api_version IN NUMBER,
292 p_commit IN VARCHAR2 default FND_API.G_FALSE,
293 p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE,
294 p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
295 p_distribution_id IN NUMBER,
296 p_invoice_id IN NUMBER,
297 p_encumbrance_amt IN NUMBER,
298 p_qty_cancelled IN NUMBER,
299 p_budget_account_id IN NUMBER,
300 p_gl_date IN DATE,
301 p_period_name IN VARCHAR2,
302 p_period_year IN VARCHAR2,
303 p_period_num IN VARCHAR2,
304 p_quarter_num IN VARCHAR2,
305 p_tax_line_flag IN VARCHAR2 default NULL, -- Bug 3480949
306 x_packet_id OUT NOCOPY NUMBER,
307 x_return_status OUT NOCOPY VARCHAR2
308 );
309
310
311 PROCEDURE is_agreement_encumbered(
312 p_api_version IN NUMBER
313 , p_commit IN VARCHAR2 default FND_API.G_FALSE
314 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
315 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
316 , x_return_status OUT NOCOPY VARCHAR2
317 , p_agreement_id_tbl IN PO_TBL_NUMBER
318 , x_agreement_encumbered_tbl OUT NOCOPY PO_TBL_VARCHAR1
319 );
320
321
322 PROCEDURE is_reservable(
323 p_api_version IN NUMBER
324 , p_commit IN VARCHAR2 default FND_API.G_FALSE
325 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
326 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
327 , x_return_status OUT NOCOPY VARCHAR2
328 , p_doc_type IN VARCHAR2
329 , p_doc_subtype IN VARCHAR2
330 , p_doc_level IN VARCHAR2
331 , p_doc_level_id IN NUMBER
332 , x_reservable_flag OUT NOCOPY VARCHAR2
333 );
334
335 PROCEDURE is_unreservable(
336 p_api_version IN NUMBER
337 , p_commit IN VARCHAR2 default FND_API.G_FALSE
338 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
339 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
340 , x_return_status OUT NOCOPY VARCHAR2
341 , p_doc_type IN VARCHAR2
342 , p_doc_subtype IN VARCHAR2
343 , p_doc_level IN VARCHAR2
344 , p_doc_level_id IN NUMBER
345 , x_unreservable_flag OUT NOCOPY VARCHAR2
346 );
347
348 PROCEDURE populate_encumbrance_gt(
349 p_api_version IN NUMBER
350 , p_init_msg_list IN VARCHAR2 default FND_API.G_FALSE
351 , p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL
352 , x_return_status OUT NOCOPY VARCHAR2
353 , p_doc_type IN VARCHAR2
354 , p_doc_level IN VARCHAR2
355 , p_doc_level_id_tbl IN po_tbl_number
356 , p_make_old_copies_flag IN VARCHAR2
357 , p_make_new_copies_flag IN VARCHAR2
358 , p_check_only_flag IN VARCHAR2
359 );
360 --<bug#5010001 START>
361
362 FUNCTION get_online_report_id RETURN NUMBER;
363
364 --<bug#5010001 END>
365 END PO_DOCUMENT_FUNDS_GRP;