APPS.CN_REASONS_PVT dependencies on DBMS_LOB

Line 213: l_clob_length := dbms_lob.getlength(l_clob_loc);

209: l_history_rec.attribute14 := rec.attribute14;
210: l_history_rec.attribute15 := rec.attribute15;
211: -- Processing CLOB
212: l_clob_loc := rec.reason;
213: l_clob_length := dbms_lob.getlength(l_clob_loc);
214: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);
215: -- End of CLOB processing
216: -- Get reason_history_id from the SEQUENCE.
217: SELECT cn_reason_history_s.NEXTVAL

Line 214: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);

210: l_history_rec.attribute15 := rec.attribute15;
211: -- Processing CLOB
212: l_clob_loc := rec.reason;
213: l_clob_length := dbms_lob.getlength(l_clob_loc);
214: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);
215: -- End of CLOB processing
216: -- Get reason_history_id from the SEQUENCE.
217: SELECT cn_reason_history_s.NEXTVAL
218: INTO l_history_rec.reason_history_id

Line 334: l_clob_length := dbms_lob.getlength(l_clob_loc);

330: l_history_rec.attribute14 := rec.attribute14;
331: l_history_rec.attribute15 := rec.attribute15;
332: -- Processing CLOB
333: l_clob_loc := rec.reason;
334: l_clob_length := dbms_lob.getlength(l_clob_loc);
335: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);
336: -- End of CLOB processing
337: -- Get reason_history_id from the SEQUENCE.
338: SELECT cn_reason_history_s.NEXTVAL

Line 335: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);

331: l_history_rec.attribute15 := rec.attribute15;
332: -- Processing CLOB
333: l_clob_loc := rec.reason;
334: l_clob_length := dbms_lob.getlength(l_clob_loc);
335: dbms_lob.read(l_clob_loc,l_clob_length,1,l_history_rec.reason);
336: -- End of CLOB processing
337: -- Get reason_history_id from the SEQUENCE.
338: SELECT cn_reason_history_s.NEXTVAL
339: INTO l_history_rec.reason_history_id