DBA Data[Home] [Help]

APPS.OKL_PROCESS_PROVISIONS_PUB SQL Statements

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

Line: 20

      SAVEPOINT insert_provisions;
Line: 49

      ROLLBACK TO insert_provisions;
Line: 57

      ROLLBACK TO insert_provisions;
Line: 90

      SAVEPOINT insert_provisions;
Line: 119

      ROLLBACK TO insert_provisions;
Line: 127

      ROLLBACK TO insert_provisions;
Line: 144

  PROCEDURE update_provisions(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pvnv_rec                     IN  pvnv_rec_type,
    x_pvnv_rec                     OUT NOCOPY pvnv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 155

      l_api_name          CONSTANT VARCHAR2(30)  := 'UPDATE_PROVISIONS';
Line: 160

      SAVEPOINT update_provisions;
Line: 165

    	      OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version     => l_api_version,
                                                           p_init_msg_list   => p_init_msg_list,
    		            							       x_return_status   => x_return_Status,
    					            					   x_msg_count       => x_msg_count,
    								            		   x_msg_data        => x_msg_data,
                  										   p_pvnv_rec        => p_pvnv_rec,
    			            							   x_pvnv_rec        => x_pvnv_rec);
Line: 183

      ROLLBACK TO update_provisions;
Line: 191

      ROLLBACK TO update_provisions;
Line: 205

  END update_provisions;
Line: 208

  PROCEDURE update_provisions(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pvnv_tbl                     IN  pvnv_tbl_type,
    x_pvnv_tbl                     OUT NOCOPY pvnv_tbl_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 219

      l_api_name          CONSTANT VARCHAR2(30)  := 'UPDATE_PROVISIONS';
Line: 224

      SAVEPOINT update_provisions;
Line: 229

   	      OKL_PROCESS_PROVISIONS_PVT.UPDATE_PROVISIONS(p_api_version     => l_api_version,
                                                       p_init_msg_list   => p_init_msg_list,
    	 	          							       x_return_status   => x_return_Status,
    					        					   x_msg_count       => x_msg_count,
    							        			   x_msg_data        => x_msg_data,
               										   p_pvnv_tbl        => p_pvnv_tbl,
    		        								   x_pvnv_tbl        => x_pvnv_tbl);
Line: 246

      ROLLBACK TO update_provisions;
Line: 254

      ROLLBACK TO update_provisions;
Line: 268

  END update_provisions;
Line: 271

  PROCEDURE delete_provisions(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pvnv_rec                     IN  pvnv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 281

      l_api_name          CONSTANT VARCHAR2(30)  := 'DELETE_PROVISIONS';
Line: 286

      SAVEPOINT delete_provisions;
Line: 291

  	      OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version     => l_api_version,
                                                       p_init_msg_list   => p_init_msg_list,
    	          								       x_return_status   => x_return_Status,
    				         						   x_msg_count       => x_msg_count,
    							        			   x_msg_data        => x_msg_data,
    									        	   p_pvnv_rec        => p_pvnv_rec);
Line: 307

      ROLLBACK TO delete_provisions;
Line: 315

      ROLLBACK TO delete_provisions;
Line: 329

  END delete_provisions;
Line: 331

  PROCEDURE delete_provisions(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_pvnv_tbl                     IN  pvnv_tbl_type)

  IS

      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 342

      l_api_name          CONSTANT VARCHAR2(30)  := 'DELETE_PROVISIONS';
Line: 347

      SAVEPOINT delete_provisions;
Line: 352

  	      OKL_PROCESS_PROVISIONS_PVT.DELETE_PROVISIONS(p_api_version     => l_api_version,
                                                       p_init_msg_list   => p_init_msg_list,
    		         							       x_return_status   => x_return_Status,
    					          					   x_msg_count       => x_msg_count,
    								          		   x_msg_data        => x_msg_data,
            										   p_pvnv_tbl        => p_pvnv_tbl);
Line: 368

      ROLLBACK TO delete_provisions;
Line: 376

      ROLLBACK TO delete_provisions;
Line: 390

  END delete_provisions;