1 PACKAGE pay_dk_expiry_support AS
2 /* $Header: pydkbalexp.pkh 120.0 2006/03/23 03:54:48 knelli noship $ */
3
4 /*------------------------------ date_ec ------------------------------------
5 NAME
6 date_ec
7 DESCRIPTION
8 Denmark specific Expiry checking code for the following date-related
9 dimensions:
10 -----------------------------------------
11 Holiday Year. (May to April)
12 -----------------------------------------
13
14 The Expiry checking code for the rest of the dimensions uses functions
15 delivered in PAY_IP_EXPIRY_SUPPORT.
16
17
18 NOTES
19 This procedure assumes the date portion of the dimension name
20 is always at the end to allow accurate identification since
21 this is used for many dimensions.
22 */
23
24
25 FUNCTION next_holiday_year_start
26 (
27 p_pactid IN NUMBER,
28 p_date IN DATE
29 ) RETURN DATE;
30
31 PROCEDURE date_ec
32 (
33 p_owner_payroll_action_id IN NUMBER, -- run created balance.
34 p_user_payroll_action_id IN NUMBER, -- current run.
35 p_owner_assignment_action_id IN NUMBER, -- assact created balance.
36 p_user_assignment_action_id IN NUMBER, -- current assact..
37 p_owner_effective_date IN DATE, -- eff date of balance.
38 p_user_effective_date IN DATE, -- eff date of current run.
39 p_dimension_name IN VARCHAR2, -- balance dimension name.
40 p_expiry_information OUT NOCOPY NUMBER -- dimension expired flag.
41 );
42
43 /* This procedure is the overlaoded function that will take care of the
44 of the requirement of Balance adjustment process.*/
45
46 PROCEDURE date_ec
47 (
48 p_owner_payroll_action_id IN NUMBER, -- run created balance.
49 p_user_payroll_action_id IN NUMBER, -- current run.
50 p_owner_assignment_action_id iN NUMBER, -- assact created balance.
51 p_user_assignment_action_id IN NUMBER, -- current assact..
52 p_owner_effective_date IN DATE, -- eff date of balance.
53 p_user_effective_date IN DATE, -- eff date of current run.
54 p_dimension_name IN VARCHAR2, -- balance dimension name.
55 p_expiry_information OUT NOCOPY DATE -- dimension expired date.
56 );
57
58 END pay_dk_expiry_support;
59