DBA Data[Home] [Help]

APPS.CN_REASONS_PVT dependencies on DUAL

Line 80: FROM DUAL;

76: --
77: BEGIN
78: SELECT cn_reasons_s.NEXTVAL
79: INTO l_reasons_all_rec.reason_id
80: FROM DUAL;
81: EXCEPTION
82: WHEN OTHERS THEN
83: RAISE FND_API.G_EXC_ERROR;
84: END;

Line 219: FROM dual;

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);
222: --
223: cn_reasons_pkg.lock_update_row(l_reasons_all_rec);

Line 340: FROM dual;

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);
343: --
344: cn_reasons_pkg.delete_row(p_reason_id);