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