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 ozf_offer_pub_w AUTHID CURRENT_USER as

1: package ozf_offer_pub_w AUTHID CURRENT_USER as
2: /* $Header: ozfwofps.pls 120.3 2005/08/10 17:36 appldev ship $ */
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 ozf_offer_pub_w AUTHID CURRENT_USER as
2: /* $Header: ozfwofps.pls 120.3 2005/08/10 17:36 appldev ship $ */
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 27: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_100
26: );
27: procedure rosetta_table_copy_out_p2(t ozf_offer_pub.act_product_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
28: , a1 out nocopy JTF_NUMBER_TABLE
29: , a2 out nocopy JTF_NUMBER_TABLE
30: , a3 out nocopy JTF_VARCHAR2_TABLE_100
31: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

48: , a21 out nocopy JTF_NUMBER_TABLE
49: , a22 out nocopy JTF_VARCHAR2_TABLE_100
50: );
51:
52: procedure rosetta_table_copy_in_p4(t out nocopy ozf_offer_pub.discount_line_tbl_type, a0 JTF_NUMBER_TABLE
53: , a1 JTF_NUMBER_TABLE
54: , a2 JTF_NUMBER_TABLE
55: , a3 JTF_NUMBER_TABLE
56: , a4 JTF_VARCHAR2_TABLE_100

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

84: , a32 JTF_NUMBER_TABLE
85: , a33 JTF_VARCHAR2_TABLE_100
86: , a34 JTF_VARCHAR2_TABLE_100
87: );
88: procedure rosetta_table_copy_out_p4(t ozf_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

121: , a33 out nocopy JTF_VARCHAR2_TABLE_100
122: , a34 out nocopy JTF_VARCHAR2_TABLE_100
123: );
124:
125: procedure rosetta_table_copy_in_p6(t out nocopy ozf_offer_pub.prod_rec_tbl_type, a0 JTF_NUMBER_TABLE
126: , a1 JTF_NUMBER_TABLE
127: , a2 JTF_VARCHAR2_TABLE_100
128: , a3 JTF_NUMBER_TABLE
129: , a4 JTF_VARCHAR2_TABLE_100

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

139: , a14 JTF_NUMBER_TABLE
140: , a15 JTF_NUMBER_TABLE
141: , a16 JTF_VARCHAR2_TABLE_100
142: );
143: procedure rosetta_table_copy_out_p6(t ozf_offer_pub.prod_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

158: , a15 out nocopy JTF_NUMBER_TABLE
159: , a16 out nocopy JTF_VARCHAR2_TABLE_100
160: );
161:
162: procedure rosetta_table_copy_in_p8(t out nocopy ozf_offer_pub.excl_rec_tbl_type, a0 JTF_NUMBER_TABLE
163: , a1 JTF_NUMBER_TABLE
164: , a2 JTF_VARCHAR2_TABLE_100
165: , a3 JTF_NUMBER_TABLE
166: , a4 JTF_NUMBER_TABLE

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

167: , a5 JTF_DATE_TABLE
168: , a6 JTF_DATE_TABLE
169: , a7 JTF_VARCHAR2_TABLE_100
170: );
171: procedure rosetta_table_copy_out_p8(t ozf_offer_pub.excl_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
172: , a1 out nocopy JTF_NUMBER_TABLE
173: , a2 out nocopy JTF_VARCHAR2_TABLE_100
174: , a3 out nocopy JTF_NUMBER_TABLE
175: , a4 out nocopy JTF_NUMBER_TABLE

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

177: , a6 out nocopy JTF_DATE_TABLE
178: , a7 out nocopy JTF_VARCHAR2_TABLE_100
179: );
180:
181: procedure rosetta_table_copy_in_p10(t out nocopy ozf_offer_pub.offer_tier_tbl_type, a0 JTF_NUMBER_TABLE
182: , a1 JTF_NUMBER_TABLE
183: , a2 JTF_NUMBER_TABLE
184: , a3 JTF_NUMBER_TABLE
185: , a4 JTF_NUMBER_TABLE

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

193: , a12 JTF_VARCHAR2_TABLE_100
194: , a13 JTF_NUMBER_TABLE
195: , a14 JTF_VARCHAR2_TABLE_100
196: );
197: procedure rosetta_table_copy_out_p10(t ozf_offer_pub.offer_tier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
198: , a1 out nocopy JTF_NUMBER_TABLE
199: , a2 out nocopy JTF_NUMBER_TABLE
200: , a3 out nocopy JTF_NUMBER_TABLE
201: , a4 out nocopy JTF_NUMBER_TABLE

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

210: , a13 out nocopy JTF_NUMBER_TABLE
211: , a14 out nocopy JTF_VARCHAR2_TABLE_100
212: );
213:
214: procedure rosetta_table_copy_in_p12(t out nocopy ozf_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
215: , a1 JTF_DATE_TABLE
216: , a2 JTF_NUMBER_TABLE
217: , a3 JTF_DATE_TABLE
218: , a4 JTF_NUMBER_TABLE

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

244: , a30 JTF_VARCHAR2_TABLE_100
245: , a31 JTF_NUMBER_TABLE
246: , a32 JTF_VARCHAR2_TABLE_100
247: );
248: procedure rosetta_table_copy_out_p12(t ozf_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
249: , a1 out nocopy JTF_DATE_TABLE
250: , a2 out nocopy JTF_NUMBER_TABLE
251: , a3 out nocopy JTF_DATE_TABLE
252: , a4 out nocopy JTF_NUMBER_TABLE

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

279: , a31 out nocopy JTF_NUMBER_TABLE
280: , a32 out nocopy JTF_VARCHAR2_TABLE_100
281: );
282:
283: procedure rosetta_table_copy_in_p14(t out nocopy ozf_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_VARCHAR2_TABLE_100
287: );

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

284: , a1 JTF_NUMBER_TABLE
285: , a2 JTF_NUMBER_TABLE
286: , a3 JTF_VARCHAR2_TABLE_100
287: );
288: procedure rosetta_table_copy_out_p14(t ozf_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
289: , a1 out nocopy JTF_NUMBER_TABLE
290: , a2 out nocopy JTF_NUMBER_TABLE
291: , a3 out nocopy JTF_VARCHAR2_TABLE_100
292: );

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

290: , a2 out nocopy JTF_NUMBER_TABLE
291: , a3 out nocopy JTF_VARCHAR2_TABLE_100
292: );
293:
294: procedure rosetta_table_copy_in_p17(t out nocopy ozf_offer_pub.modifier_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
295: , a1 JTF_VARCHAR2_TABLE_100
296: , a2 JTF_NUMBER_TABLE
297: , a3 JTF_NUMBER_TABLE
298: , a4 JTF_VARCHAR2_TABLE_100

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

362: , a68 JTF_NUMBER_TABLE
363: , a69 JTF_VARCHAR2_TABLE_300
364: , a70 JTF_VARCHAR2_TABLE_300
365: );
366: procedure rosetta_table_copy_out_p17(t ozf_offer_pub.modifier_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
367: , a1 out nocopy JTF_VARCHAR2_TABLE_100
368: , a2 out nocopy JTF_NUMBER_TABLE
369: , a3 out nocopy JTF_NUMBER_TABLE
370: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

435: , a69 out nocopy JTF_VARCHAR2_TABLE_300
436: , a70 out nocopy JTF_VARCHAR2_TABLE_300
437: );
438:
439: procedure rosetta_table_copy_in_p19(t out nocopy ozf_offer_pub.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
440: , a1 JTF_VARCHAR2_TABLE_100
441: , a2 JTF_VARCHAR2_TABLE_300
442: , a3 JTF_VARCHAR2_TABLE_300
443: , a4 JTF_VARCHAR2_TABLE_100

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

465: , a26 JTF_VARCHAR2_TABLE_300
466: , a27 JTF_VARCHAR2_TABLE_300
467: , a28 JTF_VARCHAR2_TABLE_300
468: );
469: procedure rosetta_table_copy_out_p19(t ozf_offer_pub.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
470: , a1 out nocopy JTF_VARCHAR2_TABLE_100
471: , a2 out nocopy JTF_VARCHAR2_TABLE_300
472: , a3 out nocopy JTF_VARCHAR2_TABLE_300
473: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

496: , a27 out nocopy JTF_VARCHAR2_TABLE_300
497: , a28 out nocopy JTF_VARCHAR2_TABLE_300
498: );
499:
500: procedure rosetta_table_copy_in_p21(t out nocopy ozf_offer_pub.vo_disc_tbl_type, a0 JTF_NUMBER_TABLE
501: , a1 JTF_NUMBER_TABLE
502: , a2 JTF_NUMBER_TABLE
503: , a3 JTF_NUMBER_TABLE
504: , a4 JTF_VARCHAR2_TABLE_100

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

518: , a18 JTF_VARCHAR2_TABLE_2000
519: , a19 JTF_VARCHAR2_TABLE_100
520: , a20 JTF_NUMBER_TABLE
521: );
522: procedure rosetta_table_copy_out_p21(t ozf_offer_pub.vo_disc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
523: , a1 out nocopy JTF_NUMBER_TABLE
524: , a2 out nocopy JTF_NUMBER_TABLE
525: , a3 out nocopy JTF_NUMBER_TABLE
526: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

541: , a19 out nocopy JTF_VARCHAR2_TABLE_100
542: , a20 out nocopy JTF_NUMBER_TABLE
543: );
544:
545: procedure rosetta_table_copy_in_p23(t out nocopy ozf_offer_pub.vo_prod_tbl_type, a0 JTF_NUMBER_TABLE
546: , a1 JTF_VARCHAR2_TABLE_100
547: , a2 JTF_NUMBER_TABLE
548: , a3 JTF_NUMBER_TABLE
549: , a4 JTF_NUMBER_TABLE

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

554: , a9 JTF_VARCHAR2_TABLE_100
555: , a10 JTF_VARCHAR2_TABLE_100
556: , a11 JTF_NUMBER_TABLE
557: );
558: procedure rosetta_table_copy_out_p23(t ozf_offer_pub.vo_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
559: , a1 out nocopy JTF_VARCHAR2_TABLE_100
560: , a2 out nocopy JTF_NUMBER_TABLE
561: , a3 out nocopy JTF_NUMBER_TABLE
562: , a4 out nocopy JTF_NUMBER_TABLE

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

568: , a10 out nocopy JTF_VARCHAR2_TABLE_100
569: , a11 out nocopy JTF_NUMBER_TABLE
570: );
571:
572: procedure rosetta_table_copy_in_p25(t out nocopy ozf_offer_pub.vo_mo_tbl_type, a0 JTF_NUMBER_TABLE
573: , a1 JTF_NUMBER_TABLE
574: , a2 JTF_NUMBER_TABLE
575: , a3 JTF_NUMBER_TABLE
576: , a4 JTF_VARCHAR2_TABLE_100

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

582: , a10 JTF_NUMBER_TABLE
583: , a11 JTF_NUMBER_TABLE
584: , a12 JTF_VARCHAR2_TABLE_100
585: );
586: procedure rosetta_table_copy_out_p25(t ozf_offer_pub.vo_mo_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
587: , a1 out nocopy JTF_NUMBER_TABLE
588: , a2 out nocopy JTF_NUMBER_TABLE
589: , a3 out nocopy JTF_NUMBER_TABLE
590: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 1121: end ozf_offer_pub_w;

1117: , p6_a80 VARCHAR2 := fnd_api.g_miss_char
1118: , p6_a81 VARCHAR2 := fnd_api.g_miss_char
1119: , p6_a82 NUMBER := 0-1962.0724
1120: );
1121: end ozf_offer_pub_w;