APPS.BSC_UPDATE dependencies on BSC_UPDATE_SUM

Line 1536: BSC_UPDATE_SUM.Refresh_AW_Kpi_AT(h_aw_indicators(h_i));

1532: RAISE e_could_not_get_lock;
1533: END IF;
1534:
1535: --LOCKING: call the autonomous transaction procedure
1536: BSC_UPDATE_SUM.Refresh_AW_Kpi_AT(h_aw_indicators(h_i));
1537:
1538: -- LOCKING: commit to release locks
1539: COMMIT;
1540: END IF;

Line 3275: BSC_UPDATE_SUM.g_refreshed_mvs.delete;

3271: END IF;
3272: END IF;
3273:
3274: -- Calculate the system tables
3275: BSC_UPDATE_SUM.g_refreshed_mvs.delete;
3276: BSC_UPDATE_SUM.g_num_refreshed_mvs := 0;
3277:
3278: -- Until all system tables have been calculated
3279: WHILE h_num_calculated_sys_tables <> h_num_system_tables LOOP

Line 3276: BSC_UPDATE_SUM.g_num_refreshed_mvs := 0;

3272: END IF;
3273:
3274: -- Calculate the system tables
3275: BSC_UPDATE_SUM.g_refreshed_mvs.delete;
3276: BSC_UPDATE_SUM.g_num_refreshed_mvs := 0;
3277:
3278: -- Until all system tables have been calculated
3279: WHILE h_num_calculated_sys_tables <> h_num_system_tables LOOP
3280: FOR h_i IN 1 .. h_num_system_tables LOOP

Line 3355: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_AW_AT(h_system_tables(h_i)) THEN

3351: RAISE e_could_not_get_lock;
3352: END IF;
3353:
3354: --LOCKING: call the autonomous transaction function
3355: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_AW_AT(h_system_tables(h_i)) THEN
3356: RAISE e_unexpected_error;
3357: END IF;
3358:
3359: --LOCKING: commit to release locks

Line 3369: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_MV_AT(h_system_tables(h_i),

3365: RAISE e_could_not_get_lock;
3366: END IF;
3367:
3368: -- LOCKING: call the autonomous transaction function
3369: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_MV_AT(h_system_tables(h_i),
3370: h_calculated_sys_tables,
3371: h_num_calculated_sys_tables,
3372: h_system_tables,
3373: h_num_system_tables) THEN

Line 3387: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_AT(h_system_tables(h_i)) THEN

3383: RAISE e_could_not_get_lock;
3384: END IF;
3385:
3386: --LOCKING: call the autonomous transaction function
3387: IF NOT BSC_UPDATE_SUM.Calculate_Sum_Table_AT(h_system_tables(h_i)) THEN
3388: RAISE e_unexpected_error;
3389: END IF;
3390:
3391: --LOCKING: commit to refresh the locks

Line 3465: BSC_UPDATE_SUM.Refresh_AW_Kpi_AT(h_indicators_aw(h_i));

3461: END IF;
3462:
3463: -- AW_INTEGRATION: Call the aw api to refresh the indicator cubes
3464: --LOCKING: call the autonomous transaction procedure
3465: BSC_UPDATE_SUM.Refresh_AW_Kpi_AT(h_indicators_aw(h_i));
3466:
3467: --LOCKING: commit to release the locks
3468: COMMIT;
3469: END IF;

Line 3812: IF NOT BSC_UPDATE_SUM.Refresh_Zero_MVs_AT(h_system_tables(h_i),

3808: END IF;
3809:
3810: -- Also refresh the MV created for zero code (if it exists)
3811: --LOCKING: call the autonomous transaction function
3812: IF NOT BSC_UPDATE_SUM.Refresh_Zero_MVs_AT(h_system_tables(h_i),
3813: mv_name, h_error_refresh) THEN
3814: RAISE e_error_refresh_zero;
3815: END IF;
3816:

Line 3856: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,

3852: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3853: RETURN FALSE;
3854:
3855: WHEN e_error_refresh_zero THEN
3856: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,
3857: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3858: RETURN FALSE;
3859:
3860: WHEN OTHERS THEN

Line 3947: IF NOT BSC_UPDATE_SUM.Refresh_Zero_MVs(h_system_tables(h_i),

3943: RAISE e_error_refresh;
3944: END IF;
3945:
3946: -- Also refresh the MV created for zero code (if it exists)
3947: IF NOT BSC_UPDATE_SUM.Refresh_Zero_MVs(h_system_tables(h_i),
3948: mv_name, h_error_refresh) THEN
3949: RAISE e_error_refresh_zero;
3950: END IF;
3951:

Line 3982: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,

3978: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3979: RETURN FALSE;
3980:
3981: WHEN e_error_refresh_zero THEN
3982: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_SUM.Refresh_Zero_MVs '||mv_name||' '||h_error_refresh,
3983: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3984: RETURN FALSE;
3985:
3986: WHEN OTHERS THEN