APPS.GL_JOURNAL_IMPORT_TAX_PKG dependencies on GL_JE_HEADERS

Line 88: FROM gl_je_headers

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)

Line 365: -- then update gl_je_headers details

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

Line 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;

Line 431: FROM gl_je_headers

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)

Line 708: -- then update gl_je_headers details

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

Line 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;