DBA Data[Home] [Help]

APPS.HRI_OPL_SUP_WRKFC_ASG dependencies on DBMS_MVIEW

Line 145: dbms_mview.purge_log(master => p_schema || '.HRI_MAP_SUP_WRKFC_ASG'

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

Line 152: dbms_mview.end_table_reorganization(tabowner => p_schema

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: --

Line 157: dbms_mview.purge_log(master => p_schema || '.HRI_MAP_SUP_WRKFC_ASG',

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: --

Line 167: dbms_mview.begin_table_reorganization(tabowner => p_schema,

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: --