APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_EVENTS

Line 208: l_application_id xla_events.application_id%TYPE;

204: l_log_module VARCHAR2(240);
205: l_stamp_query VARCHAR2(32000);
206: l_percl_query VARCHAR2(10000);
207: l_filters VARCHAR2(1000);
208: l_application_id xla_events.application_id%TYPE;
209:
210: C_EVENTS_WO_AAD CONSTANT VARCHAR2(10000) :=
211: ' UPDATE xla_events xle
212: SET xle.event_status_code = ''P''

Line 211: ' UPDATE xla_events xle

207: l_filters VARCHAR2(1000);
208: l_application_id xla_events.application_id%TYPE;
209:
210: C_EVENTS_WO_AAD CONSTANT VARCHAR2(10000) :=
211: ' UPDATE xla_events xle
212: SET xle.event_status_code = ''P''
213: ,xle.process_status_code = ''P''
214: ,xle.last_update_date = sysdate
215: ,xle.last_updated_by = fnd_global.user_id

Line 495: ' FROM XLA_EVENTS XLE

491: ,NULL BALANCE_TYPE
492: ,xlo1.meaning PRINT_STATUS ';
493:
494: C_EVENTS_FROM_QUERY :=
495: ' FROM XLA_EVENTS XLE
496: ,XLA_TRANSACTION_ENTITIES ENT
497: ,XLA_SUBLEDGERS XLS
498: ,FND_USER FNU
499: ,GL_PERIOD_STATUSES GPS

Line 590: ,XLA_EVENTS XLE

586: ,xlo4.meaning PRINT_STATUS ';
587:
588: C_HEADERS_FROM_QUERY :=
589: ' FROM XLA_AE_HEADERS AEH
590: ,XLA_EVENTS XLE
591: ,XLA_TRANSACTION_ENTITIES ENT
592: ,XLA_SUBLEDGERS XLS
593: ,FND_USER FNU
594: ,GL_PERIOD_STATUSES GPS

Line 669: FROM xla_events xle

665: xle.application_id APPLICATION_ID
666: ,xcl.entity_code ENTITY_CODE
667: ,xcl.event_class_code EVENT_CLASS_CODE
668: ,gjct.reporting_view_name REPORTING_VIEW_NAME
669: FROM xla_events xle
670: ,xla_event_types_b xcl
671: ,xla_event_class_attrs gjct
672: ,xla_transaction_entities ent
673: ,xla_ledger_options xlo

Line 1461: FROM xla_events xle

1457: SELECT 1
1458: INTO l_unprocessed
1459: FROM dual
1460: WHERE EXISTS(select 1
1461: FROM xla_events xle
1462: ,xla_transaction_entities xte
1463: ,gl_ledger_relationships glr1
1464: ,gl_ledger_relationships glr2
1465: ,xla_ledger_options xlo

Line 1520: FROM xla_events xle

1516: SELECT 1
1517: INTO l_unprocessed
1518: FROM dual
1519: WHERE EXISTS(select 1
1520: FROM xla_events xle
1521: ,xla_transaction_entities xte
1522: ,gl_ledger_relationships glr1
1523: ,gl_ledger_relationships glr2
1524: ,xla_ledger_options xlo