1: package okl_pal_pvt_w as
2: /* $Header: OKLIPALS.pls 120.0 2005/07/07 10:40:01 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pal_pvt.okl_pal_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_pal_pvt_w as
2: /* $Header: OKLIPALS.pls 120.0 2005/07/07 10:40:01 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pal_pvt.okl_pal_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
2: /* $Header: OKLIPALS.pls 120.0 2005/07/07 10:40:01 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pal_pvt.okl_pal_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t okl_pal_pvt.okl_pal_tbl, a0 out nocopy JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t okl_pal_pvt.okl_pal_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t okl_pal_pvt.okl_pal_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t okl_pal_pvt.okl_pal_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_DATE_TABLE
31: );
32: procedure rosetta_table_copy_out_p1(t okl_pal_pvt.okl_pal_tbl, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a5 out nocopy JTF_DATE_TABLE
38: , a6 out nocopy JTF_DATE_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: , a19 out nocopy JTF_VARCHAR2_TABLE_500
52: , a20 out nocopy JTF_VARCHAR2_TABLE_500
53: , a21 out nocopy JTF_VARCHAR2_TABLE_500
54: , a22 out nocopy JTF_VARCHAR2_TABLE_500
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
53: , a21 out nocopy JTF_VARCHAR2_TABLE_500
54: , a22 out nocopy JTF_VARCHAR2_TABLE_500
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure insert_row(p_api_version NUMBER
63: , p_init_msg_list VARCHAR2
125: , p_init_msg_list VARCHAR2
126: , x_return_status out nocopy VARCHAR2
127: , x_msg_count out nocopy NUMBER
128: , x_msg_data out nocopy VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_VARCHAR2_TABLE_100
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
126: , x_return_status out nocopy VARCHAR2
127: , x_msg_count out nocopy NUMBER
128: , x_msg_data out nocopy VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_VARCHAR2_TABLE_100
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_DATE_TABLE
128: , x_msg_data out nocopy VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_VARCHAR2_TABLE_100
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_DATE_TABLE
135: , p5_a6 JTF_DATE_TABLE
136: , p5_a7 JTF_VARCHAR2_TABLE_100
148: , p5_a19 JTF_VARCHAR2_TABLE_500
149: , p5_a20 JTF_VARCHAR2_TABLE_500
150: , p5_a21 JTF_VARCHAR2_TABLE_500
151: , p5_a22 JTF_VARCHAR2_TABLE_500
152: , p5_a23 JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
150: , p5_a21 JTF_VARCHAR2_TABLE_500
151: , p5_a22 JTF_VARCHAR2_TABLE_500
152: , p5_a23 JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
152: , p5_a23 JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_NUMBER_TABLE
153: , p5_a24 JTF_DATE_TABLE
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_NUMBER_TABLE
161: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
154: , p5_a25 JTF_NUMBER_TABLE
155: , p5_a26 JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_NUMBER_TABLE
161: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a5 out nocopy JTF_DATE_TABLE
156: , p5_a27 JTF_NUMBER_TABLE
157: , p6_a0 out nocopy JTF_NUMBER_TABLE
158: , p6_a1 out nocopy JTF_NUMBER_TABLE
159: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
160: , p6_a3 out nocopy JTF_NUMBER_TABLE
161: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a5 out nocopy JTF_DATE_TABLE
163: , p6_a6 out nocopy JTF_DATE_TABLE
164: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
177: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
178: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a23 out nocopy JTF_NUMBER_TABLE
181: , p6_a24 out nocopy JTF_DATE_TABLE
182: , p6_a25 out nocopy JTF_NUMBER_TABLE
183: , p6_a26 out nocopy JTF_DATE_TABLE
184: , p6_a27 out nocopy JTF_NUMBER_TABLE
178: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
179: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
180: , p6_a23 out nocopy JTF_NUMBER_TABLE
181: , p6_a24 out nocopy JTF_DATE_TABLE
182: , p6_a25 out nocopy JTF_NUMBER_TABLE
183: , p6_a26 out nocopy JTF_DATE_TABLE
184: , p6_a27 out nocopy JTF_NUMBER_TABLE
185: );
186: procedure update_row(p_api_version NUMBER
180: , p6_a23 out nocopy JTF_NUMBER_TABLE
181: , p6_a24 out nocopy JTF_DATE_TABLE
182: , p6_a25 out nocopy JTF_NUMBER_TABLE
183: , p6_a26 out nocopy JTF_DATE_TABLE
184: , p6_a27 out nocopy JTF_NUMBER_TABLE
185: );
186: procedure update_row(p_api_version NUMBER
187: , p_init_msg_list VARCHAR2
188: , x_return_status out nocopy VARCHAR2
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: , p5_a0 JTF_NUMBER_TABLE
254: , p5_a1 JTF_NUMBER_TABLE
255: , p5_a2 JTF_VARCHAR2_TABLE_100
256: , p5_a3 JTF_NUMBER_TABLE
257: , p5_a4 JTF_VARCHAR2_TABLE_100
250: , x_return_status out nocopy VARCHAR2
251: , x_msg_count out nocopy NUMBER
252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 JTF_NUMBER_TABLE
254: , p5_a1 JTF_NUMBER_TABLE
255: , p5_a2 JTF_VARCHAR2_TABLE_100
256: , p5_a3 JTF_NUMBER_TABLE
257: , p5_a4 JTF_VARCHAR2_TABLE_100
258: , p5_a5 JTF_DATE_TABLE
252: , x_msg_data out nocopy VARCHAR2
253: , p5_a0 JTF_NUMBER_TABLE
254: , p5_a1 JTF_NUMBER_TABLE
255: , p5_a2 JTF_VARCHAR2_TABLE_100
256: , p5_a3 JTF_NUMBER_TABLE
257: , p5_a4 JTF_VARCHAR2_TABLE_100
258: , p5_a5 JTF_DATE_TABLE
259: , p5_a6 JTF_DATE_TABLE
260: , p5_a7 JTF_VARCHAR2_TABLE_100
272: , p5_a19 JTF_VARCHAR2_TABLE_500
273: , p5_a20 JTF_VARCHAR2_TABLE_500
274: , p5_a21 JTF_VARCHAR2_TABLE_500
275: , p5_a22 JTF_VARCHAR2_TABLE_500
276: , p5_a23 JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
274: , p5_a21 JTF_VARCHAR2_TABLE_500
275: , p5_a22 JTF_VARCHAR2_TABLE_500
276: , p5_a23 JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
276: , p5_a23 JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_NUMBER_TABLE
277: , p5_a24 JTF_DATE_TABLE
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_NUMBER_TABLE
285: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
278: , p5_a25 JTF_NUMBER_TABLE
279: , p5_a26 JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_NUMBER_TABLE
285: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
286: , p6_a5 out nocopy JTF_DATE_TABLE
280: , p5_a27 JTF_NUMBER_TABLE
281: , p6_a0 out nocopy JTF_NUMBER_TABLE
282: , p6_a1 out nocopy JTF_NUMBER_TABLE
283: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
284: , p6_a3 out nocopy JTF_NUMBER_TABLE
285: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
286: , p6_a5 out nocopy JTF_DATE_TABLE
287: , p6_a6 out nocopy JTF_DATE_TABLE
288: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
300: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
301: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
302: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a23 out nocopy JTF_NUMBER_TABLE
305: , p6_a24 out nocopy JTF_DATE_TABLE
306: , p6_a25 out nocopy JTF_NUMBER_TABLE
307: , p6_a26 out nocopy JTF_DATE_TABLE
308: , p6_a27 out nocopy JTF_NUMBER_TABLE
302: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a23 out nocopy JTF_NUMBER_TABLE
305: , p6_a24 out nocopy JTF_DATE_TABLE
306: , p6_a25 out nocopy JTF_NUMBER_TABLE
307: , p6_a26 out nocopy JTF_DATE_TABLE
308: , p6_a27 out nocopy JTF_NUMBER_TABLE
309: );
310: procedure delete_row(p_api_version NUMBER
304: , p6_a23 out nocopy JTF_NUMBER_TABLE
305: , p6_a24 out nocopy JTF_DATE_TABLE
306: , p6_a25 out nocopy JTF_NUMBER_TABLE
307: , p6_a26 out nocopy JTF_DATE_TABLE
308: , p6_a27 out nocopy JTF_NUMBER_TABLE
309: );
310: procedure delete_row(p_api_version NUMBER
311: , p_init_msg_list VARCHAR2
312: , x_return_status out nocopy VARCHAR2
345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_NUMBER_TABLE
353: , p5_a4 JTF_VARCHAR2_TABLE_100
346: , x_return_status out nocopy VARCHAR2
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_NUMBER_TABLE
353: , p5_a4 JTF_VARCHAR2_TABLE_100
354: , p5_a5 JTF_DATE_TABLE
348: , x_msg_data out nocopy VARCHAR2
349: , p5_a0 JTF_NUMBER_TABLE
350: , p5_a1 JTF_NUMBER_TABLE
351: , p5_a2 JTF_VARCHAR2_TABLE_100
352: , p5_a3 JTF_NUMBER_TABLE
353: , p5_a4 JTF_VARCHAR2_TABLE_100
354: , p5_a5 JTF_DATE_TABLE
355: , p5_a6 JTF_DATE_TABLE
356: , p5_a7 JTF_VARCHAR2_TABLE_100
368: , p5_a19 JTF_VARCHAR2_TABLE_500
369: , p5_a20 JTF_VARCHAR2_TABLE_500
370: , p5_a21 JTF_VARCHAR2_TABLE_500
371: , p5_a22 JTF_VARCHAR2_TABLE_500
372: , p5_a23 JTF_NUMBER_TABLE
373: , p5_a24 JTF_DATE_TABLE
374: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a26 JTF_DATE_TABLE
376: , p5_a27 JTF_NUMBER_TABLE
370: , p5_a21 JTF_VARCHAR2_TABLE_500
371: , p5_a22 JTF_VARCHAR2_TABLE_500
372: , p5_a23 JTF_NUMBER_TABLE
373: , p5_a24 JTF_DATE_TABLE
374: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a26 JTF_DATE_TABLE
376: , p5_a27 JTF_NUMBER_TABLE
377: );
378: end okl_pal_pvt_w;
372: , p5_a23 JTF_NUMBER_TABLE
373: , p5_a24 JTF_DATE_TABLE
374: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a26 JTF_DATE_TABLE
376: , p5_a27 JTF_NUMBER_TABLE
377: );
378: end okl_pal_pvt_w;