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;
27: , x_msg_count out nocopy NUMBER
28: , x_msg_data out nocopy VARCHAR2
29: , x_deliv_id out nocopy NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
29: , x_deliv_id out nocopy NUMBER
30: , p7_a0 NUMBER := 0-1962.0724
31: , p7_a1 DATE := fnd_api.g_miss_date
32: , p7_a2 NUMBER := 0-1962.0724
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
33: , p7_a3 DATE := fnd_api.g_miss_date
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
34: , p7_a4 NUMBER := 0-1962.0724
35: , p7_a5 NUMBER := 0-1962.0724
36: , p7_a6 NUMBER := 0-1962.0724
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
37: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
38: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
39: , p7_a9 NUMBER := 0-1962.0724
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
40: , p7_a10 NUMBER := 0-1962.0724
41: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
42: , p7_a12 DATE := fnd_api.g_miss_date
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 NUMBER := 0-1962.0724
43: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a15 NUMBER := 0-1962.0724
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 NUMBER := 0-1962.0724
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a16 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 NUMBER := 0-1962.0724
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 NUMBER := 0-1962.0724
53: , p7_a23 NUMBER := 0-1962.0724
54: , p7_a24 NUMBER := 0-1962.0724
47: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
48: , p7_a18 NUMBER := 0-1962.0724
49: , p7_a19 NUMBER := 0-1962.0724
50: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a22 NUMBER := 0-1962.0724
53: , p7_a23 NUMBER := 0-1962.0724
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 NUMBER := 0-1962.0724
52: , p7_a22 NUMBER := 0-1962.0724
53: , p7_a23 NUMBER := 0-1962.0724
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 NUMBER := 0-1962.0724
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
53: , p7_a23 NUMBER := 0-1962.0724
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 NUMBER := 0-1962.0724
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a24 NUMBER := 0-1962.0724
55: , p7_a25 NUMBER := 0-1962.0724
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
55: , p7_a25 NUMBER := 0-1962.0724
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 NUMBER := 0-1962.0724
56: , p7_a26 DATE := fnd_api.g_miss_date
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
57: , p7_a27 DATE := fnd_api.g_miss_date
58: , p7_a28 DATE := fnd_api.g_miss_date
59: , p7_a29 DATE := fnd_api.g_miss_date
60: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
61: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a37 NUMBER := 0-1962.0724
68: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a39 NUMBER := 0-1962.0724
62: , p7_a32 NUMBER := 0-1962.0724
63: , p7_a33 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a37 NUMBER := 0-1962.0724
68: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a39 NUMBER := 0-1962.0724
70: , p7_a40 NUMBER := 0-1962.0724
64: , p7_a34 NUMBER := 0-1962.0724
65: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
66: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a37 NUMBER := 0-1962.0724
68: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a39 NUMBER := 0-1962.0724
70: , p7_a40 NUMBER := 0-1962.0724
71: , p7_a41 NUMBER := 0-1962.0724
72: , p7_a42 NUMBER := 0-1962.0724
69: , p7_a39 NUMBER := 0-1962.0724
70: , p7_a40 NUMBER := 0-1962.0724
71: , p7_a41 NUMBER := 0-1962.0724
72: , p7_a42 NUMBER := 0-1962.0724
73: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a40 NUMBER := 0-1962.0724
71: , p7_a41 NUMBER := 0-1962.0724
72: , p7_a42 NUMBER := 0-1962.0724
73: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a48 NUMBER := 0-1962.0724
71: , p7_a41 NUMBER := 0-1962.0724
72: , p7_a42 NUMBER := 0-1962.0724
73: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a48 NUMBER := 0-1962.0724
79: , p7_a49 NUMBER := 0-1962.0724
72: , p7_a42 NUMBER := 0-1962.0724
73: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a48 NUMBER := 0-1962.0724
79: , p7_a49 NUMBER := 0-1962.0724
80: , p7_a50 NUMBER := 0-1962.0724
73: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
75: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
76: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a48 NUMBER := 0-1962.0724
79: , p7_a49 NUMBER := 0-1962.0724
80: , p7_a50 NUMBER := 0-1962.0724
81: , p7_a51 NUMBER := 0-1962.0724
78: , p7_a48 NUMBER := 0-1962.0724
79: , p7_a49 NUMBER := 0-1962.0724
80: , p7_a50 NUMBER := 0-1962.0724
81: , p7_a51 NUMBER := 0-1962.0724
82: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a53 NUMBER := 0-1962.0724
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
80: , p7_a50 NUMBER := 0-1962.0724
81: , p7_a51 NUMBER := 0-1962.0724
82: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a53 NUMBER := 0-1962.0724
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a51 NUMBER := 0-1962.0724
82: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a53 NUMBER := 0-1962.0724
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
82: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a53 NUMBER := 0-1962.0724
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
83: , p7_a53 NUMBER := 0-1962.0724
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
84: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
98: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
106: , p7_a76 NUMBER := 0-1962.0724
99: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
106: , p7_a76 NUMBER := 0-1962.0724
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
106: , p7_a76 NUMBER := 0-1962.0724
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
106: , p7_a76 NUMBER := 0-1962.0724
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a79 NUMBER := 0-1962.0724
110: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a75 NUMBER := 0-1962.0724
106: , p7_a76 NUMBER := 0-1962.0724
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a79 NUMBER := 0-1962.0724
110: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112: )
106: , p7_a76 NUMBER := 0-1962.0724
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a79 NUMBER := 0-1962.0724
110: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112: )
113:
114: as
107: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a79 NUMBER := 0-1962.0724
110: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
111: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
112: )
113:
114: as
115: ddp_deliv_rec ams_deliverable_pub.deliv_rec_type;
237: , x_return_status out nocopy VARCHAR2
238: , x_msg_count out nocopy NUMBER
239: , x_msg_data out nocopy VARCHAR2
240: , p7_a0 NUMBER := 0-1962.0724
241: , p7_a1 DATE := fnd_api.g_miss_date
242: , p7_a2 NUMBER := 0-1962.0724
243: , p7_a3 DATE := fnd_api.g_miss_date
244: , p7_a4 NUMBER := 0-1962.0724
245: , p7_a5 NUMBER := 0-1962.0724
239: , x_msg_data out nocopy VARCHAR2
240: , p7_a0 NUMBER := 0-1962.0724
241: , p7_a1 DATE := fnd_api.g_miss_date
242: , p7_a2 NUMBER := 0-1962.0724
243: , p7_a3 DATE := fnd_api.g_miss_date
244: , p7_a4 NUMBER := 0-1962.0724
245: , p7_a5 NUMBER := 0-1962.0724
246: , p7_a6 NUMBER := 0-1962.0724
247: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
243: , p7_a3 DATE := fnd_api.g_miss_date
244: , p7_a4 NUMBER := 0-1962.0724
245: , p7_a5 NUMBER := 0-1962.0724
246: , p7_a6 NUMBER := 0-1962.0724
247: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a9 NUMBER := 0-1962.0724
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
244: , p7_a4 NUMBER := 0-1962.0724
245: , p7_a5 NUMBER := 0-1962.0724
246: , p7_a6 NUMBER := 0-1962.0724
247: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a9 NUMBER := 0-1962.0724
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a12 DATE := fnd_api.g_miss_date
247: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a9 NUMBER := 0-1962.0724
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a12 DATE := fnd_api.g_miss_date
253: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a15 NUMBER := 0-1962.0724
248: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a9 NUMBER := 0-1962.0724
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a12 DATE := fnd_api.g_miss_date
253: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a15 NUMBER := 0-1962.0724
256: , p7_a16 NUMBER := 0-1962.0724
249: , p7_a9 NUMBER := 0-1962.0724
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a12 DATE := fnd_api.g_miss_date
253: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a15 NUMBER := 0-1962.0724
256: , p7_a16 NUMBER := 0-1962.0724
257: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
250: , p7_a10 NUMBER := 0-1962.0724
251: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a12 DATE := fnd_api.g_miss_date
253: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a15 NUMBER := 0-1962.0724
256: , p7_a16 NUMBER := 0-1962.0724
257: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a18 NUMBER := 0-1962.0724
253: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a15 NUMBER := 0-1962.0724
256: , p7_a16 NUMBER := 0-1962.0724
257: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a18 NUMBER := 0-1962.0724
259: , p7_a19 NUMBER := 0-1962.0724
260: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a16 NUMBER := 0-1962.0724
257: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a18 NUMBER := 0-1962.0724
259: , p7_a19 NUMBER := 0-1962.0724
260: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a22 NUMBER := 0-1962.0724
263: , p7_a23 NUMBER := 0-1962.0724
264: , p7_a24 NUMBER := 0-1962.0724
257: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a18 NUMBER := 0-1962.0724
259: , p7_a19 NUMBER := 0-1962.0724
260: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a22 NUMBER := 0-1962.0724
263: , p7_a23 NUMBER := 0-1962.0724
264: , p7_a24 NUMBER := 0-1962.0724
265: , p7_a25 NUMBER := 0-1962.0724
262: , p7_a22 NUMBER := 0-1962.0724
263: , p7_a23 NUMBER := 0-1962.0724
264: , p7_a24 NUMBER := 0-1962.0724
265: , p7_a25 NUMBER := 0-1962.0724
266: , p7_a26 DATE := fnd_api.g_miss_date
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a23 NUMBER := 0-1962.0724
264: , p7_a24 NUMBER := 0-1962.0724
265: , p7_a25 NUMBER := 0-1962.0724
266: , p7_a26 DATE := fnd_api.g_miss_date
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a24 NUMBER := 0-1962.0724
265: , p7_a25 NUMBER := 0-1962.0724
266: , p7_a26 DATE := fnd_api.g_miss_date
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272: , p7_a32 NUMBER := 0-1962.0724
265: , p7_a25 NUMBER := 0-1962.0724
266: , p7_a26 DATE := fnd_api.g_miss_date
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272: , p7_a32 NUMBER := 0-1962.0724
273: , p7_a33 NUMBER := 0-1962.0724
266: , p7_a26 DATE := fnd_api.g_miss_date
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272: , p7_a32 NUMBER := 0-1962.0724
273: , p7_a33 NUMBER := 0-1962.0724
274: , p7_a34 NUMBER := 0-1962.0724
267: , p7_a27 DATE := fnd_api.g_miss_date
268: , p7_a28 DATE := fnd_api.g_miss_date
269: , p7_a29 DATE := fnd_api.g_miss_date
270: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272: , p7_a32 NUMBER := 0-1962.0724
273: , p7_a33 NUMBER := 0-1962.0724
274: , p7_a34 NUMBER := 0-1962.0724
275: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
271: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
272: , p7_a32 NUMBER := 0-1962.0724
273: , p7_a33 NUMBER := 0-1962.0724
274: , p7_a34 NUMBER := 0-1962.0724
275: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
277: , p7_a37 NUMBER := 0-1962.0724
278: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a39 NUMBER := 0-1962.0724
272: , p7_a32 NUMBER := 0-1962.0724
273: , p7_a33 NUMBER := 0-1962.0724
274: , p7_a34 NUMBER := 0-1962.0724
275: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
277: , p7_a37 NUMBER := 0-1962.0724
278: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a39 NUMBER := 0-1962.0724
280: , p7_a40 NUMBER := 0-1962.0724
274: , p7_a34 NUMBER := 0-1962.0724
275: , p7_a35 VARCHAR2 := fnd_api.g_miss_char
276: , p7_a36 VARCHAR2 := fnd_api.g_miss_char
277: , p7_a37 NUMBER := 0-1962.0724
278: , p7_a38 VARCHAR2 := fnd_api.g_miss_char
279: , p7_a39 NUMBER := 0-1962.0724
280: , p7_a40 NUMBER := 0-1962.0724
281: , p7_a41 NUMBER := 0-1962.0724
282: , p7_a42 NUMBER := 0-1962.0724
279: , p7_a39 NUMBER := 0-1962.0724
280: , p7_a40 NUMBER := 0-1962.0724
281: , p7_a41 NUMBER := 0-1962.0724
282: , p7_a42 NUMBER := 0-1962.0724
283: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
280: , p7_a40 NUMBER := 0-1962.0724
281: , p7_a41 NUMBER := 0-1962.0724
282: , p7_a42 NUMBER := 0-1962.0724
283: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a48 NUMBER := 0-1962.0724
281: , p7_a41 NUMBER := 0-1962.0724
282: , p7_a42 NUMBER := 0-1962.0724
283: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a48 NUMBER := 0-1962.0724
289: , p7_a49 NUMBER := 0-1962.0724
282: , p7_a42 NUMBER := 0-1962.0724
283: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a48 NUMBER := 0-1962.0724
289: , p7_a49 NUMBER := 0-1962.0724
290: , p7_a50 NUMBER := 0-1962.0724
283: , p7_a43 VARCHAR2 := fnd_api.g_miss_char
284: , p7_a44 VARCHAR2 := fnd_api.g_miss_char
285: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
286: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
287: , p7_a47 VARCHAR2 := fnd_api.g_miss_char
288: , p7_a48 NUMBER := 0-1962.0724
289: , p7_a49 NUMBER := 0-1962.0724
290: , p7_a50 NUMBER := 0-1962.0724
291: , p7_a51 NUMBER := 0-1962.0724
288: , p7_a48 NUMBER := 0-1962.0724
289: , p7_a49 NUMBER := 0-1962.0724
290: , p7_a50 NUMBER := 0-1962.0724
291: , p7_a51 NUMBER := 0-1962.0724
292: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a53 NUMBER := 0-1962.0724
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
290: , p7_a50 NUMBER := 0-1962.0724
291: , p7_a51 NUMBER := 0-1962.0724
292: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a53 NUMBER := 0-1962.0724
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
291: , p7_a51 NUMBER := 0-1962.0724
292: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a53 NUMBER := 0-1962.0724
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a52 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a53 NUMBER := 0-1962.0724
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
293: , p7_a53 NUMBER := 0-1962.0724
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
294: , p7_a54 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
295: , p7_a55 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
296: , p7_a56 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
297: , p7_a57 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
298: , p7_a58 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
299: , p7_a59 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
300: , p7_a60 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
301: , p7_a61 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
302: , p7_a62 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a63 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
304: , p7_a64 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
305: , p7_a65 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a66 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a67 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
308: , p7_a68 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
316: , p7_a76 NUMBER := 0-1962.0724
309: , p7_a69 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
316: , p7_a76 NUMBER := 0-1962.0724
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a70 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a71 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a72 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
316: , p7_a76 NUMBER := 0-1962.0724
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a73 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
316: , p7_a76 NUMBER := 0-1962.0724
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a79 NUMBER := 0-1962.0724
320: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a74 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a75 NUMBER := 0-1962.0724
316: , p7_a76 NUMBER := 0-1962.0724
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a79 NUMBER := 0-1962.0724
320: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
322: )
316: , p7_a76 NUMBER := 0-1962.0724
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a79 NUMBER := 0-1962.0724
320: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
322: )
323:
324: as
317: , p7_a77 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a78 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a79 NUMBER := 0-1962.0724
320: , p7_a80 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a81 VARCHAR2 := fnd_api.g_miss_char
322: )
323:
324: as
325: ddp_deliv_rec ams_deliverable_pub.deliv_rec_type;