DBA Data[Home] [Help]

APPS.XLA_TRANSFER_PKG dependencies on XLA_AE_HEADERS

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

1051: --
1052: -- Reset journal entry headers
1053: --
1054: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1055: trace('Updating XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
1056: END IF;
1057: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1058: UPDATE xla_ae_headers
1059: SET group_id = NULL

Line 1058: UPDATE xla_ae_headers

1054: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1055: trace('Updating XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
1056: END IF;
1057: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
1058: UPDATE xla_ae_headers
1059: SET group_id = NULL
1060: ,gl_transfer_status_code = 'N'
1061: ,gl_transfer_date = NULL
1062: ,program_update_date = SYSDATE

Line 1210: FROM xla_ae_headers aeh

1206:
1207: l_statement :=
1208: 'SELECT DISTINCT aeh.period_name
1209: ,aeh.ledger_id
1210: FROM xla_ae_headers aeh
1211: ,gl_period_statuses gps
1212: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1213: WHERE aeh.application_id = :2 --g_application_id
1214: AND aeh.ledger_id = led.column_value

Line 1275: FROM xla_ae_headers aeh

1271: END IF;
1272: l_statement := '
1273: SELECT DISTINCT gps.period_year
1274: ,gbv.budget_name
1275: FROM xla_ae_headers aeh
1276: ,gl_period_statuses gps
1277: ,gl_budget_period_ranges gbp
1278: ,gl_budget_versions gbv
1279: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led

Line 1336: FROM xla_ae_headers aeh

1332: END IF;
1333: l_statement :=
1334: ' SELECT DISTINCT aeh.ledger_id
1335: ,gll.latest_encumbrance_year
1336: FROM xla_ae_headers aeh
1337: ,gl_period_statuses gps
1338: ,gl_ledgers gll
1339: ,TABLE (CAST(:1 AS XLA_NUMBER_ARRAY_TYPE))led
1340: WHERE aeh.application_id = :2 --g_application_id

Line 1393: FROM xla_ae_headers aeh

1389: END IF;
1390: l_statement :=
1391: 'SELECT DISTINCT aeh.period_name
1392: ,aeh.ledger_id
1393: FROM xla_ae_headers aeh
1394: ,gl_period_statuses gps
1395: ,xla_transaction_entities xte
1396: ,xla_event_types_b xet
1397: ,xla_event_class_attrs xec

Line 1473: FROM xla_ae_headers aeh

1469: END IF;
1470: l_statement := '
1471: SELECT DISTINCT gps.period_year
1472: ,gbv.budget_name
1473: FROM xla_ae_headers aeh
1474: ,xla_transaction_entities xte
1475: ,xla_event_types_b xet
1476: ,xla_event_class_attrs xec
1477: ,gl_period_statuses gps

Line 1549: FROM xla_ae_headers aeh

1545: END IF;
1546: l_statement :=
1547: ' SELECT DISTINCT aeh.ledger_id
1548: ,gll.latest_encumbrance_year
1549: FROM xla_ae_headers aeh
1550: ,gl_period_statuses gps
1551: ,xla_transaction_entities xte
1552: ,xla_event_types_b xet
1553: ,xla_event_class_attrs xec

Line 1662: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */

1658: -- is pre populated in the accounting program. get the count.
1659: -- Bug 5437400 - update transfer status and transfer date in
1660: -- combined mode.
1661: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
1662: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
1663: xla_ae_headers
1664: SET gl_transfer_date = sysdate,
1665: gl_transfer_status_code = 'S'
1666: WHERE application_id = g_application_id

Line 1663: xla_ae_headers

1659: -- Bug 5437400 - update transfer status and transfer date in
1660: -- combined mode.
1661: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
1662: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
1663: xla_ae_headers
1664: SET gl_transfer_date = sysdate,
1665: gl_transfer_status_code = 'S'
1666: WHERE application_id = g_application_id
1667: AND ledger_id = g_ledger_id_tab(i)

Line 1679: UPDATE xla_ae_headers aeh

1675: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1676: trace('Selecting journal entris for the document ' || g_entity_id,C_LEVEL_STATEMENT,l_log_module);
1677: END IF;
1678: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
1679: UPDATE xla_ae_headers aeh
1680: SET program_update_date = SYSDATE,
1681: program_id = g_program_id,
1682: request_id = g_request_id,
1683: group_id = g_group_id,

Line 1699: UPDATE xla_ae_headers aeh

1695: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1696: trace('Selecting journal entries for the accounting batch id ' || g_accounting_batch_id,C_LEVEL_STATEMENT,l_log_module);
1697: END IF;
1698: FORALL i IN g_ledger_id_tab.FIRST .. g_ledger_id_tab.LAST
1699: UPDATE xla_ae_headers aeh
1700: SET program_update_date = SYSDATE,
1701: program_id = g_program_id,
1702: group_id = g_group_id,
1703: gl_transfer_date = SYSDATE,

Line 1718: UPDATE xla_ae_headers aeh

1714:
1715: ELSIF g_transfer_mode = 'STANDALONE' THEN
1716: IF g_caller = C_ACCTPROG_DOCUMENT THEN
1717: FORALL i IN g_ledger_id_tab.FIRST..g_ledger_id_tab.LAST
1718: UPDATE xla_ae_headers aeh
1719: SET program_update_date = SYSDATE,
1720: program_id = g_program_id,
1721: request_id = g_request_id,
1722: gl_transfer_date = sysdate,

Line 1749: FROM xla_ae_headers aeh

1745: ,aeh.request_id
1746: ,aeh.gl_transfer_date
1747: ,aeh.gl_transfer_status_code
1748: ,aeh.group_id
1749: FROM xla_ae_headers aeh
1750: ,xla_transaction_entities xte
1751: ,xla_event_types_b xet
1752: ,xla_event_class_attrs xeca
1753: ,xla_event_classes_b xec

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

2005: ,reference28
2006: ,reference29
2007: ,reference30
2008: )
2009: SELECT /*+ ordered index(aeh,xla_ae_headers_n1) use_nl(jc,led,ael,gps) */
2010: ''NEW'', aeh.ledger_id
2011: ,:1 , jc.user_je_category_name
2012: ,DECODE(:2, ''P'' , gps.end_date , aeh.accounting_date)
2013: ,DECODE(aeh.balance_type_code , ''E'' , led.currency_code , ael.currency_code)

Line 2055: FROM xla_ae_headers aeh

2051: ,ael.ae_header_id
2052: ,ael.ae_line_num
2053: ,ael.accounted_dr
2054: ,ael.accounted_cr
2055: FROM xla_ae_headers aeh
2056: ,xla_ae_lines ael
2057: ,gl_je_categories jc
2058: ,gl_period_statuses gps
2059: ,gl_ledgers led

Line 2313: -- Update XLA_AE_HEADERS

2309: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2310: trace('set_transfer_status.Begin',C_LEVEL_PROCEDURE,l_log_module);
2311: END IF;
2312: --
2313: -- Update XLA_AE_HEADERS
2314: --
2315: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2316: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
2317: END IF;

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

2312: --
2313: -- Update XLA_AE_HEADERS
2314: --
2315: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2316: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
2317: END IF;
2318:
2319: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
2320: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */

Line 2320: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */

2316: trace('Updating xla_ae_headers ',C_LEVEL_STATEMENT,l_log_module);
2317: END IF;
2318:
2319: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
2320: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
2321: xla_ae_headers
2322: SET gl_transfer_status_code = 'Y',
2323: gl_transfer_date = sysdate -- bug#5437400
2324: WHERE group_id = g_group_id_tab(i)

Line 2321: xla_ae_headers

2317: END IF;
2318:
2319: FORALL i IN g_group_id_tab.FIRST..g_group_id_tab.LAST
2320: UPDATE /*+ index(XLA_AE_HEADERS,XLA_AE_HEADERS_N1) */
2321: xla_ae_headers
2322: SET gl_transfer_status_code = 'Y',
2323: gl_transfer_date = sysdate -- bug#5437400
2324: WHERE group_id = g_group_id_tab(i)
2325: AND application_id = g_application_id; --4769315

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

3021: ELSE -- g_proceed flag is 'N'
3022: FOR i IN g_primary_ledgers_tab.FIRST..g_primary_ledgers_tab.LAST
3023: LOOP
3024: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3025: trace('Resetting Gl Transfer Flag to N in XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
3026: END IF;
3027: UPDATE xla_ae_headers
3028: SET group_id = NULL
3029: ,gl_transfer_status_code = 'N'

Line 3027: UPDATE xla_ae_headers

3023: LOOP
3024: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3025: trace('Resetting Gl Transfer Flag to N in XLA_AE_HEADERS',C_LEVEL_STATEMENT,l_log_module);
3026: END IF;
3027: UPDATE xla_ae_headers
3028: SET group_id = NULL
3029: ,gl_transfer_status_code = 'N'
3030: ,gl_transfer_date = NULL
3031: ,program_update_date = SYSDATE