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.PV_OFFER_PUB_W dependencies on PV_OFFER_PUB

Line 1: package body pv_offer_pub_w as

1: package body pv_offer_pub_w as
2: /* $Header: pvxwoffb.pls 120.1 2005/06/16 17:26 appldev $ */
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 pv_offer_pub.discount_line_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 pv_offer_pub.discount_line_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 59: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

55: end loop;
56: end if;
57: end if;
58: end rosetta_table_copy_in_p2;
59: procedure rosetta_table_copy_out_p2(t pv_offer_pub.discount_line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_NUMBER_TABLE
61: , a2 out nocopy JTF_NUMBER_TABLE
62: , a3 out nocopy JTF_VARCHAR2_TABLE_100
63: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 128: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE

124: end if;
125: end if;
126: end rosetta_table_copy_out_p2;
127:
128: procedure rosetta_table_copy_in_p4(t out nocopy pv_offer_pub.na_qualifier_tbl_type, a0 JTF_NUMBER_TABLE
129: , a1 JTF_VARCHAR2_TABLE_100
130: , a2 JTF_VARCHAR2_TABLE_100
131: , a3 JTF_VARCHAR2_TABLE_300
132: , a4 JTF_NUMBER_TABLE

Line 157: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

153: end loop;
154: end if;
155: end if;
156: end rosetta_table_copy_in_p4;
157: procedure rosetta_table_copy_out_p4(t pv_offer_pub.na_qualifier_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
158: , a1 out nocopy JTF_VARCHAR2_TABLE_100
159: , a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , a3 out nocopy JTF_VARCHAR2_TABLE_300
161: , a4 out nocopy JTF_NUMBER_TABLE

Line 206: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE

202: end if;
203: end if;
204: end rosetta_table_copy_out_p4;
205:
206: procedure rosetta_table_copy_in_p6(t out nocopy pv_offer_pub.budget_tbl_type, a0 JTF_NUMBER_TABLE
207: , a1 JTF_NUMBER_TABLE
208: , a2 JTF_NUMBER_TABLE
209: , a3 JTF_VARCHAR2_TABLE_100
210: ) as

Line 231: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

227: end loop;
228: end if;
229: end if;
230: end rosetta_table_copy_in_p6;
231: procedure rosetta_table_copy_out_p6(t pv_offer_pub.budget_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
232: , a1 out nocopy JTF_NUMBER_TABLE
233: , a2 out nocopy JTF_NUMBER_TABLE
234: , a3 out nocopy JTF_VARCHAR2_TABLE_100
235: ) as

Line 324: ddp_modifier_list_rec pv_offer_pub.modifier_list_rec_type;

320: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
321: )
322:
323: as
324: ddp_modifier_list_rec pv_offer_pub.modifier_list_rec_type;
325: ddp_budget_tbl pv_offer_pub.budget_tbl_type;
326: ddp_discount_tbl pv_offer_pub.discount_line_tbl_type;
327: ddp_na_qualifier_tbl pv_offer_pub.na_qualifier_tbl_type;
328: ddindx binary_integer; indx binary_integer;

Line 325: ddp_budget_tbl pv_offer_pub.budget_tbl_type;

321: )
322:
323: as
324: ddp_modifier_list_rec pv_offer_pub.modifier_list_rec_type;
325: ddp_budget_tbl pv_offer_pub.budget_tbl_type;
326: ddp_discount_tbl pv_offer_pub.discount_line_tbl_type;
327: ddp_na_qualifier_tbl pv_offer_pub.na_qualifier_tbl_type;
328: ddindx binary_integer; indx binary_integer;
329: begin

Line 326: ddp_discount_tbl pv_offer_pub.discount_line_tbl_type;

322:
323: as
324: ddp_modifier_list_rec pv_offer_pub.modifier_list_rec_type;
325: ddp_budget_tbl pv_offer_pub.budget_tbl_type;
326: ddp_discount_tbl pv_offer_pub.discount_line_tbl_type;
327: ddp_na_qualifier_tbl pv_offer_pub.na_qualifier_tbl_type;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:

Line 327: ddp_na_qualifier_tbl pv_offer_pub.na_qualifier_tbl_type;

323: as
324: ddp_modifier_list_rec pv_offer_pub.modifier_list_rec_type;
325: ddp_budget_tbl pv_offer_pub.budget_tbl_type;
326: ddp_discount_tbl pv_offer_pub.discount_line_tbl_type;
327: ddp_na_qualifier_tbl pv_offer_pub.na_qualifier_tbl_type;
328: ddindx binary_integer; indx binary_integer;
329: begin
330:
331: -- copy data to the local IN or IN-OUT args, if any

Line 358: pv_offer_pub_w.rosetta_table_copy_in_p6(ddp_budget_tbl, p7_a0

354: ddp_modifier_list_rec.modifier_operation := p6_a16;
355: ddp_modifier_list_rec.budget_offer_yn := p6_a17;
356: ddp_modifier_list_rec.tier_level := p6_a18;
357:
358: pv_offer_pub_w.rosetta_table_copy_in_p6(ddp_budget_tbl, p7_a0
359: , p7_a1
360: , p7_a2
361: , p7_a3
362: );

Line 364: pv_offer_pub_w.rosetta_table_copy_in_p2(ddp_discount_tbl, p8_a0

360: , p7_a2
361: , p7_a3
362: );
363:
364: pv_offer_pub_w.rosetta_table_copy_in_p2(ddp_discount_tbl, p8_a0
365: , p8_a1
366: , p8_a2
367: , p8_a3
368: , p8_a4

Line 376: pv_offer_pub_w.rosetta_table_copy_in_p4(ddp_na_qualifier_tbl, p9_a0

372: , p8_a8
373: , p8_a9
374: );
375:
376: pv_offer_pub_w.rosetta_table_copy_in_p4(ddp_na_qualifier_tbl, p9_a0
377: , p9_a1
378: , p9_a2
379: , p9_a3
380: , p9_a4

Line 391: pv_offer_pub.create_offer(p_init_msg_list,

387:
388:
389:
390: -- here's the delegated call to the old PL/SQL routine
391: pv_offer_pub.create_offer(p_init_msg_list,
392: p_api_version,
393: p_commit,
394: p_benefit_id,
395: p_operation,

Line 426: end pv_offer_pub_w;

422:
423:
424: end;
425:
426: end pv_offer_pub_w;