DBA Data[Home] [Help]

APPS.IRC_VACANCY_CONSIDERATIONS_API dependencies on DBMS_LOB

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

128: || l_name
129: || '';
130:
131: -- Convert the clob to a v2 so that wf can display it.
132: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
133: dbms_lob.read( l_brief_description_clob
134: , l_amount
135: , 1
136: , l_brief_description_v2

Line 133: dbms_lob.read( l_brief_description_clob

129: || '';
130:
131: -- Convert the clob to a v2 so that wf can display it.
132: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
133: dbms_lob.read( l_brief_description_clob
134: , l_amount
135: , 1
136: , l_brief_description_v2
137: );

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

280: || '&p_svid='||to_char(p_vacancy_id)
281: || '&p_spid='||to_char(l_posting_content_id);
282:
283: -- Convert the clob to a v2 so that wf can display it.
284: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
285: dbms_lob.read( l_brief_description_clob
286: , l_amount
287: , 1
288: , l_brief_description_v2

Line 285: dbms_lob.read( l_brief_description_clob

281: || '&p_spid='||to_char(l_posting_content_id);
282:
283: -- Convert the clob to a v2 so that wf can display it.
284: IF (dbms_lob.getlength(l_brief_description_clob) > 0) THEN
285: dbms_lob.read( l_brief_description_clob
286: , l_amount
287: , 1
288: , l_brief_description_v2
289: );