DBA Data[Home] [Help]

APPS.OKL_PROCESS_BUCKETS_PUB SQL Statements

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

Line: 20

      SAVEPOINT insert_buckets;
Line: 49

      ROLLBACK TO insert_buckets;
Line: 57

      ROLLBACK TO insert_buckets;
Line: 90

      SAVEPOINT insert_buckets;
Line: 127

      ROLLBACK TO insert_buckets;
Line: 135

      ROLLBACK TO insert_buckets;
Line: 152

  PROCEDURE update_buckets(
    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_bktv_rec                     IN  bktv_rec_type,
    x_bktv_rec                     OUT NOCOPY bktv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 163

      l_api_name          CONSTANT VARCHAR2(30)  := 'UPDATE_BUCKETS';
Line: 168

      SAVEPOINT update_buckets;
Line: 173

    	      OKL_PROCESS_BUCKETS_PVT.UPDATE_BUCKETS(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_bktv_rec        => p_bktv_rec,
    			            							   x_bktv_rec        => x_bktv_rec);
Line: 191

      ROLLBACK TO update_buckets;
Line: 199

      ROLLBACK TO update_buckets;
Line: 213

  END update_buckets;
Line: 216

  PROCEDURE update_buckets(
    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_bktv_tbl                     IN  bktv_tbl_type,
    x_bktv_tbl                     OUT NOCOPY bktv_tbl_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 227

      l_api_name          CONSTANT VARCHAR2(30)  := 'UPDATE_BUCKETS';
Line: 232

      SAVEPOINT update_buckets;
Line: 240

   	      OKL_PROCESS_BUCKETS_PVT.UPDATE_BUCKETS(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_bktv_rec        => l_bktv_tbl(i),
    		        								   x_bktv_rec        => x_bktv_tbl(i));
Line: 262

      ROLLBACK TO update_buckets;
Line: 270

      ROLLBACK TO update_buckets;
Line: 284

  END update_buckets;
Line: 287

  PROCEDURE delete_buckets(
    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_bktv_rec                     IN  bktv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 297

      l_api_name          CONSTANT VARCHAR2(30)  := 'DELETE_BUCKETS';
Line: 302

      SAVEPOINT delete_buckets;
Line: 307

  	      OKL_PROCESS_BUCKETS_PVT.DELETE_BUCKETS(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_bktv_rec        => p_bktv_rec);
Line: 323

      ROLLBACK TO delete_buckets;
Line: 331

      ROLLBACK TO delete_buckets;
Line: 345

  END delete_buckets;
Line: 347

  PROCEDURE delete_buckets(
    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_bktv_tbl                     IN  bktv_tbl_type)

  IS

      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 358

      l_api_name          CONSTANT VARCHAR2(30)  := 'DELETE_BUCKETS';
Line: 363

      SAVEPOINT delete_buckets;
Line: 371

  	      OKL_PROCESS_BUCKETS_PVT.DELETE_BUCKETS(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_bktv_rec        => l_bktv_tbl(i));
Line: 391

      ROLLBACK TO delete_buckets;
Line: 399

      ROLLBACK TO delete_buckets;
Line: 413

  END delete_buckets;