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

Line 1: package body ozf_offer_pub_w as

1: package body ozf_offer_pub_w as
2: /* $Header: ozfwofpb.pls 120.3 2005/08/10 17:37 appldev 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_offer_pub.act_product_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_offer_pub.act_product_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

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

81: end loop;
82: end if;
83: end if;
84: end rosetta_table_copy_in_p2;
85: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_VARCHAR2_TABLE_100
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

215: end if;
216: end if;
217: end rosetta_table_copy_out_p2;
218:
219: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
220: , a1 JTF_NUMBER_TABLE
221: , a2 JTF_NUMBER_TABLE
222: , a3 JTF_NUMBER_TABLE
223: , a4 JTF_VARCHAR2_TABLE_100

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

302: end loop;
303: end if;
304: end if;
305: end rosetta_table_copy_in_p4;
306: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
307: , a1 out nocopy JTF_NUMBER_TABLE
308: , a2 out nocopy JTF_NUMBER_TABLE
309: , a3 out nocopy JTF_NUMBER_TABLE
310: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

496: end if;
497: end if;
498: end rosetta_table_copy_out_p4;
499:
500: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
501: , a1 JTF_NUMBER_TABLE
502: , a2 JTF_VARCHAR2_TABLE_100
503: , a3 JTF_NUMBER_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100

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

547: end loop;
548: end if;
549: end if;
550: end rosetta_table_copy_in_p6;
551: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
552: , a1 out nocopy JTF_NUMBER_TABLE
553: , a2 out nocopy JTF_VARCHAR2_TABLE_100
554: , a3 out nocopy JTF_NUMBER_TABLE
555: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

651: end if;
652: end if;
653: end rosetta_table_copy_out_p6;
654:
655: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
656: , a1 JTF_NUMBER_TABLE
657: , a2 JTF_VARCHAR2_TABLE_100
658: , a3 JTF_NUMBER_TABLE
659: , a4 JTF_NUMBER_TABLE

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

684: end loop;
685: end if;
686: end if;
687: end rosetta_table_copy_in_p8;
688: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
689: , a1 out nocopy JTF_NUMBER_TABLE
690: , a2 out nocopy JTF_VARCHAR2_TABLE_100
691: , a3 out nocopy JTF_NUMBER_TABLE
692: , a4 out nocopy JTF_NUMBER_TABLE

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

743: end if;
744: end if;
745: end rosetta_table_copy_out_p8;
746:
747: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
748: , a1 JTF_NUMBER_TABLE
749: , a2 JTF_NUMBER_TABLE
750: , a3 JTF_NUMBER_TABLE
751: , a4 JTF_NUMBER_TABLE

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

790: end loop;
791: end if;
792: end if;
793: end rosetta_table_copy_in_p10;
794: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
795: , a1 out nocopy JTF_NUMBER_TABLE
796: , a2 out nocopy JTF_NUMBER_TABLE
797: , a3 out nocopy JTF_NUMBER_TABLE
798: , a4 out nocopy JTF_NUMBER_TABLE

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

884: end if;
885: end if;
886: end rosetta_table_copy_out_p10;
887:
888: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
889: , a1 JTF_DATE_TABLE
890: , a2 JTF_NUMBER_TABLE
891: , a3 JTF_DATE_TABLE
892: , a4 JTF_NUMBER_TABLE

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

967: end loop;
968: end if;
969: end if;
970: end rosetta_table_copy_in_p12;
971: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
972: , a1 out nocopy JTF_DATE_TABLE
973: , a2 out nocopy JTF_NUMBER_TABLE
974: , a3 out nocopy JTF_DATE_TABLE
975: , a4 out nocopy JTF_NUMBER_TABLE

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

1151: end if;
1152: end if;
1153: end rosetta_table_copy_out_p12;
1154:
1155: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
1156: , a1 JTF_NUMBER_TABLE
1157: , a2 JTF_NUMBER_TABLE
1158: , a3 JTF_VARCHAR2_TABLE_100
1159: ) as

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

1176: end loop;
1177: end if;
1178: end if;
1179: end rosetta_table_copy_in_p14;
1180: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1181: , a1 out nocopy JTF_NUMBER_TABLE
1182: , a2 out nocopy JTF_NUMBER_TABLE
1183: , a3 out nocopy JTF_VARCHAR2_TABLE_100
1184: ) as

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

1215: end if;
1216: end if;
1217: end rosetta_table_copy_out_p14;
1218:
1219: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1220: , a1 JTF_VARCHAR2_TABLE_100
1221: , a2 JTF_NUMBER_TABLE
1222: , a3 JTF_NUMBER_TABLE
1223: , a4 JTF_VARCHAR2_TABLE_100

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

1374: end loop;
1375: end if;
1376: end if;
1377: end rosetta_table_copy_in_p17;
1378: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1379: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1380: , a2 out nocopy JTF_NUMBER_TABLE
1381: , a3 out nocopy JTF_NUMBER_TABLE
1382: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

1748: end if;
1749: end if;
1750: end rosetta_table_copy_out_p17;
1751:
1752: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
1753: , a1 JTF_VARCHAR2_TABLE_100
1754: , a2 JTF_VARCHAR2_TABLE_300
1755: , a3 JTF_VARCHAR2_TABLE_300
1756: , a4 JTF_VARCHAR2_TABLE_100

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

1823: end loop;
1824: end if;
1825: end if;
1826: end rosetta_table_copy_in_p19;
1827: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
1828: , a1 out nocopy JTF_VARCHAR2_TABLE_100
1829: , a2 out nocopy JTF_VARCHAR2_TABLE_300
1830: , a3 out nocopy JTF_VARCHAR2_TABLE_300
1831: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

1987: end if;
1988: end if;
1989: end rosetta_table_copy_out_p19;
1990:
1991: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
1992: , a1 JTF_NUMBER_TABLE
1993: , a2 JTF_NUMBER_TABLE
1994: , a3 JTF_NUMBER_TABLE
1995: , a4 JTF_VARCHAR2_TABLE_100

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

2046: end loop;
2047: end if;
2048: end if;
2049: end rosetta_table_copy_in_p21;
2050: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2051: , a1 out nocopy JTF_NUMBER_TABLE
2052: , a2 out nocopy JTF_NUMBER_TABLE
2053: , a3 out nocopy JTF_NUMBER_TABLE
2054: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

2170: end if;
2171: end if;
2172: end rosetta_table_copy_out_p21;
2173:
2174: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
2175: , a1 JTF_VARCHAR2_TABLE_100
2176: , a2 JTF_NUMBER_TABLE
2177: , a3 JTF_NUMBER_TABLE
2178: , a4 JTF_NUMBER_TABLE

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

2211: end loop;
2212: end if;
2213: end if;
2214: end rosetta_table_copy_in_p23;
2215: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2216: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2217: , a2 out nocopy JTF_NUMBER_TABLE
2218: , a3 out nocopy JTF_NUMBER_TABLE
2219: , a4 out nocopy JTF_NUMBER_TABLE

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

2290: end if;
2291: end if;
2292: end rosetta_table_copy_out_p23;
2293:
2294: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
2295: , a1 JTF_NUMBER_TABLE
2296: , a2 JTF_NUMBER_TABLE
2297: , a3 JTF_NUMBER_TABLE
2298: , a4 JTF_VARCHAR2_TABLE_100

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

2333: end loop;
2334: end if;
2335: end if;
2336: end rosetta_table_copy_in_p25;
2337: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
2338: , a1 out nocopy JTF_NUMBER_TABLE
2339: , a2 out nocopy JTF_NUMBER_TABLE
2340: , a3 out nocopy JTF_NUMBER_TABLE
2341: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

2747: , p7_a82 NUMBER := 0-1962.0724
2748: )
2749:
2750: as
2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;

Line 2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;

2748: )
2749:
2750: as
2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;

Line 2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

2749:
2750: as
2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

Line 2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

2750: as
2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

Line 2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;

2751: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

Line 2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;

2752: ddp_modifier_line_tbl ozf_offer_pub.modifier_line_tbl_type;
2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

Line 2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;

2753: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2761: ddindx binary_integer; indx binary_integer;

Line 2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;

2754: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2761: ddindx binary_integer; indx binary_integer;
2762: begin

Line 2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;

2755: ddp_act_product_tbl ozf_offer_pub.act_product_tbl_type;
2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2761: ddindx binary_integer; indx binary_integer;
2762: begin
2763:

Line 2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;

2756: ddp_discount_tbl ozf_offer_pub.discount_line_tbl_type;
2757: ddp_excl_tbl ozf_offer_pub.excl_rec_tbl_type;
2758: ddp_offer_tier_tbl ozf_offer_pub.offer_tier_tbl_type;
2759: ddp_prod_tbl ozf_offer_pub.prod_rec_tbl_type;
2760: ddp_na_qualifier_tbl ozf_offer_pub.na_qualifier_tbl_type;
2761: ddindx binary_integer; indx binary_integer;
2762: begin
2763:
2764: -- copy data to the local IN or IN-OUT args, if any

Line 2856: ozf_offer_pub_w.rosetta_table_copy_in_p17(ddp_modifier_line_tbl, p8_a0

2852: ddp_modifier_list_rec.sales_method_flag := p7_a80;
2853: ddp_modifier_list_rec.global_flag := p7_a81;
2854: ddp_modifier_list_rec.orig_org_id := rosetta_g_miss_num_map(p7_a82);
2855:
2856: ozf_offer_pub_w.rosetta_table_copy_in_p17(ddp_modifier_line_tbl, p8_a0
2857: , p8_a1
2858: , p8_a2
2859: , p8_a3
2860: , p8_a4

Line 2929: ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p9_a0

2925: , p8_a69
2926: , p8_a70
2927: );
2928:
2929: ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p9_a0
2930: , p9_a1
2931: , p9_a2
2932: , p9_a3
2933: , p9_a4

Line 2960: ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p10_a0

2956: , p9_a27
2957: , p9_a28
2958: );
2959:
2960: ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p10_a0
2961: , p10_a1
2962: , p10_a2
2963: , p10_a3
2964: );

Line 2966: ozf_offer_pub_w.rosetta_table_copy_in_p2(ddp_act_product_tbl, p11_a0

2962: , p10_a2
2963: , p10_a3
2964: );
2965:
2966: ozf_offer_pub_w.rosetta_table_copy_in_p2(ddp_act_product_tbl, p11_a0
2967: , p11_a1
2968: , p11_a2
2969: , p11_a3
2970: , p11_a4

Line 2991: ozf_offer_pub_w.rosetta_table_copy_in_p4(ddp_discount_tbl, p12_a0

2987: , p11_a21
2988: , p11_a22
2989: );
2990:
2991: ozf_offer_pub_w.rosetta_table_copy_in_p4(ddp_discount_tbl, p12_a0
2992: , p12_a1
2993: , p12_a2
2994: , p12_a3
2995: , p12_a4

Line 3028: ozf_offer_pub_w.rosetta_table_copy_in_p8(ddp_excl_tbl, p13_a0

3024: , p12_a33
3025: , p12_a34
3026: );
3027:
3028: ozf_offer_pub_w.rosetta_table_copy_in_p8(ddp_excl_tbl, p13_a0
3029: , p13_a1
3030: , p13_a2
3031: , p13_a3
3032: , p13_a4

Line 3038: ozf_offer_pub_w.rosetta_table_copy_in_p10(ddp_offer_tier_tbl, p14_a0

3034: , p13_a6
3035: , p13_a7
3036: );
3037:
3038: ozf_offer_pub_w.rosetta_table_copy_in_p10(ddp_offer_tier_tbl, p14_a0
3039: , p14_a1
3040: , p14_a2
3041: , p14_a3
3042: , p14_a4

Line 3055: ozf_offer_pub_w.rosetta_table_copy_in_p6(ddp_prod_tbl, p15_a0

3051: , p14_a13
3052: , p14_a14
3053: );
3054:
3055: ozf_offer_pub_w.rosetta_table_copy_in_p6(ddp_prod_tbl, p15_a0
3056: , p15_a1
3057: , p15_a2
3058: , p15_a3
3059: , p15_a4

Line 3074: ozf_offer_pub_w.rosetta_table_copy_in_p12(ddp_na_qualifier_tbl, p16_a0

3070: , p15_a15
3071: , p15_a16
3072: );
3073:
3074: ozf_offer_pub_w.rosetta_table_copy_in_p12(ddp_na_qualifier_tbl, p16_a0
3075: , p16_a1
3076: , p16_a2
3077: , p16_a3
3078: , p16_a4

Line 3112: ozf_offer_pub.process_modifiers(p_init_msg_list,

3108:
3109:
3110:
3111: -- here's the delegated call to the old PL/SQL routine
3112: ozf_offer_pub.process_modifiers(p_init_msg_list,
3113: p_api_version,
3114: p_commit,
3115: x_return_status,
3116: x_msg_count,

Line 3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;

3343: , p6_a82 NUMBER := 0-1962.0724
3344: )
3345:
3346: as
3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

Line 3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;

3344: )
3345:
3346: as
3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

Line 3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;

3345:
3346: as
3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

Line 3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;

3346: as
3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3354: ddindx binary_integer; indx binary_integer;

Line 3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;

3347: ddp_modifier_list_rec ozf_offer_pub.modifier_list_rec_type;
3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3354: ddindx binary_integer; indx binary_integer;
3355: begin

Line 3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;

3348: ddp_vo_pbh_tbl ozf_offer_pub.vo_disc_tbl_type;
3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3354: ddindx binary_integer; indx binary_integer;
3355: begin
3356:

Line 3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;

3349: ddp_vo_dis_tbl ozf_offer_pub.vo_disc_tbl_type;
3350: ddp_vo_prod_tbl ozf_offer_pub.vo_prod_tbl_type;
3351: ddp_qualifier_tbl ozf_offer_pub.qualifiers_tbl_type;
3352: ddp_vo_mo_tbl ozf_offer_pub.vo_mo_tbl_type;
3353: ddp_budget_tbl ozf_offer_pub.budget_tbl_type;
3354: ddindx binary_integer; indx binary_integer;
3355: begin
3356:
3357: -- copy data to the local IN or IN-OUT args, if any

Line 3448: ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_pbh_tbl, p7_a0

3444: ddp_modifier_list_rec.sales_method_flag := p6_a80;
3445: ddp_modifier_list_rec.global_flag := p6_a81;
3446: ddp_modifier_list_rec.orig_org_id := rosetta_g_miss_num_map(p6_a82);
3447:
3448: ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_pbh_tbl, p7_a0
3449: , p7_a1
3450: , p7_a2
3451: , p7_a3
3452: , p7_a4

Line 3471: ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_dis_tbl, p8_a0

3467: , p7_a19
3468: , p7_a20
3469: );
3470:
3471: ozf_offer_pub_w.rosetta_table_copy_in_p21(ddp_vo_dis_tbl, p8_a0
3472: , p8_a1
3473: , p8_a2
3474: , p8_a3
3475: , p8_a4

Line 3494: ozf_offer_pub_w.rosetta_table_copy_in_p23(ddp_vo_prod_tbl, p9_a0

3490: , p8_a19
3491: , p8_a20
3492: );
3493:
3494: ozf_offer_pub_w.rosetta_table_copy_in_p23(ddp_vo_prod_tbl, p9_a0
3495: , p9_a1
3496: , p9_a2
3497: , p9_a3
3498: , p9_a4

Line 3508: ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p10_a0

3504: , p9_a10
3505: , p9_a11
3506: );
3507:
3508: ozf_offer_pub_w.rosetta_table_copy_in_p19(ddp_qualifier_tbl, p10_a0
3509: , p10_a1
3510: , p10_a2
3511: , p10_a3
3512: , p10_a4

Line 3539: ozf_offer_pub_w.rosetta_table_copy_in_p25(ddp_vo_mo_tbl, p11_a0

3535: , p10_a27
3536: , p10_a28
3537: );
3538:
3539: ozf_offer_pub_w.rosetta_table_copy_in_p25(ddp_vo_mo_tbl, p11_a0
3540: , p11_a1
3541: , p11_a2
3542: , p11_a3
3543: , p11_a4

Line 3554: ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p12_a0

3550: , p11_a11
3551: , p11_a12
3552: );
3553:
3554: ozf_offer_pub_w.rosetta_table_copy_in_p14(ddp_budget_tbl, p12_a0
3555: , p12_a1
3556: , p12_a2
3557: , p12_a3
3558: );

Line 3563: ozf_offer_pub.process_vo(p_init_msg_list,

3559:
3560:
3561:
3562: -- here's the delegated call to the old PL/SQL routine
3563: ozf_offer_pub.process_vo(p_init_msg_list,
3564: p_api_version,
3565: p_commit,
3566: x_return_status,
3567: x_msg_count,

Line 3596: end ozf_offer_pub_w;

3592:
3593:
3594: end;
3595:
3596: end ozf_offer_pub_w;