DBA Data[Home] [Help]

APPS.GL_ELIMINATION_JOURNALS_PKG dependencies on GL_ELIMINATION_JOURNALS_S

Line 15: -- Returns nextval from gl_elimination_journals_s

11:
12: -- Function
13: -- get_unique_id
14: -- Purpose
15: -- Returns nextval from gl_elimination_journals_s
16: -- Parameters
17: -- None
18: -- Notes
19: --

Line 23: SELECT gl_elimination_journals_s.NEXTVAL

19: --
20: FUNCTION get_unique_id RETURN NUMBER IS
21:
22: CURSOR get_new_id IS
23: SELECT gl_elimination_journals_s.NEXTVAL
24: FROM dual;
25: new_id number;
26:
27: BEGIN

Line 37: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_JOURNALS_S');

33: return(new_id);
34: ELSE
35: CLOSE get_new_id;
36: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
37: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_JOURNALS_S');
38: app_exception.raise_exception;
39: END IF;
40:
41: EXCEPTION