APPS.XLA_REVERSE_EVENTS_PUB_PKG SQL Statements

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

Line: 23

|                                  Delete_Incomplete_Reversal                |
+===========================================================================*/

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

Line: 201

PROCEDURE delete_incomplete_reversal(  p_api_version           IN  NUMBER
                                     , p_application_id IN NUMBER
                                     , p_batch_code     IN VARCHAR2
                                     , p_ledger_id      IN NUMBER
                                     , p_delete_flag    IN VARCHAR2 DEFAULT 'N'
				     , p_batch_commit_size     IN NUMBER
                                     , x_return_status  OUT NOCOPY VARCHAR2) IS

  l_api_name          CONSTANT VARCHAR2(30) := 'delete_incomplete_reversal';

Line: 218

    l_log_module := C_DEFAULT_MODULE||'.delete_incomplete_reversal';

Line: 223

         (p_msg      => 'BEGIN of procedure delete_incomplete_reversal'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   =>l_log_module);

Line: 231

                     || ' p_delete_flag    = '||p_delete_flag
		     || ' p_batch_commit_size = '||p_batch_commit_size
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   =>l_log_module);

Line: 249

         (p_msg      => 'Calling xla_reverse_events_pvt_pkg.delete_incomplete_reversal'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   =>l_log_module);

Line: 255

   xla_reverse_events_pvt_pkg.delete_incomplete_reversal(
                                       p_application_id
                                     , p_batch_code
                                     , p_ledger_id
                                     , p_delete_flag
				     , p_batch_commit_size
                                     , x_return_status  ) ;

Line: 266

          (p_msg      => 'End of delete_incomplete_reversal '
          ,p_level    => C_LEVEL_STATEMENT
          ,p_module   => l_log_module);

Line: 279

         (p_location   => 'xla_reverse_events_pub_pkg.delete_incomplete_reversal');

Line: 281

END delete_incomplete_reversal ;