APPS.OKL_SRM_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srm_pvt.srm_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_srm_pvt_w as
2: /* $Header: OKLISRMS.pls 120.1 2005/07/15 07:39:05 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srm_pvt.srm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_1000

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_srm_pvt_w as
2: /* $Header: OKLISRMS.pls 120.1 2005/07/15 07:39:05 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srm_pvt.srm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_1000
8: , a5 JTF_VARCHAR2_TABLE_200

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE

Line 27: , a24 JTF_NUMBER_TABLE

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

Line 28: , a25 JTF_NUMBER_TABLE

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

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

29: , a26 JTF_DATE_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

Line 34: , a1 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 56: , a23 out nocopy JTF_NUMBER_TABLE

52: , a19 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE

Line 57: , a24 out nocopy JTF_NUMBER_TABLE

53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE

Line 58: , a25 out nocopy JTF_NUMBER_TABLE

54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );

Line 61: , a28 out nocopy JTF_NUMBER_TABLE

57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_100

Line 64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE

60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_100
66: , a2 JTF_VARCHAR2_TABLE_2000
67: , a3 JTF_VARCHAR2_TABLE_200
68: , a4 JTF_VARCHAR2_TABLE_1000

Line 69: , a5 JTF_NUMBER_TABLE

65: , a1 JTF_VARCHAR2_TABLE_100
66: , a2 JTF_VARCHAR2_TABLE_2000
67: , a3 JTF_VARCHAR2_TABLE_200
68: , a4 JTF_VARCHAR2_TABLE_1000
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_VARCHAR2_TABLE_300
71: , a7 JTF_VARCHAR2_TABLE_100
72: , a8 JTF_VARCHAR2_TABLE_500
73: , a9 JTF_VARCHAR2_TABLE_500

Line 87: , a23 JTF_NUMBER_TABLE

83: , a19 JTF_VARCHAR2_TABLE_500
84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE

Line 88: , a24 JTF_NUMBER_TABLE

84: , a20 JTF_VARCHAR2_TABLE_500
85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE

Line 89: , a25 JTF_NUMBER_TABLE

85: , a21 JTF_VARCHAR2_TABLE_500
86: , a22 JTF_VARCHAR2_TABLE_500
87: , a23 JTF_NUMBER_TABLE
88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );

Line 92: , a28 JTF_NUMBER_TABLE

88: , a24 JTF_NUMBER_TABLE
89: , a25 JTF_NUMBER_TABLE
90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000

Line 94: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

90: , a26 JTF_DATE_TABLE
91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_200
98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

Line 99: , a5 out nocopy JTF_NUMBER_TABLE

95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_200
98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
99: , a5 out nocopy JTF_NUMBER_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_300
101: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500
103: , a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 117: , a23 out nocopy JTF_NUMBER_TABLE

113: , a19 out nocopy JTF_VARCHAR2_TABLE_500
114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE

Line 118: , a24 out nocopy JTF_NUMBER_TABLE

114: , a20 out nocopy JTF_VARCHAR2_TABLE_500
115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE

Line 119: , a25 out nocopy JTF_NUMBER_TABLE

115: , a21 out nocopy JTF_VARCHAR2_TABLE_500
116: , a22 out nocopy JTF_VARCHAR2_TABLE_500
117: , a23 out nocopy JTF_NUMBER_TABLE
118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );

Line 122: , a28 out nocopy JTF_NUMBER_TABLE

118: , a24 out nocopy JTF_NUMBER_TABLE
119: , a25 out nocopy JTF_NUMBER_TABLE
120: , a26 out nocopy JTF_DATE_TABLE
121: , a27 out nocopy JTF_DATE_TABLE
122: , a28 out nocopy JTF_NUMBER_TABLE
123: );
124:
125: procedure insert_row(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2

Line 194: , p5_a0 JTF_NUMBER_TABLE

190: , p_init_msg_list VARCHAR2
191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_VARCHAR2_TABLE_100
196: , p5_a2 JTF_VARCHAR2_TABLE_2000
197: , p5_a3 JTF_VARCHAR2_TABLE_200
198: , p5_a4 JTF_VARCHAR2_TABLE_1000

Line 199: , p5_a5 JTF_NUMBER_TABLE

195: , p5_a1 JTF_VARCHAR2_TABLE_100
196: , p5_a2 JTF_VARCHAR2_TABLE_2000
197: , p5_a3 JTF_VARCHAR2_TABLE_200
198: , p5_a4 JTF_VARCHAR2_TABLE_1000
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_300
201: , p5_a7 JTF_VARCHAR2_TABLE_100
202: , p5_a8 JTF_VARCHAR2_TABLE_500
203: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 217: , p5_a23 JTF_NUMBER_TABLE

213: , p5_a19 JTF_VARCHAR2_TABLE_500
214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE

Line 218: , p5_a24 JTF_NUMBER_TABLE

214: , p5_a20 JTF_VARCHAR2_TABLE_500
215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE

Line 219: , p5_a25 JTF_NUMBER_TABLE

215: , p5_a21 JTF_VARCHAR2_TABLE_500
216: , p5_a22 JTF_VARCHAR2_TABLE_500
217: , p5_a23 JTF_NUMBER_TABLE
218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 222: , p5_a28 JTF_NUMBER_TABLE

218: , p5_a24 JTF_NUMBER_TABLE
219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 223: , p6_a0 out nocopy JTF_NUMBER_TABLE

219: , p5_a25 JTF_NUMBER_TABLE
220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000

Line 228: , p6_a5 out nocopy JTF_NUMBER_TABLE

224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
228: , p6_a5 out nocopy JTF_NUMBER_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 246: , p6_a23 out nocopy JTF_NUMBER_TABLE

242: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE

Line 247: , p6_a24 out nocopy JTF_NUMBER_TABLE

243: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 248: , p6_a25 out nocopy JTF_NUMBER_TABLE

244: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
246: , p6_a23 out nocopy JTF_NUMBER_TABLE
247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );

Line 251: , p6_a28 out nocopy JTF_NUMBER_TABLE

247: , p6_a24 out nocopy JTF_NUMBER_TABLE
248: , p6_a25 out nocopy JTF_NUMBER_TABLE
249: , p6_a26 out nocopy JTF_DATE_TABLE
250: , p6_a27 out nocopy JTF_DATE_TABLE
251: , p6_a28 out nocopy JTF_NUMBER_TABLE
252: );
253: procedure lock_row(p_api_version NUMBER
254: , p_init_msg_list VARCHAR2
255: , x_return_status out nocopy VARCHAR2

Line 293: , p5_a0 JTF_NUMBER_TABLE

289: , p_init_msg_list VARCHAR2
290: , x_return_status out nocopy VARCHAR2
291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2
293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_100
295: , p5_a2 JTF_VARCHAR2_TABLE_2000
296: , p5_a3 JTF_VARCHAR2_TABLE_200
297: , p5_a4 JTF_VARCHAR2_TABLE_1000

Line 298: , p5_a5 JTF_NUMBER_TABLE

294: , p5_a1 JTF_VARCHAR2_TABLE_100
295: , p5_a2 JTF_VARCHAR2_TABLE_2000
296: , p5_a3 JTF_VARCHAR2_TABLE_200
297: , p5_a4 JTF_VARCHAR2_TABLE_1000
298: , p5_a5 JTF_NUMBER_TABLE
299: , p5_a6 JTF_VARCHAR2_TABLE_300
300: , p5_a7 JTF_VARCHAR2_TABLE_100
301: , p5_a8 JTF_VARCHAR2_TABLE_500
302: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 316: , p5_a23 JTF_NUMBER_TABLE

312: , p5_a19 JTF_VARCHAR2_TABLE_500
313: , p5_a20 JTF_VARCHAR2_TABLE_500
314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE

Line 317: , p5_a24 JTF_NUMBER_TABLE

313: , p5_a20 JTF_VARCHAR2_TABLE_500
314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE

Line 318: , p5_a25 JTF_NUMBER_TABLE

314: , p5_a21 JTF_VARCHAR2_TABLE_500
315: , p5_a22 JTF_VARCHAR2_TABLE_500
316: , p5_a23 JTF_NUMBER_TABLE
317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE
322: );

Line 321: , p5_a28 JTF_NUMBER_TABLE

317: , p5_a24 JTF_NUMBER_TABLE
318: , p5_a25 JTF_NUMBER_TABLE
319: , p5_a26 JTF_DATE_TABLE
320: , p5_a27 JTF_DATE_TABLE
321: , p5_a28 JTF_NUMBER_TABLE
322: );
323: procedure update_row(p_api_version NUMBER
324: , p_init_msg_list VARCHAR2
325: , x_return_status out nocopy VARCHAR2

Line 392: , p5_a0 JTF_NUMBER_TABLE

388: , p_init_msg_list VARCHAR2
389: , x_return_status out nocopy VARCHAR2
390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_VARCHAR2_TABLE_100
394: , p5_a2 JTF_VARCHAR2_TABLE_2000
395: , p5_a3 JTF_VARCHAR2_TABLE_200
396: , p5_a4 JTF_VARCHAR2_TABLE_1000

Line 397: , p5_a5 JTF_NUMBER_TABLE

393: , p5_a1 JTF_VARCHAR2_TABLE_100
394: , p5_a2 JTF_VARCHAR2_TABLE_2000
395: , p5_a3 JTF_VARCHAR2_TABLE_200
396: , p5_a4 JTF_VARCHAR2_TABLE_1000
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_VARCHAR2_TABLE_300
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_VARCHAR2_TABLE_500
401: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 415: , p5_a23 JTF_NUMBER_TABLE

411: , p5_a19 JTF_VARCHAR2_TABLE_500
412: , p5_a20 JTF_VARCHAR2_TABLE_500
413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE

Line 416: , p5_a24 JTF_NUMBER_TABLE

412: , p5_a20 JTF_VARCHAR2_TABLE_500
413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE

Line 417: , p5_a25 JTF_NUMBER_TABLE

413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_NUMBER_TABLE
416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 420: , p5_a28 JTF_NUMBER_TABLE

416: , p5_a24 JTF_NUMBER_TABLE
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

Line 421: , p6_a0 out nocopy JTF_NUMBER_TABLE

417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000

Line 426: , p6_a5 out nocopy JTF_NUMBER_TABLE

422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
426: , p6_a5 out nocopy JTF_NUMBER_TABLE
427: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
428: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 444: , p6_a23 out nocopy JTF_NUMBER_TABLE

440: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
441: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE

Line 445: , p6_a24 out nocopy JTF_NUMBER_TABLE

441: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE

Line 446: , p6_a25 out nocopy JTF_NUMBER_TABLE

442: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
443: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
444: , p6_a23 out nocopy JTF_NUMBER_TABLE
445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE
450: );

Line 449: , p6_a28 out nocopy JTF_NUMBER_TABLE

445: , p6_a24 out nocopy JTF_NUMBER_TABLE
446: , p6_a25 out nocopy JTF_NUMBER_TABLE
447: , p6_a26 out nocopy JTF_DATE_TABLE
448: , p6_a27 out nocopy JTF_DATE_TABLE
449: , p6_a28 out nocopy JTF_NUMBER_TABLE
450: );
451: procedure delete_row(p_api_version NUMBER
452: , p_init_msg_list VARCHAR2
453: , x_return_status out nocopy VARCHAR2

Line 491: , p5_a0 JTF_NUMBER_TABLE

487: , p_init_msg_list VARCHAR2
488: , x_return_status out nocopy VARCHAR2
489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_100
493: , p5_a2 JTF_VARCHAR2_TABLE_2000
494: , p5_a3 JTF_VARCHAR2_TABLE_200
495: , p5_a4 JTF_VARCHAR2_TABLE_1000

Line 496: , p5_a5 JTF_NUMBER_TABLE

492: , p5_a1 JTF_VARCHAR2_TABLE_100
493: , p5_a2 JTF_VARCHAR2_TABLE_2000
494: , p5_a3 JTF_VARCHAR2_TABLE_200
495: , p5_a4 JTF_VARCHAR2_TABLE_1000
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_VARCHAR2_TABLE_300
498: , p5_a7 JTF_VARCHAR2_TABLE_100
499: , p5_a8 JTF_VARCHAR2_TABLE_500
500: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 514: , p5_a23 JTF_NUMBER_TABLE

510: , p5_a19 JTF_VARCHAR2_TABLE_500
511: , p5_a20 JTF_VARCHAR2_TABLE_500
512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE

Line 515: , p5_a24 JTF_NUMBER_TABLE

511: , p5_a20 JTF_VARCHAR2_TABLE_500
512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE

Line 516: , p5_a25 JTF_NUMBER_TABLE

512: , p5_a21 JTF_VARCHAR2_TABLE_500
513: , p5_a22 JTF_VARCHAR2_TABLE_500
514: , p5_a23 JTF_NUMBER_TABLE
515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: );

Line 519: , p5_a28 JTF_NUMBER_TABLE

515: , p5_a24 JTF_NUMBER_TABLE
516: , p5_a25 JTF_NUMBER_TABLE
517: , p5_a26 JTF_DATE_TABLE
518: , p5_a27 JTF_DATE_TABLE
519: , p5_a28 JTF_NUMBER_TABLE
520: );
521: procedure validate_row(p_api_version NUMBER
522: , p_init_msg_list VARCHAR2
523: , x_return_status out nocopy VARCHAR2

Line 561: , p5_a0 JTF_NUMBER_TABLE

557: , p_init_msg_list VARCHAR2
558: , x_return_status out nocopy VARCHAR2
559: , x_msg_count out nocopy NUMBER
560: , x_msg_data out nocopy VARCHAR2
561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_100
563: , p5_a2 JTF_VARCHAR2_TABLE_2000
564: , p5_a3 JTF_VARCHAR2_TABLE_200
565: , p5_a4 JTF_VARCHAR2_TABLE_1000

Line 566: , p5_a5 JTF_NUMBER_TABLE

562: , p5_a1 JTF_VARCHAR2_TABLE_100
563: , p5_a2 JTF_VARCHAR2_TABLE_2000
564: , p5_a3 JTF_VARCHAR2_TABLE_200
565: , p5_a4 JTF_VARCHAR2_TABLE_1000
566: , p5_a5 JTF_NUMBER_TABLE
567: , p5_a6 JTF_VARCHAR2_TABLE_300
568: , p5_a7 JTF_VARCHAR2_TABLE_100
569: , p5_a8 JTF_VARCHAR2_TABLE_500
570: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 584: , p5_a23 JTF_NUMBER_TABLE

580: , p5_a19 JTF_VARCHAR2_TABLE_500
581: , p5_a20 JTF_VARCHAR2_TABLE_500
582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE

Line 585: , p5_a24 JTF_NUMBER_TABLE

581: , p5_a20 JTF_VARCHAR2_TABLE_500
582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE

Line 586: , p5_a25 JTF_NUMBER_TABLE

582: , p5_a21 JTF_VARCHAR2_TABLE_500
583: , p5_a22 JTF_VARCHAR2_TABLE_500
584: , p5_a23 JTF_NUMBER_TABLE
585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE
590: );

Line 589: , p5_a28 JTF_NUMBER_TABLE

585: , p5_a24 JTF_NUMBER_TABLE
586: , p5_a25 JTF_NUMBER_TABLE
587: , p5_a26 JTF_DATE_TABLE
588: , p5_a27 JTF_DATE_TABLE
589: , p5_a28 JTF_NUMBER_TABLE
590: );
591: end okl_srm_pvt_w;