APPS.OKL_SETUPFORMULAE_PUB SQL Statements

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

Line: 65

  PROCEDURE insert_formulae(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,
                        	x_fmav_rec         OUT NOCOPY fmav_rec_type) IS
    l_fmav_rec                        fmav_rec_type;

Line: 74

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_formulae';

Line: 79

    SAVEPOINT sp_insert_formulae;

Line: 84

	-- call process api to insert formulae
-- Start of wraper code generated automatically by Debug code generator for okl_setupformulae_pvt.insert_formulae
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 92

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFMB.pls call okl_setupformulae_pvt.insert_formulae ');

Line: 95

    okl_setupformulae_pvt.insert_formulae(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,
                              			  x_fmav_rec      => x_fmav_rec);

Line: 104

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFMB.pls call okl_setupformulae_pvt.insert_formulae ');

Line: 122

      ROLLBACK TO sp_insert_formulae;

Line: 132

      ROLLBACK TO sp_insert_formulae;

Line: 144

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFORMULAE_PUB','insert_formulae');

Line: 150

  END insert_formulae;

Line: 156

  PROCEDURE update_formulae(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,
                        	x_fmav_rec         OUT NOCOPY fmav_rec_type) IS
    l_fmav_rec                        fmav_rec_type;

Line: 166

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_formulae';

Line: 170

    SAVEPOINT sp_update_formulae;

Line: 175

	-- call process api to update formulae
-- Start of wraper code generated automatically by Debug code generator for okl_setupformulae_pvt.update_formulae
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 183

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSFMB.pls call okl_setupformulae_pvt.update_formulae ');

Line: 186

    okl_setupformulae_pvt.update_formulae(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,
                              			  x_fmav_rec      => x_fmav_rec);

Line: 195

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSFMB.pls call okl_setupformulae_pvt.update_formulae ');

Line: 213

      ROLLBACK TO sp_update_formulae;

Line: 223

      ROLLBACK TO sp_update_formulae;

Line: 235

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFORMULAE_PUB','update_formulae');

Line: 241

  END update_formulae;