APPS.OZF_TIME_PVT dependencies on OZF_TIME_RPT_STRUCT

Line 947: truncate_table('OZF_TIME_RPT_STRUCT');

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;
951: end if;

Line 1001: --* We should do a full refresh for OZF_TIME_RPT_STRUCT

997: l_ptd_to_date date;
998: l_period_start_date date;
999: l_row number;
1000:
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;

Line 1010: truncate_table('OZF_TIME_RPT_STRUCT');

1006: --*this would be incorrect: where report_date between l_from_date and l_to_date
1007:
1008: begin
1009:
1010: truncate_table('OZF_TIME_RPT_STRUCT');
1011:
1012: l_row := 0;
1013: l_from_date := trunc(nvl(p_from_date,trunc(add_months(sysdate,-24),'YYYY')));
1014: l_to_date := trunc(nvl(p_to_date,trunc(sysdate,'YYYY')));

Line 1017: insert into OZF_TIME_RPT_STRUCT

1013: l_from_date := trunc(nvl(p_from_date,trunc(add_months(sysdate,-24),'YYYY')));
1014: l_to_date := trunc(nvl(p_to_date,trunc(sysdate,'YYYY')));
1015:
1016: FOR c1_rec IN c1 LOOP
1017: insert into OZF_TIME_RPT_STRUCT
1018: (calendar_id,
1019: calendar_type,
1020: report_date,
1021: time_id,

Line 1050: insert into OZF_TIME_RPT_STRUCT

1046:
1047: While l_day >= least(l_week_start_date,l_period_start_date) LOOP
1048: if l_day >= l_period_start_date then
1049: if l_day >= l_week_start_date then
1050: insert into OZF_TIME_RPT_STRUCT
1051: (calendar_id,
1052: calendar_type,
1053: report_date,
1054: time_id,

Line 1083: insert into OZF_TIME_RPT_STRUCT

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
1083: insert into OZF_TIME_RPT_STRUCT
1084: (calendar_id,
1085: calendar_type,
1086: report_date,
1087: time_id,

Line 1114: insert into OZF_TIME_RPT_STRUCT

1110: end if;
1111: end if;
1112: else
1113: if l_day >= l_week_start_date then
1114: insert into OZF_TIME_RPT_STRUCT
1115: (calendar_id,
1116: calendar_type,
1117: report_date,
1118: time_id,

Line 1150: insert into OZF_TIME_RPT_STRUCT

1146: END LOOP;
1147:
1148: commit;
1149:
1150: insert into OZF_TIME_RPT_STRUCT
1151: (calendar_id,
1152: calendar_type,
1153: report_date,
1154: time_id,

Line 1181: insert into OZF_TIME_RPT_STRUCT

1177:
1178: l_row := l_row + sql%rowcount;
1179: commit;
1180:
1181: insert into OZF_TIME_RPT_STRUCT
1182: (calendar_id,
1183: calendar_type,
1184: report_date,
1185: time_id,

Line 1231: insert into OZF_TIME_RPT_STRUCT

1227:
1228: l_row := l_row + sql%rowcount;
1229: commit;
1230:
1231: insert into OZF_TIME_RPT_STRUCT
1232: (calendar_id,
1233: calendar_type,
1234: report_date,
1235: time_id,

Line 1281: insert into OZF_TIME_RPT_STRUCT

1277:
1278: l_row := l_row + sql%rowcount;
1279: commit;
1280:
1281: insert into OZF_TIME_RPT_STRUCT
1282: (calendar_id,
1283: calendar_type,
1284: report_date,
1285: time_id,

Line 1312: insert into OZF_TIME_RPT_STRUCT

1308: l_row := l_row + sql%rowcount;
1309: commit;
1310:
1311: -- All prior years (report_type: 1024), for ITD
1312: insert into OZF_TIME_RPT_STRUCT
1313: (calendar_id,
1314: calendar_type,
1315: report_date,
1316: time_id,