1 PACKAGE py_za_prorate_pkg AS
2 /* $Header: pyzapror.pkh 120.4 2005/07/04 03:06:45 kapalani noship $ */
3 /* +=======================================================================+
4 | Copyright (c) 2001 Oracle Corporation Redwood Shores, California, USA |
5 | All rights reserved. |
6 +=======================================================================+
7
8 PRODUCT
9 Oracle Payroll - ZA Localisation
10
11 NAME
12 py_za_prorate_pkg.pkh
13
14 DESCRIPTION
15 This package contains functions that can be used in proration
16 functionality.
17
18 PUBLIC FUNCTIONS
19 get_workdays
20 .
21 pro_rate
22 .
23 pro_rate_days
24 Returns the number of days worked in the pay period
25 as a fraction of the total number of days in the pay period.
26 This function can be called through fast formula
27
28 NOTES
29 .
30
31 MODIFICATION HISTORY
32 Person Date(DD-MM-YYYY) Version Comments
33 --------- ---------------- ------- -----------------------------
34 J.N. Louw 07-09-2001 115.2 Updated pro_rate_days
35 A.Stander 19-11-1998 110.0 Initial version
36 */
37
38
39 FUNCTION get_workdays
40 ( period_1 IN date
41 , period_2 IN date
42 ) RETURN NUMBER;
43 pragma restrict_references(get_workdays,WNDS);
44
45 FUNCTION pro_rate
46 ( payroll_action_id IN number
47 ) RETURN NUMBER;
48
49 pragma restrict_references(pro_rate,WNDS);
50
51 FUNCTION pro_rate_days
52 ( PAYROLL_ACTION_ID IN NUMBER
53 , ASSIGNMENT_ID IN NUMBER
54 ) RETURN NUMBER;
55
56 END py_za_prorate_pkg;