APPS.OZF_TIME_PVT dependencies on OZF_TIME_DAY

Line 302: FROM OZF_TIME_DAY

298: end if;
299:
300: -- first check if the current day is loaded
301: SELECT count(*) into l_count
302: FROM OZF_TIME_DAY
303: WHERE report_date = trunc(l_day);
304:
305: -- do an incremental update/insert
306: if l_count = 0 then -- new record, insert

Line 308: insert into OZF_TIME_DAY

304:
305: -- do an incremental update/insert
306: if l_count = 0 then -- new record, insert
307:
308: insert into OZF_TIME_DAY
309: (report_date,
310: report_date_julian,
311: start_date,
312: end_date,

Line 353: update OZF_TIME_DAY

349: l_day_row := l_day_row+1;
350:
351: else -- the day has been loaded, update those changed records only
352:
353: update OZF_TIME_DAY
354: set
355: ent_period_id = --l_period_year||l_quarter_num||lpad(l_period_num,2,'0'),
356: l_period_year||l_quarter_num||decode(length(l_period_num),1,'0'||l_period_num, l_period_num),
357: ent_period_start_date = l_start_date,

Line 436: truncate_table('OZF_TIME_DAY');

432: and day between start_date and end_date;
433:
434: begin
435:
436: truncate_table('OZF_TIME_DAY');
437:
438: -- ---------------------------------------------------------
439: -- Variable initialization
440: -- ---------------------------------------------------------

Line 458: insert into OZF_TIME_DAY

454: else
455: l_week_num := get_week_num(l_day,g_week_offset);
456: l_p445_num := get_period_num(l_week_num);
457: l_year_num := to_char(l_day-g_week_offset,'iyyy');
458: insert into OZF_TIME_DAY
459: (report_date,
460: report_date_julian,
461: start_date,
462: end_date,

Line 1005: from OZF_TIME_DAY;

1001: --* We should do a full refresh for OZF_TIME_RPT_STRUCT
1002: cursor c1 is
1003: select report_date, ent_period_start_date, ent_qtr_start_date,
1004: ent_year_start_date, week_start_date
1005: from OZF_TIME_DAY;
1006: --*this would be incorrect: where report_date between l_from_date and l_to_date
1007:
1008: begin
1009:

Line 1368: from ozf_time_day;

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
1371:
1372: select least(nvl(min(start_date),ozf_common_parameters_pvt.get_global_start_date) ,

Line 1375: from ozf_time_day;

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:
1378: return fnd_date.date_to_displaydt(l_return_date);
1379: