Wednesday, October 31, 2018

API: Update event status code in XLA_EVENTS

API: Update event status code in XLA_EVENTS

-- Created by Prudhvi 

DECLARE
p_event_source_info xla_events_pub_pkg.t_event_source_info;
BEGIN

p_event_source_info.source_application_id  := NULL;     
p_event_source_info.application_id         := 222;       -- AR
p_event_source_info.legal_entity_id        := 12340;     -- change it 
p_event_source_info.ledger_id              := 1;        -- change it
p_event_source_info.entity_type_code       := 'TRANSACTIONS';       
p_event_source_info.transaction_number     := '1234';    -- change it   
p_event_source_info.source_id_int_1        := 1234; --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.update_event_status
   (p_event_source_info         =>   p_event_source_info,
    p_event_class_code          =>   'INVOICE',
    p_event_type_code           =>   'INV_CREATE',
    p_event_date                =>   '20-JAN-17',
    p_event_status_code         =>   'U', -- un processed
    p_valuation_method          =>   NULL,
    p_security_context          =>   NULL
   );
   
   
   DBMS_OUTPUT.put_line('Updated Status');
   commit;
   
exception when others then
   DBMS_OUTPUT.put_line('Error:'||SQLERRM);
END;

No comments:

Post a Comment

SQL Important Queries

  How to delete rows with no where clause The following example deletes  all rows  from the  Person.Person  the table in the AdventureWork...