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
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
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
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:
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
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
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
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
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