APPS.OKL_SETUPPSTYPES_PUB SQL Statements

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

Line: 42

  PROCEDURE insert_pstypes(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_pdtv_rec         IN  pdtv_rec_type,
							p_psyv_rec         IN  psyv_rec_type,
                        	x_psyv_rec         OUT NOCOPY psyv_rec_type
						    ) IS
    l_psyv_rec                        psyv_rec_type;

Line: 55

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

Line: 59

    SAVEPOINT sp_insert_pstypes;

Line: 65

	-- call process api to insert psyalues
    okl_setuppstypes_pvt.insert_pstypes(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_psyv_rec      => l_psyv_rec,
                              			  x_psyv_rec      => x_psyv_rec,
										  p_pdtv_rec      => l_pdtv_rec
										  );

Line: 88

      ROLLBACK TO sp_insert_pstypes;

Line: 98

      ROLLBACK TO sp_insert_pstypes;

Line: 110

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPSTYPES_PUB','insert_pstypes');

Line: 116

  END insert_pstypes;

Line: 122

  PROCEDURE update_pstypes(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_pdtv_rec         IN  pdtv_rec_type,
							p_psyv_rec         IN  psyv_rec_type,
                        	x_psyv_rec         OUT NOCOPY psyv_rec_type
						    ) IS
    l_psyv_rec                        psyv_rec_type;

Line: 135

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

Line: 139

    SAVEPOINT sp_update_pstypes;

Line: 145

	-- call process api to update psyalues
    okl_setuppstypes_pvt.update_pstypes(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_psyv_rec      => l_psyv_rec,
                              			  x_psyv_rec      => x_psyv_rec,
										  p_pdtv_rec      => l_pdtv_rec
										  );

Line: 168

      ROLLBACK TO sp_update_pstypes;

Line: 178

      ROLLBACK TO sp_update_pstypes;

Line: 190

      FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPSTYPES_PUB','update_pstypes');

Line: 196

  END update_pstypes;