APPS.OKL_BLK_AST_UPD_PUB SQL Statements

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

Line: 16

PROCEDURE update_location(
                            p_api_version                    IN  NUMBER,
                            p_init_msg_list                	 IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            p_loc_rec                        IN  blk_rec_type,
                            x_return_status                	 OUT NOCOPY VARCHAR2,
                            x_msg_count                    	 OUT NOCOPY NUMBER,
                            x_msg_data                     	 OUT NOCOPY VARCHAR2)
  AS
    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 33

    OKL_BLK_AST_UPD_PVT.update_location( p_api_version                   => p_api_version,
                                        p_init_msg_list                  => p_init_msg_list,
                                        p_loc_rec                        => p_loc_rec,
                                        x_return_status                  => l_return_status,
                                        x_msg_count                      => l_msg_count,
                                        x_msg_data                       => l_msg_data);

Line: 74

      FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');

Line: 78

  END update_location;

Line: 94

 PROCEDURE update_location(
                            p_api_version                    IN  NUMBER,
                            p_init_msg_list                	 IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
                            p_loc_tbl                        IN  blk_tbl_type,
                            x_return_status                	 OUT NOCOPY VARCHAR2,
                            x_msg_count                    	 OUT NOCOPY NUMBER,
                            x_msg_data                     	 OUT NOCOPY VARCHAR2)
  AS
    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 115

    OKL_BLK_AST_UPD_PVT.update_location( p_api_version                   => p_api_version,
                                        p_init_msg_list                  => p_init_msg_list,
                                        p_loc_tbl                        => p_loc_tbl,
                                        x_return_status                  => l_return_status,
                                        x_msg_count                      => l_msg_count,
                                        x_msg_data                       => l_msg_data);

Line: 156

      FND_MSG_PUB.ADD_EXC_MSG('OKL_BLK_AST_UPD_PUB','Update_Location');

Line: 160

  END update_location;