1: package csi_transactions_pvt_w as
2: /* $Header: csivtxws.pls 120.12 2008/01/15 03:31:55 devijay ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
2: /* $Header: csivtxws.pls 120.12 2008/01/15 03:31:55 devijay ship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: );
6: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
7: , a1 out nocopy JTF_VARCHAR2_TABLE_100
8: );
9:
10: procedure get_transactions(p_api_version_number NUMBER
16: , p_return_tot_count VARCHAR2
17: , x_return_status out nocopy VARCHAR2
18: , x_msg_count out nocopy NUMBER
19: , x_msg_data out nocopy VARCHAR2
20: , p12_a0 out nocopy JTF_NUMBER_TABLE
21: , p12_a1 out nocopy JTF_DATE_TABLE
22: , p12_a2 out nocopy JTF_DATE_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
19: , x_msg_data out nocopy VARCHAR2
20: , p12_a0 out nocopy JTF_NUMBER_TABLE
21: , p12_a1 out nocopy JTF_DATE_TABLE
22: , p12_a2 out nocopy JTF_DATE_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
20: , p12_a0 out nocopy JTF_NUMBER_TABLE
21: , p12_a1 out nocopy JTF_DATE_TABLE
22: , p12_a2 out nocopy JTF_DATE_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
21: , p12_a1 out nocopy JTF_DATE_TABLE
22: , p12_a2 out nocopy JTF_DATE_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
23: , p12_a3 out nocopy JTF_NUMBER_TABLE
24: , p12_a4 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
25: , p12_a5 out nocopy JTF_NUMBER_TABLE
26: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
27: , p12_a7 out nocopy JTF_NUMBER_TABLE
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
28: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
29: , p12_a9 out nocopy JTF_NUMBER_TABLE
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
30: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , p12_a11 out nocopy JTF_NUMBER_TABLE
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
32: , p12_a12 out nocopy JTF_NUMBER_TABLE
33: , p12_a13 out nocopy JTF_NUMBER_TABLE
34: , p12_a14 out nocopy JTF_NUMBER_TABLE
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE
40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
35: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
36: , p12_a16 out nocopy JTF_NUMBER_TABLE
37: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
38: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
39: , p12_a19 out nocopy JTF_NUMBER_TABLE
40: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
41: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
42: , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
43: , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
52: , p12_a32 out nocopy JTF_VARCHAR2_TABLE_200
53: , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
54: , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
55: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
56: , p12_a36 out nocopy JTF_NUMBER_TABLE
57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
54: , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
55: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
56: , p12_a36 out nocopy JTF_NUMBER_TABLE
57: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
58: , p12_a38 out nocopy JTF_NUMBER_TABLE
59: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
60: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
61: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
62: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300