APPS.HR_WPM_MASS_SCORE_CARD_TRNSF dependencies on DBMS_LOB

Line 68: dbms_lob.trim(outLob,0);

64: IF inlob IS NULL OR outlob IS NULL THEN
65: RAISE_APPLICATION_ERROR(-20000,'Invalid lob locator (null value)');
66: END IF;
67: BEGIN
68: dbms_lob.trim(outLob,0);
69: npos := 0;
70: LOOP
71: nBuffSize := 32000;
72: dbms_lob.read(inlob,nbuffSize,nPos +1, vcBuff);

Line 72: dbms_lob.read(inlob,nbuffSize,nPos +1, vcBuff);

68: dbms_lob.trim(outLob,0);
69: npos := 0;
70: LOOP
71: nBuffSize := 32000;
72: dbms_lob.read(inlob,nbuffSize,nPos +1, vcBuff);
73: nPos := nPos + nBuffSize;
74: rBuff := vcBuff; -- utl_raw.CAST_to_raw(vcBuff);
75: nBuffSize := utl_raw.length(rBuff);
76: dbms_lob.writeappend(outLob, nBuffSize, rBuff);

Line 76: dbms_lob.writeappend(outLob, nBuffSize, rBuff);

72: dbms_lob.read(inlob,nbuffSize,nPos +1, vcBuff);
73: nPos := nPos + nBuffSize;
74: rBuff := vcBuff; -- utl_raw.CAST_to_raw(vcBuff);
75: nBuffSize := utl_raw.length(rBuff);
76: dbms_lob.writeappend(outLob, nBuffSize, rBuff);
77: END LOOP;
78: EXCEPTION WHEN NO_DATA_FOUND /* end of lob */ THEN
79: null;
80: END;

Line 345: dbms_lob.createtemporary(l_clob,true);

341: gt_lob(j+1).file_content_type := hr_transaction_swi.getVarchar2Value(n,'FileContentType',null);
342: gt_lob(j+1).oracle_charset := hr_transaction_swi.getVarchar2Value(n,'OracleCharset',null);
343: --dbms_output.put_line('file name:'||gt_lob(j+1).file_Name );
344: gt_lob(j+1).file_format := hr_transaction_swi.getVarchar2Value(n,'FileFormat',null);
345: dbms_lob.createtemporary(l_clob,true);
346: IF NOT xmldom.isnull(n) THEN
347: xmldom.writeToClob(n,l_clob);
348: END IF;
349: l_filestart := INSTR(l_clob,'')+10;

Line 353: dbms_lob.createtemporary(lb_filedata,true);

349: l_filestart := INSTR(l_clob,'')+10;
350: l_fileend := INSTR(l_clob,'')-1;
351: l_filedata:= SUBSTR(l_clob,l_filestart,(l_fileend-l_filestart)+1);
352: --
353: dbms_lob.createtemporary(lb_filedata,true);
354: --
355: clob_to_blob(l_filedata,lb_filedata);
356: gt_lob(j+1).file_data := lb_filedata;
357: --