APPS.XLA_AE_LINES_PKG dependencies on XLA_ACCOUNTING_PKG

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

4317: (p_msg => 'Application ID ='||to_char(l_application_id)
4318: ,p_level => C_LEVEL_STATEMENT
4319: ,p_module => l_log_module);
4320: trace -- 5412560
4321: (p_msg => 'MPA Line Reversal exists = '||xla_accounting_pkg.g_mpa_accrual_exists
4322: ,p_level => C_LEVEL_STATEMENT
4323: ,p_module => l_log_module);
4324: END IF;
4325:

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

4421: ---------------------------------------------------------------------------------------------------------
4422: -- 4669308 Delete the MPA/Accrual Line Reversal in xla_ae_lines_gt (not in distribution links yet)
4423: ---------------------------------------------------------------------------------------------------------
4424: --
4425: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560
4426: -- Modify for performance bug 5086984
4427: FOR i IN 1..l_array_entity_id.count LOOP
4428: SELECT /*+ Leading(HGT) cardinality(hgt 1) index(lgt XLA_AE_LINES_GT_U1) */
4429: lgt.ledger_id

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

4521: AND header_num = l_array_mpa_acc_header_num(j);
4522:
4523: END LOOP;
4524: --
4525: END IF; -- xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
4526: -------------------------------------------------------------------------------------------------------------------------
4527: /****** CHANGES FOR MPA CANCELLATION *******/
4528: /* ACCOUNTING BOTH ORIGINAL AND MPA/ACCRUAL REVERSAL PRIOR TO CANCELLATION DATE
4529: IS REVERSED ON THE CANCELLATION DATE.

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

6328: ---------------------------------------------------------------------------------------------------------
6329: -- 4669308 Delete the MPA/Accrual Transaction Reversal in xla_ae_lines_gt (not in distribution links yet)
6330: ---------------------------------------------------------------------------------------------------------
6331: --
6332: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5412560
6333: FORALL i IN 1..l_array_entity_id.count
6334: DELETE xla_ae_lines_gt lgt
6335: WHERE l_array_ledger_id(i) = lgt.ledger_id
6336: AND lgt.reversal_code IS NULL -- the lines created from reversal are not reversed again

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

11856: (p_msg => 'method = '||xla_accounting_cache_pkg.GetValueChar('VALUATION_METHOD_FLAG')
11857: ,p_level => C_LEVEL_PROCEDURE
11858: ,p_module => l_log_module);
11859: trace
11860: (p_msg => 'g_mpa_accrual_exists = '||xla_accounting_pkg.g_mpa_accrual_exists
11861: ,p_level => C_LEVEL_PROCEDURE
11862: ,p_module => l_log_module);
11863: END IF;
11864:

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

12396:
12397: -------------------------------------------------------------------------------------------------------------------------
12398: -- 4655713b Update MPA and Accrual Reversal lines with Prior Entry
12399: -------------------------------------------------------------------------------------------------------------------------
12400: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 5666366
12401: SELECT /*+ Leading (xal1,xah1,xal2) index(xah1 XLA_AE_HEADERS_GT_U1) index(xal2 XLA_AE_LINES_GT_N2) no_expand */ -- 5666366
12402: xal2.segment1, xal2.segment2, xal2.segment3, xal2.segment4, xal2.segment5
12403: ,xal2.segment6, xal2.segment7, xal2.segment8, xal2.segment9, xal2.segment10
12404: ,xal2.segment11, xal2.segment12, xal2.segment13, xal2.segment14, xal2.segment15

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

12688: WHERE xal.ledger_id = l_array_mpa_ledger_id(i)
12689: AND xal.ref_ae_header_id = l_array_mpa_ref_ae_header_id(i)
12690: AND xal.ae_header_id = l_array_mpa_ae_header_id(i)
12691: AND NVL(xal.header_num,0) = l_array_mpa_header_num(i);
12692: END IF; -- 5666366 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
12693: -------------------------------------------------------------------------------------------------------------------------
12694:
12695:
12696: -------------------------------------------------------------------------

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

13428:
13429: -------------------------------------------------------------------------------------------------------------------------
13430: -- 4655713b Updates MPA-Accrual (not MPA-Recognition) and Accrual Reversal lines with Same Entry
13431: -------------------------------------------------------------------------------------------------------------------------
13432: IF xla_accounting_pkg.g_mpa_accrual_exists = 'Y' THEN -- 7128871
13433: SELECT /*+ Leading (xal1,xah1,xal2) index(xah1 XLA_AE_HEADERS_GT_U1) index(xal2 XLA_AE_LINES_GT_N2) no_expand */ -- 7128871
13434: xal2.segment1, xal2.segment2, xal2.segment3, xal2.segment4, xal2.segment5
13435: ,xal2.segment6, xal2.segment7, xal2.segment8, xal2.segment9, xal2.segment10
13436: ,xal2.segment11, xal2.segment12, xal2.segment13, xal2.segment14, xal2.segment15

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

13558: AND xal.temp_line_num = l_array_mpa_temp_line_num(i)
13559: AND xal.ae_header_id = l_array_mpa_ae_header_id(i)
13560: AND NVL(xal.header_num,0) = l_array_mpa_header_num(i);
13561: -------------------------------------------------------------------------------------------------------------------------
13562: END IF; -- 7128871 xla_accounting_pkg.g_mpa_accrual_exists = 'Y'
13563:
13564:
13565: /*-------------------------------------------------------------------------------------------------------------------
13566: -- Replaced for performance fix above