1 PACKAGE pay_mx_expiry_support AUTHID CURRENT_USER AS
2 /* $Header: paymxbalexpccode.pkh 120.0 2005/05/29 11:49:56 appldev noship $ */
3
4 /*------------------------------ date_ec ------------------------------------
5 NAME
6 date_ec
7 DESCRIPTION
8 Mexico specific Expiry checking code for the following date-related
9 dimensions:
10 Person and GRE and Bi-Month.
11 The Expiry checking code for the rest of the dimensions uses functions
12 delivered in PAY_IP_EXPIRY_SUPPORT.
13
14
15 NOTES
16 This procedure assumes the date portion of the dimension name
17 is always at the end to allow accurate identification since
18 this is used for many dimensions.
19 */
20 PROCEDURE date_ec
21 (
22 p_owner_payroll_action_id IN NUMBER, -- run created balance.
23 p_user_payroll_action_id IN NUMBER, -- current run.
24 p_owner_assignment_action_id IN NUMBER, -- assact created balance.
25 p_user_assignment_action_id IN NUMBER, -- current assact..
26 p_owner_effective_date IN DATE, -- eff date of balance.
27 p_user_effective_date IN DATE, -- eff date of current run.
28 p_dimension_name IN VARCHAR2, -- balance dimension name.
29 p_expiry_information OUT NOCOPY NUMBER -- dimension expired flag.
30 );
31
32 /* This procedure is the overlaoded function that will take care of the
33 of the requirement of Balance adjustment process.*/
34
35 PROCEDURE date_ec
36 (
37 p_owner_payroll_action_id IN NUMBER, -- run created balance.
38 p_user_payroll_action_id IN NUMBER, -- current run.
39 p_owner_assignment_action_id iN NUMBER, -- assact created balance.
40 p_user_assignment_action_id IN NUMBER, -- current assact..
41 p_owner_effective_date IN DATE, -- eff date of balance.
42 p_user_effective_date IN DATE, -- eff date of current run.
43 p_dimension_name IN VARCHAR2, -- balance dimension name.
44 p_expiry_information OUT NOCOPY DATE -- dimension expired date.
45 );
46
47 END pay_mx_expiry_support;
[Home] [Help]