DBA Data[Home] [Help]

APPS.AMS_DM_SCORE_PVT_W dependencies on AMS_DM_SCORE_PVT

Line 1: package body ams_dm_score_pvt_w as

1: package body ams_dm_score_pvt_w as
2: /* $Header: amswdmsb.pls 120.1 2005/06/15 23:58:32 appldev $ */
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_p3(t OUT NOCOPY ams_dm_score_pvt.dm_score_tbl_type, a0 JTF_NUMBER_TABLE

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_dm_score_pvt.dm_score_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 133: procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

129: end loop;
130: end if;
131: end if;
132: end rosetta_table_copy_in_p3;
133: procedure rosetta_table_copy_out_p3(t ams_dm_score_pvt.dm_score_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
134: , a1 OUT NOCOPY JTF_DATE_TABLE
135: , a2 OUT NOCOPY JTF_NUMBER_TABLE
136: , a3 OUT NOCOPY JTF_DATE_TABLE
137: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 438: ddp_score_rec ams_dm_score_pvt.score_rec_type;

434: , p0_a45 VARCHAR2 := fnd_api.g_miss_char
435: , p0_a46 VARCHAR2 := fnd_api.g_miss_char
436: )
437: as
438: ddp_score_rec ams_dm_score_pvt.score_rec_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:
442: -- copy data to the local IN or IN-OUT args, if any

Line 494: ams_dm_score_pvt.check_score_items(ddp_score_rec,

490:
491:
492:
493: -- here's the delegated call to the old PL/SQL routine
494: ams_dm_score_pvt.check_score_items(ddp_score_rec,
495: p_validation_mode,
496: x_return_status);
497:
498: -- copy data back from the local OUT or IN-OUT args, if any

Line 561: ddp_score_rec ams_dm_score_pvt.score_rec_type;

557: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
558: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
559: )
560: as
561: ddp_score_rec ams_dm_score_pvt.score_rec_type;
562: ddindx binary_integer; indx binary_integer;
563: begin
564:
565: -- copy data to the local IN or IN-OUT args, if any

Line 624: ams_dm_score_pvt.create_score(p_api_version,

620:
621:
622:
623: -- here's the delegated call to the old PL/SQL routine
624: ams_dm_score_pvt.create_score(p_api_version,
625: p_init_msg_list,
626: p_commit,
627: p_validation_level,
628: x_return_status,

Line 704: ddp_score_rec ams_dm_score_pvt.score_rec_type;

700: , p7_a45 VARCHAR2 := fnd_api.g_miss_char
701: , p7_a46 VARCHAR2 := fnd_api.g_miss_char
702: )
703: as
704: ddp_score_rec ams_dm_score_pvt.score_rec_type;
705: ddindx binary_integer; indx binary_integer;
706: begin
707:
708: -- copy data to the local IN or IN-OUT args, if any

Line 766: ams_dm_score_pvt.update_score(p_api_version,

762: ddp_score_rec.attribute15 := p7_a46;
763:
764:
765: -- here's the delegated call to the old PL/SQL routine
766: ams_dm_score_pvt.update_score(p_api_version,
767: p_init_msg_list,
768: p_commit,
769: p_validation_level,
770: x_return_status,

Line 842: ddp_score_rec ams_dm_score_pvt.score_rec_type;

838: , p6_a45 VARCHAR2 := fnd_api.g_miss_char
839: , p6_a46 VARCHAR2 := fnd_api.g_miss_char
840: )
841: as
842: ddp_score_rec ams_dm_score_pvt.score_rec_type;
843: ddindx binary_integer; indx binary_integer;
844: begin
845:
846: -- copy data to the local IN or IN-OUT args, if any

Line 902: ams_dm_score_pvt.validate_score_rec(p_api_version,

898: ddp_score_rec.attribute14 := p6_a45;
899: ddp_score_rec.attribute15 := p6_a46;
900:
901: -- here's the delegated call to the old PL/SQL routine
902: ams_dm_score_pvt.validate_score_rec(p_api_version,
903: p_init_msg_list,
904: p_validation_mode,
905: x_return_status,
906: x_msg_count,

Line 975: ddp_score_rec ams_dm_score_pvt.score_rec_type;

971: , p4_a45 VARCHAR2 := fnd_api.g_miss_char
972: , p4_a46 VARCHAR2 := fnd_api.g_miss_char
973: )
974: as
975: ddp_score_rec ams_dm_score_pvt.score_rec_type;
976: ddindx binary_integer; indx binary_integer;
977: begin
978:
979: -- copy data to the local IN or IN-OUT args, if any

Line 1036: ams_dm_score_pvt.validate_score(p_api_version,

1032:
1033:
1034:
1035: -- here's the delegated call to the old PL/SQL routine
1036: ams_dm_score_pvt.validate_score(p_api_version,
1037: p_init_msg_list,
1038: p_validation_level,
1039: p_validation_mode,
1040: ddp_score_rec,

Line 1093: ams_dm_score_pvt.copy_score(p_api_version,

1089:
1090:
1091:
1092: -- here's the delegated call to the old PL/SQL routine
1093: ams_dm_score_pvt.copy_score(p_api_version,
1094: p_init_msg_list,
1095: p_commit,
1096: p_validation_level,
1097: x_return_status,

Line 1120: end ams_dm_score_pvt_w;

1116:
1117:
1118: end;
1119:
1120: end ams_dm_score_pvt_w;