[Home] [Help]
1: package body ams_cat_activity_pvt_w as
2: /* $Header: amswcacb.pls 120.1 2005/11/23 05:22 vmodur noship $ */
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:
18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ams_cat_activity_pvt.cat_activity_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE
85: end loop;
86: end if;
87: end if;
88: end rosetta_table_copy_in_p3;
89: procedure rosetta_table_copy_out_p3(t ams_cat_activity_pvt.cat_activity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
90: , a1 out nocopy JTF_NUMBER_TABLE
91: , a2 out nocopy JTF_NUMBER_TABLE
92: , a3 out nocopy JTF_NUMBER_TABLE
93: , a4 out nocopy JTF_DATE_TABLE
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;
270: ddindx binary_integer; indx binary_integer;
271: begin
272:
273: -- copy data to the local IN or IN-OUT args, if any
305: ddp_cat_activity_rec.attribute15 := p7_a24;
306:
307:
308: -- here's the delegated call to the old PL/SQL routine
309: ams_cat_activity_pvt.create_cat_activity(p_api_version_number,
310: p_init_msg_list,
311: p_commit,
312: p_validation_level,
313: x_return_status,
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;
367: ddindx binary_integer; indx binary_integer;
368: begin
369:
370: -- copy data to the local IN or IN-OUT args, if any
402: ddp_cat_activity_rec.attribute15 := p7_a24;
403:
404:
405: -- here's the delegated call to the old PL/SQL routine
406: ams_cat_activity_pvt.update_cat_activity(p_api_version_number,
407: p_init_msg_list,
408: p_commit,
409: p_validation_level,
410: x_return_status,
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;
462: ddindx binary_integer; indx binary_integer;
463: begin
464:
465: -- copy data to the local IN or IN-OUT args, if any
495:
496:
497:
498: -- here's the delegated call to the old PL/SQL routine
499: ams_cat_activity_pvt.validate_cat_activity(p_api_version_number,
500: p_init_msg_list,
501: p_validation_level,
502: ddp_cat_activity_rec,
503: x_return_status,
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;
547: ddindx binary_integer; indx binary_integer;
548: begin
549:
550: -- copy data to the local IN or IN-OUT args, if any
576:
577:
578:
579: -- here's the delegated call to the old PL/SQL routine
580: ams_cat_activity_pvt.check_cat_activity_items(ddp_cat_activity_rec,
581: p_validation_mode,
582: x_return_status);
583:
584: -- copy data back from the local variables to OUT or IN-OUT args, if any
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;
623: ddindx binary_integer; indx binary_integer;
624: begin
625:
626: -- copy data to the local IN or IN-OUT args, if any
655: ddp_cat_activity_rec.attribute14 := p5_a23;
656: ddp_cat_activity_rec.attribute15 := p5_a24;
657:
658: -- here's the delegated call to the old PL/SQL routine
659: ams_cat_activity_pvt.validate_cat_activity_rec(p_api_version_number,
660: p_init_msg_list,
661: x_return_status,
662: x_msg_count,
663: x_msg_data,
670:
671:
672: end;
673:
674: end ams_cat_activity_pvt_w;