498: RAISE REQUEST_FAILED;
499: END IF;
500:
501: -- Update the status of the consolidation batch to 'PS' in
502: -- gl_consolidation_history for Consolidation Workbench.
503: UPDATE GL_CONSOLIDATION_HISTORY
504: SET status = 'PS',
505: request_id = v_request_id
506: WHERE je_batch_id IN (SELECT je_batch_id
499: END IF;
500:
501: -- Update the status of the consolidation batch to 'PS' in
502: -- gl_consolidation_history for Consolidation Workbench.
503: UPDATE GL_CONSOLIDATION_HISTORY
504: SET status = 'PS',
505: request_id = v_request_id
506: WHERE je_batch_id IN (SELECT je_batch_id
507: FROM gl_je_batches