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 652: (p_msg => '#Line reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT

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

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

652: (p_msg => '#Line reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT
653: ,p_level => C_LEVEL_PROCEDURE
654: ,p_module => l_log_module);
655: trace
656: (p_msg => '#Tran reversal lines = '||xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT
657: ,p_level => C_LEVEL_PROCEDURE
658: ,p_module => l_log_module);
659: END IF;
660: --

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

661:
662: ------------------------------
663: -- Line Reversal
664: ------------------------------
665: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_ae_header_id.COUNT LOOP -- 5108415
666:
667: ------------------------------------------------------------------------------------
668: -- Find incomplete MPA entries whose original/parent has been reversed
669: ------------------------------------------------------------------------------------

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

676: ,xla_ae_headers xeh4 -- original entries
677: --------------------------------------------------------------
678: -- Find the original/parent
679: --------------------------------------------------------------
680: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_LR.l_array_parent_ae_header(i) -- 5108415
681: AND xeh4.application_id = p_application_id
682: AND xdl2.application_id = p_application_id
683: AND xdl2.ref_ae_header_id = xeh4.ae_header_id -- original's ae_header_id
684: AND xdl2.ref_event_id = xeh4.event_id

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

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

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

721: ---------------------------------------------------------------
722: -- Delete incomplete MPA entries
723: ---------------------------------------------------------------
724: FORALL k in 1..l_array_LR_incomplete_mpa.COUNT
725: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(k);
726: FORALL l in 1..l_array_LR_incomplete_mpa.COUNT
727: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(l);
728: FORALL m in 1..l_array_LR_incomplete_mpa.COUNT
729: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_LR_incomplete_mpa(m);

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

733:
734: ------------------------------
735: -- Transaction Reversal
736: ------------------------------
737: FOR i in 1..xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_ae_header_id.COUNT LOOP -- 5108415
738: ------------------------------------------------------------------------------------
739: -- Find incomplete MPA entries whose original/parent has been reversed
740: ------------------------------------------------------------------------------------
741: SELECT distinct xeh3.ae_header_id, xeh3.ledger_id, xeh3.entity_id

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

746: ,xla_ae_headers xeh4 -- original entries
747: --------------------------------------------------------------
748: -- Find the original/parent
749: --------------------------------------------------------------
750: WHERE xeh4.ae_header_id = xla_ae_lines_pkg.g_incomplete_mpa_acc_TR.l_array_parent_ae_header(i) -- 5108415
751: AND xeh4.application_id = p_application_id
752: AND xdl2.application_id = p_application_id
753: AND xdl2.ref_ae_header_id = xeh4.ae_header_id -- original's ae_header_id
754: AND xdl2.ref_event_id = xeh4.event_id

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

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

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

791: ---------------------------------------------------------------
792: -- Delete incomplete MPA entries
793: ---------------------------------------------------------------
794: FORALL k in 1..l_array_TR_incomplete_mpa.COUNT
795: DELETE xla_ae_lines WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(k);
796: FORALL l in 1..l_array_TR_incomplete_mpa.COUNT
797: DELETE xla_ae_headers WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(l);
798: FORALL m in 1..l_array_TR_incomplete_mpa.COUNT
799: DELETE xla_distribution_links WHERE application_id = p_application_id AND ae_header_id = l_array_TR_incomplete_mpa(m);

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

1039: */
1040:
1041: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1042: trace
1043: (p_msg => '--> CALL XLA_AE_LINES_PKG.CalculateUnroundedAmounts'
1044: ,p_level => C_LEVEL_STATEMENT
1045: ,p_module => l_log_module);
1046: END IF;
1047:

Line 1049: XLA_AE_LINES_PKG.CalculateUnroundedAmounts;

1045: ,p_module => l_log_module);
1046: END IF;
1047:
1048: -- set the unrounded accounted amount
1049: XLA_AE_LINES_PKG.CalculateUnroundedAmounts;
1050:
1051: ---------------------------------------
1052: -- 4219869 - Process Business Flow Entries
1053: ---------------------------------------

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

1050:
1051: ---------------------------------------
1052: -- 4219869 - Process Business Flow Entries
1053: ---------------------------------------
1054: XLA_AE_LINES_PKG.BusinessFlowPriorEntries(p_accounting_mode,p_ledger_id,p_budgetary_control_mode); -- 5357406
1055: -- Moved call to BusinessflowSameEntry after Map_ccid,bug 6675871
1056: --XLA_AE_LINES_PKG.BusinessFlowSameEntries;
1057:
1058:

Line 1056: --XLA_AE_LINES_PKG.BusinessFlowSameEntries;

1052: -- 4219869 - Process Business Flow Entries
1053: ---------------------------------------
1054: XLA_AE_LINES_PKG.BusinessFlowPriorEntries(p_accounting_mode,p_ledger_id,p_budgetary_control_mode); -- 5357406
1055: -- Moved call to BusinessflowSameEntry after Map_ccid,bug 6675871
1056: --XLA_AE_LINES_PKG.BusinessFlowSameEntries;
1057:
1058:
1059:
1060: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1068: XLA_AE_LINES_PKG.CalculateGainLossAmounts;

1064: ,p_module => l_log_module);
1065:
1066: END IF;
1067: -- calculate the gain/loss amount
1068: XLA_AE_LINES_PKG.CalculateGainLossAmounts;
1069:
1070:
1071: ---------------------------------------------------------------------------
1072: -- 4219869 moved to after bflow procedures

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

1086: -- bulk performance
1087: --
1088: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1089: trace
1090: (p_msg => '--> CALL XLA_AE_LINES_PKG.AccountingReversal'
1091: ,p_level => C_LEVEL_STATEMENT
1092: ,p_module => l_log_module);
1093: END IF;
1094:

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

1091: ,p_level => C_LEVEL_STATEMENT
1092: ,p_module => l_log_module);
1093: END IF;
1094:
1095: XLA_AE_LINES_PKG.AccountingReversal(CASE WHEN p_budgetary_control_mode = 'NONE'
1096: THEN p_accounting_mode
1097: ELSE p_budgetary_control_mode END);
1098:
1099: --

Line 1115: FROM xla_ae_lines_gt

1111: END IF;
1112:
1113: SELECT DISTINCT event_id BULK COLLECT
1114: INTO l_array_temp_events
1115: FROM xla_ae_lines_gt
1116: WHERE reversal_code = 'DUMMY_LR_ERROR';
1117:
1118: FORALL i IN 1..l_array_temp_events.COUNT
1119: UPDATE xla_events_gt

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

1127: ,p_level => C_LEVEL_STATEMENT
1128: ,p_module => l_log_module);
1129: END IF;
1130: --
1131: -- Delete the dummy lines from xla_ae_lines_gt table
1132: --
1133: DELETE FROM xla_ae_lines_gt
1134: WHERE balance_type_code = 'X'
1135: 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 1133: DELETE FROM xla_ae_lines_gt

1129: END IF;
1130: --
1131: -- Delete the dummy lines from xla_ae_lines_gt table
1132: --
1133: DELETE FROM xla_ae_lines_gt
1134: WHERE balance_type_code = 'X'
1135: 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');
1136:
1137: DELETE FROM xla_ae_headers_gt