[Home] [Help]
1: package cn_quota_pay_elements_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwqpes.pls 115.4 2002/07/30 02:43:27 achung noship $ */
3: procedure rosetta_table_copy_in_p2(t out cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
1: package cn_quota_pay_elements_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwqpes.pls 115.4 2002/07/30 02:43:27 achung noship $ */
3: procedure rosetta_table_copy_in_p2(t out cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: );
30: procedure rosetta_table_copy_out_p2(t cn_quota_pay_elements_pvt.quota_pay_element_tbl_type, a0 out JTF_NUMBER_TABLE
31: , a1 out JTF_VARCHAR2_TABLE_100
32: , a2 out JTF_VARCHAR2_TABLE_100
33: , a3 out JTF_DATE_TABLE
34: , a4 out JTF_DATE_TABLE
54: , a24 out JTF_VARCHAR2_TABLE_200
55: , a25 out JTF_VARCHAR2_TABLE_200
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out cn_quota_pay_elements_pvt.quota_pay_element_out_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_VARCHAR2_TABLE_100
62: , a4 JTF_DATE_TABLE
65: , a7 JTF_VARCHAR2_TABLE_100
66: , a8 JTF_DATE_TABLE
67: , a9 JTF_DATE_TABLE
68: );
69: procedure rosetta_table_copy_out_p5(t cn_quota_pay_elements_pvt.quota_pay_element_out_tbl_type, a0 out JTF_NUMBER_TABLE
70: , a1 out JTF_NUMBER_TABLE
71: , a2 out JTF_NUMBER_TABLE
72: , a3 out JTF_VARCHAR2_TABLE_100
73: , a4 out JTF_DATE_TABLE
200: , x_total_records out NUMBER
201: , x_status out VARCHAR2
202: , x_loading_status out VARCHAR2
203: );
204: end cn_quota_pay_elements_pvt_w;