2632: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2633:
2634:
2635: -- update common modules for OPI
2636: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
2637: p_source => 1);
2638: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
2639: p_source => 2);
2640:
2634:
2635: -- update common modules for OPI
2636: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
2637: p_source => 1);
2638: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
2639: p_source => 2);
2640:
2641: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
2642: p_source => 1);
2637: p_source => 1);
2638: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
2639: p_source => 2);
2640:
2641: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
2642: p_source => 1);
2643: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
2644: p_source => 2);
2645:
2639: p_source => 2);
2640:
2641: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
2642: p_source => 1);
2643: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
2644: p_source => 2);
2645:
2646: IF l_comm_opi_avail_flag AND l_comm_opm_avail_flag
2647: AND l_comm_opi_actual_flag AND l_comm_opm_actual_flag THEN
3461: bis_collection_utilities.put_line('Load resource avail into FACT ' || l_count || ' rows, completed at '
3462: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3463:
3464: -- update common modules for OPI
3465: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
3466: p_source => 1);
3467: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
3468: p_source => 2);
3469:
3463:
3464: -- update common modules for OPI
3465: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
3466: p_source => 1);
3467: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
3468: p_source => 2);
3469:
3470: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
3471: p_source => 1);
3466: p_source => 1);
3467: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,
3468: p_source => 2);
3469:
3470: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
3471: p_source => 1);
3472: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
3473: p_source => 2);
3474:
3468: p_source => 2);
3469:
3470: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
3471: p_source => 1);
3472: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_ETL,
3473: p_source => 2);
3474:
3475: IF l_comm_opi_avail_flag AND l_comm_opm_avail_flag
3476: AND l_comm_opi_actual_flag AND l_comm_opm_actual_flag THEN