1 PACKAGE pay_jp_result_pkg AUTHID CURRENT_USER AS
2 /* $Header: pyjprslt.pkh 115.2 2003/07/09 06:23:03 ytohya noship $ */
3 TYPE balance_type_ids_t IS TABLE OF NUMBER(9);
4 --
5 -- (Run) Result Values index by input_value_id.
6 --
7 TYPE result_value_t IS RECORD(
8 data_type VARCHAR2(30) NOT NULL := 'T',
9 result_value PAY_RUN_RESULT_VALUES.RESULT_VALUE%TYPE);
10 TYPE result_values_by_iv_t IS TABLE OF result_value_t INDEX BY BINARY_INTEGER;
11 --
12 -- Balance Values index by balance_type_id.
13 --
14 TYPE balance_values_by_bal_t IS TABLE OF NUMBER NOT NULL INDEX BY BINARY_INTEGER;
15 --
16 PROCEDURE result_values_internal(
17 p_assignment_action_id IN NUMBER,
18 p_effective_date IN DATE,
19 p_result_values_by_iv IN OUT NOCOPY result_values_by_iv_t);
20 --
21 PROCEDURE balance_values_internal(
22 p_result_values_by_iv IN result_values_by_iv_t,
23 p_balance_type_ids IN balance_type_ids_t,
24 p_feed_checking_date IN DATE,
25 p_balance_values_by_bal IN OUT NOCOPY balance_values_by_bal_t);
26 --
27 PROCEDURE run_internal(
28 p_assignment_action_id IN NUMBER,
29 p_feed_checking_date IN DATE,
30 p_balance_type_ids IN balance_type_ids_t,
31 p_result_values_by_iv IN OUT NOCOPY result_values_by_iv_t,
32 p_balance_values_by_bal IN OUT NOCOPY balance_values_by_bal_t);
33 --
34 FUNCTION result_value(
35 p_result_values_by_iv IN result_values_by_iv_t,
36 p_input_value_id IN NUMBER) RETURN VARCHAR2;
37 --
38 FUNCTION balance_value(
39 p_balance_values_by_bal IN balance_values_by_bal_t,
40 p_balance_type_id IN NUMBER) RETURN NUMBER;
41 --
42 /* BUG1899306: Obsoleted run and prepay functions *************************
43 FUNCTION run(
44 p_assignment_action_id IN NUMBER,
45 p_input_value_id1 IN NUMBER DEFAULT NULL,
46 p_input_value_id2 IN NUMBER DEFAULT NULL,
47 p_input_value_id3 IN NUMBER DEFAULT NULL,
48 p_input_value_id4 IN NUMBER DEFAULT NULL,
49 p_input_value_id5 IN NUMBER DEFAULT NULL,
50 p_input_value_id6 IN NUMBER DEFAULT NULL,
51 p_input_value_id7 IN NUMBER DEFAULT NULL,
52 p_input_value_id8 IN NUMBER DEFAULT NULL,
53 p_input_value_id9 IN NUMBER DEFAULT NULL,
54 p_input_value_id10 IN NUMBER DEFAULT NULL,
55 p_input_value_id11 IN NUMBER DEFAULT NULL,
56 p_input_value_id12 IN NUMBER DEFAULT NULL,
57 p_input_value_id13 IN NUMBER DEFAULT NULL,
58 p_input_value_id14 IN NUMBER DEFAULT NULL,
59 p_input_value_id15 IN NUMBER DEFAULT NULL,
60 p_input_value_id16 IN NUMBER DEFAULT NULL,
61 p_input_value_id17 IN NUMBER DEFAULT NULL,
62 p_input_value_id18 IN NUMBER DEFAULT NULL,
63 p_input_value_id19 IN NUMBER DEFAULT NULL,
64 p_input_value_id20 IN NUMBER DEFAULT NULL,
65 p_input_value_id21 IN NUMBER DEFAULT NULL,
66 p_input_value_id22 IN NUMBER DEFAULT NULL,
67 p_input_value_id23 IN NUMBER DEFAULT NULL,
68 p_input_value_id24 IN NUMBER DEFAULT NULL,
69 p_input_value_id25 IN NUMBER DEFAULT NULL,
70 p_input_value_id26 IN NUMBER DEFAULT NULL,
71 p_input_value_id27 IN NUMBER DEFAULT NULL,
72 p_input_value_id28 IN NUMBER DEFAULT NULL,
73 p_input_value_id29 IN NUMBER DEFAULT NULL,
74 p_input_value_id30 IN NUMBER DEFAULT NULL,
75 p_input_value_id31 IN NUMBER DEFAULT NULL,
76 p_input_value_id32 IN NUMBER DEFAULT NULL,
77 p_input_value_id33 IN NUMBER DEFAULT NULL,
78 p_input_value_id34 IN NUMBER DEFAULT NULL,
79 p_input_value_id35 IN NUMBER DEFAULT NULL,
80 p_input_value_id36 IN NUMBER DEFAULT NULL,
81 p_input_value_id37 IN NUMBER DEFAULT NULL,
82 p_input_value_id38 IN NUMBER DEFAULT NULL,
83 p_input_value_id39 IN NUMBER DEFAULT NULL,
84 p_input_value_id40 IN NUMBER DEFAULT NULL,
85 p_input_value_id41 IN NUMBER DEFAULT NULL,
86 p_input_value_id42 IN NUMBER DEFAULT NULL,
87 p_input_value_id43 IN NUMBER DEFAULT NULL,
88 p_input_value_id44 IN NUMBER DEFAULT NULL,
89 p_input_value_id45 IN NUMBER DEFAULT NULL,
90 p_input_value_id46 IN NUMBER DEFAULT NULL,
91 p_input_value_id47 IN NUMBER DEFAULT NULL,
92 p_input_value_id48 IN NUMBER DEFAULT NULL,
93 p_input_value_id49 IN NUMBER DEFAULT NULL,
94 p_input_value_id50 IN NUMBER DEFAULT NULL,
95 p_input_value_id51 IN NUMBER DEFAULT NULL,
96 p_input_value_id52 IN NUMBER DEFAULT NULL,
97 p_input_value_id53 IN NUMBER DEFAULT NULL,
98 p_input_value_id54 IN NUMBER DEFAULT NULL,
99 p_input_value_id55 IN NUMBER DEFAULT NULL,
100 p_input_value_id56 IN NUMBER DEFAULT NULL,
101 p_input_value_id57 IN NUMBER DEFAULT NULL,
102 p_input_value_id58 IN NUMBER DEFAULT NULL,
103 p_input_value_id59 IN NUMBER DEFAULT NULL,
104 p_input_value_id60 IN NUMBER DEFAULT NULL,
105 p_input_value_id61 IN NUMBER DEFAULT NULL,
106 p_input_value_id62 IN NUMBER DEFAULT NULL,
107 p_input_value_id63 IN NUMBER DEFAULT NULL,
108 p_input_value_id64 IN NUMBER DEFAULT NULL,
109 p_input_value_id65 IN NUMBER DEFAULT NULL,
110 p_input_value_id66 IN NUMBER DEFAULT NULL,
111 p_input_value_id67 IN NUMBER DEFAULT NULL,
112 p_input_value_id68 IN NUMBER DEFAULT NULL,
113 p_input_value_id69 IN NUMBER DEFAULT NULL,
114 p_input_value_id70 IN NUMBER DEFAULT NULL,
115 p_input_value_id71 IN NUMBER DEFAULT NULL,
116 p_input_value_id72 IN NUMBER DEFAULT NULL,
117 p_input_value_id73 IN NUMBER DEFAULT NULL,
118 p_input_value_id74 IN NUMBER DEFAULT NULL,
119 p_input_value_id75 IN NUMBER DEFAULT NULL,
120 p_input_value_id76 IN NUMBER DEFAULT NULL,
121 p_input_value_id77 IN NUMBER DEFAULT NULL,
122 p_input_value_id78 IN NUMBER DEFAULT NULL,
123 p_input_value_id79 IN NUMBER DEFAULT NULL,
124 p_input_value_id80 IN NUMBER DEFAULT NULL,
125 p_input_value_id81 IN NUMBER DEFAULT NULL,
126 p_input_value_id82 IN NUMBER DEFAULT NULL,
127 p_input_value_id83 IN NUMBER DEFAULT NULL,
128 p_input_value_id84 IN NUMBER DEFAULT NULL,
129 p_input_value_id85 IN NUMBER DEFAULT NULL,
130 p_input_value_id86 IN NUMBER DEFAULT NULL,
131 p_input_value_id87 IN NUMBER DEFAULT NULL,
132 p_input_value_id88 IN NUMBER DEFAULT NULL,
133 p_input_value_id89 IN NUMBER DEFAULT NULL,
134 p_input_value_id90 IN NUMBER DEFAULT NULL,
135 p_input_value_id91 IN NUMBER DEFAULT NULL,
136 p_input_value_id92 IN NUMBER DEFAULT NULL,
137 p_input_value_id93 IN NUMBER DEFAULT NULL,
138 p_input_value_id94 IN NUMBER DEFAULT NULL,
139 p_input_value_id95 IN NUMBER DEFAULT NULL,
140 p_input_value_id96 IN NUMBER DEFAULT NULL,
141 p_input_value_id97 IN NUMBER DEFAULT NULL,
142 p_input_value_id98 IN NUMBER DEFAULT NULL,
143 p_input_value_id99 IN NUMBER DEFAULT NULL,
144 p_input_value_id100 IN NUMBER DEFAULT NULL,
145 p_balance_type_id1 IN NUMBER DEFAULT NULL,
146 p_balance_type_id2 IN NUMBER DEFAULT NULL,
147 p_balance_type_id3 IN NUMBER DEFAULT NULL,
148 p_balance_type_id4 IN NUMBER DEFAULT NULL,
149 p_balance_type_id5 IN NUMBER DEFAULT NULL,
150 p_balance_type_id6 IN NUMBER DEFAULT NULL,
151 p_balance_type_id7 IN NUMBER DEFAULT NULL,
152 p_balance_type_id8 IN NUMBER DEFAULT NULL,
153 p_balance_type_id9 IN NUMBER DEFAULT NULL,
154 p_balance_type_id10 IN NUMBER DEFAULT NULL,
155 p_balance_type_id11 IN NUMBER DEFAULT NULL,
156 p_balance_type_id12 IN NUMBER DEFAULT NULL,
157 p_balance_type_id13 IN NUMBER DEFAULT NULL,
158 p_balance_type_id14 IN NUMBER DEFAULT NULL,
159 p_balance_type_id15 IN NUMBER DEFAULT NULL,
160 p_balance_type_id16 IN NUMBER DEFAULT NULL,
161 p_balance_type_id17 IN NUMBER DEFAULT NULL,
162 p_balance_type_id18 IN NUMBER DEFAULT NULL,
163 p_balance_type_id19 IN NUMBER DEFAULT NULL,
164 p_balance_type_id20 IN NUMBER DEFAULT NULL,
165 p_balance_type_id21 IN NUMBER DEFAULT NULL,
166 p_balance_type_id22 IN NUMBER DEFAULT NULL,
167 p_balance_type_id23 IN NUMBER DEFAULT NULL,
168 p_balance_type_id24 IN NUMBER DEFAULT NULL,
169 p_balance_type_id25 IN NUMBER DEFAULT NULL,
170 p_balance_type_id26 IN NUMBER DEFAULT NULL,
171 p_balance_type_id27 IN NUMBER DEFAULT NULL,
172 p_balance_type_id28 IN NUMBER DEFAULT NULL,
173 p_balance_type_id29 IN NUMBER DEFAULT NULL,
174 p_balance_type_id30 IN NUMBER DEFAULT NULL) RETURN pay_jp_result_run_t;
175 --
176 FUNCTION prepay(
177 p_assignment_action_id IN NUMBER,
178 p_input_value_id1 IN NUMBER DEFAULT NULL,
179 p_input_value_id2 IN NUMBER DEFAULT NULL,
180 p_input_value_id3 IN NUMBER DEFAULT NULL,
181 p_input_value_id4 IN NUMBER DEFAULT NULL,
182 p_input_value_id5 IN NUMBER DEFAULT NULL,
183 p_input_value_id6 IN NUMBER DEFAULT NULL,
184 p_input_value_id7 IN NUMBER DEFAULT NULL,
185 p_input_value_id8 IN NUMBER DEFAULT NULL,
186 p_input_value_id9 IN NUMBER DEFAULT NULL,
187 p_input_value_id10 IN NUMBER DEFAULT NULL,
188 p_input_value_id11 IN NUMBER DEFAULT NULL,
189 p_input_value_id12 IN NUMBER DEFAULT NULL,
190 p_input_value_id13 IN NUMBER DEFAULT NULL,
191 p_input_value_id14 IN NUMBER DEFAULT NULL,
192 p_input_value_id15 IN NUMBER DEFAULT NULL,
193 p_input_value_id16 IN NUMBER DEFAULT NULL,
194 p_input_value_id17 IN NUMBER DEFAULT NULL,
195 p_input_value_id18 IN NUMBER DEFAULT NULL,
196 p_input_value_id19 IN NUMBER DEFAULT NULL,
197 p_input_value_id20 IN NUMBER DEFAULT NULL,
198 p_input_value_id21 IN NUMBER DEFAULT NULL,
199 p_input_value_id22 IN NUMBER DEFAULT NULL,
200 p_input_value_id23 IN NUMBER DEFAULT NULL,
201 p_input_value_id24 IN NUMBER DEFAULT NULL,
202 p_input_value_id25 IN NUMBER DEFAULT NULL,
203 p_input_value_id26 IN NUMBER DEFAULT NULL,
204 p_input_value_id27 IN NUMBER DEFAULT NULL,
205 p_input_value_id28 IN NUMBER DEFAULT NULL,
206 p_input_value_id29 IN NUMBER DEFAULT NULL,
207 p_input_value_id30 IN NUMBER DEFAULT NULL,
208 p_input_value_id31 IN NUMBER DEFAULT NULL,
209 p_input_value_id32 IN NUMBER DEFAULT NULL,
210 p_input_value_id33 IN NUMBER DEFAULT NULL,
211 p_input_value_id34 IN NUMBER DEFAULT NULL,
212 p_input_value_id35 IN NUMBER DEFAULT NULL,
213 p_input_value_id36 IN NUMBER DEFAULT NULL,
214 p_input_value_id37 IN NUMBER DEFAULT NULL,
215 p_input_value_id38 IN NUMBER DEFAULT NULL,
216 p_input_value_id39 IN NUMBER DEFAULT NULL,
217 p_input_value_id40 IN NUMBER DEFAULT NULL,
218 p_input_value_id41 IN NUMBER DEFAULT NULL,
219 p_input_value_id42 IN NUMBER DEFAULT NULL,
220 p_input_value_id43 IN NUMBER DEFAULT NULL,
221 p_input_value_id44 IN NUMBER DEFAULT NULL,
222 p_input_value_id45 IN NUMBER DEFAULT NULL,
223 p_input_value_id46 IN NUMBER DEFAULT NULL,
224 p_input_value_id47 IN NUMBER DEFAULT NULL,
225 p_input_value_id48 IN NUMBER DEFAULT NULL,
226 p_input_value_id49 IN NUMBER DEFAULT NULL,
227 p_input_value_id50 IN NUMBER DEFAULT NULL,
228 p_input_value_id51 IN NUMBER DEFAULT NULL,
229 p_input_value_id52 IN NUMBER DEFAULT NULL,
230 p_input_value_id53 IN NUMBER DEFAULT NULL,
231 p_input_value_id54 IN NUMBER DEFAULT NULL,
232 p_input_value_id55 IN NUMBER DEFAULT NULL,
233 p_input_value_id56 IN NUMBER DEFAULT NULL,
234 p_input_value_id57 IN NUMBER DEFAULT NULL,
235 p_input_value_id58 IN NUMBER DEFAULT NULL,
236 p_input_value_id59 IN NUMBER DEFAULT NULL,
237 p_input_value_id60 IN NUMBER DEFAULT NULL,
238 p_input_value_id61 IN NUMBER DEFAULT NULL,
239 p_input_value_id62 IN NUMBER DEFAULT NULL,
240 p_input_value_id63 IN NUMBER DEFAULT NULL,
241 p_input_value_id64 IN NUMBER DEFAULT NULL,
242 p_input_value_id65 IN NUMBER DEFAULT NULL,
243 p_input_value_id66 IN NUMBER DEFAULT NULL,
244 p_input_value_id67 IN NUMBER DEFAULT NULL,
245 p_input_value_id68 IN NUMBER DEFAULT NULL,
246 p_input_value_id69 IN NUMBER DEFAULT NULL,
247 p_input_value_id70 IN NUMBER DEFAULT NULL,
248 p_input_value_id71 IN NUMBER DEFAULT NULL,
249 p_input_value_id72 IN NUMBER DEFAULT NULL,
250 p_input_value_id73 IN NUMBER DEFAULT NULL,
251 p_input_value_id74 IN NUMBER DEFAULT NULL,
252 p_input_value_id75 IN NUMBER DEFAULT NULL,
253 p_input_value_id76 IN NUMBER DEFAULT NULL,
254 p_input_value_id77 IN NUMBER DEFAULT NULL,
255 p_input_value_id78 IN NUMBER DEFAULT NULL,
256 p_input_value_id79 IN NUMBER DEFAULT NULL,
257 p_input_value_id80 IN NUMBER DEFAULT NULL,
258 p_input_value_id81 IN NUMBER DEFAULT NULL,
259 p_input_value_id82 IN NUMBER DEFAULT NULL,
260 p_input_value_id83 IN NUMBER DEFAULT NULL,
261 p_input_value_id84 IN NUMBER DEFAULT NULL,
262 p_input_value_id85 IN NUMBER DEFAULT NULL,
263 p_input_value_id86 IN NUMBER DEFAULT NULL,
264 p_input_value_id87 IN NUMBER DEFAULT NULL,
265 p_input_value_id88 IN NUMBER DEFAULT NULL,
266 p_input_value_id89 IN NUMBER DEFAULT NULL,
267 p_input_value_id90 IN NUMBER DEFAULT NULL,
268 p_input_value_id91 IN NUMBER DEFAULT NULL,
269 p_input_value_id92 IN NUMBER DEFAULT NULL,
270 p_input_value_id93 IN NUMBER DEFAULT NULL,
271 p_input_value_id94 IN NUMBER DEFAULT NULL,
272 p_input_value_id95 IN NUMBER DEFAULT NULL,
273 p_input_value_id96 IN NUMBER DEFAULT NULL,
274 p_input_value_id97 IN NUMBER DEFAULT NULL,
275 p_input_value_id98 IN NUMBER DEFAULT NULL,
276 p_input_value_id99 IN NUMBER DEFAULT NULL,
277 p_input_value_id100 IN NUMBER DEFAULT NULL,
278 p_balance_type_id1 IN NUMBER DEFAULT NULL,
279 p_balance_type_id2 IN NUMBER DEFAULT NULL,
280 p_balance_type_id3 IN NUMBER DEFAULT NULL,
281 p_balance_type_id4 IN NUMBER DEFAULT NULL,
282 p_balance_type_id5 IN NUMBER DEFAULT NULL,
283 p_balance_type_id6 IN NUMBER DEFAULT NULL,
284 p_balance_type_id7 IN NUMBER DEFAULT NULL,
285 p_balance_type_id8 IN NUMBER DEFAULT NULL,
286 p_balance_type_id9 IN NUMBER DEFAULT NULL,
287 p_balance_type_id10 IN NUMBER DEFAULT NULL,
288 p_balance_type_id11 IN NUMBER DEFAULT NULL,
289 p_balance_type_id12 IN NUMBER DEFAULT NULL,
290 p_balance_type_id13 IN NUMBER DEFAULT NULL,
291 p_balance_type_id14 IN NUMBER DEFAULT NULL,
292 p_balance_type_id15 IN NUMBER DEFAULT NULL,
293 p_balance_type_id16 IN NUMBER DEFAULT NULL,
294 p_balance_type_id17 IN NUMBER DEFAULT NULL,
295 p_balance_type_id18 IN NUMBER DEFAULT NULL,
296 p_balance_type_id19 IN NUMBER DEFAULT NULL,
297 p_balance_type_id20 IN NUMBER DEFAULT NULL,
298 p_balance_type_id21 IN NUMBER DEFAULT NULL,
299 p_balance_type_id22 IN NUMBER DEFAULT NULL,
300 p_balance_type_id23 IN NUMBER DEFAULT NULL,
301 p_balance_type_id24 IN NUMBER DEFAULT NULL,
302 p_balance_type_id25 IN NUMBER DEFAULT NULL,
303 p_balance_type_id26 IN NUMBER DEFAULT NULL,
304 p_balance_type_id27 IN NUMBER DEFAULT NULL,
305 p_balance_type_id28 IN NUMBER DEFAULT NULL,
306 p_balance_type_id29 IN NUMBER DEFAULT NULL,
307 p_balance_type_id30 IN NUMBER DEFAULT NULL) RETURN pay_jp_result_prepay_t;
308 ************************************************************************ */
309 --
310 END pay_jp_result_pkg;