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_PUB_OAW dependencies on OZF_OFFER_PUB

Line 1: package body ozf_offer_pub_oaw as

1: package body ozf_offer_pub_oaw as
2: /* $Header: ozfaofpb.pls 120.1 2005/09/29 10:48 gramanat noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ozf_offer_pub_oaw as
2: /* $Header: ozfaofpb.pls 120.1 2005/09/29 10:48 gramanat noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ozf_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 66: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

62: end loop;
63: end if;
64: end if;
65: end rosetta_table_copy_in_p2;
66: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_NUMBER_TABLE
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_VARCHAR2_TABLE_100
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE

196: end if;
197: end if;
198: end rosetta_table_copy_out_p2;
199:
200: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: , a2 JTF_NUMBER_TABLE
203: , a3 JTF_NUMBER_TABLE
204: , a4 JTF_VARCHAR2_TABLE_100

Line 287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

283: end loop;
284: end if;
285: end if;
286: end rosetta_table_copy_in_p4;
287: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
288: , a1 out nocopy JTF_NUMBER_TABLE
289: , a2 out nocopy JTF_NUMBER_TABLE
290: , a3 out nocopy JTF_NUMBER_TABLE
291: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 481: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE

477: end if;
478: end if;
479: end rosetta_table_copy_out_p4;
480:
481: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
482: , a1 JTF_NUMBER_TABLE
483: , a2 JTF_VARCHAR2_TABLE_100
484: , a3 JTF_NUMBER_TABLE
485: , a4 JTF_VARCHAR2_TABLE_100

Line 532: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

528: end loop;
529: end if;
530: end if;
531: end rosetta_table_copy_in_p6;
532: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
533: , a1 out nocopy JTF_NUMBER_TABLE
534: , a2 out nocopy JTF_VARCHAR2_TABLE_100
535: , a3 out nocopy JTF_NUMBER_TABLE
536: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE

632: end if;
633: end if;
634: end rosetta_table_copy_out_p6;
635:
636: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
637: , a1 JTF_NUMBER_TABLE
638: , a2 JTF_VARCHAR2_TABLE_100
639: , a3 JTF_NUMBER_TABLE
640: , a4 JTF_NUMBER_TABLE

Line 669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

665: end loop;
666: end if;
667: end if;
668: end rosetta_table_copy_in_p8;
669: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
670: , a1 out nocopy JTF_NUMBER_TABLE
671: , a2 out nocopy JTF_VARCHAR2_TABLE_100
672: , a3 out nocopy JTF_NUMBER_TABLE
673: , a4 out nocopy JTF_NUMBER_TABLE

Line 728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE

724: end if;
725: end if;
726: end rosetta_table_copy_out_p8;
727:
728: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
729: , a1 JTF_NUMBER_TABLE
730: , a2 JTF_NUMBER_TABLE
731: , a3 JTF_NUMBER_TABLE
732: , a4 JTF_NUMBER_TABLE

Line 775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

771: end loop;
772: end if;
773: end if;
774: end rosetta_table_copy_in_p10;
775: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
776: , a1 out nocopy JTF_NUMBER_TABLE
777: , a2 out nocopy JTF_NUMBER_TABLE
778: , a3 out nocopy JTF_NUMBER_TABLE
779: , a4 out nocopy JTF_NUMBER_TABLE

Line 869: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE

865: end if;
866: end if;
867: end rosetta_table_copy_out_p10;
868:
869: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
870: , a1 JTF_DATE_TABLE
871: , a2 JTF_NUMBER_TABLE
872: , a3 JTF_DATE_TABLE
873: , a4 JTF_NUMBER_TABLE

Line 952: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

948: end loop;
949: end if;
950: end if;
951: end rosetta_table_copy_in_p12;
952: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
953: , a1 out nocopy JTF_DATE_TABLE
954: , a2 out nocopy JTF_NUMBER_TABLE
955: , a3 out nocopy JTF_DATE_TABLE
956: , a4 out nocopy JTF_NUMBER_TABLE

Line 1136: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE

1132: end if;
1133: end if;
1134: end rosetta_table_copy_out_p12;
1135:
1136: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1137: , a1 JTF_NUMBER_TABLE
1138: , a2 JTF_NUMBER_TABLE
1139: , a3 JTF_VARCHAR2_TABLE_100
1140: ) as

Line 1161: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

1157: end loop;
1158: end if;
1159: end if;
1160: end rosetta_table_copy_in_p14;
1161: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1162: , a1 out nocopy JTF_NUMBER_TABLE
1163: , a2 out nocopy JTF_NUMBER_TABLE
1164: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1165: ) as

Line 1200: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1196: end if;
1197: end if;
1198: end rosetta_table_copy_out_p14;
1199:
1200: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1201: , a1 JTF_VARCHAR2_TABLE_100
1202: , a2 JTF_NUMBER_TABLE
1203: , a3 JTF_NUMBER_TABLE
1204: , a4 JTF_VARCHAR2_TABLE_100

Line 1359: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1355: end loop;
1356: end if;
1357: end if;
1358: end rosetta_table_copy_in_p17;
1359: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1360: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1361: , a2 out nocopy JTF_NUMBER_TABLE
1362: , a3 out nocopy JTF_NUMBER_TABLE
1363: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1733: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1729: end if;
1730: end if;
1731: end rosetta_table_copy_out_p17;
1732:
1733: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1734: , a1 JTF_VARCHAR2_TABLE_100
1735: , a2 JTF_VARCHAR2_TABLE_300
1736: , a3 JTF_VARCHAR2_TABLE_300
1737: , a4 JTF_VARCHAR2_TABLE_100

Line 1808: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

1804: end loop;
1805: end if;
1806: end if;
1807: end rosetta_table_copy_in_p19;
1808: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1809: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1810: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1811: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1812: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE

1968: end if;
1969: end if;
1970: end rosetta_table_copy_out_p19;
1971:
1972: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1973: , a1 JTF_NUMBER_TABLE
1974: , a2 JTF_NUMBER_TABLE
1975: , a3 JTF_NUMBER_TABLE
1976: , a4 JTF_VARCHAR2_TABLE_100

Line 2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2027: end loop;
2028: end if;
2029: end if;
2030: end rosetta_table_copy_in_p21;
2031: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2032: , a1 out nocopy JTF_NUMBER_TABLE
2033: , a2 out nocopy JTF_NUMBER_TABLE
2034: , a3 out nocopy JTF_NUMBER_TABLE
2035: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE

2151: end if;
2152: end if;
2153: end rosetta_table_copy_out_p21;
2154:
2155: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2156: , a1 JTF_VARCHAR2_TABLE_100
2157: , a2 JTF_NUMBER_TABLE
2158: , a3 JTF_NUMBER_TABLE
2159: , a4 JTF_NUMBER_TABLE

Line 2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2192: end loop;
2193: end if;
2194: end if;
2195: end rosetta_table_copy_in_p23;
2196: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2198: , a2 out nocopy JTF_NUMBER_TABLE
2199: , a3 out nocopy JTF_NUMBER_TABLE
2200: , a4 out nocopy JTF_NUMBER_TABLE

Line 2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE

2271: end if;
2272: end if;
2273: end rosetta_table_copy_out_p23;
2274:
2275: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2276: , a1 JTF_NUMBER_TABLE
2277: , a2 JTF_NUMBER_TABLE
2278: , a3 JTF_NUMBER_TABLE
2279: , a4 JTF_VARCHAR2_TABLE_100

Line 2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

2314: end loop;
2315: end if;
2316: end if;
2317: end rosetta_table_copy_in_p25;
2318: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2319: , a1 out nocopy JTF_NUMBER_TABLE
2320: , a2 out nocopy JTF_NUMBER_TABLE
2321: , a3 out nocopy JTF_NUMBER_TABLE
2322: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

2728: , x_error_location out nocopy NUMBER
2729: )
2730:
2731: as
2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;

Line 2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;

2729: )
2730:
2731: as
2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;

Line 2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

2730:
2731: as
2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

Line 2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

2731: as
2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

Line 2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;

2732: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

Line 2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;

2733: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

Line 2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

2734: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2742: ddindx binary_integer; indx binary_integer;

Line 2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

2735: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2742: ddindx binary_integer; indx binary_integer;
2743: begin

Line 2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

2736: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2742: ddindx binary_integer; indx binary_integer;
2743: begin
2744:

Line 2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

2737: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2738: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2739: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2740: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2741: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2742: ddindx binary_integer; indx binary_integer;
2743: begin
2744:
2745: -- copy data to the local IN or IN-OUT args, if any

Line 2837: ozf_offer_pub_oaw.rosetta_table_copy_in_p17(ddp_modifier_line_tbl, p8_a0

2833: ddp_modifier_list_rec.sales_method_flag := p7_a80;
2834: ddp_modifier_list_rec.global_flag := p7_a81;
2835: ddp_modifier_list_rec.orig_org_id := p7_a82;
2836:
2837: ozf_offer_pub_oaw.rosetta_table_copy_in_p17(ddp_modifier_line_tbl, p8_a0
2838: , p8_a1
2839: , p8_a2
2840: , p8_a3
2841: , p8_a4

Line 2910: ozf_offer_pub_oaw.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p9_a0

2906: , p8_a69
2907: , p8_a70
2908: );
2909:
2910: ozf_offer_pub_oaw.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p9_a0
2911: , p9_a1
2912: , p9_a2
2913: , p9_a3
2914: , p9_a4

Line 2941: ozf_offer_pub_oaw.rosetta_table_copy_in_p14(ddp_budget_tbl, p10_a0

2937: , p9_a27
2938: , p9_a28
2939: );
2940:
2941: ozf_offer_pub_oaw.rosetta_table_copy_in_p14(ddp_budget_tbl, p10_a0
2942: , p10_a1
2943: , p10_a2
2944: , p10_a3
2945: );

Line 2947: ozf_offer_pub_oaw.rosetta_table_copy_in_p2(ddp_act_product_tbl, p11_a0

2943: , p10_a2
2944: , p10_a3
2945: );
2946:
2947: ozf_offer_pub_oaw.rosetta_table_copy_in_p2(ddp_act_product_tbl, p11_a0
2948: , p11_a1
2949: , p11_a2
2950: , p11_a3
2951: , p11_a4

Line 2972: ozf_offer_pub_oaw.rosetta_table_copy_in_p4(ddp_discount_tbl, p12_a0

2968: , p11_a21
2969: , p11_a22
2970: );
2971:
2972: ozf_offer_pub_oaw.rosetta_table_copy_in_p4(ddp_discount_tbl, p12_a0
2973: , p12_a1
2974: , p12_a2
2975: , p12_a3
2976: , p12_a4

Line 3009: ozf_offer_pub_oaw.rosetta_table_copy_in_p8(ddp_excl_tbl, p13_a0

3005: , p12_a33
3006: , p12_a34
3007: );
3008:
3009: ozf_offer_pub_oaw.rosetta_table_copy_in_p8(ddp_excl_tbl, p13_a0
3010: , p13_a1
3011: , p13_a2
3012: , p13_a3
3013: , p13_a4

Line 3019: ozf_offer_pub_oaw.rosetta_table_copy_in_p10(ddp_offer_tier_tbl, p14_a0

3015: , p13_a6
3016: , p13_a7
3017: );
3018:
3019: ozf_offer_pub_oaw.rosetta_table_copy_in_p10(ddp_offer_tier_tbl, p14_a0
3020: , p14_a1
3021: , p14_a2
3022: , p14_a3
3023: , p14_a4

Line 3036: ozf_offer_pub_oaw.rosetta_table_copy_in_p6(ddp_prod_tbl, p15_a0

3032: , p14_a13
3033: , p14_a14
3034: );
3035:
3036: ozf_offer_pub_oaw.rosetta_table_copy_in_p6(ddp_prod_tbl, p15_a0
3037: , p15_a1
3038: , p15_a2
3039: , p15_a3
3040: , p15_a4

Line 3055: ozf_offer_pub_oaw.rosetta_table_copy_in_p12(ddp_na_qualifier_tbl, p16_a0

3051: , p15_a15
3052: , p15_a16
3053: );
3054:
3055: ozf_offer_pub_oaw.rosetta_table_copy_in_p12(ddp_na_qualifier_tbl, p16_a0
3056: , p16_a1
3057: , p16_a2
3058: , p16_a3
3059: , p16_a4

Line 3093: ozf_offer_pub.process_modifiers(p_init_msg_list,

3089:
3090:
3091:
3092: -- here's the delegated call to the old PL/SQL routine
3093: ozf_offer_pub.process_modifiers(p_init_msg_list,
3094: p_api_version,
3095: p_commit,
3096: x_return_status,
3097: x_msg_count,

Line 3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

3324: , x_error_location out nocopy NUMBER
3325: )
3326:
3327: as
3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

Line 3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;

3325: )
3326:
3327: as
3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

Line 3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;

3326:
3327: as
3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

Line 3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;

3327: as
3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3335: ddindx binary_integer; indx binary_integer;

Line 3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

3328: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3335: ddindx binary_integer; indx binary_integer;
3336: begin

Line 3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

3329: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3335: ddindx binary_integer; indx binary_integer;
3336: begin
3337:

Line 3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

3330: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3331: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3332: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3333: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3334: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3335: ddindx binary_integer; indx binary_integer;
3336: begin
3337:
3338: -- copy data to the local IN or IN-OUT args, if any

Line 3429: ozf_offer_pub_oaw.rosetta_table_copy_in_p21(ddp_vo_pbh_tbl, p7_a0

3425: ddp_modifier_list_rec.sales_method_flag := p6_a80;
3426: ddp_modifier_list_rec.global_flag := p6_a81;
3427: ddp_modifier_list_rec.orig_org_id := p6_a82;
3428:
3429: ozf_offer_pub_oaw.rosetta_table_copy_in_p21(ddp_vo_pbh_tbl, p7_a0
3430: , p7_a1
3431: , p7_a2
3432: , p7_a3
3433: , p7_a4

Line 3452: ozf_offer_pub_oaw.rosetta_table_copy_in_p21(ddp_vo_dis_tbl, p8_a0

3448: , p7_a19
3449: , p7_a20
3450: );
3451:
3452: ozf_offer_pub_oaw.rosetta_table_copy_in_p21(ddp_vo_dis_tbl, p8_a0
3453: , p8_a1
3454: , p8_a2
3455: , p8_a3
3456: , p8_a4

Line 3475: ozf_offer_pub_oaw.rosetta_table_copy_in_p23(ddp_vo_prod_tbl, p9_a0

3471: , p8_a19
3472: , p8_a20
3473: );
3474:
3475: ozf_offer_pub_oaw.rosetta_table_copy_in_p23(ddp_vo_prod_tbl, p9_a0
3476: , p9_a1
3477: , p9_a2
3478: , p9_a3
3479: , p9_a4

Line 3489: ozf_offer_pub_oaw.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p10_a0

3485: , p9_a10
3486: , p9_a11
3487: );
3488:
3489: ozf_offer_pub_oaw.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p10_a0
3490: , p10_a1
3491: , p10_a2
3492: , p10_a3
3493: , p10_a4

Line 3520: ozf_offer_pub_oaw.rosetta_table_copy_in_p25(ddp_vo_mo_tbl, p11_a0

3516: , p10_a27
3517: , p10_a28
3518: );
3519:
3520: ozf_offer_pub_oaw.rosetta_table_copy_in_p25(ddp_vo_mo_tbl, p11_a0
3521: , p11_a1
3522: , p11_a2
3523: , p11_a3
3524: , p11_a4

Line 3535: ozf_offer_pub_oaw.rosetta_table_copy_in_p14(ddp_budget_tbl, p12_a0

3531: , p11_a11
3532: , p11_a12
3533: );
3534:
3535: ozf_offer_pub_oaw.rosetta_table_copy_in_p14(ddp_budget_tbl, p12_a0
3536: , p12_a1
3537: , p12_a2
3538: , p12_a3
3539: );

Line 3544: ozf_offer_pub.process_vo(p_init_msg_list,

3540:
3541:
3542:
3543: -- here's the delegated call to the old PL/SQL routine
3544: ozf_offer_pub.process_vo(p_init_msg_list,
3545: p_api_version,
3546: p_commit,
3547: x_return_status,
3548: x_msg_count,

Line 3577: end ozf_offer_pub_oaw;

3573:
3574:
3575: end;
3576:
3577: end ozf_offer_pub_oaw;