APPS.OKL_K_RATE_PARAMS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy okl_k_rate_params_pvt.krpdel_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 7: procedure rosetta_table_copy_out_p1(t okl_k_rate_params_pvt.krpdel_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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
9: , a2 out nocopy JTF_DATE_TABLE
10: );
11:

Line 15: , a3 JTF_NUMBER_TABLE

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: );
19: procedure rosetta_table_copy_out_p6(t okl_k_rate_params_pvt.var_prm_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 22: , a3 out nocopy JTF_NUMBER_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: );
26:

Line 456: , p5_a0 JTF_NUMBER_TABLE

452: , p_init_msg_list VARCHAR2
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

Line 466: , p6_a0 JTF_NUMBER_TABLE

462: , x_return_status out nocopy VARCHAR2
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

Line 470: , p6_a4 JTF_NUMBER_TABLE

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
472: , p6_a6 JTF_DATE_TABLE
473: , p6_a7 JTF_NUMBER_TABLE
474: , p6_a8 JTF_NUMBER_TABLE

Line 471: , p6_a5 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
472: , p6_a6 JTF_DATE_TABLE
473: , p6_a7 JTF_NUMBER_TABLE
474: , p6_a8 JTF_NUMBER_TABLE
475: , p6_a9 JTF_NUMBER_TABLE

Line 473: , p6_a7 JTF_NUMBER_TABLE

469: , p6_a3 JTF_DATE_TABLE
470: , p6_a4 JTF_NUMBER_TABLE
471: , p6_a5 JTF_NUMBER_TABLE
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

Line 474: , p6_a8 JTF_NUMBER_TABLE

470: , p6_a4 JTF_NUMBER_TABLE
471: , p6_a5 JTF_NUMBER_TABLE
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

Line 475: , p6_a9 JTF_NUMBER_TABLE

471: , p6_a5 JTF_NUMBER_TABLE
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

Line 481: , p6_a15 JTF_NUMBER_TABLE

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
485: , p6_a19 JTF_DATE_TABLE

Line 483: , p6_a17 JTF_NUMBER_TABLE

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
487: , p6_a21 JTF_DATE_TABLE

Line 489: , p6_a23 JTF_NUMBER_TABLE

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
493: , p6_a27 JTF_VARCHAR2_TABLE_100

Line 509: , p6_a43 JTF_NUMBER_TABLE

505: , p6_a39 JTF_VARCHAR2_TABLE_500
506: , p6_a40 JTF_VARCHAR2_TABLE_500
507: , p6_a41 JTF_VARCHAR2_TABLE_500
508: , p6_a42 JTF_VARCHAR2_TABLE_500
509: , p6_a43 JTF_NUMBER_TABLE
510: , p6_a44 JTF_DATE_TABLE
511: , p6_a45 JTF_NUMBER_TABLE
512: , p6_a46 JTF_DATE_TABLE
513: , p6_a47 JTF_NUMBER_TABLE

Line 511: , p6_a45 JTF_NUMBER_TABLE

507: , p6_a41 JTF_VARCHAR2_TABLE_500
508: , p6_a42 JTF_VARCHAR2_TABLE_500
509: , p6_a43 JTF_NUMBER_TABLE
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: );

Line 513: , p6_a47 JTF_NUMBER_TABLE

509: , p6_a43 JTF_NUMBER_TABLE
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

Line 525: , p6_a3 out nocopy JTF_NUMBER_TABLE

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: );
529: procedure default_k_rate_params(p_api_version NUMBER