APPS.MRP_CL_REFRESH_SNAPSHOT dependencies on DBMS_MVIEW

Line 1260: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1256: BEGIN
1257:
1258: lv_task_start_time := SYSDATE;
1259: if (v_database_version >= 10) and (lv_refresh_mode = 'C') then -- bug 8997371
1260: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1261: lv_refresh_mode,
1262: atomic_refresh => FALSE,
1263: parallelism => pDegree);
1264: else

Line 1265: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1261: lv_refresh_mode,
1262: atomic_refresh => FALSE,
1263: parallelism => pDegree);
1264: else
1265: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1266: lv_refresh_mode,
1267: parallelism => pDegree);
1268: end if;
1269: lv_elapsed_mins := CEIL((SYSDATE- lv_task_start_time)*14400.0)/10;

Line 1295: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1291: BEGIN
1292:
1293: lv_task_start_time := SYSDATE;
1294: if (v_database_version >= 10) then
1295: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1296: 'C',
1297: atomic_refresh => FALSE,
1298: parallelism => pDegree);
1299: else

Line 1300: DBMS_MVIEW.REFRESH(lv_snapshot_name,

1296: 'C',
1297: atomic_refresh => FALSE,
1298: parallelism => pDegree);
1299: else
1300: DBMS_MVIEW.REFRESH(lv_snapshot_name,
1301: 'C',
1302: parallelism => pDegree);
1303: end if;
1304: COMMIT;

Line 1351: DBMS_MVIEW.REFRESH (pSnapshot_List,

1347: BEGIN
1348:
1349: lv_task_start_time := SYSDATE;
1350:
1351: DBMS_MVIEW.REFRESH (pSnapshot_List,
1352: pRefresh_Param,
1353: atomic_refresh => TRUE,
1354: parallelism => pDegree);
1355: COMMIT;

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

2163: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_refresh_param: '
2164: || lv_refresh_param);
2165: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'lv_DEGREE: '
2166: || to_char(lv_DEGREE));
2167: DBMS_MVIEW.REFRESH ( lv_snapshot_str,lv_refresh_param,parallelism =>lv_DEGREE,atomic_refresh => TRUE);
2168: COMMIT;
2169:
2170:
2171: lv_snapshot_str_tmp := lv_snapshot_str;

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

2819: --Refreshing the snapshot
2820: BEGIN
2821: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'Refreshing the snapshot : ' || lv_snap_str || ' in ' || lv_refresh_param || ' mode with degree ' || pDEGREE);
2822: if (v_database_version >= 10) then
2823: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,
2824: METHOD => lv_refresh_param,
2825: atomic_refresh => FALSE,
2826: parallelism => pDEGREE);
2827: else

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

2824: METHOD => lv_refresh_param,
2825: atomic_refresh => FALSE,
2826: parallelism => pDEGREE);
2827: else
2828: DBMS_MVIEW.REFRESH(LIST => lv_snap_str,
2829: METHOD => lv_refresh_param,
2830: parallelism => pDEGREE);
2831:
2832: end if;