318: BEGIN
319: errbuf := NULL;
320: retcode := '0';
321:
322: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_BKORD_F')) THEN
323: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
324: return;
325: END IF;
326:
323: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
324: return;
325: END IF;
326:
327: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_BKORD_F', l_start, l_end, l_period_from, l_from_date);
328: l_to_date := sysdate;
329:
330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');
331:
326:
327: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_BKORD_F', l_start, l_end, l_period_from, l_from_date);
328: l_to_date := sysdate;
329:
330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');
331:
332: FII_UTIL.Start_Timer;
333:
334: UPDATE isc_book_sum2_bkord_f
330: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_BKORD_F');
331:
332: FII_UTIL.Start_Timer;
333:
334: UPDATE isc_book_sum2_bkord_f
335: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
336: WHERE time_snapshot_date_id = trunc(sysdate);
337:
338: FII_UTIL.Stop_Timer;
335: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
336: WHERE time_snapshot_date_id = trunc(sysdate);
337:
338: FII_UTIL.Stop_Timer;
339: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_BKORD_F in');
340:
341: BIS_COLLECTION_UTILITIES.put_line(' ');
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');
343:
338: FII_UTIL.Stop_Timer;
339: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_BKORD_F in');
340:
341: BIS_COLLECTION_UTILITIES.put_line(' ');
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');
343:
344: FII_UTIL.Start_Timer;
345:
346: INSERT INTO isc_book_sum2_bkord_f(
342: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_BKORD_F');
343:
344: FII_UTIL.Start_Timer;
345:
346: INSERT INTO isc_book_sum2_bkord_f(
347: INV_ORG_ID,
348: INVENTORY_ITEM_ID,
349: CUSTOMER_ID,
350: ORDER_NUMBER,
395:
396: l_row_count := l_row_count + sql%rowcount;
397:
398: FII_UTIL.Stop_Timer;
399: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_BKORD_F in');
400:
401: BIS_COLLECTION_UTILITIES.WRAPUP(
402: TRUE,
403: l_row_count,