[Home] [Help]
PACKAGE: APPS.HR_JPBAL
Source
1 PACKAGE hr_jpbal AS
2 /* $Header: pyjpbal.pkh 120.0.12000000.2 2007/02/21 04:02:28 keyazawa noship $ */
3 /* ------------------------------------------------------------------------------------ */
4 PROCEDURE check_expiry(
5 p_owner_payroll_action_id IN NUMBER,
6 p_user_payroll_action_id IN NUMBER,
7 p_owner_assignment_action_id IN NUMBER,
8 p_user_assignment_action_id IN NUMBER,
9 p_owner_effective_date IN DATE,
10 p_user_effective_date IN DATE,
11 p_dimension_name IN VARCHAR2,
12 p_expiry_information OUT NOCOPY NUMBER);
13 /* ------------------------------------------------------------------------------------ */
14 PROCEDURE check_expiry(
15 p_owner_payroll_action_id IN NUMBER,
16 p_user_payroll_action_id IN NUMBER,
17 p_owner_assignment_action_id IN NUMBER,
18 p_user_assignment_action_id IN NUMBER,
19 p_owner_effective_date IN DATE,
20 p_user_effective_date IN DATE,
21 p_dimension_name IN VARCHAR2,
22 p_expiry_information OUT NOCOPY DATE);
23 /* ------------------------------------------------------------------------------------ */
24 FUNCTION balance(
25 p_assignment_action_id IN NUMBER,
26 p_defined_balance_id IN NUMBER)
27 RETURN NUMBER;
28 /* ------------------------------------------------------------------------------------ */
29 FUNCTION balance(
30 p_assignment_action_id IN NUMBER,
31 p_item_name IN VARCHAR2)
32 RETURN NUMBER;
33 /* ------------------------------------------------------------------------------------ */
34 PROCEDURE create_dimension(
35 errbuf OUT NOCOPY VARCHAR2,
36 retcode OUT NOCOPY NUMBER,
37 p_business_group_id IN NUMBER,
38 p_suffix IN VARCHAR2,
39 p_level IN VARCHAR2,
40 p_dim_date_type IN VARCHAR2,
41 p_start_dd_mm IN VARCHAR2,
42 p_frequency IN NUMBER);
43 /* ------------------------------------------------------------------------------------ */
44 FUNCTION calc_balance_date(
45 p_assignment_id IN NUMBER,
46 p_balance_type_id IN NUMBER,
47 p_effective_date IN DATE,
48 p_dimension_name IN VARCHAR2)
49 RETURN NUMBER;
50 /* ------------------------------------------------------------------------------------ */
51 FUNCTION calc_asg_run_action(
52 p_assignment_action_id IN NUMBER,
53 p_balance_type_id IN NUMBER)
54 RETURN NUMBER;
55 /* ------------------------------------------------------------------------------------ */
56 FUNCTION calc_asg_run_date(
57 p_assignment_id IN NUMBER,
58 p_balance_type_id IN NUMBER,
59 p_effective_date IN DATE)
60 RETURN NUMBER;
61 /* ------------------------------------------------------------------------------------ */
62 FUNCTION calc_asg_run(
63 p_assignment_action_id IN NUMBER,
64 p_balance_type_id IN NUMBER,
65 p_assignment_id IN NUMBER)
66 RETURN NUMBER;
67 /* ------------------------------------------------------------------------------------ */
68 FUNCTION calc_asg_proc_ptd_action(
69 p_assignment_action_id IN NUMBER,
70 p_balance_type_id IN NUMBER)
71 RETURN NUMBER;
72 /* ------------------------------------------------------------------------------------ */
73 FUNCTION calc_asg_proc_ptd_date(
74 p_assignment_id IN NUMBER,
75 p_balance_type_id IN NUMBER,
76 p_effective_date IN DATE)
77 RETURN NUMBER;
78 /* ------------------------------------------------------------------------------------ */
79 FUNCTION calc_asg_proc_ptd(
80 p_assignment_action_id IN NUMBER,
81 p_balance_type_id IN NUMBER,
82 p_assignment_id IN NUMBER)
83 RETURN NUMBER;
84 /* ------------------------------------------------------------------------------------ */
85 FUNCTION calc_asg_mtd_jp_action(
86 p_assignment_action_id IN NUMBER,
87 p_balance_type_id IN NUMBER)
88 RETURN NUMBER;
89 /* ------------------------------------------------------------------------------------ */
90 FUNCTION calc_asg_mtd_jp_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 FUNCTION calc_asg_mtd_jp(
97 p_assignment_action_id IN NUMBER,
98 p_balance_type_id IN NUMBER,
99 p_assignment_id IN NUMBER)
100 RETURN NUMBER;
101 /* ------------------------------------------------------------------------------------ */
102 FUNCTION calc_asg_ytd_jp_action(
103 p_assignment_action_id IN NUMBER,
104 p_balance_type_id IN NUMBER)
105 RETURN NUMBER;
106 /* ------------------------------------------------------------------------------------ */
107 FUNCTION calc_asg_ytd_jp_date(
108 p_assignment_id IN NUMBER,
109 p_balance_type_id IN NUMBER,
110 p_effective_date IN DATE)
111 RETURN NUMBER;
112 /* ------------------------------------------------------------------------------------ */
113 FUNCTION calc_asg_ytd_jp(
114 p_assignment_action_id IN NUMBER,
115 p_balance_type_id IN NUMBER,
116 p_assignment_id IN NUMBER)
117 RETURN NUMBER;
118 /* ------------------------------------------------------------------------------------ */
119 FUNCTION calc_asg_fytd_jp_action(
120 p_assignment_action_id IN NUMBER,
121 p_balance_type_id IN NUMBER)
122 RETURN NUMBER;
123 /* ------------------------------------------------------------------------------------ */
124 FUNCTION calc_asg_fytd_jp_date(
125 p_assignment_id IN NUMBER,
126 p_balance_type_id IN NUMBER,
127 p_effective_date IN DATE)
128 RETURN NUMBER;
129 /* ------------------------------------------------------------------------------------ */
130 FUNCTION calc_asg_fytd_jp(
131 p_assignment_action_id IN NUMBER,
132 p_balance_type_id IN NUMBER,
133 p_assignment_id IN NUMBER)
134 RETURN NUMBER;
135 /* ------------------------------------------------------------------------------------ */
136 FUNCTION calc_asg_fytd2_jp_action(
137 p_assignment_action_id IN NUMBER,
138 p_balance_type_id IN NUMBER)
139 RETURN NUMBER;
140 /* ------------------------------------------------------------------------------------ */
141 FUNCTION calc_asg_fytd2_jp_date(
142 p_assignment_id IN NUMBER,
143 p_balance_type_id IN NUMBER,
144 p_effective_date IN DATE)
145 RETURN NUMBER;
146 /* ------------------------------------------------------------------------------------ */
147 FUNCTION calc_asg_fytd2_jp(
148 p_assignment_action_id IN NUMBER,
149 p_balance_type_id IN NUMBER,
150 p_assignment_id IN NUMBER)
151 RETURN NUMBER;
152 /* ------------------------------------------------------------------------------------ */
153 function calc_asg_apr2mar_jp_action(
154 p_assignment_action_id in number,
155 p_balance_type_id in number)
156 return number;
157 /* ------------------------------------------------------------------------------------ */
158 function calc_asg_apr2mar_jp_date(
159 p_assignment_id in number,
160 p_balance_type_id in number,
161 p_effective_date in date)
162 return number;
163 /* ------------------------------------------------------------------------------------ */
164 function calc_asg_apr2mar_jp(
165 p_assignment_action_id in number,
166 p_balance_type_id in number,
167 p_assignment_id in number)
168 return number;
169 /* ------------------------------------------------------------------------------------ */
170 FUNCTION calc_asg_aug2jul_jp_action(
171 p_assignment_action_id IN NUMBER,
172 p_balance_type_id IN NUMBER)
173 RETURN NUMBER;
174 /* ------------------------------------------------------------------------------------ */
175 FUNCTION calc_asg_aug2jul_jp_date(
176 p_assignment_id IN NUMBER,
177 p_balance_type_id IN NUMBER,
178 p_effective_date IN DATE)
179 RETURN NUMBER;
180 /* ------------------------------------------------------------------------------------ */
181 FUNCTION calc_asg_aug2jul_jp(
182 p_assignment_action_id IN NUMBER,
183 p_balance_type_id IN NUMBER,
184 p_assignment_id IN NUMBER)
185 RETURN NUMBER;
186 /* ------------------------------------------------------------------------------------ */
187 FUNCTION calc_asg_jul2jun_jp_action(
188 p_assignment_action_id IN NUMBER,
189 p_balance_type_id IN NUMBER)
190 RETURN NUMBER;
191 /* ------------------------------------------------------------------------------------ */
192 FUNCTION calc_asg_jul2jun_jp_date(
193 p_assignment_id IN NUMBER,
194 p_balance_type_id IN NUMBER,
195 p_effective_date IN DATE)
196 RETURN NUMBER;
197 /* ------------------------------------------------------------------------------------ */
198 FUNCTION calc_asg_jul2jun_jp(
199 p_assignment_action_id IN NUMBER,
200 p_balance_type_id IN NUMBER,
201 p_assignment_id IN NUMBER)
202 RETURN NUMBER;
203 /* ------------------------------------------------------------------------------------ */
204 FUNCTION calc_asg_itd_action(
205 p_assignment_action_id IN NUMBER,
206 p_balance_type_id IN NUMBER)
207 RETURN NUMBER;
208 /* ------------------------------------------------------------------------------------ */
209 FUNCTION calc_asg_itd_date(
210 p_assignment_id IN NUMBER,
211 p_balance_type_id IN NUMBER,
212 p_effective_date IN DATE)
213 RETURN NUMBER;
214 /* ------------------------------------------------------------------------------------ */
215 FUNCTION calc_asg_itd(
216 p_assignment_action_id IN NUMBER,
217 p_balance_type_id IN NUMBER,
218 p_assignment_id IN NUMBER)
219 RETURN NUMBER;
220 /* ------------------------------------------------------------------------------------ */
221 FUNCTION calc_retro_action(
222 p_assignment_action_id IN NUMBER,
223 p_balance_type_id IN NUMBER)
224 RETURN NUMBER;
225 /* ------------------------------------------------------------------------------------ */
226 FUNCTION calc_retro_date(
227 p_assignment_id IN NUMBER,
228 p_balance_type_id IN NUMBER,
229 p_effective_date IN DATE)
230 RETURN NUMBER;
231 /* ------------------------------------------------------------------------------------ */
232 FUNCTION calc_retro(
233 p_assignment_action_id IN NUMBER,
234 p_balance_type_id IN NUMBER,
235 p_assignment_id IN NUMBER)
236 RETURN NUMBER;
237 /* ------------------------------------------------------------------------------------ */
238 FUNCTION calc_payment_action(
239 p_assignment_action_id IN NUMBER,
240 p_balance_type_id IN NUMBER)
241 RETURN NUMBER;
242 /* ------------------------------------------------------------------------------------ */
243 FUNCTION calc_payment_date(
244 p_assignment_id IN NUMBER,
245 p_balance_type_id IN NUMBER,
246 p_effective_date IN DATE)
247 RETURN NUMBER;
248 /* ------------------------------------------------------------------------------------ */
249 FUNCTION calc_payment(
250 p_assignment_action_id IN NUMBER,
251 p_balance_type_id IN NUMBER,
252 p_assignment_id IN NUMBER)
253 RETURN NUMBER;
254 /* ------------------------------------------------------------------------------------ */
255 FUNCTION calc_element_itd_bal(
256 p_assignment_action_id IN NUMBER,
257 p_balance_type_id IN NUMBER,
258 p_source_id IN NUMBER)
259 RETURN NUMBER;
260 /* ------------------------------------------------------------------------------------ */
261 FUNCTION calc_element_ptd_bal(
262 p_assignment_action_id IN NUMBER,
263 p_balance_type_id IN NUMBER,
264 p_source_id IN NUMBER)
265 RETURN NUMBER;
266 -----------------------------------------------------------------------
267 FUNCTION get_element_reference(
268 p_run_result_id IN NUMBER,
269 p_database_item_suffix IN VARCHAR2)
270 RETURN VARCHAR2;
271 /* ------------------------------------------------------------------------------------ */
272 FUNCTION calc_all_balances(
273 p_assignment_action_id IN NUMBER,
274 p_defined_balance_id IN NUMBER)
275 RETURN NUMBER;
276 /* ------------------------------------------------------------------------------------ */
277 FUNCTION calc_all_balances(
278 p_effective_date IN DATE,
279 p_assignment_id IN NUMBER,
280 p_defined_balance_id IN NUMBER)
281 RETURN NUMBER;
282 /* ------------------------------------------------------------------------------------ */
283 END hr_jpbal;