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_ACCOUNTING_ENGINE_PKG dependencies on XLA_AE_LINES

Line 64: | from XLA_AE_LINES_GT and XLA_AE_HEADERS_GT |

60: | bug 3786968. |
61: | 23-Sep-2004 S.Singhania Made changes for the bulk peroformance.It has|
62: | changed the code at number of places. |
63: | 05-Oct-2004 S.Singhania Bug 3931752: Added code to remove dummy rows |
64: | from XLA_AE_LINES_GT and XLA_AE_HEADERS_GT |
65: | (rows with balance_type_code = 'X') in |
66: | PostAccountingEngine |
67: | 08-Oct-2004 S.Singhania Bug 3928357: Made changes to make sure the |
68: | following cases are handled: |

Line 91: | XLA_AE_LINES_PKG.CalculateUnroundedAmounts |

87: | - PostAccounting |
88: | Fixed GSCC warning File.Sql.35 in TRACE. |
89: | 9-Mar-2005 W. SHen Ledger Currency Project |
90: | add call to |
91: | XLA_AE_LINES_PKG.CalculateUnroundedAmounts |
92: | XLA_AE_LINES_PKG.CalculateGainLossAmounts |
93: | XLA_AE_LINES_PKG.adjust_display_line_num |
94: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
95: | 25-May-2005 W. SHen remove call |

Line 92: | XLA_AE_LINES_PKG.CalculateGainLossAmounts |

88: | Fixed GSCC warning File.Sql.35 in TRACE. |
89: | 9-Mar-2005 W. SHen Ledger Currency Project |
90: | add call to |
91: | XLA_AE_LINES_PKG.CalculateUnroundedAmounts |
92: | XLA_AE_LINES_PKG.CalculateGainLossAmounts |
93: | XLA_AE_LINES_PKG.adjust_display_line_num |
94: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
95: | 25-May-2005 W. SHen remove call |
96: | XLA_AE_LINES_PKG.adjust_display_line_num|

Line 93: | XLA_AE_LINES_PKG.adjust_display_line_num |

89: | 9-Mar-2005 W. SHen Ledger Currency Project |
90: | add call to |
91: | XLA_AE_LINES_PKG.CalculateUnroundedAmounts |
92: | XLA_AE_LINES_PKG.CalculateGainLossAmounts |
93: | XLA_AE_LINES_PKG.adjust_display_line_num |
94: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
95: | 25-May-2005 W. SHen remove call |
96: | XLA_AE_LINES_PKG.adjust_display_line_num|
97: | 17-Jun-2005 W. SHen add call UpdateRelatedErrorsStatus back |

Line 96: | XLA_AE_LINES_PKG.adjust_display_line_num|

92: | XLA_AE_LINES_PKG.CalculateGainLossAmounts |
93: | XLA_AE_LINES_PKG.adjust_display_line_num |
94: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
95: | 25-May-2005 W. SHen remove call |
96: | XLA_AE_LINES_PKG.adjust_display_line_num|
97: | 17-Jun-2005 W. SHen add call UpdateRelatedErrorsStatus back |
98: | bug 4155511 |
99: | 24-Jun-2005 W. Chan Fix bug4092230 - Add ValidateCompleteAADDefn |
100: | 11-Jul-2005 A. Wan Changed for MPA. 4262811 |

Line 647: (p_msg => '#Line reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT

643: (p_msg => 'BEGIN of DeleteIncompleteMPA'
644: ,p_level => C_LEVEL_PROCEDURE
645: ,p_module => l_log_module);
646: trace
647: (p_msg => '#Line reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT
648: ,p_level => C_LEVEL_PROCEDURE
649: ,p_module => l_log_module);
650: trace
651: (p_msg => '#Tran reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT

Line 651: (p_msg => '#Tran reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT

647: (p_msg => '#Line reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT
648: ,p_level => C_LEVEL_PROCEDURE
649: ,p_module => l_log_module);
650: trace
651: (p_msg => '#Tran reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT
652: ,p_level => C_LEVEL_PROCEDURE
653: ,p_module => l_log_module);
654: END IF;
655: --

Line 660: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT LOOP -- 5108415

656:
657: ------------------------------
658: -- Line Reversal
659: ------------------------------
660: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT LOOP -- 5108415
661:
662: ------------------------------------------------------------------------------------
663: -- Find incomplete MPA entries whose original/parent has been reversed
664: ------------------------------------------------------------------------------------

Line 675: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_parent_ae_header(i) -- 5108415

671: ,xla_ae_headers xeh4 -- original entries
672: --------------------------------------------------------------
673: -- Find the original/parent
674: --------------------------------------------------------------
675: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_parent_ae_header(i) -- 5108415
676: AND xeh4.application_id = p_application_id
677: AND xdl2.application_id = p_application_id
678: AND xdl2.ref_ae_header_id = xeh4.ae_header_id -- original's ae_header_id
679: AND xdl2.ref_event_id = xeh4.event_id

Line 693: AND xeh3.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id(i) -- 5108415

689: --------------------------------------------------------------
690: -- Determine this is a incomplete MPA with same orginal/parent
691: --------------------------------------------------------------
692: AND xeh3.application_id = p_application_id
693: AND xeh3.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id(i) -- 5108415
694: AND xeh3.parent_ae_header_id = xeh4.ae_header_id
695: AND xeh3.event_id = xeh4.event_id
696: AND xeh3.accounting_entry_status_code <> 'F'
697: ORDER by xeh3.ledger_id, xeh3.entity_id, xeh3.ae_header_id;

Line 720: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(k);

716: ---------------------------------------------------------------
717: -- Delete incomplete MPA entries
718: ---------------------------------------------------------------
719: FORALL k in 1..l_array_LR_incomplete_mpa.COUNT
720: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(k);
721: FORALL l in 1..l_array_LR_incomplete_mpa.COUNT
722: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(l);
723: FORALL m in 1..l_array_LR_incomplete_mpa.COUNT
724: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(m);

Line 732: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT LOOP -- 5108415

728:
729: ------------------------------
730: -- Transaction Reversal
731: ------------------------------
732: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT LOOP -- 5108415
733: ------------------------------------------------------------------------------------
734: -- Find incomplete MPA entries whose original/parent has been reversed
735: ------------------------------------------------------------------------------------
736: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id

Line 745: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_parent_ae_header(i) -- 5108415

741: ,xla_ae_headers xeh4 -- original entries
742: --------------------------------------------------------------
743: -- Find the original/parent
744: --------------------------------------------------------------
745: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_parent_ae_header(i) -- 5108415
746: AND xeh4.application_id = p_application_id
747: AND xdl2.application_id = p_application_id
748: AND xdl2.ref_ae_header_id = xeh4.ae_header_id -- original's ae_header_id
749: AND xdl2.ref_event_id = xeh4.event_id

Line 763: AND xeh3.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id(i) -- 5108415

759: --------------------------------------------------------------
760: -- Determine this is a incomplete MPA with same orginal/parent
761: --------------------------------------------------------------
762: AND xeh3.application_id = p_application_id
763: AND xeh3.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id(i) -- 5108415
764: AND xeh3.parent_ae_header_id = xeh4.ae_header_id
765: AND xeh3.event_id = xeh4.event_id
766: AND xeh3.accounting_entry_status_code <> 'F'
767: ORDER by xeh3.ledger_id, xeh3.entity_id, xeh3.ae_header_id;

Line 790: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(k);

786: ---------------------------------------------------------------
787: -- Delete incomplete MPA entries
788: ---------------------------------------------------------------
789: FORALL k in 1..l_array_TR_incomplete_mpa.COUNT
790: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(k);
791: FORALL l in 1..l_array_TR_incomplete_mpa.COUNT
792: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(l);
793: FORALL m in 1..l_array_TR_incomplete_mpa.COUNT
794: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(m);

Line 1021: (p_msg => '--> CALL XLA_AE_LINES_PKG.CalculateUnroundedAmounts'

1017: */
1018:
1019: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1020: trace
1021: (p_msg => '--> CALL XLA_AE_LINES_PKG.CalculateUnroundedAmounts'
1022: ,p_level => C_LEVEL_STATEMENT
1023: ,p_module => l_log_module);
1024: END IF;
1025:

Line 1027: XLA_AE_LINES_PKG.CalculateUnroundedAmounts;

1023: ,p_module => l_log_module);
1024: END IF;
1025:
1026: -- set the unrounded accounted amount
1027: XLA_AE_LINES_PKG.CalculateUnroundedAmounts;
1028:
1029: ---------------------------------------
1030: -- 4219869 - Process Business Flow Entries
1031: ---------------------------------------

Line 1032: XLA_AE_LINES_PKG.BusinessFlowPriorEntries(p_accounting_mode,p_ledger_id,p_budgetary_control_mode); -- 5357406

1028:
1029: ---------------------------------------
1030: -- 4219869 - Process Business Flow Entries
1031: ---------------------------------------
1032: XLA_AE_LINES_PKG.BusinessFlowPriorEntries(p_accounting_mode,p_ledger_id,p_budgetary_control_mode); -- 5357406
1033: XLA_AE_LINES_PKG.BusinessFlowSameEntries;
1034:
1035: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1036: trace

Line 1033: XLA_AE_LINES_PKG.BusinessFlowSameEntries;

1029: ---------------------------------------
1030: -- 4219869 - Process Business Flow Entries
1031: ---------------------------------------
1032: XLA_AE_LINES_PKG.BusinessFlowPriorEntries(p_accounting_mode,p_ledger_id,p_budgetary_control_mode); -- 5357406
1033: XLA_AE_LINES_PKG.BusinessFlowSameEntries;
1034:
1035: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1036: trace
1037: (p_msg => '--> CALL LA_AE_LINES_PKG.CalculateGainLossAmounts'

Line 1042: XLA_AE_LINES_PKG.CalculateGainLossAmounts;

1038: ,p_level => C_LEVEL_STATEMENT
1039: ,p_module => l_log_module);
1040: END IF;
1041: -- calculate the gain/loss amount
1042: XLA_AE_LINES_PKG.CalculateGainLossAmounts;
1043:
1044:
1045: ---------------------------------------------------------------------------
1046: -- 4219869 moved to after bflow procedures

Line 1064: (p_msg => '--> CALL XLA_AE_LINES_PKG.AccountingReversal'

1060: -- bulk performance
1061: --
1062: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1063: trace
1064: (p_msg => '--> CALL XLA_AE_LINES_PKG.AccountingReversal'
1065: ,p_level => C_LEVEL_STATEMENT
1066: ,p_module => l_log_module);
1067: END IF;
1068:

Line 1069: XLA_AE_LINES_PKG.AccountingReversal(CASE WHEN p_budgetary_control_mode = 'NONE'

1065: ,p_level => C_LEVEL_STATEMENT
1066: ,p_module => l_log_module);
1067: END IF;
1068:
1069: XLA_AE_LINES_PKG.AccountingReversal(CASE WHEN p_budgetary_control_mode = 'NONE'
1070: THEN p_accounting_mode
1071: ELSE p_budgetary_control_mode END);
1072:
1073: --

Line 1089: FROM xla_ae_lines_gt

1085: END IF;
1086:
1087: SELECT DISTINCT event_id BULK COLLECT
1088: INTO l_array_temp_events
1089: FROM xla_ae_lines_gt
1090: WHERE reversal_code = 'DUMMY_LR_ERROR';
1091:
1092: FORALL i IN 1..l_array_temp_events.COUNT
1093: UPDATE xla_events_gt

Line 1105: -- Delete the dummy lines from xla_ae_lines_gt table

1101: ,p_level => C_LEVEL_STATEMENT
1102: ,p_module => l_log_module);
1103: END IF;
1104: --
1105: -- Delete the dummy lines from xla_ae_lines_gt table
1106: --
1107: DELETE FROM xla_ae_lines_gt
1108: WHERE balance_type_code = 'X'
1109: OR (unrounded_accounted_cr is null AND unrounded_accounted_dr is null AND gain_or_loss_flag = 'Y' AND calculate_g_l_amts_flag= 'Y');

Line 1107: DELETE FROM xla_ae_lines_gt

1103: END IF;
1104: --
1105: -- Delete the dummy lines from xla_ae_lines_gt table
1106: --
1107: DELETE FROM xla_ae_lines_gt
1108: WHERE balance_type_code = 'X'
1109: OR (unrounded_accounted_cr is null AND unrounded_accounted_dr is null AND gain_or_loss_flag = 'Y' AND calculate_g_l_amts_flag= 'Y');
1110:
1111: DELETE FROM xla_ae_headers_gt