DBA Data[Home] [Help]

APPS.OKL_RULE_APIS_PVT SQL Statements

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

Line: 44

    SELECT
            rgpv.ID,
            rgpv.OBJECT_VERSION_NUMBER,
            rgpv.SFWT_FLAG,
            rgpv.RGD_CODE,
            rgpv.SAT_CODE,
            rgpv.RGP_TYPE,
            rgpv.CLE_ID,
            rgpv.CHR_ID,
            rgpv.DNZ_CHR_ID,
            rgpv.PARENT_RGP_ID,
            rgpv.COMMENTS,
            rgpv.ATTRIBUTE_CATEGORY,
            rgpv.ATTRIBUTE1,
            rgpv.ATTRIBUTE2,
            rgpv.ATTRIBUTE3,
            rgpv.ATTRIBUTE4,
            rgpv.ATTRIBUTE5,
            rgpv.ATTRIBUTE6,
            rgpv.ATTRIBUTE7,
            rgpv.ATTRIBUTE8,
            rgpv.ATTRIBUTE9,
            rgpv.ATTRIBUTE10,
            rgpv.ATTRIBUTE11,
            rgpv.ATTRIBUTE12,
            rgpv.ATTRIBUTE13,
            rgpv.ATTRIBUTE14,
            rgpv.ATTRIBUTE15,
            rgpv.CREATED_BY,
            rgpv.CREATION_DATE,
            rgpv.LAST_UPDATED_BY,
            rgpv.LAST_UPDATE_DATE,
            rgpv.LAST_UPDATE_LOGIN
     FROM   Okc_Rule_Groups_V rgpv
     WHERE  rgpv.chr_id     = p_chr_id
     AND    rgpv.dnz_chr_id = p_chr_id
     AND    rgpv.cle_id is NULL
     AND    rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);
Line: 86

    SELECT
            rgpv.ID,
            rgpv.OBJECT_VERSION_NUMBER,
            rgpv.SFWT_FLAG,
            rgpv.RGD_CODE,
            rgpv.SAT_CODE,
            rgpv.RGP_TYPE,
            rgpv.CLE_ID,
            rgpv.CHR_ID,
            rgpv.DNZ_CHR_ID,
            rgpv.PARENT_RGP_ID,
            rgpv.COMMENTS,
            rgpv.ATTRIBUTE_CATEGORY,
            rgpv.ATTRIBUTE1,
            rgpv.ATTRIBUTE2,
            rgpv.ATTRIBUTE3,
            rgpv.ATTRIBUTE4,
            rgpv.ATTRIBUTE5,
            rgpv.ATTRIBUTE6,
            rgpv.ATTRIBUTE7,
            rgpv.ATTRIBUTE8,
            rgpv.ATTRIBUTE9,
            rgpv.ATTRIBUTE10,
            rgpv.ATTRIBUTE11,
            rgpv.ATTRIBUTE12,
            rgpv.ATTRIBUTE13,
            rgpv.ATTRIBUTE14,
            rgpv.ATTRIBUTE15,
            rgpv.CREATED_BY,
            rgpv.CREATION_DATE,
            rgpv.LAST_UPDATED_BY,
            rgpv.LAST_UPDATE_DATE,
            rgpv.LAST_UPDATE_LOGIN
     FROM   Okc_Rule_Groups_V rgpv
     WHERE  rgpv.cle_id     = p_cle_id
     AND    rgpv.dnz_chr_id = p_chr_id
     AND    rgpv.chr_id is NULL
     AND    rgpv.RGD_CODE = decode(p_rgd_code,null,rgpv.RGD_CODE,p_rgd_code);
Line: 127

    select cleb.dnz_chr_id
    from   okc_k_lines_b cleb
    where  cleb.id       = p_cle_id;
Line: 191

              l_rgpv_rec.LAST_UPDATED_BY,
              l_rgpv_rec.LAST_UPDATE_DATE,
              l_rgpv_rec.LAST_UPDATE_LOGIN;
Line: 242

              l_rgpv_rec.LAST_UPDATED_BY,
              l_rgpv_rec.LAST_UPDATE_DATE,
              l_rgpv_rec.LAST_UPDATE_LOGIN;
Line: 290

              l_rgpv_rec.LAST_UPDATED_BY,
              l_rgpv_rec.LAST_UPDATE_DATE,
              l_rgpv_rec.LAST_UPDATE_LOGIN;
Line: 386

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            OBJECT1_ID1,
            OBJECT2_ID1,
            OBJECT3_ID1,
            OBJECT1_ID2,
            OBJECT2_ID2,
            OBJECT3_ID2,
            JTOT_OBJECT1_CODE,
            JTOT_OBJECT2_CODE,
            JTOT_OBJECT3_CODE,
            DNZ_CHR_ID,
            RGP_ID,
            PRIORITY,
            STD_TEMPLATE_YN,
            COMMENTS,
            WARN_YN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            --TEXT,
            RULE_INFORMATION_CATEGORY,
            RULE_INFORMATION1,
            RULE_INFORMATION2,
            RULE_INFORMATION3,
            RULE_INFORMATION4,
            RULE_INFORMATION5,
            RULE_INFORMATION6,
            RULE_INFORMATION7,
            RULE_INFORMATION8,
            RULE_INFORMATION9,
            RULE_INFORMATION10,
            RULE_INFORMATION11,
            RULE_INFORMATION12,
            RULE_INFORMATION13,
            RULE_INFORMATION14,
            RULE_INFORMATION15,
            TEMPLATE_YN,
            ans_set_jtot_object_code,
            ans_set_jtot_object_id1,
            ans_set_jtot_object_id2,
            DISPLAY_SEQUENCE
     FROM Okc_Rules_V
     WHERE okc_rules_v.rgp_id    = p_rgp_id
     AND   RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
Line: 496

              l_rulv_rec.LAST_UPDATED_BY,
              l_rulv_rec.LAST_UPDATE_DATE,
              l_rulv_rec.LAST_UPDATE_LOGIN,
              --l_rulv_rec.TEXT,
              l_rulv_rec.RULE_INFORMATION_CATEGORY,
              l_rulv_rec.RULE_INFORMATION1,
              l_rulv_rec.RULE_INFORMATION2,
              l_rulv_rec.RULE_INFORMATION3,
              l_rulv_rec.RULE_INFORMATION4,
              l_rulv_rec.RULE_INFORMATION5,
              l_rulv_rec.RULE_INFORMATION6,
              l_rulv_rec.RULE_INFORMATION7,
              l_rulv_rec.RULE_INFORMATION8,
              l_rulv_rec.RULE_INFORMATION9,
              l_rulv_rec.RULE_INFORMATION10,
              l_rulv_rec.RULE_INFORMATION11,
              l_rulv_rec.RULE_INFORMATION12,
              l_rulv_rec.RULE_INFORMATION13,
              l_rulv_rec.RULE_INFORMATION14,
              l_rulv_rec.RULE_INFORMATION15,
              l_rulv_rec.TEMPLATE_YN,
              l_rulv_rec.ans_set_jtot_object_code,
              l_rulv_rec.ans_set_jtot_object_id1,
              l_rulv_rec.ans_set_jtot_object_id2,
              l_rulv_rec.DISPLAY_SEQUENCE ;
Line: 598

                                x_select         OUT NOCOPY VARCHAR2) is

Cursor rule_dff_cur is
--  select dflex.descriptive_flex_context_code
--  ,      dflex.flex_value_set_id
--  from  fnd_descr_flex_col_usage_vl dflex
--  where  dflex.application_id=510
--  and   dflex.descriptive_flexfield_name='OKC Rule Developer DF'
--  and   dflex.descriptive_flex_context_code = p_rdf_code
--  and   dflex.application_column_name = p_appl_col_name
--code added for rule striping (remove top union when finalized)
--union
  select dflex.descriptive_flex_context_code
  ,      dflex.flex_value_set_id
  from  fnd_descr_flex_col_usage_vl dflex,
        okc_rule_defs_v             rdefv
  where  dflex.application_id               = rdefv.application_id
  and   dflex.descriptive_flexfield_name    = rdefv.descriptive_flexfield_name
  and   dflex.descriptive_flex_context_code = rdefv.rule_code
  and   dflex.application_column_name       = p_appl_col_name
  and   rdefv.rule_code                     = p_rdf_code
  order by dflex.descriptive_flex_context_code;
Line: 626

   Select validation_type
   from   fnd_flex_value_sets
   where  flex_value_set_id = p_flex_value_set_id;
Line: 632

     SELECT fvt.id_column_name,
            fvt.value_column_name,
            fvt.meaning_column_name,
            fvt.application_table_name,
            fvt.additional_where_clause,
            fvt.enabled_column_name,
            fvt.start_date_column_name,
            fvt.end_date_column_name
     FROM   fnd_flex_validation_tables fvt
     WHERE  fvt.flex_value_set_id = p_flex_value_set_id;
Line: 655

l_select_clause          varchar2(2000) default null;
Line: 704

            fnd_flex_val_api.get_independent_vset_select(p_value_set_id          => rule_dff_rec.flex_value_set_id,
                                                         p_inc_id_col            => 'N',
                                                         p_inc_user_where_clause => l_inc_user_where_clause,
                                                         p_user_where_clause     => l_user_where_clause,
                                                         x_select                => l_query_string,
                                                         x_mapping_code          => l_mapping_code,
                                                         x_success               => l_success);
Line: 716

          fnd_flex_val_api.get_dependent_vset_select(  p_value_set_id          => rule_dff_rec.flex_value_set_id,
                                                       p_inc_id_col            => 'N',
                                                       p_inc_user_where_clause => l_inc_user_where_clause,
                                                       p_user_where_clause     => l_user_where_clause,
                                                       x_select                => l_query_string,
                                                       x_mapping_code          => l_mapping_code,
                                                       x_success               => l_success);
Line: 738

                      l_select_clause := ' SELECT '||l_select_clause||' '||flex_query_t_rec.value_column_name||' , ';
Line: 740

                      l_select_clause := ' SELECT '||l_select_clause||' '||flex_query_t_rec.id_column_name||' , ';
Line: 743

                   l_select_clause := l_select_clause||' '||flex_query_t_rec.value_column_name;
Line: 762

                      select l_where_clause||' '||decode(l_where_clause,null,' ',decode(instr(ltrim(flex_query_t_rec.additional_where_clause,' '),'ORDER BY'),1,' ',' AND '))||flex_query_t_rec.additional_where_clause
                      into   l_add_where_clause from dual;
Line: 766

                   l_query_string          := rtrim(ltrim(l_select_clause,' '),' ')||' '||
                                              rtrim(ltrim(l_from_clause,' '),' ')||' '||
                                              rtrim(ltrim(l_where_clause,' '),' ')||' '||
                                              rtrim(ltrim(l_order_by_clause,' '),' ');
Line: 794

        x_select := l_query_string;
Line: 852

                          x_select          OUT NOCOPY VARCHAR2) is

  l_return_status		      VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 858

  l_select_clause             Varchar2(2000) default Null;
Line: 866

  Select job.from_table from_table,
         ' FROM '||job.from_table from_clause,
         decode(where_clause,null,null,' WHERE ')||job.where_clause where_clause,
         decode(order_by_clause,null,null,' ORDER BY ')||job.order_by_clause order_by_clause
  From   jtf_objects_vl job
  Where  job.object_code = p_object_code
  And    nvl(job.start_date_active,sysdate) <= sysdate
  And    nvl(job.end_date_active,sysdate+1) > sysdate;
Line: 876

  Select 'Y'
  From   dba_tab_columns
  Where  table_name =  p_table_name
  And    column_name = p_col_name
  -----------------
  --Bug# 3431854 :
  -----------------
  And    owner      = USER;
Line: 923

      l_select_clause := 'SELECT ID1,ID2,NAME,DESCRIPTION';
Line: 956

                       l_select_clause := l_select_clause||','||'null';
Line: 958

                       l_select_clause := l_select_clause||','||'to_number(null)';
Line: 961

                   l_select_clause := l_select_clause||','||l_col_name;
Line: 980

       l_query_string := ltrim(rtrim(l_select_clause,' '),' ')||' '||
                         ltrim(rtrim(l_from_clause,' '),' ')||' '||
                         ltrim(rtrim(l_where_clause,' '),' ')||' '||
                         ltrim(rtrim(l_order_by_clause,' '),' ');
Line: 985

       x_select := l_query_string;
Line: 1065

l_select        Varchar2(2000) default null;
Line: 1098

      l_select := null;
Line: 1118

                      x_select         => l_select);
Line: 1133

         l_rulv_disp_rec.obj1_select         := l_select;
Line: 1148

      l_select := null;
Line: 1168

                      x_select         => l_select);
Line: 1184

         l_rulv_disp_rec.obj2_select         := l_select;
Line: 1199

      l_select := null;
Line: 1219

                      x_select         => l_select);
Line: 1235

         l_rulv_disp_rec.obj3_select         := l_select;
Line: 1248

        l_select := null;
Line: 1253

         l_select := null;
Line: 1263

                                x_select         => l_select);
Line: 1271

         l_rulv_disp_rec.rul_info1_select := l_select;
Line: 1276

         l_select := null;
Line: 1286

                                x_select         => l_select);
Line: 1294

         l_rulv_disp_rec.rul_info2_select := l_select;
Line: 1299

         l_select := null;
Line: 1309

                                x_select         => l_select);
Line: 1317

         l_rulv_disp_rec.rul_info3_select := l_select;
Line: 1321

         l_select := null;
Line: 1331

                                x_select         => l_select);
Line: 1339

         l_rulv_disp_rec.rul_info4_select := l_select;
Line: 1343

         l_select := null;
Line: 1353

                                x_select         => l_select);
Line: 1361

         l_rulv_disp_rec.rul_info5_select := l_select;
Line: 1365

         l_select := null;
Line: 1375

                                x_select         => l_select);
Line: 1383

         l_rulv_disp_rec.rul_info6_select := l_select;
Line: 1387

         l_select := null;
Line: 1397

                                x_select         => l_select);
Line: 1405

         l_rulv_disp_rec.rul_info7_select := l_select;
Line: 1409

         l_select := null;
Line: 1419

                                x_select         => l_select);
Line: 1427

         l_rulv_disp_rec.rul_info8_select := l_select;
Line: 1431

         l_select := null;
Line: 1441

                                x_select         => l_select);
Line: 1449

         l_rulv_disp_rec.rul_info9_select := l_select;
Line: 1453

         l_select := null;
Line: 1463

                                x_select         => l_select);
Line: 1471

         l_rulv_disp_rec.rul_info10_select := l_select;
Line: 1475

         l_select := null;
Line: 1485

                                x_select         => l_select);
Line: 1493

         l_rulv_disp_rec.rul_info11_select := l_select;
Line: 1497

         l_select := null;
Line: 1507

                                x_select         => l_select);
Line: 1515

         l_rulv_disp_rec.rul_info12_select := l_select;
Line: 1520

         l_select := null;
Line: 1530

                                x_select         => l_select);
Line: 1538

         l_rulv_disp_rec.rul_info13_select := l_select;
Line: 1542

         l_select := null;
Line: 1552

                                x_select         => l_select);
Line: 1560

         l_rulv_disp_rec.rul_info14_select := l_select;
Line: 1564

         l_select := null;
Line: 1574

                                x_select         => l_select);
Line: 1582

         l_rulv_disp_rec.rul_info15_select := l_select;
Line: 1645

                                 x_select          OUT NOCOPY VARCHAR2) is

    l_return_status		           VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 1669

    Select dflex.descriptive_flex_context_code
    ,      dflex.application_column_name
    from   fnd_descr_flex_col_usage_vl dflex,
           okc_rule_defs_v             rdefv
    where  dflex.application_id                = rdefv.application_id
    and    dflex.descriptive_flexfield_name    = rdefv.descriptive_flexfield_name
    and    dflex.descriptive_flex_context_code = rdefv.rule_code
    and    dflex.form_left_prompt              = p_rdf_name
    and    rdefv.rule_code                     = p_rdf_code
--    order by 1;
Line: 1765

                                  x_select         => x_select);
Line: 1777

                                  x_select         => x_select);
Line: 1789

                                  x_select         => x_select);
Line: 1801

                                  x_select         => x_select);
Line: 1813

                                  x_select         => x_select);
Line: 1825

                                  x_select         => x_select);
Line: 1837

                                  x_select         => x_select);
Line: 1849

                                  x_select         => x_select);
Line: 1861

                                  x_select         => x_select);
Line: 1873

                                  x_select         => x_select);
Line: 1885

                                  x_select         => x_select);
Line: 1897

                                  x_select         => x_select);
Line: 1909

                                  x_select         => x_select);
Line: 1921

                                  x_select         => x_select);
Line: 1933

                                  x_select         => x_select);
Line: 1954

                             x_select         => x_select);
Line: 1975

                             x_select         => x_select);
Line: 1996

                             x_select         => x_select);
Line: 2067

                                 x_select          OUT NOCOPY VARCHAR2) is

    l_return_status		           VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
Line: 2153

                                  x_select         => x_select);
Line: 2165

                                  x_select         => x_select);
Line: 2177

                                  x_select         => x_select);
Line: 2189

                                  x_select         => x_select);
Line: 2201

                                  x_select         => x_select);
Line: 2213

                                  x_select         => x_select);
Line: 2225

                                  x_select         => x_select);
Line: 2237

                                  x_select         => x_select);
Line: 2249

                                  x_select         => x_select);
Line: 2261

                                  x_select         => x_select);
Line: 2273

                                  x_select         => x_select);
Line: 2285

                                  x_select         => x_select);
Line: 2297

                                  x_select         => x_select);
Line: 2309

                                  x_select         => x_select);
Line: 2321

                                  x_select         => x_select);
Line: 2342

                             x_select         => x_select);
Line: 2363

                             x_select         => x_select);
Line: 2384

                             x_select         => x_select);