APPS.PV_GE_NOTIF_RULES_PVT_W dependencies on FND_API

Line 7: a number := fnd_api.g_miss_num;

3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:
6: function rosetta_g_miss_num_map(n number) return number as
7: a number := fnd_api.g_miss_num;
8: b number := 0-1962.0724;
9: begin
10: if n=a then return b; end if;
11: if n=b then return a; end if;

Line 18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;

14:
15: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
16: function rosetta_g_miss_date_in_map(d date) return date as
17: begin
18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy pv_ge_notif_rules_pvt.ge_notif_rules_tbl_type, a0 JTF_NUMBER_TABLE

Line 229: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

225: , x_msg_data out nocopy VARCHAR2
226: , x_notif_rule_id out nocopy NUMBER
227: , p7_a0 NUMBER := 0-1962.0724
228: , p7_a1 NUMBER := 0-1962.0724
229: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a3 NUMBER := 0-1962.0724
231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

Line 231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

227: , p7_a0 NUMBER := 0-1962.0724
228: , p7_a1 NUMBER := 0-1962.0724
229: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a3 NUMBER := 0-1962.0724
231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724

Line 232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

228: , p7_a1 NUMBER := 0-1962.0724
229: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a3 NUMBER := 0-1962.0724
231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

229: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
230: , p7_a3 NUMBER := 0-1962.0724
231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 NUMBER := 0-1962.0724

Line 234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

230: , p7_a3 NUMBER := 0-1962.0724
231: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 NUMBER := 0-1962.0724
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

232: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
233: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 NUMBER := 0-1962.0724
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 NUMBER := 0-1962.0724
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

234: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
235: , p7_a8 NUMBER := 0-1962.0724
236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 NUMBER := 0-1962.0724
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 NUMBER := 0-1962.0724
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 NUMBER := 0-1962.0724
242: , p7_a15 NUMBER := 0-1962.0724

Line 240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

236: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
237: , p7_a10 NUMBER := 0-1962.0724
238: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
239: , p7_a12 NUMBER := 0-1962.0724
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 NUMBER := 0-1962.0724
242: , p7_a15 NUMBER := 0-1962.0724
243: , p7_a16 DATE := fnd_api.g_miss_date
244: , p7_a17 NUMBER := 0-1962.0724

Line 243: , p7_a16 DATE := fnd_api.g_miss_date

239: , p7_a12 NUMBER := 0-1962.0724
240: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
241: , p7_a14 NUMBER := 0-1962.0724
242: , p7_a15 NUMBER := 0-1962.0724
243: , p7_a16 DATE := fnd_api.g_miss_date
244: , p7_a17 NUMBER := 0-1962.0724
245: , p7_a18 DATE := fnd_api.g_miss_date
246: , p7_a19 NUMBER := 0-1962.0724
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 245: , p7_a18 DATE := fnd_api.g_miss_date

241: , p7_a14 NUMBER := 0-1962.0724
242: , p7_a15 NUMBER := 0-1962.0724
243: , p7_a16 DATE := fnd_api.g_miss_date
244: , p7_a17 NUMBER := 0-1962.0724
245: , p7_a18 DATE := fnd_api.g_miss_date
246: , p7_a19 NUMBER := 0-1962.0724
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

243: , p7_a16 DATE := fnd_api.g_miss_date
244: , p7_a17 NUMBER := 0-1962.0724
245: , p7_a18 DATE := fnd_api.g_miss_date
246: , p7_a19 NUMBER := 0-1962.0724
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:

Line 248: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

244: , p7_a17 NUMBER := 0-1962.0724
245: , p7_a18 DATE := fnd_api.g_miss_date
246: , p7_a19 NUMBER := 0-1962.0724
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as

Line 249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

245: , p7_a18 DATE := fnd_api.g_miss_date
246: , p7_a19 NUMBER := 0-1962.0724
247: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
248: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
249: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
250: )
251:
252: as
253: ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;

Line 321: , p7_a2 VARCHAR2 := fnd_api.g_miss_char

317: , x_msg_count out nocopy NUMBER
318: , x_msg_data out nocopy VARCHAR2
319: , p7_a0 NUMBER := 0-1962.0724
320: , p7_a1 NUMBER := 0-1962.0724
321: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a3 NUMBER := 0-1962.0724
323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

Line 323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char

319: , p7_a0 NUMBER := 0-1962.0724
320: , p7_a1 NUMBER := 0-1962.0724
321: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a3 NUMBER := 0-1962.0724
323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724

Line 324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char

320: , p7_a1 NUMBER := 0-1962.0724
321: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a3 NUMBER := 0-1962.0724
323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724
328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

Line 325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char

321: , p7_a2 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a3 NUMBER := 0-1962.0724
323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724
328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a10 NUMBER := 0-1962.0724

Line 326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

322: , p7_a3 NUMBER := 0-1962.0724
323: , p7_a4 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724
328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a10 NUMBER := 0-1962.0724
330: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

324: , p7_a5 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724
328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a10 NUMBER := 0-1962.0724
330: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a12 NUMBER := 0-1962.0724
332: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 330: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

326: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a8 NUMBER := 0-1962.0724
328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a10 NUMBER := 0-1962.0724
330: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a12 NUMBER := 0-1962.0724
332: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a14 NUMBER := 0-1962.0724
334: , p7_a15 NUMBER := 0-1962.0724

Line 332: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

328: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a10 NUMBER := 0-1962.0724
330: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
331: , p7_a12 NUMBER := 0-1962.0724
332: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a14 NUMBER := 0-1962.0724
334: , p7_a15 NUMBER := 0-1962.0724
335: , p7_a16 DATE := fnd_api.g_miss_date
336: , p7_a17 NUMBER := 0-1962.0724

Line 335: , p7_a16 DATE := fnd_api.g_miss_date

331: , p7_a12 NUMBER := 0-1962.0724
332: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
333: , p7_a14 NUMBER := 0-1962.0724
334: , p7_a15 NUMBER := 0-1962.0724
335: , p7_a16 DATE := fnd_api.g_miss_date
336: , p7_a17 NUMBER := 0-1962.0724
337: , p7_a18 DATE := fnd_api.g_miss_date
338: , p7_a19 NUMBER := 0-1962.0724
339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 337: , p7_a18 DATE := fnd_api.g_miss_date

333: , p7_a14 NUMBER := 0-1962.0724
334: , p7_a15 NUMBER := 0-1962.0724
335: , p7_a16 DATE := fnd_api.g_miss_date
336: , p7_a17 NUMBER := 0-1962.0724
337: , p7_a18 DATE := fnd_api.g_miss_date
338: , p7_a19 NUMBER := 0-1962.0724
339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

335: , p7_a16 DATE := fnd_api.g_miss_date
336: , p7_a17 NUMBER := 0-1962.0724
337: , p7_a18 DATE := fnd_api.g_miss_date
338: , p7_a19 NUMBER := 0-1962.0724
339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
342: )
343:

Line 340: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

336: , p7_a17 NUMBER := 0-1962.0724
337: , p7_a18 DATE := fnd_api.g_miss_date
338: , p7_a19 NUMBER := 0-1962.0724
339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
342: )
343:
344: as

Line 341: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

337: , p7_a18 DATE := fnd_api.g_miss_date
338: , p7_a19 NUMBER := 0-1962.0724
339: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
340: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
341: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
342: )
343:
344: as
345: ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;

Line 410: , p3_a2 VARCHAR2 := fnd_api.g_miss_char

406: , x_msg_count out nocopy NUMBER
407: , x_msg_data out nocopy VARCHAR2
408: , p3_a0 NUMBER := 0-1962.0724
409: , p3_a1 NUMBER := 0-1962.0724
410: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
411: , p3_a3 NUMBER := 0-1962.0724
412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

Line 412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char

408: , p3_a0 NUMBER := 0-1962.0724
409: , p3_a1 NUMBER := 0-1962.0724
410: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
411: , p3_a3 NUMBER := 0-1962.0724
412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724

Line 413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char

409: , p3_a1 NUMBER := 0-1962.0724
410: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
411: , p3_a3 NUMBER := 0-1962.0724
412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724
417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

Line 414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char

410: , p3_a2 VARCHAR2 := fnd_api.g_miss_char
411: , p3_a3 NUMBER := 0-1962.0724
412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724
417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418: , p3_a10 NUMBER := 0-1962.0724

Line 415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

411: , p3_a3 NUMBER := 0-1962.0724
412: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724
417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418: , p3_a10 NUMBER := 0-1962.0724
419: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

413: , p3_a5 VARCHAR2 := fnd_api.g_miss_char
414: , p3_a6 VARCHAR2 := fnd_api.g_miss_char
415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724
417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418: , p3_a10 NUMBER := 0-1962.0724
419: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p3_a12 NUMBER := 0-1962.0724
421: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

Line 419: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

415: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
416: , p3_a8 NUMBER := 0-1962.0724
417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418: , p3_a10 NUMBER := 0-1962.0724
419: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p3_a12 NUMBER := 0-1962.0724
421: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p3_a14 NUMBER := 0-1962.0724
423: , p3_a15 NUMBER := 0-1962.0724

Line 421: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

417: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
418: , p3_a10 NUMBER := 0-1962.0724
419: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
420: , p3_a12 NUMBER := 0-1962.0724
421: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p3_a14 NUMBER := 0-1962.0724
423: , p3_a15 NUMBER := 0-1962.0724
424: , p3_a16 DATE := fnd_api.g_miss_date
425: , p3_a17 NUMBER := 0-1962.0724

Line 424: , p3_a16 DATE := fnd_api.g_miss_date

420: , p3_a12 NUMBER := 0-1962.0724
421: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
422: , p3_a14 NUMBER := 0-1962.0724
423: , p3_a15 NUMBER := 0-1962.0724
424: , p3_a16 DATE := fnd_api.g_miss_date
425: , p3_a17 NUMBER := 0-1962.0724
426: , p3_a18 DATE := fnd_api.g_miss_date
427: , p3_a19 NUMBER := 0-1962.0724
428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

Line 426: , p3_a18 DATE := fnd_api.g_miss_date

422: , p3_a14 NUMBER := 0-1962.0724
423: , p3_a15 NUMBER := 0-1962.0724
424: , p3_a16 DATE := fnd_api.g_miss_date
425: , p3_a17 NUMBER := 0-1962.0724
426: , p3_a18 DATE := fnd_api.g_miss_date
427: , p3_a19 NUMBER := 0-1962.0724
428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

Line 428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

424: , p3_a16 DATE := fnd_api.g_miss_date
425: , p3_a17 NUMBER := 0-1962.0724
426: , p3_a18 DATE := fnd_api.g_miss_date
427: , p3_a19 NUMBER := 0-1962.0724
428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
431: )
432:

Line 429: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

425: , p3_a17 NUMBER := 0-1962.0724
426: , p3_a18 DATE := fnd_api.g_miss_date
427: , p3_a19 NUMBER := 0-1962.0724
428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
431: )
432:
433: as

Line 430: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

426: , p3_a18 DATE := fnd_api.g_miss_date
427: , p3_a19 NUMBER := 0-1962.0724
428: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
431: )
432:
433: as
434: ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;

Line 494: , p0_a2 VARCHAR2 := fnd_api.g_miss_char

490: procedure check_ge_notif_rules_items(p_validation_mode VARCHAR2
491: , x_return_status out nocopy VARCHAR2
492: , p0_a0 NUMBER := 0-1962.0724
493: , p0_a1 NUMBER := 0-1962.0724
494: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
495: , p0_a3 NUMBER := 0-1962.0724
496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

Line 496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char

492: , p0_a0 NUMBER := 0-1962.0724
493: , p0_a1 NUMBER := 0-1962.0724
494: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
495: , p0_a3 NUMBER := 0-1962.0724
496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724

Line 497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char

493: , p0_a1 NUMBER := 0-1962.0724
494: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
495: , p0_a3 NUMBER := 0-1962.0724
496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724
501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

Line 498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char

494: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
495: , p0_a3 NUMBER := 0-1962.0724
496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724
501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a10 NUMBER := 0-1962.0724

Line 499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

495: , p0_a3 NUMBER := 0-1962.0724
496: , p0_a4 VARCHAR2 := fnd_api.g_miss_char
497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724
501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a10 NUMBER := 0-1962.0724
503: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

497: , p0_a5 VARCHAR2 := fnd_api.g_miss_char
498: , p0_a6 VARCHAR2 := fnd_api.g_miss_char
499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724
501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a10 NUMBER := 0-1962.0724
503: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
504: , p0_a12 NUMBER := 0-1962.0724
505: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 503: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

499: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
500: , p0_a8 NUMBER := 0-1962.0724
501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a10 NUMBER := 0-1962.0724
503: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
504: , p0_a12 NUMBER := 0-1962.0724
505: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a14 NUMBER := 0-1962.0724
507: , p0_a15 NUMBER := 0-1962.0724

Line 505: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

501: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
502: , p0_a10 NUMBER := 0-1962.0724
503: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
504: , p0_a12 NUMBER := 0-1962.0724
505: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a14 NUMBER := 0-1962.0724
507: , p0_a15 NUMBER := 0-1962.0724
508: , p0_a16 DATE := fnd_api.g_miss_date
509: , p0_a17 NUMBER := 0-1962.0724

Line 508: , p0_a16 DATE := fnd_api.g_miss_date

504: , p0_a12 NUMBER := 0-1962.0724
505: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
506: , p0_a14 NUMBER := 0-1962.0724
507: , p0_a15 NUMBER := 0-1962.0724
508: , p0_a16 DATE := fnd_api.g_miss_date
509: , p0_a17 NUMBER := 0-1962.0724
510: , p0_a18 DATE := fnd_api.g_miss_date
511: , p0_a19 NUMBER := 0-1962.0724
512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 510: , p0_a18 DATE := fnd_api.g_miss_date

506: , p0_a14 NUMBER := 0-1962.0724
507: , p0_a15 NUMBER := 0-1962.0724
508: , p0_a16 DATE := fnd_api.g_miss_date
509: , p0_a17 NUMBER := 0-1962.0724
510: , p0_a18 DATE := fnd_api.g_miss_date
511: , p0_a19 NUMBER := 0-1962.0724
512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

508: , p0_a16 DATE := fnd_api.g_miss_date
509: , p0_a17 NUMBER := 0-1962.0724
510: , p0_a18 DATE := fnd_api.g_miss_date
511: , p0_a19 NUMBER := 0-1962.0724
512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
515: )
516:

Line 513: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

509: , p0_a17 NUMBER := 0-1962.0724
510: , p0_a18 DATE := fnd_api.g_miss_date
511: , p0_a19 NUMBER := 0-1962.0724
512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
515: )
516:
517: as

Line 514: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

510: , p0_a18 DATE := fnd_api.g_miss_date
511: , p0_a19 NUMBER := 0-1962.0724
512: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
513: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
514: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
515: )
516:
517: as
518: ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;

Line 566: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

562: , x_msg_count out nocopy NUMBER
563: , x_msg_data out nocopy VARCHAR2
564: , p5_a0 NUMBER := 0-1962.0724
565: , p5_a1 NUMBER := 0-1962.0724
566: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a3 NUMBER := 0-1962.0724
568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

Line 568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char

564: , p5_a0 NUMBER := 0-1962.0724
565: , p5_a1 NUMBER := 0-1962.0724
566: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a3 NUMBER := 0-1962.0724
568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724

Line 569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char

565: , p5_a1 NUMBER := 0-1962.0724
566: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a3 NUMBER := 0-1962.0724
568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724
573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

Line 570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char

566: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
567: , p5_a3 NUMBER := 0-1962.0724
568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724
573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a10 NUMBER := 0-1962.0724

Line 571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

567: , p5_a3 NUMBER := 0-1962.0724
568: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724
573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a10 NUMBER := 0-1962.0724
575: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

569: , p5_a5 VARCHAR2 := fnd_api.g_miss_char
570: , p5_a6 VARCHAR2 := fnd_api.g_miss_char
571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724
573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a10 NUMBER := 0-1962.0724
575: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a12 NUMBER := 0-1962.0724
577: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

Line 575: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

571: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
572: , p5_a8 NUMBER := 0-1962.0724
573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a10 NUMBER := 0-1962.0724
575: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a12 NUMBER := 0-1962.0724
577: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a14 NUMBER := 0-1962.0724
579: , p5_a15 NUMBER := 0-1962.0724

Line 577: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

573: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
574: , p5_a10 NUMBER := 0-1962.0724
575: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
576: , p5_a12 NUMBER := 0-1962.0724
577: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a14 NUMBER := 0-1962.0724
579: , p5_a15 NUMBER := 0-1962.0724
580: , p5_a16 DATE := fnd_api.g_miss_date
581: , p5_a17 NUMBER := 0-1962.0724

Line 580: , p5_a16 DATE := fnd_api.g_miss_date

576: , p5_a12 NUMBER := 0-1962.0724
577: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
578: , p5_a14 NUMBER := 0-1962.0724
579: , p5_a15 NUMBER := 0-1962.0724
580: , p5_a16 DATE := fnd_api.g_miss_date
581: , p5_a17 NUMBER := 0-1962.0724
582: , p5_a18 DATE := fnd_api.g_miss_date
583: , p5_a19 NUMBER := 0-1962.0724
584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 582: , p5_a18 DATE := fnd_api.g_miss_date

578: , p5_a14 NUMBER := 0-1962.0724
579: , p5_a15 NUMBER := 0-1962.0724
580: , p5_a16 DATE := fnd_api.g_miss_date
581: , p5_a17 NUMBER := 0-1962.0724
582: , p5_a18 DATE := fnd_api.g_miss_date
583: , p5_a19 NUMBER := 0-1962.0724
584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

580: , p5_a16 DATE := fnd_api.g_miss_date
581: , p5_a17 NUMBER := 0-1962.0724
582: , p5_a18 DATE := fnd_api.g_miss_date
583: , p5_a19 NUMBER := 0-1962.0724
584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
587: )
588:

Line 585: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

581: , p5_a17 NUMBER := 0-1962.0724
582: , p5_a18 DATE := fnd_api.g_miss_date
583: , p5_a19 NUMBER := 0-1962.0724
584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
587: )
588:
589: as

Line 586: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

582: , p5_a18 DATE := fnd_api.g_miss_date
583: , p5_a19 NUMBER := 0-1962.0724
584: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
585: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
586: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
587: )
588:
589: as
590: ddp_ge_notif_rules_rec pv_ge_notif_rules_pvt.ge_notif_rules_rec_type;