APPS.OKL_CREDIT_CHECKLIST_PVT SQL Statements

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

Line: 14

 G_INSERT_MODE  VARCHAR2(10) := 'INSERT';

Line: 15

 G_UPDATE_MODE  VARCHAR2(10) := 'UPDATE';

Line: 16

 G_DELETE_MODE  VARCHAR2(10) := 'DELETE';

Line: 38

    SELECT 1
      FROM OKL_DATA_SRC_FNCTNS_V fun
     WHERE fun.id = p_id
    ;

Line: 107

    SELECT 1
      FROM fnd_lookups lok
     WHERE lookup_type = 'OKL_CHECKLIST_TYPE'
     and lok.enabled_flag = 'Y'
     and lok.lookup_code = p_type
     and lok.lookup_code = p_lookup_code
    ;

Line: 125

    IF (p_mode = G_INSERT_MODE) THEN

      -- column is required:
      IF (l_checklist_type IS NULL) OR
         (l_checklist_type = OKL_API.G_MISS_CHAR)
      THEN
        OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                            p_msg_name     => G_REQUIRED_VALUE,
                            p_token1       => G_COL_NAME_TOKEN,
                            p_token1_value => 'CHECKLIST_TYPE');

Line: 196

    SELECT 1
      FROM fnd_lookups lok
     WHERE lookup_type = 'OKL_TODO_ITEMS'
     and lok.enabled_flag = 'Y'
     and lok.lookup_code = p_lookup_code
    ;

Line: 207

    IF (p_mode = G_INSERT_MODE) THEN

      -- column is required:
      IF (p_rulv_rec.RULE_INFORMATION1 IS NULL) OR
         (p_rulv_rec.RULE_INFORMATION1 = OKL_API.G_MISS_CHAR)
      THEN
        OKL_API.Set_Message(p_app_name     => G_APP_NAME,
                            p_msg_name     => G_REQUIRED_VALUE,
                            p_token1       => G_COL_NAME_TOKEN,
                            p_token1_value => 'TODO_ITEM');

Line: 280

    SELECT 1
      FROM okl_credit_checklists_uv lst
     WHERE lst.khr_id = p_chr_id
     group by lst.todo_item_code, lst.function_id
     having count(1) > 1
    ;

Line: 289

    SELECT 1
      FROM okl_crd_fund_checklists_tpl_uv lst
     WHERE lst.khr_id = p_chr_id
     group by lst.todo_item_code, lst.function_id
     having count(1) > 1
    ;

Line: 542

  is select 1
FROM
  OKC_RULES_B rulh
where rulh.RULE_INFORMATION1 is not null
and trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION1)) > trunc(FND_DATE.CANONICAL_TO_DATE(rulh.RULE_INFORMATION2))
--and rulh.rule_information_category = 'LACLFM'
and rulh.id = p_id;

Line: 756

select id
from okc_rule_groups_b
where rgd_code = G_CREDIT_CHKLST_TPL--'LACCLH'
and dnz_chr_id = chr_id;

Line: 763

select id
from okc_rules_b
where RULE_INFORMATION_CATEGORY = G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
and dnz_chr_id = chr_id;

Line: 850

    IF p_mode = G_INSERT_MODE THEN
      OPEN c_rgp_id(p_rulv_rec.DNZ_CHR_ID);

Line: 1088

          p_mode           => G_INSERT_MODE
      );

Line: 1177

 PROCEDURE update_credit_chklst(
    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_tbl                     IN  rulv_tbl_type
   ,x_rulv_tbl                     OUT NOCOPY rulv_tbl_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'update_credit_chklst';

Line: 1198

  SAVEPOINT update_credit_chklst;

Line: 1231

          p_mode           => G_UPDATE_MODE
      );

Line: 1243

      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_tbl       => lp_rulv_tbl,
          x_rulv_tbl       => lx_rulv_tbl);

Line: 1281

    ROLLBACK TO update_credit_chklst;

Line: 1288

    ROLLBACK TO update_credit_chklst;

Line: 1295

	ROLLBACK TO update_credit_chklst;

Line: 1307

end update_credit_chklst;

Line: 1320

 PROCEDURE delete_credit_chklst(
    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_tbl                     IN  rulv_tbl_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'delete_credit_chklst';

Line: 1340

  SAVEPOINT delete_credit_chklst;

Line: 1372

          p_mode           => G_DELETE_MODE
      );

Line: 1383

      okl_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       => lp_rulv_tbl);

Line: 1406

    ROLLBACK TO delete_credit_chklst;

Line: 1413

    ROLLBACK TO delete_credit_chklst;

Line: 1420

	ROLLBACK TO delete_credit_chklst;

Line: 1432

end delete_credit_chklst;

Line: 1464

select a.id
from okc_rules_b a
where a.dnz_chr_id = p_chr_id
and   a.RULE_INFORMATION_CATEGORY =	G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
;

Line: 1510

      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_tbl       => lp_rulv_tbl,
          x_rulv_tbl       => lx_rulv_tbl);

Line: 1572

 PROCEDURE update_fund_chklst_tpl_hdr(
    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_tbl                     IN  rulv_tbl_type
   ,x_rulv_tbl                     OUT NOCOPY rulv_tbl_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'update_fund_chklst_tpl_hdr_pvt';

Line: 1593

  SAVEPOINT update_fund_chklst_tpl_hdr;

Line: 1623

    ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1630

    ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1637

	ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1649

end update_fund_chklst_tpl_hdr;

Line: 1662

 PROCEDURE update_fund_chklst_tpl_hdr(
    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_api_name         CONSTANT VARCHAR2(30) := 'update_fund_chklst_tpl_hdr_pvt';

Line: 1683

  SAVEPOINT update_fund_chklst_tpl_hdr;

Line: 1710

                                                  p_mode     => G_UPDATE_MODE); -- funding checklist header

Line: 1747

      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_rulv_rec,
          x_rulv_rec       => lx_rulv_rec);

Line: 1785

    ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1792

    ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1799

	ROLLBACK TO update_fund_chklst_tpl_hdr;

Line: 1811

end update_fund_chklst_tpl_hdr;

Line: 1824

 PROCEDURE update_funding_chklst_tpl(
    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_tbl                     IN  rulv_tbl_type
   ,x_rulv_tbl                     OUT NOCOPY rulv_tbl_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'update_funding_chklst_tpl';

Line: 1845

  SAVEPOINT update_funding_chklst_tpl;

Line: 1878

          p_mode           => G_UPDATE_MODE
    );

Line: 1890

      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_tbl       => lp_rulv_tbl,
          x_rulv_tbl       => lx_rulv_tbl);

Line: 1928

    ROLLBACK TO update_funding_chklst_tpl;

Line: 1935

    ROLLBACK TO update_funding_chklst_tpl;

Line: 1942

	ROLLBACK TO update_funding_chklst_tpl;

Line: 1954

end update_funding_chklst_tpl;

Line: 1988

select a.id
from okc_rules_b a
where a.dnz_chr_id = p_chr_id
and   a.RULE_INFORMATION_CATEGORY =	G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
;

Line: 2026

  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_rulv_rec,
          x_rulv_rec       => lx_rulv_rec);

Line: 2144

          p_mode           => G_INSERT_MODE
    );

Line: 2232

 PROCEDURE delete_funding_chklst_tpl(
    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_tbl                     IN  rulv_tbl_type
 )
is
  l_api_name         CONSTANT VARCHAR2(30) := 'delete_funding_chklst_tpl';

Line: 2252

  SAVEPOINT delete_funding_chklst_tpl;

Line: 2284

          p_mode           => G_DELETE_MODE
      );

Line: 2294

      okl_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       => lp_rulv_tbl);

Line: 2317

    ROLLBACK TO delete_funding_chklst_tpl;

Line: 2324

    ROLLBACK TO delete_funding_chklst_tpl;

Line: 2331

	ROLLBACK TO delete_funding_chklst_tpl;

Line: 2343

end delete_funding_chklst_tpl;