97:
98:
99: begin
100:
101: hr_utility.trace('In: ' || l_procedure_name) ;
102:
103: -- tracing the values....
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
100:
101: hr_utility.trace('In: ' || l_procedure_name) ;
102:
103: -- tracing the values....
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
106: hr_utility.trace('p_creator_type :'||p_creator_type);
107: hr_utility.trace('p_element_link_id :'||p_element_link_id);
108: hr_utility.trace('p_creator_id :'||p_creator_id);
101: hr_utility.trace('In: ' || l_procedure_name) ;
102:
103: -- tracing the values....
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
106: hr_utility.trace('p_creator_type :'||p_creator_type);
107: hr_utility.trace('p_element_link_id :'||p_element_link_id);
108: hr_utility.trace('p_creator_id :'||p_creator_id);
109:
102:
103: -- tracing the values....
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
106: hr_utility.trace('p_creator_type :'||p_creator_type);
107: hr_utility.trace('p_element_link_id :'||p_element_link_id);
108: hr_utility.trace('p_creator_id :'||p_creator_id);
109:
110: -- check to see if the element entry is for an absence
103: -- tracing the values....
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
106: hr_utility.trace('p_creator_type :'||p_creator_type);
107: hr_utility.trace('p_element_link_id :'||p_element_link_id);
108: hr_utility.trace('p_creator_id :'||p_creator_id);
109:
110: -- check to see if the element entry is for an absence
111:
104: hr_utility.trace('p_effective_date : '||p_effective_date);
105: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
106: hr_utility.trace('p_creator_type :'||p_creator_type);
107: hr_utility.trace('p_element_link_id :'||p_element_link_id);
108: hr_utility.trace('p_creator_id :'||p_creator_id);
109:
110: -- check to see if the element entry is for an absence
111:
112: if p_creator_type = 'A'
119: fetch c_absence
120: into l_batch_id ;
121: close c_absence ;
122:
123: hr_utility.trace('l_batch_id :'||l_batch_id);
124:
125: if l_batch_id is not null
126: then
127:
146: end if;
147: end loop;
148: close c_absence_category;
149:
150: hr_utility.trace('l_absence_category :'||l_absence_category);
151: hr_utility.trace('l_element_name :'||l_element_name);
152:
153: -- we've got an absence created by BEE so get values for Certificate Required,
154: -- Certificate Received input values to put into
147: end loop;
148: close c_absence_category;
149:
150: hr_utility.trace('l_absence_category :'||l_absence_category);
151: hr_utility.trace('l_element_name :'||l_element_name);
152:
153: -- we've got an absence created by BEE so get values for Certificate Required,
154: -- Certificate Received input values to put into
155: -- corresponding segments of PER_ABS_DEVELOPER_DF descriptive
164:
165: fetch c_input_value
166: into l_Certificate_required ;
167:
168: hr_utility.trace('l_Certificate_required :'||l_Certificate_required);
169:
170: if c_input_value%notfound
171: or l_Certificate_required is null
172: then
174: end if ;
175:
176: close c_input_value ;
177:
178: hr_utility.trace('AFTER l_Certificate_required :'||l_Certificate_required);
179:
180: update per_absence_attendances
181: set abs_information1 = l_Certificate_required
182: ,abs_information_category = 'AU_' || l_absence_category
190:
191: fetch c_input_value
192: into l_certificate_received ;
193:
194: hr_utility.trace('l_Certificate_received :'||l_Certificate_received);
195:
196: if c_input_value%notfound
197: or l_certificate_received is null
198: then
200: end if ;
201:
202: close c_input_value ;
203:
204: hr_utility.trace('l_Certificate_received :'||l_Certificate_received);
205:
206: -- now update the Descriptive Flexfield segments
207:
208: update per_absence_attendances
215: end if ; -- l_batch_id is not null
216:
217: end if ; -- p_creator_type = 'A'
218:
219: hr_utility.trace('Out: ' || l_procedure_name) ;
220: end insert_absence_dev_desc_flex ;
221:
222: -- -------------------------------------------------------------------------
223: -- populate update_element_entry_values procedure
271: and peev.input_value_id = piv.input_value_id;
272:
273: begin
274:
275: hr_utility.trace('In: ' || l_procedure_name) ;
276:
277: -- tracing the values....
278: hr_utility.trace('p_effective_date : '||p_effective_date);
279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
274:
275: hr_utility.trace('In: ' || l_procedure_name) ;
276:
277: -- tracing the values....
278: hr_utility.trace('p_effective_date : '||p_effective_date);
279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
280: hr_utility.trace('p_creator_type :'||p_creator_type);
281: hr_utility.trace('p_creator_id :'||p_creator_id);
282:
275: hr_utility.trace('In: ' || l_procedure_name) ;
276:
277: -- tracing the values....
278: hr_utility.trace('p_effective_date : '||p_effective_date);
279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
280: hr_utility.trace('p_creator_type :'||p_creator_type);
281: hr_utility.trace('p_creator_id :'||p_creator_id);
282:
283: if p_creator_type = 'A'
276:
277: -- tracing the values....
278: hr_utility.trace('p_effective_date : '||p_effective_date);
279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
280: hr_utility.trace('p_creator_type :'||p_creator_type);
281: hr_utility.trace('p_creator_id :'||p_creator_id);
282:
283: if p_creator_type = 'A'
284: then
277: -- tracing the values....
278: hr_utility.trace('p_effective_date : '||p_effective_date);
279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);
280: hr_utility.trace('p_creator_type :'||p_creator_type);
281: hr_utility.trace('p_creator_id :'||p_creator_id);
282:
283: if p_creator_type = 'A'
284: then
285:
299: open get_element_entry_value_id(p_element_entry_id,'Start Date');
300: fetch get_element_entry_value_id into l_element_entry_value_id;
301: close get_element_entry_value_id;
302:
303: hr_utility.trace('Updating Start Date entry value as l_start_date :'||l_start_date);
304:
305: update pay_element_entry_values_f
306: set screen_entry_value = l_start_date
307: where element_entry_value_id = l_element_entry_value_id;
309: open get_element_entry_value_id(p_element_entry_id,'End Date');
310: fetch get_element_entry_value_id into l_element_entry_value_id;
311: close get_element_entry_value_id;
312:
313: hr_utility.trace('Updating End Date entry value as l_end_date :'||l_end_date);
314:
315: update pay_element_entry_values_f
316: set screen_entry_value = l_end_date
317: where element_entry_value_id = l_element_entry_value_id;
319: open get_element_entry_value_id(p_element_entry_id,'Pay Date');
320: fetch get_element_entry_value_id into l_element_entry_value_id;
321: close get_element_entry_value_id;
322:
323: hr_utility.trace('Updating Pay Date entry value as abs_information1 :'||l_abs_information1);
324:
325: update pay_element_entry_values_f
326: set screen_entry_value = l_abs_information1
327: where element_entry_value_id = l_element_entry_value_id;
329: open get_element_entry_value_id(p_element_entry_id,'Advance Defer');
330: fetch get_element_entry_value_id into l_element_entry_value_id;
331: close get_element_entry_value_id;
332:
333: hr_utility.trace('Updating Start Advance Defer value as abs_information2 :'||l_abs_information2);
334:
335: update pay_element_entry_values_f
336: set screen_entry_value = l_abs_information2
337: where element_entry_value_id = l_element_entry_value_id;
339: open get_element_entry_value_id(p_element_entry_id,'Advance Override');
340: fetch get_element_entry_value_id into l_element_entry_value_id;
341: close get_element_entry_value_id;
342:
343: hr_utility.trace('Updating Advance Override entry value as abs_information3 :'||l_abs_information3);
344:
345: update pay_element_entry_values_f
346: set screen_entry_value = l_abs_information3
347: where element_entry_value_id = l_element_entry_value_id;