eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_DISC_LINE_PVT_W dependencies on OZF_DISC_LINE_PVT

Line 1: package body ozf_disc_line_pvt_w as

1: package body ozf_disc_line_pvt_w as
2: /* $Header: ozfwodlb.pls 120.3 2006/05/04 15:26 julou 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 ozf_disc_line_pvt.ozf_offer_line_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_disc_line_pvt.ozf_offer_line_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 129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

125: end loop;
126: end if;
127: end if;
128: end rosetta_table_copy_in_p2;
129: procedure rosetta_table_copy_out_p2(t ozf_disc_line_pvt.ozf_offer_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
130: , a1 out nocopy JTF_NUMBER_TABLE
131: , a2 out nocopy JTF_NUMBER_TABLE
132: , a3 out nocopy JTF_NUMBER_TABLE
133: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE

369: end if;
370: end if;
371: end rosetta_table_copy_out_p2;
372:
373: procedure rosetta_table_copy_in_p6(t out nocopy ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
374: , a1 JTF_NUMBER_TABLE
375: , a2 JTF_NUMBER_TABLE
376: , a3 JTF_NUMBER_TABLE
377: , a4 JTF_NUMBER_TABLE

Line 450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

446: end loop;
447: end if;
448: end if;
449: end rosetta_table_copy_in_p6;
450: procedure rosetta_table_copy_out_p6(t ozf_disc_line_pvt.ozf_offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
451: , a1 out nocopy JTF_NUMBER_TABLE
452: , a2 out nocopy JTF_NUMBER_TABLE
453: , a3 out nocopy JTF_NUMBER_TABLE
454: , a4 out nocopy JTF_NUMBER_TABLE

Line 619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE

615: end if;
616: end if;
617: end rosetta_table_copy_out_p6;
618:
619: procedure rosetta_table_copy_in_p9(t out nocopy ozf_disc_line_pvt.ozf_discount_line_tbl, a0 JTF_NUMBER_TABLE
620: , a1 JTF_NUMBER_TABLE
621: , a2 JTF_NUMBER_TABLE
622: , a3 JTF_NUMBER_TABLE
623: , a4 JTF_VARCHAR2_TABLE_100

Line 736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE

732: end loop;
733: end if;
734: end if;
735: end rosetta_table_copy_in_p9;
736: procedure rosetta_table_copy_out_p9(t ozf_disc_line_pvt.ozf_discount_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
737: , a1 out nocopy JTF_NUMBER_TABLE
738: , a2 out nocopy JTF_NUMBER_TABLE
739: , a3 out nocopy JTF_NUMBER_TABLE
740: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1005: procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE

1001: end if;
1002: end if;
1003: end rosetta_table_copy_out_p9;
1004:
1005: procedure rosetta_table_copy_in_p12(t out nocopy ozf_disc_line_pvt.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
1006: , a1 JTF_NUMBER_TABLE
1007: , a2 JTF_VARCHAR2_TABLE_100
1008: , a3 JTF_NUMBER_TABLE
1009: , a4 JTF_VARCHAR2_TABLE_100

Line 1054: procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1050: end loop;
1051: end if;
1052: end if;
1053: end rosetta_table_copy_in_p12;
1054: procedure rosetta_table_copy_out_p12(t ozf_disc_line_pvt.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1055: , a1 out nocopy JTF_NUMBER_TABLE
1056: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1057: , a3 out nocopy JTF_NUMBER_TABLE
1058: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE

1149: end if;
1150: end if;
1151: end rosetta_table_copy_out_p12;
1152:
1153: procedure rosetta_table_copy_in_p15(t out nocopy ozf_disc_line_pvt.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
1154: , a1 JTF_NUMBER_TABLE
1155: , a2 JTF_VARCHAR2_TABLE_100
1156: , a3 JTF_NUMBER_TABLE
1157: , a4 JTF_NUMBER_TABLE

Line 1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1180: end loop;
1181: end if;
1182: end if;
1183: end rosetta_table_copy_in_p15;
1184: procedure rosetta_table_copy_out_p15(t ozf_disc_line_pvt.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1185: , a1 out nocopy JTF_NUMBER_TABLE
1186: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1187: , a3 out nocopy JTF_NUMBER_TABLE
1188: , a4 out nocopy JTF_NUMBER_TABLE

Line 1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE

1234: end if;
1235: end if;
1236: end rosetta_table_copy_out_p15;
1237:
1238: procedure rosetta_table_copy_in_p18(t out nocopy ozf_disc_line_pvt.prod_reln_tbl_type, a0 JTF_NUMBER_TABLE
1239: , a1 JTF_NUMBER_TABLE
1240: , a2 JTF_NUMBER_TABLE
1241: , a3 JTF_DATE_TABLE
1242: , a4 JTF_NUMBER_TABLE

Line 1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1269: end loop;
1270: end if;
1271: end if;
1272: end rosetta_table_copy_in_p18;
1273: procedure rosetta_table_copy_out_p18(t ozf_disc_line_pvt.prod_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1274: , a1 out nocopy JTF_NUMBER_TABLE
1275: , a2 out nocopy JTF_NUMBER_TABLE
1276: , a3 out nocopy JTF_DATE_TABLE
1277: , a4 out nocopy JTF_NUMBER_TABLE

Line 1398: ddp_ozf_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;

1394: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
1395: )
1396:
1397: as
1398: ddp_ozf_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
1399: ddindx binary_integer; indx binary_integer;
1400: begin
1401:
1402: -- copy data to the local IN or IN-OUT args, if any

Line 1463: ozf_disc_line_pvt.create_discount_line(p_api_version_number,

1459: ddp_ozf_discount_line_rec.attribute15 := p7_a49;
1460:
1461:
1462: -- here's the delegated call to the old PL/SQL routine
1463: ozf_disc_line_pvt.create_discount_line(p_api_version_number,
1464: p_init_msg_list,
1465: p_commit,
1466: p_validation_level,
1467: x_return_status,

Line 1544: ddp_ozf_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;

1540: , p7_a49 VARCHAR2 := fnd_api.g_miss_char
1541: )
1542:
1543: as
1544: ddp_ozf_discount_line_rec ozf_disc_line_pvt.ozf_discount_line_rec_type;
1545: ddindx binary_integer; indx binary_integer;
1546: begin
1547:
1548: -- copy data to the local IN or IN-OUT args, if any

Line 1608: ozf_disc_line_pvt.update_discount_line(p_api_version_number,

1604: ddp_ozf_discount_line_rec.attribute14 := p7_a48;
1605: ddp_ozf_discount_line_rec.attribute15 := p7_a49;
1606:
1607: -- here's the delegated call to the old PL/SQL routine
1608: ozf_disc_line_pvt.update_discount_line(p_api_version_number,
1609: p_init_msg_list,
1610: p_commit,
1611: p_validation_level,
1612: x_return_status,

Line 1645: ddp_ozf_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;

1641: , p7_a6 DATE := fnd_api.g_miss_date
1642: )
1643:
1644: as
1645: ddp_ozf_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
1646: ddindx binary_integer; indx binary_integer;
1647: begin
1648:
1649: -- copy data to the local IN or IN-OUT args, if any

Line 1667: ozf_disc_line_pvt.create_product_exclusion(p_api_version_number,

1663: ddp_ozf_excl_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a6);
1664:
1665:
1666: -- here's the delegated call to the old PL/SQL routine
1667: ozf_disc_line_pvt.create_product_exclusion(p_api_version_number,
1668: p_init_msg_list,
1669: p_commit,
1670: p_validation_level,
1671: x_return_status,

Line 1705: ddp_ozf_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;

1701: , p7_a6 DATE := fnd_api.g_miss_date
1702: )
1703:
1704: as
1705: ddp_ozf_excl_rec ozf_disc_line_pvt.ozf_excl_rec_type;
1706: ddindx binary_integer; indx binary_integer;
1707: begin
1708:
1709: -- copy data to the local IN or IN-OUT args, if any

Line 1726: ozf_disc_line_pvt.update_product_exclusion(p_api_version_number,

1722: ddp_ozf_excl_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a5);
1723: ddp_ozf_excl_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a6);
1724:
1725: -- here's the delegated call to the old PL/SQL routine
1726: ozf_disc_line_pvt.update_product_exclusion(p_api_version_number,
1727: p_init_msg_list,
1728: p_commit,
1729: p_validation_level,
1730: x_return_status,

Line 1786: ddp_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

1782: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
1783: )
1784:
1785: as
1786: ddp_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
1787: ddindx binary_integer; indx binary_integer;
1788: begin
1789:
1790: -- copy data to the local IN or IN-OUT args, if any

Line 1831: ozf_disc_line_pvt.create_disc_tiers(p_api_version_number,

1827: ddp_tier_rec.attribute15 := p7_a29;
1828:
1829:
1830: -- here's the delegated call to the old PL/SQL routine
1831: ozf_disc_line_pvt.create_disc_tiers(p_api_version_number,
1832: p_init_msg_list,
1833: p_commit,
1834: p_validation_level,
1835: x_return_status,

Line 1892: ddp_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;

1888: , p7_a29 VARCHAR2 := fnd_api.g_miss_char
1889: )
1890:
1891: as
1892: ddp_tier_rec ozf_disc_line_pvt.ozf_offer_tier_rec_type;
1893: ddindx binary_integer; indx binary_integer;
1894: begin
1895:
1896: -- copy data to the local IN or IN-OUT args, if any

Line 1936: ozf_disc_line_pvt.update_disc_tiers(p_api_version_number,

1932: ddp_tier_rec.attribute14 := p7_a28;
1933: ddp_tier_rec.attribute15 := p7_a29;
1934:
1935: -- here's the delegated call to the old PL/SQL routine
1936: ozf_disc_line_pvt.update_disc_tiers(p_api_version_number,
1937: p_init_msg_list,
1938: p_commit,
1939: p_validation_level,
1940: x_return_status,

Line 1982: ddp_ozf_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;

1978: , p7_a15 NUMBER := 0-1962.0724
1979: )
1980:
1981: as
1982: ddp_ozf_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
1983: ddindx binary_integer; indx binary_integer;
1984: begin
1985:
1986: -- copy data to the local IN or IN-OUT args, if any

Line 2013: ozf_disc_line_pvt.create_ozf_prod_line(p_api_version_number,

2009: ddp_ozf_prod_rec.object_version_number := rosetta_g_miss_num_map(p7_a15);
2010:
2011:
2012: -- here's the delegated call to the old PL/SQL routine
2013: ozf_disc_line_pvt.create_ozf_prod_line(p_api_version_number,
2014: p_init_msg_list,
2015: p_commit,
2016: p_validation_level,
2017: x_return_status,

Line 2060: ddp_ozf_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;

2056: , p7_a15 NUMBER := 0-1962.0724
2057: )
2058:
2059: as
2060: ddp_ozf_prod_rec ozf_disc_line_pvt.ozf_prod_rec_type;
2061: ddindx binary_integer; indx binary_integer;
2062: begin
2063:
2064: -- copy data to the local IN or IN-OUT args, if any

Line 2090: ozf_disc_line_pvt.update_ozf_prod_line(p_api_version_number,

2086: ddp_ozf_prod_rec.last_update_login := rosetta_g_miss_num_map(p7_a14);
2087: ddp_ozf_prod_rec.object_version_number := rosetta_g_miss_num_map(p7_a15);
2088:
2089: -- here's the delegated call to the old PL/SQL routine
2090: ozf_disc_line_pvt.update_ozf_prod_line(p_api_version_number,
2091: p_init_msg_list,
2092: p_commit,
2093: p_validation_level,
2094: x_return_status,

Line 2109: end ozf_disc_line_pvt_w;

2105:
2106:
2107: end;
2108:
2109: end ozf_disc_line_pvt_w;