DBA Data[Home] [Help]

APPS.GL_ELIMINATION_SETS_PKG dependencies on GL_ELIMINATION_SETS_S

Line 15: -- Returns nextval from gl_elimination_sets_s

11:
12: -- Function
13: -- get_unique_id
14: -- Purpose
15: -- Returns nextval from gl_elimination_sets_s
16: -- Parameters
17: -- None
18: -- History
19: -- 11-06-1998 W Wong Created

Line 26: SELECT gl_elimination_sets_s.NEXTVAL

22: --
23: FUNCTION get_unique_id RETURN NUMBER IS
24:
25: CURSOR get_new_id IS
26: SELECT gl_elimination_sets_s.NEXTVAL
27: FROM dual;
28: new_id number;
29:
30: BEGIN

Line 40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');

36: return(new_id);
37: ELSE
38: CLOSE get_new_id;
39: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
40: fnd_message.set_token('SEQUENCE', 'GL_ELIMINATION_SETS_S');
41: app_exception.raise_exception;
42: END IF;
43:
44: EXCEPTION