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.OKL_TRANSACTION_PVT_W

Source


1 package okl_transaction_pvt_w as
2   /* $Header: OKLETXNS.pls 120.1 2005/07/12 09:12:02 dkagrawa noship $ */
3   procedure rosetta_table_copy_in_p11(t out nocopy okl_transaction_pvt.rev_tbl_type, a0 JTF_NUMBER_TABLE
4     );
5   procedure rosetta_table_copy_out_p11(t okl_transaction_pvt.rev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
6     );
7 
8   procedure create_transaction(p_api_version  NUMBER
9     , p_init_msg_list  VARCHAR2
10     , x_return_status out nocopy  VARCHAR2
11     , x_msg_count out nocopy  NUMBER
12     , x_msg_data out nocopy  VARCHAR2
13     , p_chr_id  NUMBER
14     , p_new_chr_id  NUMBER
15     , p_reason_code  VARCHAR2
16     , p_description  VARCHAR2
17     , p_trx_date  date
18     , p_trx_type  VARCHAR2
19     , p11_a0 out nocopy  NUMBER
20     , p11_a1 out nocopy  NUMBER
21     , p11_a2 out nocopy  VARCHAR2
22     , p11_a3 out nocopy  VARCHAR2
23     , p11_a4 out nocopy  VARCHAR2
24     , p11_a5 out nocopy  VARCHAR2
25     , p11_a6 out nocopy  NUMBER
26     , p11_a7 out nocopy  NUMBER
27     , p11_a8 out nocopy  NUMBER
28     , p11_a9 out nocopy  NUMBER
29     , p11_a10 out nocopy  NUMBER
30     , p11_a11 out nocopy  NUMBER
31     , p11_a12 out nocopy  VARCHAR2
32     , p11_a13 out nocopy  VARCHAR2
33     , p11_a14 out nocopy  DATE
34     , p11_a15 out nocopy  VARCHAR2
35     , p11_a16 out nocopy  VARCHAR2
36     , p11_a17 out nocopy  NUMBER
37     , p11_a18 out nocopy  VARCHAR2
38     , p11_a19 out nocopy  VARCHAR2
39     , p11_a20 out nocopy  VARCHAR2
40     , p11_a21 out nocopy  VARCHAR2
41     , p11_a22 out nocopy  VARCHAR2
42     , p11_a23 out nocopy  VARCHAR2
43     , p11_a24 out nocopy  VARCHAR2
44     , p11_a25 out nocopy  VARCHAR2
45     , p11_a26 out nocopy  VARCHAR2
46     , p11_a27 out nocopy  VARCHAR2
47     , p11_a28 out nocopy  VARCHAR2
48     , p11_a29 out nocopy  VARCHAR2
49     , p11_a30 out nocopy  VARCHAR2
50     , p11_a31 out nocopy  VARCHAR2
51     , p11_a32 out nocopy  VARCHAR2
52     , p11_a33 out nocopy  VARCHAR2
53     , p11_a34 out nocopy  VARCHAR2
54     , p11_a35 out nocopy  VARCHAR2
55     , p11_a36 out nocopy  VARCHAR2
56     , p11_a37 out nocopy  NUMBER
57     , p11_a38 out nocopy  VARCHAR2
58     , p11_a39 out nocopy  NUMBER
59     , p11_a40 out nocopy  VARCHAR2
60     , p11_a41 out nocopy  VARCHAR2
61     , p11_a42 out nocopy  NUMBER
62     , p11_a43 out nocopy  NUMBER
63     , p11_a44 out nocopy  NUMBER
64     , p11_a45 out nocopy  NUMBER
65     , p11_a46 out nocopy  NUMBER
66     , p11_a47 out nocopy  NUMBER
67     , p11_a48 out nocopy  DATE
68     , p11_a49 out nocopy  NUMBER
69     , p11_a50 out nocopy  DATE
70     , p11_a51 out nocopy  NUMBER
71     , p11_a52 out nocopy  DATE
72     , p11_a53 out nocopy  NUMBER
73     , p11_a54 out nocopy  NUMBER
74     , p11_a55 out nocopy  VARCHAR2
75     , p11_a56 out nocopy  NUMBER
76     , p11_a57 out nocopy  VARCHAR2
77     , p11_a58 out nocopy  DATE
78     , p11_a59 out nocopy  VARCHAR2
79     , p11_a60 out nocopy  VARCHAR2
80     , p11_a61 out nocopy  VARCHAR2
81     , p11_a62 out nocopy  VARCHAR2
82     , p11_a63 out nocopy  VARCHAR2
83     , p11_a64 out nocopy  VARCHAR2
84     , p11_a65 out nocopy  VARCHAR2
85     , p11_a66 out nocopy  VARCHAR2
86     , p11_a67 out nocopy  VARCHAR2
87     , p11_a68 out nocopy  VARCHAR2
88     , p11_a69 out nocopy  VARCHAR2
89     , p11_a70 out nocopy  VARCHAR2
90     , p11_a71 out nocopy  VARCHAR2
91     , p11_a72 out nocopy  VARCHAR2
92     , p11_a73 out nocopy  VARCHAR2
93     , p11_a74 out nocopy  VARCHAR2
94     , p11_a75 out nocopy  VARCHAR2
95     , p11_a76 out nocopy  VARCHAR2
96     , p11_a77 out nocopy  NUMBER
97     , p11_a78 out nocopy  DATE
98     , p11_a79 out nocopy  NUMBER
99     , p11_a80 out nocopy  NUMBER
100     , p11_a81 out nocopy  VARCHAR2
101     , p11_a82 out nocopy  DATE
102   );
103   procedure update_trx_status(p_api_version  NUMBER
104     , p_init_msg_list  VARCHAR2
105     , x_return_status out nocopy  VARCHAR2
106     , x_msg_count out nocopy  NUMBER
107     , x_msg_data out nocopy  VARCHAR2
108     , p_chr_id  NUMBER
109     , p_status  VARCHAR2
110     , p7_a0 out nocopy  NUMBER
111     , p7_a1 out nocopy  NUMBER
112     , p7_a2 out nocopy  VARCHAR2
113     , p7_a3 out nocopy  VARCHAR2
114     , p7_a4 out nocopy  VARCHAR2
115     , p7_a5 out nocopy  VARCHAR2
116     , p7_a6 out nocopy  NUMBER
117     , p7_a7 out nocopy  NUMBER
118     , p7_a8 out nocopy  NUMBER
119     , p7_a9 out nocopy  NUMBER
120     , p7_a10 out nocopy  NUMBER
121     , p7_a11 out nocopy  NUMBER
122     , p7_a12 out nocopy  VARCHAR2
123     , p7_a13 out nocopy  VARCHAR2
124     , p7_a14 out nocopy  DATE
125     , p7_a15 out nocopy  VARCHAR2
126     , p7_a16 out nocopy  VARCHAR2
127     , p7_a17 out nocopy  NUMBER
128     , p7_a18 out nocopy  VARCHAR2
129     , p7_a19 out nocopy  VARCHAR2
130     , p7_a20 out nocopy  VARCHAR2
131     , p7_a21 out nocopy  VARCHAR2
132     , p7_a22 out nocopy  VARCHAR2
133     , p7_a23 out nocopy  VARCHAR2
134     , p7_a24 out nocopy  VARCHAR2
135     , p7_a25 out nocopy  VARCHAR2
136     , p7_a26 out nocopy  VARCHAR2
137     , p7_a27 out nocopy  VARCHAR2
138     , p7_a28 out nocopy  VARCHAR2
139     , p7_a29 out nocopy  VARCHAR2
140     , p7_a30 out nocopy  VARCHAR2
141     , p7_a31 out nocopy  VARCHAR2
142     , p7_a32 out nocopy  VARCHAR2
143     , p7_a33 out nocopy  VARCHAR2
144     , p7_a34 out nocopy  VARCHAR2
145     , p7_a35 out nocopy  VARCHAR2
146     , p7_a36 out nocopy  VARCHAR2
147     , p7_a37 out nocopy  NUMBER
148     , p7_a38 out nocopy  VARCHAR2
149     , p7_a39 out nocopy  NUMBER
150     , p7_a40 out nocopy  VARCHAR2
151     , p7_a41 out nocopy  VARCHAR2
152     , p7_a42 out nocopy  NUMBER
153     , p7_a43 out nocopy  NUMBER
154     , p7_a44 out nocopy  NUMBER
155     , p7_a45 out nocopy  NUMBER
156     , p7_a46 out nocopy  NUMBER
157     , p7_a47 out nocopy  NUMBER
158     , p7_a48 out nocopy  DATE
159     , p7_a49 out nocopy  NUMBER
160     , p7_a50 out nocopy  DATE
161     , p7_a51 out nocopy  NUMBER
162     , p7_a52 out nocopy  DATE
163     , p7_a53 out nocopy  NUMBER
164     , p7_a54 out nocopy  NUMBER
165     , p7_a55 out nocopy  VARCHAR2
166     , p7_a56 out nocopy  NUMBER
167     , p7_a57 out nocopy  VARCHAR2
168     , p7_a58 out nocopy  DATE
169     , p7_a59 out nocopy  VARCHAR2
170     , p7_a60 out nocopy  VARCHAR2
171     , p7_a61 out nocopy  VARCHAR2
172     , p7_a62 out nocopy  VARCHAR2
173     , p7_a63 out nocopy  VARCHAR2
174     , p7_a64 out nocopy  VARCHAR2
175     , p7_a65 out nocopy  VARCHAR2
176     , p7_a66 out nocopy  VARCHAR2
177     , p7_a67 out nocopy  VARCHAR2
178     , p7_a68 out nocopy  VARCHAR2
179     , p7_a69 out nocopy  VARCHAR2
180     , p7_a70 out nocopy  VARCHAR2
181     , p7_a71 out nocopy  VARCHAR2
182     , p7_a72 out nocopy  VARCHAR2
183     , p7_a73 out nocopy  VARCHAR2
184     , p7_a74 out nocopy  VARCHAR2
185     , p7_a75 out nocopy  VARCHAR2
186     , p7_a76 out nocopy  VARCHAR2
187     , p7_a77 out nocopy  NUMBER
188     , p7_a78 out nocopy  DATE
189     , p7_a79 out nocopy  NUMBER
190     , p7_a80 out nocopy  NUMBER
191     , p7_a81 out nocopy  VARCHAR2
192     , p7_a82 out nocopy  DATE
193   );
194   procedure abandon_revisions(p_api_version  NUMBER
195     , p_init_msg_list  VARCHAR2
196     , x_return_status out nocopy  VARCHAR2
197     , x_msg_count out nocopy  NUMBER
198     , x_msg_data out nocopy  VARCHAR2
199     , p5_a0 JTF_NUMBER_TABLE
200     , p_contract_status  VARCHAR2
201     , p_tsu_code  VARCHAR2
202   );
203   procedure check_contract_securitized(p_api_version  NUMBER
204     , p_init_msg_list  VARCHAR2
205     , x_return_status out nocopy  VARCHAR2
206     , x_msg_count out nocopy  NUMBER
207     , x_msg_data out nocopy  VARCHAR2
208     , p_chr_id  NUMBER
209     , p_trx_date  date
210   );
211   procedure check_contract_securitized(p_api_version  NUMBER
212     , p_init_msg_list  VARCHAR2
213     , x_return_status out nocopy  VARCHAR2
214     , x_msg_count out nocopy  NUMBER
215     , x_msg_data out nocopy  VARCHAR2
216     , p_chr_id  NUMBER
217     , p_cle_id  NUMBER
218     , p_stream_type_class  VARCHAR2
219     , p_trx_date  date
220   );
221   procedure create_service_transaction(p_api_version  NUMBER
222     , p_init_msg_list  VARCHAR2
223     , x_return_status out nocopy  VARCHAR2
224     , x_msg_count out nocopy  NUMBER
225     , x_msg_data out nocopy  VARCHAR2
226     , p_lease_id  NUMBER
227     , p_service_id  NUMBER
228     , p_description  VARCHAR2
229     , p_trx_date  date
230     , p_status  VARCHAR2
231     , p10_a0 out nocopy  NUMBER
232     , p10_a1 out nocopy  NUMBER
233     , p10_a2 out nocopy  VARCHAR2
234     , p10_a3 out nocopy  VARCHAR2
235     , p10_a4 out nocopy  VARCHAR2
236     , p10_a5 out nocopy  VARCHAR2
237     , p10_a6 out nocopy  NUMBER
238     , p10_a7 out nocopy  NUMBER
239     , p10_a8 out nocopy  NUMBER
240     , p10_a9 out nocopy  NUMBER
241     , p10_a10 out nocopy  NUMBER
242     , p10_a11 out nocopy  NUMBER
243     , p10_a12 out nocopy  VARCHAR2
244     , p10_a13 out nocopy  VARCHAR2
245     , p10_a14 out nocopy  DATE
246     , p10_a15 out nocopy  VARCHAR2
247     , p10_a16 out nocopy  VARCHAR2
248     , p10_a17 out nocopy  NUMBER
249     , p10_a18 out nocopy  VARCHAR2
250     , p10_a19 out nocopy  VARCHAR2
251     , p10_a20 out nocopy  VARCHAR2
252     , p10_a21 out nocopy  VARCHAR2
253     , p10_a22 out nocopy  VARCHAR2
254     , p10_a23 out nocopy  VARCHAR2
255     , p10_a24 out nocopy  VARCHAR2
256     , p10_a25 out nocopy  VARCHAR2
257     , p10_a26 out nocopy  VARCHAR2
258     , p10_a27 out nocopy  VARCHAR2
259     , p10_a28 out nocopy  VARCHAR2
260     , p10_a29 out nocopy  VARCHAR2
261     , p10_a30 out nocopy  VARCHAR2
262     , p10_a31 out nocopy  VARCHAR2
263     , p10_a32 out nocopy  VARCHAR2
264     , p10_a33 out nocopy  VARCHAR2
265     , p10_a34 out nocopy  VARCHAR2
266     , p10_a35 out nocopy  VARCHAR2
267     , p10_a36 out nocopy  VARCHAR2
268     , p10_a37 out nocopy  NUMBER
269     , p10_a38 out nocopy  VARCHAR2
270     , p10_a39 out nocopy  NUMBER
271     , p10_a40 out nocopy  VARCHAR2
272     , p10_a41 out nocopy  VARCHAR2
273     , p10_a42 out nocopy  NUMBER
274     , p10_a43 out nocopy  NUMBER
275     , p10_a44 out nocopy  NUMBER
276     , p10_a45 out nocopy  NUMBER
277     , p10_a46 out nocopy  NUMBER
278     , p10_a47 out nocopy  NUMBER
279     , p10_a48 out nocopy  DATE
280     , p10_a49 out nocopy  NUMBER
281     , p10_a50 out nocopy  DATE
282     , p10_a51 out nocopy  NUMBER
283     , p10_a52 out nocopy  DATE
284     , p10_a53 out nocopy  NUMBER
285     , p10_a54 out nocopy  NUMBER
286     , p10_a55 out nocopy  VARCHAR2
287     , p10_a56 out nocopy  NUMBER
288     , p10_a57 out nocopy  VARCHAR2
289     , p10_a58 out nocopy  DATE
290     , p10_a59 out nocopy  VARCHAR2
291     , p10_a60 out nocopy  VARCHAR2
292     , p10_a61 out nocopy  VARCHAR2
293     , p10_a62 out nocopy  VARCHAR2
294     , p10_a63 out nocopy  VARCHAR2
295     , p10_a64 out nocopy  VARCHAR2
296     , p10_a65 out nocopy  VARCHAR2
297     , p10_a66 out nocopy  VARCHAR2
298     , p10_a67 out nocopy  VARCHAR2
299     , p10_a68 out nocopy  VARCHAR2
300     , p10_a69 out nocopy  VARCHAR2
301     , p10_a70 out nocopy  VARCHAR2
302     , p10_a71 out nocopy  VARCHAR2
303     , p10_a72 out nocopy  VARCHAR2
304     , p10_a73 out nocopy  VARCHAR2
305     , p10_a74 out nocopy  VARCHAR2
306     , p10_a75 out nocopy  VARCHAR2
307     , p10_a76 out nocopy  VARCHAR2
308     , p10_a77 out nocopy  NUMBER
309     , p10_a78 out nocopy  DATE
310     , p10_a79 out nocopy  NUMBER
311     , p10_a80 out nocopy  NUMBER
312     , p10_a81 out nocopy  VARCHAR2
313     , p10_a82 out nocopy  DATE
314   );
315   procedure create_ppd_transaction(p_api_version  NUMBER
316     , p_init_msg_list  VARCHAR2
317     , x_return_status out nocopy  VARCHAR2
318     , x_msg_count out nocopy  NUMBER
319     , x_msg_data out nocopy  VARCHAR2
320     , p_chr_id  NUMBER
321     , p_trx_date  date
322     , p_trx_type  VARCHAR2
323     , p_reason_code  VARCHAR2
324     , p9_a0 out nocopy  NUMBER
325     , p9_a1 out nocopy  NUMBER
326     , p9_a2 out nocopy  VARCHAR2
327     , p9_a3 out nocopy  VARCHAR2
328     , p9_a4 out nocopy  VARCHAR2
329     , p9_a5 out nocopy  VARCHAR2
330     , p9_a6 out nocopy  NUMBER
331     , p9_a7 out nocopy  NUMBER
332     , p9_a8 out nocopy  NUMBER
333     , p9_a9 out nocopy  NUMBER
334     , p9_a10 out nocopy  NUMBER
335     , p9_a11 out nocopy  NUMBER
336     , p9_a12 out nocopy  VARCHAR2
337     , p9_a13 out nocopy  VARCHAR2
338     , p9_a14 out nocopy  DATE
339     , p9_a15 out nocopy  VARCHAR2
340     , p9_a16 out nocopy  VARCHAR2
341     , p9_a17 out nocopy  NUMBER
342     , p9_a18 out nocopy  VARCHAR2
343     , p9_a19 out nocopy  VARCHAR2
344     , p9_a20 out nocopy  VARCHAR2
345     , p9_a21 out nocopy  VARCHAR2
346     , p9_a22 out nocopy  VARCHAR2
347     , p9_a23 out nocopy  VARCHAR2
348     , p9_a24 out nocopy  VARCHAR2
349     , p9_a25 out nocopy  VARCHAR2
350     , p9_a26 out nocopy  VARCHAR2
351     , p9_a27 out nocopy  VARCHAR2
352     , p9_a28 out nocopy  VARCHAR2
353     , p9_a29 out nocopy  VARCHAR2
354     , p9_a30 out nocopy  VARCHAR2
355     , p9_a31 out nocopy  VARCHAR2
356     , p9_a32 out nocopy  VARCHAR2
357     , p9_a33 out nocopy  VARCHAR2
358     , p9_a34 out nocopy  VARCHAR2
359     , p9_a35 out nocopy  VARCHAR2
360     , p9_a36 out nocopy  VARCHAR2
361     , p9_a37 out nocopy  NUMBER
362     , p9_a38 out nocopy  VARCHAR2
363     , p9_a39 out nocopy  NUMBER
364     , p9_a40 out nocopy  VARCHAR2
365     , p9_a41 out nocopy  VARCHAR2
366     , p9_a42 out nocopy  NUMBER
367     , p9_a43 out nocopy  NUMBER
368     , p9_a44 out nocopy  NUMBER
369     , p9_a45 out nocopy  NUMBER
370     , p9_a46 out nocopy  NUMBER
371     , p9_a47 out nocopy  NUMBER
372     , p9_a48 out nocopy  DATE
373     , p9_a49 out nocopy  NUMBER
374     , p9_a50 out nocopy  DATE
375     , p9_a51 out nocopy  NUMBER
376     , p9_a52 out nocopy  DATE
377     , p9_a53 out nocopy  NUMBER
378     , p9_a54 out nocopy  NUMBER
379     , p9_a55 out nocopy  VARCHAR2
380     , p9_a56 out nocopy  NUMBER
381     , p9_a57 out nocopy  VARCHAR2
382     , p9_a58 out nocopy  DATE
383     , p9_a59 out nocopy  VARCHAR2
384     , p9_a60 out nocopy  VARCHAR2
385     , p9_a61 out nocopy  VARCHAR2
386     , p9_a62 out nocopy  VARCHAR2
387     , p9_a63 out nocopy  VARCHAR2
388     , p9_a64 out nocopy  VARCHAR2
389     , p9_a65 out nocopy  VARCHAR2
390     , p9_a66 out nocopy  VARCHAR2
391     , p9_a67 out nocopy  VARCHAR2
392     , p9_a68 out nocopy  VARCHAR2
393     , p9_a69 out nocopy  VARCHAR2
394     , p9_a70 out nocopy  VARCHAR2
395     , p9_a71 out nocopy  VARCHAR2
396     , p9_a72 out nocopy  VARCHAR2
397     , p9_a73 out nocopy  VARCHAR2
398     , p9_a74 out nocopy  VARCHAR2
399     , p9_a75 out nocopy  VARCHAR2
400     , p9_a76 out nocopy  VARCHAR2
401     , p9_a77 out nocopy  NUMBER
402     , p9_a78 out nocopy  DATE
403     , p9_a79 out nocopy  NUMBER
404     , p9_a80 out nocopy  NUMBER
405     , p9_a81 out nocopy  VARCHAR2
406     , p9_a82 out nocopy  DATE
407   );
408 end okl_transaction_pvt_w;