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.XLA_EVENTS_PUB_PKG SQL Statements

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

Line: 37


|                                to update transaction number, Event Number  |
|                                and Reference Information                   |
|    06-May-02 S. Singhania    Added "valuation_method" and "ledger_id".     |
|                                Bug # 2351677.                              |
|    31-May-02 S. Singhania    Removed one of the 'create_entity_event' API  |
|                              Renamed 'create_entity_event' API to          |
|                                'create_bulk_events'                        |
|    23-Jul-02 S. Singhania    commented 'get_document_status' API.          |
|                                Bug # 2464825                               |
|    09-Sep-02 S. Singhania    modified 'create_bulk_events' API. Bug 2530796|
|    21-Feb-03 S. Singhania    Added 'Trace' procedure.                      |
|    04-Sep-03 S. Singhania    Made changes to satisfy enhanced requirement  |
|                                for 'Source Application'.                   |
|                                - Added parameter to CREATE_BULK_EVENTS     |
|    12-Dec-03 S. Singhania    Removed the API UPDATE_TRANSACTION_NUMBER.    |
|                                Bug # 3268790                               |
|    25-Jun-04 W. Shen         add a new function delete_entity(bug 3316535) |
|    23-OCT-04 W. Shen         New API to delete/update/create event in bulk |
|    1- APR-05 W. Shen         Add transaction_date to create_event api      |
|                                add transaction_date to update_event API    |
|    20-Apr-05 S. Singhania    Bug 4312353. Modified the calls to routines in|
|                                xla_events_pkg to reflect the change in the |
|                                way we handle valuation method different    |
|                                from other security columns                 |
|    02-May-05 V. Kumar        Removed function create_bulk_events,          |
|                              Bug # 4323140                                 |
+===========================================================================*/

--=============================================================================
--               *********** Local Trace Routine **********
--=============================================================================
C_LEVEL_STATEMENT     CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line: 239


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) IS
BEGIN
   trace('> xla_events_pub_pkg.update_event_status'           , 20);

Line: 253


   xla_events_pkg.update_event_status
      (p_event_source_info       => p_event_source_info
      ,p_valuation_method        => p_valuation_method
      ,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);

Line: 261


   trace('< xla_events_pub_pkg.update_event_status'           , 20);

Line: 267


      (p_location => 'xla_events_pub_pkg.update_event_status');

Line: 268


END update_event_status;

Line: 282


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_transaction_date             IN  DATE       DEFAULT NULL) IS
BEGIN
   trace('> xla_events_pub_pkg.update_event'                  , 20);

Line: 297


   xla_events_pkg.update_event
      (p_event_source_info        => p_event_source_info
      ,p_valuation_method         => p_valuation_method
      ,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_transaction_date         => p_transaction_date);

Line: 306


   trace('< xla_events_pub_pkg.update_event'                  , 20);

Line: 312


      (p_location => 'xla_events_pub_pkg.update_event');

Line: 313


END update_event;

Line: 327


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_transaction_date             IN  DATE       DEFAULT NULL) IS
BEGIN
   trace('> xla_events_pub_pkg.update_event'                  , 20);

Line: 343


   xla_events_pkg.update_event
      (p_event_source_info        => p_event_source_info
      ,p_valuation_method         => p_valuation_method
      ,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_transaction_date         => p_transaction_date
      ,p_event_number             => p_event_number
      ,p_overwrite_event_num      => 'Y');

Line: 354


   trace('< xla_events_pub_pkg.update_event'                  , 20);

Line: 360


      (p_location => 'xla_events_pub_pkg.update_event');

Line: 361


END update_event;

Line: 375


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_transaction_date             IN  DATE       DEFAULT NULL) IS
BEGIN
   trace('> xla_events_pub_pkg.update_event'                  , 20);

Line: 391


   xla_events_pkg.update_event
      (p_event_source_info        => p_event_source_info
      ,p_valuation_method         => p_valuation_method
      ,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_transaction_date         => p_transaction_date
      ,p_reference_info           => p_reference_info
      ,p_overwrite_ref_info       => 'Y' );

Line: 402


   trace('< xla_events_pub_pkg.update_event'                  , 20);

Line: 408


      (p_location => 'xla_events_pub_pkg.update_event');

Line: 409


END update_event;

Line: 423


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_transaction_date             IN  DATE       DEFAULT NULL) IS
BEGIN
   trace('> xla_events_pub_pkg.update_event'                  , 20);

Line: 440


   xla_events_pkg.update_event
      (p_event_source_info        => p_event_source_info
      ,p_valuation_method         => p_valuation_method
      ,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_transaction_date         => p_transaction_date
      ,p_event_number             => p_event_number
      ,p_reference_info           => p_reference_info
      ,p_overwrite_event_num      => 'Y'
      ,p_overwrite_ref_info       => 'Y');

Line: 453


   trace('< xla_events_pub_pkg.update_event'                  , 20);

Line: 459


      (p_location => 'xla_events_pub_pkg.update_event');

Line: 460


END update_event;

Line: 477


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) IS
BEGIN
   trace('> xla_events_pub_pkg.delete_event'                  , 20);

Line: 488


   xla_events_pkg.delete_event
      (p_event_source_info     => p_event_source_info
      ,p_valuation_method         => p_valuation_method
      ,p_event_id              => p_event_id );

Line: 493


   trace('< xla_events_pub_pkg.delete_event'                  , 20);

Line: 499


      (p_location => 'xla_events_pub_pkg.delete_event');

Line: 500


END delete_event;

Line: 514


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)
RETURN INTEGER IS
BEGIN
   trace('@ xla_events_pub_pkg.delete_events (fn)'             , 20);

Line: 528


   RETURN xla_events_pkg.delete_events
            (p_event_source_info      => p_event_source_info
            ,p_event_class_code       => p_event_class_code
            ,p_valuation_method         => p_valuation_method
            ,p_event_type_code        => p_event_type_code
            ,p_event_date             => p_event_date);

Line: 539


      (p_location => 'xla_events_pub_pkg.delete_events(fn)');

Line: 540


END delete_events;

Line: 552


FUNCTION delete_entity
   (p_source_info            IN  xla_events_pub_pkg.t_event_source_info
   ,p_valuation_method             IN  VARCHAR2
   ,p_security_context             IN  xla_events_pub_pkg.t_security)
RETURN INTEGER IS
l_result INTEGER;

Line: 559


   trace('> xla_events_pub_pkg.delete_entty'                  , 20);

Line: 564


   l_result := xla_events_pkg.delete_entity
      (p_source_info         => p_source_info
      ,p_valuation_method    => p_valuation_method);

Line: 568


   trace('< xla_events_pub_pkg.delete_entity'                  , 20);

Line: 575


      (p_location => 'xla_events_pub_pkg.delete_entity');

Line: 576


END delete_entity;

Line: 750


PROCEDURE update_bulk_event_statuses(p_application_id INTEGER) IS
BEGIN
  xla_events_pkg.update_bulk_event_statuses(
       p_application_id           => p_application_id);

Line: 760


      (p_location => 'xla_events_pub_pkg.update_bulk_event_statuses');

Line: 761


END update_bulk_event_statuses;

Line: 763


PROCEDURE delete_bulk_events(p_application_id INTEGER) IS
BEGIN
  xla_events_pkg.delete_bulk_events(
       p_application_id           => p_application_id);

Line: 773


      (p_location => 'xla_events_pub_pkg.delete_bulk_events');

Line: 774


END delete_bulk_events;

Line: 891


PROCEDURE update_transaction_number
   (p_event_source_info            IN  xla_events_pub_pkg.t_event_source_info
   ,p_transaction_number           IN  VARCHAR2
   ,p_valuation_method             IN  VARCHAR2
   ,p_security_context             IN  xla_events_pub_pkg.t_security
   ,p_event_id                     IN  PLS_INTEGER  DEFAULT NULL) IS
BEGIN
   trace('> xla_events_pub_pkg.update_transaction_number'             , 20);

Line: 903


   xla_events_pkg.update_transaction_number
      (p_event_source_info     => p_event_source_info
      ,p_transaction_number    => p_transaction_number
      ,p_valuation_method      => p_valuation_method
      ,p_event_id              => p_event_id
      );

Line: 910


   trace('< xla_events_pub_pkg.update_transaction_number'             , 20);

Line: 916


      (p_location => 'xla_events_pub_pkg.update_transaction_number');

Line: 917


END update_transaction_number;