DBA Data[Home] [Help]

APPS.OZF_TIME_PVT dependencies on OZF_COMMON_PARAMETERS_PVT

Line 195: g_period_set_name := ozf_common_parameters_pvt.get_period_set_name;

191: RAISE G_LOGIN_INFO_NOT_FOUND;
192: END IF;
193:
194: if (g_all_level = 'Y') then
195: g_period_set_name := ozf_common_parameters_pvt.get_period_set_name;
196: g_period_type := ozf_common_parameters_pvt.get_period_type;
197: if g_debug_flag = 'Y' then
198: OZF_TP_UTIL_PVT.put_line('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
199: end if;

Line 196: g_period_type := ozf_common_parameters_pvt.get_period_type;

192: END IF;
193:
194: if (g_all_level = 'Y') then
195: g_period_set_name := ozf_common_parameters_pvt.get_period_set_name;
196: g_period_type := ozf_common_parameters_pvt.get_period_type;
197: if g_debug_flag = 'Y' then
198: OZF_TP_UTIL_PVT.put_line('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
199: end if;
200: g_week_start_day := ozf_common_parameters_pvt.get_start_day_of_week_id;

Line 200: g_week_start_day := ozf_common_parameters_pvt.get_start_day_of_week_id;

196: g_period_type := ozf_common_parameters_pvt.get_period_type;
197: if g_debug_flag = 'Y' then
198: OZF_TP_UTIL_PVT.put_line('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
199: end if;
200: g_week_start_day := ozf_common_parameters_pvt.get_start_day_of_week_id;
201: if (g_period_set_name is null or g_period_type is null or g_week_start_day is null) then
202: raise G_OZF_PARAMETER_NOT_SETUP;
203: end if;
204: if g_debug_flag = 'Y' then

Line 215: g_global_start_date := ozf_common_parameters_pvt.GET_GLOBAL_START_DATE;

211: end if;
212:
213: -- g_global_start_date := to_date('01/01/1997','MM/DD/YYYY');
214:
215: g_global_start_date := ozf_common_parameters_pvt.GET_GLOBAL_START_DATE;
216: if (g_global_start_date is null) then
217: if g_debug_flag = 'Y' then
218: OZF_TP_UTIL_PVT.put_line('Global Start Date is not setup!');
219: end if;

Line 860: IF (NOT ozf_common_parameters_pvt.check_global_parameters(l_global_param_list)) THEN

856: g_phase := 'Call ozf common parameters api to do common set ups';
857: l_global_param_list(1) := 'OZF_TP_GLOBAL_START_DATE';
858:
859:
860: IF (NOT ozf_common_parameters_pvt.check_global_parameters(l_global_param_list)) THEN
861: if g_debug_flag = 'Y' then
862: OZF_TP_UTIL_PVT.put_line('Global Start Date has not been set up. ' ||
863: 'Program will exit with error status.');
864: end if;

Line 1365: select greatest(NVL(max(end_date)+1,ozf_common_parameters_pvt.get_global_start_date),

1361:
1362: begin
1363: if p_load_mode = 'INCRE' then
1364:
1365: select greatest(NVL(max(end_date)+1,ozf_common_parameters_pvt.get_global_start_date),
1366: ozf_common_parameters_pvt.get_global_start_date)
1367: into l_return_date
1368: from ozf_time_day;
1369:

Line 1366: ozf_common_parameters_pvt.get_global_start_date)

1362: begin
1363: if p_load_mode = 'INCRE' then
1364:
1365: select greatest(NVL(max(end_date)+1,ozf_common_parameters_pvt.get_global_start_date),
1366: ozf_common_parameters_pvt.get_global_start_date)
1367: into l_return_date
1368: from ozf_time_day;
1369:
1370: else

Line 1372: select least(nvl(min(start_date),ozf_common_parameters_pvt.get_global_start_date) ,

1368: from ozf_time_day;
1369:
1370: else
1371:
1372: select least(nvl(min(start_date),ozf_common_parameters_pvt.get_global_start_date) ,
1373: ozf_common_parameters_pvt.get_global_start_date)
1374: into l_return_date
1375: from ozf_time_day;
1376: end if;

Line 1373: ozf_common_parameters_pvt.get_global_start_date)

1369:
1370: else
1371:
1372: select least(nvl(min(start_date),ozf_common_parameters_pvt.get_global_start_date) ,
1373: ozf_common_parameters_pvt.get_global_start_date)
1374: into l_return_date
1375: from ozf_time_day;
1376: end if;
1377:

Line 1392: l_period_set_name varchar2(15) := ozf_common_parameters_pvt.get_period_set_name;

1388: return varchar2
1389: is
1390:
1391: l_return_date date;
1392: l_period_set_name varchar2(15) := ozf_common_parameters_pvt.get_period_set_name;
1393: l_period_type varchar2(15) := ozf_common_parameters_pvt.get_period_type;
1394:
1395: begin
1396:

Line 1393: l_period_type varchar2(15) := ozf_common_parameters_pvt.get_period_type;

1389: is
1390:
1391: l_return_date date;
1392: l_period_set_name varchar2(15) := ozf_common_parameters_pvt.get_period_set_name;
1393: l_period_type varchar2(15) := ozf_common_parameters_pvt.get_period_type;
1394:
1395: begin
1396:
1397: select max(end_date)