DBA Data[Home] [Help]

APPS.HR_AU_ELEMENT_ENTRY_HOOK dependencies on HR_UTILITY

Line 101: hr_utility.trace('In: ' || l_procedure_name) ;

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);

Line 104: hr_utility.trace('p_effective_date : '||p_effective_date);

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);

Line 105: hr_utility.trace('p_element_entry_id :'||p_element_entry_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:

Line 106: hr_utility.trace('p_creator_type :'||p_creator_type);

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

Line 107: hr_utility.trace('p_element_link_id :'||p_element_link_id);

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:

Line 108: hr_utility.trace('p_creator_id :'||p_creator_id);

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'

Line 123: hr_utility.trace('l_batch_id :'||l_batch_id);

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:

Line 150: hr_utility.trace('l_absence_category :'||l_absence_category);

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

Line 151: hr_utility.trace('l_element_name :'||l_element_name);

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

Line 168: hr_utility.trace('l_Certificate_required :'||l_Certificate_required);

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

Line 178: hr_utility.trace('AFTER l_Certificate_required :'||l_Certificate_required);

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

Line 194: hr_utility.trace('l_Certificate_received :'||l_Certificate_received);

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

Line 204: hr_utility.trace('l_Certificate_received :'||l_Certificate_received);

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

Line 219: hr_utility.trace('Out: ' || l_procedure_name) ;

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

Line 275: hr_utility.trace('In: ' || l_procedure_name) ;

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);

Line 278: hr_utility.trace('p_effective_date : '||p_effective_date);

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:

Line 279: hr_utility.trace('p_element_entry_id :'||p_element_entry_id);

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'

Line 280: hr_utility.trace('p_creator_type :'||p_creator_type);

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

Line 281: hr_utility.trace('p_creator_id :'||p_creator_id);

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:

Line 303: hr_utility.trace('Updating Start Date entry value as l_start_date :'||l_start_date);

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;

Line 313: hr_utility.trace('Updating End Date entry value as l_end_date :'||l_end_date);

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;

Line 323: hr_utility.trace('Updating Pay Date entry value as abs_information1 :'||l_abs_information1);

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;

Line 333: hr_utility.trace('Updating Start Advance Defer value as abs_information2 :'||l_abs_information2);

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;

Line 343: hr_utility.trace('Updating Advance Override entry value as abs_information3 :'||l_abs_information3);

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;