1 package hr_aubal AUTHID CURRENT_USER as
2 -- $Header: pyaubal.pkh 120.0.12000000.1 2007/01/17 15:44:32 appldev noship $
3
4 -- Copyright (c) 1999 Oracle Corporation
5 -- All rights reserved
6
7 -- Package used to contain balance functions for Australia.
8
9 -- Date Author Bug/CR Num Notes
10 -- -----------+--------+----------+-----------------------------------------
11 -- 28-Aug-2003 Puchil 3010965 Removed functions balance and calc_balance
12 -- 18 Dec 2002 Apunekar Added DBDRV
13 -- 22 Feb 2000 JTurner Fixed up incorrect function specs
14 -- 24-Nov-1999 sgoggin AU Created
15 -- 13-Aug-1999 sclarke Created
16
17 ------------------------calc_all_balances----------------------------------
18 function calc_all_balances
19 (p_assignment_action_id in number
20 ,p_defined_balance_id in number
21 ) return number;
22
23 ------------------------calc_all_balances----------------------------------
24 function calc_all_balances
25 (p_effective_date in date
26 ,p_assignment_id in number
27 ,p_defined_balance_id in number
28 ) return number;
29
30 -------------------------calc_asg_mtd--------------------------------------
31 function calc_asg_mtd
32 (p_assignment_action_id in number
33 ,p_balance_type_id in number
34 ,p_effective_date in date default null
35 ,p_assignment_id in number
36 ) return number;
37
38 -------------------------calc_asg_mtd_action-------------------------------
39 function calc_asg_mtd_action
40 (p_assignment_action_id in number
41 ,p_balance_type_id in number
42 ,p_effective_date in date default null
43 )return number;
44
45 -------------------------calc_asg_mtd_date---------------------------------
46 function calc_asg_mtd_date
47 (p_assignment_id in number
48 ,p_balance_type_id in number
49 ,p_effective_date in date
50 )return number;
51
52 -------------------------calc_asg_qtd--------------------------------------
53 function calc_asg_qtd
54 (p_assignment_action_id in number
55 ,p_balance_type_id in number
56 ,p_effective_date in date default null
57 ,p_assignment_id in number
58 ) return number;
59
60 -------------------------calc_asg_qtd_action-------------------------------
61 function calc_asg_qtd_action
62 (p_assignment_action_id in number
63 ,p_balance_type_id in number
64 ,p_effective_date in date default null
65 )return number;
66
67 -------------------------calc_asg_qtd_date---------------------------------
68 function calc_asg_qtd_date
69 (p_assignment_id in number
70 ,p_balance_type_id in number
71 ,p_effective_date in date
72 )return number;
73
74 -------------------------calc_asg_ytd--------------------------------------
75 function calc_asg_ytd
76 (p_assignment_action_id in number
77 ,p_balance_type_id in number
78 ,p_effective_date in date default null
79 ,p_assignment_id in number
80 ) return number;
81
82 ----------------------calc_asg_ytd_action---------------------------------
83 function calc_asg_ytd_action
84 (p_assignment_action_id in number
85 ,p_balance_type_id in number
86 ,p_effective_date in date default null
87 ) return number;
88
89 -------------------------calc_asg_ytd_date-----------------------------------
90 function calc_asg_ytd_date
91 (p_assignment_id in number
92 ,p_balance_type_id in number
93 ,p_effective_date in date
94 ) return number;
95
96 -------------------------calc_asg_FBT_ytd--------------------------------------
97 function calc_asg_fbt_ytd
98 (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 ) return number;
103
104 -------------------------calc_asg_fbt_ytd_action---------------------------------
105 function calc_asg_fbt_ytd_action
106 (p_assignment_action_id in number
107 ,p_balance_type_id in number
108 ,p_effective_date in date default null
109 ) return number;
110
111 -------------------------calc_asg_fbt_ytd_date-----------------------------------
112 function calc_asg_fbt_ytd_date
113 (p_assignment_id in number
114 ,p_balance_type_id in number
115 ,p_effective_date in date
116 ) return number;
117
118 -------------------------calc_asg_fy_ytd--------------------------------------
119 function calc_asg_fy_ytd
120 (p_assignment_action_id in number
121 ,p_balance_type_id in number
122 ,p_effective_date in date default null
123 ,p_assignment_id in number
124 ) return number;
125
126 -------------------------calc_asg_fy_ytd_action-------------------------------
127 function calc_asg_fy_ytd_action
128 (p_assignment_action_id in number
129 ,p_balance_type_id in number
130 ,p_effective_date in date default null
131 )return number;
132
133 -------------------------calc_asg_fy_ytd_date---------------------------------
134 function calc_asg_fy_ytd_date
135 (p_assignment_id in number
136 ,p_balance_type_id in number
137 ,p_effective_date in date
138 )return number;
139
140 -------------------------calc_asg_cal_ytd--------------------------------------
141 function calc_asg_cal_ytd
142 (p_assignment_action_id in number
143 ,p_balance_type_id in number
144 ,p_effective_date in date default null
145 ,p_assignment_id in number
146 ) return number;
147
148 -------------------------calc_asg_cal_ytd_action-------------------------------
149 function calc_asg_cal_ytd_action
150 (p_assignment_action_id in number
151 ,p_balance_type_id in number
152 ,p_effective_date in date default null
153 )return number;
154
155 -------------------------calc_asg_cal_ytd_date---------------------------------
156 function calc_asg_cal_ytd_date
157 (p_assignment_id in number
158 ,p_balance_type_id in number
159 ,p_effective_date in date
160 )return number;
161
162 -------------------------calc_asg_fy_qtd---------------------------------------
163 function calc_asg_fy_qtd
164 (p_assignment_action_id in number
165 ,p_balance_type_id in number
166 ,p_effective_date in date default null
167 ,p_assignment_id in number
168 )return number;
169
170 -------------------------calc_asg_fy_qtd_action--------------------------------
171 function calc_asg_fy_qtd_action
172 (p_assignment_action_id in number
173 ,p_balance_type_id in number
174 ,p_effective_date in date default null
175 )return number;
176
177 -------------------------calc_asg_fy_qtd_date----------------------------------
178 function calc_asg_fy_qtd_date
179 (p_assignment_id in number
180 ,p_balance_type_id in number
181 ,p_effective_date in date
182 ) return number;
183
184 -------------------------calc_asg_ptd_action----------------------------------
185 function calc_asg_ptd_action
186 (p_assignment_action_id in number
187 ,p_balance_type_id in number
188 ,p_effective_date in date default null
189 )return number;
190
191 -------------------------calc_asg_ptd------------------------------------------
192 function calc_asg_ptd
193 (p_assignment_action_id in number
194 ,p_balance_type_id in number
195 ,p_effective_date in date default null
196 ,p_assignment_id in number
197 ) return number;
198
199 -------------------------calc_asg_ptd_date-------------------------------------
200 function calc_asg_ptd_date
201 (p_assignment_id in number
202 ,p_balance_type_id in number
203 ,p_effective_date in date
204 ) return number;
205
206 -------------------------calc_asg_td_action-----------------------------
207 function calc_asg_td_action
208 (p_assignment_action_id in number
209 ,p_balance_type_id in number
210 ,p_effective_date in date default null
211 ) return number;
212
213 -------------------------calc_asg_td------------------------------------
214 function calc_asg_td
215 (p_assignment_action_id in number
216 ,p_balance_type_id in number
217 ,p_effective_date in date default null
218 ,p_assignment_id in number
219 ) return number;
220
221 -------------------------calc_asg_td_date-------------------------------
222 function calc_asg_td_date
223 (p_assignment_id in number
224 ,p_balance_type_id in number
225 ,p_effective_date in date
226 ) return number;
227
228 -------------------------calc_asg_run_action----------------------------
229 function calc_asg_run_action
230 (p_assignment_action_id in number
231 ,p_balance_type_id in number
232 ,p_effective_date in date default null
233 ) return number;
234
235 -------------------------calc_asg_run-----------------------------------
236 function calc_asg_run
237 (p_assignment_action_id in number
238 ,p_balance_type_id in number
239 ,p_effective_date in date default null
240 ,p_assignment_id in number
241 ) return number;
242
243 -------------------------calc_asg_run_date------------------------------
244 function calc_asg_run_date
245 (p_assignment_id in number
246 ,p_balance_type_id in number
247 ,p_effective_date in date
248 ) return number;
249
250 -------------------------calc_payment_action----------------------------
251 function calc_payment_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
257 -------------------------calc_payment-----------------------------------
258 function calc_payment
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
265 -------------------------calc_payment_date------------------------------
266 function calc_payment_date
267 (p_assignment_id in number
268 ,p_balance_type_id in number
269 ,p_effective_date in date
270 ) return number;
271 --
272 end hr_aubal;