APPS.OKL_SGT_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sgt_pvt.sgnv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_sgt_pvt_w as
2: /* $Header: OKLISGTS.pls 120.1 2005/07/14 11:59:43 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sgt_pvt.sgnv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_400
7: , a4 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_NUMBER_TABLE

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

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_VARCHAR2_TABLE_300
26: , a23 JTF_VARCHAR2_TABLE_300
27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_300
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE

Line 31: , a28 JTF_NUMBER_TABLE

27: , a24 JTF_VARCHAR2_TABLE_300
28: , a25 JTF_VARCHAR2_TABLE_300
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 33: , a30 JTF_NUMBER_TABLE

29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_sgt_pvt.sgnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_100
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_400
39: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 41: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 61: , a26 out nocopy JTF_NUMBER_TABLE

57: , a22 out nocopy JTF_VARCHAR2_TABLE_300
58: , a23 out nocopy JTF_VARCHAR2_TABLE_300
59: , a24 out nocopy JTF_VARCHAR2_TABLE_300
60: , a25 out nocopy JTF_VARCHAR2_TABLE_300
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE

Line 63: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 65: , a30 out nocopy JTF_NUMBER_TABLE

61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sgt_pvt.sgt_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_VARCHAR2_TABLE_100

Line 68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sgt_pvt.sgt_tbl_type, a0 JTF_NUMBER_TABLE

64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_sgt_pvt.sgt_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_VARCHAR2_TABLE_100
70: , a2 JTF_VARCHAR2_TABLE_100
71: , a3 JTF_VARCHAR2_TABLE_400
72: , a4 JTF_VARCHAR2_TABLE_100

Line 74: , a6 JTF_NUMBER_TABLE

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

Line 94: , a26 JTF_NUMBER_TABLE

90: , a22 JTF_VARCHAR2_TABLE_300
91: , a23 JTF_VARCHAR2_TABLE_300
92: , a24 JTF_VARCHAR2_TABLE_300
93: , a25 JTF_VARCHAR2_TABLE_300
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE

Line 96: , a28 JTF_NUMBER_TABLE

92: , a24 JTF_VARCHAR2_TABLE_300
93: , a25 JTF_VARCHAR2_TABLE_300
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 98: , a30 JTF_NUMBER_TABLE

94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 100: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_sgt_pvt.sgt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , a2 out nocopy JTF_VARCHAR2_TABLE_100
103: , a3 out nocopy JTF_VARCHAR2_TABLE_400
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 106: , a6 out nocopy JTF_NUMBER_TABLE

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

Line 126: , a26 out nocopy JTF_NUMBER_TABLE

122: , a22 out nocopy JTF_VARCHAR2_TABLE_300
123: , a23 out nocopy JTF_VARCHAR2_TABLE_300
124: , a24 out nocopy JTF_VARCHAR2_TABLE_300
125: , a25 out nocopy JTF_VARCHAR2_TABLE_300
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE

Line 128: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 130: , a30 out nocopy JTF_NUMBER_TABLE

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

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_100
208: , p5_a2 JTF_VARCHAR2_TABLE_100
209: , p5_a3 JTF_VARCHAR2_TABLE_400
210: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 212: , p5_a6 JTF_NUMBER_TABLE

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

Line 232: , p5_a26 JTF_NUMBER_TABLE

228: , p5_a22 JTF_VARCHAR2_TABLE_300
229: , p5_a23 JTF_VARCHAR2_TABLE_300
230: , p5_a24 JTF_VARCHAR2_TABLE_300
231: , p5_a25 JTF_VARCHAR2_TABLE_300
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE

Line 234: , p5_a28 JTF_NUMBER_TABLE

230: , p5_a24 JTF_VARCHAR2_TABLE_300
231: , p5_a25 JTF_VARCHAR2_TABLE_300
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 236: , p5_a30 JTF_NUMBER_TABLE

232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400

Line 237: , p6_a0 out nocopy JTF_NUMBER_TABLE

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

Line 243: , p6_a6 out nocopy JTF_NUMBER_TABLE

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

Line 263: , p6_a26 out nocopy JTF_NUMBER_TABLE

259: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
260: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
261: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
262: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 265: , p6_a28 out nocopy JTF_NUMBER_TABLE

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

Line 267: , p6_a30 out nocopy JTF_NUMBER_TABLE

263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: );
269: procedure lock_row(p_api_version NUMBER
270: , p_init_msg_list VARCHAR2
271: , x_return_status out nocopy 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_100
313: , p5_a2 JTF_VARCHAR2_TABLE_100
314: , p5_a3 JTF_VARCHAR2_TABLE_400
315: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 317: , p5_a6 JTF_NUMBER_TABLE

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

Line 337: , p5_a26 JTF_NUMBER_TABLE

333: , p5_a22 JTF_VARCHAR2_TABLE_300
334: , p5_a23 JTF_VARCHAR2_TABLE_300
335: , p5_a24 JTF_VARCHAR2_TABLE_300
336: , p5_a25 JTF_VARCHAR2_TABLE_300
337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
340: , p5_a29 JTF_DATE_TABLE
341: , p5_a30 JTF_NUMBER_TABLE

Line 339: , p5_a28 JTF_NUMBER_TABLE

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

Line 341: , p5_a30 JTF_NUMBER_TABLE

337: , p5_a26 JTF_NUMBER_TABLE
338: , p5_a27 JTF_DATE_TABLE
339: , p5_a28 JTF_NUMBER_TABLE
340: , p5_a29 JTF_DATE_TABLE
341: , p5_a30 JTF_NUMBER_TABLE
342: );
343: procedure update_row(p_api_version NUMBER
344: , p_init_msg_list VARCHAR2
345: , x_return_status out nocopy 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_100
418: , p5_a2 JTF_VARCHAR2_TABLE_100
419: , p5_a3 JTF_VARCHAR2_TABLE_400
420: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 422: , p5_a6 JTF_NUMBER_TABLE

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

Line 442: , p5_a26 JTF_NUMBER_TABLE

438: , p5_a22 JTF_VARCHAR2_TABLE_300
439: , p5_a23 JTF_VARCHAR2_TABLE_300
440: , p5_a24 JTF_VARCHAR2_TABLE_300
441: , p5_a25 JTF_VARCHAR2_TABLE_300
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE

Line 444: , p5_a28 JTF_NUMBER_TABLE

440: , p5_a24 JTF_VARCHAR2_TABLE_300
441: , p5_a25 JTF_VARCHAR2_TABLE_300
442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 446: , p5_a30 JTF_NUMBER_TABLE

442: , p5_a26 JTF_NUMBER_TABLE
443: , p5_a27 JTF_DATE_TABLE
444: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a29 JTF_DATE_TABLE
446: , p5_a30 JTF_NUMBER_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
449: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400

Line 447: , p6_a0 out nocopy JTF_NUMBER_TABLE

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

Line 453: , p6_a6 out nocopy JTF_NUMBER_TABLE

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

Line 473: , p6_a26 out nocopy JTF_NUMBER_TABLE

469: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
470: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
471: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
472: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
476: , p6_a29 out nocopy JTF_DATE_TABLE
477: , p6_a30 out nocopy JTF_NUMBER_TABLE

Line 475: , p6_a28 out nocopy JTF_NUMBER_TABLE

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

Line 477: , p6_a30 out nocopy JTF_NUMBER_TABLE

473: , p6_a26 out nocopy JTF_NUMBER_TABLE
474: , p6_a27 out nocopy JTF_DATE_TABLE
475: , p6_a28 out nocopy JTF_NUMBER_TABLE
476: , p6_a29 out nocopy JTF_DATE_TABLE
477: , p6_a30 out nocopy JTF_NUMBER_TABLE
478: );
479: procedure delete_row(p_api_version NUMBER
480: , p_init_msg_list VARCHAR2
481: , x_return_status out nocopy 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_100
523: , p5_a2 JTF_VARCHAR2_TABLE_100
524: , p5_a3 JTF_VARCHAR2_TABLE_400
525: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 527: , p5_a6 JTF_NUMBER_TABLE

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

Line 547: , p5_a26 JTF_NUMBER_TABLE

543: , p5_a22 JTF_VARCHAR2_TABLE_300
544: , p5_a23 JTF_VARCHAR2_TABLE_300
545: , p5_a24 JTF_VARCHAR2_TABLE_300
546: , p5_a25 JTF_VARCHAR2_TABLE_300
547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
550: , p5_a29 JTF_DATE_TABLE
551: , p5_a30 JTF_NUMBER_TABLE

Line 549: , p5_a28 JTF_NUMBER_TABLE

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

Line 551: , p5_a30 JTF_NUMBER_TABLE

547: , p5_a26 JTF_NUMBER_TABLE
548: , p5_a27 JTF_DATE_TABLE
549: , p5_a28 JTF_NUMBER_TABLE
550: , p5_a29 JTF_DATE_TABLE
551: , p5_a30 JTF_NUMBER_TABLE
552: );
553: procedure validate_row(p_api_version NUMBER
554: , p_init_msg_list VARCHAR2
555: , x_return_status out nocopy 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_100
597: , p5_a2 JTF_VARCHAR2_TABLE_100
598: , p5_a3 JTF_VARCHAR2_TABLE_400
599: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 601: , p5_a6 JTF_NUMBER_TABLE

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

Line 621: , p5_a26 JTF_NUMBER_TABLE

617: , p5_a22 JTF_VARCHAR2_TABLE_300
618: , p5_a23 JTF_VARCHAR2_TABLE_300
619: , p5_a24 JTF_VARCHAR2_TABLE_300
620: , p5_a25 JTF_VARCHAR2_TABLE_300
621: , p5_a26 JTF_NUMBER_TABLE
622: , p5_a27 JTF_DATE_TABLE
623: , p5_a28 JTF_NUMBER_TABLE
624: , p5_a29 JTF_DATE_TABLE
625: , p5_a30 JTF_NUMBER_TABLE

Line 623: , p5_a28 JTF_NUMBER_TABLE

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

Line 625: , p5_a30 JTF_NUMBER_TABLE

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