[Home] [Help]
1: package pv_terr_assign_pub_w as
2: /* $Header: pvxwptas.pls 120.1 2005/08/10 01:45 appldev ship $ */
3: procedure rosetta_table_copy_in_p15(t out nocopy pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 JTF_VARCHAR2_TABLE_400
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
18: );
19: procedure rosetta_table_copy_out_p15(t pv_terr_assign_pub.partner_qualifiers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_VARCHAR2_TABLE_100
23: , a4 out nocopy JTF_VARCHAR2_TABLE_100
91: procedure get_partner_details(p_party_id NUMBER
92: , x_return_status out nocopy VARCHAR2
93: , x_msg_count out nocopy NUMBER
94: , x_msg_data out nocopy VARCHAR2
95: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_400
96: , p4_a1 out nocopy JTF_NUMBER_TABLE
97: , p4_a2 out nocopy JTF_NUMBER_TABLE
98: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , p_partner_id NUMBER
129: , p_vad_partner_id NUMBER
130: , p_mode VARCHAR2
131: , p_login_user NUMBER
132: , p8_a0 JTF_VARCHAR2_TABLE_400
133: , p8_a1 JTF_NUMBER_TABLE
134: , p8_a2 JTF_NUMBER_TABLE
135: , p8_a3 JTF_VARCHAR2_TABLE_100
136: , p8_a4 JTF_VARCHAR2_TABLE_100
172: , p_partner_id NUMBER
173: , p_vad_partner_id NUMBER
174: , p_mode VARCHAR2
175: , p_login_user NUMBER
176: , p11_a0 JTF_VARCHAR2_TABLE_400
177: , p11_a1 JTF_NUMBER_TABLE
178: , p11_a2 JTF_NUMBER_TABLE
179: , p11_a3 JTF_VARCHAR2_TABLE_100
180: , p11_a4 JTF_VARCHAR2_TABLE_100