XLA: Delete event XLA_EVENTS


-- Creted by Prudhvi </code>

DECLARE
p_event_source_info xla_events_pub_pkg.t_event_source_info;
BEGIN

p_event_source_info.source_application_id := NULL; --101 GL -- 602 XLE
p_event_source_info.application_id := 222; -- AR
p_event_source_info.legal_entity_id := 1234;
p_event_source_info.ledger_id := 1;
p_event_source_info.entity_type_code := 'TRANSACTIONS';
p_event_source_info.transaction_number := NULL;
p_event_source_info.source_id_int_1 := 1234; -- Customer Transaction ID;
p_event_source_info.source_id_int_2 := NULL;
p_event_source_info.source_id_int_3 := NULL;
p_event_source_info.source_id_int_4 := NULL;
p_event_source_info.source_id_char_1 := NULL;
p_event_source_info.source_id_char_2 := NULL;
p_event_source_info.source_id_char_3 := NULL;
p_event_source_info.source_id_char_4 := NULL;

xla_events_pub_pkg.delete_event
(p_event_source_info =&gt; p_event_source_info,
p_event_id =&gt; 1234, -- xla_events
p_valuation_method =&gt; NULL,
p_security_context =&gt; NULL
);

DBMS_OUTPUT.put_line('Updated Status');
commit;

exception when others then

DBMS_OUTPUT.put_line('Error:'||SQLERRM);
END;

 

, , , ,