1 package cn_trx_factor_pvt_w as
2 /* $Header: cnwtxfts.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_tbl_type, 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_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 );
12 procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_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_NUMBER_TABLE
17 , a5 out nocopy JTF_VARCHAR2_TABLE_100
18 , a6 out nocopy JTF_NUMBER_TABLE
19 , a7 out nocopy JTF_NUMBER_TABLE
20 );
21
22 procedure validate_trx_factor(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , p_action VARCHAR2
27 , p5_a0 in out nocopy NUMBER
28 , p5_a1 in out nocopy NUMBER
29 , p5_a2 in out nocopy NUMBER
30 , p5_a3 in out nocopy NUMBER
31 , p5_a4 in out nocopy NUMBER
32 , p5_a5 in out nocopy VARCHAR2
33 , p5_a6 in out nocopy NUMBER
34 , p5_a7 in out nocopy NUMBER
35 , p6_a0 NUMBER
36 , p6_a1 NUMBER
37 , p6_a2 NUMBER
38 , p6_a3 NUMBER
39 , p6_a4 NUMBER
40 , p6_a5 VARCHAR2
41 , p6_a6 NUMBER
42 , p6_a7 NUMBER
43 , x_return_status out nocopy VARCHAR2
44 , x_msg_count out nocopy NUMBER
45 , x_msg_data out nocopy VARCHAR2
46 );
47 procedure create_trx_factor(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
49 , p_commit VARCHAR2
50 , p_validation_level NUMBER
51 , p4_a0 in out nocopy NUMBER
52 , p4_a1 in out nocopy NUMBER
53 , p4_a2 in out nocopy NUMBER
54 , p4_a3 in out nocopy NUMBER
55 , p4_a4 in out nocopy NUMBER
56 , p4_a5 in out nocopy VARCHAR2
57 , p4_a6 in out nocopy NUMBER
58 , p4_a7 in out nocopy NUMBER
59 , x_return_status out nocopy VARCHAR2
60 , x_msg_count out nocopy NUMBER
61 , x_msg_data out nocopy VARCHAR2
62 );
63 procedure update_trx_factor(p_api_version NUMBER
64 , p_init_msg_list VARCHAR2
65 , p_commit VARCHAR2
66 , p_validation_level NUMBER
67 , p4_a0 in out nocopy NUMBER
68 , p4_a1 in out nocopy NUMBER
69 , p4_a2 in out nocopy NUMBER
70 , p4_a3 in out nocopy NUMBER
71 , p4_a4 in out nocopy NUMBER
72 , p4_a5 in out nocopy VARCHAR2
73 , p4_a6 in out nocopy NUMBER
74 , p4_a7 in out nocopy NUMBER
75 , x_return_status out nocopy VARCHAR2
76 , x_msg_count out nocopy NUMBER
77 , x_msg_data out nocopy VARCHAR2
78 );
79 procedure delete_trx_factor(p_api_version NUMBER
80 , p_init_msg_list VARCHAR2
81 , p_commit VARCHAR2
82 , p_validation_level NUMBER
83 , p4_a0 in out nocopy NUMBER
84 , p4_a1 in out nocopy NUMBER
85 , p4_a2 in out nocopy NUMBER
86 , p4_a3 in out nocopy NUMBER
87 , p4_a4 in out nocopy NUMBER
88 , p4_a5 in out nocopy VARCHAR2
89 , p4_a6 in out nocopy NUMBER
90 , p4_a7 in out nocopy NUMBER
91 , x_return_status out nocopy VARCHAR2
92 , x_msg_count out nocopy NUMBER
93 , x_msg_data out nocopy VARCHAR2
94 );
95 procedure get_trx_factor(p_api_version NUMBER
96 , p_init_msg_list VARCHAR2
97 , p_commit VARCHAR2
98 , p_validation_level NUMBER
99 , p_quota_rule_id NUMBER
100 , p5_a0 out nocopy JTF_NUMBER_TABLE
101 , p5_a1 out nocopy JTF_NUMBER_TABLE
102 , p5_a2 out nocopy JTF_NUMBER_TABLE
103 , p5_a3 out nocopy JTF_NUMBER_TABLE
104 , p5_a4 out nocopy JTF_NUMBER_TABLE
105 , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
106 , p5_a6 out nocopy JTF_NUMBER_TABLE
107 , p5_a7 out nocopy JTF_NUMBER_TABLE
108 , x_return_status out nocopy VARCHAR2
109 , x_msg_count out nocopy NUMBER
110 , x_msg_data out nocopy VARCHAR2
111 );
112 end cn_trx_factor_pvt_w;