APPS.XLA_ACCOUNTING_ENGINE_PKG dependencies on XLA_AE_LINES_GT

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 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