APPS.PY_ZA_PRORATE_PKG dependencies on PY_ZA_PRORATE_PKG

Line 1: PACKAGE BODY py_za_prorate_pkg as

1: PACKAGE BODY py_za_prorate_pkg as
2: /* $Header: pyzapror.pkb 120.4.12010000.2 2009/04/29 07:00:44 rbabla ship $ */
3: /* +=======================================================================+
4: | Copyright (c) 2001 Oracle Corporation Redwood Shores, California, USA |
5: | All rights reserved. |

Line 12: py_za_prorate_pkg.pkb

8: PRODUCT
9: Oracle Payroll - ZA Localisation
10:
11: NAME
12: py_za_prorate_pkg.pkb
13:
14: DESCRIPTION
15: This package contains functions that can be used in proration
16: functionality.

Line 243: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);

239:
240: -------------------------------------------------------------------------------
241: BEGIN -- MAIN --
242: -------------------------------------------------------------------------------
243: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);
244:
245: OPEN c_Timeperiod(PAYROLL_ACTION_ID);
246: FETCH c_Timeperiod INTO l_Pdates;
247: IF c_Timeperiod%NOTFOUND THEN

Line 252: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',2);

248: raise no_data_found;
249: END IF;
250: CLOSE c_Timeperiod;
251:
252: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',2);
253:
254: OPEN c_Assignment(ASSIGNMENT_ID);
255: FETCH c_Assignment INTO l_Adates;
256: IF c_Assignment%NOTFOUND THEN

Line 261: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',3);

257: raise no_data_found;
258: END IF;
259: CLOSE c_Assignment;
260:
261: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',3);
262:
263: l_asg_dys_wrkd := LEAST(l_Pdates.end_date,l_Adates.end_date)
264: - GREATEST(l_Pdates.start_date,l_Adates.start_date)
265: + 1;

Line 270: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',4);

266: l_dys_in_prd := l_Pdates.end_date - l_Pdates.start_date + 1;
267:
268: l_frctn := l_asg_dys_wrkd / l_dys_in_prd;
269:
270: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',4);
271: RETURN l_frctn;
272:
273: EXCEPTION
274: WHEN OTHERS THEN

Line 275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);

271: RETURN l_frctn;
272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
277: hr_utility.raise_error;
278: -------------------------------------------------------------------------------
279: END pro_rate_days;

Line 276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));

272:
273: EXCEPTION
274: WHEN OTHERS THEN
275: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
276: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
277: hr_utility.raise_error;
278: -------------------------------------------------------------------------------
279: END pro_rate_days;
280:

Line 282: END py_za_prorate_pkg;

278: -------------------------------------------------------------------------------
279: END pro_rate_days;
280:
281:
282: END py_za_prorate_pkg;