630: --Get a unique value for the execution detail id
631: BEGIN
632: SELECT DPP_EXECUTION_DETAIL_ID_SEQ.nextval
633: INTO l_exe_dtl_id 634: FROM dual; 635:
636: EXCEPTION
637: WHEN NO_DATA_FOUND THEN
638: fnd_message.set_name('FND', 'SQL_PLSQL_ERROR');