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

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

Line: 126


PROCEDURE delete_refund_hdr
             (  p_api_version          IN NUMBER
               ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
               ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
               ,p_refund_header_id     IN NUMBER
               ,x_return_status       OUT NOCOPY VARCHAR2
               ,x_msg_count           OUT NOCOPY NUMBER
               ,x_msg_data            OUT NOCOPY VARCHAR2
               ) IS
l_api_version   NUMBER := 1;

Line: 140


l_api_name                CONSTANT VARCHAR2(50) := 'DELETE_REFUND_HDR';

Line: 145


      SAVEPOINT DELETE_REFUND_HDR;

Line: 164


                           'okl_pay_cure_refunds_pvt.DELETE_REFUND_HDR');

Line: 170


  	  okl_pay_cure_refunds_pvt.DELETE_REFUND_HDR(
              p_api_version		     => l_api_version
      	     ,p_init_msg_list	     => p_init_msg_list
             ,p_commit               => p_commit
	         ,x_return_status	     => l_return_status
	         ,x_msg_count		     => l_msg_count
	         ,x_msg_data	      	 => l_msg_data
             ,p_refund_header_id     => p_refund_header_id);

Line: 186


                            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'success - delete refund batch');

Line: 207


      ROLLBACK TO DELETE_REFUND_HDR;

Line: 215


      ROLLBACK TO DELETE_REFUND_HDR;

Line: 223


      ROLLBACK TO DELETE_REFUND_HDR;

Line: 227


      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','DELETE_REFUND_HDR');

Line: 233


END delete_refund_hdr;

Line: 235


PROCEDURE update_refund_hdr
             (  p_api_version          IN NUMBER
               ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
               ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
               ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
               ,x_return_status       OUT NOCOPY VARCHAR2
               ,x_msg_count           OUT NOCOPY NUMBER
               ,x_msg_data            OUT NOCOPY VARCHAR2
               ) IS


l_api_version   NUMBER := 1;

Line: 251


l_api_name                CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_HDR';

Line: 258


       SAVEPOINT UPDATE_REFUND_HDR;

Line: 278


                           'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR');

Line: 284


  	  okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR(
              p_api_version		     => l_api_version
      	     ,p_init_msg_list	     => p_init_msg_list
             ,p_commit               => p_commit
	         ,x_return_status	     => l_return_status
	         ,x_msg_count		     => l_msg_count
	         ,x_msg_data	      	 => l_msg_data
             ,p_pay_cure_refunds_rec => l_pay_cure_refunds_rec);

Line: 301


                            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR'
                                    ||l_return_status );

Line: 321


      ROLLBACK TO UPDATE_REFUND_HDR;

Line: 329


      ROLLBACK TO UPDATE_REFUND_HDR;

Line: 337


      ROLLBACK TO UPDATE_REFUND_HDR;

Line: 341


      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_HDR');

Line: 346


END update_refund_hdr;

Line: 806


PROCEDURE UPDATE_REFUND_HEADERS
             (  p_api_version          IN NUMBER
               ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
               ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
               ,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
               ,x_return_status       OUT NOCOPY VARCHAR2
               ,x_msg_count           OUT NOCOPY NUMBER
               ,x_msg_data            OUT NOCOPY VARCHAR2
               ) IS


l_api_version   NUMBER := 1;

Line: 822


l_api_name                CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_HEADERS';

Line: 829


       SAVEPOINT UPDATE_REFUND_HEADERS;

Line: 849


                           'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS');

Line: 855


  	  okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS(
              p_api_version		     => l_api_version
      	     ,p_init_msg_list	     => p_init_msg_list
             ,p_commit               => p_commit
	         ,x_return_status	     => l_return_status
	         ,x_msg_count		     => l_msg_count
	         ,x_msg_data	      	 => l_msg_data
             ,p_pay_cure_refunds_rec => l_pay_cure_refunds_rec);

Line: 872


                            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS'
                                    ||l_return_status );

Line: 892


      ROLLBACK TO UPDATE_REFUND_HEADERS;

Line: 900


      ROLLBACK TO UPDATE_REFUND_HEADERS;

Line: 908


      ROLLBACK TO UPDATE_REFUND_HEADERS;

Line: 912


      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_HEADERS');

Line: 917


END UPDATE_REFUND_HEADERS;

Line: 1033


PROCEDURE UPDATE_REFUND_DETAILS
             (  p_api_version          IN NUMBER
               ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
               ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
               ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
               ,x_return_status       OUT NOCOPY VARCHAR2
               ,x_msg_count           OUT NOCOPY NUMBER
               ,x_msg_data            OUT NOCOPY VARCHAR2
               ) IS


l_api_version   NUMBER := 1;

Line: 1049


l_api_name                CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_DETAILS';

Line: 1056


       SAVEPOINT UPDATE_REFUND_DETAILS;

Line: 1076


                           'okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS');

Line: 1082


  	  okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS(
              p_api_version		     => l_api_version
      	     ,p_init_msg_list	     => p_init_msg_list
             ,p_commit               => p_commit
	         ,x_return_status	     => l_return_status
	         ,x_msg_count		     => l_msg_count
	         ,x_msg_data	      	 => l_msg_data
             ,p_pay_cure_refunds_tbl => l_pay_cure_refunds_tbl);

Line: 1099


                            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS'
                                    ||l_return_status );

Line: 1119


      ROLLBACK TO UPDATE_REFUND_DETAILS;

Line: 1127


      ROLLBACK TO UPDATE_REFUND_DETAILS;

Line: 1135


      ROLLBACK TO UPDATE_REFUND_DETAILS;

Line: 1139


      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_DETAILS');

Line: 1144


END UPDATE_REFUND_DETAILS;

Line: 1146


PROCEDURE DELETE_REFUND_DETAILS
             (  p_api_version          IN NUMBER
               ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
               ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
               ,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
               ,x_return_status       OUT NOCOPY VARCHAR2
               ,x_msg_count           OUT NOCOPY NUMBER
               ,x_msg_data            OUT NOCOPY VARCHAR2
               ) IS


l_api_version   NUMBER := 1;

Line: 1162


l_api_name                CONSTANT VARCHAR2(50) := 'DELETE_REFUND_DETAILS';

Line: 1169


       SAVEPOINT DELETE_REFUND_DETAILS;

Line: 1189


                           'okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS');

Line: 1195


  	  okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS(
              p_api_version		     => l_api_version
      	     ,p_init_msg_list	     => p_init_msg_list
             ,p_commit               => p_commit
	         ,x_return_status	     => l_return_status
	         ,x_msg_count		     => l_msg_count
	         ,x_msg_data	      	 => l_msg_data
             ,p_pay_cure_refunds_tbl => l_pay_cure_refunds_tbl);

Line: 1212


                            OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS'
                                    ||l_return_status );

Line: 1232


      ROLLBACK TO DELETE_REFUND_DETAILS;

Line: 1240


      ROLLBACK TO DELETE_REFUND_DETAILS;

Line: 1248


      ROLLBACK TO DELETE_REFUND_DETAILS;

Line: 1252


      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','DELETE_REFUND_DETAILS');

Line: 1257


END DELETE_REFUND_DETAILS;