APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_EVENTS

Line 202: l_application_id xla_events.application_id%TYPE;

198: l_log_module VARCHAR2(240);
199: l_stamp_query VARCHAR2(32000);
200: l_percl_query VARCHAR2(10000);
201: l_filters VARCHAR2(1000);
202: l_application_id xla_events.application_id%TYPE;
203:
204: C_EVENTS_WO_AAD CONSTANT VARCHAR2(10000) :=
205: ' UPDATE xla_events xle
206: SET xle.event_status_code = ''P''

Line 205: ' UPDATE xla_events xle

201: l_filters VARCHAR2(1000);
202: l_application_id xla_events.application_id%TYPE;
203:
204: C_EVENTS_WO_AAD CONSTANT VARCHAR2(10000) :=
205: ' UPDATE xla_events xle
206: SET xle.event_status_code = ''P''
207: ,xle.process_status_code = ''P''
208: ,xle.last_update_date = sysdate
209: ,xle.last_updated_by = fnd_global.user_id

Line 489: ' FROM XLA_EVENTS XLE

485: ,NULL BALANCE_TYPE
486: ,xlo1.meaning PRINT_STATUS ';
487:
488: C_EVENTS_FROM_QUERY :=
489: ' FROM XLA_EVENTS XLE
490: ,XLA_TRANSACTION_ENTITIES ENT
491: ,XLA_SUBLEDGERS XLS
492: ,FND_USER FNU
493: ,GL_PERIOD_STATUSES GPS

Line 583: ,XLA_EVENTS XLE

579: ,xlo4.meaning PRINT_STATUS ';
580:
581: C_HEADERS_FROM_QUERY :=
582: ' FROM XLA_AE_HEADERS AEH
583: ,XLA_EVENTS XLE
584: ,XLA_TRANSACTION_ENTITIES ENT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU
587: ,GL_PERIOD_STATUSES GPS

Line 662: FROM xla_events xle

658: xle.application_id APPLICATION_ID
659: ,xcl.entity_code ENTITY_CODE
660: ,xcl.event_class_code EVENT_CLASS_CODE
661: ,gjct.reporting_view_name REPORTING_VIEW_NAME
662: FROM xla_events xle
663: ,xla_event_types_b xcl
664: ,xla_event_class_attrs gjct
665: ,xla_transaction_entities ent
666: ,xla_ledger_options xlo

Line 1410: FROM xla_events xle

1406: SELECT 1
1407: INTO l_unprocessed
1408: FROM dual
1409: WHERE EXISTS(select 1
1410: FROM xla_events xle
1411: ,xla_transaction_entities xte
1412: ,gl_ledger_relationships glr1
1413: ,gl_ledger_relationships glr2
1414: ,xla_ledger_options xlo

Line 1469: FROM xla_events xle

1465: SELECT 1
1466: INTO l_unprocessed
1467: FROM dual
1468: WHERE EXISTS(select 1
1469: FROM xla_events xle
1470: ,xla_transaction_entities xte
1471: ,gl_ledger_relationships glr1
1472: ,gl_ledger_relationships glr2
1473: ,xla_ledger_options xlo