1 package okl_transaction_pub_w as
2 /* $Header: OKLUTXNS.pls 120.1 2005/07/20 10:11:13 dkagrawa noship $ */
3 procedure create_transaction(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , x_return_status out nocopy VARCHAR2
6 , x_msg_count out nocopy NUMBER
7 , x_msg_data out nocopy VARCHAR2
8 , p_chr_id NUMBER
9 , p_new_chr_id NUMBER
10 , p_reason_code VARCHAR2
11 , p_description VARCHAR2
12 , p_trx_date date
13 , p_trx_type VARCHAR2
14 , p11_a0 out nocopy NUMBER
15 , p11_a1 out nocopy NUMBER
16 , p11_a2 out nocopy VARCHAR2
17 , p11_a3 out nocopy VARCHAR2
18 , p11_a4 out nocopy VARCHAR2
19 , p11_a5 out nocopy VARCHAR2
20 , p11_a6 out nocopy NUMBER
21 , p11_a7 out nocopy NUMBER
22 , p11_a8 out nocopy NUMBER
23 , p11_a9 out nocopy NUMBER
24 , p11_a10 out nocopy NUMBER
25 , p11_a11 out nocopy NUMBER
26 , p11_a12 out nocopy VARCHAR2
27 , p11_a13 out nocopy VARCHAR2
28 , p11_a14 out nocopy DATE
29 , p11_a15 out nocopy VARCHAR2
30 , p11_a16 out nocopy VARCHAR2
31 , p11_a17 out nocopy NUMBER
32 , p11_a18 out nocopy VARCHAR2
33 , p11_a19 out nocopy VARCHAR2
34 , p11_a20 out nocopy VARCHAR2
35 , p11_a21 out nocopy VARCHAR2
36 , p11_a22 out nocopy VARCHAR2
37 , p11_a23 out nocopy VARCHAR2
38 , p11_a24 out nocopy VARCHAR2
39 , p11_a25 out nocopy VARCHAR2
40 , p11_a26 out nocopy VARCHAR2
41 , p11_a27 out nocopy VARCHAR2
42 , p11_a28 out nocopy VARCHAR2
43 , p11_a29 out nocopy VARCHAR2
44 , p11_a30 out nocopy VARCHAR2
45 , p11_a31 out nocopy VARCHAR2
46 , p11_a32 out nocopy VARCHAR2
47 , p11_a33 out nocopy VARCHAR2
48 , p11_a34 out nocopy VARCHAR2
49 , p11_a35 out nocopy VARCHAR2
50 , p11_a36 out nocopy VARCHAR2
51 , p11_a37 out nocopy NUMBER
52 , p11_a38 out nocopy VARCHAR2
53 , p11_a39 out nocopy NUMBER
54 , p11_a40 out nocopy VARCHAR2
55 , p11_a41 out nocopy VARCHAR2
56 , p11_a42 out nocopy NUMBER
57 , p11_a43 out nocopy NUMBER
58 , p11_a44 out nocopy NUMBER
59 , p11_a45 out nocopy NUMBER
60 , p11_a46 out nocopy NUMBER
61 , p11_a47 out nocopy NUMBER
62 , p11_a48 out nocopy DATE
63 , p11_a49 out nocopy NUMBER
64 , p11_a50 out nocopy DATE
65 , p11_a51 out nocopy NUMBER
66 , p11_a52 out nocopy DATE
67 , p11_a53 out nocopy NUMBER
68 , p11_a54 out nocopy NUMBER
69 , p11_a55 out nocopy VARCHAR2
70 , p11_a56 out nocopy NUMBER
71 , p11_a57 out nocopy VARCHAR2
72 , p11_a58 out nocopy DATE
73 , p11_a59 out nocopy VARCHAR2
74 , p11_a60 out nocopy VARCHAR2
75 , p11_a61 out nocopy VARCHAR2
76 , p11_a62 out nocopy VARCHAR2
77 , p11_a63 out nocopy VARCHAR2
78 , p11_a64 out nocopy VARCHAR2
79 , p11_a65 out nocopy VARCHAR2
80 , p11_a66 out nocopy VARCHAR2
81 , p11_a67 out nocopy VARCHAR2
82 , p11_a68 out nocopy VARCHAR2
83 , p11_a69 out nocopy VARCHAR2
84 , p11_a70 out nocopy VARCHAR2
85 , p11_a71 out nocopy VARCHAR2
86 , p11_a72 out nocopy VARCHAR2
87 , p11_a73 out nocopy VARCHAR2
88 , p11_a74 out nocopy VARCHAR2
89 , p11_a75 out nocopy VARCHAR2
90 , p11_a76 out nocopy VARCHAR2
91 , p11_a77 out nocopy NUMBER
92 , p11_a78 out nocopy DATE
93 , p11_a79 out nocopy NUMBER
94 , p11_a80 out nocopy NUMBER
95 , p11_a81 out nocopy VARCHAR2
96 , p11_a82 out nocopy DATE
97 );
98 procedure update_trx_status(p_api_version NUMBER
99 , p_init_msg_list VARCHAR2
100 , x_return_status out nocopy VARCHAR2
101 , x_msg_count out nocopy NUMBER
102 , x_msg_data out nocopy VARCHAR2
103 , p_chr_id NUMBER
104 , p_status VARCHAR2
105 , p7_a0 out nocopy NUMBER
106 , p7_a1 out nocopy NUMBER
107 , p7_a2 out nocopy VARCHAR2
108 , p7_a3 out nocopy VARCHAR2
109 , p7_a4 out nocopy VARCHAR2
110 , p7_a5 out nocopy VARCHAR2
111 , p7_a6 out nocopy NUMBER
112 , p7_a7 out nocopy NUMBER
113 , p7_a8 out nocopy NUMBER
114 , p7_a9 out nocopy NUMBER
115 , p7_a10 out nocopy NUMBER
116 , p7_a11 out nocopy NUMBER
117 , p7_a12 out nocopy VARCHAR2
118 , p7_a13 out nocopy VARCHAR2
119 , p7_a14 out nocopy DATE
120 , p7_a15 out nocopy VARCHAR2
121 , p7_a16 out nocopy VARCHAR2
122 , p7_a17 out nocopy NUMBER
123 , p7_a18 out nocopy VARCHAR2
124 , p7_a19 out nocopy VARCHAR2
125 , p7_a20 out nocopy VARCHAR2
126 , p7_a21 out nocopy VARCHAR2
127 , p7_a22 out nocopy VARCHAR2
128 , p7_a23 out nocopy VARCHAR2
129 , p7_a24 out nocopy VARCHAR2
130 , p7_a25 out nocopy VARCHAR2
131 , p7_a26 out nocopy VARCHAR2
132 , p7_a27 out nocopy VARCHAR2
133 , p7_a28 out nocopy VARCHAR2
134 , p7_a29 out nocopy VARCHAR2
135 , p7_a30 out nocopy VARCHAR2
136 , p7_a31 out nocopy VARCHAR2
137 , p7_a32 out nocopy VARCHAR2
138 , p7_a33 out nocopy VARCHAR2
139 , p7_a34 out nocopy VARCHAR2
140 , p7_a35 out nocopy VARCHAR2
141 , p7_a36 out nocopy VARCHAR2
142 , p7_a37 out nocopy NUMBER
143 , p7_a38 out nocopy VARCHAR2
144 , p7_a39 out nocopy NUMBER
145 , p7_a40 out nocopy VARCHAR2
146 , p7_a41 out nocopy VARCHAR2
147 , p7_a42 out nocopy NUMBER
148 , p7_a43 out nocopy NUMBER
149 , p7_a44 out nocopy NUMBER
150 , p7_a45 out nocopy NUMBER
151 , p7_a46 out nocopy NUMBER
152 , p7_a47 out nocopy NUMBER
153 , p7_a48 out nocopy DATE
154 , p7_a49 out nocopy NUMBER
155 , p7_a50 out nocopy DATE
156 , p7_a51 out nocopy NUMBER
157 , p7_a52 out nocopy DATE
158 , p7_a53 out nocopy NUMBER
159 , p7_a54 out nocopy NUMBER
160 , p7_a55 out nocopy VARCHAR2
161 , p7_a56 out nocopy NUMBER
162 , p7_a57 out nocopy VARCHAR2
163 , p7_a58 out nocopy DATE
164 , p7_a59 out nocopy VARCHAR2
165 , p7_a60 out nocopy VARCHAR2
166 , p7_a61 out nocopy VARCHAR2
167 , p7_a62 out nocopy VARCHAR2
168 , p7_a63 out nocopy VARCHAR2
169 , p7_a64 out nocopy VARCHAR2
170 , p7_a65 out nocopy VARCHAR2
171 , p7_a66 out nocopy VARCHAR2
172 , p7_a67 out nocopy VARCHAR2
173 , p7_a68 out nocopy VARCHAR2
174 , p7_a69 out nocopy VARCHAR2
175 , p7_a70 out nocopy VARCHAR2
176 , p7_a71 out nocopy VARCHAR2
177 , p7_a72 out nocopy VARCHAR2
178 , p7_a73 out nocopy VARCHAR2
179 , p7_a74 out nocopy VARCHAR2
180 , p7_a75 out nocopy VARCHAR2
181 , p7_a76 out nocopy VARCHAR2
182 , p7_a77 out nocopy NUMBER
183 , p7_a78 out nocopy DATE
184 , p7_a79 out nocopy NUMBER
185 , p7_a80 out nocopy NUMBER
186 , p7_a81 out nocopy VARCHAR2
187 , p7_a82 out nocopy DATE
188 );
189 procedure abandon_revisions(p_api_version NUMBER
190 , p_init_msg_list VARCHAR2
191 , x_return_status out nocopy VARCHAR2
192 , x_msg_count out nocopy NUMBER
193 , x_msg_data out nocopy VARCHAR2
194 , p5_a0 JTF_NUMBER_TABLE
195 , p_contract_status VARCHAR2
196 , p_tsu_code VARCHAR2
197 );
198 end okl_transaction_pub_w;
[Home] [Help]