APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DBMS_MVIEW

Line 1219: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1215: BEGIN
1216:
1217: lv_task_start_time := SYSDATE;
1218: if (v_database_version >= 10) then
1219: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1220: lv_refresh_mode,
1221: atomic_refresh => FALSE,
1222: parallelism => pDegree);
1223: else

Line 1224: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1220: lv_refresh_mode,
1221: atomic_refresh => FALSE,
1222: parallelism => pDegree);
1223: else
1224: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1225: lv_refresh_mode,
1226: parallelism => pDegree);
1227: end if;
1228: lv_elapsed_mins := CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;

Line 1250: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1246: BEGIN
1247:
1248: lv_task_start_time := SYSDATE;
1249: if (v_database_version >= 10) then
1250: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1251: 'C',
1252: atomic_refresh => FALSE,
1253: parallelism => pDegree);
1254: else

Line 1255: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1251: 'C',
1252: atomic_refresh => FALSE,
1253: parallelism => pDegree);
1254: else
1255: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1256: 'C',
1257: parallelism => pDegree);
1258: end if;
1259: COMMIT;

Line 1306: DBMS_MVIEW.REFRESH (pSnapshot_List,

1302: BEGIN
1303:
1304: lv_task_start_time := SYSDATE;
1305:
1306: DBMS_MVIEW.REFRESH (pSnapshot_List,
1307: pRefresh_Param,
1308: atomic_refresh => TRUE,
1309: parallelism => pDegree);
1310: COMMIT;

Line 1959: DBMS_MVIEW.REFRESH ( lv_snapshot_str,lv_refresh_param,parallelism =>lv_DEGREE,atomic_refresh => TRUE);

1955: BEGIN
1956:
1957: lv_refresh_param := replace(lv_refresh_param, 'C', 'F');
1958: lv_refresh_param := replace(lv_refresh_param, '?', 'F');
1959: DBMS_MVIEW.REFRESH ( lv_snapshot_str,lv_refresh_param,parallelism =>lv_DEGREE,atomic_refresh => TRUE);
1960: COMMIT;
1961:
1962: RETCODE := G_SUCCESS;
1963:

Line 2403: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,

2399: --Refreshing the snapshot
2400: BEGIN
2401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Refreshing the snapshot : ' || lv_snap_str || ' in ' || lv_refresh_param || ' mode with degree ' || pDEGREE);
2402: if (v_database_version >= 10) then
2403: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,
2404: METHOD => lv_refresh_param,
2405: atomic_refresh => FALSE,
2406: parallelism => pDEGREE);
2407: else

Line 2408: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,

2404: METHOD => lv_refresh_param,
2405: atomic_refresh => FALSE,
2406: parallelism => pDEGREE);
2407: else
2408: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,
2409: METHOD => lv_refresh_param,
2410: parallelism => pDEGREE);
2411: end if;
2412: EXCEPTION