APPS.OKL_MST_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_mst_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEMSTS.pls 115.2 2004/02/24 22:46:33 dedey noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_600

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_mst_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEMSTS.pls 115.2 2004/02/24 22:46:33 dedey noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mst_pvt.mstv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_600
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 8: , a5 JTF_NUMBER_TABLE

4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_600
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_200
7: , a4 JTF_VARCHAR2_TABLE_600
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_500

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: );

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 35: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_200
39: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 37: , a2 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_DATE_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_mst_pvt.mstv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_200
39: , a4 out nocopy JTF_VARCHAR2_TABLE_600
40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_NUMBER_TABLE

Line 40: , a5 out nocopy JTF_NUMBER_TABLE

36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_200
39: , a4 out nocopy JTF_VARCHAR2_TABLE_600
40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a6 out nocopy JTF_NUMBER_TABLE

37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_200
39: , a4 out nocopy JTF_VARCHAR2_TABLE_600
40: , a5 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 60: , a25 out nocopy JTF_NUMBER_TABLE

56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_VARCHAR2_TABLE_500
58: , a23 out nocopy JTF_VARCHAR2_TABLE_500
59: , a24 out nocopy JTF_VARCHAR2_TABLE_500
60: , a25 out nocopy JTF_NUMBER_TABLE
61: , a26 out nocopy JTF_DATE_TABLE
62: , a27 out nocopy JTF_NUMBER_TABLE
63: , a28 out nocopy JTF_DATE_TABLE
64: , a29 out nocopy JTF_NUMBER_TABLE

Line 62: , a27 out nocopy JTF_NUMBER_TABLE

58: , a23 out nocopy JTF_VARCHAR2_TABLE_500
59: , a24 out nocopy JTF_VARCHAR2_TABLE_500
60: , a25 out nocopy JTF_NUMBER_TABLE
61: , a26 out nocopy JTF_DATE_TABLE
62: , a27 out nocopy JTF_NUMBER_TABLE
63: , a28 out nocopy JTF_DATE_TABLE
64: , a29 out nocopy JTF_NUMBER_TABLE
65: , a30 out nocopy JTF_DATE_TABLE
66: );

Line 64: , a29 out nocopy JTF_NUMBER_TABLE

60: , a25 out nocopy JTF_NUMBER_TABLE
61: , a26 out nocopy JTF_DATE_TABLE
62: , a27 out nocopy JTF_NUMBER_TABLE
63: , a28 out nocopy JTF_DATE_TABLE
64: , a29 out nocopy JTF_NUMBER_TABLE
65: , a30 out nocopy JTF_DATE_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE

64: , a29 out nocopy JTF_NUMBER_TABLE
65: , a30 out nocopy JTF_DATE_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_VARCHAR2_TABLE_200
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_200
72: , a4 JTF_VARCHAR2_TABLE_600

Line 70: , a2 JTF_NUMBER_TABLE

66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_mst_pvt.mst_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_VARCHAR2_TABLE_200
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_200
72: , a4 JTF_VARCHAR2_TABLE_600
73: , a5 JTF_NUMBER_TABLE
74: , a6 JTF_NUMBER_TABLE

Line 73: , a5 JTF_NUMBER_TABLE

69: , a1 JTF_VARCHAR2_TABLE_200
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_200
72: , a4 JTF_VARCHAR2_TABLE_600
73: , a5 JTF_NUMBER_TABLE
74: , a6 JTF_NUMBER_TABLE
75: , a7 JTF_VARCHAR2_TABLE_100
76: , a8 JTF_VARCHAR2_TABLE_100
77: , a9 JTF_VARCHAR2_TABLE_100

Line 74: , a6 JTF_NUMBER_TABLE

70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_200
72: , a4 JTF_VARCHAR2_TABLE_600
73: , a5 JTF_NUMBER_TABLE
74: , a6 JTF_NUMBER_TABLE
75: , a7 JTF_VARCHAR2_TABLE_100
76: , a8 JTF_VARCHAR2_TABLE_100
77: , a9 JTF_VARCHAR2_TABLE_100
78: , a10 JTF_VARCHAR2_TABLE_500

Line 93: , a25 JTF_NUMBER_TABLE

89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_VARCHAR2_TABLE_500
91: , a23 JTF_VARCHAR2_TABLE_500
92: , a24 JTF_VARCHAR2_TABLE_500
93: , a25 JTF_NUMBER_TABLE
94: , a26 JTF_DATE_TABLE
95: , a27 JTF_NUMBER_TABLE
96: , a28 JTF_DATE_TABLE
97: , a29 JTF_NUMBER_TABLE

Line 95: , a27 JTF_NUMBER_TABLE

91: , a23 JTF_VARCHAR2_TABLE_500
92: , a24 JTF_VARCHAR2_TABLE_500
93: , a25 JTF_NUMBER_TABLE
94: , a26 JTF_DATE_TABLE
95: , a27 JTF_NUMBER_TABLE
96: , a28 JTF_DATE_TABLE
97: , a29 JTF_NUMBER_TABLE
98: , a30 JTF_DATE_TABLE
99: );

Line 97: , a29 JTF_NUMBER_TABLE

93: , a25 JTF_NUMBER_TABLE
94: , a26 JTF_DATE_TABLE
95: , a27 JTF_NUMBER_TABLE
96: , a28 JTF_DATE_TABLE
97: , a29 JTF_NUMBER_TABLE
98: , a30 JTF_DATE_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 100: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

96: , a28 JTF_DATE_TABLE
97: , a29 JTF_NUMBER_TABLE
98: , a30 JTF_DATE_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_200
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_200
104: , a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 102: , a2 out nocopy JTF_NUMBER_TABLE

98: , a30 JTF_DATE_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_mst_pvt.mst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_200
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_200
104: , a4 out nocopy JTF_VARCHAR2_TABLE_600
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE

Line 105: , a5 out nocopy JTF_NUMBER_TABLE

101: , a1 out nocopy JTF_VARCHAR2_TABLE_200
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_200
104: , a4 out nocopy JTF_VARCHAR2_TABLE_600
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_VARCHAR2_TABLE_100
108: , a8 out nocopy JTF_VARCHAR2_TABLE_100
109: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a6 out nocopy JTF_NUMBER_TABLE

102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_200
104: , a4 out nocopy JTF_VARCHAR2_TABLE_600
105: , a5 out nocopy JTF_NUMBER_TABLE
106: , a6 out nocopy JTF_NUMBER_TABLE
107: , a7 out nocopy JTF_VARCHAR2_TABLE_100
108: , a8 out nocopy JTF_VARCHAR2_TABLE_100
109: , a9 out nocopy JTF_VARCHAR2_TABLE_100
110: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 125: , a25 out nocopy JTF_NUMBER_TABLE

121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_VARCHAR2_TABLE_500
123: , a23 out nocopy JTF_VARCHAR2_TABLE_500
124: , a24 out nocopy JTF_VARCHAR2_TABLE_500
125: , a25 out nocopy JTF_NUMBER_TABLE
126: , a26 out nocopy JTF_DATE_TABLE
127: , a27 out nocopy JTF_NUMBER_TABLE
128: , a28 out nocopy JTF_DATE_TABLE
129: , a29 out nocopy JTF_NUMBER_TABLE

Line 127: , a27 out nocopy JTF_NUMBER_TABLE

123: , a23 out nocopy JTF_VARCHAR2_TABLE_500
124: , a24 out nocopy JTF_VARCHAR2_TABLE_500
125: , a25 out nocopy JTF_NUMBER_TABLE
126: , a26 out nocopy JTF_DATE_TABLE
127: , a27 out nocopy JTF_NUMBER_TABLE
128: , a28 out nocopy JTF_DATE_TABLE
129: , a29 out nocopy JTF_NUMBER_TABLE
130: , a30 out nocopy JTF_DATE_TABLE
131: );

Line 129: , a29 out nocopy JTF_NUMBER_TABLE

125: , a25 out nocopy JTF_NUMBER_TABLE
126: , a26 out nocopy JTF_DATE_TABLE
127: , a27 out nocopy JTF_NUMBER_TABLE
128: , a28 out nocopy JTF_DATE_TABLE
129: , a29 out nocopy JTF_NUMBER_TABLE
130: , a30 out nocopy JTF_DATE_TABLE
131: );
132:
133: procedure insert_row(p_api_version NUMBER

Line 206: , p5_a0 JTF_NUMBER_TABLE

202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_VARCHAR2_TABLE_200
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_200
210: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 208: , p5_a2 JTF_NUMBER_TABLE

204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_VARCHAR2_TABLE_200
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_200
210: , p5_a4 JTF_VARCHAR2_TABLE_600
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_NUMBER_TABLE

Line 211: , p5_a5 JTF_NUMBER_TABLE

207: , p5_a1 JTF_VARCHAR2_TABLE_200
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_200
210: , p5_a4 JTF_VARCHAR2_TABLE_600
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_NUMBER_TABLE
213: , p5_a7 JTF_VARCHAR2_TABLE_100
214: , p5_a8 JTF_VARCHAR2_TABLE_100
215: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 212: , p5_a6 JTF_NUMBER_TABLE

208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_200
210: , p5_a4 JTF_VARCHAR2_TABLE_600
211: , p5_a5 JTF_NUMBER_TABLE
212: , p5_a6 JTF_NUMBER_TABLE
213: , p5_a7 JTF_VARCHAR2_TABLE_100
214: , p5_a8 JTF_VARCHAR2_TABLE_100
215: , p5_a9 JTF_VARCHAR2_TABLE_100
216: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 231: , p5_a25 JTF_NUMBER_TABLE

227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_VARCHAR2_TABLE_500
229: , p5_a23 JTF_VARCHAR2_TABLE_500
230: , p5_a24 JTF_VARCHAR2_TABLE_500
231: , p5_a25 JTF_NUMBER_TABLE
232: , p5_a26 JTF_DATE_TABLE
233: , p5_a27 JTF_NUMBER_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE

Line 233: , p5_a27 JTF_NUMBER_TABLE

229: , p5_a23 JTF_VARCHAR2_TABLE_500
230: , p5_a24 JTF_VARCHAR2_TABLE_500
231: , p5_a25 JTF_NUMBER_TABLE
232: , p5_a26 JTF_DATE_TABLE
233: , p5_a27 JTF_NUMBER_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_DATE_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 235: , p5_a29 JTF_NUMBER_TABLE

231: , p5_a25 JTF_NUMBER_TABLE
232: , p5_a26 JTF_DATE_TABLE
233: , p5_a27 JTF_NUMBER_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_DATE_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
239: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 237: , p6_a0 out nocopy JTF_NUMBER_TABLE

233: , p5_a27 JTF_NUMBER_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_DATE_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 239: , p6_a2 out nocopy JTF_NUMBER_TABLE

235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_DATE_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
242: , p6_a5 out nocopy JTF_NUMBER_TABLE
243: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 242: , p6_a5 out nocopy JTF_NUMBER_TABLE

238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
242: , p6_a5 out nocopy JTF_NUMBER_TABLE
243: , p6_a6 out nocopy JTF_NUMBER_TABLE
244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 243: , p6_a6 out nocopy JTF_NUMBER_TABLE

239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
242: , p6_a5 out nocopy JTF_NUMBER_TABLE
243: , p6_a6 out nocopy JTF_NUMBER_TABLE
244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
245: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
246: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 262: , p6_a25 out nocopy JTF_NUMBER_TABLE

258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
260: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
261: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
262: , p6_a25 out nocopy JTF_NUMBER_TABLE
263: , p6_a26 out nocopy JTF_DATE_TABLE
264: , p6_a27 out nocopy JTF_NUMBER_TABLE
265: , p6_a28 out nocopy JTF_DATE_TABLE
266: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 264: , p6_a27 out nocopy JTF_NUMBER_TABLE

260: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
261: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
262: , p6_a25 out nocopy JTF_NUMBER_TABLE
263: , p6_a26 out nocopy JTF_DATE_TABLE
264: , p6_a27 out nocopy JTF_NUMBER_TABLE
265: , p6_a28 out nocopy JTF_DATE_TABLE
266: , p6_a29 out nocopy JTF_NUMBER_TABLE
267: , p6_a30 out nocopy JTF_DATE_TABLE
268: );

Line 266: , p6_a29 out nocopy JTF_NUMBER_TABLE

262: , p6_a25 out nocopy JTF_NUMBER_TABLE
263: , p6_a26 out nocopy JTF_DATE_TABLE
264: , p6_a27 out nocopy JTF_NUMBER_TABLE
265: , p6_a28 out nocopy JTF_DATE_TABLE
266: , p6_a29 out nocopy JTF_NUMBER_TABLE
267: , p6_a30 out nocopy JTF_DATE_TABLE
268: );
269: procedure lock_row(p_api_version NUMBER
270: , p_init_msg_list VARCHAR2

Line 311: , p5_a0 JTF_NUMBER_TABLE

307: , p_init_msg_list VARCHAR2
308: , x_return_status out nocopy VARCHAR2
309: , x_msg_count out nocopy NUMBER
310: , x_msg_data out nocopy VARCHAR2
311: , p5_a0 JTF_NUMBER_TABLE
312: , p5_a1 JTF_VARCHAR2_TABLE_200
313: , p5_a2 JTF_NUMBER_TABLE
314: , p5_a3 JTF_VARCHAR2_TABLE_200
315: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 313: , p5_a2 JTF_NUMBER_TABLE

309: , x_msg_count out nocopy NUMBER
310: , x_msg_data out nocopy VARCHAR2
311: , p5_a0 JTF_NUMBER_TABLE
312: , p5_a1 JTF_VARCHAR2_TABLE_200
313: , p5_a2 JTF_NUMBER_TABLE
314: , p5_a3 JTF_VARCHAR2_TABLE_200
315: , p5_a4 JTF_VARCHAR2_TABLE_600
316: , p5_a5 JTF_NUMBER_TABLE
317: , p5_a6 JTF_NUMBER_TABLE

Line 316: , p5_a5 JTF_NUMBER_TABLE

312: , p5_a1 JTF_VARCHAR2_TABLE_200
313: , p5_a2 JTF_NUMBER_TABLE
314: , p5_a3 JTF_VARCHAR2_TABLE_200
315: , p5_a4 JTF_VARCHAR2_TABLE_600
316: , p5_a5 JTF_NUMBER_TABLE
317: , p5_a6 JTF_NUMBER_TABLE
318: , p5_a7 JTF_VARCHAR2_TABLE_100
319: , p5_a8 JTF_VARCHAR2_TABLE_100
320: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 317: , p5_a6 JTF_NUMBER_TABLE

313: , p5_a2 JTF_NUMBER_TABLE
314: , p5_a3 JTF_VARCHAR2_TABLE_200
315: , p5_a4 JTF_VARCHAR2_TABLE_600
316: , p5_a5 JTF_NUMBER_TABLE
317: , p5_a6 JTF_NUMBER_TABLE
318: , p5_a7 JTF_VARCHAR2_TABLE_100
319: , p5_a8 JTF_VARCHAR2_TABLE_100
320: , p5_a9 JTF_VARCHAR2_TABLE_100
321: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 336: , p5_a25 JTF_NUMBER_TABLE

332: , p5_a21 JTF_VARCHAR2_TABLE_500
333: , p5_a22 JTF_VARCHAR2_TABLE_500
334: , p5_a23 JTF_VARCHAR2_TABLE_500
335: , p5_a24 JTF_VARCHAR2_TABLE_500
336: , p5_a25 JTF_NUMBER_TABLE
337: , p5_a26 JTF_DATE_TABLE
338: , p5_a27 JTF_NUMBER_TABLE
339: , p5_a28 JTF_DATE_TABLE
340: , p5_a29 JTF_NUMBER_TABLE

Line 338: , p5_a27 JTF_NUMBER_TABLE

334: , p5_a23 JTF_VARCHAR2_TABLE_500
335: , p5_a24 JTF_VARCHAR2_TABLE_500
336: , p5_a25 JTF_NUMBER_TABLE
337: , p5_a26 JTF_DATE_TABLE
338: , p5_a27 JTF_NUMBER_TABLE
339: , p5_a28 JTF_DATE_TABLE
340: , p5_a29 JTF_NUMBER_TABLE
341: , p5_a30 JTF_DATE_TABLE
342: );

Line 340: , p5_a29 JTF_NUMBER_TABLE

336: , p5_a25 JTF_NUMBER_TABLE
337: , p5_a26 JTF_DATE_TABLE
338: , p5_a27 JTF_NUMBER_TABLE
339: , p5_a28 JTF_DATE_TABLE
340: , p5_a29 JTF_NUMBER_TABLE
341: , p5_a30 JTF_DATE_TABLE
342: );
343: procedure update_row(p_api_version NUMBER
344: , p_init_msg_list VARCHAR2

Line 416: , p5_a0 JTF_NUMBER_TABLE

412: , p_init_msg_list VARCHAR2
413: , x_return_status out nocopy VARCHAR2
414: , x_msg_count out nocopy NUMBER
415: , x_msg_data out nocopy VARCHAR2
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_VARCHAR2_TABLE_200
418: , p5_a2 JTF_NUMBER_TABLE
419: , p5_a3 JTF_VARCHAR2_TABLE_200
420: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 418: , p5_a2 JTF_NUMBER_TABLE

414: , x_msg_count out nocopy NUMBER
415: , x_msg_data out nocopy VARCHAR2
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_VARCHAR2_TABLE_200
418: , p5_a2 JTF_NUMBER_TABLE
419: , p5_a3 JTF_VARCHAR2_TABLE_200
420: , p5_a4 JTF_VARCHAR2_TABLE_600
421: , p5_a5 JTF_NUMBER_TABLE
422: , p5_a6 JTF_NUMBER_TABLE

Line 421: , p5_a5 JTF_NUMBER_TABLE

417: , p5_a1 JTF_VARCHAR2_TABLE_200
418: , p5_a2 JTF_NUMBER_TABLE
419: , p5_a3 JTF_VARCHAR2_TABLE_200
420: , p5_a4 JTF_VARCHAR2_TABLE_600
421: , p5_a5 JTF_NUMBER_TABLE
422: , p5_a6 JTF_NUMBER_TABLE
423: , p5_a7 JTF_VARCHAR2_TABLE_100
424: , p5_a8 JTF_VARCHAR2_TABLE_100
425: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 422: , p5_a6 JTF_NUMBER_TABLE

418: , p5_a2 JTF_NUMBER_TABLE
419: , p5_a3 JTF_VARCHAR2_TABLE_200
420: , p5_a4 JTF_VARCHAR2_TABLE_600
421: , p5_a5 JTF_NUMBER_TABLE
422: , p5_a6 JTF_NUMBER_TABLE
423: , p5_a7 JTF_VARCHAR2_TABLE_100
424: , p5_a8 JTF_VARCHAR2_TABLE_100
425: , p5_a9 JTF_VARCHAR2_TABLE_100
426: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 441: , p5_a25 JTF_NUMBER_TABLE

437: , p5_a21 JTF_VARCHAR2_TABLE_500
438: , p5_a22 JTF_VARCHAR2_TABLE_500
439: , p5_a23 JTF_VARCHAR2_TABLE_500
440: , p5_a24 JTF_VARCHAR2_TABLE_500
441: , p5_a25 JTF_NUMBER_TABLE
442: , p5_a26 JTF_DATE_TABLE
443: , p5_a27 JTF_NUMBER_TABLE
444: , p5_a28 JTF_DATE_TABLE
445: , p5_a29 JTF_NUMBER_TABLE

Line 443: , p5_a27 JTF_NUMBER_TABLE

439: , p5_a23 JTF_VARCHAR2_TABLE_500
440: , p5_a24 JTF_VARCHAR2_TABLE_500
441: , p5_a25 JTF_NUMBER_TABLE
442: , p5_a26 JTF_DATE_TABLE
443: , p5_a27 JTF_NUMBER_TABLE
444: , p5_a28 JTF_DATE_TABLE
445: , p5_a29 JTF_NUMBER_TABLE
446: , p5_a30 JTF_DATE_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 445: , p5_a29 JTF_NUMBER_TABLE

441: , p5_a25 JTF_NUMBER_TABLE
442: , p5_a26 JTF_DATE_TABLE
443: , p5_a27 JTF_NUMBER_TABLE
444: , p5_a28 JTF_DATE_TABLE
445: , p5_a29 JTF_NUMBER_TABLE
446: , p5_a30 JTF_DATE_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 447: , p6_a0 out nocopy JTF_NUMBER_TABLE

443: , p5_a27 JTF_NUMBER_TABLE
444: , p5_a28 JTF_DATE_TABLE
445: , p5_a29 JTF_NUMBER_TABLE
446: , p5_a30 JTF_DATE_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a2 out nocopy JTF_NUMBER_TABLE
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600

Line 449: , p6_a2 out nocopy JTF_NUMBER_TABLE

445: , p5_a29 JTF_NUMBER_TABLE
446: , p5_a30 JTF_DATE_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a2 out nocopy JTF_NUMBER_TABLE
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
452: , p6_a5 out nocopy JTF_NUMBER_TABLE
453: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 452: , p6_a5 out nocopy JTF_NUMBER_TABLE

448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
449: , p6_a2 out nocopy JTF_NUMBER_TABLE
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
452: , p6_a5 out nocopy JTF_NUMBER_TABLE
453: , p6_a6 out nocopy JTF_NUMBER_TABLE
454: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
455: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
456: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 453: , p6_a6 out nocopy JTF_NUMBER_TABLE

449: , p6_a2 out nocopy JTF_NUMBER_TABLE
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
452: , p6_a5 out nocopy JTF_NUMBER_TABLE
453: , p6_a6 out nocopy JTF_NUMBER_TABLE
454: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
455: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
456: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
457: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 472: , p6_a25 out nocopy JTF_NUMBER_TABLE

468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
469: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
470: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
471: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
472: , p6_a25 out nocopy JTF_NUMBER_TABLE
473: , p6_a26 out nocopy JTF_DATE_TABLE
474: , p6_a27 out nocopy JTF_NUMBER_TABLE
475: , p6_a28 out nocopy JTF_DATE_TABLE
476: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 474: , p6_a27 out nocopy JTF_NUMBER_TABLE

470: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
471: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
472: , p6_a25 out nocopy JTF_NUMBER_TABLE
473: , p6_a26 out nocopy JTF_DATE_TABLE
474: , p6_a27 out nocopy JTF_NUMBER_TABLE
475: , p6_a28 out nocopy JTF_DATE_TABLE
476: , p6_a29 out nocopy JTF_NUMBER_TABLE
477: , p6_a30 out nocopy JTF_DATE_TABLE
478: );

Line 476: , p6_a29 out nocopy JTF_NUMBER_TABLE

472: , p6_a25 out nocopy JTF_NUMBER_TABLE
473: , p6_a26 out nocopy JTF_DATE_TABLE
474: , p6_a27 out nocopy JTF_NUMBER_TABLE
475: , p6_a28 out nocopy JTF_DATE_TABLE
476: , p6_a29 out nocopy JTF_NUMBER_TABLE
477: , p6_a30 out nocopy JTF_DATE_TABLE
478: );
479: procedure delete_row(p_api_version NUMBER
480: , p_init_msg_list VARCHAR2

Line 521: , p5_a0 JTF_NUMBER_TABLE

517: , p_init_msg_list VARCHAR2
518: , x_return_status out nocopy VARCHAR2
519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p5_a0 JTF_NUMBER_TABLE
522: , p5_a1 JTF_VARCHAR2_TABLE_200
523: , p5_a2 JTF_NUMBER_TABLE
524: , p5_a3 JTF_VARCHAR2_TABLE_200
525: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 523: , p5_a2 JTF_NUMBER_TABLE

519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p5_a0 JTF_NUMBER_TABLE
522: , p5_a1 JTF_VARCHAR2_TABLE_200
523: , p5_a2 JTF_NUMBER_TABLE
524: , p5_a3 JTF_VARCHAR2_TABLE_200
525: , p5_a4 JTF_VARCHAR2_TABLE_600
526: , p5_a5 JTF_NUMBER_TABLE
527: , p5_a6 JTF_NUMBER_TABLE

Line 526: , p5_a5 JTF_NUMBER_TABLE

522: , p5_a1 JTF_VARCHAR2_TABLE_200
523: , p5_a2 JTF_NUMBER_TABLE
524: , p5_a3 JTF_VARCHAR2_TABLE_200
525: , p5_a4 JTF_VARCHAR2_TABLE_600
526: , p5_a5 JTF_NUMBER_TABLE
527: , p5_a6 JTF_NUMBER_TABLE
528: , p5_a7 JTF_VARCHAR2_TABLE_100
529: , p5_a8 JTF_VARCHAR2_TABLE_100
530: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 527: , p5_a6 JTF_NUMBER_TABLE

523: , p5_a2 JTF_NUMBER_TABLE
524: , p5_a3 JTF_VARCHAR2_TABLE_200
525: , p5_a4 JTF_VARCHAR2_TABLE_600
526: , p5_a5 JTF_NUMBER_TABLE
527: , p5_a6 JTF_NUMBER_TABLE
528: , p5_a7 JTF_VARCHAR2_TABLE_100
529: , p5_a8 JTF_VARCHAR2_TABLE_100
530: , p5_a9 JTF_VARCHAR2_TABLE_100
531: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 546: , p5_a25 JTF_NUMBER_TABLE

542: , p5_a21 JTF_VARCHAR2_TABLE_500
543: , p5_a22 JTF_VARCHAR2_TABLE_500
544: , p5_a23 JTF_VARCHAR2_TABLE_500
545: , p5_a24 JTF_VARCHAR2_TABLE_500
546: , p5_a25 JTF_NUMBER_TABLE
547: , p5_a26 JTF_DATE_TABLE
548: , p5_a27 JTF_NUMBER_TABLE
549: , p5_a28 JTF_DATE_TABLE
550: , p5_a29 JTF_NUMBER_TABLE

Line 548: , p5_a27 JTF_NUMBER_TABLE

544: , p5_a23 JTF_VARCHAR2_TABLE_500
545: , p5_a24 JTF_VARCHAR2_TABLE_500
546: , p5_a25 JTF_NUMBER_TABLE
547: , p5_a26 JTF_DATE_TABLE
548: , p5_a27 JTF_NUMBER_TABLE
549: , p5_a28 JTF_DATE_TABLE
550: , p5_a29 JTF_NUMBER_TABLE
551: , p5_a30 JTF_DATE_TABLE
552: );

Line 550: , p5_a29 JTF_NUMBER_TABLE

546: , p5_a25 JTF_NUMBER_TABLE
547: , p5_a26 JTF_DATE_TABLE
548: , p5_a27 JTF_NUMBER_TABLE
549: , p5_a28 JTF_DATE_TABLE
550: , p5_a29 JTF_NUMBER_TABLE
551: , p5_a30 JTF_DATE_TABLE
552: );
553: procedure validate_row(p_api_version NUMBER
554: , p_init_msg_list VARCHAR2

Line 595: , p5_a0 JTF_NUMBER_TABLE

591: , p_init_msg_list VARCHAR2
592: , x_return_status out nocopy VARCHAR2
593: , x_msg_count out nocopy NUMBER
594: , x_msg_data out nocopy VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_VARCHAR2_TABLE_200
597: , p5_a2 JTF_NUMBER_TABLE
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_VARCHAR2_TABLE_600

Line 597: , p5_a2 JTF_NUMBER_TABLE

593: , x_msg_count out nocopy NUMBER
594: , x_msg_data out nocopy VARCHAR2
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_VARCHAR2_TABLE_200
597: , p5_a2 JTF_NUMBER_TABLE
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_VARCHAR2_TABLE_600
600: , p5_a5 JTF_NUMBER_TABLE
601: , p5_a6 JTF_NUMBER_TABLE

Line 600: , p5_a5 JTF_NUMBER_TABLE

596: , p5_a1 JTF_VARCHAR2_TABLE_200
597: , p5_a2 JTF_NUMBER_TABLE
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_VARCHAR2_TABLE_600
600: , p5_a5 JTF_NUMBER_TABLE
601: , p5_a6 JTF_NUMBER_TABLE
602: , p5_a7 JTF_VARCHAR2_TABLE_100
603: , p5_a8 JTF_VARCHAR2_TABLE_100
604: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 601: , p5_a6 JTF_NUMBER_TABLE

597: , p5_a2 JTF_NUMBER_TABLE
598: , p5_a3 JTF_VARCHAR2_TABLE_200
599: , p5_a4 JTF_VARCHAR2_TABLE_600
600: , p5_a5 JTF_NUMBER_TABLE
601: , p5_a6 JTF_NUMBER_TABLE
602: , p5_a7 JTF_VARCHAR2_TABLE_100
603: , p5_a8 JTF_VARCHAR2_TABLE_100
604: , p5_a9 JTF_VARCHAR2_TABLE_100
605: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 620: , p5_a25 JTF_NUMBER_TABLE

616: , p5_a21 JTF_VARCHAR2_TABLE_500
617: , p5_a22 JTF_VARCHAR2_TABLE_500
618: , p5_a23 JTF_VARCHAR2_TABLE_500
619: , p5_a24 JTF_VARCHAR2_TABLE_500
620: , p5_a25 JTF_NUMBER_TABLE
621: , p5_a26 JTF_DATE_TABLE
622: , p5_a27 JTF_NUMBER_TABLE
623: , p5_a28 JTF_DATE_TABLE
624: , p5_a29 JTF_NUMBER_TABLE

Line 622: , p5_a27 JTF_NUMBER_TABLE

618: , p5_a23 JTF_VARCHAR2_TABLE_500
619: , p5_a24 JTF_VARCHAR2_TABLE_500
620: , p5_a25 JTF_NUMBER_TABLE
621: , p5_a26 JTF_DATE_TABLE
622: , p5_a27 JTF_NUMBER_TABLE
623: , p5_a28 JTF_DATE_TABLE
624: , p5_a29 JTF_NUMBER_TABLE
625: , p5_a30 JTF_DATE_TABLE
626: );

Line 624: , p5_a29 JTF_NUMBER_TABLE

620: , p5_a25 JTF_NUMBER_TABLE
621: , p5_a26 JTF_DATE_TABLE
622: , p5_a27 JTF_NUMBER_TABLE
623: , p5_a28 JTF_DATE_TABLE
624: , p5_a29 JTF_NUMBER_TABLE
625: , p5_a30 JTF_DATE_TABLE
626: );
627: end okl_mst_pvt_w;