APPS.OKL_SETUPPDTTEMPLATES_PUB SQL Statements

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

Line: 43

  PROCEDURE insert_pdttemplates(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_ptlv_rec         IN  ptlv_rec_type,
                        	    x_ptlv_rec         OUT NOCOPY ptlv_rec_type) IS
    l_ptlv_rec                        ptlv_rec_type;

Line: 52

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

Line: 57

    SAVEPOINT sp_insert_pdttemplates;

Line: 62

	-- call process api to insert pdttemplates
    okl_setuppdttemplates_pvt.insert_pdttemplates(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_ptlv_rec      => l_ptlv_rec,
                              			          x_ptlv_rec      => x_ptlv_rec);

Line: 84

      ROLLBACK TO sp_insert_pdttemplates;

Line: 94

      ROLLBACK TO sp_insert_pdttemplates;

Line: 106

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','insert_pdttemplates');

Line: 112

  END insert_pdttemplates;

Line: 118

  PROCEDURE update_pdttemplates(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_ptlv_rec         IN  ptlv_rec_type,
                        	    x_ptlv_rec         OUT NOCOPY ptlv_rec_type) IS
    l_ptlv_rec                        ptlv_rec_type;

Line: 128

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

Line: 132

    SAVEPOINT sp_update_pdttemplates;

Line: 137

	-- call process api to update pdttemplates
    okl_setuppdttemplates_pvt.update_pdttemplates(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_ptlv_rec      => l_ptlv_rec,
                              			          x_ptlv_rec      => x_ptlv_rec);

Line: 159

      ROLLBACK TO sp_update_pdttemplates;

Line: 169

      ROLLBACK TO sp_update_pdttemplates;

Line: 181

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPDTTEMPLATES_PUB','update_pdttemplates');

Line: 187

  END update_pdttemplates;