DBA Data[Home] [Help]

APPS.OZF_VOLUME_OFFER_DISC_PVT_W dependencies on OZF_VOLUME_OFFER_DISC_PVT

Line 1: package body ozf_volume_offer_disc_pvt_w as

1: package body ozf_volume_offer_disc_pvt_w as
2: /* $Header: ozfwvodb.pls 120.3 2006/05/05 11:05 julou 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:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 139: procedure rosetta_table_copy_out_p2(t ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

135: end loop;
136: end if;
137: end if;
138: end rosetta_table_copy_in_p2;
139: procedure rosetta_table_copy_out_p2(t ozf_volume_offer_disc_pvt.ozf_vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
140: , a1 out nocopy JTF_NUMBER_TABLE
141: , a2 out nocopy JTF_NUMBER_TABLE
142: , a3 out nocopy JTF_NUMBER_TABLE
143: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 408: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE

404: end if;
405: end if;
406: end rosetta_table_copy_out_p2;
407:
408: procedure rosetta_table_copy_in_p6(t out nocopy ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
409: , a1 JTF_VARCHAR2_TABLE_100
410: , a2 JTF_NUMBER_TABLE
411: , a3 JTF_VARCHAR2_TABLE_100
412: , a4 JTF_VARCHAR2_TABLE_100

Line 467: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

463: end loop;
464: end if;
465: end if;
466: end rosetta_table_copy_in_p6;
467: procedure rosetta_table_copy_out_p6(t ozf_volume_offer_disc_pvt.vo_prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
468: , a1 out nocopy JTF_VARCHAR2_TABLE_100
469: , a2 out nocopy JTF_NUMBER_TABLE
470: , a3 out nocopy JTF_VARCHAR2_TABLE_100
471: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 652: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

648: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
649: )
650:
651: as
652: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
653: ddindx binary_integer; indx binary_integer;
654: begin
655:
656: -- copy data to the local IN or IN-OUT args, if any

Line 717: ozf_volume_offer_disc_pvt.create_vo_discount(p_api_version_number,

713: ddp_vo_disc_rec.attribute15 := p7_a49;
714:
715:
716: -- here's the delegated call to the old PL/SQL routine
717: ozf_volume_offer_disc_pvt.create_vo_discount(p_api_version_number,
718: p_init_msg_list,
719: p_commit,
720: p_validation_level,
721: x_return_status,

Line 798: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

794: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
795: )
796:
797: as
798: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
799: ddindx binary_integer; indx binary_integer;
800: begin
801:
802: -- copy data to the local IN or IN-OUT args, if any

Line 862: ozf_volume_offer_disc_pvt.update_vo_discount(p_api_version_number,

858: ddp_vo_disc_rec.attribute14 := p7_a48;
859: ddp_vo_disc_rec.attribute15 := p7_a49;
860:
861: -- here's the delegated call to the old PL/SQL routine
862: ozf_volume_offer_disc_pvt.update_vo_discount(p_api_version_number,
863: p_init_msg_list,
864: p_commit,
865: p_validation_level,
866: x_return_status,

Line 913: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

909: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
910: )
911:
912: as
913: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;
914: ddindx binary_integer; indx binary_integer;
915: begin
916:
917: -- copy data to the local IN or IN-OUT args, if any

Line 949: ozf_volume_offer_disc_pvt.create_vo_product(p_api_version_number,

945: ddp_vo_prod_rec.include_volume_flag := p7_a20;
946:
947:
948: -- here's the delegated call to the old PL/SQL routine
949: ozf_volume_offer_disc_pvt.create_vo_product(p_api_version_number,
950: p_init_msg_list,
951: p_commit,
952: p_validation_level,
953: x_return_status,

Line 1001: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

997: , p7_a20 VARCHAR2 := fnd_api.g_miss_char
998: )
999:
1000: as
1001: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;
1002: ddindx binary_integer; indx binary_integer;
1003: begin
1004:
1005: -- copy data to the local IN or IN-OUT args, if any

Line 1036: ozf_volume_offer_disc_pvt.update_vo_product(p_api_version_number,

1032: ddp_vo_prod_rec.apply_discount_flag := p7_a19;
1033: ddp_vo_prod_rec.include_volume_flag := p7_a20;
1034:
1035: -- here's the delegated call to the old PL/SQL routine
1036: ozf_volume_offer_disc_pvt.update_vo_product(p_api_version_number,
1037: p_init_msg_list,
1038: p_commit,
1039: p_validation_level,
1040: x_return_status,

Line 1117: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;

1113: , p8_a49 VARCHAR2 := fnd_api.g_miss_char
1114: )
1115:
1116: as
1117: ddp_vo_disc_rec ozf_volume_offer_disc_pvt.vo_disc_rec_type;
1118: ddindx binary_integer; indx binary_integer;
1119: begin
1120:
1121: -- copy data to the local IN or IN-OUT args, if any

Line 1183: ozf_volume_offer_disc_pvt.copy_vo_discounts(p_api_version_number,

1179: ddp_vo_disc_rec.attribute15 := p8_a49;
1180:
1181:
1182: -- here's the delegated call to the old PL/SQL routine
1183: ozf_volume_offer_disc_pvt.copy_vo_discounts(p_api_version_number,
1184: p_init_msg_list,
1185: p_commit,
1186: p_validation_level,
1187: x_return_status,

Line 1231: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;

1227: , p0_a20 VARCHAR2 := fnd_api.g_miss_char
1228: )
1229:
1230: as
1231: ddp_vo_prod_rec ozf_volume_offer_disc_pvt.vo_prod_rec_type;
1232: ddindx binary_integer; indx binary_integer;
1233: begin
1234:
1235: -- copy data to the local IN or IN-OUT args, if any

Line 1260: ozf_volume_offer_disc_pvt.check_vo_product_attr(ddp_vo_prod_rec,

1256: ddp_vo_prod_rec.include_volume_flag := p0_a20;
1257:
1258:
1259: -- here's the delegated call to the old PL/SQL routine
1260: ozf_volume_offer_disc_pvt.check_vo_product_attr(ddp_vo_prod_rec,
1261: x_return_status);
1262:
1263: -- copy data back from the local variables to OUT or IN-OUT args, if any
1264:

Line 1267: end ozf_volume_offer_disc_pvt_w;

1263: -- copy data back from the local variables to OUT or IN-OUT args, if any
1264:
1265: end;
1266:
1267: end ozf_volume_offer_disc_pvt_w;