APPS.ECX_ENG_UTILS dependencies on DBMS_LOB

Line 404: l_in_clob_len := dbms_lob.getlength(p_clob);

400: if (p_clob is null) then
401: return;
402: end if;
403:
404: l_in_clob_len := dbms_lob.getlength(p_clob);
405: if (l_in_clob_len = 0) then
406: return;
407: end if;
408:

Line 415: dbms_lob.createtemporary(x_clob, true, dbms_lob.session);

411: l_end_code := ecx_eng_utils.PWD_SPEC_CODE;
412: l_end_code_len := length(l_end_code);
413:
414: if (x_clob is null) then
415: dbms_lob.createtemporary(x_clob, true, dbms_lob.session);
416: end if;
417:
418: loop
419: if (l_offset >= l_in_clob_len) then

Line 424: l_start_code_pos := dbms_lob.instr(p_clob, l_start_code, l_offset);

420: exit;
421: end if;
422:
423: -- Get the start offset of special character field.
424: l_start_code_pos := dbms_lob.instr(p_clob, l_start_code, l_offset);
425:
426: if(l_statementEnabled) then
427: ecx_debug.log(l_statement,'l_start_code_pos', l_start_code_pos,i_method_name);
428: end if;

Line 432: dbms_lob.copy(x_clob, p_clob, l_in_clob_len - l_offset + 1,

428: end if;
429:
430: -- if cannot find the special char anymore, then write the rest of the clob.
431: if (l_start_code_pos = 0 or l_start_code_pos is null) then
432: dbms_lob.copy(x_clob, p_clob, l_in_clob_len - l_offset + 1,
433: dbms_lob.getlength(x_clob)+1, l_offset);
434: exit;
435: else
436: -- write all the data that is before the special code.

Line 433: dbms_lob.getlength(x_clob)+1, l_offset);

429:
430: -- if cannot find the special char anymore, then write the rest of the clob.
431: if (l_start_code_pos = 0 or l_start_code_pos is null) then
432: dbms_lob.copy(x_clob, p_clob, l_in_clob_len - l_offset + 1,
433: dbms_lob.getlength(x_clob)+1, l_offset);
434: exit;
435: else
436: -- write all the data that is before the special code.
437: l_amount := l_start_code_pos - l_offset;

Line 439: dbms_lob.copy(x_clob, p_clob, l_amount,

435: else
436: -- write all the data that is before the special code.
437: l_amount := l_start_code_pos - l_offset;
438: if (l_amount > 0) then
439: dbms_lob.copy(x_clob, p_clob, l_amount,
440: dbms_lob.getlength(x_clob)+1, l_offset);
441: end if;
442:
443: -- find the end of the special code and figure out the special string.

Line 440: dbms_lob.getlength(x_clob)+1, l_offset);

436: -- write all the data that is before the special code.
437: l_amount := l_start_code_pos - l_offset;
438: if (l_amount > 0) then
439: dbms_lob.copy(x_clob, p_clob, l_amount,
440: dbms_lob.getlength(x_clob)+1, l_offset);
441: end if;
442:
443: -- find the end of the special code and figure out the special string.
444: l_end_code_pos := dbms_lob.instr(p_clob, l_end_code,

Line 444: l_end_code_pos := dbms_lob.instr(p_clob, l_end_code,

440: dbms_lob.getlength(x_clob)+1, l_offset);
441: end if;
442:
443: -- find the end of the special code and figure out the special string.
444: l_end_code_pos := dbms_lob.instr(p_clob, l_end_code,
445: l_start_code_pos + l_start_code_len);
446:
447: if(l_statementEnabled) then
448: ecx_debug.log(l_statement,'l_end_code_pos', l_end_code_pos,i_method_name);

Line 456: l_spec_str := dbms_lob.substr(p_clob, l_spec_str_len,

452: if (l_spec_str_len > 0) then
453: -- we assume that between two special set of character is the
454: -- password and this need to be call the ecx_data_encrypt.
455: -- get the string between two set of special characters.
456: l_spec_str := dbms_lob.substr(p_clob, l_spec_str_len,
457: l_start_code_pos + l_start_code_len);
458:
459: l_out_string := l_spec_str;
460: ecx_print_local.replace_spec_char(p_value => l_out_string,

Line 489: dbms_lob.writeappend(x_clob, length(l_spec_str), l_spec_str);

485:
486: ecx_print_local.escape_spec_char(p_value => l_out_string,
487: x_value => l_spec_str);
488:
489: dbms_lob.writeappend(x_clob, length(l_spec_str), l_spec_str);
490: end if;
491:
492: l_offset := l_end_code_pos + l_end_code_len;
493: end if;