1: package okl_svf_pvt_w as
2: /* $Header: OKLISVFS.pls 120.1 2005/07/15 07:39:38 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package okl_svf_pvt_w as
2: /* $Header: OKLISVFS.pls 120.1 2005/07/15 07:39:38 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLISVFS.pls 120.1 2005/07/15 07:39:38 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_svf_pvt.svf_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
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_p2(t okl_svf_pvt.svf_tbl_type, 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_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_DATE_TABLE
38: , a6 out nocopy JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_svf_pvt.svf_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_DATE_TABLE
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_NUMBER_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_DATE_TABLE
38: , a6 out nocopy JTF_NUMBER_TABLE
39: , a7 out nocopy JTF_VARCHAR2_TABLE_100
40: , a8 out nocopy JTF_VARCHAR2_TABLE_500
41: , a9 out nocopy JTF_VARCHAR2_TABLE_500
42: , a10 out nocopy JTF_VARCHAR2_TABLE_500
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 rosetta_table_copy_in_p5(t out nocopy okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_100
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_VARCHAR2_TABLE_100
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
64: , a2 JTF_VARCHAR2_TABLE_100
65: , a3 JTF_VARCHAR2_TABLE_100
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_VARCHAR2_TABLE_2000
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_DATE_TABLE
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_DATE_TABLE
72: , a10 JTF_NUMBER_TABLE
66: , a4 JTF_VARCHAR2_TABLE_200
67: , a5 JTF_VARCHAR2_TABLE_2000
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_DATE_TABLE
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_DATE_TABLE
72: , a10 JTF_NUMBER_TABLE
73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
68: , a6 JTF_NUMBER_TABLE
69: , a7 JTF_DATE_TABLE
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_DATE_TABLE
72: , a10 JTF_NUMBER_TABLE
73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
70: , a8 JTF_NUMBER_TABLE
71: , a9 JTF_DATE_TABLE
72: , a10 JTF_NUMBER_TABLE
73: );
74: procedure rosetta_table_copy_out_p5(t okl_svf_pvt.okl_service_fees_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a1 out nocopy JTF_VARCHAR2_TABLE_100
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
76: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a3 out nocopy JTF_VARCHAR2_TABLE_100
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a6 out nocopy JTF_NUMBER_TABLE
81: , a7 out nocopy JTF_DATE_TABLE
82: , a8 out nocopy JTF_NUMBER_TABLE
83: , a9 out nocopy JTF_DATE_TABLE
84: , a10 out nocopy JTF_NUMBER_TABLE
78: , a4 out nocopy JTF_VARCHAR2_TABLE_200
79: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
80: , a6 out nocopy JTF_NUMBER_TABLE
81: , a7 out nocopy JTF_DATE_TABLE
82: , a8 out nocopy JTF_NUMBER_TABLE
83: , a9 out nocopy JTF_DATE_TABLE
84: , a10 out nocopy JTF_NUMBER_TABLE
85: );
86:
80: , a6 out nocopy JTF_NUMBER_TABLE
81: , a7 out nocopy JTF_DATE_TABLE
82: , a8 out nocopy JTF_NUMBER_TABLE
83: , a9 out nocopy JTF_DATE_TABLE
84: , a10 out nocopy JTF_NUMBER_TABLE
85: );
86:
87: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
83: , a9 out nocopy JTF_DATE_TABLE
84: , a10 out nocopy JTF_NUMBER_TABLE
85: );
86:
87: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_VARCHAR2_TABLE_200
84: , a10 out nocopy JTF_NUMBER_TABLE
85: );
86:
87: procedure rosetta_table_copy_in_p8(t out nocopy okl_svf_pvt.svfv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a1 JTF_NUMBER_TABLE
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_VARCHAR2_TABLE_200
92: , a5 JTF_VARCHAR2_TABLE_2000
89: , a2 JTF_VARCHAR2_TABLE_100
90: , a3 JTF_VARCHAR2_TABLE_100
91: , a4 JTF_VARCHAR2_TABLE_200
92: , a5 JTF_VARCHAR2_TABLE_2000
93: , a6 JTF_NUMBER_TABLE
94: , a7 JTF_DATE_TABLE
95: , a8 JTF_DATE_TABLE
96: , a9 JTF_NUMBER_TABLE
97: , a10 JTF_VARCHAR2_TABLE_100
92: , a5 JTF_VARCHAR2_TABLE_2000
93: , a6 JTF_NUMBER_TABLE
94: , a7 JTF_DATE_TABLE
95: , a8 JTF_DATE_TABLE
96: , a9 JTF_NUMBER_TABLE
97: , a10 JTF_VARCHAR2_TABLE_100
98: , a11 JTF_VARCHAR2_TABLE_500
99: , a12 JTF_VARCHAR2_TABLE_500
100: , a13 JTF_VARCHAR2_TABLE_500
109: , a22 JTF_VARCHAR2_TABLE_500
110: , a23 JTF_VARCHAR2_TABLE_500
111: , a24 JTF_VARCHAR2_TABLE_500
112: , a25 JTF_VARCHAR2_TABLE_500
113: , a26 JTF_NUMBER_TABLE
114: , a27 JTF_DATE_TABLE
115: , a28 JTF_NUMBER_TABLE
116: , a29 JTF_DATE_TABLE
117: , a30 JTF_NUMBER_TABLE
111: , a24 JTF_VARCHAR2_TABLE_500
112: , a25 JTF_VARCHAR2_TABLE_500
113: , a26 JTF_NUMBER_TABLE
114: , a27 JTF_DATE_TABLE
115: , a28 JTF_NUMBER_TABLE
116: , a29 JTF_DATE_TABLE
117: , a30 JTF_NUMBER_TABLE
118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a26 JTF_NUMBER_TABLE
114: , a27 JTF_DATE_TABLE
115: , a28 JTF_NUMBER_TABLE
116: , a29 JTF_DATE_TABLE
117: , a30 JTF_NUMBER_TABLE
118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
115: , a28 JTF_NUMBER_TABLE
116: , a29 JTF_DATE_TABLE
117: , a30 JTF_NUMBER_TABLE
118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_200
116: , a29 JTF_DATE_TABLE
117: , a30 JTF_NUMBER_TABLE
118: );
119: procedure rosetta_table_copy_out_p8(t okl_svf_pvt.svfv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
120: , a1 out nocopy JTF_NUMBER_TABLE
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_200
124: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
121: , a2 out nocopy JTF_VARCHAR2_TABLE_100
122: , a3 out nocopy JTF_VARCHAR2_TABLE_100
123: , a4 out nocopy JTF_VARCHAR2_TABLE_200
124: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_DATE_TABLE
127: , a8 out nocopy JTF_DATE_TABLE
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
124: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
125: , a6 out nocopy JTF_NUMBER_TABLE
126: , a7 out nocopy JTF_DATE_TABLE
127: , a8 out nocopy JTF_DATE_TABLE
128: , a9 out nocopy JTF_NUMBER_TABLE
129: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a11 out nocopy JTF_VARCHAR2_TABLE_500
131: , a12 out nocopy JTF_VARCHAR2_TABLE_500
132: , a13 out nocopy JTF_VARCHAR2_TABLE_500
141: , a22 out nocopy JTF_VARCHAR2_TABLE_500
142: , a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_DATE_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
143: , a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_DATE_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: );
151:
145: , a26 out nocopy JTF_NUMBER_TABLE
146: , a27 out nocopy JTF_DATE_TABLE
147: , a28 out nocopy JTF_NUMBER_TABLE
148: , a29 out nocopy JTF_DATE_TABLE
149: , a30 out nocopy JTF_NUMBER_TABLE
150: );
151:
152: procedure insert_row(p_api_version NUMBER
153: , p_init_msg_list VARCHAR2
221: , p_init_msg_list VARCHAR2
222: , x_return_status out nocopy VARCHAR2
223: , x_msg_count out nocopy NUMBER
224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_100
229: , p5_a4 JTF_VARCHAR2_TABLE_200
222: , x_return_status out nocopy VARCHAR2
223: , x_msg_count out nocopy NUMBER
224: , x_msg_data out nocopy VARCHAR2
225: , p5_a0 JTF_NUMBER_TABLE
226: , p5_a1 JTF_NUMBER_TABLE
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_100
229: , p5_a4 JTF_VARCHAR2_TABLE_200
230: , p5_a5 JTF_VARCHAR2_TABLE_2000
227: , p5_a2 JTF_VARCHAR2_TABLE_100
228: , p5_a3 JTF_VARCHAR2_TABLE_100
229: , p5_a4 JTF_VARCHAR2_TABLE_200
230: , p5_a5 JTF_VARCHAR2_TABLE_2000
231: , p5_a6 JTF_NUMBER_TABLE
232: , p5_a7 JTF_DATE_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE
235: , p5_a10 JTF_VARCHAR2_TABLE_100
230: , p5_a5 JTF_VARCHAR2_TABLE_2000
231: , p5_a6 JTF_NUMBER_TABLE
232: , p5_a7 JTF_DATE_TABLE
233: , p5_a8 JTF_DATE_TABLE
234: , p5_a9 JTF_NUMBER_TABLE
235: , p5_a10 JTF_VARCHAR2_TABLE_100
236: , p5_a11 JTF_VARCHAR2_TABLE_500
237: , p5_a12 JTF_VARCHAR2_TABLE_500
238: , p5_a13 JTF_VARCHAR2_TABLE_500
247: , p5_a22 JTF_VARCHAR2_TABLE_500
248: , p5_a23 JTF_VARCHAR2_TABLE_500
249: , p5_a24 JTF_VARCHAR2_TABLE_500
250: , p5_a25 JTF_VARCHAR2_TABLE_500
251: , p5_a26 JTF_NUMBER_TABLE
252: , p5_a27 JTF_DATE_TABLE
253: , p5_a28 JTF_NUMBER_TABLE
254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a24 JTF_VARCHAR2_TABLE_500
250: , p5_a25 JTF_VARCHAR2_TABLE_500
251: , p5_a26 JTF_NUMBER_TABLE
252: , p5_a27 JTF_DATE_TABLE
253: , p5_a28 JTF_NUMBER_TABLE
254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
251: , p5_a26 JTF_NUMBER_TABLE
252: , p5_a27 JTF_DATE_TABLE
253: , p5_a28 JTF_NUMBER_TABLE
254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
252: , p5_a27 JTF_DATE_TABLE
253: , p5_a28 JTF_NUMBER_TABLE
254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
253: , p5_a28 JTF_NUMBER_TABLE
254: , p5_a29 JTF_DATE_TABLE
255: , p5_a30 JTF_NUMBER_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
262: , p6_a6 out nocopy JTF_NUMBER_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_DATE_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
262: , p6_a6 out nocopy JTF_NUMBER_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_DATE_TABLE
265: , p6_a9 out nocopy JTF_NUMBER_TABLE
266: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
278: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
279: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
280: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a26 out nocopy JTF_NUMBER_TABLE
283: , p6_a27 out nocopy JTF_DATE_TABLE
284: , p6_a28 out nocopy JTF_NUMBER_TABLE
285: , p6_a29 out nocopy JTF_DATE_TABLE
286: , p6_a30 out nocopy JTF_NUMBER_TABLE
280: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a26 out nocopy JTF_NUMBER_TABLE
283: , p6_a27 out nocopy JTF_DATE_TABLE
284: , p6_a28 out nocopy JTF_NUMBER_TABLE
285: , p6_a29 out nocopy JTF_DATE_TABLE
286: , p6_a30 out nocopy JTF_NUMBER_TABLE
287: );
288: procedure lock_row(p_api_version NUMBER
282: , p6_a26 out nocopy JTF_NUMBER_TABLE
283: , p6_a27 out nocopy JTF_DATE_TABLE
284: , p6_a28 out nocopy JTF_NUMBER_TABLE
285: , p6_a29 out nocopy JTF_DATE_TABLE
286: , p6_a30 out nocopy JTF_NUMBER_TABLE
287: );
288: procedure lock_row(p_api_version NUMBER
289: , p_init_msg_list VARCHAR2
290: , x_return_status out nocopy VARCHAR2
326: , p_init_msg_list VARCHAR2
327: , x_return_status out nocopy VARCHAR2
328: , x_msg_count out nocopy NUMBER
329: , x_msg_data out nocopy VARCHAR2
330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_VARCHAR2_TABLE_100
334: , p5_a4 JTF_VARCHAR2_TABLE_200
327: , x_return_status out nocopy VARCHAR2
328: , x_msg_count out nocopy NUMBER
329: , x_msg_data out nocopy VARCHAR2
330: , p5_a0 JTF_NUMBER_TABLE
331: , p5_a1 JTF_NUMBER_TABLE
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_VARCHAR2_TABLE_100
334: , p5_a4 JTF_VARCHAR2_TABLE_200
335: , p5_a5 JTF_VARCHAR2_TABLE_2000
332: , p5_a2 JTF_VARCHAR2_TABLE_100
333: , p5_a3 JTF_VARCHAR2_TABLE_100
334: , p5_a4 JTF_VARCHAR2_TABLE_200
335: , p5_a5 JTF_VARCHAR2_TABLE_2000
336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_DATE_TABLE
338: , p5_a8 JTF_DATE_TABLE
339: , p5_a9 JTF_NUMBER_TABLE
340: , p5_a10 JTF_VARCHAR2_TABLE_100
335: , p5_a5 JTF_VARCHAR2_TABLE_2000
336: , p5_a6 JTF_NUMBER_TABLE
337: , p5_a7 JTF_DATE_TABLE
338: , p5_a8 JTF_DATE_TABLE
339: , p5_a9 JTF_NUMBER_TABLE
340: , p5_a10 JTF_VARCHAR2_TABLE_100
341: , p5_a11 JTF_VARCHAR2_TABLE_500
342: , p5_a12 JTF_VARCHAR2_TABLE_500
343: , p5_a13 JTF_VARCHAR2_TABLE_500
352: , p5_a22 JTF_VARCHAR2_TABLE_500
353: , p5_a23 JTF_VARCHAR2_TABLE_500
354: , p5_a24 JTF_VARCHAR2_TABLE_500
355: , p5_a25 JTF_VARCHAR2_TABLE_500
356: , p5_a26 JTF_NUMBER_TABLE
357: , p5_a27 JTF_DATE_TABLE
358: , p5_a28 JTF_NUMBER_TABLE
359: , p5_a29 JTF_DATE_TABLE
360: , p5_a30 JTF_NUMBER_TABLE
354: , p5_a24 JTF_VARCHAR2_TABLE_500
355: , p5_a25 JTF_VARCHAR2_TABLE_500
356: , p5_a26 JTF_NUMBER_TABLE
357: , p5_a27 JTF_DATE_TABLE
358: , p5_a28 JTF_NUMBER_TABLE
359: , p5_a29 JTF_DATE_TABLE
360: , p5_a30 JTF_NUMBER_TABLE
361: );
362: procedure update_row(p_api_version NUMBER
356: , p5_a26 JTF_NUMBER_TABLE
357: , p5_a27 JTF_DATE_TABLE
358: , p5_a28 JTF_NUMBER_TABLE
359: , p5_a29 JTF_DATE_TABLE
360: , p5_a30 JTF_NUMBER_TABLE
361: );
362: procedure update_row(p_api_version NUMBER
363: , p_init_msg_list VARCHAR2
364: , x_return_status out nocopy VARCHAR2
431: , p_init_msg_list VARCHAR2
432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_100
438: , p5_a3 JTF_VARCHAR2_TABLE_100
439: , p5_a4 JTF_VARCHAR2_TABLE_200
432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_100
438: , p5_a3 JTF_VARCHAR2_TABLE_100
439: , p5_a4 JTF_VARCHAR2_TABLE_200
440: , p5_a5 JTF_VARCHAR2_TABLE_2000
437: , p5_a2 JTF_VARCHAR2_TABLE_100
438: , p5_a3 JTF_VARCHAR2_TABLE_100
439: , p5_a4 JTF_VARCHAR2_TABLE_200
440: , p5_a5 JTF_VARCHAR2_TABLE_2000
441: , p5_a6 JTF_NUMBER_TABLE
442: , p5_a7 JTF_DATE_TABLE
443: , p5_a8 JTF_DATE_TABLE
444: , p5_a9 JTF_NUMBER_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
440: , p5_a5 JTF_VARCHAR2_TABLE_2000
441: , p5_a6 JTF_NUMBER_TABLE
442: , p5_a7 JTF_DATE_TABLE
443: , p5_a8 JTF_DATE_TABLE
444: , p5_a9 JTF_NUMBER_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
446: , p5_a11 JTF_VARCHAR2_TABLE_500
447: , p5_a12 JTF_VARCHAR2_TABLE_500
448: , p5_a13 JTF_VARCHAR2_TABLE_500
457: , p5_a22 JTF_VARCHAR2_TABLE_500
458: , p5_a23 JTF_VARCHAR2_TABLE_500
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_DATE_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_DATE_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_DATE_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
462: , p5_a27 JTF_DATE_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p6_a0 out nocopy JTF_NUMBER_TABLE
467: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
468: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
470: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
471: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
472: , p6_a6 out nocopy JTF_NUMBER_TABLE
473: , p6_a7 out nocopy JTF_DATE_TABLE
474: , p6_a8 out nocopy JTF_DATE_TABLE
475: , p6_a9 out nocopy JTF_NUMBER_TABLE
476: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
471: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
472: , p6_a6 out nocopy JTF_NUMBER_TABLE
473: , p6_a7 out nocopy JTF_DATE_TABLE
474: , p6_a8 out nocopy JTF_DATE_TABLE
475: , p6_a9 out nocopy JTF_NUMBER_TABLE
476: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
477: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
478: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
479: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
488: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
489: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
490: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
491: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
492: , p6_a26 out nocopy JTF_NUMBER_TABLE
493: , p6_a27 out nocopy JTF_DATE_TABLE
494: , p6_a28 out nocopy JTF_NUMBER_TABLE
495: , p6_a29 out nocopy JTF_DATE_TABLE
496: , p6_a30 out nocopy JTF_NUMBER_TABLE
490: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
491: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
492: , p6_a26 out nocopy JTF_NUMBER_TABLE
493: , p6_a27 out nocopy JTF_DATE_TABLE
494: , p6_a28 out nocopy JTF_NUMBER_TABLE
495: , p6_a29 out nocopy JTF_DATE_TABLE
496: , p6_a30 out nocopy JTF_NUMBER_TABLE
497: );
498: procedure delete_row(p_api_version NUMBER
492: , p6_a26 out nocopy JTF_NUMBER_TABLE
493: , p6_a27 out nocopy JTF_DATE_TABLE
494: , p6_a28 out nocopy JTF_NUMBER_TABLE
495: , p6_a29 out nocopy JTF_DATE_TABLE
496: , p6_a30 out nocopy JTF_NUMBER_TABLE
497: );
498: procedure delete_row(p_api_version NUMBER
499: , p_init_msg_list VARCHAR2
500: , x_return_status out nocopy VARCHAR2
536: , p_init_msg_list VARCHAR2
537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_VARCHAR2_TABLE_100
543: , p5_a3 JTF_VARCHAR2_TABLE_100
544: , p5_a4 JTF_VARCHAR2_TABLE_200
537: , x_return_status out nocopy VARCHAR2
538: , x_msg_count out nocopy NUMBER
539: , x_msg_data out nocopy VARCHAR2
540: , p5_a0 JTF_NUMBER_TABLE
541: , p5_a1 JTF_NUMBER_TABLE
542: , p5_a2 JTF_VARCHAR2_TABLE_100
543: , p5_a3 JTF_VARCHAR2_TABLE_100
544: , p5_a4 JTF_VARCHAR2_TABLE_200
545: , p5_a5 JTF_VARCHAR2_TABLE_2000
542: , p5_a2 JTF_VARCHAR2_TABLE_100
543: , p5_a3 JTF_VARCHAR2_TABLE_100
544: , p5_a4 JTF_VARCHAR2_TABLE_200
545: , p5_a5 JTF_VARCHAR2_TABLE_2000
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_DATE_TABLE
548: , p5_a8 JTF_DATE_TABLE
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_VARCHAR2_TABLE_100
545: , p5_a5 JTF_VARCHAR2_TABLE_2000
546: , p5_a6 JTF_NUMBER_TABLE
547: , p5_a7 JTF_DATE_TABLE
548: , p5_a8 JTF_DATE_TABLE
549: , p5_a9 JTF_NUMBER_TABLE
550: , p5_a10 JTF_VARCHAR2_TABLE_100
551: , p5_a11 JTF_VARCHAR2_TABLE_500
552: , p5_a12 JTF_VARCHAR2_TABLE_500
553: , p5_a13 JTF_VARCHAR2_TABLE_500
562: , p5_a22 JTF_VARCHAR2_TABLE_500
563: , p5_a23 JTF_VARCHAR2_TABLE_500
564: , p5_a24 JTF_VARCHAR2_TABLE_500
565: , p5_a25 JTF_VARCHAR2_TABLE_500
566: , p5_a26 JTF_NUMBER_TABLE
567: , p5_a27 JTF_DATE_TABLE
568: , p5_a28 JTF_NUMBER_TABLE
569: , p5_a29 JTF_DATE_TABLE
570: , p5_a30 JTF_NUMBER_TABLE
564: , p5_a24 JTF_VARCHAR2_TABLE_500
565: , p5_a25 JTF_VARCHAR2_TABLE_500
566: , p5_a26 JTF_NUMBER_TABLE
567: , p5_a27 JTF_DATE_TABLE
568: , p5_a28 JTF_NUMBER_TABLE
569: , p5_a29 JTF_DATE_TABLE
570: , p5_a30 JTF_NUMBER_TABLE
571: );
572: procedure validate_row(p_api_version NUMBER
566: , p5_a26 JTF_NUMBER_TABLE
567: , p5_a27 JTF_DATE_TABLE
568: , p5_a28 JTF_NUMBER_TABLE
569: , p5_a29 JTF_DATE_TABLE
570: , p5_a30 JTF_NUMBER_TABLE
571: );
572: procedure validate_row(p_api_version NUMBER
573: , p_init_msg_list VARCHAR2
574: , x_return_status out nocopy VARCHAR2
610: , p_init_msg_list VARCHAR2
611: , x_return_status out nocopy VARCHAR2
612: , x_msg_count out nocopy NUMBER
613: , x_msg_data out nocopy VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_VARCHAR2_TABLE_100
618: , p5_a4 JTF_VARCHAR2_TABLE_200
611: , x_return_status out nocopy VARCHAR2
612: , x_msg_count out nocopy NUMBER
613: , x_msg_data out nocopy VARCHAR2
614: , p5_a0 JTF_NUMBER_TABLE
615: , p5_a1 JTF_NUMBER_TABLE
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_VARCHAR2_TABLE_100
618: , p5_a4 JTF_VARCHAR2_TABLE_200
619: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , p5_a2 JTF_VARCHAR2_TABLE_100
617: , p5_a3 JTF_VARCHAR2_TABLE_100
618: , p5_a4 JTF_VARCHAR2_TABLE_200
619: , p5_a5 JTF_VARCHAR2_TABLE_2000
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_DATE_TABLE
622: , p5_a8 JTF_DATE_TABLE
623: , p5_a9 JTF_NUMBER_TABLE
624: , p5_a10 JTF_VARCHAR2_TABLE_100
619: , p5_a5 JTF_VARCHAR2_TABLE_2000
620: , p5_a6 JTF_NUMBER_TABLE
621: , p5_a7 JTF_DATE_TABLE
622: , p5_a8 JTF_DATE_TABLE
623: , p5_a9 JTF_NUMBER_TABLE
624: , p5_a10 JTF_VARCHAR2_TABLE_100
625: , p5_a11 JTF_VARCHAR2_TABLE_500
626: , p5_a12 JTF_VARCHAR2_TABLE_500
627: , p5_a13 JTF_VARCHAR2_TABLE_500
636: , p5_a22 JTF_VARCHAR2_TABLE_500
637: , p5_a23 JTF_VARCHAR2_TABLE_500
638: , p5_a24 JTF_VARCHAR2_TABLE_500
639: , p5_a25 JTF_VARCHAR2_TABLE_500
640: , p5_a26 JTF_NUMBER_TABLE
641: , p5_a27 JTF_DATE_TABLE
642: , p5_a28 JTF_NUMBER_TABLE
643: , p5_a29 JTF_DATE_TABLE
644: , p5_a30 JTF_NUMBER_TABLE
638: , p5_a24 JTF_VARCHAR2_TABLE_500
639: , p5_a25 JTF_VARCHAR2_TABLE_500
640: , p5_a26 JTF_NUMBER_TABLE
641: , p5_a27 JTF_DATE_TABLE
642: , p5_a28 JTF_NUMBER_TABLE
643: , p5_a29 JTF_DATE_TABLE
644: , p5_a30 JTF_NUMBER_TABLE
645: );
646: end okl_svf_pvt_w;
640: , p5_a26 JTF_NUMBER_TABLE
641: , p5_a27 JTF_DATE_TABLE
642: , p5_a28 JTF_NUMBER_TABLE
643: , p5_a29 JTF_DATE_TABLE
644: , p5_a30 JTF_NUMBER_TABLE
645: );
646: end okl_svf_pvt_w;