PACKAGE: APPS.OZF_TP_UTIL_QUERIES_OA

Source

1 package ozf_tp_util_queries_oa AUTHID CURRENT_USER as
2   /* $Header: ozfatpqs.pls 115.0 2003/11/07 18:45:30 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     );
7   procedure rosetta_table_copy_out_p1(t ozf_tp_util_queries.qualifier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
8     , a1 out nocopy JTF_VARCHAR2_TABLE_100
9     , a2 out nocopy JTF_VARCHAR2_TABLE_100
10     );
11 
12   procedure get_list_price(p_api_version  NUMBER
13     , p_init_msg_list  VARCHAR2
14     , p_commit  VARCHAR2
15     , p_obj_id  NUMBER
16     , p_obj_type  VARCHAR2
17     , p_product_attribute  VARCHAR2
18     , p_product_attr_value  VARCHAR2
19     , p_fcst_uom  VARCHAR2
20     , p_currency_code  VARCHAR2
21     , p_price_list_id  NUMBER
22     , p10_a0 JTF_VARCHAR2_TABLE_100
23     , p10_a1 JTF_VARCHAR2_TABLE_100
24     , p10_a2 JTF_VARCHAR2_TABLE_100
25     , x_list_price out nocopy  NUMBER
26     , x_return_status out nocopy  VARCHAR2
27     , x_msg_count out nocopy  NUMBER
28     , x_msg_data out nocopy  VARCHAR2
29   );
30 end ozf_tp_util_queries_oa;