APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_RES_AVAIL_F

Line 2213: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_RES_AVAIL_F' ) = false then

2209: l_comm_opm_avail_flag := FALSE;
2210: l_comm_opi_actual_flag := FALSE;
2211: l_comm_opm_actual_flag := FALSE;
2212:
2213: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_RES_AVAIL_F' ) = false then
2214: --{
2215: RAISE_APPLICATION_ERROR(-20000, errbuf);
2216: --}
2217: END IF;

Line 2252: || '.opi_dbi_res_avail_f PURGE MATERIALIZED VIEW LOG ';

2248: execute immediate 'truncate table ' || l_opi_schema
2249: || '.opi_dbi_res_actual_stg ';
2250:
2251: execute immediate 'truncate table ' || l_opi_schema
2252: || '.opi_dbi_res_avail_f PURGE MATERIALIZED VIEW LOG ';
2253:
2254: execute immediate 'truncate table ' || l_opi_schema
2255: || '.opi_dbi_res_actual_f PURGE MATERIALIZED VIEW LOG ';
2256: --}

Line 2506: INTO opi_dbi_res_avail_f b (

2502:
2503: bis_collection_utilities.put_line('Initially load actual and avail data from staging to avail fact ...');
2504:
2505: INSERT /*+ append parallel(b) */
2506: INTO opi_dbi_res_avail_f b (
2507: resource_id,
2508: department_id,
2509: organization_id,
2510: transaction_date,

Line 2922: IF bis_collection_utilities.setup( 'OPI_DBI_RES_AVAIL_F' ) = false THEN

2918: l_comm_opi_actual_flag := FALSE;
2919: l_comm_opm_actual_flag := FALSE;
2920:
2921:
2922: IF bis_collection_utilities.setup( 'OPI_DBI_RES_AVAIL_F' ) = false THEN
2923: --{
2924: RAISE_APPLICATION_ERROR(-20000, errbuf);
2925: --}
2926: END IF;

Line 3084: UPDATE opi_dbi_res_avail_f

3080: l_stmt_num := 90;
3081:
3082: IF (l_opi_start_date = l_opi_end_date) THEN
3083: --{
3084: UPDATE opi_dbi_res_avail_f
3085: SET avail_qty = NULL,
3086: uom = NULL,
3087: avail_qty_g = NULL,
3088: avail_val_b = NULL,

Line 3280: MERGE /*+ index(f, OPI_DBI_RES_AVAIL_F_N1) */

3276: --{
3277: bis_collection_utilities.put_line('Merge res actual and avail from staging to avail fact ...');
3278: l_stmt_num := 130;
3279:
3280: MERGE /*+ index(f, OPI_DBI_RES_AVAIL_F_N1) */
3281: INTO opi_dbi_res_avail_f f
3282: USING (
3283: SELECT
3284: res.resource_id,

Line 3281: INTO opi_dbi_res_avail_f f

3277: bis_collection_utilities.put_line('Merge res actual and avail from staging to avail fact ...');
3278: l_stmt_num := 130;
3279:
3280: MERGE /*+ index(f, OPI_DBI_RES_AVAIL_F_N1) */
3281: INTO opi_dbi_res_avail_f f
3282: USING (
3283: SELECT
3284: res.resource_id,
3285: res.department_id,