DBA Data[Home] [Help]

APPS.CE_XLA_ACCT_EVENTS_PKG dependencies on XLA_ENTITY_EVENTS_V

Line 550: | 2. Based on p_report_request_id, get the list of event ID from XLA_ENTITY_EVENTS_V

546: |
547: | The following is the API logic:
548: |
549: | 1. If p_accounting_mode = 'D' (draft accounting) then don't do anything.
550: | 2. Based on p_report_request_id, get the list of event ID from XLA_ENTITY_EVENTS_V
551: | 3. For each event ID, check the PROCESS_STATUS_CODE column in XLA_ENTITY_EVENTS_V.
552: | If process_status_code = 'E' then
553: | Update cash flow acct history status (status_code) to 'Accounting Error'
554: | Else if process_status_code = 'P' then

Line 551: | 3. For each event ID, check the PROCESS_STATUS_CODE column in XLA_ENTITY_EVENTS_V.

547: | The following is the API logic:
548: |
549: | 1. If p_accounting_mode = 'D' (draft accounting) then don't do anything.
550: | 2. Based on p_report_request_id, get the list of event ID from XLA_ENTITY_EVENTS_V
551: | 3. For each event ID, check the PROCESS_STATUS_CODE column in XLA_ENTITY_EVENTS_V.
552: | If process_status_code = 'E' then
553: | Update cash flow acct history status (status_code) to 'Accounting Error'
554: | Else if process_status_code = 'P' then
555: | Update cash flow acct history status (status_code) to 'Accounted'

Line 583: FROM xla_entity_events_v

579:
580: CURSOR event_cur IS
581: SELECT event_id,
582: process_status_code
583: FROM xla_entity_events_v
584: WHERE request_id = p_report_request_id
585: AND application_id = 260;
586:
587: BEGIN