5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;
226: , p6_a30 out nocopy DATE
227: , p6_a31 out nocopy NUMBER
228: , p5_a0 NUMBER := 0-1962.0724
229: , p5_a1 NUMBER := 0-1962.0724
230: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
227: , p6_a31 out nocopy NUMBER
228: , p5_a0 NUMBER := 0-1962.0724
229: , p5_a1 NUMBER := 0-1962.0724
230: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a7 NUMBER := 0-1962.0724
229: , p5_a1 NUMBER := 0-1962.0724
230: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a7 NUMBER := 0-1962.0724
236: , p5_a8 NUMBER := 0-1962.0724
237: , p5_a9 NUMBER := 0-1962.0724
230: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
231: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a7 NUMBER := 0-1962.0724
236: , p5_a8 NUMBER := 0-1962.0724
237: , p5_a9 NUMBER := 0-1962.0724
238: , p5_a10 DATE := fnd_api.g_miss_date
234: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a7 NUMBER := 0-1962.0724
236: , p5_a8 NUMBER := 0-1962.0724
237: , p5_a9 NUMBER := 0-1962.0724
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
235: , p5_a7 NUMBER := 0-1962.0724
236: , p5_a8 NUMBER := 0-1962.0724
237: , p5_a9 NUMBER := 0-1962.0724
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a8 NUMBER := 0-1962.0724
237: , p5_a9 NUMBER := 0-1962.0724
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 NUMBER := 0-1962.0724
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
248: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
256: , p5_a28 DATE := fnd_api.g_miss_date
249: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
256: , p5_a28 DATE := fnd_api.g_miss_date
257: , p5_a29 NUMBER := 0-1962.0724
250: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
256: , p5_a28 DATE := fnd_api.g_miss_date
257: , p5_a29 NUMBER := 0-1962.0724
258: , p5_a30 DATE := fnd_api.g_miss_date
252: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
256: , p5_a28 DATE := fnd_api.g_miss_date
257: , p5_a29 NUMBER := 0-1962.0724
258: , p5_a30 DATE := fnd_api.g_miss_date
259: , p5_a31 NUMBER := 0-1962.0724
260: )
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 NUMBER := 0-1962.0724
256: , p5_a28 DATE := fnd_api.g_miss_date
257: , p5_a29 NUMBER := 0-1962.0724
258: , p5_a30 DATE := fnd_api.g_miss_date
259: , p5_a31 NUMBER := 0-1962.0724
260: )
261:
262: as
461: , x_msg_count out nocopy NUMBER
462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 NUMBER := 0-1962.0724
464: , p5_a1 NUMBER := 0-1962.0724
465: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
462: , x_msg_data out nocopy VARCHAR2
463: , p5_a0 NUMBER := 0-1962.0724
464: , p5_a1 NUMBER := 0-1962.0724
465: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a7 NUMBER := 0-1962.0724
464: , p5_a1 NUMBER := 0-1962.0724
465: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a7 NUMBER := 0-1962.0724
471: , p5_a8 NUMBER := 0-1962.0724
472: , p5_a9 NUMBER := 0-1962.0724
465: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
466: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
469: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a7 NUMBER := 0-1962.0724
471: , p5_a8 NUMBER := 0-1962.0724
472: , p5_a9 NUMBER := 0-1962.0724
473: , p5_a10 DATE := fnd_api.g_miss_date
469: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a7 NUMBER := 0-1962.0724
471: , p5_a8 NUMBER := 0-1962.0724
472: , p5_a9 NUMBER := 0-1962.0724
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
470: , p5_a7 NUMBER := 0-1962.0724
471: , p5_a8 NUMBER := 0-1962.0724
472: , p5_a9 NUMBER := 0-1962.0724
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a8 NUMBER := 0-1962.0724
472: , p5_a9 NUMBER := 0-1962.0724
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 NUMBER := 0-1962.0724
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
474: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
475: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
476: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
477: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
478: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
481: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
482: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
483: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
491: , p5_a28 DATE := fnd_api.g_miss_date
484: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
491: , p5_a28 DATE := fnd_api.g_miss_date
492: , p5_a29 NUMBER := 0-1962.0724
485: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
486: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
491: , p5_a28 DATE := fnd_api.g_miss_date
492: , p5_a29 NUMBER := 0-1962.0724
493: , p5_a30 DATE := fnd_api.g_miss_date
487: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
491: , p5_a28 DATE := fnd_api.g_miss_date
492: , p5_a29 NUMBER := 0-1962.0724
493: , p5_a30 DATE := fnd_api.g_miss_date
494: , p5_a31 NUMBER := 0-1962.0724
495: )
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 NUMBER := 0-1962.0724
491: , p5_a28 DATE := fnd_api.g_miss_date
492: , p5_a29 NUMBER := 0-1962.0724
493: , p5_a30 DATE := fnd_api.g_miss_date
494: , p5_a31 NUMBER := 0-1962.0724
495: )
496:
497: as
761: , p6_a30 out nocopy DATE
762: , p6_a31 out nocopy NUMBER
763: , p5_a0 NUMBER := 0-1962.0724
764: , p5_a1 NUMBER := 0-1962.0724
765: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
762: , p6_a31 out nocopy NUMBER
763: , p5_a0 NUMBER := 0-1962.0724
764: , p5_a1 NUMBER := 0-1962.0724
765: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a7 NUMBER := 0-1962.0724
764: , p5_a1 NUMBER := 0-1962.0724
765: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 NUMBER := 0-1962.0724
772: , p5_a9 NUMBER := 0-1962.0724
765: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
766: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
769: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 NUMBER := 0-1962.0724
772: , p5_a9 NUMBER := 0-1962.0724
773: , p5_a10 DATE := fnd_api.g_miss_date
769: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 NUMBER := 0-1962.0724
772: , p5_a9 NUMBER := 0-1962.0724
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
770: , p5_a7 NUMBER := 0-1962.0724
771: , p5_a8 NUMBER := 0-1962.0724
772: , p5_a9 NUMBER := 0-1962.0724
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a8 NUMBER := 0-1962.0724
772: , p5_a9 NUMBER := 0-1962.0724
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 NUMBER := 0-1962.0724
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
774: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
775: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
776: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
777: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
778: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
780: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
781: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
782: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
783: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
791: , p5_a28 DATE := fnd_api.g_miss_date
784: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
791: , p5_a28 DATE := fnd_api.g_miss_date
792: , p5_a29 NUMBER := 0-1962.0724
785: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
786: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
791: , p5_a28 DATE := fnd_api.g_miss_date
792: , p5_a29 NUMBER := 0-1962.0724
793: , p5_a30 DATE := fnd_api.g_miss_date
787: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
791: , p5_a28 DATE := fnd_api.g_miss_date
792: , p5_a29 NUMBER := 0-1962.0724
793: , p5_a30 DATE := fnd_api.g_miss_date
794: , p5_a31 NUMBER := 0-1962.0724
795: )
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 NUMBER := 0-1962.0724
791: , p5_a28 DATE := fnd_api.g_miss_date
792: , p5_a29 NUMBER := 0-1962.0724
793: , p5_a30 DATE := fnd_api.g_miss_date
794: , p5_a31 NUMBER := 0-1962.0724
795: )
796:
797: as
996: , x_msg_count out nocopy NUMBER
997: , x_msg_data out nocopy VARCHAR2
998: , p5_a0 NUMBER := 0-1962.0724
999: , p5_a1 NUMBER := 0-1962.0724
1000: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1004: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
997: , x_msg_data out nocopy VARCHAR2
998: , p5_a0 NUMBER := 0-1962.0724
999: , p5_a1 NUMBER := 0-1962.0724
1000: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1004: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1005: , p5_a7 NUMBER := 0-1962.0724
999: , p5_a1 NUMBER := 0-1962.0724
1000: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1004: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1005: , p5_a7 NUMBER := 0-1962.0724
1006: , p5_a8 NUMBER := 0-1962.0724
1007: , p5_a9 NUMBER := 0-1962.0724
1000: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1001: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1004: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1005: , p5_a7 NUMBER := 0-1962.0724
1006: , p5_a8 NUMBER := 0-1962.0724
1007: , p5_a9 NUMBER := 0-1962.0724
1008: , p5_a10 DATE := fnd_api.g_miss_date
1004: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1005: , p5_a7 NUMBER := 0-1962.0724
1006: , p5_a8 NUMBER := 0-1962.0724
1007: , p5_a9 NUMBER := 0-1962.0724
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1005: , p5_a7 NUMBER := 0-1962.0724
1006: , p5_a8 NUMBER := 0-1962.0724
1007: , p5_a9 NUMBER := 0-1962.0724
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1006: , p5_a8 NUMBER := 0-1962.0724
1007: , p5_a9 NUMBER := 0-1962.0724
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 NUMBER := 0-1962.0724
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1009: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1010: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1011: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1012: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1013: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1015: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1016: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1018: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1026: , p5_a28 DATE := fnd_api.g_miss_date
1019: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1026: , p5_a28 DATE := fnd_api.g_miss_date
1027: , p5_a29 NUMBER := 0-1962.0724
1020: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1026: , p5_a28 DATE := fnd_api.g_miss_date
1027: , p5_a29 NUMBER := 0-1962.0724
1028: , p5_a30 DATE := fnd_api.g_miss_date
1022: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1026: , p5_a28 DATE := fnd_api.g_miss_date
1027: , p5_a29 NUMBER := 0-1962.0724
1028: , p5_a30 DATE := fnd_api.g_miss_date
1029: , p5_a31 NUMBER := 0-1962.0724
1030: )
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 NUMBER := 0-1962.0724
1026: , p5_a28 DATE := fnd_api.g_miss_date
1027: , p5_a29 NUMBER := 0-1962.0724
1028: , p5_a30 DATE := fnd_api.g_miss_date
1029: , p5_a31 NUMBER := 0-1962.0724
1030: )
1031:
1032: as
1195: , x_msg_count out nocopy NUMBER
1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 NUMBER := 0-1962.0724
1198: , p5_a1 NUMBER := 0-1962.0724
1199: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1196: , x_msg_data out nocopy VARCHAR2
1197: , p5_a0 NUMBER := 0-1962.0724
1198: , p5_a1 NUMBER := 0-1962.0724
1199: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a7 NUMBER := 0-1962.0724
1198: , p5_a1 NUMBER := 0-1962.0724
1199: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a7 NUMBER := 0-1962.0724
1205: , p5_a8 NUMBER := 0-1962.0724
1206: , p5_a9 NUMBER := 0-1962.0724
1199: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1200: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1203: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a7 NUMBER := 0-1962.0724
1205: , p5_a8 NUMBER := 0-1962.0724
1206: , p5_a9 NUMBER := 0-1962.0724
1207: , p5_a10 DATE := fnd_api.g_miss_date
1203: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a7 NUMBER := 0-1962.0724
1205: , p5_a8 NUMBER := 0-1962.0724
1206: , p5_a9 NUMBER := 0-1962.0724
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1204: , p5_a7 NUMBER := 0-1962.0724
1205: , p5_a8 NUMBER := 0-1962.0724
1206: , p5_a9 NUMBER := 0-1962.0724
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a8 NUMBER := 0-1962.0724
1206: , p5_a9 NUMBER := 0-1962.0724
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 NUMBER := 0-1962.0724
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1208: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1209: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1210: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1211: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1212: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1214: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1215: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1216: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1217: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1225: , p5_a28 DATE := fnd_api.g_miss_date
1218: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1225: , p5_a28 DATE := fnd_api.g_miss_date
1226: , p5_a29 NUMBER := 0-1962.0724
1219: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1220: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1225: , p5_a28 DATE := fnd_api.g_miss_date
1226: , p5_a29 NUMBER := 0-1962.0724
1227: , p5_a30 DATE := fnd_api.g_miss_date
1221: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1225: , p5_a28 DATE := fnd_api.g_miss_date
1226: , p5_a29 NUMBER := 0-1962.0724
1227: , p5_a30 DATE := fnd_api.g_miss_date
1228: , p5_a31 NUMBER := 0-1962.0724
1229: )
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 NUMBER := 0-1962.0724
1225: , p5_a28 DATE := fnd_api.g_miss_date
1226: , p5_a29 NUMBER := 0-1962.0724
1227: , p5_a30 DATE := fnd_api.g_miss_date
1228: , p5_a31 NUMBER := 0-1962.0724
1229: )
1230:
1231: as