DBA Data[Home] [Help]

APPS.OKL_SETUPDSFPARAMETERS_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_dsfparameters(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_dsfv_rec		 	IN  dsfv_rec_type,
                        		 p_fprv_rec         IN  fprv_rec_type,
                        		 x_fprv_rec         OUT NOCOPY fprv_rec_type) IS
	l_dsfv_rec						  dsfv_rec_type;
Line: 54

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_dsfparameters';
Line: 59

    SAVEPOINT sp_insert_dsfparameters;
Line: 66

	-- call process api to insert function parameters
    okl_setupdsfparameters_pvt.insert_dsfparameters(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_dsfv_rec      => l_dsfv_rec,
                              			  			p_fprv_rec      => l_fprv_rec,
                              			  			x_fprv_rec      => x_fprv_rec);
Line: 89

      ROLLBACK TO sp_insert_dsfparameters;
Line: 99

      ROLLBACK TO sp_insert_dsfparameters;
Line: 111

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
Line: 117

  END insert_dsfparameters;
Line: 123

  PROCEDURE update_dsfparameters(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_dsfv_rec		 	IN  dsfv_rec_type,
                      			 p_fprv_rec         IN  fprv_rec_type,
                        		 x_fprv_rec         OUT NOCOPY fprv_rec_type) IS
	l_dsfv_rec						  dsfv_rec_type;
Line: 135

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_dsfparameters';
Line: 139

    SAVEPOINT sp_update_dsfparameters;
Line: 146

	-- call process api to update function parameters
    okl_setupdsfparameters_pvt.update_dsfparameters(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_dsfv_rec      => l_dsfv_rec,
                              			  			p_fprv_rec      => l_fprv_rec,
                              			  			x_fprv_rec      => x_fprv_rec);
Line: 169

      ROLLBACK TO sp_update_dsfparameters;
Line: 179

      ROLLBACK TO sp_update_dsfparameters;
Line: 191

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
Line: 197

  END update_dsfparameters;
Line: 203

  PROCEDURE delete_dsfparameters(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_fprv_tbl         IN  fprv_tbl_type) IS
    l_fprv_tbl                        fprv_tbl_type;
Line: 212

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_dsfparameters';
Line: 216

    SAVEPOINT sp_delete_dsfparameters;
Line: 222

	-- call process api to delete function parameters
    okl_setupdsfparameters_pvt.delete_dsfparameters(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_fprv_tbl      => l_fprv_tbl);
Line: 240

      ROLLBACK TO sp_delete_dsfparameters;
Line: 250

      ROLLBACK TO sp_delete_dsfparameters;
Line: 262

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','delete_dsfparameters');
Line: 268

  END delete_dsfparameters;
Line: 275

  PROCEDURE insert_dsfparameters(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_dsfv_rec		 	IN  dsfv_rec_type,
                        		 p_fprv_tbl         IN  fprv_tbl_type,
                        		 x_fprv_tbl         OUT NOCOPY fprv_tbl_type) IS
	l_dsfv_rec						  dsfv_rec_type;
Line: 286

    l_api_name                        CONSTANT VARCHAR2(30)  := 'insert_dsfparameters';
Line: 291

    SAVEPOINT sp_insert_dsfparameters;
Line: 297

	-- call process api to insert function parameters
    okl_setupdsfparameters_pvt.insert_dsfparameters(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_dsfv_rec      => l_dsfv_rec,
                              			  			p_fprv_tbl      => l_fprv_tbl,
                              			  			x_fprv_tbl      => x_fprv_tbl);
Line: 316

      ROLLBACK TO sp_insert_dsfparameters;
Line: 326

      ROLLBACK TO sp_insert_dsfparameters;
Line: 338

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
Line: 344

  END insert_dsfparameters;
Line: 352

  PROCEDURE update_dsfparameters(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_dsfv_rec		 	IN  dsfv_rec_type,
                        		 p_fprv_tbl         IN  fprv_tbl_type,
                        		 x_fprv_tbl         OUT NOCOPY fprv_tbl_type) IS
	l_dsfv_rec						  dsfv_rec_type;
Line: 363

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_dsfparameters';
Line: 368

    SAVEPOINT sp_update_dsfparameters;
Line: 373

	-- call process api to update function parameters
    okl_setupdsfparameters_pvt.update_dsfparameters(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_dsfv_rec      => l_dsfv_rec,
                              			  			p_fprv_tbl      => l_fprv_tbl,
                              			  			x_fprv_tbl      => x_fprv_tbl);
Line: 392

      ROLLBACK TO sp_update_dsfparameters;
Line: 402

      ROLLBACK TO sp_update_dsfparameters;
Line: 414

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
Line: 420

  END update_dsfparameters;