19: l_full_refresh := hri_oltp_conc_param.get_parameter_value
20: (p_parameter_name => 'FULL_REFRESH',
21: p_process_table_name => 'HRI_CS_SUPH');
22:
23: l_end_date := fnd_date.date_to_displaydt(hr_general.end_of_time);
24:
25: -- Set the refresh start date for full refresh
26: IF (l_full_refresh = 'Y') THEN
27: l_start_date := hri_oltp_conc_param.get_parameter_value
188: END IF;
189:
190: hri_bpl_conc_log.log_process_end
191: (p_status => TRUE
192: ,p_period_from => hr_general.start_of_time
193: ,p_period_to => hr_general.end_of_time
194: ,p_attribute1 => p_full_refresh
195: );
196:
189:
190: hri_bpl_conc_log.log_process_end
191: (p_status => TRUE
192: ,p_period_from => hr_general.start_of_time
193: ,p_period_to => hr_general.end_of_time
194: ,p_attribute1 => p_full_refresh
195: );
196:
197: EXCEPTION WHEN OTHERS THEN
197: EXCEPTION WHEN OTHERS THEN
198:
199: hri_bpl_conc_log.log_process_end
200: (p_status => FALSE
201: ,p_period_from => hr_general.start_of_time
202: ,p_period_to => hr_general.end_of_time
203: ,p_attribute1 => p_full_refresh);
204:
205: END load_all_jobs;
198:
199: hri_bpl_conc_log.log_process_end
200: (p_status => FALSE
201: ,p_period_from => hr_general.start_of_time
202: ,p_period_to => hr_general.end_of_time
203: ,p_attribute1 => p_full_refresh);
204:
205: END load_all_jobs;
206:
249:
250: -- Log process end
251: hri_bpl_conc_log.log_process_end
252: (p_status => TRUE
253: ,p_period_from => hr_general.start_of_time
254: ,p_period_to => hr_general.end_of_time
255: ,p_attribute1 => 'N');
256:
257: -- Bug 4105868: Collection Diagnostics
250: -- Log process end
251: hri_bpl_conc_log.log_process_end
252: (p_status => TRUE
253: ,p_period_from => hr_general.start_of_time
254: ,p_period_to => hr_general.end_of_time
255: ,p_attribute1 => 'N');
256:
257: -- Bug 4105868: Collection Diagnostics
258: EXCEPTION WHEN OTHERS THEN
268: ,p_note => SQLERRM);
269:
270: hri_bpl_conc_log.log_process_end
271: (p_status => FALSE
272: ,p_period_from => hr_general.start_of_time
273: ,p_period_to => hr_general.end_of_time
274: ,p_attribute1 => 'N');
275:
276: RAISE;
269:
270: hri_bpl_conc_log.log_process_end
271: (p_status => FALSE
272: ,p_period_from => hr_general.start_of_time
273: ,p_period_to => hr_general.end_of_time
274: ,p_attribute1 => 'N');
275:
276: RAISE;
277:
305:
306: -- Call the appropriate function depending on full refresh parameter
307: IF (l_full_refresh = 'Y') THEN
308: hri_opl_per_person.load(1500,
309: to_char(hr_general.start_of_time, 'YYYY/MM/DD HH24:MI:SS'),
310: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
311: ,'Y');
312: ELSE
313: hri_opl_per_person.load(1500,
310: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
311: ,'Y');
312: ELSE
313: hri_opl_per_person.load(1500,
314: to_char(hr_general.start_of_time, 'YYYY/MM/DD HH24:MI:SS'),
315: to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS')
316: ,'N');
317:
318: END IF;
319:
320: -- Log process end
321: hri_bpl_conc_log.log_process_end
322: (p_status => TRUE
323: ,p_period_from => hr_general.start_of_time
324: ,p_period_to => hr_general.end_of_time
325: ,p_attribute1 => 'N');
326:
327: EXCEPTION WHEN OTHERS THEN
320: -- Log process end
321: hri_bpl_conc_log.log_process_end
322: (p_status => TRUE
323: ,p_period_from => hr_general.start_of_time
324: ,p_period_to => hr_general.end_of_time
325: ,p_attribute1 => 'N');
326:
327: EXCEPTION WHEN OTHERS THEN
328:
337: ,p_note => SQLERRM);
338:
339: hri_bpl_conc_log.log_process_end
340: (p_status => FALSE
341: ,p_period_from => hr_general.start_of_time
342: ,p_period_to => hr_general.end_of_time
343: ,p_attribute1 => 'N');
344:
345: RAISE;
338:
339: hri_bpl_conc_log.log_process_end
340: (p_status => FALSE
341: ,p_period_from => hr_general.start_of_time
342: ,p_period_to => hr_general.end_of_time
343: ,p_attribute1 => 'N');
344:
345: RAISE;
346:
400:
401: -- Log process end
402: hri_bpl_conc_log.log_process_end
403: (p_status => TRUE
404: ,p_period_from => hr_general.start_of_time
405: ,p_period_to => hr_general.end_of_time
406: ,p_attribute1 => 'N');
407:
408: EXCEPTION WHEN OTHERS THEN
401: -- Log process end
402: hri_bpl_conc_log.log_process_end
403: (p_status => TRUE
404: ,p_period_from => hr_general.start_of_time
405: ,p_period_to => hr_general.end_of_time
406: ,p_attribute1 => 'N');
407:
408: EXCEPTION WHEN OTHERS THEN
409:
408: EXCEPTION WHEN OTHERS THEN
409:
410: hri_bpl_conc_log.log_process_end
411: (p_status => FALSE
412: ,p_period_from => hr_general.start_of_time
413: ,p_period_to => hr_general.end_of_time
414: ,p_attribute1 => 'N');
415:
416: RAISE;
409:
410: hri_bpl_conc_log.log_process_end
411: (p_status => FALSE
412: ,p_period_from => hr_general.start_of_time
413: ,p_period_to => hr_general.end_of_time
414: ,p_attribute1 => 'N');
415:
416: RAISE;
417:
463:
464: -- Log process end
465: hri_bpl_conc_log.log_process_end
466: (p_status => TRUE
467: ,p_period_from => hr_general.start_of_time
468: ,p_period_to => SYSDATE
469: ,p_attribute1 => 'N');
470:
471: EXCEPTION WHEN OTHERS THEN
471: EXCEPTION WHEN OTHERS THEN
472:
473: hri_bpl_conc_log.log_process_end
474: (p_status => FALSE
475: ,p_period_from => hr_general.start_of_time
476: ,p_period_to => SYSDATE
477: ,p_attribute1 => 'N');
478:
479: RAISE;