[Home] [Help]
796: DELETE xla_ae_lines
797: WHERE application_id = p_application_id
798: AND ae_header_id = i.ae_header_id;
799: --
800: DELETE xla_distribution_links
801: WHERE application_id = p_application_id
802: AND ae_header_id = i.ae_header_id;
803: --
804: DELETE xla_ae_headers
1152: WHERE application_id = p_application_id
1153: AND ae_header_id = l_array_ae_header_id(i);
1154:
1155: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1156: trace(p_msg => 'Update xla_distribution_links',
1157: p_module => l_log_module,
1158: p_level => C_LEVEL_STATEMENT);
1159: END IF;
1160:
1158: p_level => C_LEVEL_STATEMENT);
1159: END IF;
1160:
1161: FORALL i in 1..l_array_ae_header_id.COUNT
1162: UPDATE xla_distribution_links
1163: SET event_id = x_new_event_id,
1164: temp_line_num = abs(temp_line_num) -- added for RCA bug#8421688
1165: WHERE application_id = p_application_id
1166: AND ae_header_id = l_array_ae_header_id(i);
1169: bug#8421688:
1170: On undoing a cancelled event like invoice cancellation or payment cancellation, the redo of that event
1171: is resulting in accounting error as the NOT EXISTS of the following select fails in xla_ae_lines_pkg
1172: accounting_reversal procedure.
1173: SELECT 1 FROM xla_distribution_links xdl
1174: WHERE ref_ae_header_id = xdl.ae_header_id
1175: AND temp_line_num = xdl.temp_line_num * -1
1176: AND application_id = xdl.application_id
1177: Fix is to make the E3 event temp_line_num +ve for a cancelled event in xla_distribution_links table
1173: SELECT 1 FROM xla_distribution_links xdl
1174: WHERE ref_ae_header_id = xdl.ae_header_id
1175: AND temp_line_num = xdl.temp_line_num * -1
1176: AND application_id = xdl.application_id
1177: Fix is to make the E3 event temp_line_num +ve for a cancelled event in xla_distribution_links table
1178: using abs(temp_line_num).
1179: */
1180:
1181: IF (C_LEVEL_STATEMENT >= g_log_level) THEN