DBA Data[Home] [Help]

APPS.OKL_SETUPCGRPARAMETERS_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_cgrparameters(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_cgmv_rec         IN  cgmv_rec_type,
                        		 x_cgmv_rec         OUT NOCOPY cgmv_rec_type) IS
    l_cgmv_rec                        cgmv_rec_type;
Line: 52

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_cgrparameters';
Line: 57

    SAVEPOINT sp_insert_cgrparameters;
Line: 62

	-- call process api to insert context group parameters
    okl_setupcgrparameters_pvt.insert_cgrparameters(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_cgmv_rec      => l_cgmv_rec,
                              			  			x_cgmv_rec      => x_cgmv_rec);
Line: 84

      ROLLBACK TO sp_insert_cgrparameters;
Line: 94

      ROLLBACK TO sp_insert_cgrparameters;
Line: 106

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
Line: 112

  END insert_cgrparameters;
Line: 118

  PROCEDURE update_cgrparameters(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_cgmv_rec         IN  cgmv_rec_type,
                        		 x_cgmv_rec         OUT NOCOPY cgmv_rec_type) IS
    l_cgmv_rec                        cgmv_rec_type;
Line: 128

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_cgrparameters';
Line: 132

    SAVEPOINT sp_update_cgrparameters;
Line: 137

	-- call process api to update context group parameters
    okl_setupcgrparameters_pvt.update_cgrparameters(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_cgmv_rec      => l_cgmv_rec,
                              			  			x_cgmv_rec      => x_cgmv_rec);
Line: 159

      ROLLBACK TO sp_update_cgrparameters;
Line: 169

      ROLLBACK TO sp_update_cgrparameters;
Line: 181

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
Line: 187

  END update_cgrparameters;
Line: 193

  PROCEDURE delete_cgrparameters(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_cgmv_tbl         IN  cgmv_tbl_type) IS
    l_cgmv_tbl                        cgmv_tbl_type;
Line: 202

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_cgrparameters';
Line: 206

    SAVEPOINT sp_delete_cgrparameters;
Line: 212

	-- call process api to delete formula operands
    okl_setupcgrparameters_pvt.delete_cgrparameters(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_cgmv_tbl      => l_cgmv_tbl);
Line: 230

      ROLLBACK TO sp_delete_cgrparameters;
Line: 240

      ROLLBACK TO sp_delete_cgrparameters;
Line: 252

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','delete_cgrparameters');
Line: 258

  END delete_cgrparameters;
Line: 265

  PROCEDURE insert_cgrparameters(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_cgmv_tbl         IN  cgmv_tbl_type,
                        		 x_cgmv_tbl         OUT NOCOPY cgmv_tbl_type) IS
    l_cgmv_tbl                        cgmv_tbl_type;
Line: 274

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_cgrparameters';
Line: 279

    SAVEPOINT sp_insert_cgrparameters;
Line: 283

    okl_setupcgrparameters_pvt.insert_cgrparameters(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_cgmv_tbl      => l_cgmv_tbl,
						    x_cgmv_tbl      => x_cgmv_tbl);
Line: 302

      ROLLBACK TO sp_insert_cgrparameters;
Line: 312

      ROLLBACK TO sp_insert_cgrparameters;
Line: 324

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
Line: 330

  END insert_cgrparameters;
Line: 339

  PROCEDURE update_cgrparameters(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_cgmv_tbl         IN  cgmv_tbl_type,
                        		 x_cgmv_tbl         OUT NOCOPY cgmv_tbl_type) IS
    l_cgmv_tbl                        cgmv_tbl_type;
Line: 349

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_cgrparameters';
Line: 353

    SAVEPOINT sp_update_cgrparameters;
Line: 356

	-- call process api to update context group parameters
    okl_setupcgrparameters_pvt.update_cgrparameters(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_cgmv_tbl      => l_cgmv_tbl,
						    x_cgmv_tbl      => x_cgmv_tbl);
Line: 376

      ROLLBACK TO sp_update_cgrparameters;
Line: 386

      ROLLBACK TO sp_update_cgrparameters;
Line: 398

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
Line: 404

  END update_cgrparameters;