DBA Data[Home] [Help]

APPS.OKL_SETUPFMACONSTRAINTS_PUB SQL Statements

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

Line: 65

  PROCEDURE insert_fmaconstraints(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_fmav_rec		 IN  fmav_rec_type,
                        		  p_fodv_rec         IN  fodv_rec_type,
                        		  x_fodv_rec         OUT NOCOPY fodv_rec_type) IS
	l_fmav_rec						  fmav_rec_type;
Line: 76

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_fmaconstraints';
Line: 81

    SAVEPOINT sp_insert_fmaconstraints;
Line: 88

	-- call process api to insert formula operands
-- Start of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 96

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.insert_fmaconstraints ');
Line: 99

    okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version   => p_api_version,
                                                      p_init_msg_list => p_init_msg_list,
                              			  			  x_return_status => l_return_status,
                              			  			  x_msg_count     => x_msg_count,
                              			  			  x_msg_data      => x_msg_data,
                              			  			  p_fmav_rec      => l_fmav_rec,
                              			  			  p_fodv_rec      => l_fodv_rec,
                              			  			  x_fodv_rec      => x_fodv_rec);
Line: 109

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.insert_fmaconstraints ');
Line: 127

      ROLLBACK TO sp_insert_fmaconstraints;
Line: 137

      ROLLBACK TO sp_insert_fmaconstraints;
Line: 149

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','insert_fmaconstraints');
Line: 155

  END insert_fmaconstraints;
Line: 161

  PROCEDURE update_fmaconstraints(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_fmav_rec		 IN  fmav_rec_type,
                      			  p_fodv_rec         IN  fodv_rec_type,
                        		  x_fodv_rec         OUT NOCOPY fodv_rec_type) IS
	l_fmav_rec						  fmav_rec_type;
Line: 173

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_fmaconstraints';
Line: 177

    SAVEPOINT sp_update_fmaconstraints;
Line: 184

	-- call process api to update formula operands
-- Start of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.update_fmaconstraints
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 192

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.update_fmaconstraints ');
Line: 195

    okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version   => p_api_version,
                                                      p_init_msg_list => p_init_msg_list,
                              			  			  x_return_status => l_return_status,
                              			  			  x_msg_count     => x_msg_count,
                              			  			  x_msg_data      => x_msg_data,
                              			  			  p_fmav_rec      => l_fmav_rec,
                              			  			  p_fodv_rec      => l_fodv_rec,
                              			  			  x_fodv_rec      => x_fodv_rec);
Line: 205

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.update_fmaconstraints ');
Line: 223

      ROLLBACK TO sp_update_fmaconstraints;
Line: 233

      ROLLBACK TO sp_update_fmaconstraints;
Line: 245

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','update_fmaconstraints');
Line: 251

  END update_fmaconstraints;
Line: 257

  PROCEDURE delete_fmaconstraints(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_fodv_tbl         IN  fodv_tbl_type) IS
    l_fodv_tbl                        fodv_tbl_type;
Line: 266

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_fmaconstraints';
Line: 270

    SAVEPOINT sp_delete_fmaconstraints;
Line: 276

	-- call process api to delete formula operands
-- Start of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.delete_fmaconstraints
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 284

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.delete_fmaconstraints ');
Line: 287

    okl_setupfmaconstraints_pvt.delete_fmaconstraints(p_api_version   => p_api_version,
                                                      p_init_msg_list => p_init_msg_list,
                              			  			  x_return_status => l_return_status,
                              			  			  x_msg_count     => x_msg_count,
                              			  			  x_msg_data      => x_msg_data,
                              			  			  p_fodv_tbl      => l_fodv_tbl);
Line: 295

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.delete_fmaconstraints ');
Line: 310

      ROLLBACK TO sp_delete_fmaconstraints;
Line: 320

      ROLLBACK TO sp_delete_fmaconstraints;
Line: 332

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','delete_fmaconstraints');
Line: 338

  END delete_fmaconstraints;
Line: 345

  PROCEDURE insert_fmaconstraints(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_fmav_rec		 IN  fmav_rec_type,
				  p_fodv_tbl         IN  fodv_tbl_type,
				  x_fodv_tbl         OUT NOCOPY fodv_tbl_type) IS
    l_fmav_rec			      fmav_rec_type;
Line: 356

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_fmaconstraints';
Line: 361

    SAVEPOINT sp_insert_fmaconstraints;
Line: 366

	-- call process api to insert formula operands
 -- Start of wraper code generated automatically by Debug code generator for okl_setupfmaconstr_t_pvt.insert_fmaconstraints
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;
Line: 374

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.insert_fmaconstraints ');
Line: 377

    okl_setupfmaconstraints_pvt.insert_fmaconstraints(p_api_version   => p_api_version,
                                                      p_init_msg_list => p_init_msg_list,
						      x_return_status => l_return_status,
 						      x_msg_count     => x_msg_count,
						      x_msg_data      => x_msg_data,
						      p_fmav_rec      => l_fmav_rec,
						      p_fodv_tbl      => l_fodv_tbl,
						      x_fodv_tbl      => x_fodv_tbl);
Line: 387

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.insert_fmaconstraints ');
Line: 405

      ROLLBACK TO sp_insert_fmaconstraints;
Line: 415

      ROLLBACK TO sp_insert_fmaconstraints;
Line: 427

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','insert_fmaconstraints');
Line: 433

  END insert_fmaconstraints;
Line: 441

  PROCEDURE update_fmaconstraints(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_fmav_rec	     IN  fmav_rec_type,
				  p_fodv_tbl         IN  fodv_tbl_type,
				  x_fodv_tbl         OUT NOCOPY fodv_tbl_type) IS
    l_fmav_rec	  		      fmav_rec_type;
Line: 452

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_fmaconstraints';
Line: 457

    SAVEPOINT sp_update_fmaconstraints;
Line: 470

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.update_fmaconstraints ');
Line: 473

    okl_setupfmaconstraints_pvt.update_fmaconstraints(p_api_version   => p_api_version,
                                                      p_init_msg_list => p_init_msg_list,
						      x_return_status => l_return_status,
						      x_msg_count     => x_msg_count,
						      x_msg_data      => x_msg_data,
						      p_fmav_rec      => l_fmav_rec,
						      p_fodv_tbl      => l_fodv_tbl,
					   	      x_fodv_tbl      => x_fodv_tbl);
Line: 483

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFCB.pls call okl_setupfmaconstraints_pvt.update_fmaconstraints ');
Line: 500

      ROLLBACK TO sp_update_fmaconstraints;
Line: 510

      ROLLBACK TO sp_update_fmaconstraints;
Line: 522

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','update_fmaconstraints');
Line: 528

  END update_fmaconstraints;