DBA Data[Home] [Help]

APPS.CE_XLA_ACCT_EVENTS_PKG dependencies on XLA_ENTITY_EVENTS_V

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

607: |
608: | The following is the API logic:
609: |
610: | 1. If p_accounting_mode = 'D' (draft accounting) then don't do anything.
611: | 2. Based on p_report_request_id, get the list of event ID from XLA_ENTITY_EVENTS_V
612: | 3. For each event ID, check the PROCESS_STATUS_CODE column in XLA_ENTITY_EVENTS_V.
613: | If process_status_code = 'E' then
614: | Update cash flow acct history status (status_code) to 'Accounting Error'
615: | Else if process_status_code = 'P' then

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

608: | The following is the API logic:
609: |
610: | 1. If p_accounting_mode = 'D' (draft accounting) then don't do anything.
611: | 2. Based on p_report_request_id, get the list of event ID from XLA_ENTITY_EVENTS_V
612: | 3. For each event ID, check the PROCESS_STATUS_CODE column in XLA_ENTITY_EVENTS_V.
613: | If process_status_code = 'E' then
614: | Update cash flow acct history status (status_code) to 'Accounting Error'
615: | Else if process_status_code = 'P' then
616: | Update cash flow acct history status (status_code) to 'Accounted'

Line 644: FROM xla_entity_events_v

640:
641: CURSOR event_cur IS
642: SELECT event_id,
643: process_status_code
644: FROM xla_entity_events_v
645: WHERE request_id = p_report_request_id
646: AND application_id = 260;
647:
648: BEGIN