1 PACKAGE pay_ip_expiry_support AS
2 /* $Header: pyipexps.pkh 120.0 2005/05/29 05:59:43 appldev noship $ */
3 --
4 --
5 -- --------------------------------------------------------------------------
6 -- This is the procedure called by the core logic that manages the expiry of
7 -- latest balances. Its interface is fixed as it is called dynamically.
8 --
9 -- It will return the following output indicating the latest balance expiration
10 -- status ...
11 --
12 -- p_expiry_information = 1 - Expired
13 -- p_expiry_information = 0 - OK
14 -- --------------------------------------------------------------------------
15 --
16 PROCEDURE date_ec
17 (p_owner_payroll_action_id NUMBER
18 ,p_user_payroll_action_id NUMBER
19 ,p_owner_assignment_action_id NUMBER
20 ,p_user_assignment_action_id NUMBER
21 ,p_owner_effective_date DATE
22 ,p_user_effective_date DATE
23 ,p_dimension_name VARCHAR2
24 ,p_expiry_information OUT NOCOPY NUMBER);
25 --
26 -- ----------------------------------------------------------------------------
27 -- This is the overloaded procedure which returns actual expiry date
28 -- ----------------------------------------------------------------------------
29 --
30 PROCEDURE date_ec
31 (p_owner_payroll_action_id NUMBER
32 ,p_user_payroll_action_id NUMBER
33 ,p_owner_assignment_action_id NUMBER
34 ,p_user_assignment_action_id NUMBER
35 ,p_owner_effective_date DATE
36 ,p_user_effective_date DATE
37 ,p_dimension_name VARCHAR2
38 ,p_expiry_information OUT NOCOPY DATE);
39 END pay_ip_expiry_support;