141: IF p_enable_disable = 'E' THEN
142: --
143: -- This procedure purges rows from the materialized view log.
144: --
145: dbms_mview.purge_log(master => p_schema || '.HRI_MAP_SUP_WRKFC_ASG'
146: ,num => 99999);
147: --
148: -- This procedure ensures that the materialized view data for the master
149: -- table is valid and that the master table is in the proper state. It
148: -- This procedure ensures that the materialized view data for the master
149: -- table is valid and that the master table is in the proper state. It
150: -- must be called after a master table is reorganized
151: --
152: dbms_mview.end_table_reorganization(tabowner => p_schema
153: ,tabname => 'HRI_MAP_SUP_WRKFC_ASG');
154: --
155: -- This procedure purges rows from the materialized view log.
156: --
153: ,tabname => 'HRI_MAP_SUP_WRKFC_ASG');
154: --
155: -- This procedure purges rows from the materialized view log.
156: --
157: dbms_mview.purge_log(master => p_schema || '.HRI_MAP_SUP_WRKFC_ASG',
158: num => 99999);
159: --
160: -- For disabling the materialized view logs
161: --
163: --
164: -- This procedure performs a process to preserve materialized view data
165: -- needed for refresh. It must be called before a master table is reorganized
166: --
167: dbms_mview.begin_table_reorganization(tabowner => p_schema,
168: tabname => 'HRI_MAP_SUP_WRKFC_ASG');
169: --
170: END IF;
171: --