DBA Data[Home] [Help]

APPS.AMS_ACT_LIST_PVT_W dependencies on AMS_ACT_LIST_PVT

Line 1: package body ams_act_list_pvt_w as

1: package body ams_act_list_pvt_w as
2: /* $Header: amswalsb.pls 120.1 2005/06/27 05:42:33 appldev ship $ */
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:

Line 22: procedure rosetta_table_copy_in_p1(t OUT NOCOPY ams_act_list_pvt.child_type, a0 JTF_VARCHAR2_TABLE_100) as

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_p1(t OUT NOCOPY ams_act_list_pvt.child_type, a0 JTF_VARCHAR2_TABLE_100) as
23: ddindx binary_integer; indx binary_integer;
24: begin
25: if a0 is not null and a0.count > 0 then
26: if a0.count > 0 then

Line 40: procedure rosetta_table_copy_out_p1(t ams_act_list_pvt.child_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100) as

36: end loop;
37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t ams_act_list_pvt.child_type, a0 OUT NOCOPY JTF_VARCHAR2_TABLE_100) as
41: ddindx binary_integer; indx binary_integer;
42: begin
43: if t is null or t.count = 0 then
44: a0 := JTF_VARCHAR2_TABLE_100();

Line 63: procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE

59: end if;
60: end if;
61: end rosetta_table_copy_out_p1;
62:
63: procedure rosetta_table_copy_in_p4(t OUT NOCOPY ams_act_list_pvt.act_list_tbl_type, a0 JTF_NUMBER_TABLE
64: , a1 JTF_DATE_TABLE
65: , a2 JTF_NUMBER_TABLE
66: , a3 JTF_DATE_TABLE
67: , a4 JTF_NUMBER_TABLE

Line 108: procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

104: end loop;
105: end if;
106: end if;
107: end rosetta_table_copy_in_p4;
108: procedure rosetta_table_copy_out_p4(t ams_act_list_pvt.act_list_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
109: , a1 OUT NOCOPY JTF_DATE_TABLE
110: , a2 OUT NOCOPY JTF_NUMBER_TABLE
111: , a3 OUT NOCOPY JTF_DATE_TABLE
112: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 221: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

217: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
218: , p7_a13 NUMBER := 0-1962.0724
219: )
220: as
221: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
222: ddindx binary_integer; indx binary_integer;
223: begin
224:
225: -- copy data to the local IN or IN-OUT args, if any

Line 250: ams_act_list_pvt.create_act_list(p_api_version_number,

246: ddp_act_list_rec.order_number := rosetta_g_miss_num_map(p7_a13);
247:
248:
249: -- here's the delegated call to the old PL/SQL routine
250: ams_act_list_pvt.create_act_list(p_api_version_number,
251: p_init_msg_list,
252: p_commit,
253: p_validation_level,
254: x_return_status,

Line 295: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

291: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
292: , p7_a13 NUMBER := 0-1962.0724
293: )
294: as
295: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
296: ddindx binary_integer; indx binary_integer;
297: begin
298:
299: -- copy data to the local IN or IN-OUT args, if any

Line 324: ams_act_list_pvt.update_act_list(p_api_version_number,

320: ddp_act_list_rec.order_number := rosetta_g_miss_num_map(p7_a13);
321:
322:
323: -- here's the delegated call to the old PL/SQL routine
324: ams_act_list_pvt.update_act_list(p_api_version_number,
325: p_init_msg_list,
326: p_commit,
327: p_validation_level,
328: x_return_status,

Line 367: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

363: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
364: , p3_a13 NUMBER := 0-1962.0724
365: )
366: as
367: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
368: ddindx binary_integer; indx binary_integer;
369: begin
370:
371: -- copy data to the local IN or IN-OUT args, if any

Line 394: ams_act_list_pvt.validate_act_list(p_api_version_number,

390:
391:
392:
393: -- here's the delegated call to the old PL/SQL routine
394: ams_act_list_pvt.validate_act_list(p_api_version_number,
395: p_init_msg_list,
396: p_validation_level,
397: ddp_act_list_rec,
398: x_return_status,

Line 429: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

425: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
426: , p0_a13 NUMBER := 0-1962.0724
427: )
428: as
429: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
430: ddindx binary_integer; indx binary_integer;
431: begin
432:
433: -- copy data to the local IN or IN-OUT args, if any

Line 452: ams_act_list_pvt.check_act_list_items(ddp_act_list_rec,

448:
449:
450:
451: -- here's the delegated call to the old PL/SQL routine
452: ams_act_list_pvt.check_act_list_items(ddp_act_list_rec,
453: p_validation_mode,
454: x_return_status);
455:
456: -- copy data back from the local OUT or IN-OUT args, if any

Line 482: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

478: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
479: , p5_a13 NUMBER := 0-1962.0724
480: )
481: as
482: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
483: ddindx binary_integer; indx binary_integer;
484: begin
485:
486: -- copy data to the local IN or IN-OUT args, if any

Line 508: ams_act_list_pvt.validate_act_list_rec(p_api_version_number,

504: ddp_act_list_rec.list_action_type := p5_a12;
505: ddp_act_list_rec.order_number := rosetta_g_miss_num_map(p5_a13);
506:
507: -- here's the delegated call to the old PL/SQL routine
508: ams_act_list_pvt.validate_act_list_rec(p_api_version_number,
509: p_init_msg_list,
510: x_return_status,
511: x_msg_count,
512: x_msg_data,

Line 539: ddx_act_list_rec ams_act_list_pvt.act_list_rec_type;

535: , p0_a12 OUT NOCOPY VARCHAR2
536: , p0_a13 OUT NOCOPY NUMBER
537: )
538: as
539: ddx_act_list_rec ams_act_list_pvt.act_list_rec_type;
540: ddindx binary_integer; indx binary_integer;
541: begin
542:
543: -- copy data to the local IN or IN-OUT args, if any

Line 546: ams_act_list_pvt.init_act_list_rec(ddx_act_list_rec);

542:
543: -- copy data to the local IN or IN-OUT args, if any
544:
545: -- here's the delegated call to the old PL/SQL routine
546: ams_act_list_pvt.init_act_list_rec(ddx_act_list_rec);
547:
548: -- copy data back from the local OUT or IN-OUT args, if any
549: p0_a0 := rosetta_g_miss_num_map(ddx_act_list_rec.act_list_header_id);
550: p0_a1 := ddx_act_list_rec.last_update_date;

Line 595: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;

591: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
592: , p0_a13 NUMBER := 0-1962.0724
593: )
594: as
595: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
596: ddx_complete_rec ams_act_list_pvt.act_list_rec_type;
597: ddindx binary_integer; indx binary_integer;
598: begin
599:

Line 596: ddx_complete_rec ams_act_list_pvt.act_list_rec_type;

592: , p0_a13 NUMBER := 0-1962.0724
593: )
594: as
595: ddp_act_list_rec ams_act_list_pvt.act_list_rec_type;
596: ddx_complete_rec ams_act_list_pvt.act_list_rec_type;
597: ddindx binary_integer; indx binary_integer;
598: begin
599:
600: -- copy data to the local IN or IN-OUT args, if any

Line 618: ams_act_list_pvt.complete_act_list_rec(ddp_act_list_rec,

614: ddp_act_list_rec.order_number := rosetta_g_miss_num_map(p0_a13);
615:
616:
617: -- here's the delegated call to the old PL/SQL routine
618: ams_act_list_pvt.complete_act_list_rec(ddp_act_list_rec,
619: ddx_complete_rec);
620:
621: -- copy data back from the local OUT or IN-OUT args, if any
622:

Line 639: end ams_act_list_pvt_w;

635: p1_a12 := ddx_complete_rec.list_action_type;
636: p1_a13 := rosetta_g_miss_num_map(ddx_complete_rec.order_number);
637: end;
638:
639: end ams_act_list_pvt_w;