DBA Data[Home] [Help]

APPS.GL_JE_CATEGORIES_PKG dependencies on GL_JE_CATEGORIES_S

Line 108: SELECT gl_je_categories_s.NEXTVAL

104: -- ************************************************************************
105:
106: FUNCTION get_unique_id RETURN NUMBER IS
107: CURSOR c_getid IS
108: SELECT gl_je_categories_s.NEXTVAL
109: FROM dual;
110: id number;
111:
112: BEGIN

Line 122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');

118: RETURN( id );
119: ELSE
120: CLOSE c_getid;
121: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
122: fnd_message.set_token('SEQUENCE', 'gl_je_categories_s');
123: app_exception.raise_exception;
124: END IF;
125:
126: EXCEPTION

Line 583: SELECT gl_je_categories_s.NEXTVAL

579:
580: begin
581: /* When je_category_name is null, we assume it to be a new row. */
582: if (X_je_category_name is null) then
583: SELECT gl_je_categories_s.NEXTVAL
584: INTO X_je_category_name
585: FROM dual;
586: raise no_data_found;
587: end if;