DBA Data[Home] [Help]

APPS.HRI_OLTP_CONC_DIM dependencies on HRI_OLTP_CONC_PARAM

Line 19: l_full_refresh := hri_oltp_conc_param.get_parameter_value

15: l_full_refresh VARCHAR2(10);
16:
17: BEGIN
18:
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);

Line 27: l_start_date := hri_oltp_conc_param.get_parameter_value

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
28: (p_parameter_name => 'FULL_REFRESH_FROM_DATE',
29: p_process_table_name => 'HRI_CS_SUPH');
30: ELSE
31: l_start_date := fnd_date.date_to_canonical

Line 174: l_full_refresh := hri_oltp_conc_param.get_parameter_value

170: hri_bpl_conc_log.record_process_start('HRI_CS_JOBH_CT');
171:
172: -- If the full refresh parameter is not provided, default it
173: IF (p_full_refresh IS NULL) THEN
174: l_full_refresh := hri_oltp_conc_param.get_parameter_value
175: (p_parameter_name => 'FULL_REFRESH',
176: p_process_table_name => 'HRI_CS_JOBH_CT');
177: ELSE
178: l_full_refresh := p_full_refresh;

Line 223: l_full_refresh := hri_oltp_conc_param.get_parameter_value

219: hri_bpl_conc_log.record_process_start('HRI_CS_PRSNTYP_CT');
220:
221: -- If the full refresh parameter is not provided, default it
222: IF (p_full_refresh IS NULL) THEN
223: l_full_refresh := hri_oltp_conc_param.get_parameter_value
224: (p_parameter_name => 'FULL_REFRESH',
225: p_process_table_name => 'HRI_CS_PRSNTYP_CT');
226: ELSE
227: l_full_refresh := p_full_refresh;

Line 296: l_full_refresh := hri_oltp_conc_param.get_parameter_value

292: hri_bpl_conc_log.record_process_start('HRI_CS_PER_PERSON_CT');
293:
294: -- If the full refresh parameter is not provided, default it
295: IF (p_full_refresh IS NULL) THEN
296: l_full_refresh := hri_oltp_conc_param.get_parameter_value
297: (p_parameter_name => 'FULL_REFRESH',
298: p_process_table_name => 'HRI_CS_PER_PERSON_CT');
299: ELSE
300: l_full_refresh := p_full_refresh;

Line 367: l_full_refresh := hri_oltp_conc_param.get_parameter_value

363: hri_bpl_conc_log.record_process_start('HRI_CS_POW_BAND_CT');
364:
365: -- If the full refresh parameter is not provided, default it
366: IF (p_full_refresh IS NULL) THEN
367: l_full_refresh := hri_oltp_conc_param.get_parameter_value
368: (p_parameter_name => 'FULL_REFRESH',
369: p_process_table_name => 'HRI_CS_POW_BAND_CT');
370: ELSE
371: l_full_refresh := p_full_refresh;

Line 439: l_full_refresh := hri_oltp_conc_param.get_parameter_value

435: hri_bpl_conc_log.record_process_start('HRI_CS_JOB_JOB_ROLE_CT');
436:
437: -- If the full refresh parameter is not provided, default it
438: IF (p_full_refresh IS NULL) THEN
439: l_full_refresh := hri_oltp_conc_param.get_parameter_value
440: (p_parameter_name => 'FULL_REFRESH',
441: p_process_table_name => 'HRI_CS_JOB_JOB_ROLE_CT');
442: ELSE
443: l_full_refresh := p_full_refresh;