DBA Data[Home] [Help]

APPS.GL_CI_WORKFLOW_PKG dependencies on GL_CIT_NOTIFY_S

Line 481: SELECT gl_cit_notify_s.NEXTVAL

477: avalue => l_monitor_url);
478: End set_wf_variables;
479: FUNCTION get_unique_id RETURN NUMBER IS
480: CURSOR get_new_id IS
481: SELECT gl_cit_notify_s.NEXTVAL
482: FROM dual;
483: new_id number;
484: BEGIN
485: OPEN get_new_id;

Line 493: fnd_message.set_token('SEQUENCE', 'GL_CIT_NOTIFY_S');

489: return(new_id);
490: ELSE
491: CLOSE get_new_id;
492: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
493: fnd_message.set_token('SEQUENCE', 'GL_CIT_NOTIFY_S');
494: app_exception.raise_exception;
495: END IF;
496: EXCEPTION
497: WHEN app_exceptions.application_exception THEN