DBA Data[Home] [Help]

APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_JE_BATCHES_S

Line 118: AND sequence_name = 'GL_JE_BATCHES_S';

114: SELECT order_flag
115: INTO seq_in_order
116: FROM dba_sequences
117: WHERE sequence_owner = schema
118: AND sequence_name = 'GL_JE_BATCHES_S';
119:
120: IF (seq_in_order = 'N') THEN
121: RAISE sequence_order_error;
122: END IF;

Line 156: SELECT GL_JE_BATCHES_S.nextval

152: END IF;
153:
154: -- Get a new max_batch_id and insert/update the history record
155: BEGIN
156: SELECT GL_JE_BATCHES_S.nextval
157: INTO new_max_batch_id
158: FROM dual;
159: EXCEPTION
160: WHEN others THEN

Line 220: 'SEQUENCE', 'GL_JE_BATCHES_S');

216: X_Retcode := '2';
217: WHEN get_sequence_error THEN
218: lock_op_succeeded := release_lock(X_Chart_Of_Accounts_Id);
219: GL_MESSAGE.write_log('SHRD0050', 2, 'ROUTINE', fn_name,
220: 'SEQUENCE', 'GL_JE_BATCHES_S');
221: GL_MESSAGE.func_fail(api_name || '.' || fn_name);
222: X_Retcode := '2';
223: WHEN user_lock_error THEN
224: GL_MESSAGE.write_log('MGTS0005', 1, 'USERLOCK', lock_name);