APPS.OKL_FUNDING_CHECKLIST_PVT SQL Statements

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

Line: 22

 G_INSERT_MODE  VARCHAR2(10) := 'INSERT';

Line: 23

 G_UPDATE_MODE  VARCHAR2(10) := 'UPDATE';

Line: 24

 G_DELETE_MODE  VARCHAR2(10) := 'DELETE';

Line: 45

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

Line: 106

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

Line: 117

    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: 185

    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: 194

    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: 264

    SELECT 1
      FROM okl_funding_checklists_uv lst
     WHERE lst.FUND_REQ_ID = p_freq_id
     group by lst.todo_item_code, lst.function_id
     having count(1) > 1
    ;

Line: 430

select id
from okc_rule_groups_b
where rgd_code = G_FUNDING_CHKLST_TPL--'LAFCLH'
and dnz_chr_id = chr_id;

Line: 489

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

Line: 776

    select rgp.id
  from okc_rule_groups_b rgp
  where rgp.dnz_chr_id = p_chr_id
  and rgp.RGD_CODE = G_FUNDING_CHKLST_TPL
  ;

Line: 884

          p_mode           => G_INSERT_MODE
      );

Line: 968

 PROCEDURE update_funding_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_funding_chklst';

Line: 989

  SAVEPOINT update_funding_chklst;

Line: 1020

          p_mode           => G_UPDATE_MODE
      );

Line: 1032

      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: 1065

    ROLLBACK TO update_funding_chklst;

Line: 1072

    ROLLBACK TO update_funding_chklst;

Line: 1079

	ROLLBACK TO update_funding_chklst;

Line: 1091

end update_funding_chklst;

Line: 1104

 PROCEDURE delete_funding_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_funding_chklst';

Line: 1124

  SAVEPOINT delete_funding_chklst;

Line: 1155

          p_mode           => G_DELETE_MODE
      );

Line: 1166

      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: 1189

    ROLLBACK TO delete_funding_chklst;

Line: 1196

    ROLLBACK TO delete_funding_chklst;

Line: 1203

	ROLLBACK TO delete_funding_chklst;

Line: 1215

end delete_funding_chklst;

Line: 1272

  OKL_FUNDING_PVT.update_funding_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_tapv_rec      => lp_tapv_rec,
      x_tapv_rec      => lx_tapv_rec);

Line: 1354

select a.id
from okc_rules_b a
where a.dnz_chr_id = p_chr_id
-- Sep-26-2005 cklee -- Fixed ORA-01722: invalid number for                   |
--                      approve_funding_chklst function cursor issue          |
--and   a.object1_id1 = p_req_id
and   a.object1_id1 = TO_CHAR(p_req_id)
and   a.RULE_INFORMATION_CATEGORY =	G_FUNDING_CHKLST_TPL_RULE1--'LAFCLD'
;

Line: 1404

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