APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on DBMS_LOB

Line 395: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN

391: and language = userenv('LANG');
392: -- Convert the CLOB to a varchar2 in order for workflow to accept it
393: -- Only convert the Clob to a varchar2 if it isn't empty,
394: -- otherwise a NO_DATA_FOUND exception would be thrown.
395: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
396: -- amount will be over written by read call, so need to reset it every time
397: l_amount := l_description_size_limit;
398: dbms_lob.read( l_brief_description_clob
399: , l_amount

Line 398: dbms_lob.read( l_brief_description_clob

394: -- otherwise a NO_DATA_FOUND exception would be thrown.
395: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
396: -- amount will be over written by read call, so need to reset it every time
397: l_amount := l_description_size_limit;
398: dbms_lob.read( l_brief_description_clob
399: , l_amount
400: , 1
401: , l_brief_description_v2
402: );

Line 490: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN

486: and language = userenv('LANG');
487: -- Convert the CLOB to a varchar2 in order for workflow to accept it
488: -- Only convert the Clob to a varchar2 if it isn't empty,
489: -- otherwise a NO_DATA_FOUND exception would be thrown.
490: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
491: -- amount will be over written by read call, so need to reset it every time
492: l_amount := l_description_size_limit;
493: dbms_lob.read( l_brief_description_clob
494: , l_amount

Line 493: dbms_lob.read( l_brief_description_clob

489: -- otherwise a NO_DATA_FOUND exception would be thrown.
490: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
491: -- amount will be over written by read call, so need to reset it every time
492: l_amount := l_description_size_limit;
493: dbms_lob.read( l_brief_description_clob
494: , l_amount
495: , 1
496: , l_brief_description_v2
497: );