1 PACKAGE pay_sg_exc AS
2 /* $Header: pysgexch.pkh 120.0 2005/05/29 08:46:12 appldev noship $ */
3 /*
4 PRODUCT
5 Oracle*Payroll
6 NAME
7 pysgexch.pkb - PaYroll SG legislation EXpiry Checking code.
8 DESCRIPTION
9 Contains the expiry checking code associated with the SG
10 balance dimensions. Following the change
11 to latest balance functionality, these need to be contained
12 as packaged procedures.
13 PUBLIC FUNCTIONS
14 <none>
15 PRIVATE FUNCTIONS
16 <none>
17 NOTES
18 <none>
19 MODIFIED (DD/MM/YY)
20 jbailie 25/04/00 - first created. Based on PAYUSEXC (115)
21
22 */
23 PROCEDURE date_ec
24 (
25 p_owner_payroll_action_id in number, -- run created balance.
26 p_user_payroll_action_id in number, -- current run.
27 p_owner_assignment_action_id in number, -- assact created balance.
28 p_user_assignment_action_id in number, -- current assact..
29 p_owner_effective_date in date, -- eff date of balance.
30 p_user_effective_date in date, -- eff date of current run.
31 p_dimension_name in varchar2, -- balance dimension name.
32 p_expiry_information out nocopy number -- dimension expired flag.
33 );
34 PROCEDURE date_ec /* Bug 2797863 */
35
36 (
37
38 p_owner_payroll_action_id in number, -- run created balance.
39
40 p_user_payroll_action_id in number, -- current run.
41
42 p_owner_assignment_action_id in number, -- assact created balance.
43
44 p_user_assignment_action_id in number, -- current assact..
45
46 p_owner_effective_date in date, -- eff date of balance.
47
48 p_user_effective_date in date, -- eff date of current run.
49
50 p_dimension_name in varchar2, -- balance dimension name.
51
52 p_expiry_information out nocopy date -- dimension expired date.
53
54 );
55
56
57 FUNCTION get_expiry_date
58 (
59 p_defined_balance_id in number, -- defined balance.
60 p_assignment_action_id in number -- assact created balance.
61 ) RETURN DATE;
62
63 FUNCTION calculated_value
64 (
65 p_defined_balance_id in number, -- defined balance.
66 p_assignment_action_id in number, -- assact created balance.
67 p_tax_unit_id in number,
68 p_session_date in date
69 ) RETURN NUMBER;
70
71
72 END pay_sg_exc;