DBA Data[Home] [Help]

APPS.AMS_WEB_TRACK_PVT_W dependencies on AMS_WEB_TRACK_PVT_W

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 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 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 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 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 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 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 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 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 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 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 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 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 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;