APPS.AMS_CAT_ACTIVITY_PVT_W dependencies on FND_API

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

5:
6: -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7: function rosetta_g_miss_date_in_map(d date) return date as
8: begin
9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as

Line 14: a number := fnd_api.g_miss_num;

10: return d;
11: end;
12:
13: function rosetta_g_miss_num_map(n number) return number as
14: a number := fnd_api.g_miss_num;
15: b number := 0-1962.0724;
16: begin
17: if n=a then return b; end if;
18: if n=b then return a; end if;

Line 245: , p7_a4 DATE := fnd_api.g_miss_date

241: , p7_a0 NUMBER := 0-1962.0724
242: , p7_a1 NUMBER := 0-1962.0724
243: , p7_a2 NUMBER := 0-1962.0724
244: , p7_a3 NUMBER := 0-1962.0724
245: , p7_a4 DATE := fnd_api.g_miss_date
246: , p7_a5 NUMBER := 0-1962.0724
247: , p7_a6 DATE := fnd_api.g_miss_date
248: , p7_a7 NUMBER := 0-1962.0724
249: , p7_a8 NUMBER := 0-1962.0724

Line 247: , p7_a6 DATE := fnd_api.g_miss_date

243: , p7_a2 NUMBER := 0-1962.0724
244: , p7_a3 NUMBER := 0-1962.0724
245: , p7_a4 DATE := fnd_api.g_miss_date
246: , p7_a5 NUMBER := 0-1962.0724
247: , p7_a6 DATE := fnd_api.g_miss_date
248: , p7_a7 NUMBER := 0-1962.0724
249: , p7_a8 NUMBER := 0-1962.0724
250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

Line 250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

246: , p7_a5 NUMBER := 0-1962.0724
247: , p7_a6 DATE := fnd_api.g_miss_date
248: , p7_a7 NUMBER := 0-1962.0724
249: , p7_a8 NUMBER := 0-1962.0724
250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

247: , p7_a6 DATE := fnd_api.g_miss_date
248: , p7_a7 NUMBER := 0-1962.0724
249: , p7_a8 NUMBER := 0-1962.0724
250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

248: , p7_a7 NUMBER := 0-1962.0724
249: , p7_a8 NUMBER := 0-1962.0724
250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

249: , p7_a8 NUMBER := 0-1962.0724
250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

250: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

251: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

252: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

253: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

254: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

255: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

256: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

257: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

258: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
266: )

Line 263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

259: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
266: )
267:

Line 264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

260: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
266: )
267:
268: as

Line 265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

261: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
262: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
263: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
264: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
265: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
266: )
267:
268: as
269: ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;

Line 342: , p7_a4 DATE := fnd_api.g_miss_date

338: , p7_a0 NUMBER := 0-1962.0724
339: , p7_a1 NUMBER := 0-1962.0724
340: , p7_a2 NUMBER := 0-1962.0724
341: , p7_a3 NUMBER := 0-1962.0724
342: , p7_a4 DATE := fnd_api.g_miss_date
343: , p7_a5 NUMBER := 0-1962.0724
344: , p7_a6 DATE := fnd_api.g_miss_date
345: , p7_a7 NUMBER := 0-1962.0724
346: , p7_a8 NUMBER := 0-1962.0724

Line 344: , p7_a6 DATE := fnd_api.g_miss_date

340: , p7_a2 NUMBER := 0-1962.0724
341: , p7_a3 NUMBER := 0-1962.0724
342: , p7_a4 DATE := fnd_api.g_miss_date
343: , p7_a5 NUMBER := 0-1962.0724
344: , p7_a6 DATE := fnd_api.g_miss_date
345: , p7_a7 NUMBER := 0-1962.0724
346: , p7_a8 NUMBER := 0-1962.0724
347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

Line 347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

343: , p7_a5 NUMBER := 0-1962.0724
344: , p7_a6 DATE := fnd_api.g_miss_date
345: , p7_a7 NUMBER := 0-1962.0724
346: , p7_a8 NUMBER := 0-1962.0724
347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

Line 348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

344: , p7_a6 DATE := fnd_api.g_miss_date
345: , p7_a7 NUMBER := 0-1962.0724
346: , p7_a8 NUMBER := 0-1962.0724
347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

345: , p7_a7 NUMBER := 0-1962.0724
346: , p7_a8 NUMBER := 0-1962.0724
347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

346: , p7_a8 NUMBER := 0-1962.0724
347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char

347: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

Line 352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

348: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

349: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

Line 354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

350: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

Line 355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char

351: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

Line 356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

352: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

Line 357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

353: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

Line 358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char

354: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

Line 359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char

355: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
363: )

Line 360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char

356: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
363: )
364:

Line 361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char

357: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
363: )
364:
365: as

Line 362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char

358: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
359: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
360: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
361: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
362: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
363: )
364:
365: as
366: ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;

Line 437: , p3_a4 DATE := fnd_api.g_miss_date

433: , p3_a0 NUMBER := 0-1962.0724
434: , p3_a1 NUMBER := 0-1962.0724
435: , p3_a2 NUMBER := 0-1962.0724
436: , p3_a3 NUMBER := 0-1962.0724
437: , p3_a4 DATE := fnd_api.g_miss_date
438: , p3_a5 NUMBER := 0-1962.0724
439: , p3_a6 DATE := fnd_api.g_miss_date
440: , p3_a7 NUMBER := 0-1962.0724
441: , p3_a8 NUMBER := 0-1962.0724

Line 439: , p3_a6 DATE := fnd_api.g_miss_date

435: , p3_a2 NUMBER := 0-1962.0724
436: , p3_a3 NUMBER := 0-1962.0724
437: , p3_a4 DATE := fnd_api.g_miss_date
438: , p3_a5 NUMBER := 0-1962.0724
439: , p3_a6 DATE := fnd_api.g_miss_date
440: , p3_a7 NUMBER := 0-1962.0724
441: , p3_a8 NUMBER := 0-1962.0724
442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

Line 442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

438: , p3_a5 NUMBER := 0-1962.0724
439: , p3_a6 DATE := fnd_api.g_miss_date
440: , p3_a7 NUMBER := 0-1962.0724
441: , p3_a8 NUMBER := 0-1962.0724
442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

Line 443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

439: , p3_a6 DATE := fnd_api.g_miss_date
440: , p3_a7 NUMBER := 0-1962.0724
441: , p3_a8 NUMBER := 0-1962.0724
442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char

Line 444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

440: , p3_a7 NUMBER := 0-1962.0724
441: , p3_a8 NUMBER := 0-1962.0724
442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

Line 445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

441: , p3_a8 NUMBER := 0-1962.0724
442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char

Line 446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char

442: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

Line 447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char

443: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

Line 448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char

444: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

Line 449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char

445: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

Line 450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char

446: , p3_a13 VARCHAR2 := fnd_api.g_miss_char
447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

Line 451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char

447: , p3_a14 VARCHAR2 := fnd_api.g_miss_char
448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

Line 452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char

448: , p3_a15 VARCHAR2 := fnd_api.g_miss_char
449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

Line 453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char

449: , p3_a16 VARCHAR2 := fnd_api.g_miss_char
450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

Line 454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char

450: , p3_a17 VARCHAR2 := fnd_api.g_miss_char
451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
458: )

Line 455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char

451: , p3_a18 VARCHAR2 := fnd_api.g_miss_char
452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
458: )
459:

Line 456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char

452: , p3_a19 VARCHAR2 := fnd_api.g_miss_char
453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
458: )
459:
460: as

Line 457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char

453: , p3_a20 VARCHAR2 := fnd_api.g_miss_char
454: , p3_a21 VARCHAR2 := fnd_api.g_miss_char
455: , p3_a22 VARCHAR2 := fnd_api.g_miss_char
456: , p3_a23 VARCHAR2 := fnd_api.g_miss_char
457: , p3_a24 VARCHAR2 := fnd_api.g_miss_char
458: )
459:
460: as
461: ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;

Line 522: , p0_a4 DATE := fnd_api.g_miss_date

518: , p0_a0 NUMBER := 0-1962.0724
519: , p0_a1 NUMBER := 0-1962.0724
520: , p0_a2 NUMBER := 0-1962.0724
521: , p0_a3 NUMBER := 0-1962.0724
522: , p0_a4 DATE := fnd_api.g_miss_date
523: , p0_a5 NUMBER := 0-1962.0724
524: , p0_a6 DATE := fnd_api.g_miss_date
525: , p0_a7 NUMBER := 0-1962.0724
526: , p0_a8 NUMBER := 0-1962.0724

Line 524: , p0_a6 DATE := fnd_api.g_miss_date

520: , p0_a2 NUMBER := 0-1962.0724
521: , p0_a3 NUMBER := 0-1962.0724
522: , p0_a4 DATE := fnd_api.g_miss_date
523: , p0_a5 NUMBER := 0-1962.0724
524: , p0_a6 DATE := fnd_api.g_miss_date
525: , p0_a7 NUMBER := 0-1962.0724
526: , p0_a8 NUMBER := 0-1962.0724
527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

Line 527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

523: , p0_a5 NUMBER := 0-1962.0724
524: , p0_a6 DATE := fnd_api.g_miss_date
525: , p0_a7 NUMBER := 0-1962.0724
526: , p0_a8 NUMBER := 0-1962.0724
527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

Line 528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

524: , p0_a6 DATE := fnd_api.g_miss_date
525: , p0_a7 NUMBER := 0-1962.0724
526: , p0_a8 NUMBER := 0-1962.0724
527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

525: , p0_a7 NUMBER := 0-1962.0724
526: , p0_a8 NUMBER := 0-1962.0724
527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

526: , p0_a8 NUMBER := 0-1962.0724
527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char

527: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

Line 532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

528: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

529: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

Line 534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

530: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

Line 535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char

531: , p0_a13 VARCHAR2 := fnd_api.g_miss_char
532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

Line 536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

532: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

Line 537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

533: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

Line 538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char

534: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

Line 539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char

535: , p0_a17 VARCHAR2 := fnd_api.g_miss_char
536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
543: )

Line 540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char

536: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
543: )
544:

Line 541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char

537: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
543: )
544:
545: as

Line 542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char

538: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
539: , p0_a21 VARCHAR2 := fnd_api.g_miss_char
540: , p0_a22 VARCHAR2 := fnd_api.g_miss_char
541: , p0_a23 VARCHAR2 := fnd_api.g_miss_char
542: , p0_a24 VARCHAR2 := fnd_api.g_miss_char
543: )
544:
545: as
546: ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;

Line 598: , p5_a4 DATE := fnd_api.g_miss_date

594: , p5_a0 NUMBER := 0-1962.0724
595: , p5_a1 NUMBER := 0-1962.0724
596: , p5_a2 NUMBER := 0-1962.0724
597: , p5_a3 NUMBER := 0-1962.0724
598: , p5_a4 DATE := fnd_api.g_miss_date
599: , p5_a5 NUMBER := 0-1962.0724
600: , p5_a6 DATE := fnd_api.g_miss_date
601: , p5_a7 NUMBER := 0-1962.0724
602: , p5_a8 NUMBER := 0-1962.0724

Line 600: , p5_a6 DATE := fnd_api.g_miss_date

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

Line 603: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 604: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

601: , p5_a7 NUMBER := 0-1962.0724
602: , p5_a8 NUMBER := 0-1962.0724
603: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

Line 606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

602: , p5_a8 NUMBER := 0-1962.0724
603: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

Line 607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char

603: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
604: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

Line 608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char

604: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

Line 609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char

605: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

Line 610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char

606: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

Line 611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char

607: , p5_a13 VARCHAR2 := fnd_api.g_miss_char
608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

Line 612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char

608: , p5_a14 VARCHAR2 := fnd_api.g_miss_char
609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

Line 613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char

609: , p5_a15 VARCHAR2 := fnd_api.g_miss_char
610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

Line 614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char

610: , p5_a16 VARCHAR2 := fnd_api.g_miss_char
611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

Line 615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char

611: , p5_a17 VARCHAR2 := fnd_api.g_miss_char
612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
619: )

Line 616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char

612: , p5_a18 VARCHAR2 := fnd_api.g_miss_char
613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
619: )
620:

Line 617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char

613: , p5_a19 VARCHAR2 := fnd_api.g_miss_char
614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
619: )
620:
621: as

Line 618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char

614: , p5_a20 VARCHAR2 := fnd_api.g_miss_char
615: , p5_a21 VARCHAR2 := fnd_api.g_miss_char
616: , p5_a22 VARCHAR2 := fnd_api.g_miss_char
617: , p5_a23 VARCHAR2 := fnd_api.g_miss_char
618: , p5_a24 VARCHAR2 := fnd_api.g_miss_char
619: )
620:
621: as
622: ddp_cat_activity_rec ams_cat_activity_pvt.cat_activity_rec_type;