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.OKC_RULE_PVT SQL Statements

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

Line: 6


  G_EXCEPTION_CANNOT_DELETE    EXCEPTION;

Line: 8


  G_CANNOT_DELETE_MASTER       CONSTANT VARCHAR2(200) := 'OKC_CANNOT_DELETE_MASTER';

Line: 25


  PROCEDURE update_minor_version(p_chr_id NUMBER) IS
    l_api_version                NUMBER := 1;

Line: 34


   l_proc varchar2(72) := g_package||'update_minor_version';

Line: 41


    OKC_CVM_PVT.update_contract_version(
      p_api_version    => l_api_version,
      p_init_msg_list  => l_init_msg_list,
      x_return_status  => x_return_status,
      x_msg_count      => x_msg_count,
      x_msg_data       => x_msg_data,
      p_cvmv_rec       => l_cvmv_rec,
      x_cvmv_rec       => x_out_rec);

Line: 72


  END update_minor_version;

Line: 89


   Select application_id
   from okc_k_headers_b
   where id = p_id;

Line: 95


   SELECT application_id,meaning
   FROM   okc_rule_defs_v
   where rule_code = P_rule_code;

Line: 149


      SELECT chr.*
        FROM OKC_K_HEADERS_B chr
       WHERE chr.id = p_rulv_rec.dnz_chr_id;

Line: 202


    OKC_RUL_PVT.insert_row(
      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_rulv_rec,
      x_rulv_rec      => x_rulv_rec);

Line: 213


      update_minor_version(p_rulv_rec.dnz_chr_id);

Line: 252


  PROCEDURE update_rule(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rulv_rec                     IN  rulv_rec_type,
    x_rulv_rec                     OUT NOCOPY rulv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'update_rule';

Line: 279


   OKC_RUL_PVT.update_row(
      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      => p_rulv_rec,
      x_rulv_rec      => x_rulv_rec);

Line: 290


      update_minor_version(p_rulv_rec.dnz_chr_id);

Line: 318


  END update_rule;

Line: 320


  PROCEDURE delete_rule(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rulv_rec                     IN  rulv_rec_type) IS

    l_dummy_var VARCHAR(1) := NULL;

Line: 331


      SELECT *
        FROM OKC_COVER_TIMES_V ctiv
       WHERE ctiv.RUL_ID = p_rulv_rec.id;

Line: 336


      SELECT 'x'
        FROM OKC_ARTICLE_TRANS_V atnv
       WHERE atnv.RUL_ID = p_rulv_rec.id;

Line: 341


      SELECT *
        FROM OKC_REACT_INTERVALS_V rilv
       WHERE rilv.RUL_ID = p_rulv_rec.id;

Line: 350


    SELECT RULE_INFORMATION_CATEGORY
    FROM OKC_RULES_B
    WHERE ID = p_rulv_rec.id;

Line: 357


   l_proc varchar2(72) := g_package||'delete_rule';

Line: 365


      RAISE G_EXCEPTION_CANNOT_DELETE;

Line: 378


      OKC_RULE_PUB.delete_cover_time(
        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_ctiv_tbl      => l_ctiv_tbl);

Line: 403


      OKC_RULE_PUB.delete_react_interval(
        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_rilv_tbl      => l_rilv_tbl);

Line: 440


         okc_time_pub.delete_timevalues_n_tasks(
           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_tve_id	   => l_col_vals(i).col_value);

Line: 459


    OKC_RUL_PVT.delete_row(
      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      => p_rulv_rec);

Line: 469


      update_minor_version(p_rulv_rec.dnz_chr_id);

Line: 473


  WHEN G_EXCEPTION_CANNOT_DELETE THEN

    -- store SQL error message on message stack
    OKC_API.SET_MESSAGE(
      p_app_name        => G_APP_NAME,
      p_msg_name        => G_CANNOT_DELETE_MASTER);

Line: 508


  END delete_rule;

Line: 581


    OKC_RGP_PVT.insert_row(
      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      => p_rgpv_rec,
      x_rgpv_rec      => x_rgpv_rec);

Line: 592


      update_minor_version(p_rgpv_rec.dnz_chr_id);

Line: 618


  PROCEDURE update_rule_group(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type,
    x_rgpv_rec                     OUT NOCOPY rgpv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'update_rule_group';

Line: 647


    OKC_RGP_PVT.update_row(
      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      => p_rgpv_rec,
      x_rgpv_rec      => x_rgpv_rec);

Line: 658


      update_minor_version(p_rgpv_rec.dnz_chr_id);

Line: 686


  END update_rule_group;

Line: 688


  PROCEDURE delete_rule_group(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rgpv_rec                     IN  rgpv_rec_type) IS

    i NUMBER;

Line: 699


      SELECT rgp_type
        FROM OKC_RULE_GROUPS_B rgpv
       WHERE rgpv.ID = p_rgpv_rec.id;

Line: 705


      SELECT id
        FROM OKC_RULE_GROUPS_B rgpv
       WHERE rgpv.PARENT_RGP_ID = p_rgpv_rec.id;

Line: 711


      SELECT id
        FROM OKC_RULES_B rulv
       WHERE rulv.RGP_ID = p_rgpv_rec.id;

Line: 718


      SELECT id
        FROM OKC_RG_PARTY_ROLES_V rmpv
       WHERE rmpv.RGP_ID = p_rgpv_rec.id;

Line: 724


   l_proc varchar2(72) := g_package||'delete_rule_group';

Line: 734


      RAISE G_EXCEPTION_CANNOT_DELETE;

Line: 747


        OKC_RULE_PUB.delete_rg_mode_pty_role(
          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_rmpv_tbl      => l_rmpv_tbl);

Line: 772


        OKC_RULE_PUB.delete_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_tbl      => l_rulv_tbl);

Line: 786


    OKC_RGP_PVT.delete_row(
      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      => p_rgpv_rec);

Line: 796


      update_minor_version(p_rgpv_rec.dnz_chr_id);

Line: 803


  WHEN G_EXCEPTION_CANNOT_DELETE THEN


    -- store SQL error message on message stack
    OKC_API.SET_MESSAGE(
      p_app_name        => G_APP_NAME,
      p_msg_name        => G_CANNOT_DELETE_MASTER);

Line: 843


  END delete_rule_group;

Line: 914


    OKC_RMP_PVT.insert_row(
      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_rmpv_rec      => p_rmpv_rec,
      x_rmpv_rec      => x_rmpv_rec);

Line: 925


      update_minor_version(p_rmpv_rec.dnz_chr_id);

Line: 947


  PROCEDURE update_rg_mode_pty_role(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rmpv_rec                     IN  rmpv_rec_type,
    x_rmpv_rec                     OUT NOCOPY rmpv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'update_rg_mode_pty_role';

Line: 963


    OKC_RMP_PVT.update_row(
      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_rmpv_rec      => p_rmpv_rec,
      x_rmpv_rec      => x_rmpv_rec);

Line: 974


      update_minor_version(p_rmpv_rec.dnz_chr_id);

Line: 994


  END update_rg_mode_pty_role;

Line: 996


  PROCEDURE delete_rg_mode_pty_role(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rmpv_rec                     IN  rmpv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'delete_rg_mode_pty_role';

Line: 1011


    OKC_RMP_PVT.delete_row(
      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_rmpv_rec      => p_rmpv_rec);

Line: 1021


      update_minor_version(p_rmpv_rec.dnz_chr_id);

Line: 1041


  END delete_rg_mode_pty_role;

Line: 1116


    OKC_CTI_PVT.insert_row(
      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_ctiv_rec      => p_ctiv_rec,
      x_ctiv_rec      => x_ctiv_rec);

Line: 1127


      update_minor_version(p_ctiv_rec.dnz_chr_id);

Line: 1149


  PROCEDURE update_cover_time(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ctiv_rec                     IN  ctiv_rec_type,
    x_ctiv_rec                     OUT NOCOPY ctiv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'update_cover_time';

Line: 1165


    OKC_CTI_PVT.update_row(
      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_ctiv_rec      => p_ctiv_rec,
      x_ctiv_rec      => x_ctiv_rec);

Line: 1176


      update_minor_version(p_ctiv_rec.dnz_chr_id);

Line: 1196


  END update_cover_time;

Line: 1198


  PROCEDURE delete_cover_time(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ctiv_rec                     IN  ctiv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'delete_cover_time';

Line: 1213


    OKC_CTI_PVT.delete_row(
      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_ctiv_rec      => p_ctiv_rec);

Line: 1223


      update_minor_version(p_ctiv_rec.dnz_chr_id);

Line: 1243


  END delete_cover_time;

Line: 1314


    OKC_RIL_PVT.insert_row(
      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_rilv_rec      => p_rilv_rec,
      x_rilv_rec      => x_rilv_rec);

Line: 1325


      update_minor_version(p_rilv_rec.dnz_chr_id);

Line: 1347


  PROCEDURE update_react_interval(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_rec                     IN  rilv_rec_type,
    x_rilv_rec                     OUT NOCOPY rilv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'update_react_interval';

Line: 1363


    OKC_RIL_PVT.update_row(
      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_rilv_rec      => p_rilv_rec,
      x_rilv_rec      => x_rilv_rec);

Line: 1374


      update_minor_version(p_rilv_rec.dnz_chr_id);

Line: 1394


  END update_react_interval;

Line: 1396


  PROCEDURE delete_react_interval(
    p_api_version                  IN  NUMBER,
    p_init_msg_list                IN  VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_rilv_rec                     IN  rilv_rec_type) IS
   --
   l_proc varchar2(72) := g_package||'delete_react_interval';

Line: 1411


    OKC_RIL_PVT.delete_row(
      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_rilv_rec      => p_rilv_rec);

Line: 1421


      update_minor_version(p_rilv_rec.dnz_chr_id);

Line: 1441


  END delete_react_interval;