APPS.OPI_DBI_INV_TURNS_PKG dependencies on OPI_DBI_INV_TURNS_F

Line 105: if BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_INV_TURNS_F' ) = false then

101: -- File scope globals
102: initialize_globals ();
103:
104:
105: if BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_INV_TURNS_F' ) = false then
106: RAISE SETUP_INVALID;
107: END IF;
108:
109: /* **********************

Line 280: '.OPI_DBI_INV_TURNS_F ';

276: l_stmt_num := 40;
277: IF fnd_installation.get_app_info( 'OPI', l_status,
278: l_industry, l_opi_schema) THEN
279: execute immediate 'truncate table ' || l_opi_schema ||
280: '.OPI_DBI_INV_TURNS_F ';
281: ELSE
282: RAISE SCHEMA_INFO_NOT_FOUND;
283: END IF;
284:

Line 298: INTO opi_dbi_inv_turns_f

294: -- and source, which caused two rows to be created for the same org/date
295: -- once CPCS was introduced with source = 3. The MV has been modified
296: -- to have a unique key of org, date.
297: INSERT /*+ append */
298: INTO opi_dbi_inv_turns_f
299: (
300: organization_id,
301: transaction_date,
302: start_date_wtd,

Line 382: 'Setup of OPI_DBI_INV_TURNS_F table is incorrect.';

378:
379: retcode := s_ERROR;
380: errbuf := s_pkg_name || '.' || l_proc_name || ': #' ||
381: to_char (l_stmt_num) || ': ' ||
382: 'Setup of OPI_DBI_INV_TURNS_F table is incorrect.';
383:
384: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
385: l_row_count,
386: 'EXCEPTION '|| SQLCODE ||' : ' ||