1: package okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXS.pls 120.7 2006/03/08 11:38:00 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
1: package okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXS.pls 120.7 2006/03/08 11:38:00 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
1: package okl_ec_uptake_pvt_w as
2: /* $Header: OKLEECXS.pls 120.7 2006/03/08 11:38:00 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8:
2: /* $Header: OKLEECXS.pls 120.7 2006/03/08 11:38:00 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8:
9: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
3: procedure rosetta_table_copy_in_p18(t out nocopy okl_ec_uptake_pvt.okl_number_table_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p18(t okl_ec_uptake_pvt.okl_number_table_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8:
9: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
11:
5:
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8:
9: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
11:
12: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
13: , a1 JTF_VARCHAR2_TABLE_100
6: procedure rosetta_table_copy_in_p19(t out nocopy okl_ec_uptake_pvt.okl_varchar2_table_type, a0 JTF_VARCHAR2_TABLE_300);
7: procedure rosetta_table_copy_out_p19(t okl_ec_uptake_pvt.okl_varchar2_table_type, a0 out nocopy JTF_VARCHAR2_TABLE_300);
8:
9: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
11:
12: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
8:
9: procedure rosetta_table_copy_in_p20(t out nocopy okl_ec_uptake_pvt.okl_date_tabe_type, a0 JTF_DATE_TABLE);
10: procedure rosetta_table_copy_out_p20(t okl_ec_uptake_pvt.okl_date_tabe_type, a0 out nocopy JTF_DATE_TABLE);
11:
12: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
11:
12: procedure rosetta_table_copy_in_p22(t out nocopy okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 JTF_VARCHAR2_TABLE_300
13: , a1 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
15: procedure rosetta_table_copy_out_p22(t okl_ec_uptake_pvt.okl_qa_result_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: );
18:
19: procedure rosetta_table_copy_in_p24(t out nocopy okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 JTF_NUMBER_TABLE
20: , a1 JTF_NUMBER_TABLE
21: , a2 JTF_NUMBER_TABLE
22: , a3 JTF_VARCHAR2_TABLE_200
23: , a4 JTF_VARCHAR2_TABLE_2000
27: , a8 JTF_VARCHAR2_TABLE_100
28: , a9 JTF_VARCHAR2_TABLE_100
29: , a10 JTF_VARCHAR2_TABLE_300
30: );
31: procedure rosetta_table_copy_out_p24(t okl_ec_uptake_pvt.okl_lease_rate_set_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_200
35: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a9 out nocopy JTF_VARCHAR2_TABLE_100
41: , a10 out nocopy JTF_VARCHAR2_TABLE_300
42: );
43:
44: procedure rosetta_table_copy_in_p26(t out nocopy okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 JTF_NUMBER_TABLE
45: , a1 JTF_NUMBER_TABLE
46: , a2 JTF_NUMBER_TABLE
47: , a3 JTF_VARCHAR2_TABLE_300
48: , a4 JTF_VARCHAR2_TABLE_2000
53: , a9 JTF_VARCHAR2_TABLE_100
54: , a10 JTF_VARCHAR2_TABLE_100
55: , a11 JTF_VARCHAR2_TABLE_300
56: );
57: procedure rosetta_table_copy_out_p26(t okl_ec_uptake_pvt.okl_std_rate_tmpl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_NUMBER_TABLE
59: , a2 out nocopy JTF_NUMBER_TABLE
60: , a3 out nocopy JTF_VARCHAR2_TABLE_300
61: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a10 out nocopy JTF_VARCHAR2_TABLE_100
68: , a11 out nocopy JTF_VARCHAR2_TABLE_300
69: );
70:
71: procedure rosetta_table_copy_in_p28(t out nocopy okl_ec_uptake_pvt.okl_prod_tbl_type, a0 JTF_NUMBER_TABLE
72: , a1 JTF_VARCHAR2_TABLE_200
73: , a2 JTF_VARCHAR2_TABLE_200
74: , a3 JTF_NUMBER_TABLE
75: , a4 JTF_VARCHAR2_TABLE_2000
76: , a5 JTF_VARCHAR2_TABLE_100
77: , a6 JTF_VARCHAR2_TABLE_200
78: , a7 JTF_VARCHAR2_TABLE_4000
79: );
80: procedure rosetta_table_copy_out_p28(t okl_ec_uptake_pvt.okl_prod_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_NUMBER_TABLE
84: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
86: , a6 out nocopy JTF_VARCHAR2_TABLE_200
87: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
88: );
89:
90: procedure rosetta_table_copy_in_p30(t out nocopy okl_ec_uptake_pvt.okl_vp_tbl_type, a0 JTF_NUMBER_TABLE
91: , a1 JTF_VARCHAR2_TABLE_200
92: , a2 JTF_DATE_TABLE
93: , a3 JTF_DATE_TABLE
94: );
91: , a1 JTF_VARCHAR2_TABLE_200
92: , a2 JTF_DATE_TABLE
93: , a3 JTF_DATE_TABLE
94: );
95: procedure rosetta_table_copy_out_p30(t okl_ec_uptake_pvt.okl_vp_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_200
97: , a2 out nocopy JTF_DATE_TABLE
98: , a3 out nocopy JTF_DATE_TABLE
99: );
235: , x_return_status out nocopy VARCHAR2
236: , x_msg_count out nocopy NUMBER
237: , x_msg_data out nocopy VARCHAR2
238: );
239: end okl_ec_uptake_pvt_w;