1: package okl_tpl_pvt_w as
2: /* $Header: OKLITPLS.pls 120.2 2007/11/06 07:37:18 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tpl_pvt.tpl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
2: /* $Header: OKLITPLS.pls 120.2 2007/11/06 07:37:18 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tpl_pvt.tpl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_VARCHAR2_TABLE_3000
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_VARCHAR2_TABLE_500
45: , a42 JTF_DATE_TABLE
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_DATE_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_100
46: , a43 JTF_NUMBER_TABLE
47: , a44 JTF_DATE_TABLE
48: , a45 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_100
54: , a51 JTF_NUMBER_TABLE
49: , a46 JTF_VARCHAR2_TABLE_100
50: , a47 JTF_VARCHAR2_TABLE_100
51: , a48 JTF_NUMBER_TABLE
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_VARCHAR2_TABLE_100
54: , a51 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p2(t okl_tpl_pvt.tpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a50 JTF_VARCHAR2_TABLE_100
54: , a51 JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p2(t okl_tpl_pvt.tpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_100
58: , a2 out nocopy JTF_NUMBER_TABLE
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
55: );
56: procedure rosetta_table_copy_out_p2(t okl_tpl_pvt.tpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_VARCHAR2_TABLE_100
58: , a2 out nocopy JTF_NUMBER_TABLE
59: , a3 out nocopy JTF_VARCHAR2_TABLE_100
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
77: , a21 out nocopy JTF_NUMBER_TABLE
78: , a22 out nocopy JTF_DATE_TABLE
79: , a23 out nocopy JTF_NUMBER_TABLE
80: , a24 out nocopy JTF_VARCHAR2_TABLE_3000
81: , a25 out nocopy JTF_VARCHAR2_TABLE_100
82: , a26 out nocopy JTF_VARCHAR2_TABLE_500
83: , a27 out nocopy JTF_VARCHAR2_TABLE_500
84: , a28 out nocopy JTF_VARCHAR2_TABLE_500
85: , a29 out nocopy JTF_VARCHAR2_TABLE_500
98: , a42 out nocopy JTF_DATE_TABLE
99: , a43 out nocopy JTF_NUMBER_TABLE
100: , a44 out nocopy JTF_DATE_TABLE
101: , a45 out nocopy JTF_NUMBER_TABLE
102: , a46 out nocopy JTF_VARCHAR2_TABLE_100
103: , a47 out nocopy JTF_VARCHAR2_TABLE_100
104: , a48 out nocopy JTF_NUMBER_TABLE
105: , a49 out nocopy JTF_NUMBER_TABLE
106: , a50 out nocopy JTF_VARCHAR2_TABLE_100
99: , a43 out nocopy JTF_NUMBER_TABLE
100: , a44 out nocopy JTF_DATE_TABLE
101: , a45 out nocopy JTF_NUMBER_TABLE
102: , a46 out nocopy JTF_VARCHAR2_TABLE_100
103: , a47 out nocopy JTF_VARCHAR2_TABLE_100
104: , a48 out nocopy JTF_NUMBER_TABLE
105: , a49 out nocopy JTF_NUMBER_TABLE
106: , a50 out nocopy JTF_VARCHAR2_TABLE_100
107: , a51 out nocopy JTF_NUMBER_TABLE
102: , a46 out nocopy JTF_VARCHAR2_TABLE_100
103: , a47 out nocopy JTF_VARCHAR2_TABLE_100
104: , a48 out nocopy JTF_NUMBER_TABLE
105: , a49 out nocopy JTF_NUMBER_TABLE
106: , a50 out nocopy JTF_VARCHAR2_TABLE_100
107: , a51 out nocopy JTF_NUMBER_TABLE
108: );
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
107: , a51 out nocopy JTF_NUMBER_TABLE
108: );
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
111: , a1 JTF_VARCHAR2_TABLE_100
112: , a2 JTF_VARCHAR2_TABLE_100
113: , a3 JTF_VARCHAR2_TABLE_100
114: , a4 JTF_VARCHAR2_TABLE_2000
115: , a5 JTF_NUMBER_TABLE
108: );
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
111: , a1 JTF_VARCHAR2_TABLE_100
112: , a2 JTF_VARCHAR2_TABLE_100
113: , a3 JTF_VARCHAR2_TABLE_100
114: , a4 JTF_VARCHAR2_TABLE_2000
115: , a5 JTF_NUMBER_TABLE
116: , a6 JTF_DATE_TABLE
109:
110: procedure rosetta_table_copy_in_p5(t out nocopy okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 JTF_NUMBER_TABLE
111: , a1 JTF_VARCHAR2_TABLE_100
112: , a2 JTF_VARCHAR2_TABLE_100
113: , a3 JTF_VARCHAR2_TABLE_100
114: , a4 JTF_VARCHAR2_TABLE_2000
115: , a5 JTF_NUMBER_TABLE
116: , a6 JTF_DATE_TABLE
117: , a7 JTF_NUMBER_TABLE
118: , a8 JTF_DATE_TABLE
119: , a9 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_VARCHAR2_TABLE_100
125: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
126: , a5 out nocopy JTF_NUMBER_TABLE
119: , a9 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_VARCHAR2_TABLE_100
125: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_DATE_TABLE
120: );
121: procedure rosetta_table_copy_out_p5(t okl_tpl_pvt.okl_txl_ap_inv_lns_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_VARCHAR2_TABLE_100
125: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_DATE_TABLE
128: , a7 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure rosetta_table_copy_in_p8(t out nocopy okl_tpl_pvt.tplv_tbl_type, a0 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_VARCHAR2_TABLE_100
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
134: , a1 JTF_NUMBER_TABLE
135: , a2 JTF_VARCHAR2_TABLE_100
136: , a3 JTF_NUMBER_TABLE
137: , a4 JTF_NUMBER_TABLE
138: , a5 JTF_VARCHAR2_TABLE_100
139: , a6 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_NUMBER_TABLE
140: , a7 JTF_NUMBER_TABLE
141: , a8 JTF_NUMBER_TABLE
142: , a9 JTF_NUMBER_TABLE
143: , a10 JTF_NUMBER_TABLE
144: , a11 JTF_VARCHAR2_TABLE_100
145: , a12 JTF_NUMBER_TABLE
146: , a13 JTF_NUMBER_TABLE
147: , a14 JTF_DATE_TABLE
148: , a15 JTF_NUMBER_TABLE
151: , a18 JTF_NUMBER_TABLE
152: , a19 JTF_NUMBER_TABLE
153: , a20 JTF_VARCHAR2_TABLE_2000
154: , a21 JTF_VARCHAR2_TABLE_3000
155: , a22 JTF_VARCHAR2_TABLE_100
156: , a23 JTF_VARCHAR2_TABLE_500
157: , a24 JTF_VARCHAR2_TABLE_500
158: , a25 JTF_VARCHAR2_TABLE_500
159: , a26 JTF_VARCHAR2_TABLE_500
177: , a44 JTF_DATE_TABLE
178: , a45 JTF_NUMBER_TABLE
179: , a46 JTF_DATE_TABLE
180: , a47 JTF_NUMBER_TABLE
181: , a48 JTF_VARCHAR2_TABLE_100
182: , a49 JTF_VARCHAR2_TABLE_100
183: , a50 JTF_NUMBER_TABLE
184: , a51 JTF_NUMBER_TABLE
185: , a52 JTF_VARCHAR2_TABLE_100
178: , a45 JTF_NUMBER_TABLE
179: , a46 JTF_DATE_TABLE
180: , a47 JTF_NUMBER_TABLE
181: , a48 JTF_VARCHAR2_TABLE_100
182: , a49 JTF_VARCHAR2_TABLE_100
183: , a50 JTF_NUMBER_TABLE
184: , a51 JTF_NUMBER_TABLE
185: , a52 JTF_VARCHAR2_TABLE_100
186: , a53 JTF_NUMBER_TABLE
181: , a48 JTF_VARCHAR2_TABLE_100
182: , a49 JTF_VARCHAR2_TABLE_100
183: , a50 JTF_NUMBER_TABLE
184: , a51 JTF_NUMBER_TABLE
185: , a52 JTF_VARCHAR2_TABLE_100
186: , a53 JTF_NUMBER_TABLE
187: );
188: procedure rosetta_table_copy_out_p8(t okl_tpl_pvt.tplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_NUMBER_TABLE
186: , a53 JTF_NUMBER_TABLE
187: );
188: procedure rosetta_table_copy_out_p8(t okl_tpl_pvt.tplv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_NUMBER_TABLE
190: , a2 out nocopy JTF_VARCHAR2_TABLE_100
191: , a3 out nocopy JTF_NUMBER_TABLE
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
189: , a1 out nocopy JTF_NUMBER_TABLE
190: , a2 out nocopy JTF_VARCHAR2_TABLE_100
191: , a3 out nocopy JTF_NUMBER_TABLE
192: , a4 out nocopy JTF_NUMBER_TABLE
193: , a5 out nocopy JTF_VARCHAR2_TABLE_100
194: , a6 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_NUMBER_TABLE
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_NUMBER_TABLE
195: , a7 out nocopy JTF_NUMBER_TABLE
196: , a8 out nocopy JTF_NUMBER_TABLE
197: , a9 out nocopy JTF_NUMBER_TABLE
198: , a10 out nocopy JTF_NUMBER_TABLE
199: , a11 out nocopy JTF_VARCHAR2_TABLE_100
200: , a12 out nocopy JTF_NUMBER_TABLE
201: , a13 out nocopy JTF_NUMBER_TABLE
202: , a14 out nocopy JTF_DATE_TABLE
203: , a15 out nocopy JTF_NUMBER_TABLE
206: , a18 out nocopy JTF_NUMBER_TABLE
207: , a19 out nocopy JTF_NUMBER_TABLE
208: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
209: , a21 out nocopy JTF_VARCHAR2_TABLE_3000
210: , a22 out nocopy JTF_VARCHAR2_TABLE_100
211: , a23 out nocopy JTF_VARCHAR2_TABLE_500
212: , a24 out nocopy JTF_VARCHAR2_TABLE_500
213: , a25 out nocopy JTF_VARCHAR2_TABLE_500
214: , a26 out nocopy JTF_VARCHAR2_TABLE_500
232: , a44 out nocopy JTF_DATE_TABLE
233: , a45 out nocopy JTF_NUMBER_TABLE
234: , a46 out nocopy JTF_DATE_TABLE
235: , a47 out nocopy JTF_NUMBER_TABLE
236: , a48 out nocopy JTF_VARCHAR2_TABLE_100
237: , a49 out nocopy JTF_VARCHAR2_TABLE_100
238: , a50 out nocopy JTF_NUMBER_TABLE
239: , a51 out nocopy JTF_NUMBER_TABLE
240: , a52 out nocopy JTF_VARCHAR2_TABLE_100
233: , a45 out nocopy JTF_NUMBER_TABLE
234: , a46 out nocopy JTF_DATE_TABLE
235: , a47 out nocopy JTF_NUMBER_TABLE
236: , a48 out nocopy JTF_VARCHAR2_TABLE_100
237: , a49 out nocopy JTF_VARCHAR2_TABLE_100
238: , a50 out nocopy JTF_NUMBER_TABLE
239: , a51 out nocopy JTF_NUMBER_TABLE
240: , a52 out nocopy JTF_VARCHAR2_TABLE_100
241: , a53 out nocopy JTF_NUMBER_TABLE
236: , a48 out nocopy JTF_VARCHAR2_TABLE_100
237: , a49 out nocopy JTF_VARCHAR2_TABLE_100
238: , a50 out nocopy JTF_NUMBER_TABLE
239: , a51 out nocopy JTF_NUMBER_TABLE
240: , a52 out nocopy JTF_VARCHAR2_TABLE_100
241: , a53 out nocopy JTF_NUMBER_TABLE
242: );
243:
244: procedure insert_row(p_api_version NUMBER
361: , x_msg_count out nocopy NUMBER
362: , x_msg_data out nocopy VARCHAR2
363: , p5_a0 JTF_NUMBER_TABLE
364: , p5_a1 JTF_NUMBER_TABLE
365: , p5_a2 JTF_VARCHAR2_TABLE_100
366: , p5_a3 JTF_NUMBER_TABLE
367: , p5_a4 JTF_NUMBER_TABLE
368: , p5_a5 JTF_VARCHAR2_TABLE_100
369: , p5_a6 JTF_NUMBER_TABLE
364: , p5_a1 JTF_NUMBER_TABLE
365: , p5_a2 JTF_VARCHAR2_TABLE_100
366: , p5_a3 JTF_NUMBER_TABLE
367: , p5_a4 JTF_NUMBER_TABLE
368: , p5_a5 JTF_VARCHAR2_TABLE_100
369: , p5_a6 JTF_NUMBER_TABLE
370: , p5_a7 JTF_NUMBER_TABLE
371: , p5_a8 JTF_NUMBER_TABLE
372: , p5_a9 JTF_NUMBER_TABLE
370: , p5_a7 JTF_NUMBER_TABLE
371: , p5_a8 JTF_NUMBER_TABLE
372: , p5_a9 JTF_NUMBER_TABLE
373: , p5_a10 JTF_NUMBER_TABLE
374: , p5_a11 JTF_VARCHAR2_TABLE_100
375: , p5_a12 JTF_NUMBER_TABLE
376: , p5_a13 JTF_NUMBER_TABLE
377: , p5_a14 JTF_DATE_TABLE
378: , p5_a15 JTF_NUMBER_TABLE
381: , p5_a18 JTF_NUMBER_TABLE
382: , p5_a19 JTF_NUMBER_TABLE
383: , p5_a20 JTF_VARCHAR2_TABLE_2000
384: , p5_a21 JTF_VARCHAR2_TABLE_3000
385: , p5_a22 JTF_VARCHAR2_TABLE_100
386: , p5_a23 JTF_VARCHAR2_TABLE_500
387: , p5_a24 JTF_VARCHAR2_TABLE_500
388: , p5_a25 JTF_VARCHAR2_TABLE_500
389: , p5_a26 JTF_VARCHAR2_TABLE_500
407: , p5_a44 JTF_DATE_TABLE
408: , p5_a45 JTF_NUMBER_TABLE
409: , p5_a46 JTF_DATE_TABLE
410: , p5_a47 JTF_NUMBER_TABLE
411: , p5_a48 JTF_VARCHAR2_TABLE_100
412: , p5_a49 JTF_VARCHAR2_TABLE_100
413: , p5_a50 JTF_NUMBER_TABLE
414: , p5_a51 JTF_NUMBER_TABLE
415: , p5_a52 JTF_VARCHAR2_TABLE_100
408: , p5_a45 JTF_NUMBER_TABLE
409: , p5_a46 JTF_DATE_TABLE
410: , p5_a47 JTF_NUMBER_TABLE
411: , p5_a48 JTF_VARCHAR2_TABLE_100
412: , p5_a49 JTF_VARCHAR2_TABLE_100
413: , p5_a50 JTF_NUMBER_TABLE
414: , p5_a51 JTF_NUMBER_TABLE
415: , p5_a52 JTF_VARCHAR2_TABLE_100
416: , p5_a53 JTF_NUMBER_TABLE
411: , p5_a48 JTF_VARCHAR2_TABLE_100
412: , p5_a49 JTF_VARCHAR2_TABLE_100
413: , p5_a50 JTF_NUMBER_TABLE
414: , p5_a51 JTF_NUMBER_TABLE
415: , p5_a52 JTF_VARCHAR2_TABLE_100
416: , p5_a53 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
415: , p5_a52 JTF_VARCHAR2_TABLE_100
416: , p5_a53 JTF_NUMBER_TABLE
417: , p6_a0 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
420: , p6_a3 out nocopy JTF_NUMBER_TABLE
421: , p6_a4 out nocopy JTF_NUMBER_TABLE
422: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 out nocopy JTF_NUMBER_TABLE
418: , p6_a1 out nocopy JTF_NUMBER_TABLE
419: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
420: , p6_a3 out nocopy JTF_NUMBER_TABLE
421: , p6_a4 out nocopy JTF_NUMBER_TABLE
422: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 out nocopy JTF_NUMBER_TABLE
424: , p6_a7 out nocopy JTF_NUMBER_TABLE
425: , p6_a8 out nocopy JTF_NUMBER_TABLE
426: , p6_a9 out nocopy JTF_NUMBER_TABLE
424: , p6_a7 out nocopy JTF_NUMBER_TABLE
425: , p6_a8 out nocopy JTF_NUMBER_TABLE
426: , p6_a9 out nocopy JTF_NUMBER_TABLE
427: , p6_a10 out nocopy JTF_NUMBER_TABLE
428: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a12 out nocopy JTF_NUMBER_TABLE
430: , p6_a13 out nocopy JTF_NUMBER_TABLE
431: , p6_a14 out nocopy JTF_DATE_TABLE
432: , p6_a15 out nocopy JTF_NUMBER_TABLE
435: , p6_a18 out nocopy JTF_NUMBER_TABLE
436: , p6_a19 out nocopy JTF_NUMBER_TABLE
437: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
438: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_3000
439: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
440: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
461: , p6_a44 out nocopy JTF_DATE_TABLE
462: , p6_a45 out nocopy JTF_NUMBER_TABLE
463: , p6_a46 out nocopy JTF_DATE_TABLE
464: , p6_a47 out nocopy JTF_NUMBER_TABLE
465: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a50 out nocopy JTF_NUMBER_TABLE
468: , p6_a51 out nocopy JTF_NUMBER_TABLE
469: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
462: , p6_a45 out nocopy JTF_NUMBER_TABLE
463: , p6_a46 out nocopy JTF_DATE_TABLE
464: , p6_a47 out nocopy JTF_NUMBER_TABLE
465: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a50 out nocopy JTF_NUMBER_TABLE
468: , p6_a51 out nocopy JTF_NUMBER_TABLE
469: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a53 out nocopy JTF_NUMBER_TABLE
465: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a50 out nocopy JTF_NUMBER_TABLE
468: , p6_a51 out nocopy JTF_NUMBER_TABLE
469: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a53 out nocopy JTF_NUMBER_TABLE
471: );
472: procedure lock_row(p_api_version NUMBER
473: , p_init_msg_list VARCHAR2
535: , x_msg_count out nocopy NUMBER
536: , x_msg_data out nocopy VARCHAR2
537: , p5_a0 JTF_NUMBER_TABLE
538: , p5_a1 JTF_NUMBER_TABLE
539: , p5_a2 JTF_VARCHAR2_TABLE_100
540: , p5_a3 JTF_NUMBER_TABLE
541: , p5_a4 JTF_NUMBER_TABLE
542: , p5_a5 JTF_VARCHAR2_TABLE_100
543: , p5_a6 JTF_NUMBER_TABLE
538: , p5_a1 JTF_NUMBER_TABLE
539: , p5_a2 JTF_VARCHAR2_TABLE_100
540: , p5_a3 JTF_NUMBER_TABLE
541: , p5_a4 JTF_NUMBER_TABLE
542: , p5_a5 JTF_VARCHAR2_TABLE_100
543: , p5_a6 JTF_NUMBER_TABLE
544: , p5_a7 JTF_NUMBER_TABLE
545: , p5_a8 JTF_NUMBER_TABLE
546: , p5_a9 JTF_NUMBER_TABLE
544: , p5_a7 JTF_NUMBER_TABLE
545: , p5_a8 JTF_NUMBER_TABLE
546: , p5_a9 JTF_NUMBER_TABLE
547: , p5_a10 JTF_NUMBER_TABLE
548: , p5_a11 JTF_VARCHAR2_TABLE_100
549: , p5_a12 JTF_NUMBER_TABLE
550: , p5_a13 JTF_NUMBER_TABLE
551: , p5_a14 JTF_DATE_TABLE
552: , p5_a15 JTF_NUMBER_TABLE
555: , p5_a18 JTF_NUMBER_TABLE
556: , p5_a19 JTF_NUMBER_TABLE
557: , p5_a20 JTF_VARCHAR2_TABLE_2000
558: , p5_a21 JTF_VARCHAR2_TABLE_3000
559: , p5_a22 JTF_VARCHAR2_TABLE_100
560: , p5_a23 JTF_VARCHAR2_TABLE_500
561: , p5_a24 JTF_VARCHAR2_TABLE_500
562: , p5_a25 JTF_VARCHAR2_TABLE_500
563: , p5_a26 JTF_VARCHAR2_TABLE_500
581: , p5_a44 JTF_DATE_TABLE
582: , p5_a45 JTF_NUMBER_TABLE
583: , p5_a46 JTF_DATE_TABLE
584: , p5_a47 JTF_NUMBER_TABLE
585: , p5_a48 JTF_VARCHAR2_TABLE_100
586: , p5_a49 JTF_VARCHAR2_TABLE_100
587: , p5_a50 JTF_NUMBER_TABLE
588: , p5_a51 JTF_NUMBER_TABLE
589: , p5_a52 JTF_VARCHAR2_TABLE_100
582: , p5_a45 JTF_NUMBER_TABLE
583: , p5_a46 JTF_DATE_TABLE
584: , p5_a47 JTF_NUMBER_TABLE
585: , p5_a48 JTF_VARCHAR2_TABLE_100
586: , p5_a49 JTF_VARCHAR2_TABLE_100
587: , p5_a50 JTF_NUMBER_TABLE
588: , p5_a51 JTF_NUMBER_TABLE
589: , p5_a52 JTF_VARCHAR2_TABLE_100
590: , p5_a53 JTF_NUMBER_TABLE
585: , p5_a48 JTF_VARCHAR2_TABLE_100
586: , p5_a49 JTF_VARCHAR2_TABLE_100
587: , p5_a50 JTF_NUMBER_TABLE
588: , p5_a51 JTF_NUMBER_TABLE
589: , p5_a52 JTF_VARCHAR2_TABLE_100
590: , p5_a53 JTF_NUMBER_TABLE
591: );
592: procedure update_row(p_api_version NUMBER
593: , p_init_msg_list VARCHAR2
709: , x_msg_count out nocopy NUMBER
710: , x_msg_data out nocopy VARCHAR2
711: , p5_a0 JTF_NUMBER_TABLE
712: , p5_a1 JTF_NUMBER_TABLE
713: , p5_a2 JTF_VARCHAR2_TABLE_100
714: , p5_a3 JTF_NUMBER_TABLE
715: , p5_a4 JTF_NUMBER_TABLE
716: , p5_a5 JTF_VARCHAR2_TABLE_100
717: , p5_a6 JTF_NUMBER_TABLE
712: , p5_a1 JTF_NUMBER_TABLE
713: , p5_a2 JTF_VARCHAR2_TABLE_100
714: , p5_a3 JTF_NUMBER_TABLE
715: , p5_a4 JTF_NUMBER_TABLE
716: , p5_a5 JTF_VARCHAR2_TABLE_100
717: , p5_a6 JTF_NUMBER_TABLE
718: , p5_a7 JTF_NUMBER_TABLE
719: , p5_a8 JTF_NUMBER_TABLE
720: , p5_a9 JTF_NUMBER_TABLE
718: , p5_a7 JTF_NUMBER_TABLE
719: , p5_a8 JTF_NUMBER_TABLE
720: , p5_a9 JTF_NUMBER_TABLE
721: , p5_a10 JTF_NUMBER_TABLE
722: , p5_a11 JTF_VARCHAR2_TABLE_100
723: , p5_a12 JTF_NUMBER_TABLE
724: , p5_a13 JTF_NUMBER_TABLE
725: , p5_a14 JTF_DATE_TABLE
726: , p5_a15 JTF_NUMBER_TABLE
729: , p5_a18 JTF_NUMBER_TABLE
730: , p5_a19 JTF_NUMBER_TABLE
731: , p5_a20 JTF_VARCHAR2_TABLE_2000
732: , p5_a21 JTF_VARCHAR2_TABLE_3000
733: , p5_a22 JTF_VARCHAR2_TABLE_100
734: , p5_a23 JTF_VARCHAR2_TABLE_500
735: , p5_a24 JTF_VARCHAR2_TABLE_500
736: , p5_a25 JTF_VARCHAR2_TABLE_500
737: , p5_a26 JTF_VARCHAR2_TABLE_500
755: , p5_a44 JTF_DATE_TABLE
756: , p5_a45 JTF_NUMBER_TABLE
757: , p5_a46 JTF_DATE_TABLE
758: , p5_a47 JTF_NUMBER_TABLE
759: , p5_a48 JTF_VARCHAR2_TABLE_100
760: , p5_a49 JTF_VARCHAR2_TABLE_100
761: , p5_a50 JTF_NUMBER_TABLE
762: , p5_a51 JTF_NUMBER_TABLE
763: , p5_a52 JTF_VARCHAR2_TABLE_100
756: , p5_a45 JTF_NUMBER_TABLE
757: , p5_a46 JTF_DATE_TABLE
758: , p5_a47 JTF_NUMBER_TABLE
759: , p5_a48 JTF_VARCHAR2_TABLE_100
760: , p5_a49 JTF_VARCHAR2_TABLE_100
761: , p5_a50 JTF_NUMBER_TABLE
762: , p5_a51 JTF_NUMBER_TABLE
763: , p5_a52 JTF_VARCHAR2_TABLE_100
764: , p5_a53 JTF_NUMBER_TABLE
759: , p5_a48 JTF_VARCHAR2_TABLE_100
760: , p5_a49 JTF_VARCHAR2_TABLE_100
761: , p5_a50 JTF_NUMBER_TABLE
762: , p5_a51 JTF_NUMBER_TABLE
763: , p5_a52 JTF_VARCHAR2_TABLE_100
764: , p5_a53 JTF_NUMBER_TABLE
765: , p6_a0 out nocopy JTF_NUMBER_TABLE
766: , p6_a1 out nocopy JTF_NUMBER_TABLE
767: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
763: , p5_a52 JTF_VARCHAR2_TABLE_100
764: , p5_a53 JTF_NUMBER_TABLE
765: , p6_a0 out nocopy JTF_NUMBER_TABLE
766: , p6_a1 out nocopy JTF_NUMBER_TABLE
767: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a3 out nocopy JTF_NUMBER_TABLE
769: , p6_a4 out nocopy JTF_NUMBER_TABLE
770: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
766: , p6_a1 out nocopy JTF_NUMBER_TABLE
767: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
768: , p6_a3 out nocopy JTF_NUMBER_TABLE
769: , p6_a4 out nocopy JTF_NUMBER_TABLE
770: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
771: , p6_a6 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_NUMBER_TABLE
773: , p6_a8 out nocopy JTF_NUMBER_TABLE
774: , p6_a9 out nocopy JTF_NUMBER_TABLE
772: , p6_a7 out nocopy JTF_NUMBER_TABLE
773: , p6_a8 out nocopy JTF_NUMBER_TABLE
774: , p6_a9 out nocopy JTF_NUMBER_TABLE
775: , p6_a10 out nocopy JTF_NUMBER_TABLE
776: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
777: , p6_a12 out nocopy JTF_NUMBER_TABLE
778: , p6_a13 out nocopy JTF_NUMBER_TABLE
779: , p6_a14 out nocopy JTF_DATE_TABLE
780: , p6_a15 out nocopy JTF_NUMBER_TABLE
783: , p6_a18 out nocopy JTF_NUMBER_TABLE
784: , p6_a19 out nocopy JTF_NUMBER_TABLE
785: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
786: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_3000
787: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_100
788: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
789: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
790: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
791: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
809: , p6_a44 out nocopy JTF_DATE_TABLE
810: , p6_a45 out nocopy JTF_NUMBER_TABLE
811: , p6_a46 out nocopy JTF_DATE_TABLE
812: , p6_a47 out nocopy JTF_NUMBER_TABLE
813: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
814: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a50 out nocopy JTF_NUMBER_TABLE
816: , p6_a51 out nocopy JTF_NUMBER_TABLE
817: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
810: , p6_a45 out nocopy JTF_NUMBER_TABLE
811: , p6_a46 out nocopy JTF_DATE_TABLE
812: , p6_a47 out nocopy JTF_NUMBER_TABLE
813: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
814: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a50 out nocopy JTF_NUMBER_TABLE
816: , p6_a51 out nocopy JTF_NUMBER_TABLE
817: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a53 out nocopy JTF_NUMBER_TABLE
813: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_100
814: , p6_a49 out nocopy JTF_VARCHAR2_TABLE_100
815: , p6_a50 out nocopy JTF_NUMBER_TABLE
816: , p6_a51 out nocopy JTF_NUMBER_TABLE
817: , p6_a52 out nocopy JTF_VARCHAR2_TABLE_100
818: , p6_a53 out nocopy JTF_NUMBER_TABLE
819: );
820: procedure delete_row(p_api_version NUMBER
821: , p_init_msg_list VARCHAR2
883: , x_msg_count out nocopy NUMBER
884: , x_msg_data out nocopy VARCHAR2
885: , p5_a0 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_VARCHAR2_TABLE_100
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_NUMBER_TABLE
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_NUMBER_TABLE
886: , p5_a1 JTF_NUMBER_TABLE
887: , p5_a2 JTF_VARCHAR2_TABLE_100
888: , p5_a3 JTF_NUMBER_TABLE
889: , p5_a4 JTF_NUMBER_TABLE
890: , p5_a5 JTF_VARCHAR2_TABLE_100
891: , p5_a6 JTF_NUMBER_TABLE
892: , p5_a7 JTF_NUMBER_TABLE
893: , p5_a8 JTF_NUMBER_TABLE
894: , p5_a9 JTF_NUMBER_TABLE
892: , p5_a7 JTF_NUMBER_TABLE
893: , p5_a8 JTF_NUMBER_TABLE
894: , p5_a9 JTF_NUMBER_TABLE
895: , p5_a10 JTF_NUMBER_TABLE
896: , p5_a11 JTF_VARCHAR2_TABLE_100
897: , p5_a12 JTF_NUMBER_TABLE
898: , p5_a13 JTF_NUMBER_TABLE
899: , p5_a14 JTF_DATE_TABLE
900: , p5_a15 JTF_NUMBER_TABLE
903: , p5_a18 JTF_NUMBER_TABLE
904: , p5_a19 JTF_NUMBER_TABLE
905: , p5_a20 JTF_VARCHAR2_TABLE_2000
906: , p5_a21 JTF_VARCHAR2_TABLE_3000
907: , p5_a22 JTF_VARCHAR2_TABLE_100
908: , p5_a23 JTF_VARCHAR2_TABLE_500
909: , p5_a24 JTF_VARCHAR2_TABLE_500
910: , p5_a25 JTF_VARCHAR2_TABLE_500
911: , p5_a26 JTF_VARCHAR2_TABLE_500
929: , p5_a44 JTF_DATE_TABLE
930: , p5_a45 JTF_NUMBER_TABLE
931: , p5_a46 JTF_DATE_TABLE
932: , p5_a47 JTF_NUMBER_TABLE
933: , p5_a48 JTF_VARCHAR2_TABLE_100
934: , p5_a49 JTF_VARCHAR2_TABLE_100
935: , p5_a50 JTF_NUMBER_TABLE
936: , p5_a51 JTF_NUMBER_TABLE
937: , p5_a52 JTF_VARCHAR2_TABLE_100
930: , p5_a45 JTF_NUMBER_TABLE
931: , p5_a46 JTF_DATE_TABLE
932: , p5_a47 JTF_NUMBER_TABLE
933: , p5_a48 JTF_VARCHAR2_TABLE_100
934: , p5_a49 JTF_VARCHAR2_TABLE_100
935: , p5_a50 JTF_NUMBER_TABLE
936: , p5_a51 JTF_NUMBER_TABLE
937: , p5_a52 JTF_VARCHAR2_TABLE_100
938: , p5_a53 JTF_NUMBER_TABLE
933: , p5_a48 JTF_VARCHAR2_TABLE_100
934: , p5_a49 JTF_VARCHAR2_TABLE_100
935: , p5_a50 JTF_NUMBER_TABLE
936: , p5_a51 JTF_NUMBER_TABLE
937: , p5_a52 JTF_VARCHAR2_TABLE_100
938: , p5_a53 JTF_NUMBER_TABLE
939: );
940: procedure validate_row(p_api_version NUMBER
941: , p_init_msg_list VARCHAR2
1003: , x_msg_count out nocopy NUMBER
1004: , x_msg_data out nocopy VARCHAR2
1005: , p5_a0 JTF_NUMBER_TABLE
1006: , p5_a1 JTF_NUMBER_TABLE
1007: , p5_a2 JTF_VARCHAR2_TABLE_100
1008: , p5_a3 JTF_NUMBER_TABLE
1009: , p5_a4 JTF_NUMBER_TABLE
1010: , p5_a5 JTF_VARCHAR2_TABLE_100
1011: , p5_a6 JTF_NUMBER_TABLE
1006: , p5_a1 JTF_NUMBER_TABLE
1007: , p5_a2 JTF_VARCHAR2_TABLE_100
1008: , p5_a3 JTF_NUMBER_TABLE
1009: , p5_a4 JTF_NUMBER_TABLE
1010: , p5_a5 JTF_VARCHAR2_TABLE_100
1011: , p5_a6 JTF_NUMBER_TABLE
1012: , p5_a7 JTF_NUMBER_TABLE
1013: , p5_a8 JTF_NUMBER_TABLE
1014: , p5_a9 JTF_NUMBER_TABLE
1012: , p5_a7 JTF_NUMBER_TABLE
1013: , p5_a8 JTF_NUMBER_TABLE
1014: , p5_a9 JTF_NUMBER_TABLE
1015: , p5_a10 JTF_NUMBER_TABLE
1016: , p5_a11 JTF_VARCHAR2_TABLE_100
1017: , p5_a12 JTF_NUMBER_TABLE
1018: , p5_a13 JTF_NUMBER_TABLE
1019: , p5_a14 JTF_DATE_TABLE
1020: , p5_a15 JTF_NUMBER_TABLE
1023: , p5_a18 JTF_NUMBER_TABLE
1024: , p5_a19 JTF_NUMBER_TABLE
1025: , p5_a20 JTF_VARCHAR2_TABLE_2000
1026: , p5_a21 JTF_VARCHAR2_TABLE_3000
1027: , p5_a22 JTF_VARCHAR2_TABLE_100
1028: , p5_a23 JTF_VARCHAR2_TABLE_500
1029: , p5_a24 JTF_VARCHAR2_TABLE_500
1030: , p5_a25 JTF_VARCHAR2_TABLE_500
1031: , p5_a26 JTF_VARCHAR2_TABLE_500
1049: , p5_a44 JTF_DATE_TABLE
1050: , p5_a45 JTF_NUMBER_TABLE
1051: , p5_a46 JTF_DATE_TABLE
1052: , p5_a47 JTF_NUMBER_TABLE
1053: , p5_a48 JTF_VARCHAR2_TABLE_100
1054: , p5_a49 JTF_VARCHAR2_TABLE_100
1055: , p5_a50 JTF_NUMBER_TABLE
1056: , p5_a51 JTF_NUMBER_TABLE
1057: , p5_a52 JTF_VARCHAR2_TABLE_100
1050: , p5_a45 JTF_NUMBER_TABLE
1051: , p5_a46 JTF_DATE_TABLE
1052: , p5_a47 JTF_NUMBER_TABLE
1053: , p5_a48 JTF_VARCHAR2_TABLE_100
1054: , p5_a49 JTF_VARCHAR2_TABLE_100
1055: , p5_a50 JTF_NUMBER_TABLE
1056: , p5_a51 JTF_NUMBER_TABLE
1057: , p5_a52 JTF_VARCHAR2_TABLE_100
1058: , p5_a53 JTF_NUMBER_TABLE
1053: , p5_a48 JTF_VARCHAR2_TABLE_100
1054: , p5_a49 JTF_VARCHAR2_TABLE_100
1055: , p5_a50 JTF_NUMBER_TABLE
1056: , p5_a51 JTF_NUMBER_TABLE
1057: , p5_a52 JTF_VARCHAR2_TABLE_100
1058: , p5_a53 JTF_NUMBER_TABLE
1059: );
1060: end okl_tpl_pvt_w;