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;
61: , p6_a34 out nocopy NUMBER
62: , p6_a35 out nocopy DATE
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 NUMBER := 0-1962.0724
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 NUMBER := 0-1962.0724
69: , p5_a6 NUMBER := 0-1962.0724
63: , p5_a0 NUMBER := 0-1962.0724
64: , p5_a1 NUMBER := 0-1962.0724
65: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
66: , p5_a3 NUMBER := 0-1962.0724
67: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
68: , p5_a5 NUMBER := 0-1962.0724
69: , p5_a6 NUMBER := 0-1962.0724
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 NUMBER := 0-1962.0724
68: , p5_a5 NUMBER := 0-1962.0724
69: , p5_a6 NUMBER := 0-1962.0724
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 NUMBER := 0-1962.0724
72: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
69: , p5_a6 NUMBER := 0-1962.0724
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 NUMBER := 0-1962.0724
72: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
70: , p5_a7 NUMBER := 0-1962.0724
71: , p5_a8 NUMBER := 0-1962.0724
72: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
71: , p5_a8 NUMBER := 0-1962.0724
72: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
72: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
73: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
74: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
75: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
76: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
77: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
78: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
79: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a24 NUMBER := 0-1962.0724
80: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a24 NUMBER := 0-1962.0724
88: , p5_a25 NUMBER := 0-1962.0724
81: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a24 NUMBER := 0-1962.0724
88: , p5_a25 NUMBER := 0-1962.0724
89: , p5_a26 NUMBER := 0-1962.0724
82: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
83: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
84: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
85: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a24 NUMBER := 0-1962.0724
88: , p5_a25 NUMBER := 0-1962.0724
89: , p5_a26 NUMBER := 0-1962.0724
90: , p5_a27 DATE := fnd_api.g_miss_date
86: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
87: , p5_a24 NUMBER := 0-1962.0724
88: , p5_a25 NUMBER := 0-1962.0724
89: , p5_a26 NUMBER := 0-1962.0724
90: , p5_a27 DATE := fnd_api.g_miss_date
91: , p5_a28 DATE := fnd_api.g_miss_date
92: , p5_a29 NUMBER := 0-1962.0724
93: , p5_a30 NUMBER := 0-1962.0724
94: , p5_a31 DATE := fnd_api.g_miss_date
87: , p5_a24 NUMBER := 0-1962.0724
88: , p5_a25 NUMBER := 0-1962.0724
89: , p5_a26 NUMBER := 0-1962.0724
90: , p5_a27 DATE := fnd_api.g_miss_date
91: , p5_a28 DATE := fnd_api.g_miss_date
92: , p5_a29 NUMBER := 0-1962.0724
93: , p5_a30 NUMBER := 0-1962.0724
94: , p5_a31 DATE := fnd_api.g_miss_date
95: , p5_a32 NUMBER := 0-1962.0724
90: , p5_a27 DATE := fnd_api.g_miss_date
91: , p5_a28 DATE := fnd_api.g_miss_date
92: , p5_a29 NUMBER := 0-1962.0724
93: , p5_a30 NUMBER := 0-1962.0724
94: , p5_a31 DATE := fnd_api.g_miss_date
95: , p5_a32 NUMBER := 0-1962.0724
96: , p5_a33 NUMBER := 0-1962.0724
97: , p5_a34 NUMBER := 0-1962.0724
98: , p5_a35 DATE := fnd_api.g_miss_date
94: , p5_a31 DATE := fnd_api.g_miss_date
95: , p5_a32 NUMBER := 0-1962.0724
96: , p5_a33 NUMBER := 0-1962.0724
97: , p5_a34 NUMBER := 0-1962.0724
98: , p5_a35 DATE := fnd_api.g_miss_date
99: )
100:
101: as
102: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
393: , x_msg_count out nocopy NUMBER
394: , x_msg_data out nocopy VARCHAR2
395: , p5_a0 NUMBER := 0-1962.0724
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 NUMBER := 0-1962.0724
399: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a5 NUMBER := 0-1962.0724
401: , p5_a6 NUMBER := 0-1962.0724
395: , p5_a0 NUMBER := 0-1962.0724
396: , p5_a1 NUMBER := 0-1962.0724
397: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
398: , p5_a3 NUMBER := 0-1962.0724
399: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
400: , p5_a5 NUMBER := 0-1962.0724
401: , p5_a6 NUMBER := 0-1962.0724
402: , p5_a7 NUMBER := 0-1962.0724
403: , p5_a8 NUMBER := 0-1962.0724
400: , p5_a5 NUMBER := 0-1962.0724
401: , p5_a6 NUMBER := 0-1962.0724
402: , p5_a7 NUMBER := 0-1962.0724
403: , p5_a8 NUMBER := 0-1962.0724
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a6 NUMBER := 0-1962.0724
402: , p5_a7 NUMBER := 0-1962.0724
403: , p5_a8 NUMBER := 0-1962.0724
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
402: , p5_a7 NUMBER := 0-1962.0724
403: , p5_a8 NUMBER := 0-1962.0724
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
403: , p5_a8 NUMBER := 0-1962.0724
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
407: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
408: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
409: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
410: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a24 NUMBER := 0-1962.0724
412: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 NUMBER := 0-1962.0724
413: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 NUMBER := 0-1962.0724
421: , p5_a26 NUMBER := 0-1962.0724
414: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
415: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 NUMBER := 0-1962.0724
421: , p5_a26 NUMBER := 0-1962.0724
422: , p5_a27 DATE := fnd_api.g_miss_date
418: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 NUMBER := 0-1962.0724
421: , p5_a26 NUMBER := 0-1962.0724
422: , p5_a27 DATE := fnd_api.g_miss_date
423: , p5_a28 DATE := fnd_api.g_miss_date
424: , p5_a29 NUMBER := 0-1962.0724
425: , p5_a30 NUMBER := 0-1962.0724
426: , p5_a31 DATE := fnd_api.g_miss_date
419: , p5_a24 NUMBER := 0-1962.0724
420: , p5_a25 NUMBER := 0-1962.0724
421: , p5_a26 NUMBER := 0-1962.0724
422: , p5_a27 DATE := fnd_api.g_miss_date
423: , p5_a28 DATE := fnd_api.g_miss_date
424: , p5_a29 NUMBER := 0-1962.0724
425: , p5_a30 NUMBER := 0-1962.0724
426: , p5_a31 DATE := fnd_api.g_miss_date
427: , p5_a32 NUMBER := 0-1962.0724
422: , p5_a27 DATE := fnd_api.g_miss_date
423: , p5_a28 DATE := fnd_api.g_miss_date
424: , p5_a29 NUMBER := 0-1962.0724
425: , p5_a30 NUMBER := 0-1962.0724
426: , p5_a31 DATE := fnd_api.g_miss_date
427: , p5_a32 NUMBER := 0-1962.0724
428: , p5_a33 NUMBER := 0-1962.0724
429: , p5_a34 NUMBER := 0-1962.0724
430: , p5_a35 DATE := fnd_api.g_miss_date
426: , p5_a31 DATE := fnd_api.g_miss_date
427: , p5_a32 NUMBER := 0-1962.0724
428: , p5_a33 NUMBER := 0-1962.0724
429: , p5_a34 NUMBER := 0-1962.0724
430: , p5_a35 DATE := fnd_api.g_miss_date
431: )
432:
433: as
434: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
644: , p6_a34 out nocopy NUMBER
645: , p6_a35 out nocopy DATE
646: , p5_a0 NUMBER := 0-1962.0724
647: , p5_a1 NUMBER := 0-1962.0724
648: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a3 NUMBER := 0-1962.0724
650: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a5 NUMBER := 0-1962.0724
652: , p5_a6 NUMBER := 0-1962.0724
646: , p5_a0 NUMBER := 0-1962.0724
647: , p5_a1 NUMBER := 0-1962.0724
648: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
649: , p5_a3 NUMBER := 0-1962.0724
650: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
651: , p5_a5 NUMBER := 0-1962.0724
652: , p5_a6 NUMBER := 0-1962.0724
653: , p5_a7 NUMBER := 0-1962.0724
654: , p5_a8 NUMBER := 0-1962.0724
651: , p5_a5 NUMBER := 0-1962.0724
652: , p5_a6 NUMBER := 0-1962.0724
653: , p5_a7 NUMBER := 0-1962.0724
654: , p5_a8 NUMBER := 0-1962.0724
655: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
652: , p5_a6 NUMBER := 0-1962.0724
653: , p5_a7 NUMBER := 0-1962.0724
654: , p5_a8 NUMBER := 0-1962.0724
655: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
653: , p5_a7 NUMBER := 0-1962.0724
654: , p5_a8 NUMBER := 0-1962.0724
655: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
654: , p5_a8 NUMBER := 0-1962.0724
655: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
655: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
656: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
657: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
658: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
659: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
660: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
661: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
662: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a24 NUMBER := 0-1962.0724
663: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a24 NUMBER := 0-1962.0724
671: , p5_a25 NUMBER := 0-1962.0724
664: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a24 NUMBER := 0-1962.0724
671: , p5_a25 NUMBER := 0-1962.0724
672: , p5_a26 NUMBER := 0-1962.0724
665: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
666: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
667: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
668: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a24 NUMBER := 0-1962.0724
671: , p5_a25 NUMBER := 0-1962.0724
672: , p5_a26 NUMBER := 0-1962.0724
673: , p5_a27 DATE := fnd_api.g_miss_date
669: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
670: , p5_a24 NUMBER := 0-1962.0724
671: , p5_a25 NUMBER := 0-1962.0724
672: , p5_a26 NUMBER := 0-1962.0724
673: , p5_a27 DATE := fnd_api.g_miss_date
674: , p5_a28 DATE := fnd_api.g_miss_date
675: , p5_a29 NUMBER := 0-1962.0724
676: , p5_a30 NUMBER := 0-1962.0724
677: , p5_a31 DATE := fnd_api.g_miss_date
670: , p5_a24 NUMBER := 0-1962.0724
671: , p5_a25 NUMBER := 0-1962.0724
672: , p5_a26 NUMBER := 0-1962.0724
673: , p5_a27 DATE := fnd_api.g_miss_date
674: , p5_a28 DATE := fnd_api.g_miss_date
675: , p5_a29 NUMBER := 0-1962.0724
676: , p5_a30 NUMBER := 0-1962.0724
677: , p5_a31 DATE := fnd_api.g_miss_date
678: , p5_a32 NUMBER := 0-1962.0724
673: , p5_a27 DATE := fnd_api.g_miss_date
674: , p5_a28 DATE := fnd_api.g_miss_date
675: , p5_a29 NUMBER := 0-1962.0724
676: , p5_a30 NUMBER := 0-1962.0724
677: , p5_a31 DATE := fnd_api.g_miss_date
678: , p5_a32 NUMBER := 0-1962.0724
679: , p5_a33 NUMBER := 0-1962.0724
680: , p5_a34 NUMBER := 0-1962.0724
681: , p5_a35 DATE := fnd_api.g_miss_date
677: , p5_a31 DATE := fnd_api.g_miss_date
678: , p5_a32 NUMBER := 0-1962.0724
679: , p5_a33 NUMBER := 0-1962.0724
680: , p5_a34 NUMBER := 0-1962.0724
681: , p5_a35 DATE := fnd_api.g_miss_date
682: )
683:
684: as
685: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1012: , p6_a34 out nocopy NUMBER
1013: , p6_a35 out nocopy DATE
1014: , p5_a0 NUMBER := 0-1962.0724
1015: , p5_a1 NUMBER := 0-1962.0724
1016: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a3 NUMBER := 0-1962.0724
1018: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a5 NUMBER := 0-1962.0724
1020: , p5_a6 NUMBER := 0-1962.0724
1014: , p5_a0 NUMBER := 0-1962.0724
1015: , p5_a1 NUMBER := 0-1962.0724
1016: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1017: , p5_a3 NUMBER := 0-1962.0724
1018: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1019: , p5_a5 NUMBER := 0-1962.0724
1020: , p5_a6 NUMBER := 0-1962.0724
1021: , p5_a7 NUMBER := 0-1962.0724
1022: , p5_a8 NUMBER := 0-1962.0724
1019: , p5_a5 NUMBER := 0-1962.0724
1020: , p5_a6 NUMBER := 0-1962.0724
1021: , p5_a7 NUMBER := 0-1962.0724
1022: , p5_a8 NUMBER := 0-1962.0724
1023: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1020: , p5_a6 NUMBER := 0-1962.0724
1021: , p5_a7 NUMBER := 0-1962.0724
1022: , p5_a8 NUMBER := 0-1962.0724
1023: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1021: , p5_a7 NUMBER := 0-1962.0724
1022: , p5_a8 NUMBER := 0-1962.0724
1023: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1022: , p5_a8 NUMBER := 0-1962.0724
1023: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1023: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1024: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1025: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1026: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1027: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1028: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1029: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1030: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a24 NUMBER := 0-1962.0724
1031: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a24 NUMBER := 0-1962.0724
1039: , p5_a25 NUMBER := 0-1962.0724
1032: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a24 NUMBER := 0-1962.0724
1039: , p5_a25 NUMBER := 0-1962.0724
1040: , p5_a26 NUMBER := 0-1962.0724
1033: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1034: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1035: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1036: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a24 NUMBER := 0-1962.0724
1039: , p5_a25 NUMBER := 0-1962.0724
1040: , p5_a26 NUMBER := 0-1962.0724
1041: , p5_a27 DATE := fnd_api.g_miss_date
1037: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1038: , p5_a24 NUMBER := 0-1962.0724
1039: , p5_a25 NUMBER := 0-1962.0724
1040: , p5_a26 NUMBER := 0-1962.0724
1041: , p5_a27 DATE := fnd_api.g_miss_date
1042: , p5_a28 DATE := fnd_api.g_miss_date
1043: , p5_a29 NUMBER := 0-1962.0724
1044: , p5_a30 NUMBER := 0-1962.0724
1045: , p5_a31 DATE := fnd_api.g_miss_date
1038: , p5_a24 NUMBER := 0-1962.0724
1039: , p5_a25 NUMBER := 0-1962.0724
1040: , p5_a26 NUMBER := 0-1962.0724
1041: , p5_a27 DATE := fnd_api.g_miss_date
1042: , p5_a28 DATE := fnd_api.g_miss_date
1043: , p5_a29 NUMBER := 0-1962.0724
1044: , p5_a30 NUMBER := 0-1962.0724
1045: , p5_a31 DATE := fnd_api.g_miss_date
1046: , p5_a32 NUMBER := 0-1962.0724
1041: , p5_a27 DATE := fnd_api.g_miss_date
1042: , p5_a28 DATE := fnd_api.g_miss_date
1043: , p5_a29 NUMBER := 0-1962.0724
1044: , p5_a30 NUMBER := 0-1962.0724
1045: , p5_a31 DATE := fnd_api.g_miss_date
1046: , p5_a32 NUMBER := 0-1962.0724
1047: , p5_a33 NUMBER := 0-1962.0724
1048: , p5_a34 NUMBER := 0-1962.0724
1049: , p5_a35 DATE := fnd_api.g_miss_date
1045: , p5_a31 DATE := fnd_api.g_miss_date
1046: , p5_a32 NUMBER := 0-1962.0724
1047: , p5_a33 NUMBER := 0-1962.0724
1048: , p5_a34 NUMBER := 0-1962.0724
1049: , p5_a35 DATE := fnd_api.g_miss_date
1050: )
1051:
1052: as
1053: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;
1380: , p6_a34 out nocopy NUMBER
1381: , p6_a35 out nocopy DATE
1382: , p5_a0 NUMBER := 0-1962.0724
1383: , p5_a1 NUMBER := 0-1962.0724
1384: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a3 NUMBER := 0-1962.0724
1386: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a5 NUMBER := 0-1962.0724
1388: , p5_a6 NUMBER := 0-1962.0724
1382: , p5_a0 NUMBER := 0-1962.0724
1383: , p5_a1 NUMBER := 0-1962.0724
1384: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1385: , p5_a3 NUMBER := 0-1962.0724
1386: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1387: , p5_a5 NUMBER := 0-1962.0724
1388: , p5_a6 NUMBER := 0-1962.0724
1389: , p5_a7 NUMBER := 0-1962.0724
1390: , p5_a8 NUMBER := 0-1962.0724
1387: , p5_a5 NUMBER := 0-1962.0724
1388: , p5_a6 NUMBER := 0-1962.0724
1389: , p5_a7 NUMBER := 0-1962.0724
1390: , p5_a8 NUMBER := 0-1962.0724
1391: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1388: , p5_a6 NUMBER := 0-1962.0724
1389: , p5_a7 NUMBER := 0-1962.0724
1390: , p5_a8 NUMBER := 0-1962.0724
1391: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1389: , p5_a7 NUMBER := 0-1962.0724
1390: , p5_a8 NUMBER := 0-1962.0724
1391: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1390: , p5_a8 NUMBER := 0-1962.0724
1391: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1391: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1392: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1393: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1394: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1395: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1396: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1397: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1398: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a24 NUMBER := 0-1962.0724
1399: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a24 NUMBER := 0-1962.0724
1407: , p5_a25 NUMBER := 0-1962.0724
1400: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a24 NUMBER := 0-1962.0724
1407: , p5_a25 NUMBER := 0-1962.0724
1408: , p5_a26 NUMBER := 0-1962.0724
1401: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
1402: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1403: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1404: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a24 NUMBER := 0-1962.0724
1407: , p5_a25 NUMBER := 0-1962.0724
1408: , p5_a26 NUMBER := 0-1962.0724
1409: , p5_a27 DATE := fnd_api.g_miss_date
1405: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
1406: , p5_a24 NUMBER := 0-1962.0724
1407: , p5_a25 NUMBER := 0-1962.0724
1408: , p5_a26 NUMBER := 0-1962.0724
1409: , p5_a27 DATE := fnd_api.g_miss_date
1410: , p5_a28 DATE := fnd_api.g_miss_date
1411: , p5_a29 NUMBER := 0-1962.0724
1412: , p5_a30 NUMBER := 0-1962.0724
1413: , p5_a31 DATE := fnd_api.g_miss_date
1406: , p5_a24 NUMBER := 0-1962.0724
1407: , p5_a25 NUMBER := 0-1962.0724
1408: , p5_a26 NUMBER := 0-1962.0724
1409: , p5_a27 DATE := fnd_api.g_miss_date
1410: , p5_a28 DATE := fnd_api.g_miss_date
1411: , p5_a29 NUMBER := 0-1962.0724
1412: , p5_a30 NUMBER := 0-1962.0724
1413: , p5_a31 DATE := fnd_api.g_miss_date
1414: , p5_a32 NUMBER := 0-1962.0724
1409: , p5_a27 DATE := fnd_api.g_miss_date
1410: , p5_a28 DATE := fnd_api.g_miss_date
1411: , p5_a29 NUMBER := 0-1962.0724
1412: , p5_a30 NUMBER := 0-1962.0724
1413: , p5_a31 DATE := fnd_api.g_miss_date
1414: , p5_a32 NUMBER := 0-1962.0724
1415: , p5_a33 NUMBER := 0-1962.0724
1416: , p5_a34 NUMBER := 0-1962.0724
1417: , p5_a35 DATE := fnd_api.g_miss_date
1413: , p5_a31 DATE := fnd_api.g_miss_date
1414: , p5_a32 NUMBER := 0-1962.0724
1415: , p5_a33 NUMBER := 0-1962.0724
1416: , p5_a34 NUMBER := 0-1962.0724
1417: , p5_a35 DATE := fnd_api.g_miss_date
1418: )
1419:
1420: as
1421: ddp_sirv_rec okl_sif_rets_pub.sirv_rec_type;