1: package okl_fma_pvt_w as
2: /* $Header: OKLIFMAS.pls 120.1 2005/07/12 07:05:11 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_fma_pvt_w as
2: /* $Header: OKLIFMAS.pls 120.1 2005/07/12 07:05:11 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_fma_pvt.fma_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_200
38: , a2 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_200
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_200
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
36: procedure rosetta_table_copy_out_p2(t okl_fma_pvt.fma_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_200
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
44: , a8 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
44: , a8 out nocopy JTF_NUMBER_TABLE
45: , a9 out nocopy JTF_DATE_TABLE
46: , a10 out nocopy JTF_VARCHAR2_TABLE_100
47: , a11 out nocopy JTF_DATE_TABLE
48: , a12 out nocopy JTF_VARCHAR2_TABLE_500
59: , a23 out nocopy JTF_VARCHAR2_TABLE_500
60: , a24 out nocopy JTF_VARCHAR2_TABLE_500
61: , a25 out nocopy JTF_VARCHAR2_TABLE_500
62: , a26 out nocopy JTF_VARCHAR2_TABLE_500
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
61: , a25 out nocopy JTF_VARCHAR2_TABLE_500
62: , a26 out nocopy JTF_VARCHAR2_TABLE_500
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_fma_pvt.okl_formulae_tl_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_fma_pvt.okl_formulae_tl_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_100
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_VARCHAR2_TABLE_2000
71: , a1 JTF_VARCHAR2_TABLE_100
72: , a2 JTF_VARCHAR2_TABLE_100
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_VARCHAR2_TABLE_2000
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_NUMBER_TABLE
78: , a8 JTF_DATE_TABLE
79: , a9 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_VARCHAR2_TABLE_2000
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_NUMBER_TABLE
78: , a8 JTF_DATE_TABLE
79: , a9 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
75: , a5 JTF_NUMBER_TABLE
76: , a6 JTF_DATE_TABLE
77: , a7 JTF_NUMBER_TABLE
78: , a8 JTF_DATE_TABLE
79: , a9 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_100
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
77: , a7 JTF_NUMBER_TABLE
78: , a8 JTF_DATE_TABLE
79: , a9 JTF_NUMBER_TABLE
80: );
81: procedure rosetta_table_copy_out_p5(t okl_fma_pvt.okl_formulae_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a1 out nocopy JTF_VARCHAR2_TABLE_100
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
82: , a1 out nocopy JTF_VARCHAR2_TABLE_100
83: , a2 out nocopy JTF_VARCHAR2_TABLE_100
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_DATE_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_NUMBER_TABLE
84: , a3 out nocopy JTF_VARCHAR2_TABLE_100
85: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_DATE_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_NUMBER_TABLE
91: );
92:
86: , a5 out nocopy JTF_NUMBER_TABLE
87: , a6 out nocopy JTF_DATE_TABLE
88: , a7 out nocopy JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
89: , a8 out nocopy JTF_DATE_TABLE
90: , a9 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_NUMBER_TABLE
97: , a4 JTF_VARCHAR2_TABLE_100
90: , a9 out nocopy JTF_NUMBER_TABLE
91: );
92:
93: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_NUMBER_TABLE
97: , a4 JTF_VARCHAR2_TABLE_100
98: , a5 JTF_VARCHAR2_TABLE_200
92:
93: procedure rosetta_table_copy_in_p8(t out nocopy okl_fma_pvt.fmav_tbl_type, a0 JTF_NUMBER_TABLE
94: , a1 JTF_NUMBER_TABLE
95: , a2 JTF_VARCHAR2_TABLE_100
96: , a3 JTF_NUMBER_TABLE
97: , a4 JTF_VARCHAR2_TABLE_100
98: , a5 JTF_VARCHAR2_TABLE_200
99: , a6 JTF_VARCHAR2_TABLE_2000
100: , a7 JTF_VARCHAR2_TABLE_2000
116: , a23 JTF_VARCHAR2_TABLE_500
117: , a24 JTF_VARCHAR2_TABLE_500
118: , a25 JTF_VARCHAR2_TABLE_500
119: , a26 JTF_VARCHAR2_TABLE_500
120: , a27 JTF_NUMBER_TABLE
121: , a28 JTF_VARCHAR2_TABLE_100
122: , a29 JTF_NUMBER_TABLE
123: , a30 JTF_DATE_TABLE
124: , a31 JTF_NUMBER_TABLE
118: , a25 JTF_VARCHAR2_TABLE_500
119: , a26 JTF_VARCHAR2_TABLE_500
120: , a27 JTF_NUMBER_TABLE
121: , a28 JTF_VARCHAR2_TABLE_100
122: , a29 JTF_NUMBER_TABLE
123: , a30 JTF_DATE_TABLE
124: , a31 JTF_NUMBER_TABLE
125: , a32 JTF_DATE_TABLE
126: , a33 JTF_NUMBER_TABLE
120: , a27 JTF_NUMBER_TABLE
121: , a28 JTF_VARCHAR2_TABLE_100
122: , a29 JTF_NUMBER_TABLE
123: , a30 JTF_DATE_TABLE
124: , a31 JTF_NUMBER_TABLE
125: , a32 JTF_DATE_TABLE
126: , a33 JTF_NUMBER_TABLE
127: );
128: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
122: , a29 JTF_NUMBER_TABLE
123: , a30 JTF_DATE_TABLE
124: , a31 JTF_NUMBER_TABLE
125: , a32 JTF_DATE_TABLE
126: , a33 JTF_NUMBER_TABLE
127: );
128: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_NUMBER_TABLE
130: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a31 JTF_NUMBER_TABLE
125: , a32 JTF_DATE_TABLE
126: , a33 JTF_NUMBER_TABLE
127: );
128: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_NUMBER_TABLE
130: , a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , a3 out nocopy JTF_NUMBER_TABLE
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
125: , a32 JTF_DATE_TABLE
126: , a33 JTF_NUMBER_TABLE
127: );
128: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_NUMBER_TABLE
130: , a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , a3 out nocopy JTF_NUMBER_TABLE
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , a5 out nocopy JTF_VARCHAR2_TABLE_200
127: );
128: procedure rosetta_table_copy_out_p8(t okl_fma_pvt.fmav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
129: , a1 out nocopy JTF_NUMBER_TABLE
130: , a2 out nocopy JTF_VARCHAR2_TABLE_100
131: , a3 out nocopy JTF_NUMBER_TABLE
132: , a4 out nocopy JTF_VARCHAR2_TABLE_100
133: , a5 out nocopy JTF_VARCHAR2_TABLE_200
134: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
135: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
151: , a23 out nocopy JTF_VARCHAR2_TABLE_500
152: , a24 out nocopy JTF_VARCHAR2_TABLE_500
153: , a25 out nocopy JTF_VARCHAR2_TABLE_500
154: , a26 out nocopy JTF_VARCHAR2_TABLE_500
155: , a27 out nocopy JTF_NUMBER_TABLE
156: , a28 out nocopy JTF_VARCHAR2_TABLE_100
157: , a29 out nocopy JTF_NUMBER_TABLE
158: , a30 out nocopy JTF_DATE_TABLE
159: , a31 out nocopy JTF_NUMBER_TABLE
153: , a25 out nocopy JTF_VARCHAR2_TABLE_500
154: , a26 out nocopy JTF_VARCHAR2_TABLE_500
155: , a27 out nocopy JTF_NUMBER_TABLE
156: , a28 out nocopy JTF_VARCHAR2_TABLE_100
157: , a29 out nocopy JTF_NUMBER_TABLE
158: , a30 out nocopy JTF_DATE_TABLE
159: , a31 out nocopy JTF_NUMBER_TABLE
160: , a32 out nocopy JTF_DATE_TABLE
161: , a33 out nocopy JTF_NUMBER_TABLE
155: , a27 out nocopy JTF_NUMBER_TABLE
156: , a28 out nocopy JTF_VARCHAR2_TABLE_100
157: , a29 out nocopy JTF_NUMBER_TABLE
158: , a30 out nocopy JTF_DATE_TABLE
159: , a31 out nocopy JTF_NUMBER_TABLE
160: , a32 out nocopy JTF_DATE_TABLE
161: , a33 out nocopy JTF_NUMBER_TABLE
162: );
163:
157: , a29 out nocopy JTF_NUMBER_TABLE
158: , a30 out nocopy JTF_DATE_TABLE
159: , a31 out nocopy JTF_NUMBER_TABLE
160: , a32 out nocopy JTF_DATE_TABLE
161: , a33 out nocopy JTF_NUMBER_TABLE
162: );
163:
164: procedure insert_row(p_api_version NUMBER
165: , p_init_msg_list VARCHAR2
239: , p_init_msg_list VARCHAR2
240: , x_return_status out nocopy VARCHAR2
241: , x_msg_count out nocopy NUMBER
242: , x_msg_data out nocopy VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
240: , x_return_status out nocopy VARCHAR2
241: , x_msg_count out nocopy NUMBER
242: , x_msg_data out nocopy VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_VARCHAR2_TABLE_200
242: , x_msg_data out nocopy VARCHAR2
243: , p5_a0 JTF_NUMBER_TABLE
244: , p5_a1 JTF_NUMBER_TABLE
245: , p5_a2 JTF_VARCHAR2_TABLE_100
246: , p5_a3 JTF_NUMBER_TABLE
247: , p5_a4 JTF_VARCHAR2_TABLE_100
248: , p5_a5 JTF_VARCHAR2_TABLE_200
249: , p5_a6 JTF_VARCHAR2_TABLE_2000
250: , p5_a7 JTF_VARCHAR2_TABLE_2000
266: , p5_a23 JTF_VARCHAR2_TABLE_500
267: , p5_a24 JTF_VARCHAR2_TABLE_500
268: , p5_a25 JTF_VARCHAR2_TABLE_500
269: , p5_a26 JTF_VARCHAR2_TABLE_500
270: , p5_a27 JTF_NUMBER_TABLE
271: , p5_a28 JTF_VARCHAR2_TABLE_100
272: , p5_a29 JTF_NUMBER_TABLE
273: , p5_a30 JTF_DATE_TABLE
274: , p5_a31 JTF_NUMBER_TABLE
268: , p5_a25 JTF_VARCHAR2_TABLE_500
269: , p5_a26 JTF_VARCHAR2_TABLE_500
270: , p5_a27 JTF_NUMBER_TABLE
271: , p5_a28 JTF_VARCHAR2_TABLE_100
272: , p5_a29 JTF_NUMBER_TABLE
273: , p5_a30 JTF_DATE_TABLE
274: , p5_a31 JTF_NUMBER_TABLE
275: , p5_a32 JTF_DATE_TABLE
276: , p5_a33 JTF_NUMBER_TABLE
270: , p5_a27 JTF_NUMBER_TABLE
271: , p5_a28 JTF_VARCHAR2_TABLE_100
272: , p5_a29 JTF_NUMBER_TABLE
273: , p5_a30 JTF_DATE_TABLE
274: , p5_a31 JTF_NUMBER_TABLE
275: , p5_a32 JTF_DATE_TABLE
276: , p5_a33 JTF_NUMBER_TABLE
277: , p6_a0 out nocopy JTF_NUMBER_TABLE
278: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p5_a29 JTF_NUMBER_TABLE
273: , p5_a30 JTF_DATE_TABLE
274: , p5_a31 JTF_NUMBER_TABLE
275: , p5_a32 JTF_DATE_TABLE
276: , p5_a33 JTF_NUMBER_TABLE
277: , p6_a0 out nocopy JTF_NUMBER_TABLE
278: , p6_a1 out nocopy JTF_NUMBER_TABLE
279: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a3 out nocopy JTF_NUMBER_TABLE
273: , p5_a30 JTF_DATE_TABLE
274: , p5_a31 JTF_NUMBER_TABLE
275: , p5_a32 JTF_DATE_TABLE
276: , p5_a33 JTF_NUMBER_TABLE
277: , p6_a0 out nocopy JTF_NUMBER_TABLE
278: , p6_a1 out nocopy JTF_NUMBER_TABLE
279: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a3 out nocopy JTF_NUMBER_TABLE
281: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
274: , p5_a31 JTF_NUMBER_TABLE
275: , p5_a32 JTF_DATE_TABLE
276: , p5_a33 JTF_NUMBER_TABLE
277: , p6_a0 out nocopy JTF_NUMBER_TABLE
278: , p6_a1 out nocopy JTF_NUMBER_TABLE
279: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a3 out nocopy JTF_NUMBER_TABLE
281: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
276: , p5_a33 JTF_NUMBER_TABLE
277: , p6_a0 out nocopy JTF_NUMBER_TABLE
278: , p6_a1 out nocopy JTF_NUMBER_TABLE
279: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a3 out nocopy JTF_NUMBER_TABLE
281: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
283: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
284: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
300: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
301: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
302: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a27 out nocopy JTF_NUMBER_TABLE
305: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a29 out nocopy JTF_NUMBER_TABLE
307: , p6_a30 out nocopy JTF_DATE_TABLE
308: , p6_a31 out nocopy JTF_NUMBER_TABLE
302: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
303: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
304: , p6_a27 out nocopy JTF_NUMBER_TABLE
305: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a29 out nocopy JTF_NUMBER_TABLE
307: , p6_a30 out nocopy JTF_DATE_TABLE
308: , p6_a31 out nocopy JTF_NUMBER_TABLE
309: , p6_a32 out nocopy JTF_DATE_TABLE
310: , p6_a33 out nocopy JTF_NUMBER_TABLE
304: , p6_a27 out nocopy JTF_NUMBER_TABLE
305: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a29 out nocopy JTF_NUMBER_TABLE
307: , p6_a30 out nocopy JTF_DATE_TABLE
308: , p6_a31 out nocopy JTF_NUMBER_TABLE
309: , p6_a32 out nocopy JTF_DATE_TABLE
310: , p6_a33 out nocopy JTF_NUMBER_TABLE
311: );
312: procedure lock_row(p_api_version NUMBER
306: , p6_a29 out nocopy JTF_NUMBER_TABLE
307: , p6_a30 out nocopy JTF_DATE_TABLE
308: , p6_a31 out nocopy JTF_NUMBER_TABLE
309: , p6_a32 out nocopy JTF_DATE_TABLE
310: , p6_a33 out nocopy JTF_NUMBER_TABLE
311: );
312: procedure lock_row(p_api_version NUMBER
313: , p_init_msg_list VARCHAR2
314: , x_return_status out nocopy VARCHAR2
353: , p_init_msg_list VARCHAR2
354: , x_return_status out nocopy VARCHAR2
355: , x_msg_count out nocopy NUMBER
356: , x_msg_data out nocopy VARCHAR2
357: , p5_a0 JTF_NUMBER_TABLE
358: , p5_a1 JTF_NUMBER_TABLE
359: , p5_a2 JTF_VARCHAR2_TABLE_100
360: , p5_a3 JTF_NUMBER_TABLE
361: , p5_a4 JTF_VARCHAR2_TABLE_100
354: , x_return_status out nocopy VARCHAR2
355: , x_msg_count out nocopy NUMBER
356: , x_msg_data out nocopy VARCHAR2
357: , p5_a0 JTF_NUMBER_TABLE
358: , p5_a1 JTF_NUMBER_TABLE
359: , p5_a2 JTF_VARCHAR2_TABLE_100
360: , p5_a3 JTF_NUMBER_TABLE
361: , p5_a4 JTF_VARCHAR2_TABLE_100
362: , p5_a5 JTF_VARCHAR2_TABLE_200
356: , x_msg_data out nocopy VARCHAR2
357: , p5_a0 JTF_NUMBER_TABLE
358: , p5_a1 JTF_NUMBER_TABLE
359: , p5_a2 JTF_VARCHAR2_TABLE_100
360: , p5_a3 JTF_NUMBER_TABLE
361: , p5_a4 JTF_VARCHAR2_TABLE_100
362: , p5_a5 JTF_VARCHAR2_TABLE_200
363: , p5_a6 JTF_VARCHAR2_TABLE_2000
364: , p5_a7 JTF_VARCHAR2_TABLE_2000
380: , p5_a23 JTF_VARCHAR2_TABLE_500
381: , p5_a24 JTF_VARCHAR2_TABLE_500
382: , p5_a25 JTF_VARCHAR2_TABLE_500
383: , p5_a26 JTF_VARCHAR2_TABLE_500
384: , p5_a27 JTF_NUMBER_TABLE
385: , p5_a28 JTF_VARCHAR2_TABLE_100
386: , p5_a29 JTF_NUMBER_TABLE
387: , p5_a30 JTF_DATE_TABLE
388: , p5_a31 JTF_NUMBER_TABLE
382: , p5_a25 JTF_VARCHAR2_TABLE_500
383: , p5_a26 JTF_VARCHAR2_TABLE_500
384: , p5_a27 JTF_NUMBER_TABLE
385: , p5_a28 JTF_VARCHAR2_TABLE_100
386: , p5_a29 JTF_NUMBER_TABLE
387: , p5_a30 JTF_DATE_TABLE
388: , p5_a31 JTF_NUMBER_TABLE
389: , p5_a32 JTF_DATE_TABLE
390: , p5_a33 JTF_NUMBER_TABLE
384: , p5_a27 JTF_NUMBER_TABLE
385: , p5_a28 JTF_VARCHAR2_TABLE_100
386: , p5_a29 JTF_NUMBER_TABLE
387: , p5_a30 JTF_DATE_TABLE
388: , p5_a31 JTF_NUMBER_TABLE
389: , p5_a32 JTF_DATE_TABLE
390: , p5_a33 JTF_NUMBER_TABLE
391: );
392: procedure update_row(p_api_version NUMBER
386: , p5_a29 JTF_NUMBER_TABLE
387: , p5_a30 JTF_DATE_TABLE
388: , p5_a31 JTF_NUMBER_TABLE
389: , p5_a32 JTF_DATE_TABLE
390: , p5_a33 JTF_NUMBER_TABLE
391: );
392: procedure update_row(p_api_version NUMBER
393: , p_init_msg_list VARCHAR2
394: , x_return_status out nocopy VARCHAR2
467: , p_init_msg_list VARCHAR2
468: , x_return_status out nocopy VARCHAR2
469: , x_msg_count out nocopy NUMBER
470: , x_msg_data out nocopy VARCHAR2
471: , p5_a0 JTF_NUMBER_TABLE
472: , p5_a1 JTF_NUMBER_TABLE
473: , p5_a2 JTF_VARCHAR2_TABLE_100
474: , p5_a3 JTF_NUMBER_TABLE
475: , p5_a4 JTF_VARCHAR2_TABLE_100
468: , x_return_status out nocopy VARCHAR2
469: , x_msg_count out nocopy NUMBER
470: , x_msg_data out nocopy VARCHAR2
471: , p5_a0 JTF_NUMBER_TABLE
472: , p5_a1 JTF_NUMBER_TABLE
473: , p5_a2 JTF_VARCHAR2_TABLE_100
474: , p5_a3 JTF_NUMBER_TABLE
475: , p5_a4 JTF_VARCHAR2_TABLE_100
476: , p5_a5 JTF_VARCHAR2_TABLE_200
470: , x_msg_data out nocopy VARCHAR2
471: , p5_a0 JTF_NUMBER_TABLE
472: , p5_a1 JTF_NUMBER_TABLE
473: , p5_a2 JTF_VARCHAR2_TABLE_100
474: , p5_a3 JTF_NUMBER_TABLE
475: , p5_a4 JTF_VARCHAR2_TABLE_100
476: , p5_a5 JTF_VARCHAR2_TABLE_200
477: , p5_a6 JTF_VARCHAR2_TABLE_2000
478: , p5_a7 JTF_VARCHAR2_TABLE_2000
494: , p5_a23 JTF_VARCHAR2_TABLE_500
495: , p5_a24 JTF_VARCHAR2_TABLE_500
496: , p5_a25 JTF_VARCHAR2_TABLE_500
497: , p5_a26 JTF_VARCHAR2_TABLE_500
498: , p5_a27 JTF_NUMBER_TABLE
499: , p5_a28 JTF_VARCHAR2_TABLE_100
500: , p5_a29 JTF_NUMBER_TABLE
501: , p5_a30 JTF_DATE_TABLE
502: , p5_a31 JTF_NUMBER_TABLE
496: , p5_a25 JTF_VARCHAR2_TABLE_500
497: , p5_a26 JTF_VARCHAR2_TABLE_500
498: , p5_a27 JTF_NUMBER_TABLE
499: , p5_a28 JTF_VARCHAR2_TABLE_100
500: , p5_a29 JTF_NUMBER_TABLE
501: , p5_a30 JTF_DATE_TABLE
502: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a32 JTF_DATE_TABLE
504: , p5_a33 JTF_NUMBER_TABLE
498: , p5_a27 JTF_NUMBER_TABLE
499: , p5_a28 JTF_VARCHAR2_TABLE_100
500: , p5_a29 JTF_NUMBER_TABLE
501: , p5_a30 JTF_DATE_TABLE
502: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a32 JTF_DATE_TABLE
504: , p5_a33 JTF_NUMBER_TABLE
505: , p6_a0 out nocopy JTF_NUMBER_TABLE
506: , p6_a1 out nocopy JTF_NUMBER_TABLE
500: , p5_a29 JTF_NUMBER_TABLE
501: , p5_a30 JTF_DATE_TABLE
502: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a32 JTF_DATE_TABLE
504: , p5_a33 JTF_NUMBER_TABLE
505: , p6_a0 out nocopy JTF_NUMBER_TABLE
506: , p6_a1 out nocopy JTF_NUMBER_TABLE
507: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a3 out nocopy JTF_NUMBER_TABLE
501: , p5_a30 JTF_DATE_TABLE
502: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a32 JTF_DATE_TABLE
504: , p5_a33 JTF_NUMBER_TABLE
505: , p6_a0 out nocopy JTF_NUMBER_TABLE
506: , p6_a1 out nocopy JTF_NUMBER_TABLE
507: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a3 out nocopy JTF_NUMBER_TABLE
509: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
502: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a32 JTF_DATE_TABLE
504: , p5_a33 JTF_NUMBER_TABLE
505: , p6_a0 out nocopy JTF_NUMBER_TABLE
506: , p6_a1 out nocopy JTF_NUMBER_TABLE
507: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a3 out nocopy JTF_NUMBER_TABLE
509: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
504: , p5_a33 JTF_NUMBER_TABLE
505: , p6_a0 out nocopy JTF_NUMBER_TABLE
506: , p6_a1 out nocopy JTF_NUMBER_TABLE
507: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p6_a3 out nocopy JTF_NUMBER_TABLE
509: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
510: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
511: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
512: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
528: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
529: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
530: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
531: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
532: , p6_a27 out nocopy JTF_NUMBER_TABLE
533: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a29 out nocopy JTF_NUMBER_TABLE
535: , p6_a30 out nocopy JTF_DATE_TABLE
536: , p6_a31 out nocopy JTF_NUMBER_TABLE
530: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
531: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
532: , p6_a27 out nocopy JTF_NUMBER_TABLE
533: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a29 out nocopy JTF_NUMBER_TABLE
535: , p6_a30 out nocopy JTF_DATE_TABLE
536: , p6_a31 out nocopy JTF_NUMBER_TABLE
537: , p6_a32 out nocopy JTF_DATE_TABLE
538: , p6_a33 out nocopy JTF_NUMBER_TABLE
532: , p6_a27 out nocopy JTF_NUMBER_TABLE
533: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a29 out nocopy JTF_NUMBER_TABLE
535: , p6_a30 out nocopy JTF_DATE_TABLE
536: , p6_a31 out nocopy JTF_NUMBER_TABLE
537: , p6_a32 out nocopy JTF_DATE_TABLE
538: , p6_a33 out nocopy JTF_NUMBER_TABLE
539: );
540: procedure delete_row(p_api_version NUMBER
534: , p6_a29 out nocopy JTF_NUMBER_TABLE
535: , p6_a30 out nocopy JTF_DATE_TABLE
536: , p6_a31 out nocopy JTF_NUMBER_TABLE
537: , p6_a32 out nocopy JTF_DATE_TABLE
538: , p6_a33 out nocopy JTF_NUMBER_TABLE
539: );
540: procedure delete_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
581: , p_init_msg_list VARCHAR2
582: , x_return_status out nocopy VARCHAR2
583: , x_msg_count out nocopy NUMBER
584: , x_msg_data out nocopy VARCHAR2
585: , p5_a0 JTF_NUMBER_TABLE
586: , p5_a1 JTF_NUMBER_TABLE
587: , p5_a2 JTF_VARCHAR2_TABLE_100
588: , p5_a3 JTF_NUMBER_TABLE
589: , p5_a4 JTF_VARCHAR2_TABLE_100
582: , x_return_status out nocopy VARCHAR2
583: , x_msg_count out nocopy NUMBER
584: , x_msg_data out nocopy VARCHAR2
585: , p5_a0 JTF_NUMBER_TABLE
586: , p5_a1 JTF_NUMBER_TABLE
587: , p5_a2 JTF_VARCHAR2_TABLE_100
588: , p5_a3 JTF_NUMBER_TABLE
589: , p5_a4 JTF_VARCHAR2_TABLE_100
590: , p5_a5 JTF_VARCHAR2_TABLE_200
584: , x_msg_data out nocopy VARCHAR2
585: , p5_a0 JTF_NUMBER_TABLE
586: , p5_a1 JTF_NUMBER_TABLE
587: , p5_a2 JTF_VARCHAR2_TABLE_100
588: , p5_a3 JTF_NUMBER_TABLE
589: , p5_a4 JTF_VARCHAR2_TABLE_100
590: , p5_a5 JTF_VARCHAR2_TABLE_200
591: , p5_a6 JTF_VARCHAR2_TABLE_2000
592: , p5_a7 JTF_VARCHAR2_TABLE_2000
608: , p5_a23 JTF_VARCHAR2_TABLE_500
609: , p5_a24 JTF_VARCHAR2_TABLE_500
610: , p5_a25 JTF_VARCHAR2_TABLE_500
611: , p5_a26 JTF_VARCHAR2_TABLE_500
612: , p5_a27 JTF_NUMBER_TABLE
613: , p5_a28 JTF_VARCHAR2_TABLE_100
614: , p5_a29 JTF_NUMBER_TABLE
615: , p5_a30 JTF_DATE_TABLE
616: , p5_a31 JTF_NUMBER_TABLE
610: , p5_a25 JTF_VARCHAR2_TABLE_500
611: , p5_a26 JTF_VARCHAR2_TABLE_500
612: , p5_a27 JTF_NUMBER_TABLE
613: , p5_a28 JTF_VARCHAR2_TABLE_100
614: , p5_a29 JTF_NUMBER_TABLE
615: , p5_a30 JTF_DATE_TABLE
616: , p5_a31 JTF_NUMBER_TABLE
617: , p5_a32 JTF_DATE_TABLE
618: , p5_a33 JTF_NUMBER_TABLE
612: , p5_a27 JTF_NUMBER_TABLE
613: , p5_a28 JTF_VARCHAR2_TABLE_100
614: , p5_a29 JTF_NUMBER_TABLE
615: , p5_a30 JTF_DATE_TABLE
616: , p5_a31 JTF_NUMBER_TABLE
617: , p5_a32 JTF_DATE_TABLE
618: , p5_a33 JTF_NUMBER_TABLE
619: );
620: procedure validate_row(p_api_version NUMBER
614: , p5_a29 JTF_NUMBER_TABLE
615: , p5_a30 JTF_DATE_TABLE
616: , p5_a31 JTF_NUMBER_TABLE
617: , p5_a32 JTF_DATE_TABLE
618: , p5_a33 JTF_NUMBER_TABLE
619: );
620: procedure validate_row(p_api_version NUMBER
621: , p_init_msg_list VARCHAR2
622: , x_return_status out nocopy VARCHAR2
661: , p_init_msg_list VARCHAR2
662: , x_return_status out nocopy VARCHAR2
663: , x_msg_count out nocopy NUMBER
664: , x_msg_data out nocopy VARCHAR2
665: , p5_a0 JTF_NUMBER_TABLE
666: , p5_a1 JTF_NUMBER_TABLE
667: , p5_a2 JTF_VARCHAR2_TABLE_100
668: , p5_a3 JTF_NUMBER_TABLE
669: , p5_a4 JTF_VARCHAR2_TABLE_100
662: , x_return_status out nocopy VARCHAR2
663: , x_msg_count out nocopy NUMBER
664: , x_msg_data out nocopy VARCHAR2
665: , p5_a0 JTF_NUMBER_TABLE
666: , p5_a1 JTF_NUMBER_TABLE
667: , p5_a2 JTF_VARCHAR2_TABLE_100
668: , p5_a3 JTF_NUMBER_TABLE
669: , p5_a4 JTF_VARCHAR2_TABLE_100
670: , p5_a5 JTF_VARCHAR2_TABLE_200
664: , x_msg_data out nocopy VARCHAR2
665: , p5_a0 JTF_NUMBER_TABLE
666: , p5_a1 JTF_NUMBER_TABLE
667: , p5_a2 JTF_VARCHAR2_TABLE_100
668: , p5_a3 JTF_NUMBER_TABLE
669: , p5_a4 JTF_VARCHAR2_TABLE_100
670: , p5_a5 JTF_VARCHAR2_TABLE_200
671: , p5_a6 JTF_VARCHAR2_TABLE_2000
672: , p5_a7 JTF_VARCHAR2_TABLE_2000
688: , p5_a23 JTF_VARCHAR2_TABLE_500
689: , p5_a24 JTF_VARCHAR2_TABLE_500
690: , p5_a25 JTF_VARCHAR2_TABLE_500
691: , p5_a26 JTF_VARCHAR2_TABLE_500
692: , p5_a27 JTF_NUMBER_TABLE
693: , p5_a28 JTF_VARCHAR2_TABLE_100
694: , p5_a29 JTF_NUMBER_TABLE
695: , p5_a30 JTF_DATE_TABLE
696: , p5_a31 JTF_NUMBER_TABLE
690: , p5_a25 JTF_VARCHAR2_TABLE_500
691: , p5_a26 JTF_VARCHAR2_TABLE_500
692: , p5_a27 JTF_NUMBER_TABLE
693: , p5_a28 JTF_VARCHAR2_TABLE_100
694: , p5_a29 JTF_NUMBER_TABLE
695: , p5_a30 JTF_DATE_TABLE
696: , p5_a31 JTF_NUMBER_TABLE
697: , p5_a32 JTF_DATE_TABLE
698: , p5_a33 JTF_NUMBER_TABLE
692: , p5_a27 JTF_NUMBER_TABLE
693: , p5_a28 JTF_VARCHAR2_TABLE_100
694: , p5_a29 JTF_NUMBER_TABLE
695: , p5_a30 JTF_DATE_TABLE
696: , p5_a31 JTF_NUMBER_TABLE
697: , p5_a32 JTF_DATE_TABLE
698: , p5_a33 JTF_NUMBER_TABLE
699: );
700: end okl_fma_pvt_w;
694: , p5_a29 JTF_NUMBER_TABLE
695: , p5_a30 JTF_DATE_TABLE
696: , p5_a31 JTF_NUMBER_TABLE
697: , p5_a32 JTF_DATE_TABLE
698: , p5_a33 JTF_NUMBER_TABLE
699: );
700: end okl_fma_pvt_w;