1: package pv_terr_assign_pub_w AUTHID CURRENT_USER 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
8: , a5 JTF_VARCHAR2_TABLE_100
1: package pv_terr_assign_pub_w AUTHID CURRENT_USER 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
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_100
18: );
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
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
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
24: , a5 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
25: , a6 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
26: , a7 out nocopy JTF_VARCHAR2_TABLE_100
27: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_VARCHAR2_TABLE_100
32: , a13 out nocopy JTF_VARCHAR2_TABLE_500
33: , a14 out nocopy JTF_VARCHAR2_TABLE_100
34: );
63: , a12 out nocopy JTF_VARCHAR2_TABLE_100
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
64: , a13 out nocopy JTF_VARCHAR2_TABLE_100
65: );
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
66:
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
67: procedure rosetta_table_copy_in_p22(t out nocopy pv_terr_assign_pub.resourcelist, a0 JTF_NUMBER_TABLE);
68: procedure rosetta_table_copy_out_p22(t pv_terr_assign_pub.resourcelist, a0 out nocopy JTF_NUMBER_TABLE);
69:
70: procedure rosetta_table_copy_in_p23(t out nocopy pv_terr_assign_pub.personlist, a0 JTF_NUMBER_TABLE);
71: procedure rosetta_table_copy_out_p23(t pv_terr_assign_pub.personlist, a0 out nocopy JTF_NUMBER_TABLE);
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
72:
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
73: procedure rosetta_table_copy_in_p24(t out nocopy pv_terr_assign_pub.resourcecategorylist, a0 JTF_VARCHAR2_TABLE_100);
74: procedure rosetta_table_copy_out_p24(t pv_terr_assign_pub.resourcecategorylist, a0 out nocopy JTF_VARCHAR2_TABLE_100);
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75:
76: procedure rosetta_table_copy_in_p25(t out nocopy pv_terr_assign_pub.grouplist, a0 JTF_NUMBER_TABLE);
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: );
83:
77: procedure rosetta_table_copy_out_p25(t pv_terr_assign_pub.grouplist, a0 out nocopy JTF_NUMBER_TABLE);
78:
79: procedure rosetta_table_copy_in_p30(t out nocopy pv_terr_assign_pub.prtnr_aces_tbl_type, a0 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p30(t pv_terr_assign_pub.prtnr_aces_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: );
83:
84: procedure get_res_from_team_group(p_resource_id NUMBER
85: , p_resource_type VARCHAR2
82: );
83:
84: procedure get_res_from_team_group(p_resource_id NUMBER
85: , p_resource_type VARCHAR2
86: , p2_a0 out nocopy JTF_NUMBER_TABLE
87: , p2_a1 out nocopy JTF_NUMBER_TABLE
88: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , p2_a3 out nocopy JTF_NUMBER_TABLE
90: );
83:
84: procedure get_res_from_team_group(p_resource_id NUMBER
85: , p_resource_type VARCHAR2
86: , p2_a0 out nocopy JTF_NUMBER_TABLE
87: , p2_a1 out nocopy JTF_NUMBER_TABLE
88: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , p2_a3 out nocopy JTF_NUMBER_TABLE
90: );
91: procedure get_partner_details(p_party_id NUMBER
85: , p_resource_type VARCHAR2
86: , p2_a0 out nocopy JTF_NUMBER_TABLE
87: , p2_a1 out nocopy JTF_NUMBER_TABLE
88: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
89: , p2_a3 out nocopy JTF_NUMBER_TABLE
90: );
91: procedure get_partner_details(p_party_id NUMBER
92: , x_return_status out nocopy VARCHAR2
93: , x_msg_count out nocopy 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
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
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
100: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
101: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
108: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
109: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
102: , p4_a7 out nocopy JTF_VARCHAR2_TABLE_100
103: , p4_a8 out nocopy JTF_VARCHAR2_TABLE_100
104: , p4_a9 out nocopy JTF_VARCHAR2_TABLE_100
105: , p4_a10 out nocopy JTF_NUMBER_TABLE
106: , p4_a11 out nocopy JTF_NUMBER_TABLE
107: , p4_a12 out nocopy JTF_VARCHAR2_TABLE_100
108: , p4_a13 out nocopy JTF_VARCHAR2_TABLE_500
109: , p4_a14 out nocopy JTF_VARCHAR2_TABLE_100
110: );
118: , p_login_user NUMBER
119: , x_return_status out nocopy VARCHAR2
120: , x_msg_count out nocopy NUMBER
121: , x_msg_data out nocopy VARCHAR2
122: , p11_a0 out nocopy JTF_NUMBER_TABLE
123: );
124: procedure do_create_channel_team(p_api_version_number NUMBER
125: , p_init_msg_list VARCHAR2
126: , p_commit VARCHAR2
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
137: , p8_a5 JTF_VARCHAR2_TABLE_100
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
137: , p8_a5 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
138: , p8_a6 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
145: , p8_a13 JTF_VARCHAR2_TABLE_500
146: , p8_a14 JTF_VARCHAR2_TABLE_100
139: , p8_a7 JTF_VARCHAR2_TABLE_100
140: , p8_a8 JTF_VARCHAR2_TABLE_100
141: , p8_a9 JTF_VARCHAR2_TABLE_100
142: , p8_a10 JTF_NUMBER_TABLE
143: , p8_a11 JTF_NUMBER_TABLE
144: , p8_a12 JTF_VARCHAR2_TABLE_100
145: , p8_a13 JTF_VARCHAR2_TABLE_500
146: , p8_a14 JTF_VARCHAR2_TABLE_100
147: , x_return_status out nocopy VARCHAR2
146: , p8_a14 JTF_VARCHAR2_TABLE_100
147: , x_return_status out nocopy VARCHAR2
148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p12_a0 out nocopy JTF_NUMBER_TABLE
151: );
152: procedure create_online_channel_team(p_api_version_number NUMBER
153: , p_init_msg_list VARCHAR2
154: , p_commit VARCHAR2
159: , p_partner_id NUMBER
160: , p_vad_partner_id NUMBER
161: , p_mode VARCHAR2
162: , p_login_user NUMBER
163: , p11_a0 out nocopy JTF_NUMBER_TABLE
164: );
165: procedure do_cr_online_chnl_team(p_api_version_number NUMBER
166: , p_init_msg_list VARCHAR2
167: , p_commit VARCHAR2
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
181: , p11_a5 JTF_VARCHAR2_TABLE_100
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
181: , p11_a5 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
182: , p11_a6 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
190: , p11_a14 JTF_VARCHAR2_TABLE_100
183: , p11_a7 JTF_VARCHAR2_TABLE_100
184: , p11_a8 JTF_VARCHAR2_TABLE_100
185: , p11_a9 JTF_VARCHAR2_TABLE_100
186: , p11_a10 JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
190: , p11_a14 JTF_VARCHAR2_TABLE_100
191: , p12_a0 out nocopy JTF_NUMBER_TABLE
187: , p11_a11 JTF_NUMBER_TABLE
188: , p11_a12 JTF_VARCHAR2_TABLE_100
189: , p11_a13 JTF_VARCHAR2_TABLE_500
190: , p11_a14 JTF_VARCHAR2_TABLE_100
191: , p12_a0 out nocopy JTF_NUMBER_TABLE
192: );
193: procedure create_vad_channel_team(p_api_version_number NUMBER
194: , p_init_msg_list VARCHAR2
195: , p_commit VARCHAR2
198: , x_msg_count out nocopy NUMBER
199: , x_msg_data out nocopy VARCHAR2
200: , p_partner_id NUMBER
201: , p_vad_partner_id NUMBER
202: , p9_a0 out nocopy JTF_NUMBER_TABLE
203: );
204: procedure update_channel_team(p_api_version_number NUMBER
205: , p_init_msg_list VARCHAR2
206: , p_commit VARCHAR2
225: , p8_a13 VARCHAR2
226: , x_return_status out nocopy VARCHAR2
227: , x_msg_count out nocopy NUMBER
228: , x_msg_data out nocopy VARCHAR2
229: , p12_a0 out nocopy JTF_NUMBER_TABLE
230: );
231: end pv_terr_assign_pub_w;