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

  select 'Y'
    from user_synonyms syn, dba_tab_columns col
   where syn.synonym_name = p_table_name
     and col.owner        = syn.table_owner
     and col.table_name   = syn.table_name
     and col.column_name  = p_col_name
  union
 Select 'Y'
   From user_tab_columns col
  Where col.table_name = p_table_name
    And column_name = p_col_name;
Line: 938

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

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

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

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

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

       x_select := l_query_string;
Line: 1080

l_select        Varchar2(2000) default null;
Line: 1113

      l_select := null;
Line: 1133

                      x_select         => l_select);
Line: 1148

         l_rulv_disp_rec.obj1_select         := l_select;
Line: 1163

      l_select := null;
Line: 1183

                      x_select         => l_select);
Line: 1199

         l_rulv_disp_rec.obj2_select         := l_select;
Line: 1214

      l_select := null;
Line: 1234

                      x_select         => l_select);
Line: 1250

         l_rulv_disp_rec.obj3_select         := l_select;
Line: 1263

        l_select := null;
Line: 1268

         l_select := null;
Line: 1278

                                x_select         => l_select);
Line: 1286

         l_rulv_disp_rec.rul_info1_select := l_select;
Line: 1291

         l_select := null;
Line: 1301

                                x_select         => l_select);
Line: 1309

         l_rulv_disp_rec.rul_info2_select := l_select;
Line: 1314

         l_select := null;
Line: 1324

                                x_select         => l_select);
Line: 1332

         l_rulv_disp_rec.rul_info3_select := l_select;
Line: 1336

         l_select := null;
Line: 1346

                                x_select         => l_select);
Line: 1354

         l_rulv_disp_rec.rul_info4_select := l_select;
Line: 1358

         l_select := null;
Line: 1368

                                x_select         => l_select);
Line: 1376

         l_rulv_disp_rec.rul_info5_select := l_select;
Line: 1380

         l_select := null;
Line: 1390

                                x_select         => l_select);
Line: 1398

         l_rulv_disp_rec.rul_info6_select := l_select;
Line: 1402

         l_select := null;
Line: 1412

                                x_select         => l_select);
Line: 1420

         l_rulv_disp_rec.rul_info7_select := l_select;
Line: 1424

         l_select := null;
Line: 1434

                                x_select         => l_select);
Line: 1442

         l_rulv_disp_rec.rul_info8_select := l_select;
Line: 1446

         l_select := null;
Line: 1456

                                x_select         => l_select);
Line: 1464

         l_rulv_disp_rec.rul_info9_select := l_select;
Line: 1468

         l_select := null;
Line: 1478

                                x_select         => l_select);
Line: 1486

         l_rulv_disp_rec.rul_info10_select := l_select;
Line: 1490

         l_select := null;
Line: 1500

                                x_select         => l_select);
Line: 1508

         l_rulv_disp_rec.rul_info11_select := l_select;
Line: 1512

         l_select := null;
Line: 1522

                                x_select         => l_select);
Line: 1530

         l_rulv_disp_rec.rul_info12_select := l_select;
Line: 1535

         l_select := null;
Line: 1545

                                x_select         => l_select);
Line: 1553

         l_rulv_disp_rec.rul_info13_select := l_select;
Line: 1557

         l_select := null;
Line: 1567

                                x_select         => l_select);
Line: 1575

         l_rulv_disp_rec.rul_info14_select := l_select;
Line: 1579

         l_select := null;
Line: 1589

                                x_select         => l_select);
Line: 1597

         l_rulv_disp_rec.rul_info15_select := l_select;
Line: 1660

                                 x_select          OUT NOCOPY VARCHAR2) is

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

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

                                  x_select         => x_select);
Line: 1792

                                  x_select         => x_select);
Line: 1804

                                  x_select         => x_select);
Line: 1816

                                  x_select         => x_select);
Line: 1828

                                  x_select         => x_select);
Line: 1840

                                  x_select         => x_select);
Line: 1852

                                  x_select         => x_select);
Line: 1864

                                  x_select         => x_select);
Line: 1876

                                  x_select         => x_select);
Line: 1888

                                  x_select         => x_select);
Line: 1900

                                  x_select         => x_select);
Line: 1912

                                  x_select         => x_select);
Line: 1924

                                  x_select         => x_select);
Line: 1936

                                  x_select         => x_select);
Line: 1948

                                  x_select         => x_select);
Line: 1969

                             x_select         => x_select);
Line: 1990

                             x_select         => x_select);
Line: 2011

                             x_select         => x_select);
Line: 2082

                                 x_select          OUT NOCOPY VARCHAR2) is

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

                                  x_select         => x_select);
Line: 2180

                                  x_select         => x_select);
Line: 2192

                                  x_select         => x_select);
Line: 2204

                                  x_select         => x_select);
Line: 2216

                                  x_select         => x_select);
Line: 2228

                                  x_select         => x_select);
Line: 2240

                                  x_select         => x_select);
Line: 2252

                                  x_select         => x_select);
Line: 2264

                                  x_select         => x_select);
Line: 2276

                                  x_select         => x_select);
Line: 2288

                                  x_select         => x_select);
Line: 2300

                                  x_select         => x_select);
Line: 2312

                                  x_select         => x_select);
Line: 2324

                                  x_select         => x_select);
Line: 2336

                                  x_select         => x_select);
Line: 2357

                             x_select         => x_select);
Line: 2378

                             x_select         => x_select);
Line: 2399

                             x_select         => x_select);