1 PACKAGE pay_hk_exc AS
2 /* $Header: pyhkexch.pkh 120.1 2007/11/16 10:34:07 vamittal noship $ */
3 /*
4 PRODUCT
5 Oracle*Payroll
6 NAME
7 pyhkexch.pkb - PaYroll HK legislation EXpiry Checking code.
8 DESCRIPTION
9 Contains the expiry checking code associated with the HK
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 21/09/2000 - first created. Based on PAYSGEXC (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
35 FUNCTION get_expiry_date
36 (
37 p_defined_balance_id in number, -- defined balance.
38 p_assignment_action_id in number -- assact created balance.
39 ) RETURN DATE;
40
41 FUNCTION calculated_value
42 (
43 p_defined_balance_id in number, -- defined balance.
44 p_assignment_action_id in number, -- assact created balance.
45 p_tax_unit_id in number, -- tax_unit
46 p_source_id in number, -- source_id
47 p_session_date in date
48 ) RETURN NUMBER;
49
50 /* Bug No : 3004608 =>
51 Included the following overloaded procedure specification for prevention of loss of latest balances during balance adjustment process */
52
53 PROCEDURE date_ec
54 (
55 p_owner_payroll_action_id in number, -- run created balance.
56 p_user_payroll_action_id in number, -- current run.
57 p_owner_assignment_action_id in number, -- assact created balance.
58 p_user_assignment_action_id in number, -- current assact.
59 p_owner_effective_date in date, -- eff date of balance.
60 p_user_effective_date in date, -- eff date of current run.
61 p_dimension_name in varchar2, -- balance dimension name.
62 p_expiry_date out nocopy date -- dimension expired date.
63 );
64
65 /* Bug 6318006 This procedure finds the start date based on the specified date for dimension _ASG_12MTHS_PREV */
66
67 PROCEDURE start_code_12mths_prev( p_effective_date IN DATE
68 , p_start_date OUT NOCOPY DATE
69 , p_payroll_id IN NUMBER
70 , p_bus_grp IN NUMBER
71 , p_asg_action IN NUMBER
72 );
73
74
75 END pay_hk_exc;