eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_XLA_EVENTS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60


PROCEDURE update_event_status
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_class_code IN VARCHAR2, -- DEFAULT NULL
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_event_status_code IN VARCHAR2,
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 78


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.UPDATE_EVENT_STATUS';

Line: 80


  XLA_EVENTS_PUB_PKG.UPDATE_EVENT_STATUS
  (
    p_event_source_info => p_event_source_info,
    p_event_class_code => p_event_class_code,
    p_event_type_code => p_event_type_code,
    p_event_date => p_event_date,
    p_event_status_code => p_event_status_code,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 106


END update_event_status;

Line: 110


PROCEDURE update_event
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_id IN INTEGER,
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_event_status_code IN VARCHAR2, -- DEFAULT NULL
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 128


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.UPDATE_EVENT[1]';

Line: 130


  XLA_EVENTS_PUB_PKG.UPDATE_EVENT
  (
    p_event_source_info => p_event_source_info,
    p_event_id => p_event_id,
    p_event_type_code => p_event_type_code,
    p_event_date => p_event_date,
    p_event_status_code => p_event_status_code,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 156


END update_event;

Line: 160


PROCEDURE update_event
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_id IN INTEGER,
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_event_status_code IN VARCHAR2, -- DEFAULT NULL
  p_event_number IN INTEGER,
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 179


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.UPDATE_EVENT[2]';

Line: 181


  XLA_EVENTS_PUB_PKG.UPDATE_EVENT
  (
    p_event_source_info => p_event_source_info,
    p_event_id => p_event_id,
    p_event_type_code => p_event_type_code,
    p_event_date => p_event_date,
    p_event_status_code => p_event_status_code,
    p_event_number => p_event_number,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 208


END update_event;

Line: 212


PROCEDURE update_event
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_id IN INTEGER,
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_event_status_code IN VARCHAR2, -- DEFAULT NULL
  p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 231


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.UPDATE_EVENT[3]';

Line: 233


  XLA_EVENTS_PUB_PKG.UPDATE_EVENT
  (
    p_event_source_info => p_event_source_info,
    p_event_id => p_event_id,
    p_event_type_code => p_event_type_code,
    p_event_date => p_event_date,
    p_event_status_code => p_event_status_code,
    p_reference_info => p_reference_info,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 260


END update_event;

Line: 264


PROCEDURE update_event
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_id IN INTEGER,
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_event_status_code IN VARCHAR2, -- DEFAULT NULL
  p_event_number IN INTEGER,
  p_reference_info IN XLA_EVENTS_PUB_PKG.T_EVENT_REFERENCE_INFO,
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 284


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.UPDATE_EVENT[4]';

Line: 286


  XLA_EVENTS_PUB_PKG.UPDATE_EVENT
  (
    p_event_source_info => p_event_source_info,
    p_event_id => p_event_id,
    p_event_type_code => p_event_type_code,
    p_event_date => p_event_date,
    p_event_status_code => p_event_status_code,
    p_event_number => p_event_number,
    p_reference_info => p_reference_info,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 314


END update_event;

Line: 318


PROCEDURE delete_event
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_id IN INTEGER,
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 333


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.DELETE_EVENT';

Line: 335


  XLA_EVENTS_PUB_PKG.DELETE_EVENT
  (
    p_event_source_info => p_event_source_info,
    p_event_id => p_event_id,
    p_valuation_method => p_valuation_method,
    p_security_context => p_security_context
  );

Line: 358


END delete_event;

Line: 362


FUNCTION delete_events
(
  p_event_source_info IN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO,
  p_event_class_code IN VARCHAR2, -- DEFAULT NULL
  p_event_type_code IN VARCHAR2, -- DEFAULT NULL
  p_event_date IN DATE, -- DEFAULT NULL
  p_valuation_method IN VARCHAR2,
  p_security_context IN XLA_EVENTS_PUB_PKG.T_SECURITY,
  p_calling_sequence IN VARCHAR2
)
RETURN INTEGER
IS

  l_curr_calling_sequence VARCHAR2(2000);

Line: 380


    p_calling_sequence || ' -> AP_XLA_EVENTS_PKG.DELETE_EVENTS';

Line: 383


    XLA_EVENTS_PUB_PKG.DELETE_EVENTS
    (
      p_event_source_info => p_event_source_info,
      p_event_class_code => p_event_class_code,
      p_event_type_code => p_event_type_code,
      p_event_date => p_event_date,
      p_valuation_method => p_valuation_method,
      p_security_context => p_security_context
    );

Line: 408


END delete_events;