APPS.OKL_INS_PRODUCTS_PUB_W dependencies on FND_API

Line 136: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

132: , p6_a38 out nocopy DATE
133: , p6_a39 out nocopy NUMBER
134: , p5_a0 NUMBER := 0-1962.0724
135: , p5_a1 NUMBER := 0-1962.0724
136: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a3 NUMBER := 0-1962.0724
138: , p5_a4 NUMBER := 0-1962.0724
139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

135: , p5_a1 NUMBER := 0-1962.0724
136: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a3 NUMBER := 0-1962.0724
138: , p5_a4 NUMBER := 0-1962.0724
139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date

Line 140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

136: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a3 NUMBER := 0-1962.0724
138: , p5_a4 NUMBER := 0-1962.0724
139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724

Line 141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

137: , p5_a3 NUMBER := 0-1962.0724
138: , p5_a4 NUMBER := 0-1962.0724
139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724
145: , p5_a11 DATE := fnd_api.g_miss_date

Line 143: , p5_a9 DATE := fnd_api.g_miss_date

139: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
140: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724
145: , p5_a11 DATE := fnd_api.g_miss_date
146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 145: , p5_a11 DATE := fnd_api.g_miss_date

141: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724
145: , p5_a11 DATE := fnd_api.g_miss_date
146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a14 NUMBER := 0-1962.0724
149: , p5_a15 NUMBER := 0-1962.0724

Line 146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

142: , p5_a8 NUMBER := 0-1962.0724
143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724
145: , p5_a11 DATE := fnd_api.g_miss_date
146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a14 NUMBER := 0-1962.0724
149: , p5_a15 NUMBER := 0-1962.0724
150: , p5_a16 NUMBER := 0-1962.0724

Line 147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

143: , p5_a9 DATE := fnd_api.g_miss_date
144: , p5_a10 NUMBER := 0-1962.0724
145: , p5_a11 DATE := fnd_api.g_miss_date
146: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
147: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
148: , p5_a14 NUMBER := 0-1962.0724
149: , p5_a15 NUMBER := 0-1962.0724
150: , p5_a16 NUMBER := 0-1962.0724
151: , p5_a17 NUMBER := 0-1962.0724

Line 152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

148: , p5_a14 NUMBER := 0-1962.0724
149: , p5_a15 NUMBER := 0-1962.0724
150: , p5_a16 NUMBER := 0-1962.0724
151: , p5_a17 NUMBER := 0-1962.0724
152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

149: , p5_a15 NUMBER := 0-1962.0724
150: , p5_a16 NUMBER := 0-1962.0724
151: , p5_a17 NUMBER := 0-1962.0724
152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

150: , p5_a16 NUMBER := 0-1962.0724
151: , p5_a17 NUMBER := 0-1962.0724
152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

151: , p5_a17 NUMBER := 0-1962.0724
152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

152: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

153: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

154: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

155: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

156: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

157: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

158: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

159: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

160: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

161: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724

Line 166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

162: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724
170: , p5_a36 DATE := fnd_api.g_miss_date

Line 167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

163: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724
170: , p5_a36 DATE := fnd_api.g_miss_date
171: , p5_a37 NUMBER := 0-1962.0724

Line 168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

164: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
165: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724
170: , p5_a36 DATE := fnd_api.g_miss_date
171: , p5_a37 NUMBER := 0-1962.0724
172: , p5_a38 DATE := fnd_api.g_miss_date

Line 170: , p5_a36 DATE := fnd_api.g_miss_date

166: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
167: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724
170: , p5_a36 DATE := fnd_api.g_miss_date
171: , p5_a37 NUMBER := 0-1962.0724
172: , p5_a38 DATE := fnd_api.g_miss_date
173: , p5_a39 NUMBER := 0-1962.0724
174: );

Line 172: , p5_a38 DATE := fnd_api.g_miss_date

168: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
169: , p5_a35 NUMBER := 0-1962.0724
170: , p5_a36 DATE := fnd_api.g_miss_date
171: , p5_a37 NUMBER := 0-1962.0724
172: , p5_a38 DATE := fnd_api.g_miss_date
173: , p5_a39 NUMBER := 0-1962.0724
174: );
175: procedure lock_ins_products(p_api_version NUMBER
176: , p_init_msg_list VARCHAR2

Line 228: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

224: , x_msg_count out nocopy NUMBER
225: , x_msg_data out nocopy VARCHAR2
226: , p5_a0 NUMBER := 0-1962.0724
227: , p5_a1 NUMBER := 0-1962.0724
228: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a3 NUMBER := 0-1962.0724
230: , p5_a4 NUMBER := 0-1962.0724
231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

227: , p5_a1 NUMBER := 0-1962.0724
228: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a3 NUMBER := 0-1962.0724
230: , p5_a4 NUMBER := 0-1962.0724
231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date

Line 232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

228: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
229: , p5_a3 NUMBER := 0-1962.0724
230: , p5_a4 NUMBER := 0-1962.0724
231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724

Line 233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

229: , p5_a3 NUMBER := 0-1962.0724
230: , p5_a4 NUMBER := 0-1962.0724
231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724
237: , p5_a11 DATE := fnd_api.g_miss_date

Line 235: , p5_a9 DATE := fnd_api.g_miss_date

231: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
232: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724
237: , p5_a11 DATE := fnd_api.g_miss_date
238: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 237: , p5_a11 DATE := fnd_api.g_miss_date

233: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724
237: , p5_a11 DATE := fnd_api.g_miss_date
238: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a14 NUMBER := 0-1962.0724
241: , p5_a15 NUMBER := 0-1962.0724

Line 238: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

234: , p5_a8 NUMBER := 0-1962.0724
235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724
237: , p5_a11 DATE := fnd_api.g_miss_date
238: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a14 NUMBER := 0-1962.0724
241: , p5_a15 NUMBER := 0-1962.0724
242: , p5_a16 NUMBER := 0-1962.0724

Line 239: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

235: , p5_a9 DATE := fnd_api.g_miss_date
236: , p5_a10 NUMBER := 0-1962.0724
237: , p5_a11 DATE := fnd_api.g_miss_date
238: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
239: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
240: , p5_a14 NUMBER := 0-1962.0724
241: , p5_a15 NUMBER := 0-1962.0724
242: , p5_a16 NUMBER := 0-1962.0724
243: , p5_a17 NUMBER := 0-1962.0724

Line 244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

240: , p5_a14 NUMBER := 0-1962.0724
241: , p5_a15 NUMBER := 0-1962.0724
242: , p5_a16 NUMBER := 0-1962.0724
243: , p5_a17 NUMBER := 0-1962.0724
244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

241: , p5_a15 NUMBER := 0-1962.0724
242: , p5_a16 NUMBER := 0-1962.0724
243: , p5_a17 NUMBER := 0-1962.0724
244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

242: , p5_a16 NUMBER := 0-1962.0724
243: , p5_a17 NUMBER := 0-1962.0724
244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

243: , p5_a17 NUMBER := 0-1962.0724
244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

244: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

245: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

246: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

247: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

248: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

249: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

250: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

251: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

252: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

253: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724

Line 258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

254: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724
262: , p5_a36 DATE := fnd_api.g_miss_date

Line 259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

255: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724
262: , p5_a36 DATE := fnd_api.g_miss_date
263: , p5_a37 NUMBER := 0-1962.0724

Line 260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

256: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
257: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724
262: , p5_a36 DATE := fnd_api.g_miss_date
263: , p5_a37 NUMBER := 0-1962.0724
264: , p5_a38 DATE := fnd_api.g_miss_date

Line 262: , p5_a36 DATE := fnd_api.g_miss_date

258: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
259: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724
262: , p5_a36 DATE := fnd_api.g_miss_date
263: , p5_a37 NUMBER := 0-1962.0724
264: , p5_a38 DATE := fnd_api.g_miss_date
265: , p5_a39 NUMBER := 0-1962.0724
266: );

Line 264: , p5_a38 DATE := fnd_api.g_miss_date

260: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
261: , p5_a35 NUMBER := 0-1962.0724
262: , p5_a36 DATE := fnd_api.g_miss_date
263: , p5_a37 NUMBER := 0-1962.0724
264: , p5_a38 DATE := fnd_api.g_miss_date
265: , p5_a39 NUMBER := 0-1962.0724
266: );
267: procedure update_ins_products(p_api_version NUMBER
268: , p_init_msg_list VARCHAR2

Line 400: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

396: , p6_a38 out nocopy DATE
397: , p6_a39 out nocopy NUMBER
398: , p5_a0 NUMBER := 0-1962.0724
399: , p5_a1 NUMBER := 0-1962.0724
400: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a3 NUMBER := 0-1962.0724
402: , p5_a4 NUMBER := 0-1962.0724
403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

399: , p5_a1 NUMBER := 0-1962.0724
400: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a3 NUMBER := 0-1962.0724
402: , p5_a4 NUMBER := 0-1962.0724
403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date

Line 404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

400: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
401: , p5_a3 NUMBER := 0-1962.0724
402: , p5_a4 NUMBER := 0-1962.0724
403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724

Line 405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

401: , p5_a3 NUMBER := 0-1962.0724
402: , p5_a4 NUMBER := 0-1962.0724
403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724
409: , p5_a11 DATE := fnd_api.g_miss_date

Line 407: , p5_a9 DATE := fnd_api.g_miss_date

403: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
404: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724
409: , p5_a11 DATE := fnd_api.g_miss_date
410: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 409: , p5_a11 DATE := fnd_api.g_miss_date

405: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724
409: , p5_a11 DATE := fnd_api.g_miss_date
410: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a14 NUMBER := 0-1962.0724
413: , p5_a15 NUMBER := 0-1962.0724

Line 410: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

406: , p5_a8 NUMBER := 0-1962.0724
407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724
409: , p5_a11 DATE := fnd_api.g_miss_date
410: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a14 NUMBER := 0-1962.0724
413: , p5_a15 NUMBER := 0-1962.0724
414: , p5_a16 NUMBER := 0-1962.0724

Line 411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

407: , p5_a9 DATE := fnd_api.g_miss_date
408: , p5_a10 NUMBER := 0-1962.0724
409: , p5_a11 DATE := fnd_api.g_miss_date
410: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
411: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a14 NUMBER := 0-1962.0724
413: , p5_a15 NUMBER := 0-1962.0724
414: , p5_a16 NUMBER := 0-1962.0724
415: , p5_a17 NUMBER := 0-1962.0724

Line 416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

412: , p5_a14 NUMBER := 0-1962.0724
413: , p5_a15 NUMBER := 0-1962.0724
414: , p5_a16 NUMBER := 0-1962.0724
415: , p5_a17 NUMBER := 0-1962.0724
416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

413: , p5_a15 NUMBER := 0-1962.0724
414: , p5_a16 NUMBER := 0-1962.0724
415: , p5_a17 NUMBER := 0-1962.0724
416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

414: , p5_a16 NUMBER := 0-1962.0724
415: , p5_a17 NUMBER := 0-1962.0724
416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

415: , p5_a17 NUMBER := 0-1962.0724
416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

416: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

417: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

418: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

419: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

420: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

421: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

422: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

423: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

424: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724

Line 430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724
434: , p5_a36 DATE := fnd_api.g_miss_date

Line 431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

427: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724
434: , p5_a36 DATE := fnd_api.g_miss_date
435: , p5_a37 NUMBER := 0-1962.0724

Line 432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

428: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
429: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724
434: , p5_a36 DATE := fnd_api.g_miss_date
435: , p5_a37 NUMBER := 0-1962.0724
436: , p5_a38 DATE := fnd_api.g_miss_date

Line 434: , p5_a36 DATE := fnd_api.g_miss_date

430: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
431: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724
434: , p5_a36 DATE := fnd_api.g_miss_date
435: , p5_a37 NUMBER := 0-1962.0724
436: , p5_a38 DATE := fnd_api.g_miss_date
437: , p5_a39 NUMBER := 0-1962.0724
438: );

Line 436: , p5_a38 DATE := fnd_api.g_miss_date

432: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
433: , p5_a35 NUMBER := 0-1962.0724
434: , p5_a36 DATE := fnd_api.g_miss_date
435: , p5_a37 NUMBER := 0-1962.0724
436: , p5_a38 DATE := fnd_api.g_miss_date
437: , p5_a39 NUMBER := 0-1962.0724
438: );
439: procedure delete_ins_products(p_api_version NUMBER
440: , p_init_msg_list VARCHAR2

Line 492: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

488: , x_msg_count out nocopy NUMBER
489: , x_msg_data out nocopy VARCHAR2
490: , p5_a0 NUMBER := 0-1962.0724
491: , p5_a1 NUMBER := 0-1962.0724
492: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a3 NUMBER := 0-1962.0724
494: , p5_a4 NUMBER := 0-1962.0724
495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

491: , p5_a1 NUMBER := 0-1962.0724
492: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a3 NUMBER := 0-1962.0724
494: , p5_a4 NUMBER := 0-1962.0724
495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date

Line 496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

492: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
493: , p5_a3 NUMBER := 0-1962.0724
494: , p5_a4 NUMBER := 0-1962.0724
495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724

Line 497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

493: , p5_a3 NUMBER := 0-1962.0724
494: , p5_a4 NUMBER := 0-1962.0724
495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724
501: , p5_a11 DATE := fnd_api.g_miss_date

Line 499: , p5_a9 DATE := fnd_api.g_miss_date

495: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
496: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724
501: , p5_a11 DATE := fnd_api.g_miss_date
502: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 501: , p5_a11 DATE := fnd_api.g_miss_date

497: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724
501: , p5_a11 DATE := fnd_api.g_miss_date
502: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a14 NUMBER := 0-1962.0724
505: , p5_a15 NUMBER := 0-1962.0724

Line 502: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

498: , p5_a8 NUMBER := 0-1962.0724
499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724
501: , p5_a11 DATE := fnd_api.g_miss_date
502: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a14 NUMBER := 0-1962.0724
505: , p5_a15 NUMBER := 0-1962.0724
506: , p5_a16 NUMBER := 0-1962.0724

Line 503: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

499: , p5_a9 DATE := fnd_api.g_miss_date
500: , p5_a10 NUMBER := 0-1962.0724
501: , p5_a11 DATE := fnd_api.g_miss_date
502: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
503: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
504: , p5_a14 NUMBER := 0-1962.0724
505: , p5_a15 NUMBER := 0-1962.0724
506: , p5_a16 NUMBER := 0-1962.0724
507: , p5_a17 NUMBER := 0-1962.0724

Line 508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

504: , p5_a14 NUMBER := 0-1962.0724
505: , p5_a15 NUMBER := 0-1962.0724
506: , p5_a16 NUMBER := 0-1962.0724
507: , p5_a17 NUMBER := 0-1962.0724
508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

505: , p5_a15 NUMBER := 0-1962.0724
506: , p5_a16 NUMBER := 0-1962.0724
507: , p5_a17 NUMBER := 0-1962.0724
508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

506: , p5_a16 NUMBER := 0-1962.0724
507: , p5_a17 NUMBER := 0-1962.0724
508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

507: , p5_a17 NUMBER := 0-1962.0724
508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

508: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

509: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

510: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

511: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

512: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

513: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

514: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

515: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

516: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

517: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724

Line 522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

518: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724
526: , p5_a36 DATE := fnd_api.g_miss_date

Line 523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

519: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724
526: , p5_a36 DATE := fnd_api.g_miss_date
527: , p5_a37 NUMBER := 0-1962.0724

Line 524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

520: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
521: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724
526: , p5_a36 DATE := fnd_api.g_miss_date
527: , p5_a37 NUMBER := 0-1962.0724
528: , p5_a38 DATE := fnd_api.g_miss_date

Line 526: , p5_a36 DATE := fnd_api.g_miss_date

522: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
523: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724
526: , p5_a36 DATE := fnd_api.g_miss_date
527: , p5_a37 NUMBER := 0-1962.0724
528: , p5_a38 DATE := fnd_api.g_miss_date
529: , p5_a39 NUMBER := 0-1962.0724
530: );

Line 528: , p5_a38 DATE := fnd_api.g_miss_date

524: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
525: , p5_a35 NUMBER := 0-1962.0724
526: , p5_a36 DATE := fnd_api.g_miss_date
527: , p5_a37 NUMBER := 0-1962.0724
528: , p5_a38 DATE := fnd_api.g_miss_date
529: , p5_a39 NUMBER := 0-1962.0724
530: );
531: procedure validate_ins_products(p_api_version NUMBER
532: , p_init_msg_list VARCHAR2

Line 584: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

580: , x_msg_count out nocopy NUMBER
581: , x_msg_data out nocopy VARCHAR2
582: , p5_a0 NUMBER := 0-1962.0724
583: , p5_a1 NUMBER := 0-1962.0724
584: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a3 NUMBER := 0-1962.0724
586: , p5_a4 NUMBER := 0-1962.0724
587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

583: , p5_a1 NUMBER := 0-1962.0724
584: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a3 NUMBER := 0-1962.0724
586: , p5_a4 NUMBER := 0-1962.0724
587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date

Line 588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

584: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a3 NUMBER := 0-1962.0724
586: , p5_a4 NUMBER := 0-1962.0724
587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724

Line 589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

585: , p5_a3 NUMBER := 0-1962.0724
586: , p5_a4 NUMBER := 0-1962.0724
587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724
593: , p5_a11 DATE := fnd_api.g_miss_date

Line 591: , p5_a9 DATE := fnd_api.g_miss_date

587: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
588: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724
593: , p5_a11 DATE := fnd_api.g_miss_date
594: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 593: , p5_a11 DATE := fnd_api.g_miss_date

589: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724
593: , p5_a11 DATE := fnd_api.g_miss_date
594: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a14 NUMBER := 0-1962.0724
597: , p5_a15 NUMBER := 0-1962.0724

Line 594: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

590: , p5_a8 NUMBER := 0-1962.0724
591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724
593: , p5_a11 DATE := fnd_api.g_miss_date
594: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a14 NUMBER := 0-1962.0724
597: , p5_a15 NUMBER := 0-1962.0724
598: , p5_a16 NUMBER := 0-1962.0724

Line 595: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

591: , p5_a9 DATE := fnd_api.g_miss_date
592: , p5_a10 NUMBER := 0-1962.0724
593: , p5_a11 DATE := fnd_api.g_miss_date
594: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
595: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
596: , p5_a14 NUMBER := 0-1962.0724
597: , p5_a15 NUMBER := 0-1962.0724
598: , p5_a16 NUMBER := 0-1962.0724
599: , p5_a17 NUMBER := 0-1962.0724

Line 600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

596: , p5_a14 NUMBER := 0-1962.0724
597: , p5_a15 NUMBER := 0-1962.0724
598: , p5_a16 NUMBER := 0-1962.0724
599: , p5_a17 NUMBER := 0-1962.0724
600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

597: , p5_a15 NUMBER := 0-1962.0724
598: , p5_a16 NUMBER := 0-1962.0724
599: , p5_a17 NUMBER := 0-1962.0724
600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

598: , p5_a16 NUMBER := 0-1962.0724
599: , p5_a17 NUMBER := 0-1962.0724
600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

599: , p5_a17 NUMBER := 0-1962.0724
600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

Line 604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

600: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

Line 605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

601: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

Line 606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

602: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

Line 607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char

603: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

Line 608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char

604: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char

605: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

Line 610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char

606: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

Line 611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char

607: , p5_a25 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

Line 612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char

608: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

Line 613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char

609: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724

Line 614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char

610: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724
618: , p5_a36 DATE := fnd_api.g_miss_date

Line 615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char

611: , p5_a29 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724
618: , p5_a36 DATE := fnd_api.g_miss_date
619: , p5_a37 NUMBER := 0-1962.0724

Line 616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char

612: , p5_a30 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a31 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724
618: , p5_a36 DATE := fnd_api.g_miss_date
619: , p5_a37 NUMBER := 0-1962.0724
620: , p5_a38 DATE := fnd_api.g_miss_date

Line 618: , p5_a36 DATE := fnd_api.g_miss_date

614: , p5_a32 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a33 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724
618: , p5_a36 DATE := fnd_api.g_miss_date
619: , p5_a37 NUMBER := 0-1962.0724
620: , p5_a38 DATE := fnd_api.g_miss_date
621: , p5_a39 NUMBER := 0-1962.0724
622: );

Line 620: , p5_a38 DATE := fnd_api.g_miss_date

616: , p5_a34 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a35 NUMBER := 0-1962.0724
618: , p5_a36 DATE := fnd_api.g_miss_date
619: , p5_a37 NUMBER := 0-1962.0724
620: , p5_a38 DATE := fnd_api.g_miss_date
621: , p5_a39 NUMBER := 0-1962.0724
622: );
623: end okl_ins_products_pub_w;