1 package hr_nzbal as
2 /* $Header: pynzbal.pkh 120.0 2005/05/29 02:11:12 appldev noship $ */
3 --
4 -- Change List
5 -- ----------
6 -- DATE Name Vers Bug No Description
7 -- -----------+---------------+--------+--------+--------------------+
8 -- 18-Aug-2004 sshankar 115.6 3181581 Added function balance as
9 -- it is being used by view
10 -- pay_nz_balances_v
11 -- 13 Aug 2004 sshankar 115.5 3181581 Removed functions:
12 -- balance and calc_balance
13 -- 13 Feb 2002 vgsriniv 115.4 2203667 Added checkfile in dbdrv
14 -- 12 Nov 2001 vgsriniv 115.1 2097319 dbdrv command added
15 -- 11 Jan 2000 J Turner Commented out pragmas
16 -- 13-Aug-1999 sclarke 1.0 Created
17 -- -----------+---------------+--------+--------+--------------------+
18 --
19 ------------------------calc_all_balances----------------------------------
20 --
21 function calc_all_balances ( p_assignment_action_id in number
22 , p_defined_balance_id in number
23 )
24 return number;
25 -- pragma restrict_references (calc_all_balances, wnds, wnps);
26 --
27 ------------------------calc_all_balances----------------------------------
28 --
29 function calc_all_balances ( p_effective_date in date
30 , p_assignment_id in number
31 , p_defined_balance_id in number
32 )
33 return number;
34 -- pragma restrict_references (calc_all_balances, wnds, wnps);
35 --
36 -------------------------calc_asg_ytd--------------------------------------
37 --
38 function calc_asg_ytd ( p_assignment_action_id in number
39 , p_balance_type_id in number
40 , p_effective_date in date default null
41 , p_assignment_id in number
42 )
43 return number;
44 -- pragma restrict_references (calc_asg_ytd, wnds, wnps);
45 --
46 -------------------------calc_asg_ytd_action---------------------------------
47 --
48 function calc_asg_ytd_action( p_assignment_action_id in number
49 , p_balance_type_id in number
50 , p_effective_date in date default null
51 )
52 return number;
53 -- pragma restrict_references (calc_asg_ytd_action, wnds, wnps);
54 --
55 -------------------------calc_asg_ytd_date-----------------------------------
56 --
57 -- date mode function
58 --
59 function calc_asg_ytd_date ( p_assignment_id in number
60 , p_balance_type_id in number
61 , p_effective_date in date
62 )
63 return number;
64 -- pragma restrict_references (calc_asg_ytd_date, wnds, wnps);
65 --
66 -------------------------calc_asg_hol_ytd--------------------------------------
67 --
68 function calc_asg_hol_ytd ( p_assignment_action_id in number
69 , p_balance_type_id in number
70 , p_effective_date in date default null
71 , p_assignment_id in number
72 )
73 return number;
74 -- pragma restrict_references (calc_asg_hol_ytd, wnds, wnps);
75 --
76 -------------------------calc_asg_hol_ytd_action---------------------------------
77 --
78 function calc_asg_hol_ytd_action( p_assignment_action_id in number
79 , p_balance_type_id in number
80 , p_effective_date in date default null
81 )
82 return number;
83 -- pragma restrict_references (calc_asg_hol_ytd_action, wnds, wnps);
84 --
85 -------------------------calc_asg_hol_ytd_date-----------------------------------
86 --
87 -- date mode function
88 --
89 function calc_asg_hol_ytd_date ( p_assignment_id in number
90 , p_balance_type_id in number
91 , p_effective_date in date
92 )
93 return number;
94 -- pragma restrict_references (calc_asg_hol_ytd_date, wnds, wnps);
95 --
96 -------------------------calc_asg_fy_ytd--------------------------------------
97 --
98 function calc_asg_fy_ytd( p_assignment_action_id in number
99 , p_balance_type_id in number
100 , p_effective_date in date default null
101 , p_assignment_id in number
102 )
103 return number;
104 -- pragma restrict_references (calc_asg_fy_ytd, wnds, wnps);
105 --
106 -------------------------calc_asg_fy_ytd_action-------------------------------
107 --
108 function calc_asg_fy_ytd_action ( p_assignment_action_id in number
109 , p_balance_type_id in number
110 , p_effective_date in date default null
111 )
112 return number;
113 -- pragma restrict_references (calc_asg_fy_ytd_action, wnds, wnps);
114 --
115 -------------------------calc_asg_fy_ytd_date---------------------------------
116 --
117 -- date mode function
118 --
119 function calc_asg_fy_ytd_date ( p_assignment_id in number
120 , p_balance_type_id in number
121 , p_effective_date in date
122 )
123 return number;
124 -- pragma restrict_references (calc_asg_fy_ytd_date, wnds, wnps);
125 --
126 -------------------------calc_asg_fy_qtd---------------------------------------
127 --
128 function calc_asg_fy_qtd( p_assignment_action_id in number
129 , p_balance_type_id in number
130 , p_effective_date in date default null
131 , p_assignment_id in number
132 )
133 return number;
134 -- pragma restrict_references (calc_asg_fy_qtd, wnds, wnps);
135 --
136 -------------------------calc_asg_fy_qtd_action--------------------------------
137 --
138 function calc_asg_fy_qtd_action ( p_assignment_action_id in number
139 , p_balance_type_id in number
140 , p_effective_date in date default null
141 )
142 return number;
143 -- pragma restrict_references (calc_asg_fy_qtd_action, wnds, wnps);
144 --
145 -------------------------calc_asg_fy_qtd_date----------------------------------
146 --
147 -- date mode function
148 --
149 function calc_asg_fy_qtd_date ( p_assignment_id in number
150 , p_balance_type_id in number
151 , p_effective_date in date
152 )
153 return number;
154 -- pragma restrict_references (calc_asg_fy_qtd_date, wnds, wnps);
155 --
156 -------------------------calc_asg_4week----------------------------------------
157 --
158 function calc_asg_4week ( p_assignment_action_id in number
159 , p_balance_type_id in number
160 , p_effective_date in date default null
161 , p_assignment_id in number
162 )
163 return number;
164 -- pragma restrict_references (calc_asg_4week, wnds, wnps);
165 --
166 -------------------------calc_asg_4week_action---------------------------------
167 --
168 function calc_asg_4week_action ( p_assignment_action_id in number
169 , p_balance_type_id in number
170 , p_effective_date in date default null
171 )
172 return number;
173 -- pragma restrict_references (calc_asg_4week_action, wnds, wnps);
174 --
175 -------------------------calc_asg_4weel_date----------------------------------
176 --
177 -- date mode function
178 --
179 function calc_asg_4week_date( p_assignment_id in number
180 , p_balance_type_id in number
181 , p_effective_date in date
182 )
183 return number;
184 -- pragma restrict_references (calc_asg_4week_date, wnds, wnps);
185 --
186 -------------------------calc_asg_ptd_action----------------------------------
187 --
188 function calc_asg_ptd_action( p_assignment_action_id in number
189 , p_balance_type_id in number
190 , p_effective_date in date default null
191 )
192 return number;
193 -- pragma restrict_references (calc_asg_ptd_action, wnds, wnps);
194 --
195 -------------------------calc_asg_ptd------------------------------------------
196 --
197 function calc_asg_ptd ( p_assignment_action_id in number
198 , p_balance_type_id in number
199 , p_effective_date in date default null
200 , p_assignment_id in number
201 )
202 return number;
203 -- pragma restrict_references (calc_asg_ptd, wnds, wnps);
204 --
205 -------------------------calc_asg_ptd_date-------------------------------------
206 --
207 -- date mode function
208 --
209 function calc_asg_ptd_date ( p_assignment_id in number
210 , p_balance_type_id in number
211 , p_effective_date in date
212 )
213 return number;
214 -- pragma restrict_references (calc_asg_ptd_date, wnds, wnps);
215 --
216 -------------------------calc_asg_td_action-----------------------------
217 --
218 function calc_asg_td_action ( p_assignment_action_id in number
219 , p_balance_type_id in number
220 , p_effective_date in date default null
221 )
222 return number;
223 -- pragma restrict_references (calc_asg_td_action, wnds, wnps);
224 --
225 -------------------------calc_asg_td------------------------------------
226 --
227 function calc_asg_td( p_assignment_action_id in number
228 , p_balance_type_id in number
229 , p_effective_date in date default null
230 , p_assignment_id in number
231 )
232 return number;
233 -- pragma restrict_references (calc_asg_td, wnds, wnps);
234 --
235 -------------------------calc_asg_td_date-------------------------------
236 --
237 -- date mode function
238 --
239 function calc_asg_td_date ( p_assignment_id in number
240 , p_balance_type_id in number
241 , p_effective_date in date
242 )
243 return number;
244 -- pragma restrict_references (calc_asg_td_date, wnds, wnps);
245 --
246 -------------------------calc_asg_run_action----------------------------
247 --
248 function calc_asg_run_action( p_assignment_action_id in number
249 , p_balance_type_id in number
250 , p_effective_date in date default null
251 )
252 return number;
253 -- pragma restrict_references (calc_asg_run_action, wnds, wnps);
254 --
255 -------------------------calc_asg_run-----------------------------------
256 --
257 function calc_asg_run ( p_assignment_action_id in number
258 , p_balance_type_id in number
259 , p_effective_date in date default null
260 , p_assignment_id in number
261 )
262 return number;
263 -- pragma restrict_references (calc_asg_run, wnds, wnps);
264 --
265 -------------------------calc_asg_run_date------------------------------
266 --
267 -- date mode function
268 --
269 function calc_asg_run_date ( p_assignment_id in number
270 , p_balance_type_id in number
271 , p_effective_date in date
272 )
273 return number;
274 -- pragma restrict_references (calc_asg_run_date, wnds, wnps);
275 --
276 -------------------------calc_payment_action----------------------------
277 --
278 function calc_payment_action( p_assignment_action_id in number
279 , p_balance_type_id in number
280 , p_effective_date in date default null
281 )
282 return number;
283 -- pragma restrict_references (calc_payment_action, wnds, wnps);
284 --
285 -------------------------calc_payment-----------------------------------
286 --
287 function calc_payment ( p_assignment_action_id in number
288 , p_balance_type_id in number
289 , p_effective_date in date default null
290 , p_assignment_id in number
291 )
292 return number;
293 -- pragma restrict_references (calc_payment, wnds, wnps);
294 --
295 -------------------------calc_payment_date------------------------------
296 --
297 -- date mode function
298 --
299 function calc_payment_date ( p_assignment_id in number
300 , p_balance_type_id in number
301 , p_effective_date in date
302 )
303 return number;
304 -- pragma restrict_references (calc_payment_date, wnds, wnps);
305 --
306
307 ----------------------------balance-----------------------------------------
308 --
309 function balance( p_assignment_action_id in number
310 , p_defined_balance_id in number
311 )
312 return number;
313
314 --
315 end hr_nzbal;