APPS.OKL_OPTION_RULES_PVT_W dependencies on FND_API

Line 56: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

52: , p5_a0 NUMBER := 0-1962.0724
53: , p5_a1 NUMBER := 0-1962.0724
54: , p5_a2 NUMBER := 0-1962.0724
55: , p5_a3 NUMBER := 0-1962.0724
56: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a6 NUMBER := 0-1962.0724
59: , p5_a7 NUMBER := 0-1962.0724
60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 57: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

53: , p5_a1 NUMBER := 0-1962.0724
54: , p5_a2 NUMBER := 0-1962.0724
55: , p5_a3 NUMBER := 0-1962.0724
56: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a6 NUMBER := 0-1962.0724
59: , p5_a7 NUMBER := 0-1962.0724
60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a9 NUMBER := 0-1962.0724

Line 60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

56: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
57: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
58: , p5_a6 NUMBER := 0-1962.0724
59: , p5_a7 NUMBER := 0-1962.0724
60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a9 NUMBER := 0-1962.0724
62: , p5_a10 DATE := fnd_api.g_miss_date
63: , p5_a11 NUMBER := 0-1962.0724
64: , p5_a12 DATE := fnd_api.g_miss_date

Line 62: , p5_a10 DATE := fnd_api.g_miss_date

58: , p5_a6 NUMBER := 0-1962.0724
59: , p5_a7 NUMBER := 0-1962.0724
60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a9 NUMBER := 0-1962.0724
62: , p5_a10 DATE := fnd_api.g_miss_date
63: , p5_a11 NUMBER := 0-1962.0724
64: , p5_a12 DATE := fnd_api.g_miss_date
65: , p5_a13 NUMBER := 0-1962.0724
66: );

Line 64: , p5_a12 DATE := fnd_api.g_miss_date

60: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
61: , p5_a9 NUMBER := 0-1962.0724
62: , p5_a10 DATE := fnd_api.g_miss_date
63: , p5_a11 NUMBER := 0-1962.0724
64: , p5_a12 DATE := fnd_api.g_miss_date
65: , p5_a13 NUMBER := 0-1962.0724
66: );
67: procedure update_option_rules(p_api_version NUMBER
68: , p_init_msg_list VARCHAR2

Line 120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 121: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

117: , p5_a1 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724
119: , p5_a3 NUMBER := 0-1962.0724
120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a9 NUMBER := 0-1962.0724

Line 124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

120: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
121: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
127: , p5_a11 NUMBER := 0-1962.0724
128: , p5_a12 DATE := fnd_api.g_miss_date

Line 126: , p5_a10 DATE := fnd_api.g_miss_date

122: , p5_a6 NUMBER := 0-1962.0724
123: , p5_a7 NUMBER := 0-1962.0724
124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
127: , p5_a11 NUMBER := 0-1962.0724
128: , p5_a12 DATE := fnd_api.g_miss_date
129: , p5_a13 NUMBER := 0-1962.0724
130: );

Line 128: , p5_a12 DATE := fnd_api.g_miss_date

124: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
125: , p5_a9 NUMBER := 0-1962.0724
126: , p5_a10 DATE := fnd_api.g_miss_date
127: , p5_a11 NUMBER := 0-1962.0724
128: , p5_a12 DATE := fnd_api.g_miss_date
129: , p5_a13 NUMBER := 0-1962.0724
130: );
131: procedure validate_option_rules(p_api_version NUMBER
132: , p_init_msg_list VARCHAR2

Line 155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 NUMBER := 0-1962.0724
154: , p5_a3 NUMBER := 0-1962.0724
155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 NUMBER := 0-1962.0724
154: , p5_a3 NUMBER := 0-1962.0724
155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a9 NUMBER := 0-1962.0724

Line 159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a9 NUMBER := 0-1962.0724
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 NUMBER := 0-1962.0724
163: , p5_a12 DATE := fnd_api.g_miss_date

Line 161: , p5_a10 DATE := fnd_api.g_miss_date

157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a9 NUMBER := 0-1962.0724
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 NUMBER := 0-1962.0724
163: , p5_a12 DATE := fnd_api.g_miss_date
164: , p5_a13 NUMBER := 0-1962.0724
165: );

Line 163: , p5_a12 DATE := fnd_api.g_miss_date

159: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
160: , p5_a9 NUMBER := 0-1962.0724
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 NUMBER := 0-1962.0724
163: , p5_a12 DATE := fnd_api.g_miss_date
164: , p5_a13 NUMBER := 0-1962.0724
165: );
166: procedure create_option_rules(p_api_version NUMBER
167: , p_init_msg_list VARCHAR2

Line 223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

219: , p5_a0 NUMBER := 0-1962.0724
220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 NUMBER := 0-1962.0724
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 NUMBER := 0-1962.0724
226: , p5_a7 NUMBER := 0-1962.0724
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

220: , p5_a1 NUMBER := 0-1962.0724
221: , p5_a2 NUMBER := 0-1962.0724
222: , p5_a3 NUMBER := 0-1962.0724
223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 NUMBER := 0-1962.0724
226: , p5_a7 NUMBER := 0-1962.0724
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724

Line 227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

223: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
224: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
225: , p5_a6 NUMBER := 0-1962.0724
226: , p5_a7 NUMBER := 0-1962.0724
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date

Line 229: , p5_a10 DATE := fnd_api.g_miss_date

225: , p5_a6 NUMBER := 0-1962.0724
226: , p5_a7 NUMBER := 0-1962.0724
227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: );

Line 231: , p5_a12 DATE := fnd_api.g_miss_date

227: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
228: , p5_a9 NUMBER := 0-1962.0724
229: , p5_a10 DATE := fnd_api.g_miss_date
230: , p5_a11 NUMBER := 0-1962.0724
231: , p5_a12 DATE := fnd_api.g_miss_date
232: , p5_a13 NUMBER := 0-1962.0724
233: );
234: procedure lock_option_rules(p_api_version NUMBER
235: , p_init_msg_list VARCHAR2

Line 263: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

259: , p5_a0 NUMBER := 0-1962.0724
260: , p5_a1 NUMBER := 0-1962.0724
261: , p5_a2 NUMBER := 0-1962.0724
262: , p5_a3 NUMBER := 0-1962.0724
263: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a6 NUMBER := 0-1962.0724
266: , p5_a7 NUMBER := 0-1962.0724
267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 264: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

260: , p5_a1 NUMBER := 0-1962.0724
261: , p5_a2 NUMBER := 0-1962.0724
262: , p5_a3 NUMBER := 0-1962.0724
263: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a6 NUMBER := 0-1962.0724
266: , p5_a7 NUMBER := 0-1962.0724
267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a9 NUMBER := 0-1962.0724

Line 267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

263: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a6 NUMBER := 0-1962.0724
266: , p5_a7 NUMBER := 0-1962.0724
267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a9 NUMBER := 0-1962.0724
269: , p5_a10 DATE := fnd_api.g_miss_date
270: , p5_a11 NUMBER := 0-1962.0724
271: , p5_a12 DATE := fnd_api.g_miss_date

Line 269: , p5_a10 DATE := fnd_api.g_miss_date

265: , p5_a6 NUMBER := 0-1962.0724
266: , p5_a7 NUMBER := 0-1962.0724
267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a9 NUMBER := 0-1962.0724
269: , p5_a10 DATE := fnd_api.g_miss_date
270: , p5_a11 NUMBER := 0-1962.0724
271: , p5_a12 DATE := fnd_api.g_miss_date
272: , p5_a13 NUMBER := 0-1962.0724
273: );

Line 271: , p5_a12 DATE := fnd_api.g_miss_date

267: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
268: , p5_a9 NUMBER := 0-1962.0724
269: , p5_a10 DATE := fnd_api.g_miss_date
270: , p5_a11 NUMBER := 0-1962.0724
271: , p5_a12 DATE := fnd_api.g_miss_date
272: , p5_a13 NUMBER := 0-1962.0724
273: );
274: procedure update_option_rules(p_api_version NUMBER
275: , p_init_msg_list VARCHAR2

Line 331: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

327: , p5_a0 NUMBER := 0-1962.0724
328: , p5_a1 NUMBER := 0-1962.0724
329: , p5_a2 NUMBER := 0-1962.0724
330: , p5_a3 NUMBER := 0-1962.0724
331: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a6 NUMBER := 0-1962.0724
334: , p5_a7 NUMBER := 0-1962.0724
335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 332: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

328: , p5_a1 NUMBER := 0-1962.0724
329: , p5_a2 NUMBER := 0-1962.0724
330: , p5_a3 NUMBER := 0-1962.0724
331: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a6 NUMBER := 0-1962.0724
334: , p5_a7 NUMBER := 0-1962.0724
335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a9 NUMBER := 0-1962.0724

Line 335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

331: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
332: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
333: , p5_a6 NUMBER := 0-1962.0724
334: , p5_a7 NUMBER := 0-1962.0724
335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a9 NUMBER := 0-1962.0724
337: , p5_a10 DATE := fnd_api.g_miss_date
338: , p5_a11 NUMBER := 0-1962.0724
339: , p5_a12 DATE := fnd_api.g_miss_date

Line 337: , p5_a10 DATE := fnd_api.g_miss_date

333: , p5_a6 NUMBER := 0-1962.0724
334: , p5_a7 NUMBER := 0-1962.0724
335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a9 NUMBER := 0-1962.0724
337: , p5_a10 DATE := fnd_api.g_miss_date
338: , p5_a11 NUMBER := 0-1962.0724
339: , p5_a12 DATE := fnd_api.g_miss_date
340: , p5_a13 NUMBER := 0-1962.0724
341: );

Line 339: , p5_a12 DATE := fnd_api.g_miss_date

335: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
336: , p5_a9 NUMBER := 0-1962.0724
337: , p5_a10 DATE := fnd_api.g_miss_date
338: , p5_a11 NUMBER := 0-1962.0724
339: , p5_a12 DATE := fnd_api.g_miss_date
340: , p5_a13 NUMBER := 0-1962.0724
341: );
342: procedure delete_option_rules(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2

Line 371: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

367: , p5_a0 NUMBER := 0-1962.0724
368: , p5_a1 NUMBER := 0-1962.0724
369: , p5_a2 NUMBER := 0-1962.0724
370: , p5_a3 NUMBER := 0-1962.0724
371: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a6 NUMBER := 0-1962.0724
374: , p5_a7 NUMBER := 0-1962.0724
375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 372: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

368: , p5_a1 NUMBER := 0-1962.0724
369: , p5_a2 NUMBER := 0-1962.0724
370: , p5_a3 NUMBER := 0-1962.0724
371: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a6 NUMBER := 0-1962.0724
374: , p5_a7 NUMBER := 0-1962.0724
375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a9 NUMBER := 0-1962.0724

Line 375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

371: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
372: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
373: , p5_a6 NUMBER := 0-1962.0724
374: , p5_a7 NUMBER := 0-1962.0724
375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a9 NUMBER := 0-1962.0724
377: , p5_a10 DATE := fnd_api.g_miss_date
378: , p5_a11 NUMBER := 0-1962.0724
379: , p5_a12 DATE := fnd_api.g_miss_date

Line 377: , p5_a10 DATE := fnd_api.g_miss_date

373: , p5_a6 NUMBER := 0-1962.0724
374: , p5_a7 NUMBER := 0-1962.0724
375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a9 NUMBER := 0-1962.0724
377: , p5_a10 DATE := fnd_api.g_miss_date
378: , p5_a11 NUMBER := 0-1962.0724
379: , p5_a12 DATE := fnd_api.g_miss_date
380: , p5_a13 NUMBER := 0-1962.0724
381: );

Line 379: , p5_a12 DATE := fnd_api.g_miss_date

375: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
376: , p5_a9 NUMBER := 0-1962.0724
377: , p5_a10 DATE := fnd_api.g_miss_date
378: , p5_a11 NUMBER := 0-1962.0724
379: , p5_a12 DATE := fnd_api.g_miss_date
380: , p5_a13 NUMBER := 0-1962.0724
381: );
382: procedure validate_option_rules(p_api_version NUMBER
383: , p_init_msg_list VARCHAR2

Line 411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

407: , p5_a0 NUMBER := 0-1962.0724
408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 NUMBER := 0-1962.0724
410: , p5_a3 NUMBER := 0-1962.0724
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 NUMBER := 0-1962.0724
414: , p5_a7 NUMBER := 0-1962.0724
415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

Line 412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

408: , p5_a1 NUMBER := 0-1962.0724
409: , p5_a2 NUMBER := 0-1962.0724
410: , p5_a3 NUMBER := 0-1962.0724
411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 NUMBER := 0-1962.0724
414: , p5_a7 NUMBER := 0-1962.0724
415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a9 NUMBER := 0-1962.0724

Line 415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

411: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
412: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
413: , p5_a6 NUMBER := 0-1962.0724
414: , p5_a7 NUMBER := 0-1962.0724
415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date

Line 417: , p5_a10 DATE := fnd_api.g_miss_date

413: , p5_a6 NUMBER := 0-1962.0724
414: , p5_a7 NUMBER := 0-1962.0724
415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: );

Line 419: , p5_a12 DATE := fnd_api.g_miss_date

415: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
416: , p5_a9 NUMBER := 0-1962.0724
417: , p5_a10 DATE := fnd_api.g_miss_date
418: , p5_a11 NUMBER := 0-1962.0724
419: , p5_a12 DATE := fnd_api.g_miss_date
420: , p5_a13 NUMBER := 0-1962.0724
421: );
422: procedure create_option_val_rules(p_api_version NUMBER
423: , p_init_msg_list VARCHAR2

Line 479: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

475: , p6_a12 out nocopy NUMBER
476: , p6_a13 out nocopy DATE
477: , p6_a14 out nocopy NUMBER
478: , p5_a0 NUMBER := 0-1962.0724
479: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a2 NUMBER := 0-1962.0724
481: , p5_a3 NUMBER := 0-1962.0724
482: , p5_a4 NUMBER := 0-1962.0724
483: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 483: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

479: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
480: , p5_a2 NUMBER := 0-1962.0724
481: , p5_a3 NUMBER := 0-1962.0724
482: , p5_a4 NUMBER := 0-1962.0724
483: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a7 NUMBER := 0-1962.0724
486: , p5_a8 NUMBER := 0-1962.0724
487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 484: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

480: , p5_a2 NUMBER := 0-1962.0724
481: , p5_a3 NUMBER := 0-1962.0724
482: , p5_a4 NUMBER := 0-1962.0724
483: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a7 NUMBER := 0-1962.0724
486: , p5_a8 NUMBER := 0-1962.0724
487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a10 NUMBER := 0-1962.0724

Line 487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

483: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
484: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
485: , p5_a7 NUMBER := 0-1962.0724
486: , p5_a8 NUMBER := 0-1962.0724
487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a10 NUMBER := 0-1962.0724
489: , p5_a11 DATE := fnd_api.g_miss_date
490: , p5_a12 NUMBER := 0-1962.0724
491: , p5_a13 DATE := fnd_api.g_miss_date

Line 489: , p5_a11 DATE := fnd_api.g_miss_date

485: , p5_a7 NUMBER := 0-1962.0724
486: , p5_a8 NUMBER := 0-1962.0724
487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a10 NUMBER := 0-1962.0724
489: , p5_a11 DATE := fnd_api.g_miss_date
490: , p5_a12 NUMBER := 0-1962.0724
491: , p5_a13 DATE := fnd_api.g_miss_date
492: , p5_a14 NUMBER := 0-1962.0724
493: );

Line 491: , p5_a13 DATE := fnd_api.g_miss_date

487: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
488: , p5_a10 NUMBER := 0-1962.0724
489: , p5_a11 DATE := fnd_api.g_miss_date
490: , p5_a12 NUMBER := 0-1962.0724
491: , p5_a13 DATE := fnd_api.g_miss_date
492: , p5_a14 NUMBER := 0-1962.0724
493: );
494: procedure lock_option_val_rules(p_api_version NUMBER
495: , p_init_msg_list VARCHAR2

Line 521: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

517: , x_return_status out nocopy VARCHAR2
518: , x_msg_count out nocopy NUMBER
519: , x_msg_data out nocopy VARCHAR2
520: , p5_a0 NUMBER := 0-1962.0724
521: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a2 NUMBER := 0-1962.0724
523: , p5_a3 NUMBER := 0-1962.0724
524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 525: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

521: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
522: , p5_a2 NUMBER := 0-1962.0724
523: , p5_a3 NUMBER := 0-1962.0724
524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 NUMBER := 0-1962.0724
529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 526: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

522: , p5_a2 NUMBER := 0-1962.0724
523: , p5_a3 NUMBER := 0-1962.0724
524: , p5_a4 NUMBER := 0-1962.0724
525: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 NUMBER := 0-1962.0724
529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a10 NUMBER := 0-1962.0724

Line 529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

525: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
526: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 NUMBER := 0-1962.0724
529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a10 NUMBER := 0-1962.0724
531: , p5_a11 DATE := fnd_api.g_miss_date
532: , p5_a12 NUMBER := 0-1962.0724
533: , p5_a13 DATE := fnd_api.g_miss_date

Line 531: , p5_a11 DATE := fnd_api.g_miss_date

527: , p5_a7 NUMBER := 0-1962.0724
528: , p5_a8 NUMBER := 0-1962.0724
529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a10 NUMBER := 0-1962.0724
531: , p5_a11 DATE := fnd_api.g_miss_date
532: , p5_a12 NUMBER := 0-1962.0724
533: , p5_a13 DATE := fnd_api.g_miss_date
534: , p5_a14 NUMBER := 0-1962.0724
535: );

Line 533: , p5_a13 DATE := fnd_api.g_miss_date

529: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
530: , p5_a10 NUMBER := 0-1962.0724
531: , p5_a11 DATE := fnd_api.g_miss_date
532: , p5_a12 NUMBER := 0-1962.0724
533: , p5_a13 DATE := fnd_api.g_miss_date
534: , p5_a14 NUMBER := 0-1962.0724
535: );
536: procedure update_option_val_rules(p_api_version NUMBER
537: , p_init_msg_list VARCHAR2

Line 593: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

589: , p6_a12 out nocopy NUMBER
590: , p6_a13 out nocopy DATE
591: , p6_a14 out nocopy NUMBER
592: , p5_a0 NUMBER := 0-1962.0724
593: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a2 NUMBER := 0-1962.0724
595: , p5_a3 NUMBER := 0-1962.0724
596: , p5_a4 NUMBER := 0-1962.0724
597: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 597: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

593: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
594: , p5_a2 NUMBER := 0-1962.0724
595: , p5_a3 NUMBER := 0-1962.0724
596: , p5_a4 NUMBER := 0-1962.0724
597: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a7 NUMBER := 0-1962.0724
600: , p5_a8 NUMBER := 0-1962.0724
601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 598: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

594: , p5_a2 NUMBER := 0-1962.0724
595: , p5_a3 NUMBER := 0-1962.0724
596: , p5_a4 NUMBER := 0-1962.0724
597: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a7 NUMBER := 0-1962.0724
600: , p5_a8 NUMBER := 0-1962.0724
601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a10 NUMBER := 0-1962.0724

Line 601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

597: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
598: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
599: , p5_a7 NUMBER := 0-1962.0724
600: , p5_a8 NUMBER := 0-1962.0724
601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a10 NUMBER := 0-1962.0724
603: , p5_a11 DATE := fnd_api.g_miss_date
604: , p5_a12 NUMBER := 0-1962.0724
605: , p5_a13 DATE := fnd_api.g_miss_date

Line 603: , p5_a11 DATE := fnd_api.g_miss_date

599: , p5_a7 NUMBER := 0-1962.0724
600: , p5_a8 NUMBER := 0-1962.0724
601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a10 NUMBER := 0-1962.0724
603: , p5_a11 DATE := fnd_api.g_miss_date
604: , p5_a12 NUMBER := 0-1962.0724
605: , p5_a13 DATE := fnd_api.g_miss_date
606: , p5_a14 NUMBER := 0-1962.0724
607: );

Line 605: , p5_a13 DATE := fnd_api.g_miss_date

601: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
602: , p5_a10 NUMBER := 0-1962.0724
603: , p5_a11 DATE := fnd_api.g_miss_date
604: , p5_a12 NUMBER := 0-1962.0724
605: , p5_a13 DATE := fnd_api.g_miss_date
606: , p5_a14 NUMBER := 0-1962.0724
607: );
608: procedure delete_option_val_rules(p_api_version NUMBER
609: , p_init_msg_list VARCHAR2

Line 635: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

631: , x_return_status out nocopy VARCHAR2
632: , x_msg_count out nocopy NUMBER
633: , x_msg_data out nocopy VARCHAR2
634: , p5_a0 NUMBER := 0-1962.0724
635: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a2 NUMBER := 0-1962.0724
637: , p5_a3 NUMBER := 0-1962.0724
638: , p5_a4 NUMBER := 0-1962.0724
639: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 639: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

635: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
636: , p5_a2 NUMBER := 0-1962.0724
637: , p5_a3 NUMBER := 0-1962.0724
638: , p5_a4 NUMBER := 0-1962.0724
639: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a7 NUMBER := 0-1962.0724
642: , p5_a8 NUMBER := 0-1962.0724
643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 640: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

636: , p5_a2 NUMBER := 0-1962.0724
637: , p5_a3 NUMBER := 0-1962.0724
638: , p5_a4 NUMBER := 0-1962.0724
639: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a7 NUMBER := 0-1962.0724
642: , p5_a8 NUMBER := 0-1962.0724
643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a10 NUMBER := 0-1962.0724

Line 643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

639: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
640: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
641: , p5_a7 NUMBER := 0-1962.0724
642: , p5_a8 NUMBER := 0-1962.0724
643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a10 NUMBER := 0-1962.0724
645: , p5_a11 DATE := fnd_api.g_miss_date
646: , p5_a12 NUMBER := 0-1962.0724
647: , p5_a13 DATE := fnd_api.g_miss_date

Line 645: , p5_a11 DATE := fnd_api.g_miss_date

641: , p5_a7 NUMBER := 0-1962.0724
642: , p5_a8 NUMBER := 0-1962.0724
643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a10 NUMBER := 0-1962.0724
645: , p5_a11 DATE := fnd_api.g_miss_date
646: , p5_a12 NUMBER := 0-1962.0724
647: , p5_a13 DATE := fnd_api.g_miss_date
648: , p5_a14 NUMBER := 0-1962.0724
649: );

Line 647: , p5_a13 DATE := fnd_api.g_miss_date

643: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
644: , p5_a10 NUMBER := 0-1962.0724
645: , p5_a11 DATE := fnd_api.g_miss_date
646: , p5_a12 NUMBER := 0-1962.0724
647: , p5_a13 DATE := fnd_api.g_miss_date
648: , p5_a14 NUMBER := 0-1962.0724
649: );
650: procedure validate_option_val_rules(p_api_version NUMBER
651: , p_init_msg_list VARCHAR2

Line 677: , p5_a1 VARCHAR2 := fnd_api.g_miss_char

673: , x_return_status out nocopy VARCHAR2
674: , x_msg_count out nocopy NUMBER
675: , x_msg_data out nocopy VARCHAR2
676: , p5_a0 NUMBER := 0-1962.0724
677: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
678: , p5_a2 NUMBER := 0-1962.0724
679: , p5_a3 NUMBER := 0-1962.0724
680: , p5_a4 NUMBER := 0-1962.0724
681: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

Line 681: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

677: , p5_a1 VARCHAR2 := fnd_api.g_miss_char
678: , p5_a2 NUMBER := 0-1962.0724
679: , p5_a3 NUMBER := 0-1962.0724
680: , p5_a4 NUMBER := 0-1962.0724
681: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
682: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a7 NUMBER := 0-1962.0724
684: , p5_a8 NUMBER := 0-1962.0724
685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 682: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

678: , p5_a2 NUMBER := 0-1962.0724
679: , p5_a3 NUMBER := 0-1962.0724
680: , p5_a4 NUMBER := 0-1962.0724
681: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
682: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a7 NUMBER := 0-1962.0724
684: , p5_a8 NUMBER := 0-1962.0724
685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a10 NUMBER := 0-1962.0724

Line 685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

681: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
682: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
683: , p5_a7 NUMBER := 0-1962.0724
684: , p5_a8 NUMBER := 0-1962.0724
685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a10 NUMBER := 0-1962.0724
687: , p5_a11 DATE := fnd_api.g_miss_date
688: , p5_a12 NUMBER := 0-1962.0724
689: , p5_a13 DATE := fnd_api.g_miss_date

Line 687: , p5_a11 DATE := fnd_api.g_miss_date

683: , p5_a7 NUMBER := 0-1962.0724
684: , p5_a8 NUMBER := 0-1962.0724
685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a10 NUMBER := 0-1962.0724
687: , p5_a11 DATE := fnd_api.g_miss_date
688: , p5_a12 NUMBER := 0-1962.0724
689: , p5_a13 DATE := fnd_api.g_miss_date
690: , p5_a14 NUMBER := 0-1962.0724
691: );

Line 689: , p5_a13 DATE := fnd_api.g_miss_date

685: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
686: , p5_a10 NUMBER := 0-1962.0724
687: , p5_a11 DATE := fnd_api.g_miss_date
688: , p5_a12 NUMBER := 0-1962.0724
689: , p5_a13 DATE := fnd_api.g_miss_date
690: , p5_a14 NUMBER := 0-1962.0724
691: );
692: end okl_option_rules_pvt_w;