APPS.OKL_RULE_PUB SQL Statements

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

Line: 18

    l_rulv_rec.last_updated_by       := p_rulv_rec.last_updated_by;

Line: 19

    l_rulv_rec.last_update_date      := p_rulv_rec.last_update_date;

Line: 20

    l_rulv_rec.last_update_login     := p_rulv_rec.last_update_login;

Line: 91

    l_rulv_rec.last_updated_by       := p_rulv_rec1.last_updated_by;

Line: 92

    l_rulv_rec.last_update_date      := p_rulv_rec1.last_update_date;

Line: 93

    l_rulv_rec.last_update_login     := p_rulv_rec1.last_update_login;

Line: 174

    SELECT scs_code
    FROM OKC_K_HEADERS_V
    WHERE id = p_chr_id;

Line: 476

  PROCEDURE update_rule(
    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_rulv_rec                     IN  rulv_rec_type,
    p_edit_mode                    IN  VARCHAR2,
    x_rulv_rec                     OUT NOCOPY rulv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 487

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

Line: 495

    SELECT scs_code
    FROM OKC_K_HEADERS_V
    WHERE id = p_chr_id;

Line: 540

    OKC_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_rulv_rec_okc,
      x_rulv_rec      => l_rulv_rec_okc_out);

Line: 640

  END update_rule;

Line: 645

  PROCEDURE update_rule(
    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_rulv_rec                     IN  rulv_rec_type,
    x_rulv_rec                     OUT NOCOPY rulv_rec_type) IS

    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 655

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

Line: 673

     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_rulv_rec,
      p_edit_mode     => 'Y',
      x_rulv_rec      => x_rulv_rec);

Line: 716

  END update_rule;

Line: 723

  PROCEDURE update_rule(
    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_rulv_tbl                     IN  rulv_tbl_type,
    p_edit_mode                    IN  VARCHAR2,
    x_rulv_tbl                     OUT NOCOPY rulv_tbl_type) IS
    i                              NUMBER := 0;

Line: 739

        update_rule(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rulv_rec      => p_rulv_tbl(i),
          p_edit_mode     => p_edit_mode,
          x_rulv_rec      => x_rulv_tbl(i));

Line: 774

  END update_rule;

Line: 779

  PROCEDURE update_rule(
    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_rulv_tbl                     IN  rulv_tbl_type,
    x_rulv_tbl                     OUT NOCOPY rulv_tbl_type) IS
    i                              NUMBER := 0;

Line: 794

        update_rule(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rulv_rec      => p_rulv_tbl(i),
          x_rulv_rec      => x_rulv_tbl(i));

Line: 828

  END update_rule;

Line: 968

  PROCEDURE delete_rule(
    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_rulv_rec                     IN  rulv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 976

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

Line: 983

    SELECT DNZ_CHR_ID
    FROM   OKC_RULES_B
    WHERE  ID = P_RUL_ID;

Line: 991

    SELECT scs_code
    FROM OKC_K_HEADERS_V
    WHERE id = p_chr_id;

Line: 1073

    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_rec      => l_rulv_rec_okc);

Line: 1120

  END delete_rule;

Line: 1125

  PROCEDURE delete_rule(
    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_rulv_tbl                     IN  rulv_tbl_type) IS
    i                              NUMBER := 0;

Line: 1139

        delete_rule(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rulv_rec      => p_rulv_tbl(i));

Line: 1172

  END delete_rule;

Line: 1266

    l_rgpv_rec.last_updated_by       := p_rgpv_rec1.last_updated_by;

Line: 1267

    l_rgpv_rec.last_update_date      := p_rgpv_rec1.last_update_date;

Line: 1268

    l_rgpv_rec.last_update_login     := p_rgpv_rec1.last_update_login;

Line: 1439

  PROCEDURE update_rule_group(
    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_rgpv_rec                     IN  rgpv_rec_type,
    x_rgpv_rec                     OUT NOCOPY rgpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 1448

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

Line: 1469

    okl_okc_migration_pvt.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      => l_rgpv_rec,
      x_rgpv_rec      => x_rgpv_rec);

Line: 1517

  END update_rule_group;

Line: 1522

  PROCEDURE update_rule_group(
    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_rgpv_tbl                     IN  rgpv_tbl_type,
    x_rgpv_tbl                     OUT NOCOPY rgpv_tbl_type) IS
    i                              NUMBER := 0;

Line: 1537

        update_rule_group(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rgpv_rec      => p_rgpv_tbl(i),
          x_rgpv_rec      => x_rgpv_tbl(i));

Line: 1571

  END update_rule_group;

Line: 1576

  PROCEDURE delete_rule_group(
    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_rgpv_rec                     IN  rgpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 1584

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

Line: 1604

    okl_okc_migration_pvt.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      => p_rgpv_rec);

Line: 1651

  END delete_rule_group;

Line: 1656

  PROCEDURE delete_rule_group(
    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_rgpv_tbl                     IN  rgpv_tbl_type) IS
    i                              NUMBER := 0;

Line: 1670

        delete_rule_group(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rgpv_rec      => p_rgpv_tbl(i));

Line: 1703

  END delete_rule_group;

Line: 1928

    l_rmpv_rec.last_updated_by       := p_rmpv_rec1.last_updated_by;

Line: 1929

    l_rmpv_rec.last_update_date      := p_rmpv_rec1.last_update_date;

Line: 1930

    l_rmpv_rec.last_update_login     := p_rmpv_rec1.last_update_login;

Line: 2075

  PROCEDURE update_rg_mode_pty_role(
    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_rmpv_rec                     IN  rmpv_rec_type,
    x_rmpv_rec                     OUT NOCOPY rmpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 2084

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

Line: 2105

    okl_okc_migration_pvt.update_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_rec      => l_rmpv_rec,
      x_rmpv_rec      => x_rmpv_rec);

Line: 2153

  END update_rg_mode_pty_role;

Line: 2158

  PROCEDURE update_rg_mode_pty_role(
    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_rmpv_tbl                     IN  rmpv_tbl_type,
    x_rmpv_tbl                     OUT NOCOPY rmpv_tbl_type) IS
    i                              NUMBER := 0;

Line: 2173

        update_rg_mode_pty_role(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rmpv_rec      => p_rmpv_tbl(i),
          x_rmpv_rec      => x_rmpv_tbl(i));

Line: 2207

  END update_rg_mode_pty_role;

Line: 2212

  PROCEDURE delete_rg_mode_pty_role(
    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_rmpv_rec                     IN  rmpv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 2220

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

Line: 2240

    okl_okc_migration_pvt.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_rec      => p_rmpv_rec);

Line: 2287

  END delete_rg_mode_pty_role;

Line: 2292

  PROCEDURE delete_rg_mode_pty_role(
    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_rmpv_tbl                     IN  rmpv_tbl_type) IS
    i                              NUMBER := 0;

Line: 2306

        delete_rg_mode_pty_role(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rmpv_rec      => p_rmpv_tbl(i));

Line: 2339

  END delete_rg_mode_pty_role;

Line: 2560

    l_ctiv_rec.last_updated_by       := p_ctiv_rec1.last_updated_by;

Line: 2561

    l_ctiv_rec.last_update_date      := p_ctiv_rec1.last_update_date;

Line: 2562

    l_ctiv_rec.last_update_login     := p_ctiv_rec1.last_update_login;

Line: 2707

  PROCEDURE update_cover_time(
    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_ctiv_rec                     IN  ctiv_rec_type,
    x_ctiv_rec                     OUT NOCOPY ctiv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 2716

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

Line: 2737

    OKC_RULE_PUB.update_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_rec      => l_ctiv_rec,
      x_ctiv_rec      => x_ctiv_rec);

Line: 2785

  END update_cover_time;

Line: 2790

  PROCEDURE update_cover_time(
    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_ctiv_tbl                     IN  ctiv_tbl_type,
    x_ctiv_tbl                     OUT NOCOPY ctiv_tbl_type) IS
    i                              NUMBER := 0;

Line: 2805

        update_cover_time(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_ctiv_rec      => p_ctiv_tbl(i),
          x_ctiv_rec      => x_ctiv_tbl(i));

Line: 2839

  END update_cover_time;

Line: 2844

  PROCEDURE delete_cover_time(
    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_ctiv_rec                     IN  ctiv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 2852

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

Line: 2872

    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_rec      => p_ctiv_rec);

Line: 2919

  END delete_cover_time;

Line: 2924

  PROCEDURE delete_cover_time(
    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_ctiv_tbl                     IN  ctiv_tbl_type) IS
    i                              NUMBER := 0;

Line: 2938

        delete_cover_time(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_ctiv_rec      => p_ctiv_tbl(i));

Line: 2971

  END delete_cover_time;

Line: 3194

    l_rilv_rec.last_updated_by       := p_rilv_rec1.last_updated_by;

Line: 3195

    l_rilv_rec.last_update_date      := p_rilv_rec1.last_update_date;

Line: 3196

    l_rilv_rec.last_update_login     := p_rilv_rec1.last_update_login;

Line: 3341

  PROCEDURE update_react_interval(
    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_rilv_rec                     IN  rilv_rec_type,
    x_rilv_rec                     OUT NOCOPY rilv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 3350

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

Line: 3371

    OKC_RULE_PUB.update_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_rec      => l_rilv_rec,
      x_rilv_rec      => x_rilv_rec);

Line: 3419

  END update_react_interval;

Line: 3424

  PROCEDURE update_react_interval(
    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_rilv_tbl                     IN  rilv_tbl_type,
    x_rilv_tbl                     OUT NOCOPY rilv_tbl_type) IS
    i                              NUMBER := 0;

Line: 3439

        update_react_interval(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rilv_rec      => p_rilv_tbl(i),
          x_rilv_rec      => x_rilv_tbl(i));

Line: 3473

  END update_react_interval;

Line: 3478

  PROCEDURE delete_react_interval(
    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_rilv_rec                     IN  rilv_rec_type) IS
    l_return_status                VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line: 3486

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

Line: 3506

    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_rec      => p_rilv_rec);

Line: 3553

  END delete_react_interval;

Line: 3558

  PROCEDURE delete_react_interval(
    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_rilv_tbl                     IN  rilv_tbl_type) IS
    i                              NUMBER := 0;

Line: 3572

        delete_react_interval(
          p_api_version   => p_api_version,
          p_init_msg_list => p_init_msg_list,
          x_return_status => l_return_status,
          x_msg_count     => x_msg_count,
          x_msg_data      => x_msg_data,
          p_rilv_rec      => p_rilv_tbl(i));

Line: 3605

  END delete_react_interval;

Line: 3828

 select meaning
 from   okc_rule_defs_v
 where  rule_code = p_rle_code;

Line: 3847

      SELECT JTOT_OBJECT_CODE
      FROM okc_rule_def_sources_v
      WHERE RGR_RGD_CODE = p_rgd_code
	and RGR_RDF_CODE = p_rdf_code
	and BUY_OR_SELL  = p_intent
	and OBJECT_ID_NUMBER = p_number
	and sysdate between start_date and nvl(end_date,sysdate)
    ;

Line: 3913

      SELECT
	'(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
	||from_table select_clause
--      ||decode(p_clause_yn,'Y',decode(where_clause,'','',' where '||where_clause))|| ')'
        ,where_clause
      FROM JTF_OBJECTS_VL
      WHERE object_code = p_object_code;

Line: 3924

      '(select ''object_code'' object_code, ''id1'' id1, ''id2'' id2, ''value'' value, ''description'' description from dual where 0=1)';

Line: 3945

      SELECT object1_id1 from okc_k_party_roles_v
      where id = p_cpl_id;

Line: 3950

      SELECT
	'(select ''' || p_object_code || ''' object_code, id1, id2, name value, description from '
	||from_table||decode(where_clause,
		'',' where status = ''A'' and party_id = '''||l1||'''',
		' where status = ''A'' and party_id = '''||l1||''' and '||where_clause)|| ')'
      FROM JTF_OBJECTS_VL
      WHERE object_code = p_object_code;

Line: 3960

      '(select ''object_code'' object_code, ''id1'' id1, ''id2'' id2, ''value'' value, ''description'' description from dual where 0=1)';

Line: 3990

	'select value from '||get_object_sql(p_object_code,'Y')
	||' where id1=:1 and id2=:2';

Line: 4013

	'select description from '||get_object_sql(p_object_code,'Y')
	||' where id1=:1 and id2=:2';

Line: 4041

	'select object_code, id1, id2, description from '||p_sql
	||' where value=:1';

Line: 4066

	'select object_code, id1, id2, description from '||p_sql
	||' where value=:1 and ((:2 is null and description is null) or (:3 = description))';

Line: 4100

    select 'select '||tbl.ID_COLUMN_NAME||' id, '
		||decode(col.END_USER_COLUMN_NAME,'TVE_ID',
'comments value, '''' description from ',
tbl.VALUE_COLUMN_NAME||' value, '||NVL(tbl.MEANING_COLUMN_NAME,'''''')||' description from ')
		||tbl.APPLICATION_TABLE_NAME sel,
	tbl.ADDITIONAL_WHERE_CLAUSE whr
	from fnd_descr_flex_col_usage_vl  col,
	     fnd_flex_validation_tables   tbl,
         okc_rule_defs_v              rdefv
	where col.application_id                = rdefv.application_id
	and   col.descriptive_flexfield_name    = rdefv.descriptive_flexfield_name
	and   col.descriptive_flex_context_code = rdefv.rule_code
	and   col.application_column_name       = p_col_name
    and   rdefv.rule_code                   = p_rdf_code
	and   col.FLEX_VALUE_SET_ID=tbl.FLEX_VALUE_SET_ID;

Line: 4161

    l_sql := 'select value from '||l_sql||' where id=:1';

Line: 4184

    l_sql := 'select description from '||l_sql||' where id=:1';

Line: 4209

	'select id, description from '||p_sql
	||' where value=:1';

Line: 4232

	'select id, description from '||p_sql
	||' where value=:1 and ((:2 is null and description is null) or (:3 = description))';

Line: 4287

  x(1).last_update_date := sysdate;

Line: 4292

  x(1).last_update_date := sysdate;

Line: 4297

  x(1).last_update_date := sysdate;