DBA Data[Home] [Help]

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 2005/08/25 02:47:45 kapalani noship $ */
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 239: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);

235:
236: -------------------------------------------------------------------------------
237: BEGIN -- MAIN --
238: -------------------------------------------------------------------------------
239: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',1);
240:
241: OPEN c_Timeperiod(PAYROLL_ACTION_ID);
242: FETCH c_Timeperiod INTO l_Pdates;
243: IF c_Timeperiod%NOTFOUND THEN

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

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

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

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

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

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

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

267: RETURN l_frctn;
268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
272: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
273: hr_utility.raise_error;
274: -------------------------------------------------------------------------------
275: END pro_rate_days;

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

268:
269: EXCEPTION
270: WHEN OTHERS THEN
271: hr_utility.set_location('py_za_prorate_pkg.pro_rate_days',5);
272: hr_utility.set_message(801, 'py_za_prorate_pkg: '||TO_CHAR(SQLCODE));
273: hr_utility.raise_error;
274: -------------------------------------------------------------------------------
275: END pro_rate_days;
276:

Line 278: END py_za_prorate_pkg;

274: -------------------------------------------------------------------------------
275: END pro_rate_days;
276:
277:
278: END py_za_prorate_pkg;