APPS.AD_ZD_MVIEW dependencies on DBMS_LOB

Line 396: l_ddl := dbms_lob.substr(l_ddls(1).ddltext);

392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);
394:
395: if (l_ddls.count > 0) then
396: l_ddl := dbms_lob.substr(l_ddls(1).ddltext);
397: end if;
398:
399: log(c_module, 'PROCEDURE', 'end');
400: return l_ddl;

Line 1136: if (dbms_lob.compare(expand_query(l_mvq_text), l_mv_text) <> 0) then

1132: from ad_zd_clob
1133: where owner=l_owner and name=l_mvq_name;
1134:
1135: -- Compare query text, process if different
1136: if (dbms_lob.compare(expand_query(l_mvq_text), l_mv_text) <> 0) then
1137: log(c_module, 'STATEMENT', 'MV definition is out of date, revising...');
1138: process_mv(l_owner, p_mvname);
1139: else
1140: log(c_module, 'STATEMENT', 'MV definition is up to date');