DBA Data[Home] [Help]

APPS.BSC_UPDATE dependencies on BSC_BIA_WRAPPER

Line 1571: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar_AT(x_calendar_id, h_error_message) THEN

1567: RAISE e_could_not_get_lock;
1568: END IF;
1569:
1570: --LOCKING: call the autonomous transaction
1571: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar_AT(x_calendar_id, h_error_message) THEN
1572: RAISE e_error_load_rpt_cal;
1573: END IF;
1574:
1575: --AW_INTEGRATION: call aw api to import calendars into aw world

Line 1606: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,

1602:
1603: --LOCKING
1604: WHEN e_error_load_rpt_cal THEN
1605: ROLLBACK;
1606: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_error_message,
1607: x_source => 'BSC_UPDATE.Execute_Year_Change_Process');
1608:
1609: RETURN FALSE;
1610:

Line 3793: mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(h_system_tables(h_i));

3789: -- Make sure to refresh the MV only one time. Remember that same MV
3790: -- has data for different periodicities.
3791: -- Note: The api to refresh the MV does not fail if the MV does not exists
3792: -- or if the MV is actually a normal view
3793: mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(h_system_tables(h_i));
3794: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(mv_name,
3795: h_refreshed_mvs,
3796: h_num_refreshed_mvs) THEN
3797:

Line 3806: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV_AT(mv_name, h_error_refresh) THEN

3802: RAISE e_could_not_get_lock;
3803: END IF;
3804:
3805: --LOCKING: call the autonomous transaction function
3806: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV_AT(mv_name, h_error_refresh) THEN
3807: RAISE e_error_refresh;
3808: END IF;
3809:
3810: -- Also refresh the MV created for zero code (if it exists)

Line 3851: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,

3847: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3848: RETURN FALSE;
3849:
3850: WHEN e_error_refresh THEN
3851: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,
3852: x_source => 'BSC_UPDATE.Refresh_System_MVs');
3853: RETURN FALSE;
3854:
3855: WHEN e_error_refresh_zero THEN

Line 3937: mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(h_system_tables(h_i));

3933: -- Make sure to refresh the MV only one time. Remember that same MV
3934: -- has data for different periodicities.
3935: -- Note: The api to refresh the MV does not fail if the MV does not exists
3936: -- or if the MV is actually a normal view
3937: mv_name := BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(h_system_tables(h_i));
3938: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(mv_name,
3939: h_refreshed_mvs,
3940: h_num_refreshed_mvs) THEN
3941:

Line 3942: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(mv_name, h_error_refresh) THEN

3938: IF NOT BSC_UPDATE_UTIL.Item_Belong_To_Array_Varchar2(mv_name,
3939: h_refreshed_mvs,
3940: h_num_refreshed_mvs) THEN
3941:
3942: IF NOT BSC_BIA_WRAPPER.Refresh_Summary_MV(mv_name, h_error_refresh) THEN
3943: RAISE e_error_refresh;
3944: END IF;
3945:
3946: -- Also refresh the MV created for zero code (if it exists)

Line 3977: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||mv_name||' '||h_error_refresh,

3973: x_source => 'BSC_UPDATE.Refresh_System_MVs_Mig');
3974: RETURN FALSE;
3975:
3976: WHEN e_error_refresh THEN
3977: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Refresh_Summary_MV '||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