APPS.JTF_PF_CONV_PKG dependencies on DBMS_LOB

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

153: psize NUMBER;
154: offset NUMBER;
155: i NUMBER;
156: BEGIN
157: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
158: psize := 0;
159: IF(params IS NULL) THEN
160: RETURN paramCLOB;
161: END IF;

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

169: paramV := nv.NAME || '=' || nv.value;
170: END IF;
171: IF paramV IS NOT NULL THEN
172: psize := length(paramV);
173: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
174: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
175: END IF;
176: END LOOP;
177: RETURN paramCLOB;

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

170: END IF;
171: IF paramV IS NOT NULL THEN
172: psize := length(paramV);
173: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
174: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
175: END IF;
176: END LOOP;
177: RETURN paramCLOB;
178: END;

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

190: psize NUMBER;
191: offset NUMBER;
192: i NUMBER;
193: BEGIN
194: dbms_lob.createtemporary(paramCLOB,TRUE,DBMS_LOB.CALL);
195: psize := 0;
196: IF(params IS NULL) THEN
197: RETURN paramCLOB;
198: END IF;

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

206: paramV := nvs.NAME || '=' || nvl(nvs.value, 'JTF_PF_SZ:'||nvs.length) || ';';
207: END IF;
208: IF paramV IS NOT NULL THEN
209: psize := length(paramV);
210: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
211: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
212: END IF;
213: END LOOP;
214: RETURN paramCLOB;

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

207: END IF;
208: IF paramV IS NOT NULL THEN
209: psize := length(paramV);
210: offset := DBMS_LOB.GETLENGTH(paramClob) + 1;
211: DBMS_LOB.WRITE(paramCLOB,psize,offset,paramV);
212: END IF;
213: END LOOP;
214: RETURN paramCLOB;
215: END;