DBA Data[Home] [Help]

APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_COMMON_MOD_INCR_PKG

Line 2636: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,

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:

Line 2638: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,

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);

Line 2641: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_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);
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:

Line 2643: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_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:
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

Line 3465: l_comm_opi_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,

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:

Line 3467: l_comm_opm_avail_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => RESOURCE_VAR_ETL,

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);

Line 3470: l_comm_opi_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_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);
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:

Line 3472: l_comm_opm_actual_flag := opi_dbi_common_mod_incr_pkg.etl_report_success(p_etl_id => ACTUAL_RES_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:
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