DBA Data[Home] [Help]

APPS.XLA_AE_LINES_PKG dependencies on XLA_ACCOUNTING_PKG

Line 4223: (p_msg => 'MPA Line Reversal exists = '||xla_accounting_pkg.g_mpa_accrual_exists

4219: (p_msg => 'Application ID ='||to_char(l_application_id)
4220: ,p_level => C_LEVEL_STATEMENT
4221: ,p_module => l_log_module);
4222: trace -- 5412560
4223: (p_msg => 'MPA Line Reversal exists = '||xla_accounting_pkg.g_mpa_accrual_exists
4224: ,p_level => C_LEVEL_STATEMENT
4225: ,p_module => l_log_module);
4226: END IF;
4227:

Line 4327: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560

4323: ---------------------------------------------------------------------------------------------------------
4324: -- 4669308 Delete the MPA/Accrual Line Reversal in xla_ae_lines_gt (not in distribution links yet)
4325: ---------------------------------------------------------------------------------------------------------
4326: --
4327: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560
4328: -- Modify for performance bug 5086984
4329: FOR i IN 1..l_array_entity_id.count LOOP
4330: SELECT /*+ Leading(HGT) cardinality(hgt 1) index(lgt XLA_AE_LINES_GT_U1) */
4331: lgt.ledger_id

Line 4427: END IF; -- xla_accounting_pkg.g_mpa_accrual_exists = 'Y'

4423: AND header_num = l_array_mpa_acc_header_num(j);
4424:
4425: END LOOP;
4426: --
4427: END IF; -- xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
4428: -------------------------------------------------------------------------------------------------------------------------
4429:
4430: --
4431: -- reverse the lines in xla_ae_lines_gt table (not in distribution links yet)

Line 6200: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560

6196: ---------------------------------------------------------------------------------------------------------
6197: -- 4669308 Delete the MPA/Accrual Transaction Reversal in xla_ae_lines_gt (not in distribution links yet)
6198: ---------------------------------------------------------------------------------------------------------
6199: --
6200: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560
6201: FORALL i IN 1..l_array_entity_id.count
6202: DELETE xla_ae_lines_gt lgt
6203: WHERE l_array_ledger_id(i) = lgt.ledger_id
6204: AND lgt.reversal_code IS NULL -- the lines created from reversal are not reversed again

Line 11416: (p_msg => 'g_mpa_accrual_exists = '||xla_accounting_pkg.g_mpa_accrual_exists

11412: (p_msg => 'method = '||xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG')
11413: ,p_level => C_LEVEL_PROCEDURE
11414: ,p_module => l_log_module);
11415: trace
11416: (p_msg => 'g_mpa_accrual_exists = '||xla_accounting_pkg.g_mpa_accrual_exists
11417: ,p_level => C_LEVEL_PROCEDURE
11418: ,p_module => l_log_module);
11419: END IF;
11420:

Line 11944: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5666366

11940:
11941: -------------------------------------------------------------------------------------------------------------------------
11942: -- 4655713b Update MPA and Accrual Reversal lines with Prior Entry
11943: -------------------------------------------------------------------------------------------------------------------------
11944: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5666366
11945: SELECT /*+ Leading (xal1,xah1,xal2) index(xah1 XLA_AE_HEADERS_GT_U1) index(xal2 XLA_AE_LINES_GT_N2) no_expand */ -- 5666366
11946: xal2.segment1, xal2.segment2, xal2.segment3, xal2.segment4, xal2.segment5
11947: ,xal2.segment6, xal2.segment7, xal2.segment8, xal2.segment9, xal2.segment10
11948: ,xal2.segment11, xal2.segment12, xal2.segment13, xal2.segment14, xal2.segment15

Line 12235: END IF; -- 5666366 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'

12231: WHERE xal.ledger_id = l_array_mpa_ledger_id(i)
12232: AND xal.ref_ae_header_id = l_array_mpa_ref_ae_header_id(i)
12233: AND xal.ae_header_id = l_array_mpa_ae_header_id(i)
12234: AND NVL(xal.header_num,0) = l_array_mpa_header_num(i);
12235: END IF; -- 5666366 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
12236: -------------------------------------------------------------------------------------------------------------------------
12237:
12238:
12239: -------------------------------------------------------------------------

Line 12896: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 7128871

12892:
12893: -------------------------------------------------------------------------------------------------------------------------
12894: -- 4655713b Updates MPA-Accrual (not MPA-Recognition) and Accrual Reversal lines with Same Entry
12895: -------------------------------------------------------------------------------------------------------------------------
12896: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 7128871
12897: SELECT /*+ Leading (xal1,xah1,xal2) index(xah1 XLA_AE_HEADERS_GT_U1) index(xal2 XLA_AE_LINES_GT_N2) no_expand */ -- 7128871
12898: xal2.segment1, xal2.segment2, xal2.segment3, xal2.segment4, xal2.segment5
12899: ,xal2.segment6, xal2.segment7, xal2.segment8, xal2.segment9, xal2.segment10
12900: ,xal2.segment11, xal2.segment12, xal2.segment13, xal2.segment14, xal2.segment15

Line 13025: END IF; -- 7128871 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'

13021: AND xal.temp_line_num = l_array_mpa_temp_line_num(i)
13022: AND xal.ae_header_id = l_array_mpa_ae_header_id(i)
13023: AND NVL(xal.header_num,0) = l_array_mpa_header_num(i);
13024: -------------------------------------------------------------------------------------------------------------------------
13025: END IF; -- 7128871 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
13026:
13027:
13028: /*-------------------------------------------------------------------------------------------------------------------
13029: -- Replaced for performance fix above