Refresh the materialized view of Oracle stored procedures

Oracle Stored Procedure refresh materialized view SQL:

Create or replace package body REFRESH_MVIEW IS

-- Author: 241433
-- Created: 4:25:04
-- Purpose: This PKG is for REFRESH MVIEW

-- Public type declarations
CONS_BCR_LIST VARCHAR2 (40): = 'wb_ui_block_list_all_vw ';
CONS_BCR_LIST_QUERY VARCHAR2 (40): = 'wb_ui_block_list_query_vw ';
CONS_BCR_RULE VARCHAR2 (40): = 'wb_ui_block_rule_all_vw ';

CONS_CUST_HCP VARCHAR2 (40): = 'capublish. HCP_CUST_PROFILE_VW ';
CONS_CUST_HCA VARCHAR2 (40): = 'capublish. HCA_CUST_PROFILE_VW ';

PROCEDURE REFRESH_MVIEW (P_MVIEW_NAME IN VARCHAR2) IS
BEGIN
DBMS_MVIEW.REFRESH (P_MVIEW_NAME );
END REFRESH_MVIEW;

PROCEDURE REFRESH_MVIEW_BCR_REPORT IS
BEGIN
REFRESH_MVIEW (CONS_BCR_LIST );
REFRESH_MVIEW (CONS_BCR_LIST_QUERY );
REFRESH_MVIEW (CONS_BCR_RULE );
END REFRESH_MVIEW_BCR_REPORT;

PROCEDURE REFRESH_MVIEW_CUST IS
BEGIN
REFRESH_MVIEW (CONS_CUST_HCP );
REFRESH_MVIEW (CONS_CUST_HCA );
END REFRESH_MVIEW_CUST;

END REFRESH_MVIEW;