DBA Data[Home] [Help]

APPS.OKL_OPT_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 4: , a1 JTF_VARCHAR2_TABLE_200

1: package okl_opt_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIOPTS.pls 115.3 2002/12/24 04:06:02 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_2000

2: /* $Header: OKLIOPTS.pls 115.3 2002/12/24 04:06:02 sgorantl noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_opt_pvt.opt_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500

Line 32: , a1 out nocopy JTF_VARCHAR2_TABLE_200

28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_VARCHAR2_TABLE_200
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
35: , a4 out nocopy JTF_DATE_TABLE
36: , a5 out nocopy JTF_DATE_TABLE

Line 34: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

30: );
31: procedure rosetta_table_copy_out_p2(t okl_opt_pvt.opt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_VARCHAR2_TABLE_200
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
35: , a4 out nocopy JTF_DATE_TABLE
36: , a5 out nocopy JTF_DATE_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 62: , a2 JTF_VARCHAR2_TABLE_200

58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_VARCHAR2_TABLE_200
63: , a3 JTF_VARCHAR2_TABLE_2000
64: , a4 JTF_DATE_TABLE
65: , a5 JTF_DATE_TABLE
66: , a6 JTF_VARCHAR2_TABLE_100

Line 63: , a3 JTF_VARCHAR2_TABLE_2000

59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_opt_pvt.optv_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_VARCHAR2_TABLE_200
63: , a3 JTF_VARCHAR2_TABLE_2000
64: , a4 JTF_DATE_TABLE
65: , a5 JTF_DATE_TABLE
66: , a6 JTF_VARCHAR2_TABLE_100
67: , a7 JTF_VARCHAR2_TABLE_500

Line 90: , a2 out nocopy JTF_VARCHAR2_TABLE_200

86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000

87: );
88: procedure rosetta_table_copy_out_p5(t okl_opt_pvt.optv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_VARCHAR2_TABLE_200
91: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
92: , a4 out nocopy JTF_DATE_TABLE
93: , a5 out nocopy JTF_DATE_TABLE
94: , a6 out nocopy JTF_VARCHAR2_TABLE_100
95: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 184: , p5_a2 JTF_VARCHAR2_TABLE_200

180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_DATE_TABLE
187: , p5_a5 JTF_DATE_TABLE
188: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 185: , p5_a3 JTF_VARCHAR2_TABLE_2000

181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_VARCHAR2_TABLE_200
185: , p5_a3 JTF_VARCHAR2_TABLE_2000
186: , p5_a4 JTF_DATE_TABLE
187: , p5_a5 JTF_DATE_TABLE
188: , p5_a6 JTF_VARCHAR2_TABLE_100
189: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a4 out nocopy JTF_DATE_TABLE
214: , p6_a5 out nocopy JTF_DATE_TABLE
215: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
212: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
213: , p6_a4 out nocopy JTF_DATE_TABLE
214: , p6_a5 out nocopy JTF_DATE_TABLE
215: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
216: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 277: , p5_a2 JTF_VARCHAR2_TABLE_200

273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_VARCHAR2_TABLE_200
278: , p5_a3 JTF_VARCHAR2_TABLE_2000
279: , p5_a4 JTF_DATE_TABLE
280: , p5_a5 JTF_DATE_TABLE
281: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 278: , p5_a3 JTF_VARCHAR2_TABLE_2000

274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_VARCHAR2_TABLE_200
278: , p5_a3 JTF_VARCHAR2_TABLE_2000
279: , p5_a4 JTF_DATE_TABLE
280: , p5_a5 JTF_DATE_TABLE
281: , p5_a6 JTF_VARCHAR2_TABLE_100
282: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 370: , p5_a2 JTF_VARCHAR2_TABLE_200

366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_VARCHAR2_TABLE_200
371: , p5_a3 JTF_VARCHAR2_TABLE_2000
372: , p5_a4 JTF_DATE_TABLE
373: , p5_a5 JTF_DATE_TABLE
374: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 371: , p5_a3 JTF_VARCHAR2_TABLE_2000

367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_VARCHAR2_TABLE_200
371: , p5_a3 JTF_VARCHAR2_TABLE_2000
372: , p5_a4 JTF_DATE_TABLE
373: , p5_a5 JTF_DATE_TABLE
374: , p5_a6 JTF_VARCHAR2_TABLE_100
375: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200

393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
399: , p6_a4 out nocopy JTF_DATE_TABLE
400: , p6_a5 out nocopy JTF_DATE_TABLE
401: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000

394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
398: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
399: , p6_a4 out nocopy JTF_DATE_TABLE
400: , p6_a5 out nocopy JTF_DATE_TABLE
401: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
402: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 463: , p5_a2 JTF_VARCHAR2_TABLE_200

459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_VARCHAR2_TABLE_200
464: , p5_a3 JTF_VARCHAR2_TABLE_2000
465: , p5_a4 JTF_DATE_TABLE
466: , p5_a5 JTF_DATE_TABLE
467: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 464: , p5_a3 JTF_VARCHAR2_TABLE_2000

460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_VARCHAR2_TABLE_200
464: , p5_a3 JTF_VARCHAR2_TABLE_2000
465: , p5_a4 JTF_DATE_TABLE
466: , p5_a5 JTF_DATE_TABLE
467: , p5_a6 JTF_VARCHAR2_TABLE_100
468: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 529: , p5_a2 JTF_VARCHAR2_TABLE_200

525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_VARCHAR2_TABLE_200
530: , p5_a3 JTF_VARCHAR2_TABLE_2000
531: , p5_a4 JTF_DATE_TABLE
532: , p5_a5 JTF_DATE_TABLE
533: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 530: , p5_a3 JTF_VARCHAR2_TABLE_2000

526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_VARCHAR2_TABLE_200
530: , p5_a3 JTF_VARCHAR2_TABLE_2000
531: , p5_a4 JTF_DATE_TABLE
532: , p5_a5 JTF_DATE_TABLE
533: , p5_a6 JTF_VARCHAR2_TABLE_100
534: , p5_a7 JTF_VARCHAR2_TABLE_500