DBA Data[Home] [Help]

APPS.HRI_OLTP_CONC_DIM dependencies on HR_GENERAL

Line 23: l_end_date := fnd_date.date_to_displaydt(hr_general.end_of_time);

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

Line 192: ,p_period_from => hr_general.start_of_time

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:

Line 193: ,p_period_to => hr_general.end_of_time

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

Line 201: ,p_period_from => hr_general.start_of_time

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;

Line 202: ,p_period_to => hr_general.end_of_time

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:

Line 253: ,p_period_from => hr_general.start_of_time

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

Line 254: ,p_period_to => hr_general.end_of_time

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

Line 272: ,p_period_from => hr_general.start_of_time

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;

Line 273: ,p_period_to => hr_general.end_of_time

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:

Line 309: to_char(hr_general.start_of_time, 'YYYY/MM/DD HH24:MI:SS'),

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,

Line 314: 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,
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;

Line 323: ,p_period_from => hr_general.start_of_time

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

Line 324: ,p_period_to => hr_general.end_of_time

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:

Line 341: ,p_period_from => hr_general.start_of_time

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;

Line 342: ,p_period_to => hr_general.end_of_time

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:

Line 404: ,p_period_from => hr_general.start_of_time

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

Line 405: ,p_period_to => hr_general.end_of_time

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:

Line 412: ,p_period_from => hr_general.start_of_time

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;

Line 413: ,p_period_to => hr_general.end_of_time

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:

Line 467: ,p_period_from => hr_general.start_of_time

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

Line 475: ,p_period_from => hr_general.start_of_time

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;