DBA Data[Home] [Help]

APPS.CN_REASONS_PVT dependencies on CN_REASON_HISTORY_S

Line 217: SELECT cn_reason_history_s.NEXTVAL

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
219: FROM dual;
220: --
221: cn_reason_history_pkg.insert_row(l_history_rec);

Line 338: SELECT cn_reason_history_s.NEXTVAL

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
340: FROM dual;
341: --
342: cn_reason_history_pkg.insert_row(l_history_rec);