38: te.source_id_int_1 source_id_int_1,
39: te.security_id_int_1 security_id_int_1,
40: te.ledger_id ledger_id,
41: te.entity_code entity_code
42: FROM xla_events evt,
43: xla_transaction_entities_upg te
44: WHERE evt.application_id = 682
45: AND evt.event_status_code ='U'
46: AND evt.process_status_code IN ('U','I','D')
70:
71:
72: l_open_period_gl_date DATE := NULL;
73: l_event_date DATE := NULL;
74: l_event_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
75: l_security XLA_EVENTS_PUB_PKG.t_security;
76:
77: l_api_name CONSTANT VARCHAR2(30) := 'Update_GL_Date';
78: l_api_version CONSTANT NUMBER := 1.0;
71:
72: l_open_period_gl_date DATE := NULL;
73: l_event_date DATE := NULL;
74: l_event_source_info XLA_EVENTS_PUB_PKG.t_event_source_info;
75: l_security XLA_EVENTS_PUB_PKG.t_security;
76:
77: l_api_name CONSTANT VARCHAR2(30) := 'Update_GL_Date';
78: l_api_version CONSTANT NUMBER := 1.0;
79: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME ||'.'|| l_api_name;
172:
173: l_event_source_info.application_id := 682;
174:
175: --Call XLA Update API to update the event Date
176: XLA_EVENTS_PUB_PKG.update_event
177: (p_event_source_info => l_event_source_info
178: ,p_event_id => c_xla_event_data.event_id
179: ,p_event_type_code => c_xla_event_data.event_type_code
180: ,p_event_date => l_event_date