APPS.OKL_MRB_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mrb_pvt.mrbv_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_mrb_pvt_w as
2: /* $Header: OKLEMRBS.pls 120.1 2005/07/11 14:18:46 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mrb_pvt.mrbv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_600
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package okl_mrb_pvt_w as
2: /* $Header: OKLEMRBS.pls 120.1 2005/07/11 14:18:46 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_mrb_pvt.mrbv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_600
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_mrb_pvt.mrbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 34: , a31 JTF_NUMBER_TABLE

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

Line 36: procedure rosetta_table_copy_out_p2(t okl_mrb_pvt.mrbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 38: , a2 out nocopy JTF_NUMBER_TABLE

34: , a31 JTF_NUMBER_TABLE
35: );
36: procedure rosetta_table_copy_out_p2(t okl_mrb_pvt.mrbv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_600
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_VARCHAR2_TABLE_100
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE

Line 65: , a29 out nocopy JTF_NUMBER_TABLE

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_DATE_TABLE
65: , a29 out nocopy JTF_NUMBER_TABLE
66: , a30 out nocopy JTF_DATE_TABLE
67: , a31 out nocopy JTF_NUMBER_TABLE
68: );
69:

Line 67: , a31 out nocopy JTF_NUMBER_TABLE

63: , a27 out nocopy JTF_NUMBER_TABLE
64: , a28 out nocopy JTF_DATE_TABLE
65: , a29 out nocopy 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_mrb_pvt.mrb_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_600

Line 70: procedure rosetta_table_copy_in_p5(t out nocopy okl_mrb_pvt.mrb_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_mrb_pvt.mrb_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_600
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_VARCHAR2_TABLE_100

Line 72: , a2 JTF_NUMBER_TABLE

68: );
69:
70: procedure rosetta_table_copy_in_p5(t out nocopy okl_mrb_pvt.mrb_tbl_type, a0 JTF_NUMBER_TABLE
71: , a1 JTF_VARCHAR2_TABLE_600
72: , a2 JTF_NUMBER_TABLE
73: , a3 JTF_VARCHAR2_TABLE_100
74: , a4 JTF_VARCHAR2_TABLE_100
75: , a5 JTF_VARCHAR2_TABLE_100
76: , a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
99: , a29 JTF_NUMBER_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE

Line 99: , a29 JTF_NUMBER_TABLE

95: , a25 JTF_VARCHAR2_TABLE_500
96: , a26 JTF_VARCHAR2_TABLE_500
97: , a27 JTF_NUMBER_TABLE
98: , a28 JTF_DATE_TABLE
99: , a29 JTF_NUMBER_TABLE
100: , a30 JTF_DATE_TABLE
101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_mrb_pvt.mrb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 101: , a31 JTF_NUMBER_TABLE

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

Line 103: procedure rosetta_table_copy_out_p5(t okl_mrb_pvt.mrb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 105: , a2 out nocopy JTF_NUMBER_TABLE

101: , a31 JTF_NUMBER_TABLE
102: );
103: procedure rosetta_table_copy_out_p5(t okl_mrb_pvt.mrb_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_600
105: , a2 out nocopy JTF_NUMBER_TABLE
106: , a3 out nocopy JTF_VARCHAR2_TABLE_100
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE

Line 132: , a29 out nocopy JTF_NUMBER_TABLE

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_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_TABLE
133: , a30 out nocopy JTF_DATE_TABLE
134: , a31 out nocopy JTF_NUMBER_TABLE
135: );
136:

Line 134: , a31 out nocopy JTF_NUMBER_TABLE

130: , a27 out nocopy JTF_NUMBER_TABLE
131: , a28 out nocopy JTF_DATE_TABLE
132: , a29 out nocopy JTF_NUMBER_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_VARCHAR2_TABLE_600
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 214: , p5_a2 JTF_NUMBER_TABLE

210: , x_msg_count out nocopy NUMBER
211: , x_msg_data out nocopy VARCHAR2
212: , p5_a0 JTF_NUMBER_TABLE
213: , p5_a1 JTF_VARCHAR2_TABLE_600
214: , p5_a2 JTF_NUMBER_TABLE
215: , p5_a3 JTF_VARCHAR2_TABLE_100
216: , p5_a4 JTF_VARCHAR2_TABLE_100
217: , p5_a5 JTF_VARCHAR2_TABLE_100
218: , p5_a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
241: , p5_a29 JTF_NUMBER_TABLE
242: , p5_a30 JTF_DATE_TABLE
243: , p5_a31 JTF_NUMBER_TABLE

Line 241: , p5_a29 JTF_NUMBER_TABLE

237: , p5_a25 JTF_VARCHAR2_TABLE_500
238: , p5_a26 JTF_VARCHAR2_TABLE_500
239: , p5_a27 JTF_NUMBER_TABLE
240: , p5_a28 JTF_DATE_TABLE
241: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600

Line 243: , p5_a31 JTF_NUMBER_TABLE

239: , p5_a27 JTF_NUMBER_TABLE
240: , p5_a28 JTF_DATE_TABLE
241: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
246: , p6_a2 out nocopy JTF_NUMBER_TABLE
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 244: , p6_a0 out nocopy JTF_NUMBER_TABLE

240: , p5_a28 JTF_DATE_TABLE
241: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
246: , p6_a2 out nocopy JTF_NUMBER_TABLE
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 246: , p6_a2 out nocopy JTF_NUMBER_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_VARCHAR2_TABLE_600
246: , p6_a2 out nocopy JTF_NUMBER_TABLE
247: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
248: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
249: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
250: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
273: , p6_a29 out nocopy JTF_NUMBER_TABLE
274: , p6_a30 out nocopy JTF_DATE_TABLE
275: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 273: , p6_a29 out nocopy JTF_NUMBER_TABLE

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_DATE_TABLE
273: , p6_a29 out nocopy JTF_NUMBER_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

Line 275: , p6_a31 out nocopy JTF_NUMBER_TABLE

271: , p6_a27 out nocopy JTF_NUMBER_TABLE
272: , p6_a28 out nocopy JTF_DATE_TABLE
273: , p6_a29 out nocopy JTF_NUMBER_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_VARCHAR2_TABLE_600
322: , p5_a2 JTF_NUMBER_TABLE
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 322: , p5_a2 JTF_NUMBER_TABLE

318: , x_msg_count out nocopy NUMBER
319: , x_msg_data out nocopy VARCHAR2
320: , p5_a0 JTF_NUMBER_TABLE
321: , p5_a1 JTF_VARCHAR2_TABLE_600
322: , p5_a2 JTF_NUMBER_TABLE
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_VARCHAR2_TABLE_100
325: , p5_a5 JTF_VARCHAR2_TABLE_100
326: , p5_a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
349: , p5_a29 JTF_NUMBER_TABLE
350: , p5_a30 JTF_DATE_TABLE
351: , p5_a31 JTF_NUMBER_TABLE

Line 349: , p5_a29 JTF_NUMBER_TABLE

345: , p5_a25 JTF_VARCHAR2_TABLE_500
346: , p5_a26 JTF_VARCHAR2_TABLE_500
347: , p5_a27 JTF_NUMBER_TABLE
348: , p5_a28 JTF_DATE_TABLE
349: , p5_a29 JTF_NUMBER_TABLE
350: , p5_a30 JTF_DATE_TABLE
351: , p5_a31 JTF_NUMBER_TABLE
352: );
353: procedure update_row(p_api_version NUMBER

Line 351: , p5_a31 JTF_NUMBER_TABLE

347: , p5_a27 JTF_NUMBER_TABLE
348: , p5_a28 JTF_DATE_TABLE
349: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
430: , p5_a2 JTF_NUMBER_TABLE
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 430: , p5_a2 JTF_NUMBER_TABLE

426: , x_msg_count out nocopy NUMBER
427: , x_msg_data out nocopy VARCHAR2
428: , p5_a0 JTF_NUMBER_TABLE
429: , p5_a1 JTF_VARCHAR2_TABLE_600
430: , p5_a2 JTF_NUMBER_TABLE
431: , p5_a3 JTF_VARCHAR2_TABLE_100
432: , p5_a4 JTF_VARCHAR2_TABLE_100
433: , p5_a5 JTF_VARCHAR2_TABLE_100
434: , p5_a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
457: , p5_a29 JTF_NUMBER_TABLE
458: , p5_a30 JTF_DATE_TABLE
459: , p5_a31 JTF_NUMBER_TABLE

Line 457: , p5_a29 JTF_NUMBER_TABLE

453: , p5_a25 JTF_VARCHAR2_TABLE_500
454: , p5_a26 JTF_VARCHAR2_TABLE_500
455: , p5_a27 JTF_NUMBER_TABLE
456: , p5_a28 JTF_DATE_TABLE
457: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600

Line 459: , p5_a31 JTF_NUMBER_TABLE

455: , p5_a27 JTF_NUMBER_TABLE
456: , p5_a28 JTF_DATE_TABLE
457: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 460: , p6_a0 out nocopy JTF_NUMBER_TABLE

456: , p5_a28 JTF_DATE_TABLE
457: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 462: , p6_a2 out nocopy JTF_NUMBER_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_VARCHAR2_TABLE_600
462: , p6_a2 out nocopy JTF_NUMBER_TABLE
463: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
464: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
465: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
489: , p6_a29 out nocopy JTF_NUMBER_TABLE
490: , p6_a30 out nocopy JTF_DATE_TABLE
491: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 489: , p6_a29 out nocopy JTF_NUMBER_TABLE

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_DATE_TABLE
489: , p6_a29 out nocopy JTF_NUMBER_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

Line 491: , p6_a31 out nocopy JTF_NUMBER_TABLE

487: , p6_a27 out nocopy JTF_NUMBER_TABLE
488: , p6_a28 out nocopy JTF_DATE_TABLE
489: , p6_a29 out nocopy JTF_NUMBER_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_VARCHAR2_TABLE_600
538: , p5_a2 JTF_NUMBER_TABLE
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 538: , p5_a2 JTF_NUMBER_TABLE

534: , x_msg_count out nocopy NUMBER
535: , x_msg_data out nocopy VARCHAR2
536: , p5_a0 JTF_NUMBER_TABLE
537: , p5_a1 JTF_VARCHAR2_TABLE_600
538: , p5_a2 JTF_NUMBER_TABLE
539: , p5_a3 JTF_VARCHAR2_TABLE_100
540: , p5_a4 JTF_VARCHAR2_TABLE_100
541: , p5_a5 JTF_VARCHAR2_TABLE_100
542: , p5_a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
565: , p5_a29 JTF_NUMBER_TABLE
566: , p5_a30 JTF_DATE_TABLE
567: , p5_a31 JTF_NUMBER_TABLE

Line 565: , p5_a29 JTF_NUMBER_TABLE

561: , p5_a25 JTF_VARCHAR2_TABLE_500
562: , p5_a26 JTF_VARCHAR2_TABLE_500
563: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a28 JTF_DATE_TABLE
565: , p5_a29 JTF_NUMBER_TABLE
566: , p5_a30 JTF_DATE_TABLE
567: , p5_a31 JTF_NUMBER_TABLE
568: );
569: procedure validate_row(p_api_version NUMBER

Line 567: , p5_a31 JTF_NUMBER_TABLE

563: , p5_a27 JTF_NUMBER_TABLE
564: , p5_a28 JTF_DATE_TABLE
565: , p5_a29 JTF_NUMBER_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_VARCHAR2_TABLE_600
614: , p5_a2 JTF_NUMBER_TABLE
615: , p5_a3 JTF_VARCHAR2_TABLE_100
616: , p5_a4 JTF_VARCHAR2_TABLE_100

Line 614: , p5_a2 JTF_NUMBER_TABLE

610: , x_msg_count out nocopy NUMBER
611: , x_msg_data out nocopy VARCHAR2
612: , p5_a0 JTF_NUMBER_TABLE
613: , p5_a1 JTF_VARCHAR2_TABLE_600
614: , p5_a2 JTF_NUMBER_TABLE
615: , p5_a3 JTF_VARCHAR2_TABLE_100
616: , p5_a4 JTF_VARCHAR2_TABLE_100
617: , p5_a5 JTF_VARCHAR2_TABLE_100
618: , p5_a6 JTF_VARCHAR2_TABLE_600

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_DATE_TABLE
641: , p5_a29 JTF_NUMBER_TABLE
642: , p5_a30 JTF_DATE_TABLE
643: , p5_a31 JTF_NUMBER_TABLE

Line 641: , p5_a29 JTF_NUMBER_TABLE

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

Line 643: , p5_a31 JTF_NUMBER_TABLE

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