1 package pay_pyieexc AUTHID CURRENT_USER as
2 /* $Header: pyieexc.pkh 115.4 2003/01/28 10:14:55 mmahmad ship $ */
3 /* Copyright (c) Oracle Corporation 1994. All rights reserved. */
4 /*
5 PRODUCT
6 Oracle*Payroll
7 NAME
8 pyieexc.pkh - PaYroll Test IE legislation EXpiry Checking code.
9 DESCRIPTION
10 Contains the expiry checking code for the balance dimensions
11 created for IRELAND.
12 PUBLIC FUNCTIONS
13 <none>
14 PRIVATE FUNCTIONS
15 <none>
16 NOTES
17 <none>
18 MODIFIED (DD/MM/YY)
19 rmakhija 15/06/01 - first created by editing similar package of GB localization.
20 abhaduri 16/04/02 - added ASG_PROC_PTD_EC procedure for new dimension
21 _ELEMENT_PTD for Attachment of Earnings Order.
22 mmahmad 24/01/03 Added NOCOPY
23 */
24 /*------------------------------ ASG_PTD_EC ----------------------------*/
25 /*
26 NAME
27 ASG_PTD_EC - Assignment-level Period to Date expiry check.
28 DESCRIPTION
29 Expiry checking code for the following:
30 IE Assignment-level Period To Date Balance Dimension
31 NOTES
32 The associated dimension is expiry checked at assignment action level
33 */
34 procedure ASG_PTD_EC
35 (
36 p_owner_payroll_action_id in number, -- run created balance.
37 p_user_payroll_action_id in number, -- current run.
38 p_owner_assignment_action_id in number, -- assact created balance.
39 p_user_assignment_action_id in number, -- current assact..
40 p_owner_effective_date in date, -- eff date of balance.
41 p_user_effective_date in date, -- eff date of current run.
42 p_dimension_name in varchar2, -- balance dimension name.
43 p_expiry_information out NOCOPY number -- dimension expired flag.
44 ) ;
45
46 /*------------------------------ ASG_YTD_EC -------------------------*/
47 /*
48 NAME
49 ASG_YTD_EC - Assignment Tax Year to Date expiry check
50 DESCRIPTION
51 Expiry checking code for the following:
52 IE Assignment-level Tax Year to Date dimension
53 NOTES
54 The associated dimension is expiry checked at assignment action level
55 */
56 procedure ASG_YTD_EC
57 (
58 p_owner_payroll_action_id in number, -- run created balance.
59 p_user_payroll_action_id in number, -- current run.
60 p_owner_assignment_action_id in number, -- assact created balance.
61 p_user_assignment_action_id in number, -- current assact..
62 p_owner_effective_date in date, -- eff date of balance.
63 p_user_effective_date in date, -- eff date of current run.
64 p_dimension_name in varchar2, -- balance dimension name.
65 p_expiry_information out NOCOPY number -- dimension expired flag.
66 ) ;
67
68 /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/
69 /*
70 NAME
71 ASG_PROC_PTD_EC - Assignment Processing Period to Date expiry check.
72 DESCRIPTION
73 Expiry checking code for the following:
74 IE Element-level Process Period To Date Balance Dimension
75 NOTES
76 The associtated dimension is expiry checked at payroll action level
77 */
78 procedure ASG_PROC_PTD_EC
79 (
80 p_owner_payroll_action_id in number, -- run created balance.
81 p_user_payroll_action_id in number, -- current run.
82 p_owner_assignment_action_id in number, -- assact created balance.
83 p_user_assignment_action_id in number, -- current assact..
84 p_owner_effective_date in date, -- eff date of balance.
85 p_user_effective_date in date, -- eff date of current run.
86 p_dimension_name in varchar2, -- balance dimension name.
87 p_expiry_information out NOCOPY number -- dimension expired flag.
88 ) ;
89 -----------------------------------------------------------------------------
90
91 end pay_pyieexc;