374: -- load the array as required by SLA:
375: -- verify event number and transaction number relevance here
376: -- since neither table uses a transaction sequence
377: forall i in 1..p_asset_id_tbl.count
378: insert into xla_events_int_gt
379: (APPLICATION_ID ,
380: LEDGER_ID ,
381: LEGAL_ENTITY_ID ,
382: ENTITY_CODE ,
417: );
418:
419: select event_id bulk collect
420: into x_event_id_tbl
421: from xla_events_int_gt
422: order by event_number;
423:
424: EXCEPTION
425: WHEN OTHERS THEN
467: -- load the array as required by SLA:
468: -- verify event number and transaction number relevance here
469: -- since neither table uses a transaction sequence
470: forall i in 1..p_asset_id_tbl.count
471: insert into xla_events_int_gt
472: (APPLICATION_ID ,
473: LEDGER_ID ,
474: LEGAL_ENTITY_ID ,
475: ENTITY_CODE ,
510: );
511:
512: select event_id bulk collect
513: into x_event_id_tbl
514: from xla_events_int_gt
515: order by event_number;
516:
517:
518: EXCEPTION