1: package okl_credit_datapoints_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLECDPS.pls 120.1 2011/04/07 21:20:14 rmunjulu ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_credit_datapoints_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLECDPS.pls 120.1 2011/04/07 21:20:14 rmunjulu ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
1: package okl_credit_datapoints_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLECDPS.pls 120.1 2011/04/07 21:20:14 rmunjulu ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLECDPS.pls 120.1 2011/04/07 21:20:14 rmunjulu ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: );
12: procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200
11: );
12: procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: );
12: procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_200
18: , a6 out nocopy JTF_VARCHAR2_TABLE_100
11: );
12: procedure rosetta_table_copy_out_p4(t okl_credit_datapoints_pvt.lap_dp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_NUMBER_TABLE
14: , a2 out nocopy JTF_NUMBER_TABLE
15: , a3 out nocopy JTF_NUMBER_TABLE
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_200
18: , a6 out nocopy JTF_VARCHAR2_TABLE_100
19: , a7 out nocopy JTF_VARCHAR2_TABLE_200
21:
22: procedure fetch_leaseapp_datapoints(p_api_version NUMBER
23: , p_init_msg_list VARCHAR2
24: , p_leaseapp_id NUMBER
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_NUMBER_TABLE
28: , p3_a3 out nocopy JTF_NUMBER_TABLE
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
22: procedure fetch_leaseapp_datapoints(p_api_version NUMBER
23: , p_init_msg_list VARCHAR2
24: , p_leaseapp_id NUMBER
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_NUMBER_TABLE
28: , p3_a3 out nocopy JTF_NUMBER_TABLE
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
23: , p_init_msg_list VARCHAR2
24: , p_leaseapp_id NUMBER
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_NUMBER_TABLE
28: , p3_a3 out nocopy JTF_NUMBER_TABLE
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
31: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
24: , p_leaseapp_id NUMBER
25: , p3_a0 out nocopy JTF_NUMBER_TABLE
26: , p3_a1 out nocopy JTF_NUMBER_TABLE
27: , p3_a2 out nocopy JTF_NUMBER_TABLE
28: , p3_a3 out nocopy JTF_NUMBER_TABLE
29: , p3_a4 out nocopy JTF_VARCHAR2_TABLE_100
30: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_200
31: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_100
32: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_200
35: , x_msg_data out nocopy VARCHAR2
36: );
37: procedure store_leaseapp_datapoints(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2
39: , p2_a0 JTF_NUMBER_TABLE
40: , p2_a1 JTF_NUMBER_TABLE
41: , p2_a2 JTF_NUMBER_TABLE
42: , p2_a3 JTF_NUMBER_TABLE
43: , p2_a4 JTF_VARCHAR2_TABLE_100
36: );
37: procedure store_leaseapp_datapoints(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2
39: , p2_a0 JTF_NUMBER_TABLE
40: , p2_a1 JTF_NUMBER_TABLE
41: , p2_a2 JTF_NUMBER_TABLE
42: , p2_a3 JTF_NUMBER_TABLE
43: , p2_a4 JTF_VARCHAR2_TABLE_100
44: , p2_a5 JTF_VARCHAR2_TABLE_200
37: procedure store_leaseapp_datapoints(p_api_version NUMBER
38: , p_init_msg_list VARCHAR2
39: , p2_a0 JTF_NUMBER_TABLE
40: , p2_a1 JTF_NUMBER_TABLE
41: , p2_a2 JTF_NUMBER_TABLE
42: , p2_a3 JTF_NUMBER_TABLE
43: , p2_a4 JTF_VARCHAR2_TABLE_100
44: , p2_a5 JTF_VARCHAR2_TABLE_200
45: , p2_a6 JTF_VARCHAR2_TABLE_100
38: , p_init_msg_list VARCHAR2
39: , p2_a0 JTF_NUMBER_TABLE
40: , p2_a1 JTF_NUMBER_TABLE
41: , p2_a2 JTF_NUMBER_TABLE
42: , p2_a3 JTF_NUMBER_TABLE
43: , p2_a4 JTF_VARCHAR2_TABLE_100
44: , p2_a5 JTF_VARCHAR2_TABLE_200
45: , p2_a6 JTF_VARCHAR2_TABLE_100
46: , p2_a7 JTF_VARCHAR2_TABLE_200