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;
231: , p5_a3 NUMBER := 0-1962.0724
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 NUMBER := 0-1962.0724
234: , p5_a6 NUMBER := 0-1962.0724
235: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 DATE := fnd_api.g_miss_date
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
232: , p5_a4 NUMBER := 0-1962.0724
233: , p5_a5 NUMBER := 0-1962.0724
234: , p5_a6 NUMBER := 0-1962.0724
235: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 DATE := fnd_api.g_miss_date
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
240: , p5_a12 DATE := fnd_api.g_miss_date
233: , p5_a5 NUMBER := 0-1962.0724
234: , p5_a6 NUMBER := 0-1962.0724
235: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 DATE := fnd_api.g_miss_date
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
240: , p5_a12 DATE := fnd_api.g_miss_date
241: , p5_a13 NUMBER := 0-1962.0724
234: , p5_a6 NUMBER := 0-1962.0724
235: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
236: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 DATE := fnd_api.g_miss_date
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
240: , p5_a12 DATE := fnd_api.g_miss_date
241: , p5_a13 NUMBER := 0-1962.0724
242: , p5_a14 DATE := fnd_api.g_miss_date
236: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
237: , p5_a9 DATE := fnd_api.g_miss_date
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
240: , p5_a12 DATE := fnd_api.g_miss_date
241: , p5_a13 NUMBER := 0-1962.0724
242: , p5_a14 DATE := fnd_api.g_miss_date
243: , p5_a15 NUMBER := 0-1962.0724
244: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a10 DATE := fnd_api.g_miss_date
239: , p5_a11 NUMBER := 0-1962.0724
240: , p5_a12 DATE := fnd_api.g_miss_date
241: , p5_a13 NUMBER := 0-1962.0724
242: , p5_a14 DATE := fnd_api.g_miss_date
243: , p5_a15 NUMBER := 0-1962.0724
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
240: , p5_a12 DATE := fnd_api.g_miss_date
241: , p5_a13 NUMBER := 0-1962.0724
242: , p5_a14 DATE := fnd_api.g_miss_date
243: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
242: , p5_a14 DATE := fnd_api.g_miss_date
243: , p5_a15 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
243: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 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 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 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 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 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 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 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 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a31 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 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
260: )
253: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
260: )
261:
254: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
260: )
261:
262: as
255: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
260: )
261:
262: as
263: ddp_icpv_rec okl_itm_cat_rv_prcs_pub.icpv_rec_type;
466: , p5_a3 NUMBER := 0-1962.0724
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 NUMBER := 0-1962.0724
469: , p5_a6 NUMBER := 0-1962.0724
470: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 DATE := fnd_api.g_miss_date
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
467: , p5_a4 NUMBER := 0-1962.0724
468: , p5_a5 NUMBER := 0-1962.0724
469: , p5_a6 NUMBER := 0-1962.0724
470: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 DATE := fnd_api.g_miss_date
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
475: , p5_a12 DATE := fnd_api.g_miss_date
468: , p5_a5 NUMBER := 0-1962.0724
469: , p5_a6 NUMBER := 0-1962.0724
470: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 DATE := fnd_api.g_miss_date
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
475: , p5_a12 DATE := fnd_api.g_miss_date
476: , p5_a13 NUMBER := 0-1962.0724
469: , p5_a6 NUMBER := 0-1962.0724
470: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
471: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 DATE := fnd_api.g_miss_date
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
475: , p5_a12 DATE := fnd_api.g_miss_date
476: , p5_a13 NUMBER := 0-1962.0724
477: , p5_a14 DATE := fnd_api.g_miss_date
471: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
472: , p5_a9 DATE := fnd_api.g_miss_date
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
475: , p5_a12 DATE := fnd_api.g_miss_date
476: , p5_a13 NUMBER := 0-1962.0724
477: , p5_a14 DATE := fnd_api.g_miss_date
478: , p5_a15 NUMBER := 0-1962.0724
479: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
473: , p5_a10 DATE := fnd_api.g_miss_date
474: , p5_a11 NUMBER := 0-1962.0724
475: , p5_a12 DATE := fnd_api.g_miss_date
476: , p5_a13 NUMBER := 0-1962.0724
477: , p5_a14 DATE := fnd_api.g_miss_date
478: , p5_a15 NUMBER := 0-1962.0724
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
475: , p5_a12 DATE := fnd_api.g_miss_date
476: , p5_a13 NUMBER := 0-1962.0724
477: , p5_a14 DATE := fnd_api.g_miss_date
478: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
477: , p5_a14 DATE := fnd_api.g_miss_date
478: , p5_a15 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
478: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 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 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 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 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 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 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 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 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a31 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 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
488: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
489: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
490: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
497: as
490: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
491: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
492: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
494: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
495: )
496:
497: as
498: ddp_icpv_rec okl_itm_cat_rv_prcs_pub.icpv_rec_type;
766: , p5_a3 NUMBER := 0-1962.0724
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 DATE := fnd_api.g_miss_date
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
767: , p5_a4 NUMBER := 0-1962.0724
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 DATE := fnd_api.g_miss_date
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
768: , p5_a5 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 DATE := fnd_api.g_miss_date
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 NUMBER := 0-1962.0724
769: , p5_a6 NUMBER := 0-1962.0724
770: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 DATE := fnd_api.g_miss_date
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 NUMBER := 0-1962.0724
777: , p5_a14 DATE := fnd_api.g_miss_date
771: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
772: , p5_a9 DATE := fnd_api.g_miss_date
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 NUMBER := 0-1962.0724
777: , p5_a14 DATE := fnd_api.g_miss_date
778: , p5_a15 NUMBER := 0-1962.0724
779: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
773: , p5_a10 DATE := fnd_api.g_miss_date
774: , p5_a11 NUMBER := 0-1962.0724
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 NUMBER := 0-1962.0724
777: , p5_a14 DATE := fnd_api.g_miss_date
778: , p5_a15 NUMBER := 0-1962.0724
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
775: , p5_a12 DATE := fnd_api.g_miss_date
776: , p5_a13 NUMBER := 0-1962.0724
777: , p5_a14 DATE := fnd_api.g_miss_date
778: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
777: , p5_a14 DATE := fnd_api.g_miss_date
778: , p5_a15 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
778: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 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 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 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 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 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 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 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 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 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 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: )
788: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
789: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
797: as
790: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
791: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
792: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
793: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
794: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
797: as
798: ddp_icpv_rec okl_itm_cat_rv_prcs_pub.icpv_rec_type;
1001: , p5_a3 NUMBER := 0-1962.0724
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 NUMBER := 0-1962.0724
1004: , p5_a6 NUMBER := 0-1962.0724
1005: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1006: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 DATE := fnd_api.g_miss_date
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1002: , p5_a4 NUMBER := 0-1962.0724
1003: , p5_a5 NUMBER := 0-1962.0724
1004: , p5_a6 NUMBER := 0-1962.0724
1005: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1006: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 DATE := fnd_api.g_miss_date
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1010: , p5_a12 DATE := fnd_api.g_miss_date
1003: , p5_a5 NUMBER := 0-1962.0724
1004: , p5_a6 NUMBER := 0-1962.0724
1005: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1006: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 DATE := fnd_api.g_miss_date
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1010: , p5_a12 DATE := fnd_api.g_miss_date
1011: , p5_a13 NUMBER := 0-1962.0724
1004: , p5_a6 NUMBER := 0-1962.0724
1005: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1006: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 DATE := fnd_api.g_miss_date
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1010: , p5_a12 DATE := fnd_api.g_miss_date
1011: , p5_a13 NUMBER := 0-1962.0724
1012: , p5_a14 DATE := fnd_api.g_miss_date
1006: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1007: , p5_a9 DATE := fnd_api.g_miss_date
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1010: , p5_a12 DATE := fnd_api.g_miss_date
1011: , p5_a13 NUMBER := 0-1962.0724
1012: , p5_a14 DATE := fnd_api.g_miss_date
1013: , p5_a15 NUMBER := 0-1962.0724
1014: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1008: , p5_a10 DATE := fnd_api.g_miss_date
1009: , p5_a11 NUMBER := 0-1962.0724
1010: , p5_a12 DATE := fnd_api.g_miss_date
1011: , p5_a13 NUMBER := 0-1962.0724
1012: , p5_a14 DATE := fnd_api.g_miss_date
1013: , p5_a15 NUMBER := 0-1962.0724
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
1010: , p5_a12 DATE := fnd_api.g_miss_date
1011: , p5_a13 NUMBER := 0-1962.0724
1012: , p5_a14 DATE := fnd_api.g_miss_date
1013: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
1012: , p5_a14 DATE := fnd_api.g_miss_date
1013: , p5_a15 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
1013: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 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 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 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 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 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 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 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 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a31 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 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1030: )
1023: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1030: )
1031:
1024: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1030: )
1031:
1032: as
1025: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1030: )
1031:
1032: as
1033: ddp_icpv_rec okl_itm_cat_rv_prcs_pub.icpv_rec_type;
1200: , p5_a3 NUMBER := 0-1962.0724
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 NUMBER := 0-1962.0724
1203: , p5_a6 NUMBER := 0-1962.0724
1204: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 DATE := fnd_api.g_miss_date
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1201: , p5_a4 NUMBER := 0-1962.0724
1202: , p5_a5 NUMBER := 0-1962.0724
1203: , p5_a6 NUMBER := 0-1962.0724
1204: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 DATE := fnd_api.g_miss_date
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1209: , p5_a12 DATE := fnd_api.g_miss_date
1202: , p5_a5 NUMBER := 0-1962.0724
1203: , p5_a6 NUMBER := 0-1962.0724
1204: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 DATE := fnd_api.g_miss_date
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1209: , p5_a12 DATE := fnd_api.g_miss_date
1210: , p5_a13 NUMBER := 0-1962.0724
1203: , p5_a6 NUMBER := 0-1962.0724
1204: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1205: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 DATE := fnd_api.g_miss_date
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1209: , p5_a12 DATE := fnd_api.g_miss_date
1210: , p5_a13 NUMBER := 0-1962.0724
1211: , p5_a14 DATE := fnd_api.g_miss_date
1205: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1206: , p5_a9 DATE := fnd_api.g_miss_date
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1209: , p5_a12 DATE := fnd_api.g_miss_date
1210: , p5_a13 NUMBER := 0-1962.0724
1211: , p5_a14 DATE := fnd_api.g_miss_date
1212: , p5_a15 NUMBER := 0-1962.0724
1213: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1207: , p5_a10 DATE := fnd_api.g_miss_date
1208: , p5_a11 NUMBER := 0-1962.0724
1209: , p5_a12 DATE := fnd_api.g_miss_date
1210: , p5_a13 NUMBER := 0-1962.0724
1211: , p5_a14 DATE := fnd_api.g_miss_date
1212: , p5_a15 NUMBER := 0-1962.0724
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
1209: , p5_a12 DATE := fnd_api.g_miss_date
1210: , p5_a13 NUMBER := 0-1962.0724
1211: , p5_a14 DATE := fnd_api.g_miss_date
1212: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
1211: , p5_a14 DATE := fnd_api.g_miss_date
1212: , p5_a15 NUMBER := 0-1962.0724
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 DATE := fnd_api.g_miss_date
1212: , p5_a15 NUMBER := 0-1962.0724
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 NUMBER := 0-1962.0724
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 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 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 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 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 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 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 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 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a31 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 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1229: )
1222: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1229: )
1230:
1223: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
1224: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1229: )
1230:
1231: as
1224: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1225: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1226: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
1227: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1228: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
1229: )
1230:
1231: as
1232: ddp_icpv_rec okl_itm_cat_rv_prcs_pub.icpv_rec_type;