DBA Data[Home] [Help]

APPS.RA_CUSTOMER_TEXT_PKG dependencies on DBMS_LOB

Line 226: dbms_lob.writeappend(cl,len,sv);

222:
223: BEGIN
224: IF (nvl(lengthb(sv),0) + nvl(lengthb(vl),0)) >= 32000 THEN
225: len := nvl(lengthb(sv),0);
226: dbms_lob.writeappend(cl,len,sv);
227: sv := vl;
228: ELSE
229: sv := sv || vl;
230: END IF;

Line 350: --dbms_lob.writeappend(site_lob,lengthb(stvar),stvar);

346: END LOOP;
347: END LOOP;
348: --Bug 12665166
349: --Before appending stvar to site_lob, verifying length of stvar
350: --dbms_lob.writeappend(site_lob,lengthb(stvar),stvar);
351: IF length(stvar) <> 0 THEN
352: dbms_lob.writeappend(site_lob,nvl(length(stvar),0),stvar) ;
353: END IF;
354: END;

Line 352: dbms_lob.writeappend(site_lob,nvl(length(stvar),0),stvar) ;

348: --Bug 12665166
349: --Before appending stvar to site_lob, verifying length of stvar
350: --dbms_lob.writeappend(site_lob,lengthb(stvar),stvar);
351: IF length(stvar) <> 0 THEN
352: dbms_lob.writeappend(site_lob,nvl(length(stvar),0),stvar) ;
353: END IF;
354: END;
355:
356: Procedure site_info (