APPS.OPI_DBI_INV_CCA_PKG dependencies on OPI_DBI_BOUNDS_PKG

Line 305: OPI_DBI_BOUNDS_PKG.MAINTAIN_OPI_DBI_LOGS ( p_etl_type=> C_ETL_TYPE,

301: -- Set up the bounds for Cycle Count accuracy in the log table.
302: -- Commit will be done
303: BIS_COLLECTION_UTILITIES.PUT_LINE (
304: 'Setting up bounds for Process and Discrete ...');
305: OPI_DBI_BOUNDS_PKG.MAINTAIN_OPI_DBI_LOGS ( p_etl_type=> C_ETL_TYPE,
306: p_load_type=> C_LOAD_INIT);
307:
308:
309: l_stmt_id := 30;

Line 358: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;

354: -- Call API to load ledger data into Global temp table
355: -- This temp table will be joined to extract process adjustments
356: BIS_COLLECTION_UTILITIES.PUT_LINE (
357: 'Loading Ledger data into temp table ...');
358: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
359:
360: l_stmt_id := 57;
361: -- Committing the data. Since the temp table is made with On Commit preserve rows
362: -- there will be no problem.

Line 422: OPI_DBI_BOUNDS_PKG.SET_LOAD_SUCCESSFUL(C_ETL_TYPE, C_LOAD_INIT);

418:
419: l_stmt_id := 150;
420: -- Update the bounds table
421: BIS_COLLECTION_UTILITIES.PUT_LINE ('Updating run time bounds for next run ...');
422: OPI_DBI_BOUNDS_PKG.SET_LOAD_SUCCESSFUL(C_ETL_TYPE, C_LOAD_INIT);
423:
424: l_stmt_id := 160;
425: -- Truncate the staging table, commit the data to the fact table
426: -- and update the CCA related bounds in one database transaction

Line 2255: OPI_DBI_BOUNDS_PKG.MAINTAIN_OPI_DBI_LOGS ( p_etl_type=> C_ETL_TYPE,

2251: -- Set up the bounds for Cycle Count accuracy in the log table.
2252: BIS_COLLECTION_UTILITIES.PUT_LINE (
2253: 'Setting up bounds for discrete manufacturing organzations ...');
2254: -- return status not speified in the procedure
2255: OPI_DBI_BOUNDS_PKG.MAINTAIN_OPI_DBI_LOGS ( p_etl_type=> C_ETL_TYPE,
2256: p_load_type=> C_LOAD_INCR);
2257: l_stmt_id := 30;
2258: -- Extract the adjustment entry data from MMT/MTA using the
2259: -- bounds just set up.

Line 2274: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;

2270: -- Call API to load ledger data into Global temp table
2271: -- This temp table will be joined to extract process adjustments
2272: BIS_COLLECTION_UTILITIES.PUT_LINE (
2273: 'Loading Ledger data into temp table ...');
2274: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
2275:
2276: l_stmt_id := 47;
2277: -- Committing the data. Since the temp table is made with On Commit preserve rows
2278: -- there will be no problem.

Line 2327: OPI_DBI_BOUNDS_PKG.SET_LOAD_SUCCESSFUL(C_ETL_TYPE, C_LOAD_INCR);

2323: l_stmt_id := 120;
2324: -- Update the bounds table
2325: BIS_COLLECTION_UTILITIES.PUT_LINE ('Updating run time bounds for next run ...');
2326: -- return status not speified in the procedure
2327: OPI_DBI_BOUNDS_PKG.SET_LOAD_SUCCESSFUL(C_ETL_TYPE, C_LOAD_INCR);
2328:
2329:
2330: l_stmt_id := 130;
2331: -- Truncate the staging table, commit the data to the fact table