DBA Data[Home] [Help]

APPS.JTF_PF_CONV_PKG dependencies on DBMS_LOB

Line 217: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);

213: psize NUMBER;
214: offset NUMBER;
215: i NUMBER;
216: BEGIN
217: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
218: psize := 0;
219: IF(params IS NULL) THEN
220: RETURN paramCLOB;
221: END IF;

Line 233: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;

229: paramV := nv.NAME || '=' || nv.value;
230: END IF;
231: IF paramV IS NOT NULL THEN
232: psize := length(paramV);
233: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
234: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
235: END IF;
236: END LOOP;
237: RETURN paramCLOB;

Line 234: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);

230: END IF;
231: IF paramV IS NOT NULL THEN
232: psize := length(paramV);
233: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
234: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
235: END IF;
236: END LOOP;
237: RETURN paramCLOB;
238: END;

Line 253: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);

249: psize NUMBER;
250: offset NUMBER;
251: i NUMBER;
252: BEGIN
253: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
254: psize := 0;
255: IF(params IS NULL) THEN
256: RETURN paramCLOB;
257: END IF;

Line 271: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;

267: || ';';
268: END IF;
269: IF paramV IS NOT NULL THEN
270: psize := length(paramV);
271: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
272: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
273: END IF;
274: END LOOP;
275: RETURN paramCLOB;

Line 272: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);

268: END IF;
269: IF paramV IS NOT NULL THEN
270: psize := length(paramV);
271: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
272: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
273: END IF;
274: END LOOP;
275: RETURN paramCLOB;
276: END;