84: --
85: CURSOR je_headers (batch_id_in NUMBER)
86: IS
87: SELECT je_header_id,name,je_source,tax_status_code,ledger_id
88: FROM gl_je_headers
89: WHERE je_batch_id = batch_id_in
90: FOR UPDATE;
91: --
92: CURSOR je_lines (header_id_in NUMBER)
361: END LOOP;
362: CLOSE je_lines;
363: --
364: -- if any line has been updated for taxes in current header,
365: -- then update gl_je_headers details
366: --
367: IF l_je_header_tax_required = 1
368: THEN
369: UPDATE gl_je_headers
365: -- then update gl_je_headers details
366: --
367: IF l_je_header_tax_required = 1
368: THEN
369: UPDATE gl_je_headers
370: SET tax_status_code = 'R'
371: WHERE CURRENT OF je_headers;
372: l_batch_tax_required := 1;
373: END IF;
427: --
428: CURSOR je_headers (batch_id_in NUMBER)
429: IS
430: SELECT je_header_id,name,je_source,tax_status_code, ledger_id
431: FROM gl_je_headers
432: WHERE je_batch_id = batch_id_in
433: FOR UPDATE;
434: --
435: CURSOR je_lines (header_id_in NUMBER)
704: END LOOP;
705: CLOSE je_lines;
706: --
707: -- if any line has been updated for taxes in current header,
708: -- then update gl_je_headers details
709: --
710: IF l_je_header_tax_required = 1
711: THEN
712: UPDATE gl_je_headers
708: -- then update gl_je_headers details
709: --
710: IF l_je_header_tax_required = 1
711: THEN
712: UPDATE gl_je_headers
713: SET tax_status_code = 'R'
714: WHERE CURRENT OF je_headers;
715: --WHERE je_header_id = l_je_header_id;
716: l_batch_tax_required := 1;