APPS.OKL_ASSET_DETAILS_PUB SQL Statements

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

Line: 5

  PROCEDURE Update_year(
                      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_dnz_chr_id             IN  NUMBER,
                      p_parent_line_id         IN  NUMBER,
                      p_year                   IN  VARCHAR2,
                      x_year                   OUT NOCOPY VARCHAR2)
  AS
    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 20

  g_api_name := 'Update Year';

Line: 29

    okl_asset_details_pvt.update_year(  p_api_version            => p_api_version,
                                            p_init_msg_list          => p_init_msg_list,
                                            x_return_status          => l_return_status,
                                            x_msg_count              => l_msg_count,
                                            x_msg_data               => l_msg_data,
                                            p_dnz_chr_id             => p_dnz_chr_id,
                                            p_parent_line_id         => p_parent_line_id,
                                            p_year                   => p_year,
                                            x_year                   => x_year);

Line: 75

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Year');

Line: 79

  END update_year;

Line: 81

  PROCEDURE update_tax(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_rule_id                IN  NUMBER,
                     p_rule_grp_id            IN  NUMBER,
                     p_dnz_chr_id             IN  NUMBER,
                     p_rule_information1      IN  VARCHAR2,
                     p_rule_information2      IN  VARCHAR2,
                     p_rule_information3      IN  VARCHAR2,
                     p_rule_information4      IN  VARCHAR2,
                     x_rule_information1      OUT  NOCOPY VARCHAR2,
                     x_rule_information2      OUT  NOCOPY VARCHAR2,
                     x_rule_information3      OUT  NOCOPY VARCHAR2,
                     x_rule_information4      OUT  NOCOPY VARCHAR2)
  AS
    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 102

  g_api_name := 'Update Tax';

Line: 111

  okl_asset_details_pvt.update_tax(p_api_version                   =>p_api_version,
                                          p_init_msg_list          => p_init_msg_list,
                                          x_return_status          => l_return_status,
                                          x_msg_count              => l_msg_count,
                                          x_msg_data               => l_msg_data,
                                          p_rule_id                => p_rule_id,
                                          p_rule_grp_id            => p_rule_grp_id,
                                          p_dnz_chr_id             => p_dnz_chr_id,
                                          p_rule_information1      => p_rule_information1,
                                          p_rule_information2      => p_rule_information2,
                                          p_rule_information3      => p_rule_information3,
                                          p_rule_information4      => p_rule_information4,
                                          x_rule_information1      => x_rule_information1,
                                          x_rule_information2      => x_rule_information2,
                                          x_rule_information3      => x_rule_information3,
                                          x_rule_information4      => x_rule_information4);

Line: 164

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Tax');

Line: 168

  END update_Tax;

Line: 170

PROCEDURE update_asset(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_asset_id             IN     NUMBER,
                         p_asset_number         IN     VARCHAR2,
                         px_asset_desc          IN OUT NOCOPY VARCHAR2,
                         px_model_no            IN OUT NOCOPY VARCHAR2,
                         px_manufacturer        IN OUT NOCOPY VARCHAR2)
  AS
    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 185

  g_api_name := 'Update Asset';

Line: 194

    okl_asset_details_pvt.update_asset(p_api_version          => p_api_version,
                                       p_init_msg_list        => p_init_msg_list,
                                       x_return_status        => l_return_status,
                                       x_msg_count            => l_msg_count,
                                       x_msg_data             => l_msg_data,
                                       p_asset_id             => p_asset_id,
                                       p_asset_number         => p_asset_number,
                                       px_asset_desc          => px_asset_desc,
                                       px_model_no            => px_model_no,
                                       px_manufacturer        => px_manufacturer);

Line: 241

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ASSET_DETAILS_PUB','Update_Asset');

Line: 245

  END update_Asset;