APPS.GL_MOVEMERGE_REQUESTS_PKG dependencies on GL_MOVEMERGE_REQUESTS_S

Line 19: -- returns nextval from gl_movemerge_requests_s

15: --
16: -- Function
17: -- get_unique_id
18: -- Purpose
19: -- returns nextval from gl_movemerge_requests_s
20: -- Parameters
21: -- None
22: -- Notes
23: --

Line 26: SELECT gl_movemerge_requests_s.NEXTVAL

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

Line 38: fnd_message.set_token('SEQUENCE', 'GL_MOVEMERGE_REQUESTS_S');

34: return(new_id);
35: ELSE
36: CLOSE get_new_id;
37: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
38: fnd_message.set_token('SEQUENCE', 'GL_MOVEMERGE_REQUESTS_S');
39: app_exception.raise_exception;
40: END IF;
41: EXCEPTION
42: WHEN app_exceptions.application_exception THEN