71: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
72:
73: /*Bug 7299779 -- vavenugo */
74: /* Variables declared for updating events */
75: l_event_source_info xla_events_pub_pkg.t_event_source_info;
76: l_event_id NUMBER;
77: l_security xla_events_pub_pkg.t_security;
78: l_event_count NUMBER;
79: l_trh_count NUMBER;
73: /*Bug 7299779 -- vavenugo */
74: /* Variables declared for updating events */
75: l_event_source_info xla_events_pub_pkg.t_event_source_info;
76: l_event_id NUMBER;
77: l_security xla_events_pub_pkg.t_security;
78: l_event_count NUMBER;
79: l_trh_count NUMBER;
80:
81: cursor update_event (p_trx_id ra_customer_trx.customer_trx_id%TYPE)
379: open update_event (p_trh_rec.customer_trx_id);
380: loop
381: fetch update_event into l_event_id;
382: exit when update_event%NOTFOUND;
383: xla_events_pub_pkg.update_event
384: ( p_event_source_info => l_event_source_info,
385: p_event_id => l_event_id,
386: p_event_status_code => 'N',
387: p_valuation_method => null,