1 package pa_deductions_w AUTHID CURRENT_USER as
2 /* $Header: PADCTNRS.pls 120.1.12010000.1 2009/07/21 10:59:27 sosharma noship $ */
3 procedure rosetta_table_copy_in_p0(t out nocopy pa_deductions.g_dctn_hdrid, a0 JTF_NUMBER_TABLE);
4 procedure rosetta_table_copy_out_p0(t pa_deductions.g_dctn_hdrid, a0 out nocopy JTF_NUMBER_TABLE);
5
6 procedure rosetta_table_copy_in_p1(t out nocopy pa_deductions.g_dctn_txnid, a0 JTF_NUMBER_TABLE);
7 procedure rosetta_table_copy_out_p1(t pa_deductions.g_dctn_txnid, a0 out nocopy JTF_NUMBER_TABLE);
8
9 procedure rosetta_table_copy_in_p4(t out nocopy pa_deductions.g_dctn_hdrtbl, a0 JTF_NUMBER_TABLE
10 , a1 JTF_NUMBER_TABLE
11 , a2 JTF_NUMBER_TABLE
12 , a3 JTF_NUMBER_TABLE
13 , a4 JTF_VARCHAR2_TABLE_100
14 , a5 JTF_VARCHAR2_TABLE_100
15 , a6 JTF_NUMBER_TABLE
16 , a7 JTF_VARCHAR2_TABLE_100
17 , a8 JTF_NUMBER_TABLE
18 , a9 JTF_VARCHAR2_TABLE_100
19 , a10 JTF_VARCHAR2_TABLE_100
20 , a11 JTF_VARCHAR2_TABLE_100
21 , a12 JTF_VARCHAR2_TABLE_100
22 , a13 JTF_DATE_TABLE
23 , a14 JTF_NUMBER_TABLE
24 , a15 JTF_NUMBER_TABLE
25 , a16 JTF_DATE_TABLE
26 , a17 JTF_DATE_TABLE
27 , a18 JTF_VARCHAR2_TABLE_4000
28 , a19 JTF_VARCHAR2_TABLE_100
29 , a20 JTF_NUMBER_TABLE
30 );
31 procedure rosetta_table_copy_out_p4(t pa_deductions.g_dctn_hdrtbl, a0 out nocopy JTF_NUMBER_TABLE
32 , a1 out nocopy JTF_NUMBER_TABLE
33 , a2 out nocopy JTF_NUMBER_TABLE
34 , a3 out nocopy JTF_NUMBER_TABLE
35 , a4 out nocopy JTF_VARCHAR2_TABLE_100
36 , a5 out nocopy JTF_VARCHAR2_TABLE_100
37 , a6 out nocopy JTF_NUMBER_TABLE
38 , a7 out nocopy JTF_VARCHAR2_TABLE_100
39 , a8 out nocopy JTF_NUMBER_TABLE
40 , a9 out nocopy JTF_VARCHAR2_TABLE_100
41 , a10 out nocopy JTF_VARCHAR2_TABLE_100
42 , a11 out nocopy JTF_VARCHAR2_TABLE_100
43 , a12 out nocopy JTF_VARCHAR2_TABLE_100
44 , a13 out nocopy JTF_DATE_TABLE
45 , a14 out nocopy JTF_NUMBER_TABLE
46 , a15 out nocopy JTF_NUMBER_TABLE
47 , a16 out nocopy JTF_DATE_TABLE
48 , a17 out nocopy JTF_DATE_TABLE
49 , a18 out nocopy JTF_VARCHAR2_TABLE_4000
50 , a19 out nocopy JTF_VARCHAR2_TABLE_100
51 , a20 out nocopy JTF_NUMBER_TABLE
52 );
53
54 procedure rosetta_table_copy_in_p5(t out nocopy pa_deductions.g_dctn_txntbl, a0 JTF_NUMBER_TABLE
55 , a1 JTF_NUMBER_TABLE
56 , a2 JTF_NUMBER_TABLE
57 , a3 JTF_NUMBER_TABLE
58 , a4 JTF_VARCHAR2_TABLE_100
59 , a5 JTF_DATE_TABLE
60 , a6 JTF_DATE_TABLE
61 , a7 JTF_NUMBER_TABLE
62 , a8 JTF_NUMBER_TABLE
63 , a9 JTF_NUMBER_TABLE
64 , a10 JTF_NUMBER_TABLE
65 , a11 JTF_VARCHAR2_TABLE_100
66 , a12 JTF_NUMBER_TABLE
67 , a13 JTF_NUMBER_TABLE
68 , a14 JTF_VARCHAR2_TABLE_100
69 , a15 JTF_DATE_TABLE
70 , a16 JTF_NUMBER_TABLE
71 , a17 JTF_NUMBER_TABLE
72 , a18 JTF_VARCHAR2_TABLE_4000
73 , a19 JTF_VARCHAR2_TABLE_100
74 );
75 procedure rosetta_table_copy_out_p5(t pa_deductions.g_dctn_txntbl, a0 out nocopy JTF_NUMBER_TABLE
76 , a1 out nocopy JTF_NUMBER_TABLE
77 , a2 out nocopy JTF_NUMBER_TABLE
78 , a3 out nocopy JTF_NUMBER_TABLE
79 , a4 out nocopy JTF_VARCHAR2_TABLE_100
80 , a5 out nocopy JTF_DATE_TABLE
81 , a6 out nocopy JTF_DATE_TABLE
82 , a7 out nocopy JTF_NUMBER_TABLE
83 , a8 out nocopy JTF_NUMBER_TABLE
84 , a9 out nocopy JTF_NUMBER_TABLE
85 , a10 out nocopy JTF_NUMBER_TABLE
86 , a11 out nocopy JTF_VARCHAR2_TABLE_100
87 , a12 out nocopy JTF_NUMBER_TABLE
88 , a13 out nocopy JTF_NUMBER_TABLE
89 , a14 out nocopy JTF_VARCHAR2_TABLE_100
90 , a15 out nocopy JTF_DATE_TABLE
91 , a16 out nocopy JTF_NUMBER_TABLE
92 , a17 out nocopy JTF_NUMBER_TABLE
93 , a18 out nocopy JTF_VARCHAR2_TABLE_4000
94 , a19 out nocopy JTF_VARCHAR2_TABLE_100
95 );
96
97 procedure create_deduction_hdr(p0_a0 in out nocopy JTF_NUMBER_TABLE
98 , p0_a1 in out nocopy JTF_NUMBER_TABLE
99 , p0_a2 in out nocopy JTF_NUMBER_TABLE
100 , p0_a3 in out nocopy JTF_NUMBER_TABLE
101 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
102 , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
103 , p0_a6 in out nocopy JTF_NUMBER_TABLE
104 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
105 , p0_a8 in out nocopy JTF_NUMBER_TABLE
106 , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
107 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
108 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
109 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
110 , p0_a13 in out nocopy JTF_DATE_TABLE
111 , p0_a14 in out nocopy JTF_NUMBER_TABLE
112 , p0_a15 in out nocopy JTF_NUMBER_TABLE
113 , p0_a16 in out nocopy JTF_DATE_TABLE
114 , p0_a17 in out nocopy JTF_DATE_TABLE
115 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
116 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
117 , p0_a20 in out nocopy JTF_NUMBER_TABLE
118 , p_msg_count out nocopy NUMBER
119 , p_msg_data out nocopy VARCHAR2
120 , p_return_status out nocopy VARCHAR2
121 , p_calling_mode VARCHAR2
122 );
123 procedure create_deduction_txn(p0_a0 in out nocopy JTF_NUMBER_TABLE
124 , p0_a1 in out nocopy JTF_NUMBER_TABLE
125 , p0_a2 in out nocopy JTF_NUMBER_TABLE
126 , p0_a3 in out nocopy JTF_NUMBER_TABLE
127 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
128 , p0_a5 in out nocopy JTF_DATE_TABLE
129 , p0_a6 in out nocopy JTF_DATE_TABLE
130 , p0_a7 in out nocopy JTF_NUMBER_TABLE
131 , p0_a8 in out nocopy JTF_NUMBER_TABLE
132 , p0_a9 in out nocopy JTF_NUMBER_TABLE
133 , p0_a10 in out nocopy JTF_NUMBER_TABLE
134 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
135 , p0_a12 in out nocopy JTF_NUMBER_TABLE
136 , p0_a13 in out nocopy JTF_NUMBER_TABLE
137 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
138 , p0_a15 in out nocopy JTF_DATE_TABLE
139 , p0_a16 in out nocopy JTF_NUMBER_TABLE
140 , p0_a17 in out nocopy JTF_NUMBER_TABLE
141 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
142 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
143 , p_msg_count out nocopy NUMBER
144 , p_msg_data out nocopy VARCHAR2
145 , p_return_status out nocopy VARCHAR2
146 , p_calling_mode VARCHAR2
147 );
148 procedure update_deduction_hdr(p0_a0 in out nocopy JTF_NUMBER_TABLE
149 , p0_a1 in out nocopy JTF_NUMBER_TABLE
150 , p0_a2 in out nocopy JTF_NUMBER_TABLE
151 , p0_a3 in out nocopy JTF_NUMBER_TABLE
152 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
153 , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
154 , p0_a6 in out nocopy JTF_NUMBER_TABLE
155 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
156 , p0_a8 in out nocopy JTF_NUMBER_TABLE
157 , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
158 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
159 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
160 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
161 , p0_a13 in out nocopy JTF_DATE_TABLE
162 , p0_a14 in out nocopy JTF_NUMBER_TABLE
163 , p0_a15 in out nocopy JTF_NUMBER_TABLE
164 , p0_a16 in out nocopy JTF_DATE_TABLE
165 , p0_a17 in out nocopy JTF_DATE_TABLE
166 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
167 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
168 , p0_a20 in out nocopy JTF_NUMBER_TABLE
169 , p_msg_count out nocopy NUMBER
170 , p_msg_data out nocopy VARCHAR2
171 , p_return_status out nocopy VARCHAR2
172 , p_calling_mode VARCHAR2
173 );
174 procedure update_deduction_txn(p0_a0 in out nocopy JTF_NUMBER_TABLE
175 , p0_a1 in out nocopy JTF_NUMBER_TABLE
176 , p0_a2 in out nocopy JTF_NUMBER_TABLE
177 , p0_a3 in out nocopy JTF_NUMBER_TABLE
178 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
179 , p0_a5 in out nocopy JTF_DATE_TABLE
180 , p0_a6 in out nocopy JTF_DATE_TABLE
181 , p0_a7 in out nocopy JTF_NUMBER_TABLE
182 , p0_a8 in out nocopy JTF_NUMBER_TABLE
183 , p0_a9 in out nocopy JTF_NUMBER_TABLE
184 , p0_a10 in out nocopy JTF_NUMBER_TABLE
185 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
186 , p0_a12 in out nocopy JTF_NUMBER_TABLE
187 , p0_a13 in out nocopy JTF_NUMBER_TABLE
188 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
189 , p0_a15 in out nocopy JTF_DATE_TABLE
190 , p0_a16 in out nocopy JTF_NUMBER_TABLE
191 , p0_a17 in out nocopy JTF_NUMBER_TABLE
192 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
193 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
194 , p_msg_count out nocopy NUMBER
195 , p_msg_data out nocopy VARCHAR2
196 , p_return_status out nocopy VARCHAR2
197 , p_calling_mode VARCHAR2
198 );
199 procedure delete_deduction_hdr(p_dctn_hdrid JTF_NUMBER_TABLE
200 , p_msg_count out nocopy NUMBER
201 , p_msg_data out nocopy VARCHAR2
202 , p_return_status out nocopy VARCHAR2
203 );
204 procedure delete_deduction_txn(p_dctn_txnid JTF_NUMBER_TABLE
205 , p_msg_count out nocopy NUMBER
206 , p_msg_data out nocopy VARCHAR2
207 , p_return_status out nocopy VARCHAR2
208 );
209 procedure validate_deduction_hdr(p0_a0 in out nocopy JTF_NUMBER_TABLE
210 , p0_a1 in out nocopy JTF_NUMBER_TABLE
211 , p0_a2 in out nocopy JTF_NUMBER_TABLE
212 , p0_a3 in out nocopy JTF_NUMBER_TABLE
213 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
214 , p0_a5 in out nocopy JTF_VARCHAR2_TABLE_100
215 , p0_a6 in out nocopy JTF_NUMBER_TABLE
216 , p0_a7 in out nocopy JTF_VARCHAR2_TABLE_100
217 , p0_a8 in out nocopy JTF_NUMBER_TABLE
218 , p0_a9 in out nocopy JTF_VARCHAR2_TABLE_100
219 , p0_a10 in out nocopy JTF_VARCHAR2_TABLE_100
220 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
221 , p0_a12 in out nocopy JTF_VARCHAR2_TABLE_100
222 , p0_a13 in out nocopy JTF_DATE_TABLE
223 , p0_a14 in out nocopy JTF_NUMBER_TABLE
224 , p0_a15 in out nocopy JTF_NUMBER_TABLE
225 , p0_a16 in out nocopy JTF_DATE_TABLE
226 , p0_a17 in out nocopy JTF_DATE_TABLE
227 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
228 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
229 , p0_a20 in out nocopy JTF_NUMBER_TABLE
230 , p_msg_count out nocopy NUMBER
231 , p_msg_data out nocopy VARCHAR2
232 , p_return_status out nocopy VARCHAR2
233 , p_calling_mode VARCHAR2
234 , ddrosetta_retval_bool OUT NOCOPY NUMBER
235 );
236 procedure validate_deduction_txn(p0_a0 in out nocopy JTF_NUMBER_TABLE
237 , p0_a1 in out nocopy JTF_NUMBER_TABLE
238 , p0_a2 in out nocopy JTF_NUMBER_TABLE
239 , p0_a3 in out nocopy JTF_NUMBER_TABLE
240 , p0_a4 in out nocopy JTF_VARCHAR2_TABLE_100
241 , p0_a5 in out nocopy JTF_DATE_TABLE
242 , p0_a6 in out nocopy JTF_DATE_TABLE
243 , p0_a7 in out nocopy JTF_NUMBER_TABLE
244 , p0_a8 in out nocopy JTF_NUMBER_TABLE
245 , p0_a9 in out nocopy JTF_NUMBER_TABLE
246 , p0_a10 in out nocopy JTF_NUMBER_TABLE
247 , p0_a11 in out nocopy JTF_VARCHAR2_TABLE_100
248 , p0_a12 in out nocopy JTF_NUMBER_TABLE
249 , p0_a13 in out nocopy JTF_NUMBER_TABLE
250 , p0_a14 in out nocopy JTF_VARCHAR2_TABLE_100
251 , p0_a15 in out nocopy JTF_DATE_TABLE
252 , p0_a16 in out nocopy JTF_NUMBER_TABLE
253 , p0_a17 in out nocopy JTF_NUMBER_TABLE
254 , p0_a18 in out nocopy JTF_VARCHAR2_TABLE_4000
255 , p0_a19 in out nocopy JTF_VARCHAR2_TABLE_100
256 , p_msg_count out nocopy NUMBER
257 , p_msg_data out nocopy VARCHAR2
258 , p_return_status out nocopy VARCHAR2
259 , p_calling_mode VARCHAR2
260 , ddrosetta_retval_bool OUT NOCOPY NUMBER
261 );
262 end pa_deductions_w;
[Home] [Help]