[Home] [Help]
PACKAGE: APPS.OKL_MLA_CREATE_UPDATE_PUB_W
Source
1 package okl_mla_create_update_pub_w AUTHID CURRENT_USER as
2 /* $Header: OKLEMCUS.pls 120.0 2006/11/22 12:14:46 zrehman noship $ */
3 procedure rosetta_table_copy_in_p7(t out nocopy okl_mla_create_update_pub.deal_tab_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_200
5 , a2 JTF_VARCHAR2_TABLE_2000
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_200
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_VARCHAR2_TABLE_100
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_100
18 , a15 JTF_VARCHAR2_TABLE_100
19 , a16 JTF_VARCHAR2_TABLE_100
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_DATE_TABLE
22 , a19 JTF_DATE_TABLE
23 , a20 JTF_DATE_TABLE
24 , a21 JTF_DATE_TABLE
25 , a22 JTF_VARCHAR2_TABLE_100
26 , a23 JTF_VARCHAR2_TABLE_100
27 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_NUMBER_TABLE
31 , a28 JTF_VARCHAR2_TABLE_100
32 , a29 JTF_VARCHAR2_TABLE_200
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_300
35 , a32 JTF_NUMBER_TABLE
36 , a33 JTF_VARCHAR2_TABLE_100
37 , a34 JTF_VARCHAR2_TABLE_200
38 , a35 JTF_VARCHAR2_TABLE_100
39 , a36 JTF_VARCHAR2_TABLE_300
40 , a37 JTF_VARCHAR2_TABLE_100
41 , a38 JTF_VARCHAR2_TABLE_300
42 , a39 JTF_NUMBER_TABLE
43 , a40 JTF_VARCHAR2_TABLE_200
44 , a41 JTF_VARCHAR2_TABLE_2000
45 , a42 JTF_NUMBER_TABLE
46 , a43 JTF_VARCHAR2_TABLE_200
47 , a44 JTF_VARCHAR2_TABLE_200
48 , a45 JTF_NUMBER_TABLE
49 , a46 JTF_NUMBER_TABLE
50 , a47 JTF_NUMBER_TABLE
51 , a48 JTF_NUMBER_TABLE
52 , a49 JTF_VARCHAR2_TABLE_500
53 , a50 JTF_VARCHAR2_TABLE_300
54 , a51 JTF_NUMBER_TABLE
55 , a52 JTF_NUMBER_TABLE
56 , a53 JTF_VARCHAR2_TABLE_500
57 , a54 JTF_VARCHAR2_TABLE_300
58 , a55 JTF_NUMBER_TABLE
59 , a56 JTF_VARCHAR2_TABLE_300
60 , a57 JTF_VARCHAR2_TABLE_300
61 , a58 JTF_NUMBER_TABLE
62 , a59 JTF_VARCHAR2_TABLE_100
63 , a60 JTF_VARCHAR2_TABLE_200
64 , a61 JTF_VARCHAR2_TABLE_100
65 , a62 JTF_VARCHAR2_TABLE_300
66 , a63 JTF_NUMBER_TABLE
67 , a64 JTF_NUMBER_TABLE
68 , a65 JTF_VARCHAR2_TABLE_500
69 , a66 JTF_VARCHAR2_TABLE_300
70 , a67 JTF_NUMBER_TABLE
71 , a68 JTF_NUMBER_TABLE
72 , a69 JTF_VARCHAR2_TABLE_500
73 , a70 JTF_VARCHAR2_TABLE_300
74 , a71 JTF_NUMBER_TABLE
75 , a72 JTF_NUMBER_TABLE
76 , a73 JTF_VARCHAR2_TABLE_500
77 , a74 JTF_VARCHAR2_TABLE_300
78 , a75 JTF_NUMBER_TABLE
79 , a76 JTF_NUMBER_TABLE
80 , a77 JTF_VARCHAR2_TABLE_500
81 , a78 JTF_VARCHAR2_TABLE_300
82 , a79 JTF_VARCHAR2_TABLE_100
83 , a80 JTF_NUMBER_TABLE
84 , a81 JTF_DATE_TABLE
85 , a82 JTF_VARCHAR2_TABLE_100
86 , a83 JTF_NUMBER_TABLE
87 );
88 procedure rosetta_table_copy_out_p7(t okl_mla_create_update_pub.deal_tab_type, a0 out nocopy JTF_NUMBER_TABLE
89 , a1 out nocopy JTF_VARCHAR2_TABLE_200
90 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
91 , a3 out nocopy JTF_VARCHAR2_TABLE_100
92 , a4 out nocopy JTF_VARCHAR2_TABLE_100
93 , a5 out nocopy JTF_DATE_TABLE
94 , a6 out nocopy JTF_DATE_TABLE
95 , a7 out nocopy JTF_NUMBER_TABLE
96 , a8 out nocopy JTF_VARCHAR2_TABLE_200
97 , a9 out nocopy JTF_NUMBER_TABLE
98 , a10 out nocopy JTF_NUMBER_TABLE
99 , a11 out nocopy JTF_VARCHAR2_TABLE_100
100 , a12 out nocopy JTF_VARCHAR2_TABLE_100
101 , a13 out nocopy JTF_VARCHAR2_TABLE_100
102 , a14 out nocopy JTF_VARCHAR2_TABLE_100
103 , a15 out nocopy JTF_VARCHAR2_TABLE_100
104 , a16 out nocopy JTF_VARCHAR2_TABLE_100
105 , a17 out nocopy JTF_VARCHAR2_TABLE_100
106 , a18 out nocopy JTF_DATE_TABLE
107 , a19 out nocopy JTF_DATE_TABLE
108 , a20 out nocopy JTF_DATE_TABLE
109 , a21 out nocopy JTF_DATE_TABLE
110 , a22 out nocopy JTF_VARCHAR2_TABLE_100
111 , a23 out nocopy JTF_VARCHAR2_TABLE_100
112 , a24 out nocopy JTF_VARCHAR2_TABLE_200
113 , a25 out nocopy JTF_NUMBER_TABLE
114 , a26 out nocopy JTF_NUMBER_TABLE
115 , a27 out nocopy JTF_NUMBER_TABLE
116 , a28 out nocopy JTF_VARCHAR2_TABLE_100
117 , a29 out nocopy JTF_VARCHAR2_TABLE_200
118 , a30 out nocopy JTF_VARCHAR2_TABLE_100
119 , a31 out nocopy JTF_VARCHAR2_TABLE_300
120 , a32 out nocopy JTF_NUMBER_TABLE
121 , a33 out nocopy JTF_VARCHAR2_TABLE_100
122 , a34 out nocopy JTF_VARCHAR2_TABLE_200
123 , a35 out nocopy JTF_VARCHAR2_TABLE_100
124 , a36 out nocopy JTF_VARCHAR2_TABLE_300
125 , a37 out nocopy JTF_VARCHAR2_TABLE_100
126 , a38 out nocopy JTF_VARCHAR2_TABLE_300
127 , a39 out nocopy JTF_NUMBER_TABLE
128 , a40 out nocopy JTF_VARCHAR2_TABLE_200
129 , a41 out nocopy JTF_VARCHAR2_TABLE_2000
130 , a42 out nocopy JTF_NUMBER_TABLE
131 , a43 out nocopy JTF_VARCHAR2_TABLE_200
132 , a44 out nocopy JTF_VARCHAR2_TABLE_200
133 , a45 out nocopy JTF_NUMBER_TABLE
134 , a46 out nocopy JTF_NUMBER_TABLE
135 , a47 out nocopy JTF_NUMBER_TABLE
136 , a48 out nocopy JTF_NUMBER_TABLE
137 , a49 out nocopy JTF_VARCHAR2_TABLE_500
138 , a50 out nocopy JTF_VARCHAR2_TABLE_300
139 , a51 out nocopy JTF_NUMBER_TABLE
140 , a52 out nocopy JTF_NUMBER_TABLE
141 , a53 out nocopy JTF_VARCHAR2_TABLE_500
142 , a54 out nocopy JTF_VARCHAR2_TABLE_300
143 , a55 out nocopy JTF_NUMBER_TABLE
144 , a56 out nocopy JTF_VARCHAR2_TABLE_300
145 , a57 out nocopy JTF_VARCHAR2_TABLE_300
146 , a58 out nocopy JTF_NUMBER_TABLE
147 , a59 out nocopy JTF_VARCHAR2_TABLE_100
148 , a60 out nocopy JTF_VARCHAR2_TABLE_200
149 , a61 out nocopy JTF_VARCHAR2_TABLE_100
150 , a62 out nocopy JTF_VARCHAR2_TABLE_300
151 , a63 out nocopy JTF_NUMBER_TABLE
152 , a64 out nocopy JTF_NUMBER_TABLE
153 , a65 out nocopy JTF_VARCHAR2_TABLE_500
154 , a66 out nocopy JTF_VARCHAR2_TABLE_300
155 , a67 out nocopy JTF_NUMBER_TABLE
156 , a68 out nocopy JTF_NUMBER_TABLE
157 , a69 out nocopy JTF_VARCHAR2_TABLE_500
158 , a70 out nocopy JTF_VARCHAR2_TABLE_300
159 , a71 out nocopy JTF_NUMBER_TABLE
160 , a72 out nocopy JTF_NUMBER_TABLE
161 , a73 out nocopy JTF_VARCHAR2_TABLE_500
162 , a74 out nocopy JTF_VARCHAR2_TABLE_300
163 , a75 out nocopy JTF_NUMBER_TABLE
164 , a76 out nocopy JTF_NUMBER_TABLE
165 , a77 out nocopy JTF_VARCHAR2_TABLE_500
166 , a78 out nocopy JTF_VARCHAR2_TABLE_300
167 , a79 out nocopy JTF_VARCHAR2_TABLE_100
168 , a80 out nocopy JTF_NUMBER_TABLE
169 , a81 out nocopy JTF_DATE_TABLE
170 , a82 out nocopy JTF_VARCHAR2_TABLE_100
171 , a83 out nocopy JTF_NUMBER_TABLE
172 );
173
174 procedure rosetta_table_copy_in_p9(t out nocopy okl_mla_create_update_pub.party_tab_type, a0 JTF_NUMBER_TABLE
175 , a1 JTF_VARCHAR2_TABLE_100
176 , a2 JTF_VARCHAR2_TABLE_500
177 , a3 JTF_VARCHAR2_TABLE_500
178 , a4 JTF_VARCHAR2_TABLE_500
179 , a5 JTF_VARCHAR2_TABLE_500
180 , a6 JTF_VARCHAR2_TABLE_500
181 , a7 JTF_VARCHAR2_TABLE_500
182 , a8 JTF_VARCHAR2_TABLE_500
183 , a9 JTF_VARCHAR2_TABLE_500
184 , a10 JTF_VARCHAR2_TABLE_500
185 , a11 JTF_VARCHAR2_TABLE_500
186 , a12 JTF_VARCHAR2_TABLE_500
187 , a13 JTF_VARCHAR2_TABLE_500
188 , a14 JTF_VARCHAR2_TABLE_500
189 , a15 JTF_VARCHAR2_TABLE_500
190 , a16 JTF_VARCHAR2_TABLE_500
191 , a17 JTF_VARCHAR2_TABLE_100
192 , a18 JTF_VARCHAR2_TABLE_200
193 , a19 JTF_VARCHAR2_TABLE_100
194 , a20 JTF_VARCHAR2_TABLE_100
195 , a21 JTF_NUMBER_TABLE
196 , a22 JTF_NUMBER_TABLE
197 , a23 JTF_NUMBER_TABLE
198 );
199 procedure rosetta_table_copy_out_p9(t okl_mla_create_update_pub.party_tab_type, a0 out nocopy JTF_NUMBER_TABLE
200 , a1 out nocopy JTF_VARCHAR2_TABLE_100
201 , a2 out nocopy JTF_VARCHAR2_TABLE_500
202 , a3 out nocopy JTF_VARCHAR2_TABLE_500
203 , a4 out nocopy JTF_VARCHAR2_TABLE_500
204 , a5 out nocopy JTF_VARCHAR2_TABLE_500
205 , a6 out nocopy JTF_VARCHAR2_TABLE_500
206 , a7 out nocopy JTF_VARCHAR2_TABLE_500
207 , a8 out nocopy JTF_VARCHAR2_TABLE_500
208 , a9 out nocopy JTF_VARCHAR2_TABLE_500
209 , a10 out nocopy JTF_VARCHAR2_TABLE_500
210 , a11 out nocopy JTF_VARCHAR2_TABLE_500
211 , a12 out nocopy JTF_VARCHAR2_TABLE_500
212 , a13 out nocopy JTF_VARCHAR2_TABLE_500
213 , a14 out nocopy JTF_VARCHAR2_TABLE_500
214 , a15 out nocopy JTF_VARCHAR2_TABLE_500
215 , a16 out nocopy JTF_VARCHAR2_TABLE_500
216 , a17 out nocopy JTF_VARCHAR2_TABLE_100
217 , a18 out nocopy JTF_VARCHAR2_TABLE_200
218 , a19 out nocopy JTF_VARCHAR2_TABLE_100
219 , a20 out nocopy JTF_VARCHAR2_TABLE_100
220 , a21 out nocopy JTF_NUMBER_TABLE
221 , a22 out nocopy JTF_NUMBER_TABLE
222 , a23 out nocopy JTF_NUMBER_TABLE
223 );
224
225 procedure rosetta_table_copy_in_p11(t out nocopy okl_mla_create_update_pub.upd_deal_tab_type, a0 JTF_NUMBER_TABLE
226 , a1 JTF_VARCHAR2_TABLE_200
227 , a2 JTF_VARCHAR2_TABLE_2000
228 , a3 JTF_DATE_TABLE
229 , a4 JTF_DATE_TABLE
230 , a5 JTF_VARCHAR2_TABLE_100
231 , a6 JTF_VARCHAR2_TABLE_100
232 , a7 JTF_DATE_TABLE
233 , a8 JTF_VARCHAR2_TABLE_100
234 , a9 JTF_NUMBER_TABLE
235 );
236 procedure rosetta_table_copy_out_p11(t okl_mla_create_update_pub.upd_deal_tab_type, a0 out nocopy JTF_NUMBER_TABLE
237 , a1 out nocopy JTF_VARCHAR2_TABLE_200
238 , a2 out nocopy JTF_VARCHAR2_TABLE_2000
239 , a3 out nocopy JTF_DATE_TABLE
240 , a4 out nocopy JTF_DATE_TABLE
241 , a5 out nocopy JTF_VARCHAR2_TABLE_100
242 , a6 out nocopy JTF_VARCHAR2_TABLE_100
243 , a7 out nocopy JTF_DATE_TABLE
244 , a8 out nocopy JTF_VARCHAR2_TABLE_100
245 , a9 out nocopy JTF_NUMBER_TABLE
246 );
247
248 procedure update_deal(p_api_version NUMBER
249 , p_init_msg_list VARCHAR2
250 , x_return_status out nocopy VARCHAR2
251 , x_msg_count out nocopy NUMBER
252 , x_msg_data out nocopy VARCHAR2
253 , p6_a0 out nocopy NUMBER
254 , p6_a1 out nocopy VARCHAR2
255 , p6_a2 out nocopy VARCHAR2
256 , p6_a3 out nocopy DATE
257 , p6_a4 out nocopy DATE
258 , p6_a5 out nocopy VARCHAR2
259 , p6_a6 out nocopy VARCHAR2
260 , p6_a7 out nocopy DATE
261 , p6_a8 out nocopy VARCHAR2
262 , p6_a9 out nocopy NUMBER
263 , p5_a0 NUMBER := 0-1962.0724
264 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
265 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
266 , p5_a3 DATE := fnd_api.g_miss_date
267 , p5_a4 DATE := fnd_api.g_miss_date
268 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
269 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
270 , p5_a7 DATE := fnd_api.g_miss_date
271 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
272 , p5_a9 NUMBER := 0-1962.0724
273 );
274 procedure create_deal(p_api_version NUMBER
275 , p_init_msg_list VARCHAR2
276 , x_return_status out nocopy VARCHAR2
277 , x_msg_count out nocopy NUMBER
278 , x_msg_data out nocopy VARCHAR2
279 , p_source_code VARCHAR2
280 , p_template_type VARCHAR2
281 , p_contract_number VARCHAR2
282 , p_scs_code VARCHAR2
283 , p_customer_id1 in out nocopy VARCHAR2
284 , p_customer_id2 in out nocopy VARCHAR2
285 , p_customer_code VARCHAR2
286 , p_customer_name VARCHAR2
287 , p_effective_from date
288 , p_program_name VARCHAR2
289 , p_program_id NUMBER
290 , p_org_id NUMBER
291 , p_organization_id NUMBER
292 , p_source_chr_id in out nocopy NUMBER
293 , p_source_contract_number VARCHAR2
294 , x_chr_id out nocopy NUMBER
295 , p_legal_entity_id NUMBER
296 );
297 procedure create_party(p_api_version NUMBER
298 , p_init_msg_list VARCHAR2
299 , x_return_status out nocopy VARCHAR2
300 , x_msg_count out nocopy NUMBER
301 , x_msg_data out nocopy VARCHAR2
302 , p6_a0 out nocopy NUMBER
303 , p6_a1 out nocopy VARCHAR2
304 , p6_a2 out nocopy VARCHAR2
305 , p6_a3 out nocopy VARCHAR2
306 , p6_a4 out nocopy VARCHAR2
307 , p6_a5 out nocopy VARCHAR2
308 , p6_a6 out nocopy VARCHAR2
309 , p6_a7 out nocopy VARCHAR2
310 , p6_a8 out nocopy VARCHAR2
311 , p6_a9 out nocopy VARCHAR2
312 , p6_a10 out nocopy VARCHAR2
313 , p6_a11 out nocopy VARCHAR2
314 , p6_a12 out nocopy VARCHAR2
315 , p6_a13 out nocopy VARCHAR2
316 , p6_a14 out nocopy VARCHAR2
317 , p6_a15 out nocopy VARCHAR2
318 , p6_a16 out nocopy VARCHAR2
319 , p6_a17 out nocopy VARCHAR2
320 , p6_a18 out nocopy VARCHAR2
321 , p6_a19 out nocopy VARCHAR2
322 , p6_a20 out nocopy VARCHAR2
323 , p6_a21 out nocopy NUMBER
324 , p6_a22 out nocopy NUMBER
325 , p6_a23 out nocopy NUMBER
326 , p5_a0 NUMBER := 0-1962.0724
327 , p5_a1 VARCHAR2 := fnd_api.g_miss_char
328 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
329 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
330 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
331 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
332 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
333 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
334 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
335 , p5_a9 VARCHAR2 := fnd_api.g_miss_char
336 , p5_a10 VARCHAR2 := fnd_api.g_miss_char
337 , p5_a11 VARCHAR2 := fnd_api.g_miss_char
338 , p5_a12 VARCHAR2 := fnd_api.g_miss_char
339 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
340 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
341 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
342 , p5_a16 VARCHAR2 := fnd_api.g_miss_char
343 , p5_a17 VARCHAR2 := fnd_api.g_miss_char
344 , p5_a18 VARCHAR2 := fnd_api.g_miss_char
345 , p5_a19 VARCHAR2 := fnd_api.g_miss_char
346 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
347 , p5_a21 NUMBER := 0-1962.0724
348 , p5_a22 NUMBER := 0-1962.0724
349 , p5_a23 NUMBER := 0-1962.0724
350 );
351 end okl_mla_create_update_pub_w;