APPS.OKL_RCT_PUB SQL Statements

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

Line: 39

   SAVEPOINT save_Insert_row;

Line: 94

      ROLLBACK TO save_Insert_row;

Line: 102

      ROLLBACK TO save_Insert_row;

Line: 110

      ROLLBACK TO save_Insert_row;

Line: 114

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RCT_PUB','insert_row');

Line: 122

PROCEDURE update_internal_trans(
    p_api_version                  IN NUMBER
   ,p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
   ,x_return_status                OUT NOCOPY VARCHAR2
   ,x_msg_count                    OUT NOCOPY NUMBER
   ,x_msg_data                     OUT NOCOPY VARCHAR2
   ,p_rctv_rec                     IN rctv_rec_type
   ,p_rcav_tbl                     IN rcav_tbl_type
   ,x_rctv_rec                     OUT NOCOPY rctv_rec_type
   ,x_rcav_tbl                     OUT NOCOPY rcav_tbl_type
    ) IS
   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line: 146

   SAVEPOINT save_update_row;

Line: 161

 	Okl_Incsh_Pvt.update_internal_trans(
       p_api_version
      ,p_init_msg_list
      ,l_return_status
   	  ,x_msg_count
   	  ,x_msg_data
   	  ,lp_rctv_rec
   	  ,lp_rcav_tbl
   	  ,lx_rctv_rec
   	  ,lx_rcav_tbl
   	);

Line: 196

      ROLLBACK TO save_update_row;

Line: 204

      ROLLBACK TO save_update_row;

Line: 212

      ROLLBACK TO save_update_row;

Line: 216

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RCT_PUB','update_row');

Line: 492

PROCEDURE delete_internal_trans(
    p_api_version                  IN NUMBER
   ,p_init_msg_list                IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
   ,x_return_status                OUT NOCOPY VARCHAR2
   ,x_msg_count                    OUT NOCOPY NUMBER
   ,x_msg_data                     OUT NOCOPY VARCHAR2
   ,p_rctv_rec                     IN rctv_rec_type
   ,p_rcav_tbl                     IN rcav_tbl_type
   ,x_rctv_rec                     OUT NOCOPY rctv_rec_type
   ,x_rcav_tbl                     OUT NOCOPY rcav_tbl_type
    ) IS
   l_return_status         VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

Line: 516

   SAVEPOINT save_delete_row;

Line: 529

 	Okl_Incsh_Pvt.delete_internal_trans(
       p_api_version
      ,p_init_msg_list
      ,x_return_status
   	  ,x_msg_count
   	  ,x_msg_data
   	  ,p_rctv_rec
   	  ,p_rcav_tbl
   	  ,x_rctv_rec
   	  ,x_rcav_tbl
   	);

Line: 565

      ROLLBACK TO save_delete_row;

Line: 573

      ROLLBACK TO save_delete_row;

Line: 581

      ROLLBACK TO save_delete_row;

Line: 585

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_RCT_PUB','delete_row');