1: package cn_pmt_trans_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwpmtrs.pls 120.4 2005/12/23 09:26 fmburu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_pmt_trans_pvt.pmt_tran_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package cn_pmt_trans_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwpmtrs.pls 120.4 2005/12/23 09:26 fmburu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_pmt_trans_pvt.pmt_tran_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package cn_pmt_trans_pvt_w AUTHID CURRENT_USER as
2: /* $Header: cnwpmtrs.pls 120.4 2005/12/23 09:26 fmburu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_pmt_trans_pvt.pmt_tran_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: cnwpmtrs.pls 120.4 2005/12/23 09:26 fmburu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_pmt_trans_pvt.pmt_tran_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_pmt_trans_pvt.pmt_tran_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: );
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: );
20: procedure rosetta_table_copy_out_p1(t cn_pmt_trans_pvt.pmt_tran_tbl, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: );
20: procedure rosetta_table_copy_out_p1(t cn_pmt_trans_pvt.pmt_tran_tbl, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: );
20: procedure rosetta_table_copy_out_p1(t cn_pmt_trans_pvt.pmt_tran_tbl, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_VARCHAR2_TABLE_100
26: , a6 out nocopy JTF_VARCHAR2_TABLE_100
19: );
20: procedure rosetta_table_copy_out_p1(t cn_pmt_trans_pvt.pmt_tran_tbl, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_VARCHAR2_TABLE_100
26: , a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , a7 out nocopy JTF_VARCHAR2_TABLE_100
20: procedure rosetta_table_copy_out_p1(t cn_pmt_trans_pvt.pmt_tran_tbl, a0 out nocopy JTF_NUMBER_TABLE
21: , a1 out nocopy JTF_NUMBER_TABLE
22: , a2 out nocopy JTF_NUMBER_TABLE
23: , a3 out nocopy JTF_NUMBER_TABLE
24: , a4 out nocopy JTF_NUMBER_TABLE
25: , a5 out nocopy JTF_VARCHAR2_TABLE_100
26: , a6 out nocopy JTF_VARCHAR2_TABLE_100
27: , a7 out nocopy JTF_VARCHAR2_TABLE_100
28: , a8 out nocopy JTF_VARCHAR2_TABLE_100
28: , a8 out nocopy JTF_VARCHAR2_TABLE_100
29: , a9 out nocopy JTF_VARCHAR2_TABLE_100
30: , a10 out nocopy JTF_VARCHAR2_TABLE_100
31: , a11 out nocopy JTF_VARCHAR2_TABLE_100
32: , a12 out nocopy JTF_NUMBER_TABLE
33: , a13 out nocopy JTF_VARCHAR2_TABLE_100
34: , a14 out nocopy JTF_VARCHAR2_TABLE_100
35: , a15 out nocopy JTF_VARCHAR2_TABLE_100
36: );
35: , a15 out nocopy JTF_VARCHAR2_TABLE_100
36: );
37:
38: procedure rosetta_table_copy_in_p3(t out nocopy cn_pmt_trans_pvt.pmt_process_tbl, a0 JTF_VARCHAR2_TABLE_300
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_NUMBER_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
36: );
37:
38: procedure rosetta_table_copy_in_p3(t out nocopy cn_pmt_trans_pvt.pmt_process_tbl, a0 JTF_VARCHAR2_TABLE_300
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_NUMBER_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
44: , a6 JTF_NUMBER_TABLE
37:
38: procedure rosetta_table_copy_in_p3(t out nocopy cn_pmt_trans_pvt.pmt_process_tbl, a0 JTF_VARCHAR2_TABLE_300
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_NUMBER_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
38: procedure rosetta_table_copy_in_p3(t out nocopy cn_pmt_trans_pvt.pmt_process_tbl, a0 JTF_VARCHAR2_TABLE_300
39: , a1 JTF_NUMBER_TABLE
40: , a2 JTF_NUMBER_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
46: , a8 JTF_VARCHAR2_TABLE_100
40: , a2 JTF_NUMBER_TABLE
41: , a3 JTF_NUMBER_TABLE
42: , a4 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
46: , a8 JTF_VARCHAR2_TABLE_100
47: , a9 JTF_NUMBER_TABLE
48: , a10 JTF_NUMBER_TABLE
43: , a5 JTF_VARCHAR2_TABLE_4000
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
46: , a8 JTF_VARCHAR2_TABLE_100
47: , a9 JTF_NUMBER_TABLE
48: , a10 JTF_NUMBER_TABLE
49: , a11 JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
44: , a6 JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
46: , a8 JTF_VARCHAR2_TABLE_100
47: , a9 JTF_NUMBER_TABLE
48: , a10 JTF_NUMBER_TABLE
49: , a11 JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
45: , a7 JTF_VARCHAR2_TABLE_4000
46: , a8 JTF_VARCHAR2_TABLE_100
47: , a9 JTF_NUMBER_TABLE
48: , a10 JTF_NUMBER_TABLE
49: , a11 JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_NUMBER_TABLE
48: , a10 JTF_NUMBER_TABLE
49: , a11 JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
49: , a11 JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
57: , a6 out nocopy JTF_NUMBER_TABLE
50: );
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
51: procedure rosetta_table_copy_out_p3(t cn_pmt_trans_pvt.pmt_process_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
52: , a1 out nocopy JTF_NUMBER_TABLE
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_NUMBER_TABLE
61: , a10 out nocopy JTF_NUMBER_TABLE
56: , a5 out nocopy JTF_VARCHAR2_TABLE_4000
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_NUMBER_TABLE
61: , a10 out nocopy JTF_NUMBER_TABLE
62: , a11 out nocopy JTF_NUMBER_TABLE
63: );
64:
57: , a6 out nocopy JTF_NUMBER_TABLE
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_NUMBER_TABLE
61: , a10 out nocopy JTF_NUMBER_TABLE
62: , a11 out nocopy JTF_NUMBER_TABLE
63: );
64:
65: procedure process_pmt_transactions(p_api_version NUMBER
58: , a7 out nocopy JTF_VARCHAR2_TABLE_4000
59: , a8 out nocopy JTF_VARCHAR2_TABLE_100
60: , a9 out nocopy JTF_NUMBER_TABLE
61: , a10 out nocopy JTF_NUMBER_TABLE
62: , a11 out nocopy JTF_NUMBER_TABLE
63: );
64:
65: procedure process_pmt_transactions(p_api_version NUMBER
66: , p_init_msg_list VARCHAR2