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_OFFER_PVT_W dependencies on OZF_OFFER_PVT

Line 1: package body ozf_offer_pvt_w as

1: package body ozf_offer_pvt_w as
2: /* $Header: ozfwofrb.pls 120.16 2011/03/14 05:16:18 nirprasa 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p1(t out nocopy ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: ) as

Line 50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

46: end loop;
47: end if;
48: end if;
49: end rosetta_table_copy_in_p1;
50: procedure rosetta_table_copy_out_p1(t ozf_offer_pvt.ozf_qp_reln_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: ) as

Line 89: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100

85: end if;
86: end if;
87: end rosetta_table_copy_out_p1;
88:
89: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
90: , a1 JTF_VARCHAR2_TABLE_100
91: , a2 JTF_NUMBER_TABLE
92: , a3 JTF_VARCHAR2_TABLE_100
93: , a4 JTF_NUMBER_TABLE

Line 252: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

248: end loop;
249: end if;
250: end if;
251: end rosetta_table_copy_in_p4;
252: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
253: , a1 out nocopy JTF_VARCHAR2_TABLE_100
254: , a2 out nocopy JTF_NUMBER_TABLE
255: , a3 out nocopy JTF_VARCHAR2_TABLE_100
256: , a4 out nocopy JTF_NUMBER_TABLE

Line 636: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

632: end if;
633: end if;
634: end rosetta_table_copy_out_p4;
635:
636: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_VARCHAR2_TABLE_100
638: , a2 JTF_NUMBER_TABLE
639: , a3 JTF_VARCHAR2_TABLE_100
640: , a4 JTF_VARCHAR2_TABLE_100

Line 679: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

675: end loop;
676: end if;
677: end if;
678: end rosetta_table_copy_in_p6;
679: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
680: , a1 out nocopy JTF_VARCHAR2_TABLE_100
681: , a2 out nocopy JTF_NUMBER_TABLE
682: , a3 out nocopy JTF_VARCHAR2_TABLE_100
683: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 763: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

759: end if;
760: end if;
761: end rosetta_table_copy_out_p6;
762:
763: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
764: , a1 JTF_VARCHAR2_TABLE_100
765: , a2 JTF_VARCHAR2_TABLE_300
766: , a3 JTF_VARCHAR2_TABLE_300
767: , a4 JTF_VARCHAR2_TABLE_100

Line 838: procedure rosetta_table_copy_out_p8(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

834: end loop;
835: end if;
836: end if;
837: end rosetta_table_copy_in_p8;
838: procedure rosetta_table_copy_out_p8(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
839: , a1 out nocopy JTF_VARCHAR2_TABLE_100
840: , a2 out nocopy JTF_VARCHAR2_TABLE_300
841: , a3 out nocopy JTF_VARCHAR2_TABLE_300
842: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1173: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1169: , p7_a85 NUMBER := 0-1962.0724
1170: )
1171:
1172: as
1173: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1174: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:

Line 1174: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1170: )
1171:
1172: as
1173: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1174: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1175: ddindx binary_integer; indx binary_integer;
1176: begin
1177:
1178: -- copy data to the local IN or IN-OUT args, if any

Line 1273: ozf_offer_pvt_w.rosetta_table_copy_in_p4(ddp_modifier_line_tbl, p8_a0

1269: ddp_modifier_list_rec.na_qualifier_type := p7_a83;
1270: ddp_modifier_list_rec.na_qualifier_id := rosetta_g_miss_num_map(p7_a84);
1271: ddp_modifier_list_rec.percent_discount := rosetta_g_miss_num_map(p7_a85);
1272:
1273: ozf_offer_pvt_w.rosetta_table_copy_in_p4(ddp_modifier_line_tbl, p8_a0
1274: , p8_a1
1275: , p8_a2
1276: , p8_a3
1277: , p8_a4

Line 1351: ozf_offer_pvt.process_modifiers(p_init_msg_list,

1347:
1348:
1349:
1350: -- here's the delegated call to the old PL/SQL routine
1351: ozf_offer_pvt.process_modifiers(p_init_msg_list,
1352: p_api_version,
1353: p_commit,
1354: x_return_status,
1355: x_msg_count,

Line 1459: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1455: , x_error_location out nocopy NUMBER
1456: )
1457:
1458: as
1459: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1460: ddindx binary_integer; indx binary_integer;
1461: begin
1462:
1463: -- copy data to the local IN or IN-OUT args, if any

Line 1470: ozf_offer_pvt_w.rosetta_table_copy_in_p4(ddp_modifier_line_tbl, p6_a0

1466:
1467:
1468:
1469:
1470: ozf_offer_pvt_w.rosetta_table_copy_in_p4(ddp_modifier_line_tbl, p6_a0
1471: , p6_a1
1472: , p6_a2
1473: , p6_a3
1474: , p6_a4

Line 1547: ozf_offer_pvt.create_offer_tiers(p_init_msg_list,

1543: );
1544:
1545:
1546: -- here's the delegated call to the old PL/SQL routine
1547: ozf_offer_pvt.create_offer_tiers(p_init_msg_list,
1548: p_api_version,
1549: p_commit,
1550: x_return_status,
1551: x_msg_count,

Line 1605: ddp_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

1601: , x_error_location out nocopy NUMBER
1602: )
1603:
1604: as
1605: ddp_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
1606: ddindx binary_integer; indx binary_integer;
1607: begin
1608:
1609: -- copy data to the local IN or IN-OUT args, if any

Line 1616: ozf_offer_pvt_w.rosetta_table_copy_in_p8(ddp_qualifiers_tbl, p6_a0

1612:
1613:
1614:
1615:
1616: ozf_offer_pvt_w.rosetta_table_copy_in_p8(ddp_qualifiers_tbl, p6_a0
1617: , p6_a1
1618: , p6_a2
1619: , p6_a3
1620: , p6_a4

Line 1649: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list,

1645: );
1646:
1647:
1648: -- here's the delegated call to the old PL/SQL routine
1649: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list,
1650: p_api_version,
1651: p_commit,
1652: x_return_status,
1653: x_msg_count,

Line 1691: ddp_pricing_attr_tbl ozf_offer_pvt.pricing_attr_tbl_type;

1687: , x_error_location out nocopy NUMBER
1688: )
1689:
1690: as
1691: ddp_pricing_attr_tbl ozf_offer_pvt.pricing_attr_tbl_type;
1692: ddindx binary_integer; indx binary_integer;
1693: begin
1694:
1695: -- copy data to the local IN or IN-OUT args, if any

Line 1702: ozf_offer_pvt_w.rosetta_table_copy_in_p6(ddp_pricing_attr_tbl, p6_a0

1698:
1699:
1700:
1701:
1702: ozf_offer_pvt_w.rosetta_table_copy_in_p6(ddp_pricing_attr_tbl, p6_a0
1703: , p6_a1
1704: , p6_a2
1705: , p6_a3
1706: , p6_a4

Line 1719: ozf_offer_pvt.process_exclusions(p_init_msg_list,

1715: );
1716:
1717:
1718: -- here's the delegated call to the old PL/SQL routine
1719: ozf_offer_pvt.process_exclusions(p_init_msg_list,
1720: p_api_version,
1721: p_commit,
1722: x_return_status,
1723: x_msg_count,

Line 1761: ddp_advanced_options_rec ozf_offer_pvt.advanced_option_rec_type;

1757: , p6_a13 NUMBER := 0-1962.0724
1758: )
1759:
1760: as
1761: ddp_advanced_options_rec ozf_offer_pvt.advanced_option_rec_type;
1762: ddindx binary_integer; indx binary_integer;
1763: begin
1764:
1765: -- copy data to the local IN or IN-OUT args, if any

Line 1788: ozf_offer_pvt.process_adv_options(p_init_msg_list,

1784: ddp_advanced_options_rec.autopay_party_attr := p6_a12;
1785: ddp_advanced_options_rec.autopay_party_id := rosetta_g_miss_num_map(p6_a13);
1786:
1787: -- here's the delegated call to the old PL/SQL routine
1788: ozf_offer_pvt.process_adv_options(p_init_msg_list,
1789: p_api_version,
1790: p_commit,
1791: x_return_status,
1792: x_msg_count,

Line 1902: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;

1898: , p7_a85 NUMBER := 0-1962.0724
1899: )
1900:
1901: as
1902: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;
1903: ddindx binary_integer; indx binary_integer;
1904: begin
1905:
1906: -- copy data to the local IN or IN-OUT args, if any

Line 2003: ozf_offer_pvt.activate_offer_over(p_init_msg_list,

1999: ddp_offer_rec.percent_discount := rosetta_g_miss_num_map(p7_a85);
2000:
2001:
2002: -- here's the delegated call to the old PL/SQL routine
2003: ozf_offer_pvt.activate_offer_over(p_init_msg_list,
2004: p_api_version,
2005: p_commit,
2006: x_return_status,
2007: x_msg_count,

Line 2117: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

2113: , p4_a85 NUMBER := 0-1962.0724
2114: )
2115:
2116: as
2117: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
2118: ddindx binary_integer; indx binary_integer;
2119: begin
2120:
2121: -- copy data to the local IN or IN-OUT args, if any

Line 2214: ozf_offer_pvt.update_offer_status(p_commit,

2210: ddp_modifier_list_rec.na_qualifier_id := rosetta_g_miss_num_map(p4_a84);
2211: ddp_modifier_list_rec.percent_discount := rosetta_g_miss_num_map(p4_a85);
2212:
2213: -- here's the delegated call to the old PL/SQL routine
2214: ozf_offer_pvt.update_offer_status(p_commit,
2215: x_return_status,
2216: x_msg_count,
2217: x_msg_data,
2218: ddp_modifier_list_rec);

Line 2323: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;

2319: , p7_a85 NUMBER := 0-1962.0724
2320: )
2321:
2322: as
2323: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;
2324: ddindx binary_integer; indx binary_integer;
2325: begin
2326:
2327: -- copy data to the local IN or IN-OUT args, if any

Line 2423: ozf_offer_pvt.process_offer_activation(p_api_version_number,

2419: ddp_offer_rec.na_qualifier_id := rosetta_g_miss_num_map(p7_a84);
2420: ddp_offer_rec.percent_discount := rosetta_g_miss_num_map(p7_a85);
2421:
2422: -- here's the delegated call to the old PL/SQL routine
2423: ozf_offer_pvt.process_offer_activation(p_api_version_number,
2424: p_init_msg_list,
2425: p_commit,
2426: p_validation_level,
2427: x_return_status,

Line 2442: end ozf_offer_pvt_w;

2438:
2439:
2440: end;
2441:
2442: end ozf_offer_pvt_w;