APPS.OKL_SPP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_spp_pvt.spp_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_spp_pvt_w as
2: /* $Header: OKLISPPS.pls 120.1 2005/07/15 07:38:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_spp_pvt.spp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package okl_spp_pvt_w as
2: /* $Header: OKLISPPS.pls 120.1 2005/07/15 07:38:49 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_spp_pvt.spp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

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

Line 31: , a28 JTF_NUMBER_TABLE

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

Line 34: , a31 JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 36: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

32: , a29 JTF_DATE_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_200
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_DATE_TABLE

Line 37: , a1 out nocopy JTF_NUMBER_TABLE

33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_spp_pvt.spp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_VARCHAR2_TABLE_200
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_DATE_TABLE

Line 63: , a27 out nocopy JTF_NUMBER_TABLE

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

Line 64: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 67: , a31 out nocopy JTF_NUMBER_TABLE

63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_NUMBER_TABLE
65: , a29 out nocopy JTF_DATE_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE

Line 70: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE

66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_VARCHAR2_TABLE_200
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_DATE_TABLE

Line 71: , a1 JTF_NUMBER_TABLE

67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_spp_pvt.sppv_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_NUMBER_TABLE
72: , a2 JTF_VARCHAR2_TABLE_200
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_DATE_TABLE
75: , a5 JTF_DATE_TABLE

Line 97: , a27 JTF_NUMBER_TABLE

93: , a23 JTF_VARCHAR2_TABLE_500
94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_VARCHAR2_TABLE_500
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE

Line 98: , a28 JTF_NUMBER_TABLE

94: , a24 JTF_VARCHAR2_TABLE_500
95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_VARCHAR2_TABLE_500
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE
102: );

Line 101: , a31 JTF_NUMBER_TABLE

97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_NUMBER_TABLE
99: , a29 JTF_DATE_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 103: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

99: , a29 JTF_DATE_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE

Line 104: , a1 out nocopy JTF_NUMBER_TABLE

100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_spp_pvt.sppv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_NUMBER_TABLE
105: , a2 out nocopy JTF_VARCHAR2_TABLE_200
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_DATE_TABLE
108: , a5 out nocopy JTF_DATE_TABLE

Line 130: , a27 out nocopy JTF_NUMBER_TABLE

126: , a23 out nocopy JTF_VARCHAR2_TABLE_500
127: , a24 out nocopy JTF_VARCHAR2_TABLE_500
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE

Line 131: , a28 out nocopy JTF_NUMBER_TABLE

127: , a24 out nocopy JTF_VARCHAR2_TABLE_500
128: , a25 out nocopy JTF_VARCHAR2_TABLE_500
129: , a26 out nocopy JTF_VARCHAR2_TABLE_500
130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: );

Line 134: , a31 out nocopy JTF_NUMBER_TABLE

130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_NUMBER_TABLE
132: , a29 out nocopy JTF_DATE_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: );
136:
137: procedure insert_row(p_api_version NUMBER
138: , p_init_msg_list VARCHAR2

Line 212: , p5_a0 JTF_NUMBER_TABLE

208: , p_init_msg_list VARCHAR2
209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_200
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_DATE_TABLE

Line 213: , p5_a1 JTF_NUMBER_TABLE

209: , x_return_status out nocopy VARCHAR2
210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_NUMBER_TABLE
214: , p5_a2 JTF_VARCHAR2_TABLE_200
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_DATE_TABLE
217: , p5_a5 JTF_DATE_TABLE

Line 239: , p5_a27 JTF_NUMBER_TABLE

235: , p5_a23 JTF_VARCHAR2_TABLE_500
236: , p5_a24 JTF_VARCHAR2_TABLE_500
237: , p5_a25 JTF_VARCHAR2_TABLE_500
238: , p5_a26 JTF_VARCHAR2_TABLE_500
239: , p5_a27 JTF_NUMBER_TABLE
240: , p5_a28 JTF_NUMBER_TABLE
241: , p5_a29 JTF_DATE_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE

Line 240: , p5_a28 JTF_NUMBER_TABLE

236: , p5_a24 JTF_VARCHAR2_TABLE_500
237: , p5_a25 JTF_VARCHAR2_TABLE_500
238: , p5_a26 JTF_VARCHAR2_TABLE_500
239: , p5_a27 JTF_NUMBER_TABLE
240: , p5_a28 JTF_NUMBER_TABLE
241: , p5_a29 JTF_DATE_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE
244: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 243: , p5_a31 JTF_NUMBER_TABLE

239: , p5_a27 JTF_NUMBER_TABLE
240: , p5_a28 JTF_NUMBER_TABLE
241: , p5_a29 JTF_DATE_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 244: , p6_a0 out nocopy JTF_NUMBER_TABLE

240: , p5_a28 JTF_NUMBER_TABLE
241: , p5_a29 JTF_DATE_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_DATE_TABLE

Line 245: , p6_a1 out nocopy JTF_NUMBER_TABLE

241: , p5_a29 JTF_DATE_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE
244: , p6_a0 out nocopy JTF_NUMBER_TABLE
245: , p6_a1 out nocopy JTF_NUMBER_TABLE
246: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_DATE_TABLE
249: , p6_a5 out nocopy JTF_DATE_TABLE

Line 271: , p6_a27 out nocopy JTF_NUMBER_TABLE

267: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a27 out nocopy JTF_NUMBER_TABLE
272: , p6_a28 out nocopy JTF_NUMBER_TABLE
273: , p6_a29 out nocopy JTF_DATE_TABLE
274: , p6_a30 out nocopy JTF_DATE_TABLE
275: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 272: , p6_a28 out nocopy JTF_NUMBER_TABLE

268: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a27 out nocopy JTF_NUMBER_TABLE
272: , p6_a28 out nocopy JTF_NUMBER_TABLE
273: , p6_a29 out nocopy JTF_DATE_TABLE
274: , p6_a30 out nocopy JTF_DATE_TABLE
275: , p6_a31 out nocopy JTF_NUMBER_TABLE
276: );

Line 275: , p6_a31 out nocopy JTF_NUMBER_TABLE

271: , p6_a27 out nocopy JTF_NUMBER_TABLE
272: , p6_a28 out nocopy JTF_NUMBER_TABLE
273: , p6_a29 out nocopy JTF_DATE_TABLE
274: , p6_a30 out nocopy JTF_DATE_TABLE
275: , p6_a31 out nocopy JTF_NUMBER_TABLE
276: );
277: procedure lock_row(p_api_version NUMBER
278: , p_init_msg_list VARCHAR2
279: , x_return_status out nocopy VARCHAR2

Line 320: , p5_a0 JTF_NUMBER_TABLE

316: , p_init_msg_list VARCHAR2
317: , x_return_status out nocopy VARCHAR2
318: , x_msg_count out nocopy NUMBER
319: , x_msg_data out nocopy VARCHAR2
320: , p5_a0 JTF_NUMBER_TABLE
321: , p5_a1 JTF_NUMBER_TABLE
322: , p5_a2 JTF_VARCHAR2_TABLE_200
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_DATE_TABLE

Line 321: , p5_a1 JTF_NUMBER_TABLE

317: , x_return_status out nocopy VARCHAR2
318: , x_msg_count out nocopy NUMBER
319: , x_msg_data out nocopy VARCHAR2
320: , p5_a0 JTF_NUMBER_TABLE
321: , p5_a1 JTF_NUMBER_TABLE
322: , p5_a2 JTF_VARCHAR2_TABLE_200
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_DATE_TABLE
325: , p5_a5 JTF_DATE_TABLE

Line 347: , p5_a27 JTF_NUMBER_TABLE

343: , p5_a23 JTF_VARCHAR2_TABLE_500
344: , p5_a24 JTF_VARCHAR2_TABLE_500
345: , p5_a25 JTF_VARCHAR2_TABLE_500
346: , p5_a26 JTF_VARCHAR2_TABLE_500
347: , p5_a27 JTF_NUMBER_TABLE
348: , p5_a28 JTF_NUMBER_TABLE
349: , p5_a29 JTF_DATE_TABLE
350: , p5_a30 JTF_DATE_TABLE
351: , p5_a31 JTF_NUMBER_TABLE

Line 348: , p5_a28 JTF_NUMBER_TABLE

344: , p5_a24 JTF_VARCHAR2_TABLE_500
345: , p5_a25 JTF_VARCHAR2_TABLE_500
346: , p5_a26 JTF_VARCHAR2_TABLE_500
347: , p5_a27 JTF_NUMBER_TABLE
348: , p5_a28 JTF_NUMBER_TABLE
349: , p5_a29 JTF_DATE_TABLE
350: , p5_a30 JTF_DATE_TABLE
351: , p5_a31 JTF_NUMBER_TABLE
352: );

Line 351: , p5_a31 JTF_NUMBER_TABLE

347: , p5_a27 JTF_NUMBER_TABLE
348: , p5_a28 JTF_NUMBER_TABLE
349: , p5_a29 JTF_DATE_TABLE
350: , p5_a30 JTF_DATE_TABLE
351: , p5_a31 JTF_NUMBER_TABLE
352: );
353: procedure update_row(p_api_version NUMBER
354: , p_init_msg_list VARCHAR2
355: , x_return_status out nocopy VARCHAR2

Line 428: , p5_a0 JTF_NUMBER_TABLE

424: , p_init_msg_list VARCHAR2
425: , x_return_status out nocopy VARCHAR2
426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_NUMBER_TABLE
430: , p5_a2 JTF_VARCHAR2_TABLE_200
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_DATE_TABLE

Line 429: , p5_a1 JTF_NUMBER_TABLE

425: , x_return_status out nocopy VARCHAR2
426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_NUMBER_TABLE
430: , p5_a2 JTF_VARCHAR2_TABLE_200
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_DATE_TABLE
433: , p5_a5 JTF_DATE_TABLE

Line 455: , p5_a27 JTF_NUMBER_TABLE

451: , p5_a23 JTF_VARCHAR2_TABLE_500
452: , p5_a24 JTF_VARCHAR2_TABLE_500
453: , p5_a25 JTF_VARCHAR2_TABLE_500
454: , p5_a26 JTF_VARCHAR2_TABLE_500
455: , p5_a27 JTF_NUMBER_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE

Line 456: , p5_a28 JTF_NUMBER_TABLE

452: , p5_a24 JTF_VARCHAR2_TABLE_500
453: , p5_a25 JTF_VARCHAR2_TABLE_500
454: , p5_a26 JTF_VARCHAR2_TABLE_500
455: , p5_a27 JTF_NUMBER_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE
460: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 459: , p5_a31 JTF_NUMBER_TABLE

455: , p5_a27 JTF_NUMBER_TABLE
456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_NUMBER_TABLE
462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 460: , p6_a0 out nocopy JTF_NUMBER_TABLE

456: , p5_a28 JTF_NUMBER_TABLE
457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_NUMBER_TABLE
462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_DATE_TABLE

Line 461: , p6_a1 out nocopy JTF_NUMBER_TABLE

457: , p5_a29 JTF_DATE_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE
460: , p6_a0 out nocopy JTF_NUMBER_TABLE
461: , p6_a1 out nocopy JTF_NUMBER_TABLE
462: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_DATE_TABLE
465: , p6_a5 out nocopy JTF_DATE_TABLE

Line 487: , p6_a27 out nocopy JTF_NUMBER_TABLE

483: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
484: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
485: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
486: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
487: , p6_a27 out nocopy JTF_NUMBER_TABLE
488: , p6_a28 out nocopy JTF_NUMBER_TABLE
489: , p6_a29 out nocopy JTF_DATE_TABLE
490: , p6_a30 out nocopy JTF_DATE_TABLE
491: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 488: , p6_a28 out nocopy JTF_NUMBER_TABLE

484: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
485: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
486: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
487: , p6_a27 out nocopy JTF_NUMBER_TABLE
488: , p6_a28 out nocopy JTF_NUMBER_TABLE
489: , p6_a29 out nocopy JTF_DATE_TABLE
490: , p6_a30 out nocopy JTF_DATE_TABLE
491: , p6_a31 out nocopy JTF_NUMBER_TABLE
492: );

Line 491: , p6_a31 out nocopy JTF_NUMBER_TABLE

487: , p6_a27 out nocopy JTF_NUMBER_TABLE
488: , p6_a28 out nocopy JTF_NUMBER_TABLE
489: , p6_a29 out nocopy JTF_DATE_TABLE
490: , p6_a30 out nocopy JTF_DATE_TABLE
491: , p6_a31 out nocopy JTF_NUMBER_TABLE
492: );
493: procedure delete_row(p_api_version NUMBER
494: , p_init_msg_list VARCHAR2
495: , x_return_status out nocopy VARCHAR2

Line 536: , p5_a0 JTF_NUMBER_TABLE

532: , p_init_msg_list VARCHAR2
533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_200
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_DATE_TABLE

Line 537: , p5_a1 JTF_NUMBER_TABLE

533: , x_return_status out nocopy VARCHAR2
534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_NUMBER_TABLE
538: , p5_a2 JTF_VARCHAR2_TABLE_200
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_DATE_TABLE
541: , p5_a5 JTF_DATE_TABLE

Line 563: , p5_a27 JTF_NUMBER_TABLE

559: , p5_a23 JTF_VARCHAR2_TABLE_500
560: , p5_a24 JTF_VARCHAR2_TABLE_500
561: , p5_a25 JTF_VARCHAR2_TABLE_500
562: , p5_a26 JTF_VARCHAR2_TABLE_500
563: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a28 JTF_NUMBER_TABLE
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_DATE_TABLE
567: , p5_a31 JTF_NUMBER_TABLE

Line 564: , p5_a28 JTF_NUMBER_TABLE

560: , p5_a24 JTF_VARCHAR2_TABLE_500
561: , p5_a25 JTF_VARCHAR2_TABLE_500
562: , p5_a26 JTF_VARCHAR2_TABLE_500
563: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a28 JTF_NUMBER_TABLE
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_DATE_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: );

Line 567: , p5_a31 JTF_NUMBER_TABLE

563: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a28 JTF_NUMBER_TABLE
565: , p5_a29 JTF_DATE_TABLE
566: , p5_a30 JTF_DATE_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: );
569: procedure validate_row(p_api_version NUMBER
570: , p_init_msg_list VARCHAR2
571: , x_return_status out nocopy VARCHAR2

Line 612: , p5_a0 JTF_NUMBER_TABLE

608: , p_init_msg_list VARCHAR2
609: , x_return_status out nocopy VARCHAR2
610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p5_a0 JTF_NUMBER_TABLE
613: , p5_a1 JTF_NUMBER_TABLE
614: , p5_a2 JTF_VARCHAR2_TABLE_200
615: , p5_a3 JTF_VARCHAR2_TABLE_100
616: , p5_a4 JTF_DATE_TABLE

Line 613: , p5_a1 JTF_NUMBER_TABLE

609: , x_return_status out nocopy VARCHAR2
610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p5_a0 JTF_NUMBER_TABLE
613: , p5_a1 JTF_NUMBER_TABLE
614: , p5_a2 JTF_VARCHAR2_TABLE_200
615: , p5_a3 JTF_VARCHAR2_TABLE_100
616: , p5_a4 JTF_DATE_TABLE
617: , p5_a5 JTF_DATE_TABLE

Line 639: , p5_a27 JTF_NUMBER_TABLE

635: , p5_a23 JTF_VARCHAR2_TABLE_500
636: , p5_a24 JTF_VARCHAR2_TABLE_500
637: , p5_a25 JTF_VARCHAR2_TABLE_500
638: , p5_a26 JTF_VARCHAR2_TABLE_500
639: , p5_a27 JTF_NUMBER_TABLE
640: , p5_a28 JTF_NUMBER_TABLE
641: , p5_a29 JTF_DATE_TABLE
642: , p5_a30 JTF_DATE_TABLE
643: , p5_a31 JTF_NUMBER_TABLE

Line 640: , p5_a28 JTF_NUMBER_TABLE

636: , p5_a24 JTF_VARCHAR2_TABLE_500
637: , p5_a25 JTF_VARCHAR2_TABLE_500
638: , p5_a26 JTF_VARCHAR2_TABLE_500
639: , p5_a27 JTF_NUMBER_TABLE
640: , p5_a28 JTF_NUMBER_TABLE
641: , p5_a29 JTF_DATE_TABLE
642: , p5_a30 JTF_DATE_TABLE
643: , p5_a31 JTF_NUMBER_TABLE
644: );

Line 643: , p5_a31 JTF_NUMBER_TABLE

639: , p5_a27 JTF_NUMBER_TABLE
640: , p5_a28 JTF_NUMBER_TABLE
641: , p5_a29 JTF_DATE_TABLE
642: , p5_a30 JTF_DATE_TABLE
643: , p5_a31 JTF_NUMBER_TABLE
644: );
645: end okl_spp_pvt_w;