APPS.OZF_OFFER_PVT_OA dependencies on OZF_OFFER_PVT

Line 1: package body ozf_offer_pvt_oa as

1: package body ozf_offer_pvt_oa as
2: /* $Header: ozfaofub.pls 120.2 2006/07/20 12:01:28 mgudivak ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ozf_offer_pvt_oa as
2: /* $Header: ozfaofub.pls 120.2 2006/07/20 12:01:28 mgudivak ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pvt.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 162: procedure rosetta_table_copy_out_p2(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

158: end loop;
159: end if;
160: end if;
161: end rosetta_table_copy_in_p2;
162: procedure rosetta_table_copy_out_p2(t ozf_offer_pvt.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
163: , a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , a2 out nocopy JTF_NUMBER_TABLE
165: , a3 out nocopy JTF_NUMBER_TABLE
166: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 536: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

532: end if;
533: end if;
534: end rosetta_table_copy_out_p2;
535:
536: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
537: , a1 JTF_VARCHAR2_TABLE_100
538: , a2 JTF_NUMBER_TABLE
539: , a3 JTF_VARCHAR2_TABLE_100
540: , a4 JTF_VARCHAR2_TABLE_100

Line 579: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

575: end loop;
576: end if;
577: end if;
578: end rosetta_table_copy_in_p4;
579: procedure rosetta_table_copy_out_p4(t ozf_offer_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
580: , a1 out nocopy JTF_VARCHAR2_TABLE_100
581: , a2 out nocopy JTF_NUMBER_TABLE
582: , a3 out nocopy JTF_VARCHAR2_TABLE_100
583: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 663: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

659: end if;
660: end if;
661: end rosetta_table_copy_out_p4;
662:
663: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
664: , a1 JTF_VARCHAR2_TABLE_100
665: , a2 JTF_VARCHAR2_TABLE_300
666: , a3 JTF_VARCHAR2_TABLE_300
667: , a4 JTF_VARCHAR2_TABLE_100

Line 738: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

734: end loop;
735: end if;
736: end if;
737: end rosetta_table_copy_in_p6;
738: procedure rosetta_table_copy_out_p6(t ozf_offer_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
739: , a1 out nocopy JTF_VARCHAR2_TABLE_100
740: , a2 out nocopy JTF_VARCHAR2_TABLE_300
741: , a3 out nocopy JTF_VARCHAR2_TABLE_300
742: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1068: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

1064: , x_error_location out nocopy NUMBER
1065: )
1066:
1067: as
1068: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1069: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1070: ddindx binary_integer; indx binary_integer;
1071: begin
1072:

Line 1069: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1065: )
1066:
1067: as
1068: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
1069: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1070: ddindx binary_integer; indx binary_integer;
1071: begin
1072:
1073: -- copy data to the local IN or IN-OUT args, if any

Line 1165: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p8_a0

1161: ddp_modifier_list_rec.sales_method_flag := p7_a80;
1162: ddp_modifier_list_rec.global_flag := p7_a81;
1163: ddp_modifier_list_rec.orig_org_id := p7_a82;
1164:
1165: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p8_a0
1166: , p8_a1
1167: , p8_a2
1168: , p8_a3
1169: , p8_a4

Line 1241: ozf_offer_pvt.process_modifiers(p_init_msg_list,

1237:
1238:
1239:
1240: -- here's the delegated call to the old PL/SQL routine
1241: ozf_offer_pvt.process_modifiers(p_init_msg_list,
1242: p_api_version,
1243: p_commit,
1244: x_return_status,
1245: x_msg_count,

Line 1450: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

1446: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
1447: )
1448:
1449: as
1450: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
1451: ddx_modifiers_tbl qp_modifiers_pub.modifiers_tbl_type;
1452: ddx_pricing_attr_tbl qp_modifiers_pub.pricing_attr_tbl_type;
1453: ddindx binary_integer; indx binary_integer;
1454: begin

Line 1463: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p6_a0

1459:
1460:
1461:
1462:
1463: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p6_a0
1464: , p6_a1
1465: , p6_a2
1466: , p6_a3
1467: , p6_a4

Line 1540: ozf_offer_pvt.create_offer_tiers(p_init_msg_list,

1536:
1537:
1538:
1539: -- here's the delegated call to the old PL/SQL routine
1540: ozf_offer_pvt.create_offer_tiers(p_init_msg_list,
1541: p_api_version,
1542: p_commit,
1543: x_return_status,
1544: x_msg_count,

Line 1759: ddp_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;

1755: , p8_a51 out nocopy JTF_VARCHAR2_TABLE_100
1756: )
1757:
1758: as
1759: ddp_qualifiers_tbl ozf_offer_pvt.qualifiers_tbl_type;
1760: ddx_qualifiers_tbl qp_qualifier_rules_pub.qualifiers_tbl_type;
1761: ddindx binary_integer; indx binary_integer;
1762: begin
1763:

Line 1771: ozf_offer_pvt_oa.rosetta_table_copy_in_p6(ddp_qualifiers_tbl, p6_a0

1767:
1768:
1769:
1770:
1771: ozf_offer_pvt_oa.rosetta_table_copy_in_p6(ddp_qualifiers_tbl, p6_a0
1772: , p6_a1
1773: , p6_a2
1774: , p6_a3
1775: , p6_a4

Line 1805: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list,

1801:
1802:
1803:
1804: -- here's the delegated call to the old PL/SQL routine
1805: ozf_offer_pvt.process_market_qualifiers(p_init_msg_list,
1806: p_api_version,
1807: p_commit,
1808: x_return_status,
1809: x_msg_count,

Line 1902: ddp_pricing_attr_tbl ozf_offer_pvt.pricing_attr_tbl_type;

1898: , x_error_location out nocopy NUMBER
1899: )
1900:
1901: as
1902: ddp_pricing_attr_tbl ozf_offer_pvt.pricing_attr_tbl_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 1913: ozf_offer_pvt_oa.rosetta_table_copy_in_p4(ddp_pricing_attr_tbl, p6_a0

1909:
1910:
1911:
1912:
1913: ozf_offer_pvt_oa.rosetta_table_copy_in_p4(ddp_pricing_attr_tbl, p6_a0
1914: , p6_a1
1915: , p6_a2
1916: , p6_a3
1917: , p6_a4

Line 1930: ozf_offer_pvt.process_exclusions(p_init_msg_list,

1926: );
1927:
1928:
1929: -- here's the delegated call to the old PL/SQL routine
1930: ozf_offer_pvt.process_exclusions(p_init_msg_list,
1931: p_api_version,
1932: p_commit,
1933: x_return_status,
1934: x_msg_count,

Line 1972: ddp_advanced_options_rec ozf_offer_pvt.advanced_option_rec_type;

1968: , p6_a13 NUMBER
1969: )
1970:
1971: as
1972: ddp_advanced_options_rec ozf_offer_pvt.advanced_option_rec_type;
1973: ddindx binary_integer; indx binary_integer;
1974: begin
1975:
1976: -- copy data to the local IN or IN-OUT args, if any

Line 1999: ozf_offer_pvt.process_adv_options(p_init_msg_list,

1995: ddp_advanced_options_rec.autopay_party_attr := p6_a12;
1996: ddp_advanced_options_rec.autopay_party_id := p6_a13;
1997:
1998: -- here's the delegated call to the old PL/SQL routine
1999: ozf_offer_pvt.process_adv_options(p_init_msg_list,
2000: p_api_version,
2001: p_commit,
2002: x_return_status,
2003: x_msg_count,

Line 2110: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;

2106: , x_amount_error out nocopy VARCHAR2
2107: )
2108:
2109: as
2110: ddp_offer_rec ozf_offer_pvt.modifier_list_rec_type;
2111: ddindx binary_integer; indx binary_integer;
2112: begin
2113:
2114: -- copy data to the local IN or IN-OUT args, if any

Line 2208: ozf_offer_pvt.activate_offer_over(p_init_msg_list,

2204: ddp_offer_rec.orig_org_id := p7_a82;
2205:
2206:
2207: -- here's the delegated call to the old PL/SQL routine
2208: ozf_offer_pvt.activate_offer_over(p_init_msg_list,
2209: p_api_version,
2210: p_commit,
2211: x_return_status,
2212: x_msg_count,

Line 2319: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;

2315: , p4_a82 NUMBER
2316: )
2317:
2318: as
2319: ddp_modifier_list_rec ozf_offer_pvt.modifier_list_rec_type;
2320: ddindx binary_integer; indx binary_integer;
2321: begin
2322:
2323: -- copy data to the local IN or IN-OUT args, if any

Line 2413: ozf_offer_pvt.update_offer_status(p_commit,

2409: ddp_modifier_list_rec.global_flag := p4_a81;
2410: ddp_modifier_list_rec.orig_org_id := p4_a82;
2411:
2412: -- here's the delegated call to the old PL/SQL routine
2413: ozf_offer_pvt.update_offer_status(p_commit,
2414: x_return_status,
2415: x_msg_count,
2416: x_msg_data,
2417: ddp_modifier_list_rec);

Line 2596: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;

2592: , x_error_location out nocopy NUMBER
2593: )
2594:
2595: as
2596: ddp_modifier_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
2597: ddx_modifier_line_tbl qp_modifiers_pub.modifiers_tbl_type;
2598: ddindx binary_integer; indx binary_integer;
2599: begin
2600:

Line 2606: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p4_a0

2602:
2603:
2604:
2605:
2606: ozf_offer_pvt_oa.rosetta_table_copy_in_p2(ddp_modifier_line_tbl, p4_a0
2607: , p4_a1
2608: , p4_a2
2609: , p4_a3
2610: , p4_a4

Line 2683: ozf_offer_pvt.process_qp_list_lines(x_return_status,

2679:
2680:
2681:
2682: -- here's the delegated call to the old PL/SQL routine
2683: ozf_offer_pvt.process_qp_list_lines(x_return_status,
2684: x_msg_count,
2685: x_msg_data,
2686: p_offer_type,
2687: ddp_modifier_line_tbl,

Line 2793: end ozf_offer_pvt_oa;

2789: );
2790:
2791: end;
2792:
2793: end ozf_offer_pvt_oa;