DBA Data[Home] [Help]

APPS.AMS_WEB_TRACK_PVT_W dependencies on AMS_WEB_TRACK_PVT

Line 1: package body ams_web_track_pvt_w as

1: package body ams_web_track_pvt_w as
2: /* $Header: amswwtgb.pls 120.1 2005/06/27 05:43:44 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_p2(t OUT NOCOPY ams_web_track_pvt.web_track_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_p2(t OUT NOCOPY ams_web_track_pvt.web_track_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

91: end loop;
92: end if;
93: end if;
94: end rosetta_table_copy_in_p2;
95: procedure rosetta_table_copy_out_p2(t ams_web_track_pvt.web_track_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
96: , a1 OUT NOCOPY JTF_NUMBER_TABLE
97: , a2 OUT NOCOPY JTF_VARCHAR2_TABLE_100
98: , a3 OUT NOCOPY JTF_NUMBER_TABLE
99: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE

250: end if;
251: end if;
252: end rosetta_table_copy_out_p2;
253:
254: procedure rosetta_table_copy_in_p13(t OUT NOCOPY ams_web_track_pvt.web_recomms_tbl_type, a0 JTF_NUMBER_TABLE
255: , a1 JTF_NUMBER_TABLE
256: , a2 JTF_NUMBER_TABLE
257: , a3 JTF_VARCHAR2_TABLE_100
258: , a4 JTF_NUMBER_TABLE

Line 329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

325: end loop;
326: end if;
327: end if;
328: end rosetta_table_copy_in_p13;
329: procedure rosetta_table_copy_out_p13(t ams_web_track_pvt.web_recomms_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
330: , a1 OUT NOCOPY JTF_NUMBER_TABLE
331: , a2 OUT NOCOPY JTF_NUMBER_TABLE
332: , a3 OUT NOCOPY JTF_VARCHAR2_TABLE_100
333: , a4 OUT NOCOPY JTF_NUMBER_TABLE

Line 493: procedure rosetta_table_copy_in_p23(t OUT NOCOPY ams_web_track_pvt.impr_obj_id_tbl_type, a0 JTF_NUMBER_TABLE

489: end if;
490: end if;
491: end rosetta_table_copy_out_p13;
492:
493: procedure rosetta_table_copy_in_p23(t OUT NOCOPY ams_web_track_pvt.impr_obj_id_tbl_type, a0 JTF_NUMBER_TABLE
494: , a1 JTF_NUMBER_TABLE
495: ) as
496: ddindx binary_integer; indx binary_integer;
497: begin

Line 514: procedure rosetta_table_copy_out_p23(t ams_web_track_pvt.impr_obj_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE

510: end loop;
511: end if;
512: end if;
513: end rosetta_table_copy_in_p23;
514: procedure rosetta_table_copy_out_p23(t ams_web_track_pvt.impr_obj_id_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
515: , a1 OUT NOCOPY JTF_NUMBER_TABLE
516: ) as
517: ddindx binary_integer; indx binary_integer;
518: begin

Line 581: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

577: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
578: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
579: )
580: as
581: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
582: ddindx binary_integer; indx binary_integer;
583: begin
584:
585: -- copy data to the local IN or IN-OUT args, if any

Line 624: ams_web_track_pvt.create_web_track(p_api_version_number,

620: ddp_web_track_rec.attribute15 := p7_a27;
621:
622:
623: -- here's the delegated call to the old PL/SQL routine
624: ams_web_track_pvt.create_web_track(p_api_version_number,
625: p_init_msg_list,
626: p_commit,
627: p_validation_level,
628: x_return_status,

Line 682: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

678: , p7_a26 VARCHAR2 := fnd_api.g_miss_char
679: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
680: )
681: as
682: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
683: ddindx binary_integer; indx binary_integer;
684: begin
685:
686: -- copy data to the local IN or IN-OUT args, if any

Line 724: ams_web_track_pvt.update_web_track(p_api_version_number,

720: ddp_web_track_rec.attribute14 := p7_a26;
721: ddp_web_track_rec.attribute15 := p7_a27;
722:
723: -- here's the delegated call to the old PL/SQL routine
724: ams_web_track_pvt.update_web_track(p_api_version_number,
725: p_init_msg_list,
726: p_commit,
727: p_validation_level,
728: x_return_status,

Line 780: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

776: , p3_a26 VARCHAR2 := fnd_api.g_miss_char
777: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
778: )
779: as
780: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
781: ddindx binary_integer; indx binary_integer;
782: begin
783:
784: -- copy data to the local IN or IN-OUT args, if any

Line 822: ams_web_track_pvt.validate_web_track(p_api_version_number,

818:
819:
820:
821: -- here's the delegated call to the old PL/SQL routine
822: ams_web_track_pvt.validate_web_track(p_api_version_number,
823: p_init_msg_list,
824: p_validation_level,
825: ddp_web_track_rec,
826: p_validation_mode,

Line 873: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

869: , p0_a26 VARCHAR2 := fnd_api.g_miss_char
870: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
871: )
872: as
873: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
874: ddindx binary_integer; indx binary_integer;
875: begin
876:
877: -- copy data to the local IN or IN-OUT args, if any

Line 910: ams_web_track_pvt.check_web_track_items(ddp_web_track_rec,

906:
907:
908:
909: -- here's the delegated call to the old PL/SQL routine
910: ams_web_track_pvt.check_web_track_items(ddp_web_track_rec,
911: p_validation_mode,
912: x_return_status);
913:
914: -- copy data back from the local OUT or IN-OUT args, if any

Line 954: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

950: , p5_a26 VARCHAR2 := fnd_api.g_miss_char
951: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
952: )
953: as
954: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
955: ddindx binary_integer; indx binary_integer;
956: begin
957:
958: -- copy data to the local IN or IN-OUT args, if any

Line 994: ams_web_track_pvt.validate_web_track_rec(p_api_version_number,

990: ddp_web_track_rec.attribute14 := p5_a26;
991: ddp_web_track_rec.attribute15 := p5_a27;
992:
993: -- here's the delegated call to the old PL/SQL routine
994: ams_web_track_pvt.validate_web_track_rec(p_api_version_number,
995: p_init_msg_list,
996: x_return_status,
997: x_msg_count,
998: x_msg_data,

Line 1048: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

1044: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1045: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1046: )
1047: as
1048: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1049: ddindx binary_integer; indx binary_integer;
1050: begin
1051:
1052: -- copy data to the local IN or IN-OUT args, if any

Line 1092: ams_web_track_pvt.create_web_recomms(p_api_version_number,

1088: ddp_web_recomms_rec.attribute15 := p7_a28;
1089:
1090:
1091: -- here's the delegated call to the old PL/SQL routine
1092: ams_web_track_pvt.create_web_recomms(p_api_version_number,
1093: p_init_msg_list,
1094: p_commit,
1095: p_validation_level,
1096: x_return_status,

Line 1151: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

1147: , p7_a27 VARCHAR2 := fnd_api.g_miss_char
1148: , p7_a28 VARCHAR2 := fnd_api.g_miss_char
1149: )
1150: as
1151: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1152: ddindx binary_integer; indx binary_integer;
1153: begin
1154:
1155: -- copy data to the local IN or IN-OUT args, if any

Line 1194: ams_web_track_pvt.update_web_recomms(p_api_version_number,

1190: ddp_web_recomms_rec.attribute14 := p7_a27;
1191: ddp_web_recomms_rec.attribute15 := p7_a28;
1192:
1193: -- here's the delegated call to the old PL/SQL routine
1194: ams_web_track_pvt.update_web_recomms(p_api_version_number,
1195: p_init_msg_list,
1196: p_commit,
1197: p_validation_level,
1198: x_return_status,

Line 1251: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

1247: , p3_a27 VARCHAR2 := fnd_api.g_miss_char
1248: , p3_a28 VARCHAR2 := fnd_api.g_miss_char
1249: )
1250: as
1251: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1252: ddindx binary_integer; indx binary_integer;
1253: begin
1254:
1255: -- copy data to the local IN or IN-OUT args, if any

Line 1294: ams_web_track_pvt.validate_web_recomms(p_api_version_number,

1290:
1291:
1292:
1293: -- here's the delegated call to the old PL/SQL routine
1294: ams_web_track_pvt.validate_web_recomms(p_api_version_number,
1295: p_init_msg_list,
1296: p_validation_level,
1297: ddp_web_recomms_rec,
1298: p_validation_mode,

Line 1346: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

1342: , p0_a27 VARCHAR2 := fnd_api.g_miss_char
1343: , p0_a28 VARCHAR2 := fnd_api.g_miss_char
1344: )
1345: as
1346: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1347: ddindx binary_integer; indx binary_integer;
1348: begin
1349:
1350: -- copy data to the local IN or IN-OUT args, if any

Line 1384: ams_web_track_pvt.check_web_recomms_items(ddp_web_recomms_rec,

1380:
1381:
1382:
1383: -- here's the delegated call to the old PL/SQL routine
1384: ams_web_track_pvt.check_web_recomms_items(ddp_web_recomms_rec,
1385: p_validation_mode,
1386: x_return_status);
1387:
1388: -- copy data back from the local OUT or IN-OUT args, if any

Line 1429: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;

1425: , p5_a27 VARCHAR2 := fnd_api.g_miss_char
1426: , p5_a28 VARCHAR2 := fnd_api.g_miss_char
1427: )
1428: as
1429: ddp_web_recomms_rec ams_web_track_pvt.web_recomms_rec_type;
1430: ddindx binary_integer; indx binary_integer;
1431: begin
1432:
1433: -- copy data to the local IN or IN-OUT args, if any

Line 1470: ams_web_track_pvt.validate_web_recomms_rec(p_api_version_number,

1466: ddp_web_recomms_rec.attribute14 := p5_a27;
1467: ddp_web_recomms_rec.attribute15 := p5_a28;
1468:
1469: -- here's the delegated call to the old PL/SQL routine
1470: ams_web_track_pvt.validate_web_recomms_rec(p_api_version_number,
1471: p_init_msg_list,
1472: x_return_status,
1473: x_msg_count,
1474: x_msg_data,

Line 1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;

1549: , p4_a26 VARCHAR2 := fnd_api.g_miss_char
1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1552: as
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;
1555: ddx_impr_obj_id_rec ams_web_track_pvt.impr_obj_id_tbl_type;
1556: ddindx binary_integer; indx binary_integer;
1557: begin

Line 1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;

1550: , p4_a27 VARCHAR2 := fnd_api.g_miss_char
1551: )
1552: as
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;
1555: ddx_impr_obj_id_rec ams_web_track_pvt.impr_obj_id_tbl_type;
1556: ddindx binary_integer; indx binary_integer;
1557: begin
1558:

Line 1555: ddx_impr_obj_id_rec ams_web_track_pvt.impr_obj_id_tbl_type;

1551: )
1552: as
1553: ddp_web_track_rec ams_web_track_pvt.web_track_rec_type;
1554: ddp_web_recomms_tbl ams_web_track_pvt.web_recomms_tbl_type;
1555: ddx_impr_obj_id_rec ams_web_track_pvt.impr_obj_id_tbl_type;
1556: ddindx binary_integer; indx binary_integer;
1557: begin
1558:
1559: -- copy data to the local IN or IN-OUT args, if any

Line 1593: ams_web_track_pvt_w.rosetta_table_copy_in_p13(ddp_web_recomms_tbl, p5_a0

1589: ddp_web_track_rec.attribute13 := p4_a25;
1590: ddp_web_track_rec.attribute14 := p4_a26;
1591: ddp_web_track_rec.attribute15 := p4_a27;
1592:
1593: ams_web_track_pvt_w.rosetta_table_copy_in_p13(ddp_web_recomms_tbl, p5_a0
1594: , p5_a1
1595: , p5_a2
1596: , p5_a3
1597: , p5_a4

Line 1629: ams_web_track_pvt.create_web_imp_track(p_api_version_number,

1625:
1626:
1627:
1628: -- here's the delegated call to the old PL/SQL routine
1629: ams_web_track_pvt.create_web_imp_track(p_api_version_number,
1630: p_init_msg_list,
1631: p_commit,
1632: p_validation_level,
1633: ddp_web_track_rec,

Line 1647: ams_web_track_pvt_w.rosetta_table_copy_out_p23(ddx_impr_obj_id_rec, p6_a0

1643:
1644:
1645:
1646:
1647: ams_web_track_pvt_w.rosetta_table_copy_out_p23(ddx_impr_obj_id_rec, p6_a0
1648: , p6_a1
1649: );
1650:
1651:

Line 1655: end ams_web_track_pvt_w;

1651:
1652:
1653: end;
1654:
1655: end ams_web_track_pvt_w;