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;
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_p3(t OUT NOCOPY ams_actresource_pub.act_resource_rec_tbl, a0 JTF_NUMBER_TABLE
294: , x_msg_count OUT NOCOPY NUMBER
295: , x_msg_data OUT NOCOPY VARCHAR2
296: , x_act_resource_id OUT NOCOPY NUMBER
297: , p7_a0 NUMBER := 0-1962.0724
298: , p7_a1 DATE := fnd_api.g_miss_date
299: , p7_a2 NUMBER := 0-1962.0724
300: , p7_a3 DATE := fnd_api.g_miss_date
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724
296: , x_act_resource_id OUT NOCOPY NUMBER
297: , p7_a0 NUMBER := 0-1962.0724
298: , p7_a1 DATE := fnd_api.g_miss_date
299: , p7_a2 NUMBER := 0-1962.0724
300: , p7_a3 DATE := fnd_api.g_miss_date
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724
303: , p7_a6 NUMBER := 0-1962.0724
304: , p7_a7 NUMBER := 0-1962.0724
301: , p7_a4 NUMBER := 0-1962.0724
302: , p7_a5 NUMBER := 0-1962.0724
303: , p7_a6 NUMBER := 0-1962.0724
304: , p7_a7 NUMBER := 0-1962.0724
305: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
303: , p7_a6 NUMBER := 0-1962.0724
304: , p7_a7 NUMBER := 0-1962.0724
305: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
305: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
306: , p7_a9 NUMBER := 0-1962.0724
307: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
307: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
308: , p7_a11 NUMBER := 0-1962.0724
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
309: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
310: , p7_a13 DATE := fnd_api.g_miss_date
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
311: , p7_a14 DATE := fnd_api.g_miss_date
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
312: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
313: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
314: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
315: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
316: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
317: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
318: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
319: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
320: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
321: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
322: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
323: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
324: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
332: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
325: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
326: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
327: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
328: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
329: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
330: )
331: as
332: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
333: ddindx binary_integer; indx binary_integer;
405: , x_return_status OUT NOCOPY VARCHAR2
406: , x_msg_count OUT NOCOPY NUMBER
407: , x_msg_data OUT NOCOPY VARCHAR2
408: , p7_a0 NUMBER := 0-1962.0724
409: , p7_a1 DATE := fnd_api.g_miss_date
410: , p7_a2 NUMBER := 0-1962.0724
411: , p7_a3 DATE := fnd_api.g_miss_date
412: , p7_a4 NUMBER := 0-1962.0724
413: , p7_a5 NUMBER := 0-1962.0724
407: , x_msg_data OUT NOCOPY VARCHAR2
408: , p7_a0 NUMBER := 0-1962.0724
409: , p7_a1 DATE := fnd_api.g_miss_date
410: , p7_a2 NUMBER := 0-1962.0724
411: , p7_a3 DATE := fnd_api.g_miss_date
412: , p7_a4 NUMBER := 0-1962.0724
413: , p7_a5 NUMBER := 0-1962.0724
414: , p7_a6 NUMBER := 0-1962.0724
415: , p7_a7 NUMBER := 0-1962.0724
412: , p7_a4 NUMBER := 0-1962.0724
413: , p7_a5 NUMBER := 0-1962.0724
414: , p7_a6 NUMBER := 0-1962.0724
415: , p7_a7 NUMBER := 0-1962.0724
416: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a9 NUMBER := 0-1962.0724
418: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
414: , p7_a6 NUMBER := 0-1962.0724
415: , p7_a7 NUMBER := 0-1962.0724
416: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a9 NUMBER := 0-1962.0724
418: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
416: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a9 NUMBER := 0-1962.0724
418: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
417: , p7_a9 NUMBER := 0-1962.0724
418: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
418: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
419: , p7_a11 NUMBER := 0-1962.0724
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
420: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
421: , p7_a13 DATE := fnd_api.g_miss_date
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
422: , p7_a14 DATE := fnd_api.g_miss_date
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
423: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
424: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
425: , p7_a17 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
426: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
427: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
428: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
429: , p7_a21 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
430: , p7_a22 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
431: , p7_a23 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
432: , p7_a24 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
433: , p7_a25 VARCHAR2 := fnd_api.g_miss_char
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
441: )
434: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
441: )
442: as
435: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
441: )
442: as
443: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
436: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
437: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
438: , p7_a30 VARCHAR2 := fnd_api.g_miss_char
439: , p7_a31 VARCHAR2 := fnd_api.g_miss_char
440: , p7_a32 VARCHAR2 := fnd_api.g_miss_char
441: )
442: as
443: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
444: ddindx binary_integer; indx binary_integer;
512: , x_return_status OUT NOCOPY VARCHAR2
513: , x_msg_count OUT NOCOPY NUMBER
514: , x_msg_data OUT NOCOPY VARCHAR2
515: , p6_a0 NUMBER := 0-1962.0724
516: , p6_a1 DATE := fnd_api.g_miss_date
517: , p6_a2 NUMBER := 0-1962.0724
518: , p6_a3 DATE := fnd_api.g_miss_date
519: , p6_a4 NUMBER := 0-1962.0724
520: , p6_a5 NUMBER := 0-1962.0724
514: , x_msg_data OUT NOCOPY VARCHAR2
515: , p6_a0 NUMBER := 0-1962.0724
516: , p6_a1 DATE := fnd_api.g_miss_date
517: , p6_a2 NUMBER := 0-1962.0724
518: , p6_a3 DATE := fnd_api.g_miss_date
519: , p6_a4 NUMBER := 0-1962.0724
520: , p6_a5 NUMBER := 0-1962.0724
521: , p6_a6 NUMBER := 0-1962.0724
522: , p6_a7 NUMBER := 0-1962.0724
519: , p6_a4 NUMBER := 0-1962.0724
520: , p6_a5 NUMBER := 0-1962.0724
521: , p6_a6 NUMBER := 0-1962.0724
522: , p6_a7 NUMBER := 0-1962.0724
523: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
524: , p6_a9 NUMBER := 0-1962.0724
525: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
521: , p6_a6 NUMBER := 0-1962.0724
522: , p6_a7 NUMBER := 0-1962.0724
523: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
524: , p6_a9 NUMBER := 0-1962.0724
525: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
523: , p6_a8 VARCHAR2 := fnd_api.g_miss_char
524: , p6_a9 NUMBER := 0-1962.0724
525: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
524: , p6_a9 NUMBER := 0-1962.0724
525: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
525: , p6_a10 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
526: , p6_a11 NUMBER := 0-1962.0724
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
527: , p6_a12 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
528: , p6_a13 DATE := fnd_api.g_miss_date
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
529: , p6_a14 DATE := fnd_api.g_miss_date
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
530: , p6_a15 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
531: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
532: , p6_a17 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
533: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
534: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
535: , p6_a20 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
536: , p6_a21 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
537: , p6_a22 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
538: , p6_a23 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
539: , p6_a24 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
547: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
540: , p6_a25 VARCHAR2 := fnd_api.g_miss_char
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
547: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
548: )
541: , p6_a26 VARCHAR2 := fnd_api.g_miss_char
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
547: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
548: )
549: as
542: , p6_a27 VARCHAR2 := fnd_api.g_miss_char
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
547: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
548: )
549: as
550: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
543: , p6_a28 VARCHAR2 := fnd_api.g_miss_char
544: , p6_a29 VARCHAR2 := fnd_api.g_miss_char
545: , p6_a30 VARCHAR2 := fnd_api.g_miss_char
546: , p6_a31 VARCHAR2 := fnd_api.g_miss_char
547: , p6_a32 VARCHAR2 := fnd_api.g_miss_char
548: )
549: as
550: ddp_act_resource_rec ams_actresource_pub.act_resource_rec_type;
551: ddindx binary_integer; indx binary_integer;