APPS.OKL_ASSET_DETAILS_PVT SQL Statements

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

Line: 41

  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)  IS

   subtype klev_rec_type is okl_CONTRACT_PVT.klev_rec_type;

Line: 59

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

Line: 86

    OKL_CONTRACT_PUB.update_contract_line(
                                          p_api_version        => p_api_version,
                                          p_init_msg_list      => p_init_msg_list,
                                          x_return_status      => x_return_status,
                                          x_msg_count          => x_msg_count,
                                          x_msg_data           => x_msg_data,
                                          p_clev_rec           => l_clev_rec,
                                          p_klev_rec           => l_klev_rec,
                                          x_clev_rec           => lx_clev_rec,
                                          x_klev_rec           => lx_klev_rec);

Line: 134

 END Update_year;

Line: 136

 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) IS

 SUBTYPE  rule_rec_type IS OKL_RULE_PUB.rulv_rec_type;

Line: 157

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

Line: 188

    OKL_RULE_PUB.update_rule(
                      p_api_version          => p_api_version,
                      p_init_msg_list        => p_init_msg_list,
                      x_return_status        => x_return_status,
                      x_msg_count            => x_msg_count,
                      x_msg_data             => x_msg_data,
                      p_rulv_rec             => l_rule_rec,
                      x_rulv_rec             => lx_rule_rec);

Line: 241

  END update_tax;

Line: 243

  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,
-- SPILLAIP - 2689257 - Start
                         px_asset_desc            IN OUT NOCOPY VARCHAR2,
                         px_model_no              IN OUT NOCOPY VARCHAR2,
                         px_manufacturer          IN OUT NOCOPY VARCHAR2) IS
-- SPILLAIP - 2689257 - End

  l_trans_rec            FA_API_TYPES.trans_rec_type;

Line: 264

  l_calling_fn          VARCHAR2(50)  := 'Update Asset Desc Wrapper';

Line: 266

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

Line: 299

    fa_asset_desc_pub.update_desc(
                                  p_api_version         => p_api_version,
                                  p_commit              => l_commit_flag,
                                  p_validation_level    => l_validation_level,
                                  x_return_status       => x_return_status,
                                  x_msg_count           => x_msg_count,
                                  x_msg_data            => x_msg_data,
                                  p_calling_fn          => l_calling_fn,
                                  px_trans_rec          => l_trans_rec,
                                  px_asset_hdr_rec      => l_asset_hdr_rec,
                                  px_asset_desc_rec_new => l_asset_desc_rec,
                      --            px_asset_type_rec_new => l_asset_type_rec,
                                  px_asset_cat_rec_new  => l_asset_cat_rec);

Line: 353

  END update_asset;