[Home] [Help]
PACKAGE: APPS.PY_ZA_BAL
Source
1 PACKAGE py_za_bal AS
2 /* $Header: pyzabal1.pkh 120.0 2005/05/29 10:21:01 appldev noship $ */
3 -----------------------------------------------------------------------
4 -----------------------------------------------------------------------
5 FUNCTION span_start(
6 p_input_date DATE,
7 p_frequency NUMBER DEFAULT 1,
8 p_start_dd_mm VARCHAR2 DEFAULT '06-04-')
9 RETURN date ;
10 PRAGMA RESTRICT_REFERENCES (span_start, WNDS, WNPS);
11 -----------------------------------------------------------------------
12 -----------------------------------------------------------------------
13 -- what is the latest reset date for a particular dimension
14 FUNCTION dimension_reset_date(
15 p_dimension_name IN VARCHAR2,
16 p_user_date IN DATE,
17 p_business_group_id IN NUMBER)
18 RETURN date;
19 PRAGMA RESTRICT_REFERENCES (dimension_reset_date, WNDS, WNPS);
20 -----------------------------------------------------------------------
21 -----------------------------------------------------------------------
22 FUNCTION start_director(
23 p_assignment_id NUMBER,
24 p_start_date DATE ,
25 p_end_date DATE )
26 RETURN DATE;
27 PRAGMA RESTRICT_REFERENCES (start_director, WNDS, WNPS);
28 -----------------------------------------------------------------------
29 -----------------------------------------------------------------------
30 FUNCTION balance (
31 p_assignment_action_id IN NUMBER,
32 p_defined_balance_id IN NUMBER)
33 RETURN number ;
34 PRAGMA RESTRICT_REFERENCES (balance, WNDS, WNPS);
35 -----------------------------------------------------------------------
36 -----------------------------------------------------------------------
37 FUNCTION calc_all_balances(
38 p_assignment_action_id IN NUMBER,
39 p_defined_balance_id IN NUMBER)
40 RETURN NUMBER;
41 PRAGMA RESTRICT_REFERENCES (calc_all_balances, WNDS, WNPS);
42 -----------------------------------------------------------------------
43 FUNCTION calc_all_balances(
44 p_effective_date IN DATE,
45 p_assignment_id IN NUMBER,
46 p_defined_balance_id IN NUMBER)
47 RETURN NUMBER;
48 PRAGMA RESTRICT_REFERENCES (calc_all_balances, WNDS, WNPS);
49 -----------------------------------------------------------------------
50 -----------------------------------------------------------------------
51 FUNCTION calc_asg_itd_action(
52 p_assignment_action_id IN NUMBER,
53 p_balance_type_id IN NUMBER,
54 p_effective_date IN DATE DEFAULT NULL)
55 RETURN NUMBER;
56 PRAGMA RESTRICT_REFERENCES (calc_asg_itd_action, WNDS, WNPS);
57 -----------------------------------------------------------------------
58 FUNCTION calc_asg_itd(
59 p_assignment_action_id IN NUMBER,
60 p_balance_type_id IN NUMBER,
61 p_effective_date IN DATE DEFAULT NULL,
62 p_assignment_id IN NUMBER)
63 RETURN NUMBER;
64 PRAGMA RESTRICT_REFERENCES (calc_asg_itd, WNDS, WNPS);
65 -----------------------------------------------------------------------
66 --date mode function
67 FUNCTION calc_asg_itd_date(
68 p_assignment_id IN NUMBER,
69 p_balance_type_id IN NUMBER,
70 p_effective_date IN DATE)
71 RETURN NUMBER;
72 PRAGMA RESTRICT_REFERENCES (calc_asg_itd_date, WNDS, WNPS);
73 -----------------------------------------------------------------------
74 -----------------------------------------------------------------------
75 FUNCTION calc_asg_run_action(
76 p_assignment_action_id IN NUMBER,
77 p_balance_type_id IN NUMBER,
78 p_effective_date IN DATE DEFAULT NULL)
79 RETURN NUMBER;
80 PRAGMA RESTRICT_REFERENCES (calc_asg_run_action, WNDS, WNPS);
81 -----------------------------------------------------------------------
82 FUNCTION calc_asg_run(
83 p_assignment_action_id IN NUMBER,
84 p_balance_type_id IN NUMBER,
85 p_effective_date IN DATE DEFAULT NULL,
86 p_assignment_id IN NUMBER)
87 RETURN NUMBER;
88 PRAGMA RESTRICT_REFERENCES (calc_asg_run, WNDS, WNPS);
89 -----------------------------------------------------------------------
90 --date mode function
91 FUNCTION calc_asg_run_date(
92 p_assignment_id IN NUMBER,
93 p_balance_type_id IN NUMBER,
94 p_effective_date IN DATE)
95 RETURN NUMBER;
96 PRAGMA RESTRICT_REFERENCES (calc_asg_run_date, WNDS, WNPS);
97 -----------------------------------------------------------------------
98 -----------------------------------------------------------------------
99 FUNCTION calc_payments_action(
100 p_assignment_action_id IN NUMBER,
101 p_balance_type_id IN NUMBER,
102 p_effective_date IN DATE DEFAULT NULL)
103 RETURN NUMBER;
104 PRAGMA RESTRICT_REFERENCES (calc_payments_action, WNDS, WNPS);
105 -----------------------------------------------------------------------
106 FUNCTION calc_payments(
107 p_assignment_action_id IN NUMBER,
108 p_balance_type_id IN NUMBER,
109 p_effective_date IN DATE DEFAULT NULL,
110 p_assignment_id IN NUMBER)
111 RETURN NUMBER;
112 PRAGMA RESTRICT_REFERENCES (calc_payments, WNDS, WNPS);
113 -----------------------------------------------------------------------
114 --date mode function
115 FUNCTION calc_payments_date(
116 p_assignment_id IN NUMBER,
117 p_balance_type_id IN NUMBER,
118 p_effective_date IN DATE)
119 RETURN NUMBER;
120 PRAGMA RESTRICT_REFERENCES (calc_payments_date, WNDS, WNPS);
121 -----------------------------------------------------------------------
122 -----------------------------------------------------------------------
123
124
125
126
127 -----------------------------------------------------------------------
128 -----------------------------------------------------------------------
129 FUNCTION calc_ASG_TAX_PTD_action(
130 p_assignment_action_id IN NUMBER,
131 p_balance_type_id IN NUMBER,
132 p_effective_date IN DATE DEFAULT NULL)
133 RETURN NUMBER;
134 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_PTD_action, WNDS, WNPS);
135 -----------------------------------------------------------------------
136 FUNCTION calc_ASG_TAX_PTD(
137 p_assignment_action_id IN NUMBER,
138 p_balance_type_id IN NUMBER,
139 p_effective_date IN DATE DEFAULT NULL,
140 p_assignment_id IN NUMBER)
141 RETURN NUMBER;
142 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_PTD, WNDS, WNPS);
143 -----------------------------------------------------------------------
144 --date mode function
145 FUNCTION calc_ASG_TAX_PTD_date(
146 p_assignment_id IN NUMBER,
147 p_balance_type_id IN NUMBER,
148 p_effective_date IN DATE)
149 RETURN NUMBER;
150 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_PTD_date, WNDS, WNPS);
151 -----------------------------------------------------------------------
152 -----------------------------------------------------------------------
153 FUNCTION calc_ASG_TAX_YTD_action(
154 p_assignment_action_id IN NUMBER,
155 p_balance_type_id IN NUMBER,
156 p_effective_date IN DATE DEFAULT NULL)
157 RETURN NUMBER;
158 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_YTD_action, WNDS, WNPS);
159 -----------------------------------------------------------------------
160 FUNCTION calc_ASG_TAX_YTD(
161 p_assignment_action_id IN NUMBER,
162 p_balance_type_id IN NUMBER,
163 p_effective_date IN DATE DEFAULT NULL,
164 p_assignment_id IN NUMBER)
165 RETURN NUMBER;
166 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_YTD, WNDS, WNPS);
167 -----------------------------------------------------------------------
168 --date mode function
169 FUNCTION calc_ASG_TAX_YTD_date(
170 p_assignment_id IN NUMBER,
171 p_balance_type_id IN NUMBER,
172 p_effective_date IN DATE)
173 RETURN NUMBER;
174 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_YTD_date, WNDS, WNPS);
175 -----------------------------------------------------------------------
176 -----------------------------------------------------------------------
177 FUNCTION calc_ASG_TAX_MTD_action(
178 p_assignment_action_id IN NUMBER,
179 p_balance_type_id IN NUMBER,
180 p_effective_date IN DATE DEFAULT NULL)
181 RETURN NUMBER;
182 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_MTD_action, WNDS, WNPS);
183 -----------------------------------------------------------------------
184 FUNCTION calc_ASG_TAX_MTD(
185 p_assignment_action_id IN NUMBER,
186 p_balance_type_id IN NUMBER,
187 p_effective_date IN DATE DEFAULT NULL,
188 p_assignment_id IN NUMBER)
189 RETURN NUMBER;
190 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_MTD, WNDS, WNPS);
191 -----------------------------------------------------------------------
192 --date mode function
193 FUNCTION calc_ASG_TAX_MTD_date(
194 p_assignment_id IN NUMBER,
195 p_balance_type_id IN NUMBER,
196 p_effective_date IN DATE)
197 RETURN NUMBER;
198 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_MTD_date, WNDS, WNPS);
199 -----------------------------------------------------------------------
200 -----------------------------------------------------------------------
201 FUNCTION calc_ASG_TAX_QTD_action(
202 p_assignment_action_id IN NUMBER,
203 p_balance_type_id IN NUMBER,
204 p_effective_date IN DATE DEFAULT NULL)
205 RETURN NUMBER;
206 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_QTD_action, WNDS, WNPS);
207 -----------------------------------------------------------------------
208 FUNCTION calc_ASG_TAX_QTD(
209 p_assignment_action_id IN NUMBER,
210 p_balance_type_id IN NUMBER,
211 p_effective_date IN DATE DEFAULT NULL,
212 p_assignment_id IN NUMBER)
213 RETURN NUMBER;
214 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_QTD, WNDS, WNPS);
215 -----------------------------------------------------------------------
216 --date mode function
217 FUNCTION calc_ASG_TAX_QTD_date(
218 p_assignment_id IN NUMBER,
219 p_balance_type_id IN NUMBER,
220 p_effective_date IN DATE)
221 RETURN NUMBER;
222 PRAGMA RESTRICT_REFERENCES (calc_ASG_TAX_QTD_date, WNDS, WNPS);
223 -----------------------------------------------------------------------
224 -----------------------------------------------------------------------
225 -----------------------------------------------------------------------
226 -----------------------------------------------------------------------
227 FUNCTION calc_ASG_CAL_PTD_action(
228 p_assignment_action_id IN NUMBER,
229 p_balance_type_id IN NUMBER,
230 p_effective_date IN DATE DEFAULT NULL)
231 RETURN NUMBER;
232 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_PTD_action, WNDS, WNPS);
233 -----------------------------------------------------------------------
234 FUNCTION calc_ASG_CAL_PTD(
235 p_assignment_action_id IN NUMBER,
236 p_balance_type_id IN NUMBER,
237 p_effective_date IN DATE DEFAULT NULL,
238 p_assignment_id IN NUMBER)
239 RETURN NUMBER;
240 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_PTD, WNDS, WNPS);
241 -----------------------------------------------------------------------
242 --date mode function
243 FUNCTION calc_ASG_CAL_PTD_date(
244 p_assignment_id IN NUMBER,
245 p_balance_type_id IN NUMBER,
246 p_effective_date IN DATE)
247 RETURN NUMBER;
248 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_PTD_date, WNDS, WNPS);
249 -----------------------------------------------------------------------
250 -----------------------------------------------------------------------
251 FUNCTION calc_ASG_CAL_YTD_action(
252 p_assignment_action_id IN NUMBER,
253 p_balance_type_id IN NUMBER,
254 p_effective_date IN DATE DEFAULT NULL)
255 RETURN NUMBER;
256 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_YTD_action, WNDS, WNPS);
257 -----------------------------------------------------------------------
258 FUNCTION calc_ASG_CAL_YTD(
259 p_assignment_action_id IN NUMBER,
260 p_balance_type_id IN NUMBER,
261 p_effective_date IN DATE DEFAULT NULL,
262 p_assignment_id IN NUMBER)
263 RETURN NUMBER;
264 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_YTD, WNDS, WNPS);
265 -----------------------------------------------------------------------
266 --date mode function
267 FUNCTION calc_ASG_CAL_YTD_date(
268 p_assignment_id IN NUMBER,
269 p_balance_type_id IN NUMBER,
270 p_effective_date IN DATE)
271 RETURN NUMBER;
272 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_YTD_date, WNDS, WNPS);
273 -----------------------------------------------------------------------
274 -----------------------------------------------------------------------
275 FUNCTION calc_ASG_CAL_MTD_action(
276 p_assignment_action_id IN NUMBER,
277 p_balance_type_id IN NUMBER,
278 p_effective_date IN DATE DEFAULT NULL)
279 RETURN NUMBER;
280 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_MTD_action, WNDS, WNPS);
281 -----------------------------------------------------------------------
282 FUNCTION calc_ASG_CAL_MTD(
283 p_assignment_action_id IN NUMBER,
284 p_balance_type_id IN NUMBER,
285 p_effective_date IN DATE DEFAULT NULL,
286 p_assignment_id IN NUMBER)
287 RETURN NUMBER;
288 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_MTD, WNDS, WNPS);
289 -----------------------------------------------------------------------
290 --date mode function
291 FUNCTION calc_ASG_CAL_MTD_date(
292 p_assignment_id IN NUMBER,
293 p_balance_type_id IN NUMBER,
294 p_effective_date IN DATE)
295 RETURN NUMBER;
296 PRAGMA RESTRICT_REFERENCES (calc_ASG_CAL_MTD_date, WNDS, WNPS);
297 -----------------------------------------------------------------------
298 -----------------------------------------------------------------------
299
300
301
302
303
304
305
306
307 -----------------------------------------------------------------------
308 -----------------------------------------------------------------------
309 FUNCTION calc_balance(
310 p_assignment_id IN NUMBER,
311 p_balance_type_id IN NUMBER, -- balance
312 p_period_from_date IN DATE, -- since regular pay date of period
313 p_event_from_date IN DATE, -- since effective date of
314 p_to_date IN DATE, -- sum up to this date
315 p_action_sequence IN NUMBER) -- sum up to this sequence
316 RETURN NUMBER;
317 PRAGMA RESTRICT_REFERENCES (calc_balance, WNDS, WNPS);
318 -----------------------------------------------------------------------
319 -----------------------------------------------------------------------
320 PROCEDURE create_dimension(
321 errbuf OUT NOCOPY VARCHAR2,
322 retcode OUT NOCOPY NUMBER,
323 p_business_group_id IN NUMBER,
324 p_suffix IN VARCHAR2,
325 p_level IN VARCHAR2,
326 p_start_dd_mm IN VARCHAR2,
327 p_frequency IN NUMBER,
328 p_global_name IN VARCHAR2 DEFAULT NULL);
329 -----------------------------------------------------------------------
330 -----------------------------------------------------------------------
331 PROCEDURE check_expiry(
332 p_owner_payroll_action_id IN NUMBER,
333 p_user_payroll_action_id IN NUMBER,
334 p_owner_assignment_action_id IN NUMBER,
335 p_user_assignment_action_id IN NUMBER,
336 p_owner_effective_date IN DATE,
337 p_user_effective_date IN DATE,
338 p_dimension_name IN VARCHAR2,
339 p_expiry_information OUT NOCOPY NUMBER);
340 -----------------------------------------------------------------------
341 -----------------------------------------------------------------------
342
343 --3491357
344 -----------------------------------------------------------------------
345 -----------------------------------------------------------------------
346 FUNCTION get_balance_value(
347 p_assignment_id IN NUMBER,
348 p_balance_type_id IN NUMBER,
349 p_dimension IN VARCHAR2,
350 p_effective_date IN DATE)
351 RETURN NUMBER;
352 -----------------------------------------------------------------------
353 FUNCTION get_balance_value_action(
354 p_assignment_action_id IN NUMBER,
355 p_balance_type_id IN NUMBER,
356 p_dimension IN VARCHAR2)
357 RETURN NUMBER;
358 -----------------------------------------------------------------------
359 -----------------------------------------------------------------------
360 --Bug 4365925
361 FUNCTION get_balance_value(
362 p_defined_balance_id IN NUMBER,
363 p_assignment_id IN NUMBER,
364 p_effective_date IN DATE)
365 RETURN NUMBER;
366 -----------------------------------------------------------------------
367
368 END py_za_bal;
369