1 PACKAGE PAY_FI_EXPIRY_SUPPORT AUTHID CURRENT_USER AS
2 /* $Header: pyfiepst.pkh 120.1 2006/01/24 22:12:20 dbehera 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 court_order_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 PROCEDURE court_order_ec
27 (p_owner_payroll_action_id NUMBER
28 ,p_user_payroll_action_id NUMBER
29 ,p_owner_assignment_action_id NUMBER
30 ,p_user_assignment_action_id NUMBER
31 ,p_owner_effective_date DATE
32 ,p_user_effective_date DATE
33 ,p_dimension_name VARCHAR2
34 ,p_expiry_information OUT NOCOPY DATE);
35
36 PROCEDURE holiday_pay_ec
37 (p_owner_payroll_action_id NUMBER
38 ,p_user_payroll_action_id NUMBER
39 ,p_owner_assignment_action_id NUMBER
40 ,p_user_assignment_action_id NUMBER
41 ,p_owner_effective_date DATE
42 ,p_user_effective_date DATE
43 ,p_dimension_name VARCHAR2
44 ,p_expiry_information OUT NOCOPY NUMBER);
45
46 PROCEDURE holiday_pay_ec
47 (p_owner_payroll_action_id NUMBER
48 ,p_user_payroll_action_id NUMBER
49 ,p_owner_assignment_action_id NUMBER
50 ,p_user_assignment_action_id NUMBER
51 ,p_owner_effective_date DATE
52 ,p_user_effective_date DATE
53 ,p_dimension_name VARCHAR2
54 ,p_expiry_information OUT NOCOPY DATE);
55
56 END pay_fi_expiry_support;