APPS.OKL_JTOT_CONTACT_EXTRACT_PUB SQL Statements

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

Line: 19

  SELECT prv.id1,
         prv.id2,
         prv.name,
         prv.description
  FROM  okx_parties_v prv
  WHERE prv.name = NVL(p_name,prv.name)
  AND   prv.id1  = p_id1
  AND   prv.id2  = NVL(p_id2,prv.id2)
  ORDER BY prv.name;

Line: 31

  SELECT ord.id1,
         ord.id2,
         ord.name,
         ord.description
  FROM  okx_organization_defs_v ord
  WHERE ord.organization_type = 'OPERATING_UNIT'
  AND   ord.information_type = 'Operating Unit Information'
  AND   ord.name = NVL(p_name,ord.name)
  AND   ord.id1  = NVL(p_id1,ord.id1)
  AND   ord.id2  = NVL(p_id2,ord.id2)
  ORDER BY ord.NAME;

Line: 46

  SELECT  vev.id1,
          vev.id2,
          vev.name,
          vev.description
  FROM okx_vendors_v vev
  WHERE vev.name = NVL(p_name,vev.name)
  AND   vev.id1  = NVL(p_id1,vev.id1)
  AND   vev.id2  = NVL(p_id2,vev.id2)
  ORDER BY vev.NAME;

Line: 62

	    select a.attribute_label_long
	 from ak_region_items ri, ak_regions r, ak_attributes_vl a
	 where ri.region_code = r.region_code
	 and ri.region_application_id = r.region_application_id
	 and ri.attribute_code = a.attribute_code
	 and ri.attribute_application_id = a.attribute_application_id
	 and ri.region_code  =  p_ak_region
	 and ri.attribute_code = p_ak_attribute
	--end modified abhsaxen for performance SQLID 20562543
	;

Line: 85

    	select fnd.meaning
    	from   okc_subclass_roles sur,
               okc_k_headers_b    chr,
               fnd_lookup_values  fnd
    	where  fnd.lookup_code = sur.rle_code
    	and    sur.rle_code  = p_rle_code
    	and    fnd.lookup_type = 'OKC_ROLE'
    	and    fnd.language = userenv('LANG')
    	and    sur.scs_code = chr.scs_code
    	and    chr.id = p_chr_id
    	and    nvl(sur.start_date,sysdate) <= sysdate
    	and    nvl(sur.end_date,sysdate+1) > sysdate;

Line: 121

                     x_select_clause       OUT NOCOPY  VARCHAR2,
                     x_from_clause         OUT NOCOPY  VARCHAR2,
                     x_where_clause        OUT NOCOPY  VARCHAR2,
                     x_order_by_clause     OUT NOCOPY  VARCHAR2,
                     x_object_code         OUT NOCOPY  VARCHAR2) is
CURSOR  jtf_party_role_cur (p_role_code VARCHAR2, p_intent VARCHAR2) is
        select job.object_code OBJECT_CODE,
               job.object_code||'.ID1, '||
               job.object_code||'.ID2, '||
               job.object_code||'.NAME, '||
                       job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
               from_table FROM_CLAUSE,
               where_clause WHERE_CLAUSE,
               order_by_clause ORDER_BY_CLAUSE
       from    jtf_objects_b job,
               okc_role_sources rs
       where   job.object_code = rs.jtot_object_code
       and     nvl(job.start_date_active,sysdate) <= sysdate
       and     nvl(job.end_date_active,sysdate + 1) > sysdate
       and     rs.rle_code     = p_role_code
       and     rs.start_date <= sysdate
       and     nvl(rs.end_date,sysdate+1) > sysdate
       and     rs.buy_or_sell = p_intent;

Line: 153

             x_select_clause   := 'NOT FOUND';

Line: 159

             x_select_clause   := jtf_party_role_rec.select_clause;

Line: 164

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
                into   l_where_clause
                from   dual;

Line: 170

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' NAME like '||''''||p_name||'%'||''''
                into   l_where_clause
                from   dual;

Line: 200

       select object1_id1,
              object1_id2,
              jtot_object1_code,
              rle_code
       from   OKC_K_PARTY_ROLES_V
       where  rle_code = nvl(p_role_code,rle_code)
       and    nvl(cle_id,-99999)   = p_cle_id
       and    nvl(chr_id,-99999)   = p_chr_id
       and    dnz_chr_id           = decode(p_chr_id,null,dnz_chr_id,p_dnz_chr_id)
       order  by rle_code;

Line: 211

l_select_clause     varchar2(2000) default null;

Line: 371

                 x_select_clause   => l_select_clause,
                 x_from_clause     => l_from_clause ,
                 x_where_clause    => l_where_clause,
                 x_order_by_clause => l_order_by_clause,
                 x_object_code     => l_object_code);

Line: 376

          l_query_string := 'SELECT '||ltrim(rtrim(l_select_clause,' '),' ')||' '||
                        'FROM '||ltrim(rtrim(l_from_clause,' '),' ')||' '||
                        'WHERE '||ltrim(rtrim(l_where_clause,' '),' ')||' '||
                        'ORDER BY '||ltrim(rtrim(l_order_by_clause,' '),' ');

Line: 427

l_select_clause     varchar2(2000) default null;

Line: 554

                 x_select_clause   => l_select_clause,
                 x_from_clause     => l_from_clause ,
                 x_where_clause    => l_where_clause,
                 x_order_by_clause => l_order_by_clause,
                 x_object_code     => l_object_code);

Line: 559

          l_query_string := 'SELECT '||ltrim(rtrim(l_select_clause,' '),' ')||' '||
                        'FROM '||ltrim(rtrim(l_from_clause,' '),' ')||' '||
                        'WHERE '||ltrim(rtrim(l_where_clause,' '),' ')||' '||
                        'ORDER BY '||ltrim(rtrim(l_order_by_clause,' '),' ');

Line: 598

                      x_select_clause       OUT NOCOPY VARCHAR2,
                      x_from_clause         OUT NOCOPY VARCHAR2,
                      x_where_clause        OUT NOCOPY VARCHAR2,
                      x_order_by_clause     OUT NOCOPY VARCHAR2,
                      x_object_code         OUT NOCOPY VARCHAR2) is
CURSOR jtf_contacts_cur(p_contact_code VARCHAR2, p_role_code VARCHAR2, p_intent VARCHAR2) is
       select job.object_code OBJECT_CODE,
              job.object_code||'.ID1, '||
              job.object_code||'.ID2, '||
              job.object_code||'.NAME, '||
		      job.object_code||'.DESCRIPTION ' SELECT_CLAUSE,
              from_table FROM_CLAUSE,
              where_clause WHERE_CLAUSE,
              order_by_clause ORDER_BY_CLAUSE
       from   jtf_objects_b job,
              okc_contact_sources cs
       where  job.object_code = cs.jtot_object_code
       and     nvl(job.start_date_active,sysdate) <= sysdate
       and     nvl(job.end_date_active,sysdate + 1) > sysdate
       and    cs.cro_code = p_contact_code
       and    cs.rle_code = p_role_code
       and    cs.start_date <= sysdate
       and    nvl(cs.end_date,sysdate+1) > sysdate
       and    cs.buy_or_sell = p_intent;

Line: 637

             x_select_clause   := 'NOT FOUND';

Line: 643

             x_select_clause   := jtf_contacts_rec.select_clause;

Line: 648

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' ID1 = '||''''||p_id1||''''||' AND '||' ID2 = '||''''||p_id2||''''
                into   l_where_clause
                from   dual;

Line: 654

                select x_where_clause || decode(x_where_clause,null,null,' AND ')||
                       ' NAME = '||''''||p_name||''''
                into   l_where_clause
                from   dual;

Line: 660

             select ' SELECT count(*) rec_count'||
                    ' FROM '||x_from_clause||
                    decode(x_where_clause,null,' ',' WHERE ')||x_where_clause||
                    decode(x_order_by_clause,null,null,' ORDER BY ')||x_order_by_clause
             into   l_query_string from dual;

Line: 802

l_select_clause     varchar2(2000) default null;

Line: 839

	   select count(1)
	from okc_k_party_roles_b
	where dnz_chr_id = p_chr_id
	and chr_id = p_chr_id
	and rle_code = p_rle_code
	and object1_id1 = p_id1
	and object1_id2 = p_id2
	--end modified abhsaxen for performance SQLID 20562561
	;

Line: 849

SELECT rle_code, object1_id1, object1_id2
FROM okc_k_party_roles_v
WHERE id = p_cpl_id;

Line: 916

      			        p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 930

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 939

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 971

      			          p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1003

      			        p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1017

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1026

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1048

      			          p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1081

      			        p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1095

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1104

      			         p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1126

      			          p_token1_value => l_amt_ak_prompt); --please_select_a_value_from_lov

Line: 1146

  	                  p_msg_name => 'OKL_LLA_DUP_SELECTION',
      			  p_token1 => 'TOKEN',
      			  p_token1_value => l_amt_ak_prompt); --Party_name_already_exists

Line: 1163

  	                  p_msg_name => 'OKL_LLA_DUP_SELECTION',
      			  p_token1 => 'TOKEN',
      			  p_token1_value => l_amt_ak_prompt); --Party_name_already_exists

Line: 1238

  Procedure Delete_Party (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_chr_id       	   IN	NUMBER,
                     p_cpl_id       	   IN	NUMBER
                     ) AS

   l_api_name	         VARCHAR2(30) := 'Validate_Party';

Line: 1276

   select object1_id1,rle_code from okc_k_party_roles_v
   where id = p_cpl_id;

Line: 1283

   select count(*)   from okx_vendor_sites_v
   where exists (select 1 from okl_trx_ap_invoices_b a
                              ,okl_txl_ap_inv_lns_all_b b
              where a.id = b.tap_id
                and a.ipvs_id = okx_vendor_sites_v.id1
                and b.khr_id = p_chr_id)
   and vendor_id = p_id1;

Line: 1293

	    select count(*)
	   from okc_k_party_roles_b
	   where chr_id is null
	   and cle_id is not null
	   and rle_code = 'OKL_VENDOR'
	   and dnz_chr_id = p_chr_id
	   and object1_id1 = p_id1
	--end modified abhsaxen for performance SQLID 20562568
	;

Line: 1303

   select rgpr.id ,rgpr.rgp_id
   from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp
   where rgpr.dnz_chr_id = p_chr_id
   and rgpr.cpl_id = p_cpl_id
   and rgpr.dnz_chr_id = rgp.dnz_chr_id
   and rgpr.dnz_chr_id = rgp.chr_id
   and rgpr.rgp_id = rgp.id;

Line: 1312

   select rul.id
   from okc_rg_party_roles_v rgpr, okc_rule_groups_v rgp, okc_rules_v rul
   where rgpr.dnz_chr_id = p_chr_id
   and rgpr.cpl_id = p_cpl_id
   and rgpr.dnz_chr_id = rgp.dnz_chr_id
   and rgpr.dnz_chr_id = rgp.chr_id
   and rgpr.dnz_chr_id = rul.dnz_chr_id
   and rgpr.rgp_id = rgp.id
   and rgp.id = rul.rgp_id;

Line: 1414

			     , p_msg_name => 'OKL_LLA_DELETE_PARTY1'
                             , p_token1 => 'COL_NAME'
                             , p_token1_value => l_rle_code_meaning
			   );

Line: 1434

			     , p_msg_name => 'OKL_LLA_DELETE_PARTY'
                             , p_token1 => 'COL_NAME'
                             , p_token1_value => l_rle_code_meaning
			   );

Line: 1449

			     , p_msg_name => 'OKL_LLA_DELETE_PARTY'
                             , p_token1 => 'COL_NAME'
                             , p_token1_value => l_rle_code_meaning
			   );

Line: 1471

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

  OKL_RULE_PUB.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       => lp_rgpv_rec);

Line: 1506

  OKL_RULE_PUB.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       => lp_rmpv_rec);

Line: 1525

  OKL_OKC_MIGRATION_PVT.delete_k_party_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_cplv_rec       => lp_cplv_rec);

Line: 1535

   OKL_K_PARTY_ROLES_PVT.delete_k_party_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_cplv_rec       => lp_cplv_rec,
        p_kplv_rec       => lp_kplv_rec);

Line: 1599

  END Delete_Party;