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_TRANSFER_PKG dependencies on XLA_AE_HEADERS

Line 80: | XLA_AE_HEADERS in Select_Journal_Entries |

76: | in finding the application from |
77: | which the data manager has been spawned. |
78: | 12-Aug-2009 rajose bug#8691650 Phase 2 |
79: | 01-Sep-2010 VGOPISET 10047096 Perf changes in the UPDATE of |
80: | XLA_AE_HEADERS in Select_Journal_Entries |
81: | 26-NOV-2010 Narayanan M.S. Bug#10124492 Headers with gl_transfer_sta|
82: | tus_code as 'NT' will not be reset to 'N'|
83: | or 'Y' |
84: | Bug#9839301 Modified procedure |

Line 552: FROM xla_ae_headers xah

548: , Case
549: When xal.accounted_dr is not null Then 'D'
550: Else 'I'
551: END
552: FROM xla_ae_headers xah
553: , xla_ae_lines xal
554: , xla_subledgers xs
555: , gl_period_statuses gps
556: , v$session ses

Line 616: -- update xla_ae_headers as funds reserved

612: end if;
613:
614: IF (NVL(l_bc_count,0) > 0) THEN
615:
616: -- update xla_ae_headers as funds reserved
617: g_reserve_flag := true;
618:
619: update xla_ae_headers xah
620: set xah.funds_status_code = 'S'

Line 619: update xla_ae_headers xah

615:
616: -- update xla_ae_headers as funds reserved
617: g_reserve_flag := true;
618:
619: update xla_ae_headers xah
620: set xah.funds_status_code = 'S'
621: where xah.ledger_id = g_ledger_id_tab(i)
622: and xah.application_id = p_application_id
623: and xah.group_id = p_group_id

Line 1520: UPDATE xla_Ae_headers xah

1516: --
1517: IF g_application_id = 200 THEN
1518:
1519: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1520: UPDATE xla_Ae_headers xah
1521: set funds_status_code = null
1522: where group_id = g_group_id_tab(i)
1523: and funds_status_code = 'S'
1524: and exists

Line 1569: trace('Updating XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);

1565: --
1566: -- Reset journal entry headers
1567: --
1568: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1569: trace('Updating XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
1570: END IF;
1571: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1572: UPDATE xla_ae_headers
1573: SET group_id = NULL

Line 1572: UPDATE xla_ae_headers

1568: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1569: trace('Updating XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
1570: END IF;
1571: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1572: UPDATE xla_ae_headers
1573: SET group_id = NULL
1574: ,gl_transfer_status_code = 'N'
1575: ,gl_transfer_date = NULL
1576: ,program_update_date = SYSDATE

Line 1747: FROM xla_ae_headers aeh

1743:
1744: l_statement :=
1745: 'SELECT DISTINCT aeh.period_name
1746: ,aeh.ledger_id
1747: FROM xla_ae_headers aeh
1748: ,gl_period_statuses gps
1749: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1750: WHERE aeh.application_id = :2 --g_application_id
1751: AND aeh.ledger_id = led.column_value

Line 1812: FROM xla_ae_headers aeh

1808: END IF;
1809: l_statement := '
1810: SELECT DISTINCT gps.period_year
1811: ,gbv.budget_name
1812: FROM xla_ae_headers aeh
1813: ,gl_period_statuses gps
1814: ,gl_budget_period_ranges gbp
1815: ,gl_budget_versions gbv
1816: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 1873: FROM xla_ae_headers aeh

1869: END IF;
1870: l_statement :=
1871: ' SELECT DISTINCT aeh.ledger_id
1872: ,gll.latest_encumbrance_year
1873: FROM xla_ae_headers aeh
1874: ,gl_period_statuses gps
1875: ,gl_ledgers gll
1876: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1877: WHERE aeh.application_id = :2 --g_application_id

Line 1930: FROM xla_ae_headers aeh

1926: END IF;
1927: l_statement :=
1928: 'SELECT DISTINCT aeh.period_name
1929: ,aeh.ledger_id
1930: FROM xla_ae_headers aeh
1931: ,gl_period_statuses gps
1932: ,xla_transaction_entities xte
1933: ,xla_event_types_b xet
1934: ,xla_event_class_attrs xec

Line 2010: FROM xla_ae_headers aeh

2006: END IF;
2007: l_statement := '
2008: SELECT DISTINCT gps.period_year
2009: ,gbv.budget_name
2010: FROM xla_ae_headers aeh
2011: ,xla_transaction_entities xte
2012: ,xla_event_types_b xet
2013: ,xla_event_class_attrs xec
2014: ,gl_period_statuses gps

Line 2086: FROM xla_ae_headers aeh

2082: END IF;
2083: l_statement :=
2084: ' SELECT DISTINCT aeh.ledger_id
2085: ,gll.latest_encumbrance_year
2086: FROM xla_ae_headers aeh
2087: ,gl_period_statuses gps
2088: ,xla_transaction_entities xte
2089: ,xla_event_types_b xet
2090: ,xla_event_class_attrs xec

Line 2199: UPDATE /+ index(xah, XLA_AE_HEADERS_N1) /

2195: -- is pre populated in the accounting program. get the count.
2196: -- Bug 5437400 - update transfer status and transfer date in
2197: -- combined mode.
2198: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
2199: UPDATE /*+ index(xah, XLA_AE_HEADERS_N1) */
2200: xla_ae_headers xah
2201: SET gl_transfer_date = sysdate,
2202: gl_transfer_status_code = 'S'
2203: WHERE application_id = g_application_id

Line 2200: xla_ae_headers xah

2196: -- Bug 5437400 - update transfer status and transfer date in
2197: -- combined mode.
2198: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
2199: UPDATE /*+ index(xah, XLA_AE_HEADERS_N1) */
2200: xla_ae_headers xah
2201: SET gl_transfer_date = sysdate,
2202: gl_transfer_status_code = 'S'
2203: WHERE application_id = g_application_id
2204: AND ledger_id = g_ledger_id_tab(i)

Line 2233: UPDATE xla_ae_headers aeh

2229: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2230: trace('Selecting journal entris for the document ' || g_entity_id,C_LEVEL_STATEMENT,l_log_module);
2231: END IF;
2232: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
2233: UPDATE xla_ae_headers aeh
2234: SET program_update_date = SYSDATE,
2235: program_id = g_program_id,
2236: request_id = g_request_id,
2237: group_id = g_group_id,

Line 2269: UPDATE xla_ae_headers aeh

2265: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2266: trace('Selecting journal entries for the accounting batch id ' || g_accounting_batch_id,C_LEVEL_STATEMENT,l_log_module);
2267: END IF;
2268: FORALL i IN g_ledger_id_tab.FIRST .. g_ledger_id_tab.LAST
2269: UPDATE xla_ae_headers aeh
2270: SET program_update_date = SYSDATE,
2271: program_id = g_program_id,
2272: group_id = g_group_id,
2273: gl_transfer_date = SYSDATE,

Line 2303: UPDATE xla_ae_headers aeh

2299:
2300: ELSIF g_transfer_mode = 'STANDALONE' THEN
2301: IF g_caller = C_ACCTPROG_DOCUMENT THEN
2302: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
2303: UPDATE xla_ae_headers aeh
2304: SET program_update_date = SYSDATE,
2305: program_id = g_program_id,
2306: request_id = g_request_id,
2307: gl_transfer_date = sysdate,

Line 2355: FROM xla_ae_headers aeh

2351: ,aeh.request_id
2352: ,aeh.gl_transfer_date
2353: ,aeh.gl_transfer_status_code
2354: ,aeh.group_id
2355: FROM xla_ae_headers aeh
2356: ,xla_transaction_entities xte
2357: --,xla_event_types_b xet
2358: --,xla_event_class_attrs xeca
2359: --,xla_event_classes_b xec -- commented for bug12542507 and made it as IN clause

Line 2659: SELECT /+ ordered index(aeh,xla_ae_headers_n1) use_nl(jc,led,ael,gps) /

2655: ,reference28
2656: ,reference29
2657: ,reference30
2658: )
2659: SELECT /*+ ordered index(aeh,xla_ae_headers_n1) use_nl(jc,led,ael,gps) */
2660: ''NEW'', aeh.ledger_id
2661: ,:1 , decode(:2,''Y'',jc.je_category_key
2662: ,jc.user_je_category_name)
2663: ,DECODE(:3, ''P'' , gps.end_date , aeh.accounting_date)

Line 2708: FROM xla_ae_headers aeh

2704: ,ael.ae_header_id
2705: ,ael.ae_line_num
2706: ,ael.accounted_dr
2707: ,ael.accounted_cr
2708: FROM xla_ae_headers aeh
2709: ,xla_ae_lines ael
2710: ,gl_je_categories jc
2711: ,gl_period_statuses gps
2712: ,gl_ledgers led

Line 3017: -- Update XLA_AE_HEADERS

3013: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3014: trace('set_transfer_status.Begin',C_LEVEL_PROCEDURE,l_log_module);
3015: END IF;
3016: --
3017: -- Update XLA_AE_HEADERS
3018: --
3019: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3020: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
3021: END IF;

Line 3020: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);

3016: --
3017: -- Update XLA_AE_HEADERS
3018: --
3019: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3020: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
3021: END IF;
3022:
3023: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3024: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */

Line 3024: UPDATE /+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) /

3020: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
3021: END IF;
3022:
3023: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3024: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
3025: xla_ae_headers
3026: SET gl_transfer_status_code = 'Y',
3027: gl_transfer_date = sysdate -- bug#5437400
3028: WHERE group_id = g_group_id_tab(i)

Line 3025: xla_ae_headers

3021: END IF;
3022:
3023: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
3024: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
3025: xla_ae_headers
3026: SET gl_transfer_status_code = 'Y',
3027: gl_transfer_date = sysdate -- bug#5437400
3028: WHERE group_id = g_group_id_tab(i)
3029: AND application_id = g_application_id --4769315

Line 3911: trace('Resetting Gl Transfer Flag to N in XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);

3907: ELSE -- g_proceed flag is 'N'
3908: FOR i IN g_primary_ledgers_tab.FIRST..g_primary_ledgers_tab.LAST
3909: LOOP
3910: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3911: trace('Resetting Gl Transfer Flag to N in XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
3912: END IF;
3913: UPDATE xla_ae_headers
3914: SET group_id = NULL
3915: ,gl_transfer_status_code = 'N'

Line 3913: UPDATE xla_ae_headers

3909: LOOP
3910: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3911: trace('Resetting Gl Transfer Flag to N in XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
3912: END IF;
3913: UPDATE xla_ae_headers
3914: SET group_id = NULL
3915: ,gl_transfer_status_code = 'N'
3916: ,gl_transfer_date = NULL
3917: ,program_update_date = SYSDATE