DBA Data[Home] [Help]

APPS.OKL_SETUP_ACCRUALS_PUB SQL Statements

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

Line: 152

  PROCEDURE update_accrual_rules(
    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_agnv_rec                     IN  agnv_rec_type,
    x_agnv_rec                     OUT NOCOPY agnv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 163

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

      SAVEPOINT update_accrual_rules;
Line: 173

    	      OKL_SETUP_ACCRUALS_PVT.update_accrual_rules(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_agnv_rec        => p_agnv_rec,
    			            							   x_agnv_rec        => x_agnv_rec);
Line: 191

      ROLLBACK TO update_accrual_rules;
Line: 199

      ROLLBACK TO update_accrual_rules;
Line: 206

        ROLLBACK TO update_accrual_rules;
Line: 207

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
Line: 213

  END update_accrual_rules;
Line: 216

  PROCEDURE update_accrual_rules(
    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_agnv_tbl                     IN  agnv_tbl_type,
    x_agnv_tbl                     OUT NOCOPY agnv_tbl_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 227

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

      SAVEPOINT update_accrual_rules;
Line: 240

   	      OKL_SETUP_ACCRUALS_PVT.update_accrual_rules(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_agnv_rec        => l_agnv_tbl(i),
    		        								   x_agnv_rec        => x_agnv_tbl(i));
Line: 262

      ROLLBACK TO update_accrual_rules;
Line: 270

      ROLLBACK TO update_accrual_rules;
Line: 277

      ROLLBACK TO update_accrual_rules;
Line: 278

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
Line: 284

  END update_accrual_rules;
Line: 287

  PROCEDURE delete_accrual_rules(
    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_agnv_rec                     IN  agnv_rec_type)

	IS
      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 297

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

      SAVEPOINT delete_accrual_rules;
Line: 307

  	      OKL_SETUP_ACCRUALS_PVT.delete_accrual_rules(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_agnv_rec        => p_agnv_rec);
Line: 323

      ROLLBACK TO delete_accrual_rules;
Line: 331

      ROLLBACK TO delete_accrual_rules;
Line: 338

      ROLLBACK TO delete_accrual_rules;
Line: 339

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
Line: 345

  END delete_accrual_rules;
Line: 347

  PROCEDURE delete_accrual_rules(
    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_agnv_tbl                     IN  agnv_tbl_type)

  IS

      l_api_version       CONSTANT NUMBER        := 1.0;
Line: 358

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

      SAVEPOINT delete_accrual_rules;
Line: 371

  	      OKL_SETUP_ACCRUALS_PVT.delete_accrual_rules(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_agnv_rec        => l_agnv_tbl(i));
Line: 391

      ROLLBACK TO delete_accrual_rules;
Line: 399

      ROLLBACK TO delete_accrual_rules;
Line: 406

      ROLLBACK TO delete_accrual_rules;
Line: 407

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
Line: 413

  END delete_accrual_rules;