eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AE_HEADER_PKG dependencies on XLA_AE_LINES_GT

Line 32: | xla_ae_lines_gt, xla_je_headers_gt by |

28: | 28-APR-2003 K.Boussema Added validation of Accounting Event Extract |
29: | bug 2925651 |
30: | 06-MAI-2003 K.Boussema Modifcation included for bug2936071 |
31: | 13-MAI-2003 K.Boussema Renamed temporary tables xla_je_lines_gt by |
32: | xla_ae_lines_gt, xla_je_headers_gt by |
33: | xla_ae_headers_gt |
34: | Renamed in xla_distribution_links the column |
35: | base_amount by ledger_amount |
36: | 20-MAI-2003 K.Boussema Added a Token to XLA_AP_CANNOT_INSERT_JE |

Line 57: | 12-DEC-2003 K. Boussema Renamed target_coa_id in xla_ae_lines_gt |

53: | 22-OCT-2003 K.Boussema Changed to capture the Merge Matching Lines |
54: | preference for Accounting Reversal from JLT |
55: | 26-NOV-2003 K.Boussema Removed the insert of the sl_coa_mapping name|
56: | for change third party lines, bug 3278955 |
57: | 12-DEC-2003 K. Boussema Renamed target_coa_id in xla_ae_lines_gt |
58: | by ccid_coa_id |
59: | Reviewed the InsertHeaders, bug 3042840 |
60: | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
61: | 3310291 and 3320689 |

Line 2140: (SELECT /+ INDEX (AEL, XLA_AE_LINES_GT_N3) / -- 4752774 -- changed in 8319065 performance changes

2136: , accrual_reversal_flag -- 4262811
2137: , acc_rev_gl_date_option -- 4262811
2138: , parent_header_id -- 4262811
2139: , parent_ae_line_num) -- 4262811
2140: (SELECT /*+ INDEX (AEL, XLA_AE_LINES_GT_N3) */ -- 4752774 -- changed in 8319065 performance changes
2141: g_rec_header_new.array_event_id(Idx)
2142: , CASE ael.balance_type_code
2143: when C_BUDGET THEN
2144: g_rec_header_new.array_budget_status(Idx)

Line 2284: FROM xla_ae_lines_gt ael

2280: , g_rec_header_new.array_accrual_reversal_flag(Idx) -- 4262811
2281: , g_rec_header_new.array_acc_rev_gl_date_option(Idx) -- 4262811
2282: , g_rec_header_new.array_parent_header_id(Idx) -- 4262811
2283: , g_rec_header_new.array_parent_line_num(Idx) -- 4262811
2284: FROM xla_ae_lines_gt ael
2285: WHERE ael.ae_header_id = g_rec_header_new.array_event_id(Idx)
2286: AND ael.ledger_id = g_rec_header_new.array_target_ledger_id(Idx)
2287: AND (nvl(ael.gain_or_loss_flag, 'N') <> 'Y' or nvl(ael.calculate_g_l_amts_flag, 'N') <> 'Y')
2288: AND ael.header_num =

Line 2376: (p_msg => 'SQL - Insert into xla_ae_lines_gt '

2372: --
2373: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2374:
2375: trace
2376: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2377: ,p_level => C_LEVEL_STATEMENT
2378: ,p_module => l_log_module);
2379: END IF;
2380: --

Line 2381: INSERT INTO xla_ae_lines_gt

2377: ,p_level => C_LEVEL_STATEMENT
2378: ,p_module => l_log_module);
2379: END IF;
2380: --
2381: INSERT INTO xla_ae_lines_gt
2382: (
2383: ae_header_id
2384: , temp_line_num
2385: , event_id

Line 2887: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT

2883:
2884: IF (C_LEVEL_EVENT >= g_log_level) THEN
2885:
2886: trace
2887: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
2888: ,p_level => C_LEVEL_EVENT
2889: ,p_module => l_log_module);
2890:
2891: END IF;

Line 2900: (p_msg => 'SQL - Insert into xla_ae_lines_gt '

2896: --
2897: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2898:
2899: trace
2900: (p_msg => 'SQL - Insert into xla_ae_lines_gt '
2901: ,p_level => C_LEVEL_STATEMENT
2902: ,p_module => l_log_module);
2903: END IF;
2904: --

Line 2906: INSERT INTO xla_ae_lines_gt

2902: ,p_module => l_log_module);
2903: END IF;
2904: --
2905: --
2906: INSERT INTO xla_ae_lines_gt
2907: (
2908: ae_header_id
2909: , temp_line_num
2910: , event_id

Line 3085: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT

3081: --
3082: IF (C_LEVEL_EVENT >= g_log_level) THEN
3083:
3084: trace
3085: (p_msg => '# temporary journal lines inserted into GT xla_ae_lines_gt = '||SQL%ROWCOUNT
3086: ,p_level => C_LEVEL_EVENT
3087: ,p_module => l_log_module);
3088: END IF;
3089:

Line 3493: UPDATE /+ INDEX(XAL XLA_AE_LINES_GT_N4) / xla_ae_lines_gt XAL

3489: --
3490: --
3491: -- added hints for the perf change via bug#10047074
3492: FORALL i IN xla_ae_journal_entry_pkg.g_array_ae_header_id.FIRST .. xla_ae_journal_entry_pkg.g_array_ae_header_id.LAST
3493: UPDATE /*+ INDEX(XAL XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt XAL
3494: SET XAL.ACCOUNTING_DATE = (SELECT /*+ INDEX(xah XLA_AE_HEADERS_GT_U1) */xah.accounting_date
3495: FROM xla_ae_headers_gt xah
3496: WHERE xah.ae_header_id = xla_ae_journal_entry_pkg.g_array_ae_header_id(i)
3497: and xah.ledger_id = xla_ae_journal_entry_pkg.g_array_ledger_id(i)

Line 3512: (p_msg => '# rows updated in xla_ae_lines_gt(date_adjust) =' || l_count

3508: l_count := SQL%ROWCOUNT;
3509:
3510: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3511: trace
3512: (p_msg => '# rows updated in xla_ae_lines_gt(date_adjust) =' || l_count
3513: ,p_level => C_LEVEL_STATEMENT
3514: ,p_module => l_log_module);
3515: END IF;
3516: