[Home] [Help]
PACKAGE: APPS.PAY_ELEMENT_LINKS_PKG
Source
1 package PAY_ELEMENT_LINKS_PKG as
2 /* $Header: pyeli.pkh 120.1.12010000.1 2008/07/27 22:31:16 appldev ship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1994 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10
11 Name
12 Element Links Table Handler
13 Purpose
14 To act as an interface between forms and the Element Links entity
15 History
16 16-MAR-1994 N Simpson Created
17 29-MAR-1994 N Simpson Amended check_distribution_set to
18 restrict cursor by business group/
19 legislation code
20 22-JUN-1994 N Simpson Fixes to G908 bugs
21 25-Oct-1994 N Simpson Fixed G1355 by adding check to
22 check_deletion_allowed to prevent
23 deletion if balance adjustment entries
24 exist outside the life of the link
25 20-MAY-2005 SuSivasu Fixed dbdrv, NOCOPY and GSCC issues.
26 14-NOV-2006 thabara Added function pay_basis_exists.
27 */
28 --------------------------------------------------------------------------------
29 function LINK_END_DATE (p_link_id number) return date;
30 --------------------------------------------------------------------------------
31 procedure insert_row(p_rowid in out nocopy varchar2,
32 p_element_link_id in out nocopy number,
33 p_effective_start_date date,
34 p_effective_end_date in out nocopy date,
35 p_payroll_id number,
36 p_job_id number,
37 p_position_id number,
38 p_people_group_id number,
39 p_cost_allocation_keyflex_id number,
40 p_organization_id number,
41 p_element_type_id number,
42 p_location_id number,
43 p_grade_id number,
44 p_balancing_keyflex_id number,
45 p_business_group_id number,
46 p_legislation_code varchar2,
47 p_element_set_id number,
48 p_pay_basis_id number,
49 p_costable_type varchar2,
50 p_link_to_all_payrolls_flag varchar2,
51 p_multiply_value_flag varchar2,
52 p_standard_link_flag varchar2,
53 p_transfer_to_gl_flag varchar2,
54 p_comment_id number,
55 p_employment_category varchar2,
56 p_qualifying_age number,
57 p_qualifying_length_of_service number,
58 p_qualifying_units varchar2,
59 p_attribute_category varchar2,
60 p_attribute1 varchar2,
61 p_attribute2 varchar2,
62 p_attribute3 varchar2,
63 p_attribute4 varchar2,
64 p_attribute5 varchar2,
65 p_attribute6 varchar2,
66 p_attribute7 varchar2,
67 p_attribute8 varchar2,
68 p_attribute9 varchar2,
69 p_attribute10 varchar2,
70 p_attribute11 varchar2,
71 p_attribute12 varchar2,
72 p_attribute13 varchar2,
73 p_attribute14 varchar2,
74 p_attribute15 varchar2,
75 p_attribute16 varchar2,
76 p_attribute17 varchar2,
77 p_attribute18 varchar2,
78 p_attribute19 varchar2,
79 p_attribute20 varchar2);
80 -------------------------------------------------------------------------------
81 procedure lock_row(p_rowid varchar2,
82 p_element_link_id number,
83 p_effective_start_date date,
84 p_effective_end_date date,
85 p_payroll_id number,
86 p_job_id number,
87 p_position_id number,
88 p_people_group_id number,
89 p_cost_allocation_keyflex_id number,
90 p_organization_id number,
91 p_element_type_id number,
92 p_location_id number,
93 p_grade_id number,
94 p_balancing_keyflex_id number,
95 p_business_group_id number,
96 p_element_set_id number,
97 p_pay_basis_id number,
98 p_costable_type varchar2,
99 p_link_to_all_payrolls_flag varchar2,
100 p_multiply_value_flag varchar2,
101 p_standard_link_flag varchar2,
102 p_transfer_to_gl_flag varchar2,
103 p_comment_id number,
104 p_employment_category varchar2,
105 p_qualifying_age number,
106 p_qualifying_length_of_service number,
107 p_qualifying_units varchar2,
108 p_attribute_category varchar2,
109 p_attribute1 varchar2,
110 p_attribute2 varchar2,
111 p_attribute3 varchar2,
112 p_attribute4 varchar2,
113 p_attribute5 varchar2,
114 p_attribute6 varchar2,
115 p_attribute7 varchar2,
116 p_attribute8 varchar2,
117 p_attribute9 varchar2,
118 p_attribute10 varchar2,
119 p_attribute11 varchar2,
120 p_attribute12 varchar2,
121 p_attribute13 varchar2,
122 p_attribute14 varchar2,
123 p_attribute15 varchar2,
124 p_attribute16 varchar2,
125 p_attribute17 varchar2,
126 p_attribute18 varchar2,
127 p_attribute19 varchar2,
128 p_attribute20 varchar2) ;
129 --------------------------------------------------------------------------------
130 procedure update_row(p_rowid varchar2,
131 p_element_link_id number,
132 p_effective_start_date date,
133 p_effective_end_date in out nocopy date,
134 p_payroll_id number,
135 p_job_id number,
136 p_position_id number,
137 p_people_group_id number,
138 p_cost_allocation_keyflex_id number,
139 p_organization_id number,
140 p_element_type_id number,
141 p_location_id number,
142 p_grade_id number,
143 p_balancing_keyflex_id number,
144 p_business_group_id number,
145 p_legislation_code varchar2,
146 p_element_set_id number,
147 p_pay_basis_id number,
148 p_costable_type varchar2,
149 p_link_to_all_payrolls_flag varchar2,
150 p_multiply_value_flag varchar2,
151 p_standard_link_flag varchar2,
152 p_transfer_to_gl_flag varchar2,
153 p_comment_id number,
154 p_employment_category varchar2,
155 p_qualifying_age number,
156 p_qualifying_length_of_service number,
157 p_qualifying_units varchar2,
158 p_attribute_category varchar2,
159 p_attribute1 varchar2,
160 p_attribute2 varchar2,
161 p_attribute3 varchar2,
162 p_attribute4 varchar2,
163 p_attribute5 varchar2,
164 p_attribute6 varchar2,
165 p_attribute7 varchar2,
166 p_attribute8 varchar2,
167 p_attribute9 varchar2,
168 p_attribute10 varchar2,
169 p_attribute11 varchar2,
170 p_attribute12 varchar2,
171 p_attribute13 varchar2,
172 p_attribute14 varchar2,
173 p_attribute15 varchar2,
174 p_attribute16 varchar2,
175 p_attribute17 varchar2,
176 p_attribute18 varchar2,
177 p_attribute19 varchar2,
178 p_attribute20 varchar2);
179 --------------------------------------------------------------------------------
180 procedure delete_row(
181 --
182 p_rowid varchar2,
183 p_element_link_id number,
184 p_delete_mode varchar2,
185 p_session_date date,
186 p_validation_start_date date,
187 p_validation_end_date date,
188 p_effective_start_date date,
189 p_business_group_id number,
190 p_people_group_id number);
191 --------------------------------------------------------------------------------
192 function MAX_END_DATE(
193 --
194 --******************************************************************************
195 --* Returns the latest allowable date for the effective end date of a link. *
196 --* This is the latest of: *
197 --* 1. The element type's last effective end date. *
198 --* 2. The latest end date for a payroll associated with the link. *
199 --* 3. The day before the start date of another link which would *
200 --* have matching criteria for the same element.
201 --******************************************************************************
202 --
203 -- Parameters are:
204 --
205 p_element_type_id number,
206 p_element_link_id number,
207 p_validation_start_date date,
208 p_validation_end_date date,
209 p_organization_id number,
210 p_people_group_id number,
211 p_job_id number,
212 p_position_id number,
213 p_grade_id number,
214 p_location_id number,
215 p_link_to_all_payrolls_flag varchar2,
216 p_payroll_id number,
217 p_employment_category varchar2,
218 p_pay_basis_id number,
219 p_business_group_id number) return date;
220 --------------------------------------------------------------------------------
221 function ELEMENT_IN_DISTRIBUTION_SET (
222 --******************************************************************************
223 --* Returns TRUE if the element is in a distribution set
224 --******************************************************************************
225
226 p_element_type_id number,
227 p_business_group_id number,
228 p_legislation_code varchar2) return boolean;
229 --------------------------------------------------------------------------------
230 function ELEMENT_ENTRIES_EXIST (
231 --
232 --******************************************************************************
233 --* Returns TRUE if element entries already exist for this link *
234 --******************************************************************************
235 --
236 -- Parameters are:
237 --
238 p_element_link_id number,
239 p_error_if_true boolean := FALSE) return boolean ;
240 --------------------------------------------------------------------------------
241 function DATE_EFFECTIVELY_UPDATED (
242 --
243 --******************************************************************************
244 --* Returns TRUE if there exists more than one row with the same link ID *
245 --******************************************************************************
246 --
247 -- Parameters are:
248 --
249 p_element_link_id number,
250 p_rowid varchar2) return boolean;
251 --------------------------------------------------------------------------------
252 procedure CHECK_DELETION_ALLOWED (
253 --
254 --******************************************************************************
255 --* Checks to see if link may be deleted. *
256 --******************************************************************************
257 --
258 -- Parameters:
259 --
260 p_element_link_id number,
261 p_delete_mode varchar2,
262 p_validation_start_date date );
263 --------------------------------------------------------------------------------
264 procedure CHECK_RELATIONSHIPS (
265 --
266 --******************************************************************************
267 --* Returns values used by forms to set item properties. The calls within this *
268 --* procedure could be used separately, but bundling them here reduces network *
269 --* traffic. *
270 --******************************************************************************
271 --
272 -- Parameters are:
273 --
274 p_element_link_id number,
275 p_rowid varchar2,
276 p_date_effectively_updated out nocopy boolean,
277 p_element_entries_exist out nocopy boolean ) ;
278 --------------------------------------------------------------------------------
279 function PAY_BASIS_EXISTS (
280 --
281 --******************************************************************************
282 --* Returns TRUE if a pay basis exists for the element type. *
283 --******************************************************************************
284 --
285 -- Parameters are:
286 --
287 p_element_type_id number
288 ,p_business_group_id number) return boolean;
289 --------------------------------------------------------------------------------
290 end PAY_ELEMENT_LINKS_PKG;