75: , x_msg_count out nocopy NUMBER
76: , x_msg_data out nocopy VARCHAR2
77: , x_qualifier_id out nocopy NUMBER
78: , p7_a0 NUMBER := 0-1962.0724
79: , p7_a1 DATE := fnd_api.g_miss_date
80: , p7_a2 NUMBER := 0-1962.0724
81: , p7_a3 DATE := fnd_api.g_miss_date
82: , p7_a4 NUMBER := 0-1962.0724
83: , p7_a5 NUMBER := 0-1962.0724
77: , x_qualifier_id out nocopy NUMBER
78: , p7_a0 NUMBER := 0-1962.0724
79: , p7_a1 DATE := fnd_api.g_miss_date
80: , p7_a2 NUMBER := 0-1962.0724
81: , p7_a3 DATE := fnd_api.g_miss_date
82: , p7_a4 NUMBER := 0-1962.0724
83: , p7_a5 NUMBER := 0-1962.0724
84: , p7_a6 NUMBER := 0-1962.0724
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
81: , p7_a3 DATE := fnd_api.g_miss_date
82: , p7_a4 NUMBER := 0-1962.0724
83: , p7_a5 NUMBER := 0-1962.0724
84: , p7_a6 NUMBER := 0-1962.0724
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
82: , p7_a4 NUMBER := 0-1962.0724
83: , p7_a5 NUMBER := 0-1962.0724
84: , p7_a6 NUMBER := 0-1962.0724
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
83: , p7_a5 NUMBER := 0-1962.0724
84: , p7_a6 NUMBER := 0-1962.0724
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
84: , p7_a6 NUMBER := 0-1962.0724
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
85: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
88: , p7_a10 DATE := fnd_api.g_miss_date
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
89: , p7_a11 DATE := fnd_api.g_miss_date
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
90: , p7_a12 NUMBER := 0-1962.0724
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
91: , p7_a13 NUMBER := 0-1962.0724
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
92: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
93: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
94: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
95: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
96: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
97: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
98: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
99: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
100: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
101: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a31 NUMBER := 0-1962.0724
102: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a31 NUMBER := 0-1962.0724
110: );
103: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a31 NUMBER := 0-1962.0724
110: );
111: procedure update_offr_qual(p_api_version_number NUMBER
104: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
105: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
106: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
107: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
108: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
109: , p7_a31 NUMBER := 0-1962.0724
110: );
111: procedure update_offr_qual(p_api_version_number NUMBER
112: , p_init_msg_list VARCHAR2
115: , x_return_status out nocopy VARCHAR2
116: , x_msg_count out nocopy NUMBER
117: , x_msg_data out nocopy VARCHAR2
118: , p7_a0 NUMBER := 0-1962.0724
119: , p7_a1 DATE := fnd_api.g_miss_date
120: , p7_a2 NUMBER := 0-1962.0724
121: , p7_a3 DATE := fnd_api.g_miss_date
122: , p7_a4 NUMBER := 0-1962.0724
123: , p7_a5 NUMBER := 0-1962.0724
117: , x_msg_data out nocopy VARCHAR2
118: , p7_a0 NUMBER := 0-1962.0724
119: , p7_a1 DATE := fnd_api.g_miss_date
120: , p7_a2 NUMBER := 0-1962.0724
121: , p7_a3 DATE := fnd_api.g_miss_date
122: , p7_a4 NUMBER := 0-1962.0724
123: , p7_a5 NUMBER := 0-1962.0724
124: , p7_a6 NUMBER := 0-1962.0724
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
121: , p7_a3 DATE := fnd_api.g_miss_date
122: , p7_a4 NUMBER := 0-1962.0724
123: , p7_a5 NUMBER := 0-1962.0724
124: , p7_a6 NUMBER := 0-1962.0724
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
122: , p7_a4 NUMBER := 0-1962.0724
123: , p7_a5 NUMBER := 0-1962.0724
124: , p7_a6 NUMBER := 0-1962.0724
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
123: , p7_a5 NUMBER := 0-1962.0724
124: , p7_a6 NUMBER := 0-1962.0724
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
124: , p7_a6 NUMBER := 0-1962.0724
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
125: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
126: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
127: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
128: , p7_a10 DATE := fnd_api.g_miss_date
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a11 DATE := fnd_api.g_miss_date
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a12 NUMBER := 0-1962.0724
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a13 NUMBER := 0-1962.0724
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
132: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
133: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
134: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
135: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
136: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
137: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
138: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
139: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
140: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
141: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a31 NUMBER := 0-1962.0724
142: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a31 NUMBER := 0-1962.0724
150: );
143: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a31 NUMBER := 0-1962.0724
150: );
151: procedure validate_offr_qual(p_api_version_number NUMBER
144: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
145: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
146: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
147: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
148: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
149: , p7_a31 NUMBER := 0-1962.0724
150: );
151: procedure validate_offr_qual(p_api_version_number NUMBER
152: , p_init_msg_list VARCHAR2
155: , x_return_status out nocopy VARCHAR2
156: , x_msg_count out nocopy NUMBER
157: , x_msg_data out nocopy VARCHAR2
158: , p3_a0 NUMBER := 0-1962.0724
159: , p3_a1 DATE := fnd_api.g_miss_date
160: , p3_a2 NUMBER := 0-1962.0724
161: , p3_a3 DATE := fnd_api.g_miss_date
162: , p3_a4 NUMBER := 0-1962.0724
163: , p3_a5 NUMBER := 0-1962.0724
157: , x_msg_data out nocopy VARCHAR2
158: , p3_a0 NUMBER := 0-1962.0724
159: , p3_a1 DATE := fnd_api.g_miss_date
160: , p3_a2 NUMBER := 0-1962.0724
161: , p3_a3 DATE := fnd_api.g_miss_date
162: , p3_a4 NUMBER := 0-1962.0724
163: , p3_a5 NUMBER := 0-1962.0724
164: , p3_a6 NUMBER := 0-1962.0724
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
161: , p3_a3 DATE := fnd_api.g_miss_date
162: , p3_a4 NUMBER := 0-1962.0724
163: , p3_a5 NUMBER := 0-1962.0724
164: , p3_a6 NUMBER := 0-1962.0724
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
162: , p3_a4 NUMBER := 0-1962.0724
163: , p3_a5 NUMBER := 0-1962.0724
164: , p3_a6 NUMBER := 0-1962.0724
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
163: , p3_a5 NUMBER := 0-1962.0724
164: , p3_a6 NUMBER := 0-1962.0724
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
164: , p3_a6 NUMBER := 0-1962.0724
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
165: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
166: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
167: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
168: , p3_a10 DATE := fnd_api.g_miss_date
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
169: , p3_a11 DATE := fnd_api.g_miss_date
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
170: , p3_a12 NUMBER := 0-1962.0724
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
171: , p3_a13 NUMBER := 0-1962.0724
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
172: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
173: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
174: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
175: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
176: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
177: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
178: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
179: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
180: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
181: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
189: , p3_a31 NUMBER := 0-1962.0724
182: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
189: , p3_a31 NUMBER := 0-1962.0724
190: );
183: , p3_a25 VARCHAR2 := fnd_api.g_miss_char
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
189: , p3_a31 NUMBER := 0-1962.0724
190: );
191: procedure check_ozf_offr_qual_items(p_validation_mode VARCHAR2
184: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
185: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
186: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
187: , p3_a29 VARCHAR2 := fnd_api.g_miss_char
188: , p3_a30 VARCHAR2 := fnd_api.g_miss_char
189: , p3_a31 NUMBER := 0-1962.0724
190: );
191: procedure check_ozf_offr_qual_items(p_validation_mode VARCHAR2
192: , x_return_status out nocopy VARCHAR2
190: );
191: procedure check_ozf_offr_qual_items(p_validation_mode VARCHAR2
192: , x_return_status out nocopy VARCHAR2
193: , p0_a0 NUMBER := 0-1962.0724
194: , p0_a1 DATE := fnd_api.g_miss_date
195: , p0_a2 NUMBER := 0-1962.0724
196: , p0_a3 DATE := fnd_api.g_miss_date
197: , p0_a4 NUMBER := 0-1962.0724
198: , p0_a5 NUMBER := 0-1962.0724
192: , x_return_status out nocopy VARCHAR2
193: , p0_a0 NUMBER := 0-1962.0724
194: , p0_a1 DATE := fnd_api.g_miss_date
195: , p0_a2 NUMBER := 0-1962.0724
196: , p0_a3 DATE := fnd_api.g_miss_date
197: , p0_a4 NUMBER := 0-1962.0724
198: , p0_a5 NUMBER := 0-1962.0724
199: , p0_a6 NUMBER := 0-1962.0724
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
196: , p0_a3 DATE := fnd_api.g_miss_date
197: , p0_a4 NUMBER := 0-1962.0724
198: , p0_a5 NUMBER := 0-1962.0724
199: , p0_a6 NUMBER := 0-1962.0724
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
197: , p0_a4 NUMBER := 0-1962.0724
198: , p0_a5 NUMBER := 0-1962.0724
199: , p0_a6 NUMBER := 0-1962.0724
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
198: , p0_a5 NUMBER := 0-1962.0724
199: , p0_a6 NUMBER := 0-1962.0724
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
199: , p0_a6 NUMBER := 0-1962.0724
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
200: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
201: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
202: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
203: , p0_a10 DATE := fnd_api.g_miss_date
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
204: , p0_a11 DATE := fnd_api.g_miss_date
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
205: , p0_a12 NUMBER := 0-1962.0724
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
206: , p0_a13 NUMBER := 0-1962.0724
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
207: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
208: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
209: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
210: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
211: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
212: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
213: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
214: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
215: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
216: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a31 NUMBER := 0-1962.0724
217: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a31 NUMBER := 0-1962.0724
225: );
218: , p0_a25 VARCHAR2 := fnd_api.g_miss_char
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a31 NUMBER := 0-1962.0724
225: );
226: procedure validate_ozf_offr_qual_rec(p_api_version_number NUMBER
219: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
220: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
221: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
222: , p0_a29 VARCHAR2 := fnd_api.g_miss_char
223: , p0_a30 VARCHAR2 := fnd_api.g_miss_char
224: , p0_a31 NUMBER := 0-1962.0724
225: );
226: procedure validate_ozf_offr_qual_rec(p_api_version_number NUMBER
227: , p_init_msg_list VARCHAR2
228: , x_return_status out nocopy VARCHAR2
229: , x_msg_count out nocopy NUMBER
230: , x_msg_data out nocopy VARCHAR2
231: , p5_a0 NUMBER := 0-1962.0724
232: , p5_a1 DATE := fnd_api.g_miss_date
233: , p5_a2 NUMBER := 0-1962.0724
234: , p5_a3 DATE := fnd_api.g_miss_date
235: , p5_a4 NUMBER := 0-1962.0724
236: , p5_a5 NUMBER := 0-1962.0724
230: , x_msg_data out nocopy VARCHAR2
231: , p5_a0 NUMBER := 0-1962.0724
232: , p5_a1 DATE := fnd_api.g_miss_date
233: , p5_a2 NUMBER := 0-1962.0724
234: , p5_a3 DATE := fnd_api.g_miss_date
235: , p5_a4 NUMBER := 0-1962.0724
236: , p5_a5 NUMBER := 0-1962.0724
237: , p5_a6 NUMBER := 0-1962.0724
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a3 DATE := fnd_api.g_miss_date
235: , p5_a4 NUMBER := 0-1962.0724
236: , p5_a5 NUMBER := 0-1962.0724
237: , p5_a6 NUMBER := 0-1962.0724
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
235: , p5_a4 NUMBER := 0-1962.0724
236: , p5_a5 NUMBER := 0-1962.0724
237: , p5_a6 NUMBER := 0-1962.0724
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
236: , p5_a5 NUMBER := 0-1962.0724
237: , p5_a6 NUMBER := 0-1962.0724
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
237: , p5_a6 NUMBER := 0-1962.0724
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
238: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
241: , p5_a10 DATE := fnd_api.g_miss_date
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
242: , p5_a11 DATE := fnd_api.g_miss_date
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
243: , p5_a12 NUMBER := 0-1962.0724
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
244: , p5_a13 NUMBER := 0-1962.0724
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a31 NUMBER := 0-1962.0724
255: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a31 NUMBER := 0-1962.0724
263: );
256: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a31 NUMBER := 0-1962.0724
263: );
264: end ozf_offr_qual_pvt_w;
257: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
262: , p5_a31 NUMBER := 0-1962.0724
263: );
264: end ozf_offr_qual_pvt_w;