APPS.FV_YE_CLOSE dependencies on GL_JE_BATCHES

Line 3184: l_je_batch_id gl_je_batches.je_batch_id%TYPE;

3180: vl_gl_source VARCHAR2(1024) ;
3181: posting_run_id NUMBER;
3182: L_ledger_id gl_ledgers.LEDGER_ID%type;
3183: interface_Ctrl_no NUMBER;
3184: l_je_batch_id gl_je_batches.je_batch_id%TYPE;
3185: single_led_id NUMBER;
3186: dummy NUMBER;
3187:
3188: CURSOR journal_entries_cur IS

Line 3788: select je_batch_id into l_je_batch_id from gl_je_batches where group_id = vg_jrnl_group_id ;

3784: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' THE vp_retcode IS '||vp_retcode);
3785: IF (vp_post_to_gl='Y' and vp_retcode <> 1) then
3786: begin
3787:
3788: select je_batch_id into l_je_batch_id from gl_je_batches where group_id = vg_jrnl_group_id ;
3789:
3790:
3791:
3792: Update gl_je_batches

Line 3792: Update gl_je_batches

3788: select je_batch_id into l_je_batch_id from gl_je_batches where group_id = vg_jrnl_group_id ;
3789:
3790:
3791:
3792: Update gl_je_batches
3793: set status = 'S', posting_run_id = je_batch_id where je_batch_id = l_je_batch_id;
3794:
3795: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3796: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' Batch ID IS '||l_je_batch_id);