DBA Data[Home] [Help]

APPS.GL_ENCUMBRANCE_TYPES_PKG dependencies on GL_ENCUMBRANCE_TYPES_S

Line 36: 'gl_encumbrance_types.select_row');

32: RAISE;
33: WHEN OTHERS THEN
34: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
35: fnd_message.set_token('PROCEDURE',
36: 'gl_encumbrance_types.select_row');
37: RAISE;
38: END select_row;
39:
40:

Line 108: SELECT gl_encumbrance_types_s.NEXTVAL

104:
105:
106: PROCEDURE get_unique_id (x_encumbrance_type_id IN OUT NOCOPY NUMBER) IS
107: CURSOR get_new_id IS
108: SELECT gl_encumbrance_types_s.NEXTVAL
109: FROM dual;
110: new_id number;
111: BEGIN
112: OPEN get_new_id;

Line 120: fnd_message.set_token('SEQUENCE', 'GL_ENCUMBRANCE_TYPES_S');

116: CLOSE get_new_id;
117: ELSE
118: CLOSE get_new_id;
119: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
120: fnd_message.set_token('SEQUENCE', 'GL_ENCUMBRANCE_TYPES_S');
121: app_exception.raise_exception;
122: END IF;
123:
124: EXCEPTION

Line 153: 'gl_encumbrance_types.select_columns');

149: RAISE;
150: WHEN OTHERS THEN
151: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
152: fnd_message.set_token('PROCEDURE',
153: 'gl_encumbrance_types.select_columns');
154: RAISE;
155: END select_columns;
156:
157:

Line 207: SELECT gl_encumbrance_types_s.nextval

203:
204: current_sequence NUMBER := 0;
205: BEGIN
206: IF (x_encumbrance_type_id IS NULL) THEN
207: SELECT gl_encumbrance_types_s.nextval
208: INTO x_encumbrance_type_id
209: FROM dual;
210: END IF;
211: