1 package pyieexc AUTHID CURRENT_USER as
2 /* $Header: pyieexc.pkh 120.1 2009/06/05 06:34:34 knadhan 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 vmkhande 16/04/03 Added expiry code for ASG_QTD
24 npershad 30/10/03 Added expiry code for ASG_TWO_YTD
25 rtulaban 26/05/04 Added start date code for ASG_TWO_YTD.
26 knadhan 05/06/09 Created overridden procedures for all procedure for preventing
27 loss of latest balance when an baalnce adjsutment done.
28 Bug 8522294..
29 */
30 /*------------------------------ ASG_PTD_EC ----------------------------*/
31 /*
32 NAME
33 ASG_PTD_EC - Assignment-level Period to Date expiry check.
34 DESCRIPTION
35 Expiry checking code for the following:
36 IE Assignment-level Period To Date Balance Dimension
37 NOTES
38 The associated dimension is expiry checked at assignment action level
39 */
40 procedure ASG_PTD_EC
41 (
42 p_owner_payroll_action_id in number, -- run created balance.
43 p_user_payroll_action_id in number, -- current run.
44 p_owner_assignment_action_id in number, -- assact created balance.
45 p_user_assignment_action_id in number, -- current assact..
46 p_owner_effective_date in date, -- eff date of balance.
47 p_user_effective_date in date, -- eff date of current run.
48 p_dimension_name in varchar2, -- balance dimension name.
49 p_expiry_information out NOCOPY number -- dimension expired flag.
50 ) ;
51 /* 8522294 */
52 procedure ASG_PTD_EC
53 (
54 p_owner_payroll_action_id in number, -- run created balance.
55 p_user_payroll_action_id in number, -- current run.
56 p_owner_assignment_action_id in number, -- assact created balance.
57 p_user_assignment_action_id in number, -- current assact..
58 p_owner_effective_date in date, -- eff date of balance.
59 p_user_effective_date in date, -- eff date of current run.
60 p_dimension_name in varchar2, -- balance dimension name.
61 p_expiry_information out NOCOPY date -- dimension expired flag.
62 ) ;
63
64 /*------------------------------ ASG_YTD_EC -------------------------*/
65 /*
66 NAME
67 ASG_YTD_EC - Assignment Tax Year to Date expiry check
68 DESCRIPTION
69 Expiry checking code for the following:
70 IE Assignment-level Tax Year to Date dimension
71 NOTES
72 The associated dimension is expiry checked at assignment action level
73 */
74 procedure ASG_YTD_EC
75 (
76 p_owner_payroll_action_id in number, -- run created balance.
77 p_user_payroll_action_id in number, -- current run.
78 p_owner_assignment_action_id in number, -- assact created balance.
79 p_user_assignment_action_id in number, -- current assact..
80 p_owner_effective_date in date, -- eff date of balance.
81 p_user_effective_date in date, -- eff date of current run.
82 p_dimension_name in varchar2, -- balance dimension name.
83 p_expiry_information out NOCOPY number -- dimension expired flag.
84 ) ;
85
86 /* 8522294 */
87 procedure ASG_YTD_EC
88 (
89 p_owner_payroll_action_id in number, -- run created balance.
90 p_user_payroll_action_id in number, -- current run.
91 p_owner_assignment_action_id in number, -- assact created balance.
92 p_user_assignment_action_id in number, -- current assact..
93 p_owner_effective_date in date, -- eff date of balance.
94 p_user_effective_date in date, -- eff date of current run.
95 p_dimension_name in varchar2, -- balance dimension name.
96 p_expiry_information out NOCOPY date -- dimension expired flag.
97 ) ;
98 /*------------------------------ ASG_PROC_PTD_EC ----------------------------*/
99 /*
100 NAME
101 ASG_PROC_PTD_EC - Assignment Processing Period to Date expiry check.
102 DESCRIPTION
103 Expiry checking code for the following:
104 IE Element-level Process Period To Date Balance Dimension
105 NOTES
106 The associtated dimension is expiry checked at payroll action level
107 */
108 procedure ASG_PROC_PTD_EC
109 (
110 p_owner_payroll_action_id in number, -- run created balance.
111 p_user_payroll_action_id in number, -- current run.
112 p_owner_assignment_action_id in number, -- assact created balance.
113 p_user_assignment_action_id in number, -- current assact..
114 p_owner_effective_date in date, -- eff date of balance.
115 p_user_effective_date in date, -- eff date of current run.
116 p_dimension_name in varchar2, -- balance dimension name.
117 p_expiry_information out NOCOPY number -- dimension expired flag.
118 ) ;
119
120 /* 8522294 */
121
122 procedure ASG_PROC_PTD_EC
123 (
124 p_owner_payroll_action_id in number, -- run created balance.
125 p_user_payroll_action_id in number, -- current run.
126 p_owner_assignment_action_id in number, -- assact created balance.
127 p_user_assignment_action_id in number, -- current assact..
128 p_owner_effective_date in date, -- eff date of balance.
129 p_user_effective_date in date, -- eff date of current run.
130 p_dimension_name in varchar2, -- balance dimension name.
131 p_expiry_information out NOCOPY date -- dimension expired flag.
132 ) ;
133
134 /*------------------------------ ASG_QTD_EC ----------------------------*/
135 /*
136 NAME
137 ASG_QTD_EC - Assignment-level Quater to Date expiry check.
138 DESCRIPTION
139 Expiry checking code for the following:
140 IE Assignment-level Quater To Date Balance Dimension
141 NOTES
142 The associated dimension is expiry checked at assignment action level
143 */
144 procedure ASG_QTD_EC
145 (
146 p_owner_payroll_action_id in number, -- run created balance.
147 p_user_payroll_action_id in number, -- current run.
148 p_owner_assignment_action_id in number, -- assact created balance.
149 p_user_assignment_action_id in number, -- current assact..
150 p_owner_effective_date in date, -- eff date of balance.
151 p_user_effective_date in date, -- eff date of current run.
152 p_dimension_name in varchar2, -- balance dimension name.
153 p_expiry_information out NOCOPY number -- dimension expired flag.
154 ) ;
155
156 /* 8522294 */
157
158 procedure ASG_QTD_EC
159 (
160 p_owner_payroll_action_id in number, -- run created balance.
161 p_user_payroll_action_id in number, -- current run.
162 p_owner_assignment_action_id in number, -- assact created balance.
163 p_user_assignment_action_id in number, -- current assact..
164 p_owner_effective_date in date, -- eff date of balance.
165 p_user_effective_date in date, -- eff date of current run.
166 p_dimension_name in varchar2, -- balance dimension name.
167 p_expiry_information out NOCOPY date -- dimension expired flag.
168 ) ;
169
170 /*------------------------------ ASG_TWO_YTD_EC -------------------------*/
171 /*
172 NAME
173 ASG_YTD_EC - Assignment Previous Year/Tax Year to Date expiry check
174 DESCRIPTION
175 Expiry checking code for the following:
176 IE Assignment-level Previous Year/Tax Year to Date dimension
177 NOTES
178 The associated dimension is expiry checked at assignment action level
179 */
180 procedure ASG_TWO_YTD_EC
181 (
182 p_owner_payroll_action_id in number, -- run created balance.
183 p_user_payroll_action_id in number, -- current run.
184 p_owner_assignment_action_id in number, -- assact created balance.
185 p_user_assignment_action_id in number, -- current assact..
186 p_owner_effective_date in date, -- eff date of balance.
187 p_user_effective_date in date, -- eff date of current run.
188 p_dimension_name in varchar2, -- balance dimension name.
189 p_expiry_information out NOCOPY number -- dimension expired flag.
190 ) ;
191
192 /* 8522294 */
193
194 procedure ASG_TWO_YTD_EC
195 (
196 p_owner_payroll_action_id in number, -- run created balance.
197 p_user_payroll_action_id in number, -- current run.
198 p_owner_assignment_action_id in number, -- assact created balance.
199 p_user_assignment_action_id in number, -- current assact..
200 p_owner_effective_date in date, -- eff date of balance.
201 p_user_effective_date in date, -- eff date of current run.
202 p_dimension_name in varchar2, -- balance dimension name.
203 p_expiry_information out NOCOPY date -- dimension expired flag.
204 ) ;
205 -----------------------------------------------------------------------------
206 -- Procedure: PROC_TWO_YTD_START
207 -- Description: used by TWO_YTD Dimensions for Run Level Balances only.
208 -- This procedure accepts a date and assignment action and other
209 -- params, and returns the start date of the Previous Tax Year, depending
210 -- on the regular payment date of the payroll action.
211
212 procedure proc_two_ytd_start
213 (
214 p_period_type in varchar2 default null,
215 p_effective_date in date default null,
216 p_start_date out nocopy date,
217 p_start_date_code in varchar2 default null,
218 p_payroll_id in number,
219 p_bus_grp in number default null,
220 p_action_type in varchar2 default null,
221 p_asg_action in number
222 );
223
224 -----------------------------------------------------------------------------
225 end pyieexc;