APPS.OPI_DBI_INV_TURNS_PKG dependencies on BIS_COLLECTION_UTILITIES

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 269: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished Filling missing start date Time bucket rows process.');

265: INV_BALANCE_SG
266: from OPI_INV_ITD_ORG_MV
267: );
268:
269: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished Filling missing start date Time bucket rows process.');
270:
271: /* *******************************
272: Calculating Weights, adding start dates
273: ******************************* */

Line 364: BIS_COLLECTION_UTILITIES.PUT_LINE ('Inserted ' || l_row_count ||

360: AND turns.organization_id = cogs.organization_id(+);
361:
362: l_row_count := sql%rowcount;
363:
364: BIS_COLLECTION_UTILITIES.PUT_LINE ('Inserted ' || l_row_count ||
365: ' rows into the turns table successfully.');
366: BIS_COLLECTION_UTILITIES.WRAPUP (TRUE, l_row_count,
367: 'Pushed successfully into turns table.');
368: COMMIT;

Line 366: BIS_COLLECTION_UTILITIES.WRAPUP (TRUE, l_row_count,

362: l_row_count := sql%rowcount;
363:
364: BIS_COLLECTION_UTILITIES.PUT_LINE ('Inserted ' || l_row_count ||
365: ' rows into the turns table successfully.');
366: BIS_COLLECTION_UTILITIES.WRAPUP (TRUE, l_row_count,
367: 'Pushed successfully into turns table.');
368: COMMIT;
369:
370: errbuf := '';

Line 384: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,

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 ||' : ' ||
387: errbuf);
388:

Line 402: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,

398: errbuf := s_pkg_name || '.' || l_proc_name || ': #' ||
399: to_char (l_stmt_num) || ': ' ||
400: 'Unable to get OPI schema information.';
401:
402: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
403: l_row_count,
404: 'EXCEPTION '|| SQLCODE ||' : ' ||
405: errbuf);
406:

Line 420: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,

416: to_char (l_stmt_num) || ': ' ||
417: substr(SQLERRM, 1,200);
418:
419:
420: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
421: l_row_count,
422: 'EXCEPTION '|| SQLCODE ||' : ' ||
423: errbuf);
424: return;