1: package okl_ity_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIITYS.pls 120.1 2005/07/13 09:29:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_ity_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIITYS.pls 120.1 2005/07/13 09:29:00 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ity_pvt.ity_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
30: procedure rosetta_table_copy_out_p2(t okl_ity_pvt.ity_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_NUMBER_TABLE
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
38: , a8 out nocopy JTF_VARCHAR2_TABLE_500
47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_100
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_VARCHAR2_TABLE_100
60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_100
62: , a4 JTF_VARCHAR2_TABLE_200
60: , a2 JTF_VARCHAR2_TABLE_100
61: , a3 JTF_VARCHAR2_TABLE_100
62: , a4 JTF_VARCHAR2_TABLE_200
63: , a5 JTF_VARCHAR2_TABLE_2000
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_200
63: , a5 JTF_VARCHAR2_TABLE_2000
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
64: , a6 JTF_NUMBER_TABLE
65: , a7 JTF_DATE_TABLE
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_VARCHAR2_TABLE_100
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
66: , a8 JTF_NUMBER_TABLE
67: , a9 JTF_DATE_TABLE
68: , a10 JTF_NUMBER_TABLE
69: );
70: procedure rosetta_table_copy_out_p5(t okl_ity_pvt.okl_invoice_types_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a1 out nocopy JTF_VARCHAR2_TABLE_100
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
72: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a3 out nocopy JTF_VARCHAR2_TABLE_100
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
74: , a4 out nocopy JTF_VARCHAR2_TABLE_200
75: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
76: , a6 out nocopy JTF_NUMBER_TABLE
77: , a7 out nocopy JTF_DATE_TABLE
78: , a8 out nocopy JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
79: , a9 out nocopy JTF_DATE_TABLE
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200
80: , a10 out nocopy JTF_NUMBER_TABLE
81: );
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200
88: , a5 JTF_VARCHAR2_TABLE_2000
82:
83: procedure rosetta_table_copy_in_p8(t out nocopy okl_ity_pvt.ityv_tbl_type, a0 JTF_NUMBER_TABLE
84: , a1 JTF_NUMBER_TABLE
85: , a2 JTF_VARCHAR2_TABLE_100
86: , a3 JTF_NUMBER_TABLE
87: , a4 JTF_VARCHAR2_TABLE_200
88: , a5 JTF_VARCHAR2_TABLE_2000
89: , a6 JTF_VARCHAR2_TABLE_100
90: , a7 JTF_VARCHAR2_TABLE_100
103: , a20 JTF_VARCHAR2_TABLE_500
104: , a21 JTF_VARCHAR2_TABLE_500
105: , a22 JTF_VARCHAR2_TABLE_500
106: , a23 JTF_VARCHAR2_TABLE_500
107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
105: , a22 JTF_VARCHAR2_TABLE_500
106: , a23 JTF_VARCHAR2_TABLE_500
107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a24 JTF_NUMBER_TABLE
108: , a25 JTF_DATE_TABLE
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a26 JTF_NUMBER_TABLE
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200
110: , a27 JTF_DATE_TABLE
111: , a28 JTF_NUMBER_TABLE
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200
118: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
112: );
113: procedure rosetta_table_copy_out_p8(t okl_ity_pvt.ityv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
114: , a1 out nocopy JTF_NUMBER_TABLE
115: , a2 out nocopy JTF_VARCHAR2_TABLE_100
116: , a3 out nocopy JTF_NUMBER_TABLE
117: , a4 out nocopy JTF_VARCHAR2_TABLE_200
118: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a6 out nocopy JTF_VARCHAR2_TABLE_100
120: , a7 out nocopy JTF_VARCHAR2_TABLE_100
133: , a20 out nocopy JTF_VARCHAR2_TABLE_500
134: , a21 out nocopy JTF_VARCHAR2_TABLE_500
135: , a22 out nocopy JTF_VARCHAR2_TABLE_500
136: , a23 out nocopy JTF_VARCHAR2_TABLE_500
137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE
135: , a22 out nocopy JTF_VARCHAR2_TABLE_500
136: , a23 out nocopy JTF_VARCHAR2_TABLE_500
137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE
142: );
143:
137: , a24 out nocopy JTF_NUMBER_TABLE
138: , a25 out nocopy JTF_DATE_TABLE
139: , a26 out nocopy JTF_NUMBER_TABLE
140: , a27 out nocopy JTF_DATE_TABLE
141: , a28 out nocopy JTF_NUMBER_TABLE
142: );
143:
144: procedure insert_row(p_api_version NUMBER
145: , p_init_msg_list VARCHAR2
209: , p_init_msg_list VARCHAR2
210: , x_return_status out nocopy VARCHAR2
211: , x_msg_count out nocopy NUMBER
212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_VARCHAR2_TABLE_200
210: , x_return_status out nocopy VARCHAR2
211: , x_msg_count out nocopy NUMBER
212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_VARCHAR2_TABLE_200
218: , p5_a5 JTF_VARCHAR2_TABLE_2000
212: , x_msg_data out nocopy VARCHAR2
213: , p5_a0 JTF_NUMBER_TABLE
214: , p5_a1 JTF_NUMBER_TABLE
215: , p5_a2 JTF_VARCHAR2_TABLE_100
216: , p5_a3 JTF_NUMBER_TABLE
217: , p5_a4 JTF_VARCHAR2_TABLE_200
218: , p5_a5 JTF_VARCHAR2_TABLE_2000
219: , p5_a6 JTF_VARCHAR2_TABLE_100
220: , p5_a7 JTF_VARCHAR2_TABLE_100
233: , p5_a20 JTF_VARCHAR2_TABLE_500
234: , p5_a21 JTF_VARCHAR2_TABLE_500
235: , p5_a22 JTF_VARCHAR2_TABLE_500
236: , p5_a23 JTF_VARCHAR2_TABLE_500
237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a22 JTF_VARCHAR2_TABLE_500
236: , p5_a23 JTF_VARCHAR2_TABLE_500
237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
237: , p5_a24 JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
238: , p5_a25 JTF_DATE_TABLE
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
239: , p5_a26 JTF_NUMBER_TABLE
240: , p5_a27 JTF_DATE_TABLE
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
241: , p5_a28 JTF_NUMBER_TABLE
242: , p6_a0 out nocopy JTF_NUMBER_TABLE
243: , p6_a1 out nocopy JTF_NUMBER_TABLE
244: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a3 out nocopy JTF_NUMBER_TABLE
246: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
248: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
263: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
264: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
265: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE
264: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
265: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE
271: );
272: procedure lock_row(p_api_version NUMBER
266: , p6_a24 out nocopy JTF_NUMBER_TABLE
267: , p6_a25 out nocopy JTF_DATE_TABLE
268: , p6_a26 out nocopy JTF_NUMBER_TABLE
269: , p6_a27 out nocopy JTF_DATE_TABLE
270: , p6_a28 out nocopy JTF_NUMBER_TABLE
271: );
272: procedure lock_row(p_api_version NUMBER
273: , p_init_msg_list VARCHAR2
274: , x_return_status out nocopy VARCHAR2
308: , p_init_msg_list VARCHAR2
309: , x_return_status out nocopy VARCHAR2
310: , x_msg_count out nocopy NUMBER
311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200
309: , x_return_status out nocopy VARCHAR2
310: , x_msg_count out nocopy NUMBER
311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200
317: , p5_a5 JTF_VARCHAR2_TABLE_2000
311: , x_msg_data out nocopy VARCHAR2
312: , p5_a0 JTF_NUMBER_TABLE
313: , p5_a1 JTF_NUMBER_TABLE
314: , p5_a2 JTF_VARCHAR2_TABLE_100
315: , p5_a3 JTF_NUMBER_TABLE
316: , p5_a4 JTF_VARCHAR2_TABLE_200
317: , p5_a5 JTF_VARCHAR2_TABLE_2000
318: , p5_a6 JTF_VARCHAR2_TABLE_100
319: , p5_a7 JTF_VARCHAR2_TABLE_100
332: , p5_a20 JTF_VARCHAR2_TABLE_500
333: , p5_a21 JTF_VARCHAR2_TABLE_500
334: , p5_a22 JTF_VARCHAR2_TABLE_500
335: , p5_a23 JTF_VARCHAR2_TABLE_500
336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE
334: , p5_a22 JTF_VARCHAR2_TABLE_500
335: , p5_a23 JTF_VARCHAR2_TABLE_500
336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE
341: );
342: procedure update_row(p_api_version NUMBER
336: , p5_a24 JTF_NUMBER_TABLE
337: , p5_a25 JTF_DATE_TABLE
338: , p5_a26 JTF_NUMBER_TABLE
339: , p5_a27 JTF_DATE_TABLE
340: , p5_a28 JTF_NUMBER_TABLE
341: );
342: procedure update_row(p_api_version NUMBER
343: , p_init_msg_list VARCHAR2
344: , x_return_status out nocopy VARCHAR2
407: , p_init_msg_list VARCHAR2
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200
408: , x_return_status out nocopy VARCHAR2
409: , x_msg_count out nocopy NUMBER
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200
416: , p5_a5 JTF_VARCHAR2_TABLE_2000
410: , x_msg_data out nocopy VARCHAR2
411: , p5_a0 JTF_NUMBER_TABLE
412: , p5_a1 JTF_NUMBER_TABLE
413: , p5_a2 JTF_VARCHAR2_TABLE_100
414: , p5_a3 JTF_NUMBER_TABLE
415: , p5_a4 JTF_VARCHAR2_TABLE_200
416: , p5_a5 JTF_VARCHAR2_TABLE_2000
417: , p5_a6 JTF_VARCHAR2_TABLE_100
418: , p5_a7 JTF_VARCHAR2_TABLE_100
431: , p5_a20 JTF_VARCHAR2_TABLE_500
432: , p5_a21 JTF_VARCHAR2_TABLE_500
433: , p5_a22 JTF_VARCHAR2_TABLE_500
434: , p5_a23 JTF_VARCHAR2_TABLE_500
435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
433: , p5_a22 JTF_VARCHAR2_TABLE_500
434: , p5_a23 JTF_VARCHAR2_TABLE_500
435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
435: , p5_a24 JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
436: , p5_a25 JTF_DATE_TABLE
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
437: , p5_a26 JTF_NUMBER_TABLE
438: , p5_a27 JTF_DATE_TABLE
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
445: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
439: , p5_a28 JTF_NUMBER_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_NUMBER_TABLE
442: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
443: , p6_a3 out nocopy JTF_NUMBER_TABLE
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
445: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
446: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
447: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
461: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
462: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE
462: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE
469: );
470: procedure delete_row(p_api_version NUMBER
464: , p6_a24 out nocopy JTF_NUMBER_TABLE
465: , p6_a25 out nocopy JTF_DATE_TABLE
466: , p6_a26 out nocopy JTF_NUMBER_TABLE
467: , p6_a27 out nocopy JTF_DATE_TABLE
468: , p6_a28 out nocopy JTF_NUMBER_TABLE
469: );
470: procedure delete_row(p_api_version NUMBER
471: , p_init_msg_list VARCHAR2
472: , x_return_status out nocopy VARCHAR2
506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200
515: , p5_a5 JTF_VARCHAR2_TABLE_2000
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_VARCHAR2_TABLE_100
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_200
515: , p5_a5 JTF_VARCHAR2_TABLE_2000
516: , p5_a6 JTF_VARCHAR2_TABLE_100
517: , p5_a7 JTF_VARCHAR2_TABLE_100
530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_VARCHAR2_TABLE_500
532: , p5_a22 JTF_VARCHAR2_TABLE_500
533: , p5_a23 JTF_VARCHAR2_TABLE_500
534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE
532: , p5_a22 JTF_VARCHAR2_TABLE_500
533: , p5_a23 JTF_VARCHAR2_TABLE_500
534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE
539: );
540: procedure validate_row(p_api_version NUMBER
534: , p5_a24 JTF_NUMBER_TABLE
535: , p5_a25 JTF_DATE_TABLE
536: , p5_a26 JTF_NUMBER_TABLE
537: , p5_a27 JTF_DATE_TABLE
538: , p5_a28 JTF_NUMBER_TABLE
539: );
540: procedure validate_row(p_api_version NUMBER
541: , p_init_msg_list VARCHAR2
542: , x_return_status out nocopy VARCHAR2
576: , p_init_msg_list VARCHAR2
577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200
577: , x_return_status out nocopy VARCHAR2
578: , x_msg_count out nocopy NUMBER
579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200
585: , p5_a5 JTF_VARCHAR2_TABLE_2000
579: , x_msg_data out nocopy VARCHAR2
580: , p5_a0 JTF_NUMBER_TABLE
581: , p5_a1 JTF_NUMBER_TABLE
582: , p5_a2 JTF_VARCHAR2_TABLE_100
583: , p5_a3 JTF_NUMBER_TABLE
584: , p5_a4 JTF_VARCHAR2_TABLE_200
585: , p5_a5 JTF_VARCHAR2_TABLE_2000
586: , p5_a6 JTF_VARCHAR2_TABLE_100
587: , p5_a7 JTF_VARCHAR2_TABLE_100
600: , p5_a20 JTF_VARCHAR2_TABLE_500
601: , p5_a21 JTF_VARCHAR2_TABLE_500
602: , p5_a22 JTF_VARCHAR2_TABLE_500
603: , p5_a23 JTF_VARCHAR2_TABLE_500
604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE
602: , p5_a22 JTF_VARCHAR2_TABLE_500
603: , p5_a23 JTF_VARCHAR2_TABLE_500
604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE
609: );
610: end okl_ity_pvt_w;
604: , p5_a24 JTF_NUMBER_TABLE
605: , p5_a25 JTF_DATE_TABLE
606: , p5_a26 JTF_NUMBER_TABLE
607: , p5_a27 JTF_DATE_TABLE
608: , p5_a28 JTF_NUMBER_TABLE
609: );
610: end okl_ity_pvt_w;