APPS.XLA_UPDATE_INVAL_CCID dependencies on XLA_AE_LINES

Line 265: UPDATE xla_ae_lines xal

261:
262: -- Updateing with the new ccid
263: print_logfile (p_new_ccid || ' p_new_ccid');
264: FORALL i IN l_ccid.FIRST .. l_ccid.LAST
265: UPDATE xla_ae_lines xal
266: SET xal.code_combination_id = p_new_ccid
267: WHERE application_id = p_application_id
268: AND ae_header_id IN (
269: SELECT ae_header_id

Line 295: UPDATE xla_ae_lines xal

291: print_logfile (l_ccid (i));
292: END LOOP;
293:
294: FORALL i IN l_ccid.FIRST .. l_ccid.LAST
295: UPDATE xla_ae_lines xal
296: SET xal.code_combination_id = p_status -- -2
297: WHERE application_id = p_application_id
298: AND ae_header_id IN (
299: SELECT ae_header_id

Line 307: print_logfile ('No. of xla_ae_lines Records ' || SQL%ROWCOUNT);

303: AND ledger_id = p_ledger_id)
304: AND code_combination_id = l_ccid (i)
305: RETURNING ae_header_id
306: BULK COLLECT INTO l_ae_header_id;
307: print_logfile ('No. of xla_ae_lines Records ' || SQL%ROWCOUNT);
308: FORALL j IN l_ae_header_id.FIRST .. l_ae_header_id.LAST
309: UPDATE xla_ae_headers
310: SET accounting_entry_status_code = 'I'
311: WHERE application_id = p_application_id