1: package okl_pdt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPDTS.pls 120.3 2005/10/30 04:17:14 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pdt_pvt.pdt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_pdt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIPDTS.pls 120.3 2005/10/30 04:17:14 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pdt_pvt.pdt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLIPDTS.pls 120.3 2005/10/30 04:17:14 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_pdt_pvt.pdt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_200
39: , a2 out nocopy JTF_NUMBER_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_200
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a32 JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_200
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_100
43: , a6 out nocopy JTF_NUMBER_TABLE
36: );
37: procedure rosetta_table_copy_out_p2(t okl_pdt_pvt.pdt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_VARCHAR2_TABLE_200
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_100
43: , a6 out nocopy JTF_NUMBER_TABLE
44: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
39: , a2 out nocopy JTF_NUMBER_TABLE
40: , a3 out nocopy JTF_NUMBER_TABLE
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_100
43: , a6 out nocopy JTF_NUMBER_TABLE
44: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a8 out nocopy JTF_NUMBER_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_DATE_TABLE
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_VARCHAR2_TABLE_100
43: , a6 out nocopy JTF_NUMBER_TABLE
44: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
45: , a8 out nocopy JTF_NUMBER_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_DATE_TABLE
48: , a11 out nocopy JTF_DATE_TABLE
49: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a24 out nocopy JTF_VARCHAR2_TABLE_500
62: , a25 out nocopy JTF_VARCHAR2_TABLE_500
63: , a26 out nocopy JTF_VARCHAR2_TABLE_500
64: , a27 out nocopy JTF_VARCHAR2_TABLE_500
65: , a28 out nocopy JTF_NUMBER_TABLE
66: , a29 out nocopy JTF_DATE_TABLE
67: , a30 out nocopy JTF_NUMBER_TABLE
68: , a31 out nocopy JTF_DATE_TABLE
69: , a32 out nocopy JTF_NUMBER_TABLE
63: , a26 out nocopy JTF_VARCHAR2_TABLE_500
64: , a27 out nocopy JTF_VARCHAR2_TABLE_500
65: , a28 out nocopy JTF_NUMBER_TABLE
66: , a29 out nocopy JTF_DATE_TABLE
67: , a30 out nocopy JTF_NUMBER_TABLE
68: , a31 out nocopy JTF_DATE_TABLE
69: , a32 out nocopy JTF_NUMBER_TABLE
70: );
71:
65: , a28 out nocopy JTF_NUMBER_TABLE
66: , a29 out nocopy JTF_DATE_TABLE
67: , a30 out nocopy JTF_NUMBER_TABLE
68: , a31 out nocopy JTF_DATE_TABLE
69: , a32 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
68: , a31 out nocopy JTF_DATE_TABLE
69: , a32 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_NUMBER_TABLE
76: , a4 JTF_VARCHAR2_TABLE_200
69: , a32 out nocopy JTF_NUMBER_TABLE
70: );
71:
72: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_NUMBER_TABLE
76: , a4 JTF_VARCHAR2_TABLE_200
77: , a5 JTF_VARCHAR2_TABLE_2000
70: );
71:
72: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_NUMBER_TABLE
76: , a4 JTF_VARCHAR2_TABLE_200
77: , a5 JTF_VARCHAR2_TABLE_2000
78: , a6 JTF_NUMBER_TABLE
71:
72: procedure rosetta_table_copy_in_p5(t out nocopy okl_pdt_pvt.pdtv_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_NUMBER_TABLE
76: , a4 JTF_VARCHAR2_TABLE_200
77: , a5 JTF_VARCHAR2_TABLE_2000
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_VARCHAR2_TABLE_100
74: , a2 JTF_NUMBER_TABLE
75: , a3 JTF_NUMBER_TABLE
76: , a4 JTF_VARCHAR2_TABLE_200
77: , a5 JTF_VARCHAR2_TABLE_2000
78: , a6 JTF_NUMBER_TABLE
79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_DATE_TABLE
82: , a10 JTF_VARCHAR2_TABLE_100
96: , a24 JTF_VARCHAR2_TABLE_500
97: , a25 JTF_VARCHAR2_TABLE_500
98: , a26 JTF_VARCHAR2_TABLE_500
99: , a27 JTF_VARCHAR2_TABLE_500
100: , a28 JTF_NUMBER_TABLE
101: , a29 JTF_DATE_TABLE
102: , a30 JTF_NUMBER_TABLE
103: , a31 JTF_DATE_TABLE
104: , a32 JTF_NUMBER_TABLE
98: , a26 JTF_VARCHAR2_TABLE_500
99: , a27 JTF_VARCHAR2_TABLE_500
100: , a28 JTF_NUMBER_TABLE
101: , a29 JTF_DATE_TABLE
102: , a30 JTF_NUMBER_TABLE
103: , a31 JTF_DATE_TABLE
104: , a32 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
100: , a28 JTF_NUMBER_TABLE
101: , a29 JTF_DATE_TABLE
102: , a30 JTF_NUMBER_TABLE
103: , a31 JTF_DATE_TABLE
104: , a32 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
102: , a30 JTF_NUMBER_TABLE
103: , a31 JTF_DATE_TABLE
104: , a32 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_VARCHAR2_TABLE_200
103: , a31 JTF_DATE_TABLE
104: , a32 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_VARCHAR2_TABLE_200
111: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a32 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_VARCHAR2_TABLE_200
111: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a6 out nocopy JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p5(t okl_pdt_pvt.pdtv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_VARCHAR2_TABLE_200
111: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a6 out nocopy JTF_NUMBER_TABLE
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
108: , a2 out nocopy JTF_NUMBER_TABLE
109: , a3 out nocopy JTF_NUMBER_TABLE
110: , a4 out nocopy JTF_VARCHAR2_TABLE_200
111: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
112: , a6 out nocopy JTF_NUMBER_TABLE
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_DATE_TABLE
116: , a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , a24 out nocopy JTF_VARCHAR2_TABLE_500
131: , a25 out nocopy JTF_VARCHAR2_TABLE_500
132: , a26 out nocopy JTF_VARCHAR2_TABLE_500
133: , a27 out nocopy JTF_VARCHAR2_TABLE_500
134: , a28 out nocopy JTF_NUMBER_TABLE
135: , a29 out nocopy JTF_DATE_TABLE
136: , a30 out nocopy JTF_NUMBER_TABLE
137: , a31 out nocopy JTF_DATE_TABLE
138: , a32 out nocopy JTF_NUMBER_TABLE
132: , a26 out nocopy JTF_VARCHAR2_TABLE_500
133: , a27 out nocopy JTF_VARCHAR2_TABLE_500
134: , a28 out nocopy JTF_NUMBER_TABLE
135: , a29 out nocopy JTF_DATE_TABLE
136: , a30 out nocopy JTF_NUMBER_TABLE
137: , a31 out nocopy JTF_DATE_TABLE
138: , a32 out nocopy JTF_NUMBER_TABLE
139: );
140:
134: , a28 out nocopy JTF_NUMBER_TABLE
135: , a29 out nocopy JTF_DATE_TABLE
136: , a30 out nocopy JTF_NUMBER_TABLE
137: , a31 out nocopy JTF_DATE_TABLE
138: , a32 out nocopy JTF_NUMBER_TABLE
139: );
140:
141: procedure insert_row(p_api_version NUMBER
142: , p_init_msg_list VARCHAR2
214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_NUMBER_TABLE
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_200
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_NUMBER_TABLE
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_NUMBER_TABLE
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_NUMBER_TABLE
217: , x_msg_data out nocopy VARCHAR2
218: , p5_a0 JTF_NUMBER_TABLE
219: , p5_a1 JTF_NUMBER_TABLE
220: , p5_a2 JTF_NUMBER_TABLE
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_NUMBER_TABLE
225: , p5_a7 JTF_VARCHAR2_TABLE_100
220: , p5_a2 JTF_NUMBER_TABLE
221: , p5_a3 JTF_NUMBER_TABLE
222: , p5_a4 JTF_VARCHAR2_TABLE_200
223: , p5_a5 JTF_VARCHAR2_TABLE_2000
224: , p5_a6 JTF_NUMBER_TABLE
225: , p5_a7 JTF_VARCHAR2_TABLE_100
226: , p5_a8 JTF_VARCHAR2_TABLE_100
227: , p5_a9 JTF_DATE_TABLE
228: , p5_a10 JTF_VARCHAR2_TABLE_100
242: , p5_a24 JTF_VARCHAR2_TABLE_500
243: , p5_a25 JTF_VARCHAR2_TABLE_500
244: , p5_a26 JTF_VARCHAR2_TABLE_500
245: , p5_a27 JTF_VARCHAR2_TABLE_500
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
244: , p5_a26 JTF_VARCHAR2_TABLE_500
245: , p5_a27 JTF_VARCHAR2_TABLE_500
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p5_a28 JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
247: , p5_a29 JTF_DATE_TABLE
248: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
248: , p5_a30 JTF_NUMBER_TABLE
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
249: , p5_a31 JTF_DATE_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a6 out nocopy JTF_NUMBER_TABLE
250: , p5_a32 JTF_NUMBER_TABLE
251: , p6_a0 out nocopy JTF_NUMBER_TABLE
252: , p6_a1 out nocopy JTF_NUMBER_TABLE
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a6 out nocopy JTF_NUMBER_TABLE
258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
253: , p6_a2 out nocopy JTF_NUMBER_TABLE
254: , p6_a3 out nocopy JTF_NUMBER_TABLE
255: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
256: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
257: , p6_a6 out nocopy JTF_NUMBER_TABLE
258: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
260: , p6_a9 out nocopy JTF_DATE_TABLE
261: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
275: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
276: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
277: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
278: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
279: , p6_a28 out nocopy JTF_NUMBER_TABLE
280: , p6_a29 out nocopy JTF_DATE_TABLE
281: , p6_a30 out nocopy JTF_NUMBER_TABLE
282: , p6_a31 out nocopy JTF_DATE_TABLE
283: , p6_a32 out nocopy JTF_NUMBER_TABLE
277: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
278: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
279: , p6_a28 out nocopy JTF_NUMBER_TABLE
280: , p6_a29 out nocopy JTF_DATE_TABLE
281: , p6_a30 out nocopy JTF_NUMBER_TABLE
282: , p6_a31 out nocopy JTF_DATE_TABLE
283: , p6_a32 out nocopy JTF_NUMBER_TABLE
284: );
285: procedure lock_row(p_api_version NUMBER
279: , p6_a28 out nocopy JTF_NUMBER_TABLE
280: , p6_a29 out nocopy JTF_DATE_TABLE
281: , p6_a30 out nocopy JTF_NUMBER_TABLE
282: , p6_a31 out nocopy JTF_DATE_TABLE
283: , p6_a32 out nocopy JTF_NUMBER_TABLE
284: );
285: procedure lock_row(p_api_version NUMBER
286: , p_init_msg_list VARCHAR2
287: , x_return_status out nocopy VARCHAR2
325: , p_init_msg_list VARCHAR2
326: , x_return_status out nocopy VARCHAR2
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_200
326: , x_return_status out nocopy VARCHAR2
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_200
334: , p5_a5 JTF_VARCHAR2_TABLE_2000
327: , x_msg_count out nocopy NUMBER
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_200
334: , p5_a5 JTF_VARCHAR2_TABLE_2000
335: , p5_a6 JTF_NUMBER_TABLE
328: , x_msg_data out nocopy VARCHAR2
329: , p5_a0 JTF_NUMBER_TABLE
330: , p5_a1 JTF_NUMBER_TABLE
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_200
334: , p5_a5 JTF_VARCHAR2_TABLE_2000
335: , p5_a6 JTF_NUMBER_TABLE
336: , p5_a7 JTF_VARCHAR2_TABLE_100
331: , p5_a2 JTF_NUMBER_TABLE
332: , p5_a3 JTF_NUMBER_TABLE
333: , p5_a4 JTF_VARCHAR2_TABLE_200
334: , p5_a5 JTF_VARCHAR2_TABLE_2000
335: , p5_a6 JTF_NUMBER_TABLE
336: , p5_a7 JTF_VARCHAR2_TABLE_100
337: , p5_a8 JTF_VARCHAR2_TABLE_100
338: , p5_a9 JTF_DATE_TABLE
339: , p5_a10 JTF_VARCHAR2_TABLE_100
353: , p5_a24 JTF_VARCHAR2_TABLE_500
354: , p5_a25 JTF_VARCHAR2_TABLE_500
355: , p5_a26 JTF_VARCHAR2_TABLE_500
356: , p5_a27 JTF_VARCHAR2_TABLE_500
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_DATE_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
355: , p5_a26 JTF_VARCHAR2_TABLE_500
356: , p5_a27 JTF_VARCHAR2_TABLE_500
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_DATE_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: );
363: procedure update_row(p_api_version NUMBER
357: , p5_a28 JTF_NUMBER_TABLE
358: , p5_a29 JTF_DATE_TABLE
359: , p5_a30 JTF_NUMBER_TABLE
360: , p5_a31 JTF_DATE_TABLE
361: , p5_a32 JTF_NUMBER_TABLE
362: );
363: procedure update_row(p_api_version NUMBER
364: , p_init_msg_list VARCHAR2
365: , x_return_status out nocopy VARCHAR2
436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_200
437: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_200
445: , p5_a5 JTF_VARCHAR2_TABLE_2000
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_200
445: , p5_a5 JTF_VARCHAR2_TABLE_2000
446: , p5_a6 JTF_NUMBER_TABLE
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_200
445: , p5_a5 JTF_VARCHAR2_TABLE_2000
446: , p5_a6 JTF_NUMBER_TABLE
447: , p5_a7 JTF_VARCHAR2_TABLE_100
442: , p5_a2 JTF_NUMBER_TABLE
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_200
445: , p5_a5 JTF_VARCHAR2_TABLE_2000
446: , p5_a6 JTF_NUMBER_TABLE
447: , p5_a7 JTF_VARCHAR2_TABLE_100
448: , p5_a8 JTF_VARCHAR2_TABLE_100
449: , p5_a9 JTF_DATE_TABLE
450: , p5_a10 JTF_VARCHAR2_TABLE_100
464: , p5_a24 JTF_VARCHAR2_TABLE_500
465: , p5_a25 JTF_VARCHAR2_TABLE_500
466: , p5_a26 JTF_VARCHAR2_TABLE_500
467: , p5_a27 JTF_VARCHAR2_TABLE_500
468: , p5_a28 JTF_NUMBER_TABLE
469: , p5_a29 JTF_DATE_TABLE
470: , p5_a30 JTF_NUMBER_TABLE
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
466: , p5_a26 JTF_VARCHAR2_TABLE_500
467: , p5_a27 JTF_VARCHAR2_TABLE_500
468: , p5_a28 JTF_NUMBER_TABLE
469: , p5_a29 JTF_DATE_TABLE
470: , p5_a30 JTF_NUMBER_TABLE
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
468: , p5_a28 JTF_NUMBER_TABLE
469: , p5_a29 JTF_DATE_TABLE
470: , p5_a30 JTF_NUMBER_TABLE
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
469: , p5_a29 JTF_DATE_TABLE
470: , p5_a30 JTF_NUMBER_TABLE
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
477: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
470: , p5_a30 JTF_NUMBER_TABLE
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
477: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
478: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
471: , p5_a31 JTF_DATE_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
477: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
478: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a6 out nocopy JTF_NUMBER_TABLE
472: , p5_a32 JTF_NUMBER_TABLE
473: , p6_a0 out nocopy JTF_NUMBER_TABLE
474: , p6_a1 out nocopy JTF_NUMBER_TABLE
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
477: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
478: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a6 out nocopy JTF_NUMBER_TABLE
480: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
475: , p6_a2 out nocopy JTF_NUMBER_TABLE
476: , p6_a3 out nocopy JTF_NUMBER_TABLE
477: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
478: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
479: , p6_a6 out nocopy JTF_NUMBER_TABLE
480: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
481: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
482: , p6_a9 out nocopy JTF_DATE_TABLE
483: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
497: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
498: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
499: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
501: , p6_a28 out nocopy JTF_NUMBER_TABLE
502: , p6_a29 out nocopy JTF_DATE_TABLE
503: , p6_a30 out nocopy JTF_NUMBER_TABLE
504: , p6_a31 out nocopy JTF_DATE_TABLE
505: , p6_a32 out nocopy JTF_NUMBER_TABLE
499: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
500: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
501: , p6_a28 out nocopy JTF_NUMBER_TABLE
502: , p6_a29 out nocopy JTF_DATE_TABLE
503: , p6_a30 out nocopy JTF_NUMBER_TABLE
504: , p6_a31 out nocopy JTF_DATE_TABLE
505: , p6_a32 out nocopy JTF_NUMBER_TABLE
506: );
507: procedure delete_row(p_api_version NUMBER
501: , p6_a28 out nocopy JTF_NUMBER_TABLE
502: , p6_a29 out nocopy JTF_DATE_TABLE
503: , p6_a30 out nocopy JTF_NUMBER_TABLE
504: , p6_a31 out nocopy JTF_DATE_TABLE
505: , p6_a32 out nocopy JTF_NUMBER_TABLE
506: );
507: procedure delete_row(p_api_version NUMBER
508: , p_init_msg_list VARCHAR2
509: , x_return_status out nocopy VARCHAR2
547: , p_init_msg_list VARCHAR2
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_NUMBER_TABLE
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_200
548: , x_return_status out nocopy VARCHAR2
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_NUMBER_TABLE
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_200
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
549: , x_msg_count out nocopy NUMBER
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_NUMBER_TABLE
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_200
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
557: , p5_a6 JTF_NUMBER_TABLE
550: , x_msg_data out nocopy VARCHAR2
551: , p5_a0 JTF_NUMBER_TABLE
552: , p5_a1 JTF_NUMBER_TABLE
553: , p5_a2 JTF_NUMBER_TABLE
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_200
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
557: , p5_a6 JTF_NUMBER_TABLE
558: , p5_a7 JTF_VARCHAR2_TABLE_100
553: , p5_a2 JTF_NUMBER_TABLE
554: , p5_a3 JTF_NUMBER_TABLE
555: , p5_a4 JTF_VARCHAR2_TABLE_200
556: , p5_a5 JTF_VARCHAR2_TABLE_2000
557: , p5_a6 JTF_NUMBER_TABLE
558: , p5_a7 JTF_VARCHAR2_TABLE_100
559: , p5_a8 JTF_VARCHAR2_TABLE_100
560: , p5_a9 JTF_DATE_TABLE
561: , p5_a10 JTF_VARCHAR2_TABLE_100
575: , p5_a24 JTF_VARCHAR2_TABLE_500
576: , p5_a25 JTF_VARCHAR2_TABLE_500
577: , p5_a26 JTF_VARCHAR2_TABLE_500
578: , p5_a27 JTF_VARCHAR2_TABLE_500
579: , p5_a28 JTF_NUMBER_TABLE
580: , p5_a29 JTF_DATE_TABLE
581: , p5_a30 JTF_NUMBER_TABLE
582: , p5_a31 JTF_DATE_TABLE
583: , p5_a32 JTF_NUMBER_TABLE
577: , p5_a26 JTF_VARCHAR2_TABLE_500
578: , p5_a27 JTF_VARCHAR2_TABLE_500
579: , p5_a28 JTF_NUMBER_TABLE
580: , p5_a29 JTF_DATE_TABLE
581: , p5_a30 JTF_NUMBER_TABLE
582: , p5_a31 JTF_DATE_TABLE
583: , p5_a32 JTF_NUMBER_TABLE
584: );
585: procedure validate_row(p_api_version NUMBER
579: , p5_a28 JTF_NUMBER_TABLE
580: , p5_a29 JTF_DATE_TABLE
581: , p5_a30 JTF_NUMBER_TABLE
582: , p5_a31 JTF_DATE_TABLE
583: , p5_a32 JTF_NUMBER_TABLE
584: );
585: procedure validate_row(p_api_version NUMBER
586: , p_init_msg_list VARCHAR2
587: , x_return_status out nocopy VARCHAR2
625: , p_init_msg_list VARCHAR2
626: , x_return_status out nocopy VARCHAR2
627: , x_msg_count out nocopy NUMBER
628: , x_msg_data out nocopy VARCHAR2
629: , p5_a0 JTF_NUMBER_TABLE
630: , p5_a1 JTF_NUMBER_TABLE
631: , p5_a2 JTF_NUMBER_TABLE
632: , p5_a3 JTF_NUMBER_TABLE
633: , p5_a4 JTF_VARCHAR2_TABLE_200
626: , x_return_status out nocopy VARCHAR2
627: , x_msg_count out nocopy NUMBER
628: , x_msg_data out nocopy VARCHAR2
629: , p5_a0 JTF_NUMBER_TABLE
630: , p5_a1 JTF_NUMBER_TABLE
631: , p5_a2 JTF_NUMBER_TABLE
632: , p5_a3 JTF_NUMBER_TABLE
633: , p5_a4 JTF_VARCHAR2_TABLE_200
634: , p5_a5 JTF_VARCHAR2_TABLE_2000
627: , x_msg_count out nocopy NUMBER
628: , x_msg_data out nocopy VARCHAR2
629: , p5_a0 JTF_NUMBER_TABLE
630: , p5_a1 JTF_NUMBER_TABLE
631: , p5_a2 JTF_NUMBER_TABLE
632: , p5_a3 JTF_NUMBER_TABLE
633: , p5_a4 JTF_VARCHAR2_TABLE_200
634: , p5_a5 JTF_VARCHAR2_TABLE_2000
635: , p5_a6 JTF_NUMBER_TABLE
628: , x_msg_data out nocopy VARCHAR2
629: , p5_a0 JTF_NUMBER_TABLE
630: , p5_a1 JTF_NUMBER_TABLE
631: , p5_a2 JTF_NUMBER_TABLE
632: , p5_a3 JTF_NUMBER_TABLE
633: , p5_a4 JTF_VARCHAR2_TABLE_200
634: , p5_a5 JTF_VARCHAR2_TABLE_2000
635: , p5_a6 JTF_NUMBER_TABLE
636: , p5_a7 JTF_VARCHAR2_TABLE_100
631: , p5_a2 JTF_NUMBER_TABLE
632: , p5_a3 JTF_NUMBER_TABLE
633: , p5_a4 JTF_VARCHAR2_TABLE_200
634: , p5_a5 JTF_VARCHAR2_TABLE_2000
635: , p5_a6 JTF_NUMBER_TABLE
636: , p5_a7 JTF_VARCHAR2_TABLE_100
637: , p5_a8 JTF_VARCHAR2_TABLE_100
638: , p5_a9 JTF_DATE_TABLE
639: , p5_a10 JTF_VARCHAR2_TABLE_100
653: , p5_a24 JTF_VARCHAR2_TABLE_500
654: , p5_a25 JTF_VARCHAR2_TABLE_500
655: , p5_a26 JTF_VARCHAR2_TABLE_500
656: , p5_a27 JTF_VARCHAR2_TABLE_500
657: , p5_a28 JTF_NUMBER_TABLE
658: , p5_a29 JTF_DATE_TABLE
659: , p5_a30 JTF_NUMBER_TABLE
660: , p5_a31 JTF_DATE_TABLE
661: , p5_a32 JTF_NUMBER_TABLE
655: , p5_a26 JTF_VARCHAR2_TABLE_500
656: , p5_a27 JTF_VARCHAR2_TABLE_500
657: , p5_a28 JTF_NUMBER_TABLE
658: , p5_a29 JTF_DATE_TABLE
659: , p5_a30 JTF_NUMBER_TABLE
660: , p5_a31 JTF_DATE_TABLE
661: , p5_a32 JTF_NUMBER_TABLE
662: );
663: end okl_pdt_pvt_w;
657: , p5_a28 JTF_NUMBER_TABLE
658: , p5_a29 JTF_DATE_TABLE
659: , p5_a30 JTF_NUMBER_TABLE
660: , p5_a31 JTF_DATE_TABLE
661: , p5_a32 JTF_NUMBER_TABLE
662: );
663: end okl_pdt_pvt_w;