APPS.JTF_USR_HKS dependencies on DBMS_LOB

Line 926: dbms_lob.createtemporary( l_hdr_XML, true, dbms_lob.call);

922: -- dbms_output.put_line(' generate header xml :' ||chr(10)||l_hdrXML_str );
923:
924: l_hdrXML_len := length(l_hdrXML_str);
925: -- dbms_output.put_line(' getting length');
926: dbms_lob.createtemporary( l_hdr_XML, true, dbms_lob.call);
927: -- dbms_output.put_line(' creating temp lob');
928: dbms_lob.write( l_hdr_XML, l_hdrXML_len, 1, l_hdrXML_str);
929: -- dbms_output.put_line(' after writting to lob');
930:

Line 928: dbms_lob.write( l_hdr_XML, l_hdrXML_len, 1, l_hdrXML_str);

924: l_hdrXML_len := length(l_hdrXML_str);
925: -- dbms_output.put_line(' getting length');
926: dbms_lob.createtemporary( l_hdr_XML, true, dbms_lob.call);
927: -- dbms_output.put_line(' creating temp lob');
928: dbms_lob.write( l_hdr_XML, l_hdrXML_len, 1, l_hdrXML_str);
929: -- dbms_output.put_line(' after writting to lob');
930:
931: /* Set bind variables */
932:

Line 949: dbms_lob.read(l_msg_SQL,amount,position,charstr);

945:
946: /*
947: begin
948: loop
949: dbms_lob.read(l_msg_SQL,amount,position,charstr);
950: dbms_output.put_line(charstr);
951: position := position + amount;
952: end loop;
953: exception

Line 958: dbms_lob.createtemporary( l_msg_SQL_lob, true, dbms_lob.call);

954: when NO_DATA_FOUND then
955: null;
956: end;
957:
958: dbms_lob.createtemporary( l_msg_SQL_lob, true, dbms_lob.call);
959: l_msg_SQL_len := dbms_lob.getlength(l_msg_SQL);
960: dbms_lob.copy( l_msg_SQL_lob, l_msg_SQL, l_msg_SQL_len, 1, 1);
961: */
962:

Line 959: l_msg_SQL_len := dbms_lob.getlength(l_msg_SQL);

955: null;
956: end;
957:
958: dbms_lob.createtemporary( l_msg_SQL_lob, true, dbms_lob.call);
959: l_msg_SQL_len := dbms_lob.getlength(l_msg_SQL);
960: dbms_lob.copy( l_msg_SQL_lob, l_msg_SQL, l_msg_SQL_len, 1, 1);
961: */
962:
963:

Line 960: dbms_lob.copy( l_msg_SQL_lob, l_msg_SQL, l_msg_SQL_len, 1, 1);

956: end;
957:
958: dbms_lob.createtemporary( l_msg_SQL_lob, true, dbms_lob.call);
959: l_msg_SQL_len := dbms_lob.getlength(l_msg_SQL);
960: dbms_lob.copy( l_msg_SQL_lob, l_msg_SQL, l_msg_SQL_len, 1, 1);
961: */
962:
963:
964: l_msg_XML := DBMS_XMLQUERY.getXML ( ctxHdl => queryCtx,

Line 972: dbms_lob.read(l_msg_XML,amount,position,charstr);

968: /*
969: position := 1;
970: begin
971: loop
972: dbms_lob.read(l_msg_XML,amount,position,charstr);
973: dbms_output.put_line(charstr);
974: position := position + amount;
975: end loop;
976: exception