APPS.OKL_SETUPTQUALITYS_PUB SQL Statements

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

Line: 45

  PROCEDURE insert_tqualitys(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_ptqv_rec        IN  ptqv_rec_type,
                       	     x_ptqv_rec        OUT NOCOPY ptqv_rec_type
  		    	             ) IS
    l_ptqv_rec                        ptqv_rec_type;

Line: 55

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

Line: 61

    SAVEPOINT sp_insert_tqualitys;

Line: 71

   OKL_SETUPTQUALITYS_PVT.insert_tqualitys(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_ptqv_rec        => l_ptqv_rec,
                       	                   x_ptqv_rec        => x_ptqv_rec
										   );

Line: 94

      ROLLBACK TO sp_insert_tqualitys;

Line: 104

      ROLLBACK TO sp_insert_tqualitys;

Line: 116

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPTQUALITYS_PUB','insert_tqualitys');

Line: 122

  END insert_tqualitys;

Line: 128

  PROCEDURE update_tqualitys(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_ptqv_rec	       IN  ptqv_rec_type,
               		     x_ptqv_rec        OUT NOCOPY ptqv_rec_type) IS
    l_ptqv_rec                        ptqv_rec_type;

Line: 138

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

Line: 142

    SAVEPOINT sp_update_tqualitys;

Line: 151

   OKL_SETUPTQUALITYS_PVT.update_tqualitys(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_ptqv_rec        => l_ptqv_rec,
                       	                   x_ptqv_rec        => x_ptqv_rec);

Line: 173

      ROLLBACK TO sp_update_tqualitys;

Line: 183

      ROLLBACK TO sp_update_tqualitys;

Line: 195

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPTQUALITYS_PUB','update_tqualitys');

Line: 201

  END update_tqualitys;