APPS.AD_ZD_PREP dependencies on DBMS_LOB

Line 768: if(dbms_lob.istemporary(l_ddl) =1 ) then

764: -- Shall we raise an error from here?
765: raise_application_error(-20996,
766: 'dbms_metadata returned null for User-Defined-Type Specification: ' ||x_owner||'.'||x_name);
767: end if;
768: if(dbms_lob.istemporary(l_ddl) =1 ) then
769: dbms_lob.freetemporary(l_ddl);
770: end if;
771:
772: -- STEP#2 Follow same steps for OBJECT Body

Line 769: dbms_lob.freetemporary(l_ddl);

765: raise_application_error(-20996,
766: 'dbms_metadata returned null for User-Defined-Type Specification: ' ||x_owner||'.'||x_name);
767: end if;
768: if(dbms_lob.istemporary(l_ddl) =1 ) then
769: dbms_lob.freetemporary(l_ddl);
770: end if;
771:
772: -- STEP#2 Follow same steps for OBJECT Body
773: dm_h := dbms_metadata.open('TYPE');

Line 796: if(dbms_lob.istemporary(l_ddl) =1 ) then

792: else
793: log(l_module, 'STATEMENT', 'dbms_metadata returned null for User-Defined-Type Body: '||x_owner||'.'||x_name );
794: end if;
795:
796: if(dbms_lob.istemporary(l_ddl) =1 ) then
797: dbms_lob.freetemporary(l_ddl);
798: end if;
799:
800: -- Grant execute priviledge to

Line 797: dbms_lob.freetemporary(l_ddl);

793: log(l_module, 'STATEMENT', 'dbms_metadata returned null for User-Defined-Type Body: '||x_owner||'.'||x_name );
794: end if;
795:
796: if(dbms_lob.istemporary(l_ddl) =1 ) then
797: dbms_lob.freetemporary(l_ddl);
798: end if;
799:
800: -- Grant execute priviledge to
801: exec(x_sql => 'GRANT EXECUTE ON "'||x_new_owner||'"."'||x_name||'" to PUBLIC', x_log_mod => l_module, x_ignore=>true);