APPS.XLA_AE_CODE_COMBINATION_PKG dependencies on XLA_AE_HEADERS_GT

Line 2555: xla_ae_headers_gt hdr

2551: hdr.ledger_id ledger_id,
2552: hdr.ae_header_id ae_header_id,
2553: temp.ae_line_num ae_line_num
2554: FROM xla_ae_lines_gt temp,
2555: xla_ae_headers_gt hdr
2556: WHERE temp.ae_header_id = hdr.ae_header_id
2557: AND temp.ccid_coa_id = p_chart_of_accounts_id
2558: AND nvl(temp.segment1 ,'#') = nvl(p_segment1,'#')
2559: AND nvl(temp.segment2 ,'#') = nvl(p_segment2,'#')

Line 3237: xla_ae_headers_gt hdr

3233: hdr.ledger_id ledger_id,
3234: hdr.ae_header_id ae_header_id,
3235: lns.code_combination_id ccid
3236: FROM xla_ae_lines_gt lns,
3237: xla_ae_headers_gt hdr
3238: WHERE lns.ae_header_id = hdr.ae_header_id
3239: AND lns.code_combination_id <> -1
3240: AND lns.code_combination_status_code = C_INVALID
3241: AND lns.balance_type_code <> 'X'

Line 3255: xla_ae_headers_gt hdr

3251: hdr.ledger_id ledger_id,
3252: hdr.ae_header_id ae_header_id,
3253: lns.alt_code_combination_id ccid
3254: FROM xla_ae_lines_gt lns,
3255: xla_ae_headers_gt hdr
3256: WHERE lns.ae_header_id = hdr.ae_header_id
3257: AND lns.alt_code_combination_id <> -1
3258: AND lns.alt_ccid_status_code = C_INVALID
3259: AND lns.balance_type_code <> 'X'

Line 5651: UPDATE xla_ae_headers_gt xahg

5647: --
5648: -- commented bug 13023651
5649: /*IF l_ccid_created > 0 THEN
5650:
5651: UPDATE xla_ae_headers_gt xahg
5652: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5653: WHERE xahg.ae_header_id IN (SELECT xalg.ae_header_id
5654: FROM xla_ae_lines_gt xalg
5655: WHERE xalg.balance_type_code <> 'X'

Line 5670: UPDATE xla_ae_headers_gt xahg

5666:
5667: -- added bug 13023651 modified Update such that journal entries which are unable to derive ccid would be marked in error,related entries should not be marked as invalid.
5668: IF l_ccid_created > 0 THEN
5669:
5670: UPDATE xla_ae_headers_gt xahg
5671: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5672: WHERE (xahg.ae_header_id , NVL(xahg.header_num,0) , xahg.balance_type_code , xahg.ledger_id ) IN (
5673: SELECT xalg.ae_header_id , NVL(xalg.header_num, 0) , xalg.balance_type_code , xalg.ledger_id
5674: FROM xla_ae_lines_gt xalg

Line 5685: (p_msg => 'SQL - Update xla_ae_headers_gt '

5681: -- end bug 13023651
5682: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5683:
5684: trace
5685: (p_msg => 'SQL - Update xla_ae_headers_gt '
5686: ,p_level => C_LEVEL_STATEMENT
5687: ,p_module => l_log_module);
5688: trace
5689: (p_msg => '# of rows updated into xla_ae_headers_gt = '||SQL%ROWCOUNT

Line 5689: (p_msg => '# of rows updated into xla_ae_headers_gt = '||SQL%ROWCOUNT

5685: (p_msg => 'SQL - Update xla_ae_headers_gt '
5686: ,p_level => C_LEVEL_STATEMENT
5687: ,p_module => l_log_module);
5688: trace
5689: (p_msg => '# of rows updated into xla_ae_headers_gt = '||SQL%ROWCOUNT
5690: ,p_level => C_LEVEL_STATEMENT
5691: ,p_module => l_log_module);
5692:
5693: END IF;