eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_MSC_OBJECTS_C dependencies on FII_UTIL

Line 191: FII_UTIL.Start_Timer;

187: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_apps_instances';
188: EXECUTE IMMEDIATE l_trunc_stmt;
189:
190: BIS_COLLECTION_UTILITIES.put_line('Begin to collect instance information');
191: FII_UTIL.Start_Timer;
192:
193: l_stmt := 'INSERT INTO isc_dbi_apps_instances (' ||
194: ' instance_id, currency, instance_code, ' ||
195: ' m2a_dblink, a2m_dblink, created_by, creation_date, '||

Line 211: FII_UTIL.Stop_Timer;

207: g_errbuf := 'No corresponding source instance defined in the APS instance.';
208: RETURN (-1);
209: END IF;
210:
211: FII_UTIL.Stop_Timer;
212: FII_UTIL.Print_Timer('Collected instance information in');
213: BIS_COLLECTION_UTILITIES.Put_Line(' ');
214:
215: /* From DBI7.0, functional and DBI global currencies will be used. */

Line 212: FII_UTIL.Print_Timer('Collected instance information in');

208: RETURN (-1);
209: END IF;
210:
211: FII_UTIL.Stop_Timer;
212: FII_UTIL.Print_Timer('Collected instance information in');
213: BIS_COLLECTION_UTILITIES.Put_Line(' ');
214:
215: /* From DBI7.0, functional and DBI global currencies will be used. */
216:

Line 218: -- FII_UTIL.Start_Timer;

214:
215: /* From DBI7.0, functional and DBI global currencies will be used. */
216:
217: -- BIS_COLLECTION_UTILITIES.put_line('Begin to validate APS currency.');
218: -- FII_UTIL.Start_Timer;
219: --
220: -- SELECT count(*)
221: -- INTO l_currency
222: -- FROM isc_dbi_apps_instances i, fnd_currencies cur

Line 235: -- FII_UTIL.Stop_Timer;

231: -- BIS_COLLECTION_UTILITIES.Put_Line_Out(fnd_message.get_string('ISC', 'ISC_DBI_INVALID_CURRENCY'));
232: -- BIS_COLLECTION_UTILITIES.Put_Line_Out(' ');
233: -- END IF;
234: --
235: -- FII_UTIL.Stop_Timer;
236: -- FII_UTIL.Print_Timer('Validated the planning currency in');
237: -- BIS_COLLECTION_UTILITIES.Put_Line(' ');
238:
239:

Line 236: -- FII_UTIL.Print_Timer('Validated the planning currency in');

232: -- BIS_COLLECTION_UTILITIES.Put_Line_Out(' ');
233: -- END IF;
234: --
235: -- FII_UTIL.Stop_Timer;
236: -- FII_UTIL.Print_Timer('Validated the planning currency in');
237: -- BIS_COLLECTION_UTILITIES.Put_Line(' ');
238:
239:
240: RETURN(1);

Line 274: FII_UTIL.Start_Timer;

270: -- Insert the plans need to be collected into ISC_DBI_TMP_PLANS
271: -- ------------------------------------------------------------
272:
273: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp table');
274: FII_UTIL.Start_Timer;
275:
276: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
277: EXECUTE IMMEDIATE l_trunc_stmt;
278:

Line 279: FII_UTIL.Stop_Timer;

275:
276: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
277: EXECUTE IMMEDIATE l_trunc_stmt;
278:
279: FII_UTIL.Stop_Timer;
280: FII_UTIL.Print_Timer('Truncated the temp table in');
281: BIS_COLLECTION_UTILITIES.Put_Line(' ');
282:
283: g_snapshot_date := sysdate;

Line 280: FII_UTIL.Print_Timer('Truncated the temp table in');

276: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
277: EXECUTE IMMEDIATE l_trunc_stmt;
278:
279: FII_UTIL.Stop_Timer;
280: FII_UTIL.Print_Timer('Truncated the temp table in');
281: BIS_COLLECTION_UTILITIES.Put_Line(' ');
282:
283: g_snapshot_date := sysdate;
284: BIS_COLLECTION_UTILITIES.put_line('The snapshot date is '|| to_char(g_snapshot_date, 'MM/DD/YYYY HH24:MI:SS'));

Line 287: FII_UTIL.Start_Timer;

283: g_snapshot_date := sysdate;
284: BIS_COLLECTION_UTILITIES.put_line('The snapshot date is '|| to_char(g_snapshot_date, 'MM/DD/YYYY HH24:MI:SS'));
285:
286: BIS_COLLECTION_UTILITIES.put_line('Begin to load into the temp table.');
287: FII_UTIL.Start_Timer;
288:
289: l_stmt := 'INSERT INTO isc_dbi_tmp_plans (' ||
290: 'PLAN_ID, PLAN_NAME, OLD_DATA_START_DATE, DATA_START_DATE, ' ||
291: 'INSTANCE_ID, PLAN_USAGE) ' ||

Line 316: FII_UTIL.Stop_Timer;

312: EXECUTE IMMEDIATE l_stmt;
313: l_count := SQL%ROWCOUNT;
314: COMMIT;
315:
316: FII_UTIL.Stop_Timer;
317: FII_UTIL.Print_Timer('Retrieved '|| l_count || ' plans from setup tables in');
318: BIS_COLLECTION_UTILITIES.Put_Line(' ');
319:
320: BIS_COLLECTION_UTILITIES.Put_Line(' ');

Line 317: FII_UTIL.Print_Timer('Retrieved '|| l_count || ' plans from setup tables in');

313: l_count := SQL%ROWCOUNT;
314: COMMIT;
315:
316: FII_UTIL.Stop_Timer;
317: FII_UTIL.Print_Timer('Retrieved '|| l_count || ' plans from setup tables in');
318: BIS_COLLECTION_UTILITIES.Put_Line(' ');
319:
320: BIS_COLLECTION_UTILITIES.Put_Line(' ');
321: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_DBI_TMP_PLANS');

Line 322: FII_UTIL.Start_Timer;

318: BIS_COLLECTION_UTILITIES.Put_Line(' ');
319:
320: BIS_COLLECTION_UTILITIES.Put_Line(' ');
321: BIS_COLLECTION_UTILITIES.Put_Line('Analyzing table ISC_DBI_TMP_PLANS');
322: FII_UTIL.Start_Timer;
323:
324: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
325: TABNAME => 'ISC_DBI_TMP_PLANS');
326:

Line 327: FII_UTIL.Stop_Timer;

323:
324: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
325: TABNAME => 'ISC_DBI_TMP_PLANS');
326:
327: FII_UTIL.Stop_Timer;
328: FII_UTIL.Print_Timer('Analyzed table ISC_DBI_TMP_PLANS in ');
329:
330: -- Clean up the obsolete planned data
331:

Line 328: FII_UTIL.Print_Timer('Analyzed table ISC_DBI_TMP_PLANS in ');

324: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
325: TABNAME => 'ISC_DBI_TMP_PLANS');
326:
327: FII_UTIL.Stop_Timer;
328: FII_UTIL.Print_Timer('Analyzed table ISC_DBI_TMP_PLANS in ');
329:
330: -- Clean up the obsolete planned data
331:
332: l_count := 0;

Line 420: FII_UTIL.Start_Timer;

416: EXECUTE IMMEDIATE l_trunc_stmt;
417: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_periods has been truncated.');
418:
419: BIS_COLLECTION_UTILITIES.put_line('Begin to load the base tables from APS instance.');
420: FII_UTIL.Start_Timer;
421:
422: l_insert_stmt := 'INSERT /*+ APPEND PARALLEL */ FIRST '||
423: 'WHEN union_flag = 1 THEN '||
424: 'INTO isc_dbi_plans ( ' ||

Line 923: FII_UTIL.Stop_Timer;

919: EXECUTE IMMEDIATE (l_insert_stmt || l_sel_stmt1 || l_sel_stmt2);
920: l_count := l_count + sql%rowcount;
921: COMMIT;
922:
923: FII_UTIL.Stop_Timer;
924: FII_UTIL.Print_Timer('Loaded the base tables in');
925: BIS_COLLECTION_UTILITIES.Put_Line(' ');
926:
927: UPDATE isc_dbi_tmp_plans tmp SET constrained_flag = (select constrained_flag from isc_dbi_plans p where p.plan_id = tmp.plan_id);

Line 924: FII_UTIL.Print_Timer('Loaded the base tables in');

920: l_count := l_count + sql%rowcount;
921: COMMIT;
922:
923: FII_UTIL.Stop_Timer;
924: FII_UTIL.Print_Timer('Loaded the base tables in');
925: BIS_COLLECTION_UTILITIES.Put_Line(' ');
926:
927: UPDATE isc_dbi_tmp_plans tmp SET constrained_flag = (select constrained_flag from isc_dbi_plans p where p.plan_id = tmp.plan_id);
928: COMMIT;

Line 930: FII_UTIL.Start_Timer;

926:
927: UPDATE isc_dbi_tmp_plans tmp SET constrained_flag = (select constrained_flag from isc_dbi_plans p where p.plan_id = tmp.plan_id);
928: COMMIT;
929:
930: FII_UTIL.Start_Timer;
931:
932: FOR i in 1..g_small_bases.last LOOP
933: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema, TABNAME => g_small_bases(i));
934: END LOOP;

Line 943: FII_UTIL.Stop_Timer;

939:
940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
941: TABNAME => 'ISC_DBI_PERIODS');
942:
943: FII_UTIL.Stop_Timer;
944: FII_UTIL.Print_Timer('Analyzed the base tables in');
945:
946: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_plan_curr_rates';
947: EXECUTE IMMEDIATE l_trunc_stmt;

Line 944: FII_UTIL.Print_Timer('Analyzed the base tables in');

940: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
941: TABNAME => 'ISC_DBI_PERIODS');
942:
943: FII_UTIL.Stop_Timer;
944: FII_UTIL.Print_Timer('Analyzed the base tables in');
945:
946: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_plan_curr_rates';
947: EXECUTE IMMEDIATE l_trunc_stmt;
948: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_plan_curr_rates has been truncated.');

Line 951: FII_UTIL.Start_Timer;

947: EXECUTE IMMEDIATE l_trunc_stmt;
948: BIS_COLLECTION_UTILITIES.put_line('Table isc_dbi_plan_curr_rates has been truncated.');
949:
950: BIS_COLLECTION_UTILITIES.put_line('Begin to retrieve the currency conversion rates.');
951: FII_UTIL.Start_Timer;
952:
953: INSERT INTO isc_dbi_plan_curr_rates(
954: ORGANIZATION_ID,
955: FROM_CURRENCY,

Line 975: FII_UTIL.Stop_Timer;

971: WHERE hoi.org_information_context ='Accounting Information'
972: AND hoi.organization_id = org.organization_id
973: AND hoi.org_information1 = to_char(gsb.set_of_books_id);
974:
975: FII_UTIL.Stop_Timer;
976: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');
977: COMMIT;
978:
979: FII_UTIL.Start_Timer;

Line 976: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');

972: AND hoi.organization_id = org.organization_id
973: AND hoi.org_information1 = to_char(gsb.set_of_books_id);
974:
975: FII_UTIL.Stop_Timer;
976: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');
977: COMMIT;
978:
979: FII_UTIL.Start_Timer;
980:

Line 979: FII_UTIL.Start_Timer;

975: FII_UTIL.Stop_Timer;
976: FII_UTIL.Print_Timer('Retrieved '||sql%rowcount||' currency rates in');
977: COMMIT;
978:
979: FII_UTIL.Start_Timer;
980:
981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:

Line 984: FII_UTIL.Stop_Timer;

980:
981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:
984: FII_UTIL.Stop_Timer;
985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');
986:
987: RETURN(l_count);
988:

Line 985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');

981: FND_STATS.GATHER_TABLE_STATS(OWNNAME => g_isc_schema,
982: TABNAME => 'ISC_DBI_PLAN_CURR_RATES');
983:
984: FII_UTIL.Stop_Timer;
985: FII_UTIL.Print_Timer('Analyzed ISC_DBI_PLAN_CURR_RATES in');
986:
987: RETURN(l_count);
988:
989: EXCEPTION

Line 1008: FII_UTIL.Start_Timer;

1004: l_is_missing BOOLEAN := TRUE;
1005:
1006: BEGIN
1007:
1008: FII_UTIL.Start_Timer;
1009:
1010: SELECT min(p.data_start_date),max(p.cutoff_date)
1011: INTO l_min, l_max
1012: FROM isc_dbi_plans p, isc_dbi_tmp_plans tmp

Line 1015: FII_UTIL.Stop_Timer;

1011: INTO l_min, l_max
1012: FROM isc_dbi_plans p, isc_dbi_tmp_plans tmp
1013: WHERE p.plan_id = tmp.plan_id;
1014:
1015: FII_UTIL.Stop_Timer;
1016: FII_UTIL.Print_Timer('Retrieved the min and max date in ');
1017:
1018: FII_UTIL.Start_Timer;
1019:

Line 1016: FII_UTIL.Print_Timer('Retrieved the min and max date in ');

1012: FROM isc_dbi_plans p, isc_dbi_tmp_plans tmp
1013: WHERE p.plan_id = tmp.plan_id;
1014:
1015: FII_UTIL.Stop_Timer;
1016: FII_UTIL.Print_Timer('Retrieved the min and max date in ');
1017:
1018: FII_UTIL.Start_Timer;
1019:
1020: BIS_COLLECTION_UTILITIES.Put_Line_Out(' ');

Line 1018: FII_UTIL.Start_Timer;

1014:
1015: FII_UTIL.Stop_Timer;
1016: FII_UTIL.Print_Timer('Retrieved the min and max date in ');
1017:
1018: FII_UTIL.Start_Timer;
1019:
1020: BIS_COLLECTION_UTILITIES.Put_Line_Out(' ');
1021: BIS_COLLECTION_UTILITIES.Put_Line_Out(' ');
1022:

Line 1038: FII_UTIL.Stop_Timer;

1034: BIS_COLLECTION_UTILITIES.Put_Line(' ');
1035: END IF;
1036: END IF;
1037:
1038: FII_UTIL.Stop_Timer;
1039: FII_UTIL.Print_Timer('Completed time continuity check in');
1040:
1041: RETURN(1);
1042:

Line 1039: FII_UTIL.Print_Timer('Completed time continuity check in');

1035: END IF;
1036: END IF;
1037:
1038: FII_UTIL.Stop_Timer;
1039: FII_UTIL.Print_Timer('Completed time continuity check in');
1040:
1041: RETURN(1);
1042:
1043: EXCEPTION

Line 1217: FII_UTIL.Start_Timer;

1213: -- ----------------------------------------------------------
1214:
1215: BIS_COLLECTION_UTILITIES.put_line(' ');
1216: BIS_COLLECTION_UTILITIES.put_line('Identifying the missing currency conversion rates');
1217: FII_UTIL.Start_Timer;
1218:
1219: l_miss_conv := REPORT_MISSING_RATE;
1220:
1221: FII_UTIL.Stop_Timer;

Line 1221: FII_UTIL.Stop_Timer;

1217: FII_UTIL.Start_Timer;
1218:
1219: l_miss_conv := REPORT_MISSING_RATE;
1220:
1221: FII_UTIL.Stop_Timer;
1222: FII_UTIL.Print_Timer('Completed missing currency check in');
1223:
1224: IF (l_miss_conv = -1) THEN
1225: return(-1);

Line 1222: FII_UTIL.Print_Timer('Completed missing currency check in');

1218:
1219: l_miss_conv := REPORT_MISSING_RATE;
1220:
1221: FII_UTIL.Stop_Timer;
1222: FII_UTIL.Print_Timer('Completed missing currency check in');
1223:
1224: IF (l_miss_conv = -1) THEN
1225: return(-1);
1226: ELSIF (l_miss_conv > 0) THEN

Line 1254: FII_UTIL.Start_Timer;

1250:
1251: BIS_COLLECTION_UTILITIES.put_line(' ');
1252: BIS_COLLECTION_UTILITIES.put_line('Identifying the dangling items');
1253:
1254: FII_UTIL.Start_Timer;
1255:
1256: l_item_count := IDENTIFY_DANGLING_ITEM;
1257:
1258: FII_UTIL.Stop_Timer;

Line 1258: FII_UTIL.Stop_Timer;

1254: FII_UTIL.Start_Timer;
1255:
1256: l_item_count := IDENTIFY_DANGLING_ITEM;
1257:
1258: FII_UTIL.Stop_Timer;
1259: FII_UTIL.Print_Timer('Identified '||l_item_count||' dangling items in');
1260:
1261: IF (l_item_count = -1) THEN
1262: return(-1);

Line 1259: FII_UTIL.Print_Timer('Identified '||l_item_count||' dangling items in');

1255:
1256: l_item_count := IDENTIFY_DANGLING_ITEM;
1257:
1258: FII_UTIL.Stop_Timer;
1259: FII_UTIL.Print_Timer('Identified '||l_item_count||' dangling items in');
1260:
1261: IF (l_item_count = -1) THEN
1262: return(-1);
1263: ELSIF (l_item_count > 0) THEN

Line 1320: FII_UTIL.Stop_Timer;

1316: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.'|| g_small_bases(i);
1317: EXECUTE IMMEDIATE l_trunc_stmt;
1318: END LOOP;
1319:
1320: FII_UTIL.Stop_Timer;
1321: FII_UTIL.Print_Timer('Truncate the base tables in');
1322:
1323: -- --------------------------------------------
1324: -- Clean Up the Last Collected Date

Line 1321: FII_UTIL.Print_Timer('Truncate the base tables in');

1317: EXECUTE IMMEDIATE l_trunc_stmt;
1318: END LOOP;
1319:
1320: FII_UTIL.Stop_Timer;
1321: FII_UTIL.Print_Timer('Truncate the base tables in');
1322:
1323: -- --------------------------------------------
1324: -- Clean Up the Last Collected Date
1325: -- --------------------------------------------

Line 1489: FII_UTIL.Start_Timer;

1485:
1486: BEGIN
1487:
1488: l_count := 0;
1489: FII_UTIL.Start_Timer;
1490:
1491: OPEN Delete_List;
1492: FETCH Delete_List INTO l_delete_id;
1493: IF Delete_List%ROWCOUNT <> 0 THEN

Line 1501: FII_UTIL.Stop_Timer;

1497: FETCH Delete_List INTO l_delete_id;
1498: END LOOP;
1499: END IF;
1500:
1501: FII_UTIL.Stop_Timer;
1502: FII_UTIL.Print_Timer('Dropped '|| Delete_List%ROWCOUNT ||' duplicate snapshots in');
1503: CLOSE Delete_List;
1504:
1505: IF (g_rebuild_snapshot_index = 'Y') THEN

Line 1502: FII_UTIL.Print_Timer('Dropped '|| Delete_List%ROWCOUNT ||' duplicate snapshots in');

1498: END LOOP;
1499: END IF;
1500:
1501: FII_UTIL.Stop_Timer;
1502: FII_UTIL.Print_Timer('Dropped '|| Delete_List%ROWCOUNT ||' duplicate snapshots in');
1503: CLOSE Delete_List;
1504:
1505: IF (g_rebuild_snapshot_index = 'Y') THEN
1506:

Line 1512: FII_UTIL.Start_Timer;

1508: OPEN Get_Index_Lists(g_large_snapshots(j), g_isc_schema);
1509: FETCH Get_Index_Lists INTO l_index_name;
1510: IF Get_Index_Lists%ROWCOUNT <> 0 THEN
1511: WHILE Get_Index_Lists%Found LOOP
1512: FII_UTIL.Start_Timer;
1513: l_rebuild_index_stmt := 'ALTER INDEX '|| g_isc_schema || '.' || l_index_name || ' REBUILD';
1514: EXECUTE IMMEDIATE l_rebuild_index_stmt;
1515: FII_UTIL.Stop_Timer;
1516: FII_UTIL.Print_Timer('Rebuilt index '|| l_index_name || ' in');

Line 1515: FII_UTIL.Stop_Timer;

1511: WHILE Get_Index_Lists%Found LOOP
1512: FII_UTIL.Start_Timer;
1513: l_rebuild_index_stmt := 'ALTER INDEX '|| g_isc_schema || '.' || l_index_name || ' REBUILD';
1514: EXECUTE IMMEDIATE l_rebuild_index_stmt;
1515: FII_UTIL.Stop_Timer;
1516: FII_UTIL.Print_Timer('Rebuilt index '|| l_index_name || ' in');
1517: FETCH Get_Index_Lists INTO l_index_name;
1518: END LOOP;
1519: END IF;

Line 1516: FII_UTIL.Print_Timer('Rebuilt index '|| l_index_name || ' in');

1512: FII_UTIL.Start_Timer;
1513: l_rebuild_index_stmt := 'ALTER INDEX '|| g_isc_schema || '.' || l_index_name || ' REBUILD';
1514: EXECUTE IMMEDIATE l_rebuild_index_stmt;
1515: FII_UTIL.Stop_Timer;
1516: FII_UTIL.Print_Timer('Rebuilt index '|| l_index_name || ' in');
1517: FETCH Get_Index_Lists INTO l_index_name;
1518: END LOOP;
1519: END IF;
1520: CLOSE Get_Index_Lists;

Line 1538: FII_UTIL.Start_Timer;

1534: -- --------------
1535: -- Add Partitions
1536: -- --------------
1537:
1538: FII_UTIL.Start_Timer;
1539:
1540: OPEN Snapshot_List;
1541: FETCH Snapshot_List INTO l_add_snapshot_id;
1542: IF Snapshot_List%ROWCOUNT <> 0 THEN

Line 1561: FII_UTIL.Stop_Timer;

1557: END LOOP;
1558: FETCH Snapshot_List INTO l_add_snapshot_id;
1559: END LOOP;
1560: END IF;
1561: FII_UTIL.Stop_Timer;
1562: FII_UTIL.Print_Timer('Added '|| Snapshot_List%ROWCOUNT ||' partitions in');
1563: CLOSE Snapshot_List;
1564:
1565: -- ----------------------------------

Line 1562: FII_UTIL.Print_Timer('Added '|| Snapshot_List%ROWCOUNT ||' partitions in');

1558: FETCH Snapshot_List INTO l_add_snapshot_id;
1559: END LOOP;
1560: END IF;
1561: FII_UTIL.Stop_Timer;
1562: FII_UTIL.Print_Timer('Added '|| Snapshot_List%ROWCOUNT ||' partitions in');
1563: CLOSE Snapshot_List;
1564:
1565: -- ----------------------------------
1566: -- Collect ISC_DBI_PLAN_SNAPSHOTS

Line 1571: FII_UTIL.Start_Timer;

1567: -- ----------------------------------
1568:
1569: BIS_COLLECTION_UTILITIES.put_line(' ');
1570: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_snapshots.');
1571: FII_UTIL.Start_Timer;
1572:
1573: INSERT
1574: INTO isc_dbi_plan_snapshots F(
1575: SNAPSHOT_ID,

Line 1598: FII_UTIL.Stop_Timer;

1594: AND ip.plan_id = ipo.plan_id
1595: GROUP BY tmp.snapshot_id, ip.plan_id, ip.organization_id, ip.compile_designator, ip.constrained_flag, ip.curr_plan_type,
1596: ip.cutoff_date, ip.data_start_date, ip.description;
1597:
1598: FII_UTIL.Stop_Timer;
1599: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_snapshots in');
1600: -- COMMIT;
1601:
1602: -- ----------------------------------

Line 1599: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_snapshots in');

1595: GROUP BY tmp.snapshot_id, ip.plan_id, ip.organization_id, ip.compile_designator, ip.constrained_flag, ip.curr_plan_type,
1596: ip.cutoff_date, ip.data_start_date, ip.description;
1597:
1598: FII_UTIL.Stop_Timer;
1599: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_snapshots in');
1600: -- COMMIT;
1601:
1602: -- ----------------------------------
1603: -- Collect ISC_DBI_PLAN_ORG_SNAPSHOTS

Line 1608: FII_UTIL.Start_Timer;

1604: -- ----------------------------------
1605:
1606: BIS_COLLECTION_UTILITIES.put_line(' ');
1607: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_plan_org_snapshots.');
1608: FII_UTIL.Start_Timer;
1609:
1610: INSERT
1611: INTO isc_dbi_plan_org_snapshots(
1612: SNAPSHOT_ID,

Line 1620: FII_UTIL.Stop_Timer;

1616: isc_dbi_plan_organizations ipo
1617: WHERE tmp.plan_id = ipo.plan_id
1618: AND bitand(tmp.plan_usage, 2) = 2;
1619:
1620: FII_UTIL.Stop_Timer;
1621: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_organizations in');
1622: -- COMMIT;
1623:
1624: -- ----------------------------------

Line 1621: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_organizations in');

1617: WHERE tmp.plan_id = ipo.plan_id
1618: AND bitand(tmp.plan_usage, 2) = 2;
1619:
1620: FII_UTIL.Stop_Timer;
1621: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_plan_organizations in');
1622: -- COMMIT;
1623:
1624: -- ----------------------------------
1625: -- Collect ISC_DBI_SUPPLIES_SNAPSHOTS

Line 1630: FII_UTIL.Start_Timer;

1626: -- ----------------------------------
1627:
1628: BIS_COLLECTION_UTILITIES.put_line(' ');
1629: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_supplies_snapshots.');
1630: FII_UTIL.Start_Timer;
1631:
1632: -- item level only, move category to MV
1633:
1634: INSERT INTO isc_dbi_supplies_snapshots F(

Line 1671: FII_UTIL.Stop_Timer;

1667: AND ids.disposition_status_type <> 2
1668: GROUP BY tmp.snapshot_id, ids.organization_id, nvl(ids.sr_supplier_id, -1), ids.sr_inventory_item_id, ids.uom_code,
1669: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1670:
1671: FII_UTIL.Stop_Timer;
1672: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_supplies_snapshots in');
1673: -- COMMIT;
1674:
1675:

Line 1672: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_supplies_snapshots in');

1668: GROUP BY tmp.snapshot_id, ids.organization_id, nvl(ids.sr_supplier_id, -1), ids.sr_inventory_item_id, ids.uom_code,
1669: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1670:
1671: FII_UTIL.Stop_Timer;
1672: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_supplies_snapshots in');
1673: -- COMMIT;
1674:
1675:
1676: -- ----------------------------------------

Line 1688: FII_UTIL.Start_Timer;

1684: -- ----------------------------------------
1685:
1686: BIS_COLLECTION_UTILITIES.put_line(' ');
1687: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for unconstrained plans.');
1688: FII_UTIL.Start_Timer;
1689:
1690: INSERT
1691: INTO isc_dbi_shortfall_snapshots F(
1692: SNAPSHOT_ID,

Line 1791: FII_UTIL.Stop_Timer;

1787: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,
1788: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1789: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1790:
1791: FII_UTIL.Stop_Timer;
1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1793:
1794: BIS_COLLECTION_UTILITIES.put_line(' ');
1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');

Line 1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');

1788: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1789: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1790:
1791: FII_UTIL.Stop_Timer;
1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1793:
1794: BIS_COLLECTION_UTILITIES.put_line(' ');
1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');
1796: FII_UTIL.Start_Timer;

Line 1796: FII_UTIL.Start_Timer;

1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1793:
1794: BIS_COLLECTION_UTILITIES.put_line(' ');
1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');
1796: FII_UTIL.Start_Timer;
1797:
1798: INSERT
1799: INTO isc_dbi_shortfall_snapshots F(
1800: SNAPSHOT_ID,

Line 1907: FII_UTIL.Stop_Timer;

1903: GROUP BY f.snapshot_id, f.organization_id, f.dmd_item_id, f.uom_code, f.organization_type, f.reason_type,
1904: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1905: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1906:
1907: FII_UTIL.Stop_Timer;
1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1909: -- COMMIT;
1910:
1911: -- ------------------------------------

Line 1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');

1904: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1905: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1906:
1907: FII_UTIL.Stop_Timer;
1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1909: -- COMMIT;
1910:
1911: -- ------------------------------------
1912: -- Collect ISC_DBI_INV_DETAIL_SNAPSHOTS

Line 1917: FII_UTIL.Start_Timer;

1913: -- ------------------------------------
1914:
1915: BIS_COLLECTION_UTILITIES.put_line(' ');
1916: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_inv_detail_snapshots.');
1917: FII_UTIL.Start_Timer;
1918:
1919: -- item level only
1920:
1921: INSERT /*+ APPEND PARALLEL(F) */

Line 2033: FII_UTIL.Stop_Timer;

2029: WHERE tmp.snapshot_id = sh.snapshot_id
2030: AND bitand(tmp.plan_usage, 2) = 2)
2031: GROUP BY snapshot_id, organization_id, sr_inventory_item_id, start_date, period_type_id, uom_code;
2032:
2033: FII_UTIL.Stop_Timer;
2034: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_inv_detail_snapshots in');
2035: -- COMMIT;
2036:
2037: -- ----------------------------------

Line 2034: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_inv_detail_snapshots in');

2030: AND bitand(tmp.plan_usage, 2) = 2)
2031: GROUP BY snapshot_id, organization_id, sr_inventory_item_id, start_date, period_type_id, uom_code;
2032:
2033: FII_UTIL.Stop_Timer;
2034: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_inv_detail_snapshots in');
2035: -- COMMIT;
2036:
2037: -- ----------------------------------
2038: -- Collect ISC_DBI_RES_SUM_SNAPSHOTS

Line 2043: FII_UTIL.Start_Timer;

2039: -- ----------------------------------
2040:
2041: BIS_COLLECTION_UTILITIES.put_line(' ');
2042: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_res_sum_snapshots.');
2043: FII_UTIL.Start_Timer;
2044:
2045: INSERT /*+ APPEND PARALLEL(F) */
2046: INTO isc_dbi_res_sum_snapshots F(
2047: SNAPSHOT_ID,

Line 2081: FII_UTIL.Stop_Timer;

2077: -- AND ires.resource_id > 0
2078: GROUP BY snapshot_id, ires.organization_id, ires.resource_id, ires.organization_type, ires.department_id,
2079: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
2080:
2081: FII_UTIL.Stop_Timer;
2082: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_res_sum_snapshots in');
2083: -- COMMIT;
2084: END IF;
2085:

Line 2082: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_res_sum_snapshots in');

2078: GROUP BY snapshot_id, ires.organization_id, ires.resource_id, ires.organization_type, ires.department_id,
2079: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
2080:
2081: FII_UTIL.Stop_Timer;
2082: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_res_sum_snapshots in');
2083: -- COMMIT;
2084: END IF;
2085:
2086: RETURN(1);

Line 2160: FII_UTIL.Start_Timer;

2156: -- --------------------------------------------
2157:
2158: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2159: BIS_COLLECTION_UTILITIES.put_line('Begin to update the collection information.');
2160: FII_UTIL.Start_Timer;
2161:
2162: DELETE from isc_dbi_plan_schedules
2163: WHERE frequency = 'ONCE'
2164: AND next_collection_date <= g_snapshot_date

Line 2201: FII_UTIL.Stop_Timer;

2197: -- UPDATE isc_dbi_plan_schedules
2198: -- SET next_collection_date = ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(plan_name)
2199: -- WHERE plan_name IN (select plan_name from isc_dbi_tmp_plans tmp WHERE bitand(tmp.plan_usage, 2) = 2);
2200:
2201: FII_UTIL.Stop_Timer;
2202: FII_UTIL.Print_Timer('Updated the setup tables in');
2203: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2204:
2205: /*

Line 2202: FII_UTIL.Print_Timer('Updated the setup tables in');

2198: -- SET next_collection_date = ISC_DBI_PLAN_SETUP_UTIL_PKG.get_next_collection_date(plan_name)
2199: -- WHERE plan_name IN (select plan_name from isc_dbi_tmp_plans tmp WHERE bitand(tmp.plan_usage, 2) = 2);
2200:
2201: FII_UTIL.Stop_Timer;
2202: FII_UTIL.Print_Timer('Updated the setup tables in');
2203: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2204:
2205: /*
2206: -- ------------------------

Line 2212: FII_UTIL.Start_Timer;

2208: -- ------------------------
2209:
2210: BIS_COLLECTION_UTILITIES.put_line(' ');
2211: BIS_COLLECTION_UTILITIES.put_line('Truncating the temp table');
2212: FII_UTIL.Start_Timer;
2213:
2214: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
2215: EXECUTE IMMEDIATE l_trunc_stmt;
2216:

Line 2217: FII_UTIL.Stop_Timer;

2213:
2214: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
2215: EXECUTE IMMEDIATE l_trunc_stmt;
2216:
2217: FII_UTIL.Stop_Timer;
2218: FII_UTIL.Print_Timer('Truncated the temp table in');
2219: */
2220: -- ----------------------------------------------
2221: -- No exception raised so far. Successful. Call

Line 2218: FII_UTIL.Print_Timer('Truncated the temp table in');

2214: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.isc_dbi_tmp_plans';
2215: EXECUTE IMMEDIATE l_trunc_stmt;
2216:
2217: FII_UTIL.Stop_Timer;
2218: FII_UTIL.Print_Timer('Truncated the temp table in');
2219: */
2220: -- ----------------------------------------------
2221: -- No exception raised so far. Successful. Call
2222: -- Wrapup to commit and insert messages into logs

Line 2316: FII_UTIL.Stop_Timer;

2312: l_trunc_stmt := 'truncate table ' || g_isc_schema ||'.'|| g_small_snapshots(i);
2313: EXECUTE IMMEDIATE l_trunc_stmt;
2314: END LOOP;
2315:
2316: FII_UTIL.Stop_Timer;
2317: FII_UTIL.Print_Timer('Truncated the snapshot tables in');
2318: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2319:
2320: -- --------------------------------------------

Line 2317: FII_UTIL.Print_Timer('Truncated the snapshot tables in');

2313: EXECUTE IMMEDIATE l_trunc_stmt;
2314: END LOOP;
2315:
2316: FII_UTIL.Stop_Timer;
2317: FII_UTIL.Print_Timer('Truncated the snapshot tables in');
2318: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2319:
2320: -- --------------------------------------------
2321: -- Insert data into the snapshot tables

Line 2422: FII_UTIL.Start_Timer;

2418: -- --------------------------------------------
2419:
2420: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2421: BIS_COLLECTION_UTILITIES.put_line('Begin to purge the obsolete snapshots ');
2422: FII_UTIL.Start_Timer;
2423:
2424: l_purge := PURGE_SNAPSHOTS;
2425:
2426: IF (l_purge = -1) THEN

Line 2430: FII_UTIL.Stop_Timer;

2426: IF (l_purge = -1) THEN
2427: RAISE l_failure;
2428: END IF;
2429:
2430: FII_UTIL.Stop_Timer;
2431: FII_UTIL.Print_Timer('Purged '|| l_purge ||' snapshots in');
2432: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2433:
2434: -- --------------------------------------------

Line 2431: FII_UTIL.Print_Timer('Purged '|| l_purge ||' snapshots in');

2427: RAISE l_failure;
2428: END IF;
2429:
2430: FII_UTIL.Stop_Timer;
2431: FII_UTIL.Print_Timer('Purged '|| l_purge ||' snapshots in');
2432: BIS_COLLECTION_UTILITIES.Put_Line(' ');
2433:
2434: -- --------------------------------------------
2435: -- Insert data into the snapshot tables