eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.PV_TERR_ASSIGN_PUB_W

Source


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
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     );
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
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     );
35 
36   procedure rosetta_table_copy_in_p19(t out nocopy pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 JTF_VARCHAR2_TABLE_100
37     , a1 JTF_VARCHAR2_TABLE_100
38     , a2 JTF_VARCHAR2_TABLE_100
39     , a3 JTF_VARCHAR2_TABLE_100
40     , a4 JTF_VARCHAR2_TABLE_100
41     , a5 JTF_VARCHAR2_TABLE_100
42     , a6 JTF_VARCHAR2_TABLE_100
43     , a7 JTF_VARCHAR2_TABLE_100
44     , a8 JTF_VARCHAR2_TABLE_100
45     , a9 JTF_VARCHAR2_TABLE_100
46     , a10 JTF_VARCHAR2_TABLE_100
47     , a11 JTF_VARCHAR2_TABLE_100
48     , a12 JTF_VARCHAR2_TABLE_100
49     , a13 JTF_VARCHAR2_TABLE_100
50     );
51   procedure rosetta_table_copy_out_p19(t pv_terr_assign_pub.prtnr_qflr_flg_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52     , a1 out nocopy JTF_VARCHAR2_TABLE_100
53     , a2 out nocopy JTF_VARCHAR2_TABLE_100
54     , a3 out nocopy JTF_VARCHAR2_TABLE_100
55     , a4 out nocopy JTF_VARCHAR2_TABLE_100
56     , a5 out nocopy JTF_VARCHAR2_TABLE_100
57     , a6 out nocopy JTF_VARCHAR2_TABLE_100
58     , a7 out nocopy JTF_VARCHAR2_TABLE_100
59     , a8 out nocopy JTF_VARCHAR2_TABLE_100
60     , a9 out nocopy JTF_VARCHAR2_TABLE_100
61     , a10 out nocopy JTF_VARCHAR2_TABLE_100
62     , a11 out nocopy JTF_VARCHAR2_TABLE_100
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);
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     );
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
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
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
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   );
111   procedure create_channel_team(p_api_version_number  NUMBER
112     , p_init_msg_list  VARCHAR2
113     , p_commit  VARCHAR2
114     , p_validation_level  NUMBER
115     , p_partner_id  NUMBER
116     , p_vad_partner_id  NUMBER
117     , p_mode  VARCHAR2
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
127     , p_validation_level  NUMBER
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
137     , p8_a5 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
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
155     , p_validation_level  NUMBER
156     , x_return_status out nocopy  VARCHAR2
157     , x_msg_count out nocopy  NUMBER
158     , x_msg_data out nocopy  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
168     , p_validation_level  NUMBER
169     , x_return_status out nocopy  VARCHAR2
170     , x_msg_count out nocopy  NUMBER
171     , x_msg_data out nocopy  VARCHAR2
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
181     , p11_a5 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
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
196     , p_validation_level  NUMBER
197     , x_return_status out nocopy  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
207     , p_validation_level  NUMBER
208     , p_partner_id  NUMBER
209     , p_vad_partner_id  NUMBER
210     , p_mode  VARCHAR2
211     , p_login_user  NUMBER
212     , p8_a0  VARCHAR2
213     , p8_a1  VARCHAR2
214     , p8_a2  VARCHAR2
215     , p8_a3  VARCHAR2
216     , p8_a4  VARCHAR2
217     , p8_a5  VARCHAR2
218     , p8_a6  VARCHAR2
219     , p8_a7  VARCHAR2
220     , p8_a8  VARCHAR2
221     , p8_a9  VARCHAR2
222     , p8_a10  VARCHAR2
223     , p8_a11  VARCHAR2
224     , p8_a12  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;