1 package po_doc_numbering_pkg AUTHID CURRENT_USER AS
2 /* $Header: po_doc_numbering_pkg.pls 120.10.12020000.3 2013/02/26 08:46:20 amalick ship $ */
3
4 PROCEDURE DEFAULT_DOC_NUMBER_UDA( p_doc_header_id IN NUMBER,
5 p_draft_id IN NUMBER,
6 p_template_id IN NUMBER,
7 p_context_usage IN VARCHAR2,
8 p_source_org_owned IN VARCHAR2,
9 p_caller IN VARCHAR2,
10 x_doc_number OUT NOCOPY VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2);
12
13 PROCEDURE req_numbering_XD
14 (x_prefix IN OUT NOCOPY VARCHAR2
15 ,x_fiscal_year IN OUT NOCOPY NUMBER
16 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
17 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
18 ,x_allowed_range IN OUT NOCOPY VARCHAR2
19 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
20 ,x_min_value IN OUT NOCOPY VARCHAR2
21 ,x_max_value IN OUT NOCOPY VARCHAR2
22 ,x_serial_number IN OUT NOCOPY VARCHAR2
23 ,x_delimiter IN OUT NOCOPY VARCHAR2
24 ,x_document_number IN OUT NOCOPY VARCHAR2
25 ,x_return_status OUT NOCOPY VARCHAR2
26 ,x_errorcode OUT NOCOPY VARCHAR2
27 ,x_msg_count OUT NOCOPY VARCHAR2
28 ,x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31
32 PROCEDURE req_numbering_XDN
33 (x_requisition_header_id IN NUMBER
34 ,x_prefix IN OUT NOCOPY VARCHAR2
35 ,x_fiscal_year IN OUT NOCOPY NUMBER
36 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
37 ,x_serial_number IN OUT NOCOPY VARCHAR2
38 ,x_delimiter IN OUT NOCOPY VARCHAR2
39 ,x_document_number IN OUT NOCOPY VARCHAR2
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_errorcode OUT NOCOPY VARCHAR2
42 ,x_msg_count OUT NOCOPY VARCHAR2
43 ,x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46
47 PROCEDURE req_numbering_XV
48 (x_requisition_header_id IN NUMBER
49 ,x_prefix IN VARCHAR2
50 ,x_fiscal_year IN NUMBER
51 ,x_agency_identifier IN VARCHAR2
52 ,x_serial_number IN VARCHAR2
53 ,x_document_number IN VARCHAR2
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_errorcode OUT NOCOPY VARCHAR2
56 ,x_msg_count OUT NOCOPY VARCHAR2
57 ,x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE req_numbering_XLE
61 (x_prefix IN OUT NOCOPY VARCHAR2
62 ,x_fiscal_year IN OUT NOCOPY NUMBER
63 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
64 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
65 ,x_allowed_range IN OUT NOCOPY VARCHAR2
66 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
67 ,x_min_value IN OUT NOCOPY VARCHAR2
68 ,x_max_value IN OUT NOCOPY VARCHAR2
69 ,x_serial_number IN OUT NOCOPY VARCHAR2
70 ,x_delimiter IN OUT NOCOPY VARCHAR2
71 ,x_document_number IN OUT NOCOPY VARCHAR2
72 ,x_return_status OUT NOCOPY VARCHAR2
73 ,x_errorcode OUT NOCOPY VARCHAR2
74 ,x_msg_count OUT NOCOPY VARCHAR2
75 ,x_msg_data OUT NOCOPY VARCHAR2
76 );
77
78 PROCEDURE req_numbering_XSC
79 (x_requisition_header_id IN NUMBER
80 ,x_prefix IN OUT NOCOPY VARCHAR2
81 ,x_fiscal_year IN OUT NOCOPY NUMBER
82 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
83 ,x_serial_number IN OUT NOCOPY VARCHAR2
84 ,x_delimiter IN OUT NOCOPY VARCHAR2
85 ,x_document_number IN OUT NOCOPY VARCHAR2
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_errorcode OUT NOCOPY VARCHAR2
88 ,x_msg_count OUT NOCOPY VARCHAR2
89 ,x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92
93 ---------------------------------------------------------
94
95 PROCEDURE sol_numbering_XD
96 (x_prefix IN OUT NOCOPY VARCHAR2
97 ,x_fiscal_year IN OUT NOCOPY NUMBER
98 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
99 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
100 ,x_allowed_range IN OUT NOCOPY VARCHAR2
101 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
102 ,x_min_value IN OUT NOCOPY VARCHAR2
103 ,x_max_value IN OUT NOCOPY VARCHAR2
104 ,x_serial_number IN OUT NOCOPY VARCHAR2
105 ,x_delimiter IN OUT NOCOPY VARCHAR2
106 ,x_document_number IN OUT NOCOPY VARCHAR2
107 ,x_return_status OUT NOCOPY VARCHAR2
108 ,x_errorcode OUT NOCOPY VARCHAR2
109 ,x_msg_count OUT NOCOPY VARCHAR2
110 ,x_msg_data OUT NOCOPY VARCHAR2
111 );
112
113
114 PROCEDURE sol_numbering_XDN
115 (x_auction_header_id IN NUMBER
116 ,x_prefix IN OUT NOCOPY VARCHAR2
117 ,x_fiscal_year IN OUT NOCOPY NUMBER
118 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
119 ,x_serial_number IN OUT NOCOPY VARCHAR2
120 ,x_delimiter IN OUT NOCOPY VARCHAR2
121 ,x_document_number IN OUT NOCOPY VARCHAR2
122 ,x_return_status OUT NOCOPY VARCHAR2
123 ,x_errorcode OUT NOCOPY VARCHAR2
124 ,x_msg_count OUT NOCOPY VARCHAR2
125 ,x_msg_data OUT NOCOPY VARCHAR2
126 );
127
128
129 PROCEDURE sol_numbering_XV
130 (x_auction_header_id IN NUMBER
131 ,x_prefix IN VARCHAR2
132 ,x_fiscal_year IN NUMBER
133 ,x_agency_identifier IN VARCHAR2
134 ,x_serial_number IN VARCHAR2
135 ,x_document_number IN VARCHAR2
136 ,x_return_status OUT NOCOPY VARCHAR2
137 ,x_errorcode OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY VARCHAR2
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 PROCEDURE sol_numbering_XLE
143 (x_prefix IN OUT NOCOPY VARCHAR2
144 ,x_fiscal_year IN OUT NOCOPY NUMBER
145 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
146 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
147 ,x_allowed_range IN OUT NOCOPY VARCHAR2
148 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
149 ,x_min_value IN OUT NOCOPY VARCHAR2
150 ,x_max_value IN OUT NOCOPY VARCHAR2
151 ,x_serial_number IN OUT NOCOPY VARCHAR2
152 ,x_delimiter IN OUT NOCOPY VARCHAR2
153 ,x_document_number IN OUT NOCOPY VARCHAR2
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_errorcode OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY VARCHAR2
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160 PROCEDURE sol_numbering_XSC
161 (x_auction_header_id IN NUMBER
162 ,x_prefix IN OUT NOCOPY VARCHAR2
163 ,x_fiscal_year IN OUT NOCOPY NUMBER
164 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
165 ,x_serial_number IN OUT NOCOPY VARCHAR2
166 ,x_delimiter IN OUT NOCOPY VARCHAR2
167 ,x_document_number IN OUT NOCOPY VARCHAR2
168 ,x_return_status OUT NOCOPY VARCHAR2
169 ,x_errorcode OUT NOCOPY VARCHAR2
170 ,x_msg_count OUT NOCOPY VARCHAR2
171 ,x_msg_data OUT NOCOPY VARCHAR2
172 );
173
174
175
176 ---------------------------------------------------------
177
178 PROCEDURE order_numbering_XD
179 (x_prefix IN OUT NOCOPY VARCHAR2
180 ,x_fiscal_year IN OUT NOCOPY NUMBER
181 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
182 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
183 ,x_allowed_range IN OUT NOCOPY VARCHAR2
184 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
185 ,x_min_value IN OUT NOCOPY VARCHAR2
186 ,x_max_value IN OUT NOCOPY VARCHAR2
187 ,x_serial_number IN OUT NOCOPY VARCHAR2
188 ,x_delimiter IN OUT NOCOPY VARCHAR2
189 ,x_document_number IN OUT NOCOPY VARCHAR2
190 ,x_return_status OUT NOCOPY VARCHAR2
191 ,x_errorcode OUT NOCOPY VARCHAR2
192 ,x_msg_count OUT NOCOPY VARCHAR2
193 ,x_msg_data OUT NOCOPY VARCHAR2
194 );
195
196
197 PROCEDURE order_numbering_XDN
198 (x_order_header_id IN NUMBER
199 ,x_prefix IN OUT NOCOPY VARCHAR2
200 ,x_fiscal_year IN OUT NOCOPY NUMBER
201 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
202 ,x_serial_number IN OUT NOCOPY VARCHAR2
203 ,x_delimiter IN OUT NOCOPY VARCHAR2
204 ,x_document_number IN OUT NOCOPY VARCHAR2
205 ,x_return_status OUT NOCOPY VARCHAR2
206 ,x_errorcode OUT NOCOPY VARCHAR2
207 ,x_msg_count OUT NOCOPY VARCHAR2
208 ,x_msg_data OUT NOCOPY VARCHAR2
209 );
210
211
212 PROCEDURE order_numbering_XV
213 (x_order_header_id IN NUMBER
214 ,x_prefix IN VARCHAR2
215 ,x_fiscal_year IN NUMBER
216 ,x_agency_identifier IN VARCHAR2
217 ,x_serial_number IN VARCHAR2
218 ,x_document_number IN VARCHAR2
219 ,x_return_status OUT NOCOPY VARCHAR2
220 ,x_errorcode OUT NOCOPY VARCHAR2
221 ,x_msg_count OUT NOCOPY VARCHAR2
222 ,x_msg_data OUT NOCOPY VARCHAR2
223 );
224
225 PROCEDURE order_numbering_XLE
226 (x_prefix IN OUT NOCOPY VARCHAR2
227 ,x_fiscal_year IN OUT NOCOPY NUMBER
228 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
229 ,x_agency_identifier_hidden IN OUT NOCOPY VARCHAR2
230 ,x_allowed_range IN OUT NOCOPY VARCHAR2
231 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
232 ,x_min_value IN OUT NOCOPY VARCHAR2
233 ,x_max_value IN OUT NOCOPY VARCHAR2
234 ,x_serial_number IN OUT NOCOPY VARCHAR2
235 ,x_delimiter IN OUT NOCOPY VARCHAR2
236 ,x_document_number IN OUT NOCOPY VARCHAR2
237 ,x_return_status OUT NOCOPY VARCHAR2
238 ,x_errorcode OUT NOCOPY VARCHAR2
239 ,x_msg_count OUT NOCOPY VARCHAR2
240 ,x_msg_data OUT NOCOPY VARCHAR2
241 );
242
243 PROCEDURE order_numbering_XSC
244 (x_order_header_id IN NUMBER
245 ,x_prefix IN OUT NOCOPY VARCHAR2
246 ,x_fiscal_year IN OUT NOCOPY NUMBER
247 ,x_agency_identifier IN OUT NOCOPY VARCHAR2
248 ,x_serial_number IN OUT NOCOPY VARCHAR2
249 ,x_delimiter IN OUT NOCOPY VARCHAR2
250 ,x_document_number IN OUT NOCOPY VARCHAR2
251 ,x_return_status OUT NOCOPY VARCHAR2
252 ,x_errorcode OUT NOCOPY VARCHAR2
253 ,x_msg_count OUT NOCOPY VARCHAR2
254 ,x_msg_data OUT NOCOPY VARCHAR2
255 );
256
257
258 PROCEDURE order_mod_numbering_XD
259 (p_po_header_id IN NUMBER
260 ,p_draft_id IN NUMBER
261 ,x_base_doc_number IN OUT NOCOPY varchar2
262 ,x_serial_number IN OUT NOCOPY VARCHAR2
263 ,x_delimiter IN OUT NOCOPY VARCHAR2
264 ,x_document_number IN OUT NOCOPY VARCHAR2
265 ,x_return_status OUT NOCOPY VARCHAR2
266 ,x_errorcode OUT NOCOPY VARCHAR2
267 ,x_msg_count OUT NOCOPY VARCHAR2
268 ,x_msg_data OUT NOCOPY VARCHAR2
269 );
270
271
272
273 PROCEDURE order_mod_numbering_XV
274 (p_po_header_id IN NUMBER
275 ,p_draft_id IN NUMBER
276 ,x_base_doc_number IN OUT NOCOPY varchar2
277 ,x_serial_number IN OUT NOCOPY VARCHAR2
278 ,x_delimiter IN OUT NOCOPY VARCHAR2
279 ,x_document_number IN OUT NOCOPY VARCHAR2
280 ,x_return_status OUT NOCOPY VARCHAR2
281 ,x_errorcode OUT NOCOPY VARCHAR2
282 ,x_msg_count OUT NOCOPY VARCHAR2
283 ,x_msg_data OUT NOCOPY VARCHAR2
284 );
285
286
287 PROCEDURE sol_amend_numbering_XD
288 (p_auction_header_id IN NUMBER
289 ,p_base_auction_header_id IN NUMBER
290 ,x_base_doc_number IN OUT NOCOPY varchar2
291 ,x_serial_number IN OUT NOCOPY VARCHAR2
292 ,x_delimiter IN OUT NOCOPY VARCHAR2
293 ,x_document_number IN OUT NOCOPY VARCHAR2
294 ,x_return_status OUT NOCOPY VARCHAR2
295 ,x_errorcode OUT NOCOPY VARCHAR2
296 ,x_msg_count OUT NOCOPY VARCHAR2
297 ,x_msg_data OUT NOCOPY VARCHAR2
298 );
299
300
301 PROCEDURE sol_amend_numbering_XV
302 (p_auction_header_id IN NUMBER
303 ,x_base_doc_number IN OUT NOCOPY varchar2
304 ,x_serial_number IN OUT NOCOPY VARCHAR2
305 ,x_delimiter IN OUT NOCOPY VARCHAR2
306 ,x_document_number IN OUT NOCOPY VARCHAR2
307 ,x_return_status OUT NOCOPY VARCHAR2
308 ,x_errorcode OUT NOCOPY VARCHAR2
309 ,x_msg_count OUT NOCOPY VARCHAR2
310 ,x_msg_data OUT NOCOPY VARCHAR2
311 );
312
313
314 PROCEDURE dod_sol_numbering_XD
315 (x_dodaac IN OUT NOCOPY VARCHAR2
316 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
317 ,x_instrument_type IN OUT NOCOPY VARCHAR2
318 ,x_allowed_range IN OUT NOCOPY VARCHAR2
319 ,x_min_value IN OUT NOCOPY VARCHAR2
320 ,x_max_value IN OUT NOCOPY VARCHAR2
321 ,x_serial_number IN OUT NOCOPY VARCHAR2
322 ,x_delimiter IN OUT NOCOPY VARCHAR2
323 ,x_document_number IN OUT NOCOPY VARCHAR2
324 ,x_dodaac_hidden IN OUT NOCOPY VARCHAR2
325 ,x_instrument_type_hidden IN OUT NOCOPY VARCHAR2
326 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
327 ,x_return_status OUT NOCOPY VARCHAR2
328 ,x_errorcode OUT NOCOPY VARCHAR2
329 ,x_msg_count OUT NOCOPY VARCHAR2
330 ,x_msg_data OUT NOCOPY VARCHAR2
331 );
332
333
334
335 PROCEDURE dod_sol_numbering_XDN
336 (x_auction_header_id IN NUMBER
337 ,x_dodaac IN OUT NOCOPY VARCHAR2
338 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
339 ,x_instrument_type IN OUT NOCOPY VARCHAR2
340 ,x_serial_number IN OUT NOCOPY VARCHAR2
341 ,x_delimiter IN OUT NOCOPY VARCHAR2
342 ,x_document_number IN OUT NOCOPY VARCHAR2
343 ,x_return_status OUT NOCOPY VARCHAR2
344 ,x_errorcode OUT NOCOPY VARCHAR2
345 ,x_msg_count OUT NOCOPY VARCHAR2
346 ,x_msg_data OUT NOCOPY VARCHAR2
347 );
348
349
350 PROCEDURE dod_sol_numbering_XV
351 (x_auction_header_id IN NUMBER
352 ,x_dodaac IN VARCHAR2
353 ,x_fiscal_year IN VARCHAR2
354 ,x_instrument_type IN VARCHAR2
355 ,x_serial_number IN VARCHAR2
356 ,x_document_number IN VARCHAR2
357 ,x_return_status OUT NOCOPY VARCHAR2
358 ,x_errorcode OUT NOCOPY VARCHAR2
359 ,x_msg_count OUT NOCOPY VARCHAR2
360 ,x_msg_data OUT NOCOPY VARCHAR2
361 );
362
363
364
365 PROCEDURE dod_sol_numbering_XLE
366 (x_dodaac IN OUT NOCOPY VARCHAR2
367 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
368 ,x_instrument_type IN OUT NOCOPY VARCHAR2
369 ,x_allowed_range IN OUT NOCOPY VARCHAR2
370 ,x_min_value IN OUT NOCOPY VARCHAR2
371 ,x_max_value IN OUT NOCOPY VARCHAR2
372 ,x_serial_number IN OUT NOCOPY VARCHAR2
373 ,x_delimiter IN OUT NOCOPY VARCHAR2
374 ,x_document_number IN OUT NOCOPY VARCHAR2
375 ,x_dodaac_hidden IN OUT NOCOPY VARCHAR2
376 ,x_instrument_type_hidden IN OUT NOCOPY VARCHAR2
380 ,x_msg_count OUT NOCOPY VARCHAR2
377 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
378 ,x_return_status OUT NOCOPY VARCHAR2
379 ,x_errorcode OUT NOCOPY VARCHAR2
381 ,x_msg_data OUT NOCOPY VARCHAR2
382 );
383
384
385 PROCEDURE dod_sol_numbering_XSC
386 (x_auction_header_id IN NUMBER
387 ,x_dodaac IN VARCHAR2
388 ,x_fiscal_year IN VARCHAR2
389 ,x_instrument_type IN VARCHAR2
390 ,x_serial_number IN VARCHAR2
391 ,x_document_number IN VARCHAR2
392 ,x_return_status OUT NOCOPY VARCHAR2
393 ,x_errorcode OUT NOCOPY VARCHAR2
394 ,x_msg_count OUT NOCOPY VARCHAR2
395 ,x_msg_data OUT NOCOPY VARCHAR2
396 );
397
398
399
400 PROCEDURE dod_award_numbering_XD
401 (x_dodaac IN OUT NOCOPY VARCHAR2
402 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
403 ,x_instrument_type IN OUT NOCOPY VARCHAR2
404 ,x_allowed_range IN OUT NOCOPY VARCHAR2
405 ,x_min_value IN OUT NOCOPY VARCHAR2
406 ,x_max_value IN OUT NOCOPY VARCHAR2
407 ,x_serial_number IN OUT NOCOPY VARCHAR2
408 ,x_delimiter IN OUT NOCOPY VARCHAR2
409 ,x_document_number IN OUT NOCOPY VARCHAR2
410 ,x_dodaac_hidden IN OUT NOCOPY VARCHAR2
411 ,x_instrument_type_hidden IN OUT NOCOPY VARCHAR2
412 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
413 ,x_return_status OUT NOCOPY VARCHAR2
414 ,x_errorcode OUT NOCOPY VARCHAR2
415 ,x_msg_count OUT NOCOPY VARCHAR2
416 ,x_msg_data OUT NOCOPY VARCHAR2
417 );
418
419
420
421 PROCEDURE dod_award_numbering_XDN
422 (x_order_header_id IN NUMBER
423 ,x_dodaac IN OUT NOCOPY VARCHAR2
424 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
425 ,x_instrument_type IN OUT NOCOPY VARCHAR2
426 ,x_serial_number IN OUT NOCOPY VARCHAR2
427 ,x_delimiter IN OUT NOCOPY VARCHAR2
428 ,x_document_number IN OUT NOCOPY VARCHAR2
429 ,x_return_status OUT NOCOPY VARCHAR2
430 ,x_errorcode OUT NOCOPY VARCHAR2
431 ,x_msg_count OUT NOCOPY VARCHAR2
432 ,x_msg_data OUT NOCOPY VARCHAR2
433 );
434
435
436 PROCEDURE dod_award_numbering_XV
437 (x_order_header_id IN NUMBER
438 ,x_dodaac IN VARCHAR2
439 ,x_fiscal_year IN VARCHAR2
440 ,x_instrument_type IN VARCHAR2
441 ,x_serial_number IN VARCHAR2
442 ,x_document_number IN VARCHAR2
443 ,x_return_status OUT NOCOPY VARCHAR2
444 ,x_errorcode OUT NOCOPY VARCHAR2
445 ,x_msg_count OUT NOCOPY VARCHAR2
446 ,x_msg_data OUT NOCOPY VARCHAR2
447 );
448
449
450
451 PROCEDURE dod_award_numbering_XLE
452 (x_dodaac IN OUT NOCOPY VARCHAR2
453 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
454 ,x_instrument_type IN OUT NOCOPY VARCHAR2
455 ,x_allowed_range IN OUT NOCOPY VARCHAR2
456 ,x_min_value IN OUT NOCOPY VARCHAR2
457 ,x_max_value IN OUT NOCOPY VARCHAR2
458 ,x_serial_number IN OUT NOCOPY VARCHAR2
459 ,x_delimiter IN OUT NOCOPY VARCHAR2
460 ,x_document_number IN OUT NOCOPY VARCHAR2
461 ,x_dodaac_hidden IN OUT NOCOPY VARCHAR2
462 ,x_instrument_type_hidden IN OUT NOCOPY VARCHAR2
463 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
464 ,x_return_status OUT NOCOPY VARCHAR2
465 ,x_errorcode OUT NOCOPY VARCHAR2
466 ,x_msg_count OUT NOCOPY VARCHAR2
467 ,x_msg_data OUT NOCOPY VARCHAR2
468 );
469
470
471 PROCEDURE dod_award_numbering_XSC
472 (x_order_header_id IN NUMBER
473 ,x_dodaac IN VARCHAR2
474 ,x_fiscal_year IN VARCHAR2
475 ,x_instrument_type IN VARCHAR2
476 ,x_serial_number IN VARCHAR2
477 ,x_document_number IN VARCHAR2
478 ,x_return_status OUT NOCOPY VARCHAR2
479 ,x_errorcode OUT NOCOPY VARCHAR2
480 ,x_msg_count OUT NOCOPY VARCHAR2
481 ,x_msg_data OUT NOCOPY VARCHAR2
482 );
483
484 PROCEDURE dod_award_numbering_XDA
485 (x_order_header_id IN NUMBER
486 ,x_dodaac IN OUT NOCOPY VARCHAR2
487 ,x_fiscal_year IN OUT NOCOPY VARCHAR2
488 ,x_instrument_type IN OUT NOCOPY VARCHAR2
489 ,x_serial_number IN OUT NOCOPY VARCHAR2
490 ,x_delimiter IN OUT NOCOPY VARCHAR2
491 ,x_document_number IN OUT NOCOPY VARCHAR2
492 ,x_delimiter_ext OUT NOCOPY VARCHAR2
493 ,x_return_status OUT NOCOPY VARCHAR2
494 ,x_errorcode OUT NOCOPY VARCHAR2
495 ,x_msg_count OUT NOCOPY VARCHAR2
496 ,x_msg_data OUT NOCOPY VARCHAR2
497 );
498
499 PROCEDURE dod_order_numbering_ow_XD
500 (x_source_doc_number IN OUT NOCOPY VARCHAR2
501 ,x_allowed_range IN OUT NOCOPY VARCHAR2
502 ,x_min_value IN OUT NOCOPY VARCHAR2
503 ,x_max_value IN OUT NOCOPY VARCHAR2
504 ,x_serial_number IN OUT NOCOPY VARCHAR2
505 ,x_delimiter IN OUT NOCOPY VARCHAR2
506 ,x_document_number IN OUT NOCOPY VARCHAR2
507 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
508 ,p_source_doc_number IN VARCHAR2
509 ,x_return_status OUT NOCOPY VARCHAR2
510 ,x_errorcode OUT NOCOPY VARCHAR2
511 ,x_msg_count OUT NOCOPY VARCHAR2
512 ,x_msg_data OUT NOCOPY VARCHAR2
513 );
514
515
516 PROCEDURE dod_order_numbering_ow_XV
517 (x_order_header_id IN NUMBER
518 ,x_source_doc_number IN VARCHAR2
519 ,x_serial_number IN VARCHAR2
523 ,x_msg_count OUT NOCOPY VARCHAR2
520 ,x_document_number IN VARCHAR2
521 ,x_return_status OUT NOCOPY VARCHAR2
522 ,x_errorcode OUT NOCOPY VARCHAR2
524 ,x_msg_data OUT NOCOPY VARCHAR2
525 );
526
527
528 PROCEDURE dod_order_numbering_ow_XDN
529 (x_order_header_id IN NUMBER
530 ,x_source_doc_number IN OUT NOCOPY VARCHAR2
531 ,x_allowed_range IN OUT NOCOPY VARCHAR2
532 ,x_min_value IN OUT NOCOPY VARCHAR2
533 ,x_max_value IN OUT NOCOPY VARCHAR2
534 ,x_serial_number IN OUT NOCOPY VARCHAR2
535 ,x_delimiter IN OUT NOCOPY VARCHAR2
536 ,x_document_number IN OUT NOCOPY VARCHAR2
537 ,x_return_status OUT NOCOPY VARCHAR2
538 ,x_errorcode OUT NOCOPY VARCHAR2
539 ,x_msg_count OUT NOCOPY VARCHAR2
540 ,x_msg_data OUT NOCOPY VARCHAR2
541 );
542
543
544 PROCEDURE dod_order_numbering_ow_XLE
545 (x_source_doc_number IN OUT NOCOPY VARCHAR2
546 ,x_allowed_range IN OUT NOCOPY VARCHAR2
547 ,x_min_value IN OUT NOCOPY VARCHAR2
548 ,x_max_value IN OUT NOCOPY VARCHAR2
549 ,x_serial_number IN OUT NOCOPY VARCHAR2
550 ,x_delimiter IN OUT NOCOPY VARCHAR2
551 ,x_document_number IN OUT NOCOPY VARCHAR2
552 ,x_allowed_range_hidden IN OUT NOCOPY VARCHAR2
553 ,x_return_status OUT NOCOPY VARCHAR2
554 ,x_errorcode OUT NOCOPY VARCHAR2
555 ,x_msg_count OUT NOCOPY VARCHAR2
556 ,x_msg_data OUT NOCOPY VARCHAR2
557 );
558
559 PROCEDURE dod_order_numbering_ow_XSC
560 (x_order_header_id IN NUMBER
561 ,x_source_doc_number IN VARCHAR2
562 ,x_serial_number IN VARCHAR2
563 ,x_document_number IN VARCHAR2
564 ,x_return_status OUT NOCOPY VARCHAR2
565 ,x_errorcode OUT NOCOPY VARCHAR2
566 ,x_msg_count OUT NOCOPY VARCHAR2
567 ,x_msg_data OUT NOCOPY VARCHAR2
568 );
569
570 PROCEDURE dod_order_numbering_ow_XDA
571 (x_order_header_id IN NUMBER
572 ,x_source_doc_number IN OUT NOCOPY VARCHAR2
573 ,x_serial_number IN OUT NOCOPY VARCHAR2
574 ,x_delimiter IN OUT NOCOPY VARCHAR2
575 ,x_document_number IN OUT NOCOPY VARCHAR2
576 ,x_delimiter_ext OUT NOCOPY VARCHAR2
577 ,x_return_status OUT NOCOPY VARCHAR2
578 ,x_errorcode OUT NOCOPY VARCHAR2
579 ,x_msg_count OUT NOCOPY VARCHAR2
580 ,x_msg_data OUT NOCOPY VARCHAR2
581 );
582
583 PROCEDURE dod_order_numbering_now_XD
584 (x_source_doc_number IN OUT NOCOPY VARCHAR2
585 ,x_call_order_number IN OUT NOCOPY VARCHAR2
586 ,x_serial_number IN OUT NOCOPY VARCHAR2
587 ,x_delimiter IN OUT NOCOPY VARCHAR2
588 ,x_document_number IN OUT NOCOPY VARCHAR2
589 ,p_source_doc_number IN VARCHAR2
590 ,x_return_status OUT NOCOPY VARCHAR2
591 ,x_errorcode OUT NOCOPY VARCHAR2
592 ,x_msg_count OUT NOCOPY VARCHAR2
593 ,x_msg_data OUT NOCOPY VARCHAR2
594 );
595
596 PROCEDURE dod_order_numbering_now_XV
597 (x_order_header_id IN NUMBER
598 ,x_source_doc_number IN VARCHAR2
599 ,x_call_order_number IN VARCHAR2
600 ,x_serial_number IN VARCHAR2
601 ,x_document_number IN VARCHAR2
602 ,x_return_status OUT NOCOPY VARCHAR2
603 ,x_errorcode OUT NOCOPY VARCHAR2
604 ,x_msg_count OUT NOCOPY VARCHAR2
605 ,x_msg_data OUT NOCOPY VARCHAR2
606 );
607
608
609 PROCEDURE dod_order_numbering_now_XDN
610 (x_order_header_id IN NUMBER
611 ,x_source_doc_number IN OUT NOCOPY VARCHAR2
612 ,x_call_order_number IN OUT NOCOPY VARCHAR2
613 ,x_serial_number IN OUT NOCOPY VARCHAR2
614 ,x_delimiter IN OUT NOCOPY VARCHAR2
615 ,x_document_number IN OUT NOCOPY VARCHAR2
616 ,x_return_status OUT NOCOPY VARCHAR2
617 ,x_errorcode OUT NOCOPY VARCHAR2
618 ,x_msg_count OUT NOCOPY VARCHAR2
619 ,x_msg_data OUT NOCOPY VARCHAR2
620 );
621
622
623 PROCEDURE dod_order_numbering_now_XSC
624 (x_order_header_id IN NUMBER
625 ,x_source_doc_number IN VARCHAR2
626 ,x_call_order_number IN VARCHAR2
627 ,x_serial_number IN VARCHAR2
628 ,x_document_number IN VARCHAR2
629 ,x_return_status OUT NOCOPY VARCHAR2
630 ,x_errorcode OUT NOCOPY VARCHAR2
631 ,x_msg_count OUT NOCOPY VARCHAR2
632 ,x_msg_data OUT NOCOPY VARCHAR2
633 );
634
635 PROCEDURE dod_order_numbering_now_XDA
636 (x_order_header_id IN NUMBER
637 ,x_source_doc_number IN OUT NOCOPY VARCHAR2
638 ,x_call_order_number IN OUT NOCOPY VARCHAR2
639 ,x_serial_number IN OUT NOCOPY VARCHAR2
640 ,x_delimiter IN OUT NOCOPY VARCHAR2
641 ,x_document_number IN OUT NOCOPY VARCHAR2
642 ,x_delimiter_ext OUT NOCOPY VARCHAR2
643 ,x_return_status OUT NOCOPY VARCHAR2
644 ,x_errorcode OUT NOCOPY VARCHAR2
645 ,x_msg_count OUT NOCOPY VARCHAR2
646 ,x_msg_data OUT NOCOPY VARCHAR2
647 );
648
649
650 PROCEDURE dod_sol_amd_XD
651 (p_auction_header_id IN NUMBER
652 ,p_base_auction_header_id IN NUMBER
653 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
654 ,x_control_char IN OUT NOCOPY varchar2
655 ,x_serial_number IN OUT NOCOPY VARCHAR2
656 ,x_delimiter IN OUT NOCOPY VARCHAR2
657 ,x_document_number IN OUT NOCOPY VARCHAR2
658 ,x_return_status OUT NOCOPY VARCHAR2
659 ,x_errorcode OUT NOCOPY VARCHAR2
660 ,x_msg_count OUT NOCOPY VARCHAR2
661 ,x_msg_data OUT NOCOPY VARCHAR2
665 PROCEDURE dod_sol_amd_XV
662 );
663
664
666 (p_auction_header_id IN NUMBER
667 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
668 ,x_control_char IN OUT NOCOPY VARCHAR2
669 ,x_serial_number IN OUT NOCOPY VARCHAR2
670 ,x_delimiter IN OUT NOCOPY VARCHAR2
671 ,x_document_number IN OUT NOCOPY VARCHAR2
672 ,x_return_status OUT NOCOPY VARCHAR2
673 ,x_errorcode OUT NOCOPY VARCHAR2
674 ,x_msg_count OUT NOCOPY VARCHAR2
675 ,x_msg_data OUT NOCOPY VARCHAR2
676 );
677
678 PROCEDURE dod_sol_amd_XDN
679 (p_auction_header_id IN NUMBER
680 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
681 ,x_control_char IN OUT NOCOPY VARCHAR2
682 ,x_serial_number IN OUT NOCOPY VARCHAR2
683 ,x_delimiter IN OUT NOCOPY VARCHAR2
684 ,x_document_number IN OUT NOCOPY VARCHAR2
685 ,x_return_status OUT NOCOPY VARCHAR2
686 ,x_errorcode OUT NOCOPY VARCHAR2
687 ,x_msg_count OUT NOCOPY VARCHAR2
688 ,x_msg_data OUT NOCOPY VARCHAR2
689 );
690
691
692
693 PROCEDURE dod_ord_mod_XD
694 (p_po_header_id IN NUMBER
695 ,p_draft_id IN NUMBER
696 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
697 ,x_control_char IN OUT NOCOPY VARCHAR2
698 ,x_modif_type IN OUT NOCOPY VARCHAR2
699 ,x_serial_number IN OUT NOCOPY VARCHAR2
700 ,x_delimiter IN OUT NOCOPY VARCHAR2
701 ,x_document_number IN OUT NOCOPY VARCHAR2
702 ,x_modif_type_h IN OUT NOCOPY VARCHAR2
703 ,x_return_status OUT NOCOPY VARCHAR2
704 ,x_errorcode OUT NOCOPY VARCHAR2
705 ,x_msg_count OUT NOCOPY VARCHAR2
706 ,x_msg_data OUT NOCOPY VARCHAR2
707 );
708
709
710 PROCEDURE dod_ord_mod_XV
711 (p_po_header_id IN NUMBER
712 ,p_draft_id IN NUMBER
713 ,x_base_doc_number IN OUT NOCOPY varchar2
714 ,x_control_char IN OUT NOCOPY VARCHAR2
715 ,x_serial_number IN OUT NOCOPY VARCHAR2
716 ,x_delimiter IN OUT NOCOPY VARCHAR2
717 ,x_document_number IN OUT NOCOPY VARCHAR2
718 ,x_return_status OUT NOCOPY VARCHAR2
719 ,x_errorcode OUT NOCOPY VARCHAR2
720 ,x_msg_count OUT NOCOPY VARCHAR2
721 ,x_msg_data OUT NOCOPY VARCHAR2
722 );
723
724
725 PROCEDURE dod_ord_mod_XLE
726 (p_po_header_id IN NUMBER
727 ,p_draft_id IN NUMBER
728 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
729 ,x_control_char IN OUT NOCOPY VARCHAR2
730 ,x_modif_type IN OUT NOCOPY VARCHAR2
731 ,x_serial_number IN OUT NOCOPY VARCHAR2
732 ,x_delimiter IN OUT NOCOPY VARCHAR2
733 ,x_document_number IN OUT NOCOPY VARCHAR2
734 ,x_modif_type_h IN OUT NOCOPY VARCHAR2
735 ,x_return_status OUT NOCOPY VARCHAR2
736 ,x_errorcode OUT NOCOPY VARCHAR2
737 ,x_msg_count OUT NOCOPY VARCHAR2
738 ,x_msg_data OUT NOCOPY VARCHAR2
739 );
740
741 PROCEDURE dod_ord_mod_XDN
742 (p_po_header_id IN NUMBER
743 ,p_draft_id IN NUMBER
744 ,x_base_doc_number IN OUT NOCOPY varchar2
745 ,x_control_char IN OUT NOCOPY VARCHAR2
746 ,x_serial_number IN OUT NOCOPY VARCHAR2
747 ,x_delimiter IN OUT NOCOPY VARCHAR2
748 ,x_document_number IN OUT NOCOPY VARCHAR2
749 ,x_return_status OUT NOCOPY VARCHAR2
750 ,x_errorcode OUT NOCOPY VARCHAR2
751 ,x_msg_count OUT NOCOPY VARCHAR2
752 ,x_msg_data OUT NOCOPY VARCHAR2
753 );
754
755
756 PROCEDURE dod_ord_mod_XPA
757 (p_po_header_id IN NUMBER
758 ,p_draft_id IN NUMBER
759 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
760 ,x_control_char IN OUT NOCOPY VARCHAR2
761 ,x_modif_type IN OUT NOCOPY VARCHAR2
762 ,x_serial_number IN OUT NOCOPY VARCHAR2
763 ,x_delimiter IN OUT NOCOPY VARCHAR2
764 ,x_document_number IN OUT NOCOPY VARCHAR2
765 ,x_modif_type_h IN OUT NOCOPY VARCHAR2
766 ,x_return_status OUT NOCOPY VARCHAR2
767 ,x_errorcode OUT NOCOPY VARCHAR2
768 ,x_msg_count OUT NOCOPY VARCHAR2
769 ,x_msg_data OUT NOCOPY VARCHAR2
770 );
771
772 PROCEDURE dod_ord_mod_XDA
773 (p_po_header_id IN NUMBER
774 ,p_draft_id IN NUMBER
775 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
776 ,x_control_char IN OUT NOCOPY VARCHAR2
777 ,x_modif_type IN OUT NOCOPY VARCHAR2
778 ,x_serial_number IN OUT NOCOPY VARCHAR2
779 ,x_delimiter IN OUT NOCOPY VARCHAR2
780 ,x_document_number IN OUT NOCOPY VARCHAR2
781 ,x_delimiter_ext OUT NOCOPY VARCHAR2
782 ,x_return_status OUT NOCOPY VARCHAR2
783 ,x_errorcode OUT NOCOPY VARCHAR2
784 ,x_msg_count OUT NOCOPY VARCHAR2
785 ,x_msg_data OUT NOCOPY VARCHAR2
786 );
787
788 PROCEDURE dod_awd_mod_XD
789 (p_po_header_id IN NUMBER
790 ,p_draft_id IN NUMBER
791 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
792 ,x_control_char IN OUT NOCOPY VARCHAR2
793 ,x_modif_type IN OUT NOCOPY VARCHAR2
794 ,x_modif_code IN OUT NOCOPY VARCHAR2
795 ,x_serial_number IN OUT NOCOPY VARCHAR2
796 ,x_delimiter IN OUT NOCOPY VARCHAR2
797 ,x_document_number IN OUT NOCOPY VARCHAR2
798 ,x_return_status OUT NOCOPY VARCHAR2
799 ,x_errorcode OUT NOCOPY VARCHAR2
800 ,x_msg_count OUT NOCOPY VARCHAR2
801 ,x_msg_data OUT NOCOPY VARCHAR2
802 );
803
804
805 PROCEDURE dod_awd_mod_XV
806 (p_po_header_id IN NUMBER
810 ,x_serial_number IN OUT NOCOPY VARCHAR2
807 ,p_draft_id IN NUMBER
808 ,x_base_doc_number IN OUT NOCOPY varchar2
809 ,x_control_char IN OUT NOCOPY VARCHAR2
811 ,x_delimiter IN OUT NOCOPY VARCHAR2
812 ,x_document_number IN OUT NOCOPY VARCHAR2
813 ,x_return_status OUT NOCOPY VARCHAR2
814 ,x_errorcode OUT NOCOPY VARCHAR2
815 ,x_msg_count OUT NOCOPY VARCHAR2
816 ,x_msg_data OUT NOCOPY VARCHAR2
817 );
818
819 PROCEDURE dod_awd_mod_XDN
820 (p_po_header_id IN NUMBER
821 ,p_draft_id IN NUMBER
822 ,x_base_doc_number IN OUT NOCOPY varchar2
823 ,x_control_char IN OUT NOCOPY VARCHAR2
824 ,x_modif_type IN OUT NOCOPY VARCHAR2
825 ,x_modif_code IN OUT NOCOPY VARCHAR2
826 ,x_serial_number IN OUT NOCOPY VARCHAR2
827 ,x_delimiter IN OUT NOCOPY VARCHAR2
828 ,x_document_number IN OUT NOCOPY VARCHAR2
829 ,x_return_status OUT NOCOPY VARCHAR2
830 ,x_errorcode OUT NOCOPY VARCHAR2
831 ,x_msg_count OUT NOCOPY VARCHAR2
832 ,x_msg_data OUT NOCOPY VARCHAR2
833 );
834
835 PROCEDURE dod_awd_mod_XPA
836 (p_po_header_id IN NUMBER
837 ,p_draft_id IN NUMBER
838 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
839 ,x_control_char IN OUT NOCOPY VARCHAR2
840 ,x_modif_type IN OUT NOCOPY VARCHAR2
841 ,x_modif_code IN OUT NOCOPY VARCHAR2
842 ,x_serial_number IN OUT NOCOPY VARCHAR2
843 ,x_delimiter IN OUT NOCOPY VARCHAR2
844 ,x_document_number IN OUT NOCOPY VARCHAR2
845 ,x_return_status OUT NOCOPY VARCHAR2
846 ,x_errorcode OUT NOCOPY VARCHAR2
847 ,x_msg_count OUT NOCOPY VARCHAR2
848 ,x_msg_data OUT NOCOPY VARCHAR2
849 ,x_appr_ser_num IN OUT NOCOPY VARCHAR2
850 );
851
852 PROCEDURE dod_awd_mod_XDA
853 (p_po_header_id IN NUMBER
854 ,p_draft_id IN NUMBER
855 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
856 ,x_control_char IN OUT NOCOPY VARCHAR2
857 ,x_modif_type IN OUT NOCOPY VARCHAR2
858 ,x_modif_code IN OUT NOCOPY VARCHAR2
859 ,x_serial_number IN OUT NOCOPY VARCHAR2
860 ,x_delimiter IN OUT NOCOPY VARCHAR2
861 ,x_document_number IN OUT NOCOPY VARCHAR2
862 ,x_delimiter_ext OUT NOCOPY VARCHAR2
863 ,x_return_status OUT NOCOPY VARCHAR2
864 ,x_errorcode OUT NOCOPY VARCHAR2
865 ,x_msg_count OUT NOCOPY VARCHAR2
866 ,x_msg_data OUT NOCOPY VARCHAR2
867 );
868
869
870 PROCEDURE process_dod_awd_mod_doc_num
871 (
872 p_po_header_id IN NUMBER,
873 p_po_draft_id IN NUMBER,
874 p_uda_template_id IN NUMBER,
875 p_ag_type IN varchar2
876 );
877
878 FUNCTION get_owned_by_issuing_org(p_idv_number IN NUMBER) RETURN VARCHAR2;
879
880 FUNCTION get_delimiter_for_doc(p_po_header_id IN NUMBER,
881 p_draft_id IN NUMBER
882 ) RETURN VARCHAR2;
883 --<PAR Project>
884 PROCEDURE awd_par_XD
885 (p_po_header_id IN NUMBER
886 ,p_draft_id IN NUMBER
887 ,x_base_doc_number IN OUT NOCOPY VARCHAR2
888 ,x_serial_number IN OUT NOCOPY VARCHAR2
889 ,x_delimiter IN OUT NOCOPY VARCHAR2
890 ,x_document_number IN OUT NOCOPY VARCHAR2
891 ,x_document_type IN OUT NOCOPY VARCHAR2
892 ,x_owning_org IN OUT NOCOPY VARCHAR2
893 ,x_doc_sub_type IN OUT NOCOPY VARCHAR2
894 ,x_source_doc_number IN OUT NOCOPY VARCHAR2
895 ,x_style_id IN OUT NOCOPY NUMBER
896 ,x_org_id IN OUT NOCOPY NUMBER
897 ,x_return_status OUT NOCOPY VARCHAR2
898 ,x_errorcode OUT NOCOPY VARCHAR2
899 ,x_msg_count OUT NOCOPY VARCHAR2
900 ,x_msg_data OUT NOCOPY VARCHAR2
901 );
902
903 --Mod Commercialization
904 FUNCTION default_mod_number(p_document_id IN NUMBER)
905 RETURN VARCHAR2;
906
907 --<Bug 15835524>
908 PROCEDURE sync_doc_num_change_to_bids
909 ( p_document_id IN NUMBER,
910 p_clm_document_number IN VARCHAR2
911 );
912
913 --Start of Comments
914
915 --This global variable G_PO_VALIDATION_EVENT_TYPE is used to find the po validation event type .
916
917 --In the po validation action methods ,based on this event type the validation of the serial number is performed.
918
919 --The default value is 'SAVE'.
920
921 --In po XDN procedures, the event type is set to 'XDN' and after validation it is reset to 'SAVE'.
922
923 --In DEFAULT_DOC_NUMBER_UDA procedure,the event type is set to 'DEFAULT_DOC' and after defaulting it is reset to 'SAVE'
924
925 --End of Comments
926
927 G_PO_VALIDATION_EVENT_TYPE VARCHAR2(50):= 'SAVE' ;
928
929 END PO_DOC_NUMBERING_PKG;