eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_DEAL_TERMS_PVT SQL Statements

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

Line: 35


   PROCEDURE delete_terms(
            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_chr_id              IN  NUMBER,
            p_rgp_id              IN  NUMBER,
            p_page_name           IN  VARCHAR2) IS
  BEGIN
      null;

Line: 46


  END delete_terms;

Line: 140


    OKL_RULE_PUB.update_rule_group(
        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_rgpv_rec       => lp_labill_rgpv_rec,
        x_rgpv_rec       => lx_labill_rgpv_rec);

Line: 162


   OKL_CONTRACT_PUB.update_contract_header(
           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_restricted_update     => 'F',
           p_chrv_rec       	=> lp_chrv_rec,
           p_khrv_rec       	=> lp_khrv_rec,
           x_chrv_rec       	=> lx_chrv_rec,
           x_khrv_rec       	=> lx_khrv_rec);

Line: 231


      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       => lp_lapmth_rulv_rec,
        x_rulv_rec       => lx_lapmth_rulv_rec);

Line: 299


      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       => lp_labacc_rulv_rec,
        x_rulv_rec       => lx_labacc_rulv_rec);

Line: 373


      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       => lp_lainvd_rulv_rec,
        x_rulv_rec       => lx_lainvd_rulv_rec);

Line: 429


        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       => lp_lainpr_rulv_rec,
          x_rulv_rec       => lx_lainpr_rulv_rec);

Line: 556


    OKL_RULE_PUB.update_rule_group(
        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_rgpv_rec       => lp_larvin_rgpv_rec,
        x_rgpv_rec       => lx_larvin_rgpv_rec);

Line: 611


      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       => lp_larvau_rulv_rec,
        x_rulv_rec       => lx_larvau_rulv_rec);

Line: 667


      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       => lp_larvam_rulv_rec,
        x_rulv_rec       => lx_larvam_rulv_rec);

Line: 754


  SELECT chr.bill_to_site_use_id,
         csu.location bill_to_site_name
  FROM okc_k_headers_b chr,
       hz_cust_site_uses_all csu
  WHERE chr.id = p_chr_id
  AND   csu.site_use_id = chr.bill_to_site_use_id;

Line: 762


  SELECT rul.rgp_id,rgp.rgd_code,rul.ID,rul.object1_id1,rul.object1_id2,rul.rule_information1,rul.rule_information2,
         rul.rule_information3, rul.rule_information4
  FROM  okc_rules_b rul,
        okc_rule_groups_b rgp
  WHERE rgp.chr_id = p_chr_id
  AND   rgp.dnz_chr_id = p_chr_id
  AND   rgp.rgd_code = p_rgd_code
  AND   rgp.id = rul.rgp_id
  AND   rgp.dnz_chr_id = rul.dnz_chr_id
  AND   rul.rule_information_category = p_rule_info_cat;

Line: 776


  SELECT name
  FROM okx_receipt_methods_v
  WHERE id1 = p_object1_id1;

Line: 781


  SELECT name,bank_name
  FROM okx_rcpt_method_accounts_v
  WHERE id1 = p_object1_id1;

Line: 786


  SELECT name
  FROM okl_bpd_active_csh_rls_v
  WHERE id1 = p_object1_id1;

Line: 915


  SELECT rgp.dnz_chr_id,
         rgp.id rgp_id,
         rgp.rgd_code,
         rgp.id rgp_larvin_larvau_id,
         rgp.id rgp_larvin_larvam_id,
         rul_larvau.id rul_larvau_id,
	 rul_larvau.rule_information_category larvau_rule_info_cat,
	 rul_larvam.id rul_larvam_id,
	 rul_larvam.rule_information_category larvam_rule_info_cat,
         rul_larvau.rule_information1 larvau_rule_information1,
	 rul_larvam.rule_information4 larvam_rule_information4
  FROM  okc_rules_b rul_larvau,
        okc_rules_b rul_larvam,
        okc_rule_groups_b rgp
  WHERE rgp.chr_id = p_chr_id
  AND   rgp.dnz_chr_id = p_chr_id
  AND   rgp.rgd_code = 'LARVIN'
  AND   rul_larvau.rgp_id = rgp.id
  AND   rul_larvau.dnz_chr_id = rgp.dnz_chr_id
  AND   rul_larvau.rule_information_category = 'LARVAU'
  AND   rul_larvam.rgp_id = rgp.id
  AND   rul_larvam.rule_information_category = 'LARVAM'
  AND   rul_larvam.dnz_chr_id = rgp.dnz_chr_id;

Line: 940


  SELECT cle.id,ossv.id1,name,fee_type
  from okc_k_lines_b cle,
       okl_k_lines kle,
       okc_k_items itm,
       okl_strmtyp_source_v ossv,
       okc_line_styles_b olsb
  where cle.id = kle.id
  and cle.id = itm.cle_id
  and itm.object1_id1 = ossv.id1
  and kle.fee_type = 'ABSORBED'
  and kle.fee_purpose_code = 'RVI'
  and cle.lse_id = olsb.ID
  and olsb.LTY_CODE = 'FEE'
  and cle.dnz_chr_id = p_chr_id;

Line: 1010


 PROCEDURE delete_tnc_group(
      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_tnc_id                     IN  NUMBER
      ) is


  l_return_status        VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

Line: 1021


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

Line: 1026


  SELECT 'Y'
  from   okc_rule_groups_b
  where  id = p_rgp_id;

Line: 1033


  SELECT 'Y'
  from   OKL_PARTY_PAYMENT_HDR
  where  id = p_ppyh_id;

Line: 1040


  SELECT id, cpl_id
  from   OKL_PARTY_PAYMENT_DTLS
  where  payment_hdr_id = p_ppyh_id;

Line: 1071


                           'OKL_DEAL_CREAT_PVT.delete_tnc_group.',
                           'p_tnc_id :'||p_tnc_id);

Line: 1086


           FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_rule_group = '||x_return_status);

Line: 1089


        okc_rule_pub.delete_rule_group(
           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_rgpv_rec      => l_rgpv_rec);

Line: 1097


           FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_rule_group = '||x_return_status);

Line: 1133


                       FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_dtls = '||x_return_status);

Line: 1136


                   OKL_PARTY_PAYMENTS_PVT.delete_party_payment_dtls(
                     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_ppydv_rec     => l_ppydv_rec
                     );

Line: 1145


                       FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After call to delete_party_payment_dtls = '||x_return_status);

Line: 1157


               FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'Before call to delete_party_payment_hdr = '||x_return_status);

Line: 1160


          OKL_PARTY_PAYMENTS_PVT.delete_party_payment_hdr(
                     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_pphv_rec     => l_pphv_rec
                     );

Line: 1169


               FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'After  call to delete_party_payment_hdr = '||x_return_status);

Line: 1181


          FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'End(-)');

Line: 1203


              FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - ERROR');

Line: 1223


              FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - UNEXCP ERROR');

Line: 1243


              FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_DEAL_CREAT_PVT.delete_tnc_group.', 'EXP - OTHERS');

Line: 1245


  END delete_tnc_group;