DBA Data[Home] [Help]

APPS.HRI_TIME_C dependencies on BIS_COMMON_PARAMETERS

Line 337: g_period_set_name := bis_common_parameters.get_period_set_name;

333: RAISE G_LOGIN_INFO_NOT_FOUND;
334: END IF;
335:
336: if (g_all_level = 'Y') then
337: g_period_set_name := bis_common_parameters.get_period_set_name;
338: g_period_type := bis_common_parameters.get_period_type;
339: if g_debug_flag = 'Y' then
340: hri_util.put_line('INIT : '||'Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
341: end if;

Line 338: g_period_type := bis_common_parameters.get_period_type;

334: END IF;
335:
336: if (g_all_level = 'Y') then
337: g_period_set_name := bis_common_parameters.get_period_set_name;
338: g_period_type := bis_common_parameters.get_period_type;
339: if g_debug_flag = 'Y' then
340: hri_util.put_line('INIT : '||'Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
341: end if;
342: g_week_start_day := bis_common_parameters.get_start_day_of_week_id;

Line 342: g_week_start_day := bis_common_parameters.get_start_day_of_week_id;

338: g_period_type := bis_common_parameters.get_period_type;
339: if g_debug_flag = 'Y' then
340: hri_util.put_line('INIT : '||'Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
341: end if;
342: g_week_start_day := bis_common_parameters.get_start_day_of_week_id;
343: if (g_period_set_name is null or g_period_type is null or g_week_start_day is null) then
344: raise G_BIS_PARAMETER_NOT_SETUP;
345: end if;
346:

Line 356: g_global_start_date := bis_common_parameters.get_GLOBAL_START_DATE;

352: hri_util.put_line('INIT : '||'Week offset = '||g_week_offset);
353: hri_util.put_line(' ');
354: end if;
355:
356: g_global_start_date := bis_common_parameters.get_GLOBAL_START_DATE;
357: if (g_global_start_date is null) then
358: raise G_BIS_PARAMETER_NOT_SETUP;
359: end if;
360: if g_debug_flag = 'Y' then

Line 2581: IF (NOT bis_common_parameters.check_global_parameters(l_global_param_list)) THEN

2577: -- If it returns false, then program should error out
2578: -----------------------------------------------------
2579: g_phase := 'Call BIS API to do common set ups';
2580: l_global_param_list(1) := 'BIS_GLOBAL_START_DATE';
2581: IF (NOT bis_common_parameters.check_global_parameters(l_global_param_list)) THEN
2582: retcode := 1;
2583: raise G_BIS_PARAMETER_NOT_SETUP;
2584: ELSIF (NOT BIS_COLLECTION_UTILITIES.setup('HRI_DBI_TIME_M')) THEN
2585: errbuf := sqlerrm;

Line 2593: g_phase := 'Retrieve the BIS common parameters';

2589: -- exception handler needs to know whether to perform a wrapup
2590: -- with error
2591: l_bis_setup := 'Y';
2592:
2593: g_phase := 'Retrieve the BIS common parameters';
2594: INIT;
2595:
2596: if g_all_level = 'Y' then
2597:

Line 4179: l_return_date := bis_common_parameters.get_global_start_date;

4175: ( bis_collection_utilities.get_last_refresh_period
4176: ('HRI_DBI_TIME_M')
4177: ) +1, fnd_date.displaydt_to_date(DEFAULT_LOAD_TO_DATE));
4178: else
4179: l_return_date := bis_common_parameters.get_global_start_date;
4180: end if;
4181: else
4182: select least(nvl(min(start_date),bis_common_parameters.get_global_start_date) , bis_common_parameters.get_global_start_date) into l_return_date
4183: from HRI_time_day;

Line 4182: select least(nvl(min(start_date),bis_common_parameters.get_global_start_date) , bis_common_parameters.get_global_start_date) into l_return_date

4178: else
4179: l_return_date := bis_common_parameters.get_global_start_date;
4180: end if;
4181: else
4182: select least(nvl(min(start_date),bis_common_parameters.get_global_start_date) , bis_common_parameters.get_global_start_date) into l_return_date
4183: from HRI_time_day;
4184: end if;
4185:
4186: return fnd_date.date_to_displaydt(l_return_date);

Line 4200: l_period_set_name varchar2(15) := bis_common_parameters.get_period_set_name;

4196: return varchar2
4197: is
4198:
4199: l_return_date date;
4200: l_period_set_name varchar2(15) := bis_common_parameters.get_period_set_name;
4201: l_period_type varchar2(15) := bis_common_parameters.get_period_type;
4202:
4203: begin
4204:

Line 4201: l_period_type varchar2(15) := bis_common_parameters.get_period_type;

4197: is
4198:
4199: l_return_date date;
4200: l_period_set_name varchar2(15) := bis_common_parameters.get_period_set_name;
4201: l_period_type varchar2(15) := bis_common_parameters.get_period_type;
4202:
4203: begin
4204:
4205: select max(end_date)