APPS.ISC_DBI_BOOK_SUM2_REF_PKG dependencies on ISC_BOOK_SUM2_PDUE_F

Line 66: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE_F')) THEN

62: BEGIN
63: errbuf := NULL;
64: retcode := '0';
65:
66: IF (Not BIS_COLLECTION_UTILITIES.setup('ISC_BOOK_SUM2_PDUE_F')) THEN
67: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
68: return;
69: END IF;
70:

Line 71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);

67: RAISE_APPLICATION_ERROR (-20000,'Error in SETUP: ' || errbuf);
68: return;
69: END IF;
70:
71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);
72: l_to_date := sysdate;
73:
74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');
75:

Line 74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');

70:
71: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_PDUE_F', l_start, l_end, l_period_from, l_from_date);
72: l_to_date := sysdate;
73:
74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');
75:
76: FII_UTIL.Start_Timer;
77:
78: UPDATE isc_book_sum2_pdue_f

Line 78: UPDATE isc_book_sum2_pdue_f

74: BIS_COLLECTION_UTILITIES.put_line('Updating ISC_BOOK_SUM2_PDUE_F');
75:
76: FII_UTIL.Start_Timer;
77:
78: UPDATE isc_book_sum2_pdue_f
79: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
80: WHERE time_snapshot_date_id = trunc(sysdate);
81:
82: FII_UTIL.Stop_Timer;

Line 83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');

79: SET time_snapshot_date_id = to_date('1000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS')
80: WHERE time_snapshot_date_id = trunc(sysdate);
81:
82: FII_UTIL.Stop_Timer;
83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');
84:
85: BIS_COLLECTION_UTILITIES.put_line(' ');
86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');
87:

Line 86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');

82: FII_UTIL.Stop_Timer;
83: FII_UTIL.Print_Timer('Obsoleted ' || sql%rowcount || ' rows in ISC_BOOK_SUM2_PDUE_F in');
84:
85: BIS_COLLECTION_UTILITIES.put_line(' ');
86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');
87:
88: FII_UTIL.Start_Timer;
89:
90: INSERT INTO isc_book_sum2_pdue_f(

Line 90: INSERT INTO isc_book_sum2_pdue_f(

86: BIS_COLLECTION_UTILITIES.put_line('Inserting data into ISC_BOOK_SUM2_PDUE_F');
87:
88: FII_UTIL.Start_Timer;
89:
90: INSERT INTO isc_book_sum2_pdue_f(
91: INV_ORG_ID,
92: INVENTORY_ITEM_ID,
93: CUSTOMER_ID,
94: TIME_BOOKED_DATE_ID,

Line 130: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE_F in');

126:
127: l_row_count := l_row_count + sql%rowcount;
128:
129: FII_UTIL.Stop_Timer;
130: FII_UTIL.Print_Timer('Inserted ' || l_row_count || ' rows into ISC_BOOK_SUM2_PDUE_F in');
131:
132: BIS_COLLECTION_UTILITIES.WRAPUP(
133: TRUE,
134: l_row_count,