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_HEADERS

Line 33: | xla_ae_headers_gt |

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 |
37: | message |

Line 79: | - changed the insert into xla_ae_headers_gt |

75: | 29-MAR-2204 K.Boussema Changed based on bug 3528667 |
76: | - added get_period_name function to retrieve|
77: | the period_name from gl_period_statuses |
78: | - added the cache of period_name |
79: | - changed the insert into xla_ae_headers_gt |
80: | 11-MAY-2004 K.Boussema Removed the call to XLA trace routine from |
81: | trace() procedure |
82: | 17-MAY-2004 W.Shen change for attribute enhancement project |
83: | 1. add TransactionReversal procedure from |

Line 2002: (p_msg => 'SQL - Insert into xla_ae_headers_gt'

1998:
1999: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2000:
2001: trace
2002: (p_msg => 'SQL - Insert into xla_ae_headers_gt'
2003: ,p_level => C_LEVEL_STATEMENT
2004: ,p_module => l_log_module);
2005: END IF;
2006:

Line 2009: INSERT /+ opt_param('_gby_hash_aggregation_enabled','false') / INTO xla_ae_headers_gt -- added hint for bug 14246749

2005: END IF;
2006:
2007:
2008: FORALL Idx IN 1..g_rec_header_new.array_je_category_name.count SAVE EXCEPTIONS --added Save exception 7526530
2009: INSERT /*+ opt_param('_gby_hash_aggregation_enabled','false') */ INTO xla_ae_headers_gt -- added hint for bug 14246749
2010: ( ae_header_id
2011: , accounting_entry_status_code
2012: , accounting_entry_type_code
2013: , ledger_id

Line 2303: (p_msg => '# temporary headers inserted into GT xla_ae_headers_gt = '||SQL%ROWCOUNT

2299:
2300: IF (C_LEVEL_EVENT >= g_log_level) THEN
2301:
2302: trace
2303: (p_msg => '# temporary headers inserted into GT xla_ae_headers_gt = '||SQL%ROWCOUNT
2304: ,p_level => C_LEVEL_EVENT
2305: ,p_module => l_log_module);
2306: END IF;
2307: --

Line 2735: xla_ae_headers xah,

2731: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
2732: , 0 -- 5100860 assign value to avoid using function index
2733: --
2734: FROM xla_ae_lines xal,
2735: xla_ae_headers xah,
2736: xla_distribution_links xdl,
2737: xla_events xe,
2738: (SELECT ae_header_id
2739: ,ae_line_num

Line 3060: xla_ae_headers xah,

3056: , xal.encumbrance_type_id -- 4458381 Public Sector Enh
3057: , 0 -- 5100860 assign value to avoid using function index
3058: --
3059: FROM xla_ae_lines xal,
3060: xla_ae_headers xah,
3061: xla_distribution_links xdl,
3062: xla_events xe
3063: WHERE xe.event_id = xdl.event_id
3064: AND xe.event_id = xah.event_id

Line 3386: (p_msg => 'SQL - update xla_ae_headers_gt'

3382: l_transaction_calendar_id IS NOT NULL) THEN
3383:
3384: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3385: trace
3386: (p_msg => 'SQL - update xla_ae_headers_gt'
3387: ,p_level => C_LEVEL_STATEMENT
3388: ,p_module => l_log_module);
3389: END IF;
3390:

Line 3394: -- UPDATE xla_ae_headers_gt xah

3390:
3391:
3392: -- performance fix bug9781991 fixes both SQLs in this procedure, overriding both bug9630931 and bug8898196
3393: --
3394: -- UPDATE xla_ae_headers_gt xah
3395: -- SET accounting_date =
3396: -- DECODE(xah.acc_rev_gl_date_option,
3397: -- 'XLA_NEXT_DAY',
3398: -- (SELECT min(transaction_date)

Line 3407: -- FROM xla_ae_headers_gt xah2

3403: -- -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE
3404: -- (SELECT transaction_date
3405: -- FROM (SELECT /*+ USE_NL_WITH_INDEX(XAH2, GL_TRANSACTION_DATES_U1) */ xah2.ae_header_id
3406: -- , d.transaction_date
3407: -- FROM xla_ae_headers_gt xah2
3408: -- , gl_transaction_dates d
3409: -- WHERE d.transaction_calendar_id = l_transaction_calendar_id
3410: -- AND d.business_day_flag = 'Y'
3411: -- AND d.transaction_date >= xah2.period_start_date

Line 3428: UPDATE /+ index(xah XLA_AE_HEADERS_GT_U1) / xla_ae_headers_gt xah --added U1 hint for bug#10229047

3424: -- and tmp.TRANSACTION_DATE >= XAH.PERIOD_START_DATE /* added vdamerla bug 8898196 */));
3425:
3426:
3427: 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
3428: UPDATE /*+ index(xah XLA_AE_HEADERS_GT_U1) */ xla_ae_headers_gt xah --added U1 hint for bug#10229047
3429: SET accounting_date =
3430: DECODE(xah.acc_rev_gl_date_option,
3431: 'XLA_NEXT_DAY',
3432: ( SELECT min(transaction_date)

Line 3439: FROM (SELECT /+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) / xah2.ae_header_id

3435: AND d.transaction_date >= xah.accounting_date
3436: AND d.transaction_calendar_id = l_transaction_calendar_id),
3437: -- XLA_FIRST_DAY_NEXT_GL_PERIOD, XLA_LAST_DAY_NEXT_GL_PERIOD, NONE
3438: ( SELECT transaction_date
3439: FROM (SELECT /*+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) */ xah2.ae_header_id
3440: --added U1 hint for bug#10229047
3441: , d.transaction_date
3442: FROM xla_ae_headers_gt xah2
3443: , gl_transaction_dates d

Line 3442: FROM xla_ae_headers_gt xah2

3438: ( SELECT transaction_date
3439: FROM (SELECT /*+ USE_NL(xah2,gps,d) INDEX(d GL_TRANSACTION_DATES_U1) index(xah2 XLA_AE_HEADERS_GT_U1) */ xah2.ae_header_id
3440: --added U1 hint for bug#10229047
3441: , d.transaction_date
3442: FROM xla_ae_headers_gt xah2
3443: , gl_transaction_dates d
3444: , gl_period_statuses gps
3445: WHERE d.transaction_calendar_id = l_transaction_calendar_id
3446: AND d.business_day_flag = 'Y'

Line 3479: (p_msg => '# rows updated in xla_ae_headers_gt(1.2) ='|| l_count

3475: l_count := SQL%BULK_ROWCOUNT(i) + l_count;
3476: END LOOP;
3477:
3478: trace
3479: (p_msg => '# rows updated in xla_ae_headers_gt(1.2) ='|| l_count
3480: ,p_level => C_LEVEL_STATEMENT
3481: ,p_module => l_log_module);
3482: END IF;
3483:

Line 3494: SET XAL.ACCOUNTING_DATE = (SELECT /+ INDEX(xah XLA_AE_HEADERS_GT_U1) /xah.accounting_date

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)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)

Line 3495: FROM xla_ae_headers_gt xah

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)
3498: and xah.event_id = xla_ae_journal_entry_pkg.g_array_event_id(i)
3499: and xah.balance_type_code = xla_ae_journal_entry_pkg.g_array_balance_type(i)