APPS.OZF_TIME_PVT dependencies on OZF_TIME_WEEK

Line 549: delete from OZF_TIME_WEEK where start_date <= l_to_date and end_date >= l_from_date;

545: l_period_num := get_period_num(l_week_num);
546: l_year_num := to_char(l_week-g_week_offset,'iyyy');
547: l_week_row := 0;
548:
549: delete from OZF_TIME_WEEK where start_date <= l_to_date and end_date >= l_from_date;
550:
551: -- ----------------------
552: -- Populate Week Level
553: -- ----------------------

Line 555: insert into OZF_TIME_WEEK

551: -- ----------------------
552: -- Populate Week Level
553: -- ----------------------
554: while l_week <= l_to_date loop
555: insert into OZF_TIME_WEEK
556: (week_id,
557: period445_id,
558: sequence,
559: name,

Line 943: truncate_table('OZF_TIME_WEEK');

939: end if;
940:
941:
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');

Line 1078: select nvl(min(start_date),l_week_start_date) into l_ptd_to_date from OZF_TIME_WEEK

1074:
1075: l_row := l_row + sql%rowcount;
1076:
1077: else
1078: select nvl(min(start_date),l_week_start_date) into l_ptd_to_date from OZF_TIME_WEEK
1079: where start_date >= l_period_start_date
1080: and start_date < l_week_start_date;
1081:
1082: if l_day < l_ptd_to_date then

Line 1174: from OZF_TIME_WEEK

1170: sysdate,
1171: g_user_id,
1172: g_user_id,
1173: g_login_id
1174: from OZF_TIME_WEEK
1175: where start_date >= c1_rec.ent_period_start_date
1176: and end_date < c1_rec.week_start_date;
1177:
1178: l_row := l_row + sql%rowcount;