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_PRICELIST_PVT_W dependencies on OZF_PRICELIST_PVT

Line 1: package body ozf_pricelist_pvt_w as

1: package body ozf_pricelist_pvt_w as
2: /* $Header: ozfwpltb.pls 120.1 2005/08/17 17:56 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_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p3(t out nocopy ozf_pricelist_pvt.qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_DATE_TABLE
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_NUMBER_TABLE

Line 103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

99: end loop;
100: end if;
101: end if;
102: end rosetta_table_copy_in_p3;
103: procedure rosetta_table_copy_out_p3(t ozf_pricelist_pvt.qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_DATE_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_NUMBER_TABLE

Line 282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100

278: end if;
279: end if;
280: end rosetta_table_copy_out_p3;
281:
282: procedure rosetta_table_copy_in_p5(t out nocopy ozf_pricelist_pvt.price_list_line_tbl_type, a0 JTF_VARCHAR2_TABLE_100
283: , a1 JTF_DATE_TABLE
284: , a2 JTF_NUMBER_TABLE
285: , a3 JTF_NUMBER_TABLE
286: , a4 JTF_NUMBER_TABLE

Line 361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

357: end loop;
358: end if;
359: end if;
360: end rosetta_table_copy_in_p5;
361: procedure rosetta_table_copy_out_p5(t ozf_pricelist_pvt.price_list_line_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
362: , a1 out nocopy JTF_DATE_TABLE
363: , a2 out nocopy JTF_NUMBER_TABLE
364: , a3 out nocopy JTF_NUMBER_TABLE
365: , a4 out nocopy JTF_NUMBER_TABLE

Line 535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE

531: end if;
532: end if;
533: end rosetta_table_copy_out_p5;
534:
535: procedure rosetta_table_copy_in_p7(t out nocopy ozf_pricelist_pvt.pricing_attr_tbl_type, a0 JTF_NUMBER_TABLE
536: , a1 JTF_VARCHAR2_TABLE_100
537: , a2 JTF_VARCHAR2_TABLE_100
538: , a3 JTF_NUMBER_TABLE
539: , a4 JTF_VARCHAR2_TABLE_300

Line 580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

576: end loop;
577: end if;
578: end if;
579: end rosetta_table_copy_in_p7;
580: procedure rosetta_table_copy_out_p7(t ozf_pricelist_pvt.pricing_attr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
581: , a1 out nocopy JTF_VARCHAR2_TABLE_100
582: , a2 out nocopy JTF_VARCHAR2_TABLE_100
583: , a3 out nocopy JTF_NUMBER_TABLE
584: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 669: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

665: end if;
666: end if;
667: end rosetta_table_copy_out_p7;
668:
669: procedure rosetta_table_copy_in_p12(t out nocopy ozf_pricelist_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
670: ddindx binary_integer; indx binary_integer;
671: begin
672: if a0 is not null and a0.count > 0 then
673: if a0.count > 0 then

Line 687: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

683: end loop;
684: end if;
685: end if;
686: end rosetta_table_copy_in_p12;
687: procedure rosetta_table_copy_out_p12(t ozf_pricelist_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
688: ddindx binary_integer; indx binary_integer;
689: begin
690: if t is null or t.count = 0 then
691: a0 := JTF_NUMBER_TABLE();

Line 836: ddp_price_list_rec ozf_pricelist_pvt.ozf_price_list_rec_type;

832: , p7_a35 NUMBER := 0-1962.0724
833: )
834:
835: as
836: ddp_price_list_rec ozf_pricelist_pvt.ozf_price_list_rec_type;
837: ddp_price_list_line_tbl ozf_pricelist_pvt.price_list_line_tbl_type;
838: ddp_pricing_attr_tbl ozf_pricelist_pvt.pricing_attr_tbl_type;
839: ddp_qualifiers_tbl ozf_pricelist_pvt.qualifiers_tbl_type;
840: ddindx binary_integer; indx binary_integer;

Line 837: ddp_price_list_line_tbl ozf_pricelist_pvt.price_list_line_tbl_type;

833: )
834:
835: as
836: ddp_price_list_rec ozf_pricelist_pvt.ozf_price_list_rec_type;
837: ddp_price_list_line_tbl ozf_pricelist_pvt.price_list_line_tbl_type;
838: ddp_pricing_attr_tbl ozf_pricelist_pvt.pricing_attr_tbl_type;
839: ddp_qualifiers_tbl ozf_pricelist_pvt.qualifiers_tbl_type;
840: ddindx binary_integer; indx binary_integer;
841: begin

Line 838: ddp_pricing_attr_tbl ozf_pricelist_pvt.pricing_attr_tbl_type;

834:
835: as
836: ddp_price_list_rec ozf_pricelist_pvt.ozf_price_list_rec_type;
837: ddp_price_list_line_tbl ozf_pricelist_pvt.price_list_line_tbl_type;
838: ddp_pricing_attr_tbl ozf_pricelist_pvt.pricing_attr_tbl_type;
839: ddp_qualifiers_tbl ozf_pricelist_pvt.qualifiers_tbl_type;
840: ddindx binary_integer; indx binary_integer;
841: begin
842:

Line 839: ddp_qualifiers_tbl ozf_pricelist_pvt.qualifiers_tbl_type;

835: as
836: ddp_price_list_rec ozf_pricelist_pvt.ozf_price_list_rec_type;
837: ddp_price_list_line_tbl ozf_pricelist_pvt.price_list_line_tbl_type;
838: ddp_pricing_attr_tbl ozf_pricelist_pvt.pricing_attr_tbl_type;
839: ddp_qualifiers_tbl ozf_pricelist_pvt.qualifiers_tbl_type;
840: ddindx binary_integer; indx binary_integer;
841: begin
842:
843: -- copy data to the local IN or IN-OUT args, if any

Line 888: ozf_pricelist_pvt_w.rosetta_table_copy_in_p5(ddp_price_list_line_tbl, p8_a0

884: ddp_price_list_rec.attribute15 := p7_a33;
885: ddp_price_list_rec.global_flag := p7_a34;
886: ddp_price_list_rec.org_id := rosetta_g_miss_num_map(p7_a35);
887:
888: ozf_pricelist_pvt_w.rosetta_table_copy_in_p5(ddp_price_list_line_tbl, p8_a0
889: , p8_a1
890: , p8_a2
891: , p8_a3
892: , p8_a4

Line 921: ozf_pricelist_pvt_w.rosetta_table_copy_in_p7(ddp_pricing_attr_tbl, p9_a0

917: , p8_a29
918: , p8_a30
919: );
920:
921: ozf_pricelist_pvt_w.rosetta_table_copy_in_p7(ddp_pricing_attr_tbl, p9_a0
922: , p9_a1
923: , p9_a2
924: , p9_a3
925: , p9_a4

Line 937: ozf_pricelist_pvt_w.rosetta_table_copy_in_p3(ddp_qualifiers_tbl, p10_a0

933: , p9_a12
934: , p9_a13
935: );
936:
937: ozf_pricelist_pvt_w.rosetta_table_copy_in_p3(ddp_qualifiers_tbl, p10_a0
938: , p10_a1
939: , p10_a2
940: , p10_a3
941: , p10_a4

Line 975: ozf_pricelist_pvt.process_price_list(p_api_version,

971:
972:
973:
974: -- here's the delegated call to the old PL/SQL routine
975: ozf_pricelist_pvt.process_price_list(p_api_version,
976: p_init_msg_list,
977: p_commit,
978: p_validation_level,
979: x_return_status,

Line 1017: ddp_new_inv_item_id ozf_pricelist_pvt.num_tbl_type;

1013: , p_new_inv_item_id JTF_NUMBER_TABLE
1014: )
1015:
1016: as
1017: ddp_new_inv_item_id ozf_pricelist_pvt.num_tbl_type;
1018: ddindx binary_integer; indx binary_integer;
1019: begin
1020:
1021: -- copy data to the local IN or IN-OUT args, if any

Line 1029: ozf_pricelist_pvt_w.rosetta_table_copy_in_p12(ddp_new_inv_item_id, p_new_inv_item_id);

1025:
1026:
1027:
1028:
1029: ozf_pricelist_pvt_w.rosetta_table_copy_in_p12(ddp_new_inv_item_id, p_new_inv_item_id);
1030:
1031: -- here's the delegated call to the old PL/SQL routine
1032: ozf_pricelist_pvt.add_inventory_item(p_api_version,
1033: p_init_msg_list,

Line 1032: ozf_pricelist_pvt.add_inventory_item(p_api_version,

1028:
1029: ozf_pricelist_pvt_w.rosetta_table_copy_in_p12(ddp_new_inv_item_id, p_new_inv_item_id);
1030:
1031: -- here's the delegated call to the old PL/SQL routine
1032: ozf_pricelist_pvt.add_inventory_item(p_api_version,
1033: p_init_msg_list,
1034: p_commit,
1035: x_return_status,
1036: x_msg_count,

Line 1051: end ozf_pricelist_pvt_w;

1047:
1048:
1049: end;
1050:
1051: end ozf_pricelist_pvt_w;