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_TP_UTIL_QUERIES_OA dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_tp_util_queries.qualifier_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ozf_tp_util_queries_oa as
2: /* $Header: ozfatpqb.pls 115.0 2003/11/07 18:45:31 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_tp_util_queries.qualifier_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: ) as
7: ddindx binary_integer; indx binary_integer;

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body ozf_tp_util_queries_oa as
2: /* $Header: ozfatpqb.pls 115.0 2003/11/07 18:45:31 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_tp_util_queries.qualifier_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: ) as
7: ddindx binary_integer; indx binary_integer;
8: begin

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body ozf_tp_util_queries_oa as
2: /* $Header: ozfatpqb.pls 115.0 2003/11/07 18:45:31 gramanat noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_tp_util_queries.qualifier_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: ) as
7: ddindx binary_integer; indx binary_integer;
8: begin
9: if a0 is not null and a0.count > 0 then

Line 26: procedure rosetta_table_copy_out_p1(t ozf_tp_util_queries.qualifier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

22: end loop;
23: end if;
24: end if;
25: end rosetta_table_copy_in_p1;
26: procedure rosetta_table_copy_out_p1(t ozf_tp_util_queries.qualifier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;

Line 27: , a1 out nocopy JTF_VARCHAR2_TABLE_100

23: end if;
24: end if;
25: end rosetta_table_copy_in_p1;
26: procedure rosetta_table_copy_out_p1(t ozf_tp_util_queries.qualifier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin

Line 28: , a2 out nocopy JTF_VARCHAR2_TABLE_100

24: end if;
25: end rosetta_table_copy_in_p1;
26: procedure rosetta_table_copy_out_p1(t ozf_tp_util_queries.qualifier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
27: , a1 out nocopy JTF_VARCHAR2_TABLE_100
28: , a2 out nocopy JTF_VARCHAR2_TABLE_100
29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then

Line 33: a0 := JTF_VARCHAR2_TABLE_100();

29: ) as
30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();

Line 34: a1 := JTF_VARCHAR2_TABLE_100();

30: ddindx binary_integer; indx binary_integer;
31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();
38: a1 := JTF_VARCHAR2_TABLE_100();

Line 35: a2 := JTF_VARCHAR2_TABLE_100();

31: begin
32: if t is null or t.count = 0 then
33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();

Line 37: a0 := JTF_VARCHAR2_TABLE_100();

33: a0 := JTF_VARCHAR2_TABLE_100();
34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();
40: if t.count > 0 then
41: a0.extend(t.count);

Line 38: a1 := JTF_VARCHAR2_TABLE_100();

34: a1 := JTF_VARCHAR2_TABLE_100();
35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();
40: if t.count > 0 then
41: a0.extend(t.count);
42: a1.extend(t.count);

Line 39: a2 := JTF_VARCHAR2_TABLE_100();

35: a2 := JTF_VARCHAR2_TABLE_100();
36: else
37: a0 := JTF_VARCHAR2_TABLE_100();
38: a1 := JTF_VARCHAR2_TABLE_100();
39: a2 := JTF_VARCHAR2_TABLE_100();
40: if t.count > 0 then
41: a0.extend(t.count);
42: a1.extend(t.count);
43: a2.extend(t.count);

Line 70: , p10_a0 JTF_VARCHAR2_TABLE_100

66: , p_product_attr_value VARCHAR2
67: , p_fcst_uom VARCHAR2
68: , p_currency_code VARCHAR2
69: , p_price_list_id NUMBER
70: , p10_a0 JTF_VARCHAR2_TABLE_100
71: , p10_a1 JTF_VARCHAR2_TABLE_100
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , x_list_price out nocopy NUMBER
74: , x_return_status out nocopy VARCHAR2

Line 71: , p10_a1 JTF_VARCHAR2_TABLE_100

67: , p_fcst_uom VARCHAR2
68: , p_currency_code VARCHAR2
69: , p_price_list_id NUMBER
70: , p10_a0 JTF_VARCHAR2_TABLE_100
71: , p10_a1 JTF_VARCHAR2_TABLE_100
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , x_list_price out nocopy NUMBER
74: , x_return_status out nocopy VARCHAR2
75: , x_msg_count out nocopy NUMBER

Line 72: , p10_a2 JTF_VARCHAR2_TABLE_100

68: , p_currency_code VARCHAR2
69: , p_price_list_id NUMBER
70: , p10_a0 JTF_VARCHAR2_TABLE_100
71: , p10_a1 JTF_VARCHAR2_TABLE_100
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , x_list_price out nocopy NUMBER
74: , x_return_status out nocopy VARCHAR2
75: , x_msg_count out nocopy NUMBER
76: , x_msg_data out nocopy VARCHAR2