APPS.CN_REASONS_PUB dependencies on DBMS_LOB

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

152: x_notes_tbl(l_tbl_count).last_updated_username := rec.user_name;
153: x_notes_tbl(l_tbl_count).object_version_number := rec.object_version_number;
154: -- Processing CLOB
155: l_clob_loc := rec.reason;
156: l_clob_length := dbms_lob.getlength(l_clob_loc);
157: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);
158: -- End of CLOB processing
159: END IF;
160: END LOOP;

Line 157: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);

153: x_notes_tbl(l_tbl_count).object_version_number := rec.object_version_number;
154: -- Processing CLOB
155: l_clob_loc := rec.reason;
156: l_clob_length := dbms_lob.getlength(l_clob_loc);
157: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);
158: -- End of CLOB processing
159: END IF;
160: END LOOP;
161: x_notes_count := l_total_rows;

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

511: x_notes_tbl(l_tbl_count).last_updated_username := rec.user_name;
512: x_notes_tbl(l_tbl_count).object_version_number := rec.object_version_number;
513: -- Processing CLOB
514: l_clob_loc := rec.reason;
515: l_clob_length := dbms_lob.getlength(l_clob_loc);
516: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);
517: -- End of CLOB processing
518:
519: l_tbl_count := l_tbl_count + 1;

Line 516: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);

512: x_notes_tbl(l_tbl_count).object_version_number := rec.object_version_number;
513: -- Processing CLOB
514: l_clob_loc := rec.reason;
515: l_clob_length := dbms_lob.getlength(l_clob_loc);
516: dbms_lob.read(l_clob_loc,l_clob_length,1,x_notes_tbl(l_tbl_count).reason);
517: -- End of CLOB processing
518:
519: l_tbl_count := l_tbl_count + 1;
520: END LOOP;