DBA Data[Home] [Help]

APPS.OZF_TIME_PVT dependencies on OZF_TIME_ENT_YEAR

Line 762: delete from OZF_TIME_ENT_YEAR where ent_year_id in

758: select nvl(max(end_date), l_to_date)
759: into l_end_date
760: from ozf_time_ent_period;
761:
762: delete from OZF_TIME_ENT_YEAR where ent_year_id in
763: (select period_year
764: from gl_periods
765: where period_set_name = g_period_set_name
766: and period_type = g_period_type

Line 774: insert into OZF_TIME_ENT_YEAR

770:
771: -- ----------------------
772: -- Populate Enterprise Year Level
773: -- ----------------------
774: insert into OZF_TIME_ENT_YEAR
775: (ent_year_id,
776: period_set_name,
777: period_type,
778: sequence,

Line 946: truncate_table('OZF_TIME_ENT_YEAR');

942: else
943: truncate_table('OZF_TIME_WEEK');
944: truncate_table('OZF_TIME_ENT_PERIOD');
945: truncate_table('OZF_TIME_ENT_QTR');
946: truncate_table('OZF_TIME_ENT_YEAR');
947: truncate_table('OZF_TIME_RPT_STRUCT');
948: if g_debug_flag = 'Y' then
949: OZF_TP_UTIL_PVT.put_line(' ');
950: end if;

Line 1305: from OZF_TIME_ENT_YEAR

1301: sysdate,
1302: g_user_id,
1303: g_user_id,
1304: g_login_id
1305: from OZF_TIME_ENT_YEAR
1306: where c1_rec.report_date between start_date and end_date;
1307:
1308: l_row := l_row + sql%rowcount;
1309: commit;

Line 1336: from OZF_TIME_ENT_YEAR

1332: sysdate,
1333: g_user_id,
1334: g_user_id,
1335: g_login_id
1336: from OZF_TIME_ENT_YEAR
1337: where end_date >= g_global_start_date -- should we use start_date?
1338: and end_date < c1_rec.report_date;
1339:
1340: l_row := l_row + sql%rowcount;