APPS.OKL_K_RATE_PARAMS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_k_rate_params_pvt_w as
2: /* $Header: OKLUKRPS.pls 120.2 2005/11/22 23:40:37 ramurt noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_k_rate_params_pvt.krpdel_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: );
7: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 8: , a1 out nocopy JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: );
7: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_DATE_TABLE
10: );
11:
12: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 12: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100

8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_DATE_TABLE
10: );
11:
12: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_100
15: , a3 JTF_NUMBER_TABLE
16: , a4 JTF_DATE_TABLE

Line 13: , a1 JTF_VARCHAR2_TABLE_100

9: , a2 out nocopy JTF_DATE_TABLE
10: );
11:
12: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_100
15: , a3 JTF_NUMBER_TABLE
16: , a4 JTF_DATE_TABLE
17: , a5 JTF_DATE_TABLE

Line 14: , a2 JTF_VARCHAR2_TABLE_100

10: );
11:
12: procedure rosetta_table_copy_in_p6(t out nocopy okl_k_rate_params_pvt.var_prm_tbl_type, a0 JTF_VARCHAR2_TABLE_100
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_100
15: , a3 JTF_NUMBER_TABLE
16: , a4 JTF_DATE_TABLE
17: , a5 JTF_DATE_TABLE
18: );

Line 19: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

15: , a3 JTF_NUMBER_TABLE
16: , a4 JTF_DATE_TABLE
17: , a5 JTF_DATE_TABLE
18: );
19: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_VARCHAR2_TABLE_100
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_DATE_TABLE

Line 20: , a1 out nocopy JTF_VARCHAR2_TABLE_100

16: , a4 JTF_DATE_TABLE
17: , a5 JTF_DATE_TABLE
18: );
19: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_VARCHAR2_TABLE_100
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_DATE_TABLE
24: , a5 out nocopy JTF_DATE_TABLE

Line 21: , a2 out nocopy JTF_VARCHAR2_TABLE_100

17: , a5 JTF_DATE_TABLE
18: );
19: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
20: , a1 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_VARCHAR2_TABLE_100
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_DATE_TABLE
24: , a5 out nocopy JTF_DATE_TABLE
25: );

Line 457: , p5_a1 JTF_VARCHAR2_TABLE_100

453: , x_return_status out nocopy VARCHAR2
454: , x_msg_count out nocopy NUMBER
455: , x_msg_data out nocopy VARCHAR2
456: , p5_a0 JTF_NUMBER_TABLE
457: , p5_a1 JTF_VARCHAR2_TABLE_100
458: , p5_a2 JTF_DATE_TABLE
459: );
460: procedure validate_k_rate_params(p_api_version NUMBER
461: , p_init_msg_list VARCHAR2

Line 467: , p6_a1 JTF_VARCHAR2_TABLE_100

463: , x_msg_count out nocopy NUMBER
464: , x_msg_data out nocopy VARCHAR2
465: , p_product_id NUMBER
466: , p6_a0 JTF_NUMBER_TABLE
467: , p6_a1 JTF_VARCHAR2_TABLE_100
468: , p6_a2 JTF_DATE_TABLE
469: , p6_a3 JTF_DATE_TABLE
470: , p6_a4 JTF_NUMBER_TABLE
471: , p6_a5 JTF_NUMBER_TABLE

Line 476: , p6_a10 JTF_VARCHAR2_TABLE_100

472: , p6_a6 JTF_DATE_TABLE
473: , p6_a7 JTF_NUMBER_TABLE
474: , p6_a8 JTF_NUMBER_TABLE
475: , p6_a9 JTF_NUMBER_TABLE
476: , p6_a10 JTF_VARCHAR2_TABLE_100
477: , p6_a11 JTF_VARCHAR2_TABLE_100
478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100

Line 477: , p6_a11 JTF_VARCHAR2_TABLE_100

473: , p6_a7 JTF_NUMBER_TABLE
474: , p6_a8 JTF_NUMBER_TABLE
475: , p6_a9 JTF_NUMBER_TABLE
476: , p6_a10 JTF_VARCHAR2_TABLE_100
477: , p6_a11 JTF_VARCHAR2_TABLE_100
478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE

Line 478: , p6_a12 JTF_VARCHAR2_TABLE_100

474: , p6_a8 JTF_NUMBER_TABLE
475: , p6_a9 JTF_NUMBER_TABLE
476: , p6_a10 JTF_VARCHAR2_TABLE_100
477: , p6_a11 JTF_VARCHAR2_TABLE_100
478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE
482: , p6_a16 JTF_VARCHAR2_TABLE_100

Line 479: , p6_a13 JTF_VARCHAR2_TABLE_100

475: , p6_a9 JTF_NUMBER_TABLE
476: , p6_a10 JTF_VARCHAR2_TABLE_100
477: , p6_a11 JTF_VARCHAR2_TABLE_100
478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE
482: , p6_a16 JTF_VARCHAR2_TABLE_100
483: , p6_a17 JTF_NUMBER_TABLE

Line 480: , p6_a14 JTF_VARCHAR2_TABLE_100

476: , p6_a10 JTF_VARCHAR2_TABLE_100
477: , p6_a11 JTF_VARCHAR2_TABLE_100
478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE
482: , p6_a16 JTF_VARCHAR2_TABLE_100
483: , p6_a17 JTF_NUMBER_TABLE
484: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 482: , p6_a16 JTF_VARCHAR2_TABLE_100

478: , p6_a12 JTF_VARCHAR2_TABLE_100
479: , p6_a13 JTF_VARCHAR2_TABLE_100
480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE
482: , p6_a16 JTF_VARCHAR2_TABLE_100
483: , p6_a17 JTF_NUMBER_TABLE
484: , p6_a18 JTF_VARCHAR2_TABLE_100
485: , p6_a19 JTF_DATE_TABLE
486: , p6_a20 JTF_VARCHAR2_TABLE_100

Line 484: , p6_a18 JTF_VARCHAR2_TABLE_100

480: , p6_a14 JTF_VARCHAR2_TABLE_100
481: , p6_a15 JTF_NUMBER_TABLE
482: , p6_a16 JTF_VARCHAR2_TABLE_100
483: , p6_a17 JTF_NUMBER_TABLE
484: , p6_a18 JTF_VARCHAR2_TABLE_100
485: , p6_a19 JTF_DATE_TABLE
486: , p6_a20 JTF_VARCHAR2_TABLE_100
487: , p6_a21 JTF_DATE_TABLE
488: , p6_a22 JTF_VARCHAR2_TABLE_100

Line 486: , p6_a20 JTF_VARCHAR2_TABLE_100

482: , p6_a16 JTF_VARCHAR2_TABLE_100
483: , p6_a17 JTF_NUMBER_TABLE
484: , p6_a18 JTF_VARCHAR2_TABLE_100
485: , p6_a19 JTF_DATE_TABLE
486: , p6_a20 JTF_VARCHAR2_TABLE_100
487: , p6_a21 JTF_DATE_TABLE
488: , p6_a22 JTF_VARCHAR2_TABLE_100
489: , p6_a23 JTF_NUMBER_TABLE
490: , p6_a24 JTF_VARCHAR2_TABLE_100

Line 488: , p6_a22 JTF_VARCHAR2_TABLE_100

484: , p6_a18 JTF_VARCHAR2_TABLE_100
485: , p6_a19 JTF_DATE_TABLE
486: , p6_a20 JTF_VARCHAR2_TABLE_100
487: , p6_a21 JTF_DATE_TABLE
488: , p6_a22 JTF_VARCHAR2_TABLE_100
489: , p6_a23 JTF_NUMBER_TABLE
490: , p6_a24 JTF_VARCHAR2_TABLE_100
491: , p6_a25 JTF_DATE_TABLE
492: , p6_a26 JTF_VARCHAR2_TABLE_100

Line 490: , p6_a24 JTF_VARCHAR2_TABLE_100

486: , p6_a20 JTF_VARCHAR2_TABLE_100
487: , p6_a21 JTF_DATE_TABLE
488: , p6_a22 JTF_VARCHAR2_TABLE_100
489: , p6_a23 JTF_NUMBER_TABLE
490: , p6_a24 JTF_VARCHAR2_TABLE_100
491: , p6_a25 JTF_DATE_TABLE
492: , p6_a26 JTF_VARCHAR2_TABLE_100
493: , p6_a27 JTF_VARCHAR2_TABLE_100
494: , p6_a28 JTF_VARCHAR2_TABLE_500

Line 492: , p6_a26 JTF_VARCHAR2_TABLE_100

488: , p6_a22 JTF_VARCHAR2_TABLE_100
489: , p6_a23 JTF_NUMBER_TABLE
490: , p6_a24 JTF_VARCHAR2_TABLE_100
491: , p6_a25 JTF_DATE_TABLE
492: , p6_a26 JTF_VARCHAR2_TABLE_100
493: , p6_a27 JTF_VARCHAR2_TABLE_100
494: , p6_a28 JTF_VARCHAR2_TABLE_500
495: , p6_a29 JTF_VARCHAR2_TABLE_500
496: , p6_a30 JTF_VARCHAR2_TABLE_500

Line 493: , p6_a27 JTF_VARCHAR2_TABLE_100

489: , p6_a23 JTF_NUMBER_TABLE
490: , p6_a24 JTF_VARCHAR2_TABLE_100
491: , p6_a25 JTF_DATE_TABLE
492: , p6_a26 JTF_VARCHAR2_TABLE_100
493: , p6_a27 JTF_VARCHAR2_TABLE_100
494: , p6_a28 JTF_VARCHAR2_TABLE_500
495: , p6_a29 JTF_VARCHAR2_TABLE_500
496: , p6_a30 JTF_VARCHAR2_TABLE_500
497: , p6_a31 JTF_VARCHAR2_TABLE_500

Line 514: , p6_a48 JTF_VARCHAR2_TABLE_100

510: , p6_a44 JTF_DATE_TABLE
511: , p6_a45 JTF_NUMBER_TABLE
512: , p6_a46 JTF_DATE_TABLE
513: , p6_a47 JTF_NUMBER_TABLE
514: , p6_a48 JTF_VARCHAR2_TABLE_100
515: );
516: procedure generate_rate_summary(p_api_version NUMBER
517: , p_init_msg_list VARCHAR2
518: , x_return_status out nocopy VARCHAR2

Line 522: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

518: , x_return_status out nocopy VARCHAR2
519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p_chr_id NUMBER
522: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
523: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a3 out nocopy JTF_NUMBER_TABLE
526: , p6_a4 out nocopy JTF_DATE_TABLE

Line 523: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

519: , x_msg_count out nocopy NUMBER
520: , x_msg_data out nocopy VARCHAR2
521: , p_chr_id NUMBER
522: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
523: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a3 out nocopy JTF_NUMBER_TABLE
526: , p6_a4 out nocopy JTF_DATE_TABLE
527: , p6_a5 out nocopy JTF_DATE_TABLE

Line 524: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

520: , x_msg_data out nocopy VARCHAR2
521: , p_chr_id NUMBER
522: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
523: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a3 out nocopy JTF_NUMBER_TABLE
526: , p6_a4 out nocopy JTF_DATE_TABLE
527: , p6_a5 out nocopy JTF_DATE_TABLE
528: );