1 PACKAGE pay_no_expiry_support AS
2 /* $Header: pynobalexp.pkh 120.0.12000000.1 2007/01/17 23:09:24 appldev noship $ */
3
4 /*------------------------------ date_ec ------------------------------------
5 NAME
6 date_ec
7 DESCRIPTION
8 Norway specific Expiry checking code for the following date-related
9 dimensions:
10 -----------------------------------------
11 Person and GRE and Bi-Month.
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 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 /* This procedure is the overlaoded function that will take care of the
36 of the requirement of Balance adjustment process.*/
37
38 PROCEDURE date_ec
39 (
40 p_owner_payroll_action_id IN NUMBER, -- run created balance.
41 p_user_payroll_action_id IN NUMBER, -- current run.
42 p_owner_assignment_action_id iN NUMBER, -- assact created balance.
43 p_user_assignment_action_id IN NUMBER, -- current assact..
44 p_owner_effective_date IN DATE, -- eff date of balance.
45 p_user_effective_date IN DATE, -- eff date of current run.
46 p_dimension_name IN VARCHAR2, -- balance dimension name.
47 p_expiry_information OUT NOCOPY DATE -- dimension expired date.
48 );
49
50 END pay_no_expiry_support;