APPS.IRC_DOC_UTIL dependencies on DBMS_LOB

Line 101: l_doc_length:=dbms_lob.getlength(l_doc);

97: end if;
98: --
99: -- find the end position
100: --
101: l_doc_length:=dbms_lob.getlength(l_doc);
102: if vOffsetTable(1).offset+75>l_doc_length then
103: l_pos_end1:=l_doc_length;
104: else
105: -- find the space after 75 characters after the hit

Line 109: l_text:=dbms_lob.substr(l_doc,(l_pos_end1-l_pos_start1),l_pos_start1);

105: -- find the space after 75 characters after the hit
106: l_pos_end1:=vOffsetTable(1).offset+75;
107: end if;
108: --
109: l_text:=dbms_lob.substr(l_doc,(l_pos_end1-l_pos_start1),l_pos_start1);
110: --
111: vTeaserLine:=vTeaserLine||substr(l_text,1,(vOffsetTable(1).offset-l_pos_start1))||IRC_DOC_UTIL.MARKUP_START_TAG
112: ||substr(l_text,(vOffsetTable(1).offset-l_pos_start1+1),vOffsetTable(1).length)||IRC_DOC_UTIL.MARKUP_END_TAG;
113: --

Line 151: l_text:=dbms_lob.substr(l_doc,(l_pos_end2-l_pos_start2),l_pos_start2);

147: else
148: -- find the space after 75 characters after the hit
149: l_pos_end2:=vOffsetTable(vCounter).offset+75;
150: end if;
151: l_text:=dbms_lob.substr(l_doc,(l_pos_end2-l_pos_start2),l_pos_start2);
152: --
153: vTeaserLine:=vTeaserLine||substr(l_text,1,(vOffsetTable(vCounter).offset-l_pos_start2))||IRC_DOC_UTIL.MARKUP_START_TAG
154: ||substr(l_text,(vOffsetTable(vCounter).offset-l_pos_start2+1),vOffsetTable(vCounter).length)||IRC_DOC_UTIL.MARKUP_END_TAG;
155: --