[Home] [Help]
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;