DBA Data[Home] [Help]

APPS.CN_SCA_DENORM_RULES_PVT dependencies on DBMS_MVIEW

Line 341: /* bug 13504898 DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);

337: WHERE transaction_source = p_txn_src
338: AND org_id = p_org_id;
339: debugmsg('Rules Sync : Deleted denorm rule count : '||SQL%ROWCOUNT);
340: debugmsg('Rules Sync : 12.2 - MV is converted to view - no refresh process');
341: /* bug 13504898 DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
342: debugmsg('Rules Sync : Refreshing MV completed');
343: */
344: COMMIT;
345: EXCEPTION

Line 519: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);

515: /* Check introduced for bug14374323 */
516:
517: IF (ad_zd.get_edition('PATCH') IS NULL) THEN
518: BEGIN
519: DBMS_MVIEW.REFRESH('CN_SCA_RULE_COND_VALS_MV','C','',TRUE,FALSE,0,4,0,TRUE);
520: EXCEPTION
521: WHEN OTHERS THEN
522: debugmsg('Results Transfer : Unexpected exception');
523: RAISE;