APPS.XLA_AE_CODE_COMBINATION_PKG dependencies on XLA_AE_HEADERS_GT

Line 2546: xla_ae_headers_gt hdr

2542: hdr.entity_id entity_id,
2543: hdr.ledger_id ledger_id,
2544: hdr.ae_header_id ae_header_id
2545: FROM xla_ae_lines_gt temp,
2546: xla_ae_headers_gt hdr
2547: WHERE temp.ae_header_id = hdr.ae_header_id
2548: AND temp.ccid_coa_id = p_chart_of_accounts_id
2549: AND nvl(temp.segment1 ,'#') = nvl(p_segment1,'#')
2550: AND nvl(temp.segment2 ,'#') = nvl(p_segment2,'#')

Line 3227: xla_ae_headers_gt hdr

3223: hdr.ledger_id ledger_id,
3224: hdr.ae_header_id ae_header_id,
3225: lns.code_combination_id ccid
3226: FROM xla_ae_lines_gt lns,
3227: xla_ae_headers_gt hdr
3228: WHERE lns.ae_header_id = hdr.ae_header_id
3229: AND lns.code_combination_id <> -1
3230: AND lns.code_combination_status_code = C_INVALID
3231: AND lns.balance_type_code <> 'X'

Line 3245: xla_ae_headers_gt hdr

3241: hdr.ledger_id ledger_id,
3242: hdr.ae_header_id ae_header_id,
3243: lns.alt_code_combination_id ccid
3244: FROM xla_ae_lines_gt lns,
3245: xla_ae_headers_gt hdr
3246: WHERE lns.ae_header_id = hdr.ae_header_id
3247: AND lns.alt_code_combination_id <> -1
3248: AND lns.alt_ccid_status_code = C_INVALID
3249: AND lns.balance_type_code <> 'X'

Line 4899: ,xla_ae_headers_gt xahg

4895: ,gami.from_ccid from_ccid
4896: ,xjlg.ccid_coa_id ccid_coa_id
4897: FROM gl_accts_map_int_gt gami
4898: ,xla_ae_lines_gt xjlg
4899: ,xla_ae_headers_gt xahg
4900: ,xla_transaction_accts_gt xtag
4901: WHERE xjlg.ae_header_id = xahg.ae_header_id
4902: AND xjlg.event_id = xahg.event_id
4903: AND xjlg.ae_header_id = xtag.ae_header_id

Line 4925: ,xla_ae_headers_gt xahg

4921: ,gami.from_ccid from_ccid
4922: , xjlg.ccid_coa_id coa_id
4923: FROM gl_accts_map_int_gt gami
4924: ,xla_ae_lines_gt xjlg
4925: ,xla_ae_headers_gt xahg
4926: ,xla_transaction_accts_gt xtag
4927: WHERE xjlg.ae_header_id = xahg.ae_header_id
4928: AND xjlg.event_id = xahg.event_id
4929: AND xjlg.ae_header_id = xtag.ae_header_id

Line 5628: UPDATE xla_ae_headers_gt xahg

5624: create_new_ccid ;
5625: --
5626: IF l_ccid_created > 0 THEN
5627:
5628: UPDATE xla_ae_headers_gt xahg
5629: SET xahg.accounting_entry_status_code = xla_ae_journal_entry_pkg.C_INVALID
5630: WHERE xahg.ae_header_id IN (SELECT xalg.ae_header_id
5631: FROM xla_ae_lines_gt xalg
5632: WHERE xalg.balance_type_code <> 'X'

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

5643:
5644: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
5645:
5646: trace
5647: (p_msg => 'SQL - Update xla_ae_headers_gt '
5648: ,p_level => C_LEVEL_STATEMENT
5649: ,p_module => l_log_module);
5650: trace
5651: (p_msg => '# of rows updated into xla_ae_headers_gt = '||SQL%ROWCOUNT

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

5647: (p_msg => 'SQL - Update xla_ae_headers_gt '
5648: ,p_level => C_LEVEL_STATEMENT
5649: ,p_module => l_log_module);
5650: trace
5651: (p_msg => '# of rows updated into xla_ae_headers_gt = '||SQL%ROWCOUNT
5652: ,p_level => C_LEVEL_STATEMENT
5653: ,p_module => l_log_module);
5654:
5655: END IF;