APPS.OKS_UTIL_PUB SQL Statements

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

Line: 171

      SELECT application_id
      FROM   fnd_application
      WHERE  application_short_name = app_short_name;

Line: 358

    v_selectstmt   VARCHAR2(500) ;

Line: 408

       v_selectstmt := 'SELECT  '||v_cols||' FROM  '||p_table_r.table_name||' '||v_where_clause;

Line: 410

	  oe_debug_pub.add('select stmt'||v_selectstmt);

Line: 417

       v_selectstmt := 'SELECT  '||p_table_r.id_column_name||' FROM  '||p_table_r.table_name||' '||v_where_clause;

Line: 421

     v_selectstmt := 'SELECT  '||p_table_r.value_column_name||' FROM  '||p_table_r.table_name||' '||p_table_r.where_clause;

Line: 428

     DBMS_SQL.PARSE(v_cursor_id,v_selectstmt,DBMS_SQL.V7);

Line: 507

PROCEDURE UPDATE_CONTACTS_SALESGROUP
   ( ERRBUF            OUT      NOCOPY VARCHAR2,
     RETCODE           OUT      NOCOPY NUMBER,
     P_CONTRACT_ID     IN              NUMBER,
     P_GROUP_ID        IN              NUMBER)
   IS
--

  ---------------------------
  -- cursors to select contracts for given contract number
  -- and group
  ---------------------------
  --CP_CONTRACT_ID is not null
  --cp_group_id is not null
  CURSOR CONTRACT_HDR_1(cp_contract_id NUMBER
                       ,cp_group_id NUMBER)
  IS
  SELECT  hdr.id hdr_id, authoring_org_id org_id
  FROM    okc_k_headers_b hdr
  WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
  AND   Hdr.Template_yn = 'N'
  AND   exists (Select 'x' from OKC_K_GRPINGS  okg
              Where  okg.included_chr_id = hdr.id
              And    okg.cgp_parent_id= cp_group_id)
  AND   Hdr.id = CP_CONTRACT_ID;

Line: 538

  SELECT  hdr.id hdr_id, authoring_org_id org_id
  FROM    okc_k_headers_b hdr
  WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
  AND   Hdr.Template_yn = 'N'
  AND   Hdr.id = CP_CONTRACT_ID;

Line: 549

  SELECT  hdr.id hdr_id, authoring_org_id org_id
  FROM    okc_k_headers_b hdr
  WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
  AND   Hdr.Template_yn = 'N'
  AND   exists (Select 'x' from OKC_K_GRPINGS  okg
              Where  okg.included_chr_id = hdr.id
              And    okg.cgp_parent_id= cp_group_id);

Line: 562

  SELECT  /*+ PARALLEL(HDR) */ hdr.id hdr_id, authoring_org_id org_id
  FROM    okc_k_headers_b HDR
  WHERE Hdr.scs_code in ('SERVICE', 'WARRANTY','SUBSCRIPTION')
  AND   Hdr.Template_yn =  'N';

Line: 572

  SELECT id , object1_id1 ,object1_id2, cpl_id, cro_code , start_date, last_update_date
  FROM  OKC_CONTACTS
  WHERE dnz_chr_id = cp_contract_id
  AND   jtot_object1_code   = 'OKX_SALEPERS'
 -- and cro_code = 'SALESPERSON' -- changed for bug#3564073
  AND   sales_group_id IS NULL;

Line: 641

                            			      p_date        => nvl(contacts_rec.start_date,contacts_rec.last_update_date)); -- sysdate replaced for DBI change request.

Line: 654

        okc_contract_party_pub.update_contact (
              p_api_version => l_api_version,
              p_init_msg_list => l_init_msg_list,
              x_return_status => l_return_status,
              x_msg_count => l_msg_count,
              x_msg_data => l_msg_data,
              p_ctcv_tbl => l_ctcv_tbl_in,
              x_ctcv_tbl => l_ctcv_tbl_out );

Line: 702

END update_contacts_salesgroup; -- Procedure

Line: 729

    SELECT concatenated_segments name
    FROM mtl_system_items_b_kfv
    WHERE inventory_item_id = to_number(p_object1_id1)
      and organization_id = to_number(p_object1_id2);

Line: 736

    SELECT concatenated_segments name
    FROM mtl_system_items_b_kfv mtl,
         csi_item_instances csi
    WHERE mtl.inventory_item_id = csi.inventory_item_id
      AND mtl.organization_id = csi.inv_master_organization_id
      AND csi.instance_id = to_number(p_object1_id1);

Line: 745

    SELECT party_name name
    FROM hz_parties
    WHERE party_id = to_number(p_object1_id1);

Line: 751

    SELECT party_site_number||'-'||party_site_name name
    FROM hz_party_sites p
    WHERE party_site_id = to_number(p_object1_id1);

Line: 757

    SELECT name
    FROM csi_systems_tl csi
    WHERE csi.system_id = to_number(p_object1_id1)
      AND csi.language = USERENV('LANG');

Line: 764

    SELECT NVL(ca.account_name, p.party_name) name
    FROM hz_cust_accounts ca,
         hz_parties p
    WHERE ca.party_id = p.party_id
      AND ca.cust_account_id = to_number(p_object1_id1);

Line: 772

    SELECT source_object_code, source_object_id
    FROM csi_counter_associations csi
    WHERE csi.counter_id = to_number(p_object1_id1);

Line: 777

    SELECT concatenated_segments name
    FROM mtl_system_items_b_kfv mtl,
         csi_item_instances csi
    WHERE mtl.inventory_item_id = csi.inventory_item_id
      AND mtl.organization_id = csi.inv_master_organization_id
      AND csi.instance_id = p_instance_id;

Line: 785

    SELECT concatenated_segments name
    FROM mtl_system_items_b_kfv mtl,
         okc_k_items item
    WHERE mtl.inventory_item_id = to_number(item.object1_id1)
      AND mtl.organization_id = to_number(item.object1_id2)
      AND item.cle_id = p_line_id;

Line: 839

    SELECT lse.lty_code, item.object1_id1, item.object1_id2
    FROM okc_k_lines_b sle, okc_k_items item, okc_line_styles_b lse
    WHERE item.cle_id = sle.id
      AND lse.id = sle.lse_id
      AND sle.id = p_subline_id;

Line: 897

select
 cas.cust_account_id Cust_Account_ID
,ca.party_id Party_ID
from
 hz_cust_site_uses_all csu
,hz_cust_acct_sites_all cas
,hz_cust_accounts_all ca
where
csu.site_use_id = P_Bill_To_Site_Use_ID
and cas.cust_acct_site_id = csu.cust_acct_site_id
and ca.cust_account_id = cas.cust_account_id;

Line: 910

select
 ca.party_id Party_ID
from
 hz_cust_accounts_all ca
where ca.cust_account_id = P_Cust_Acct_ID;

Line: 918

select
 instr_assignment_ID
/* Modified by cgopinee for PA DSS Enhancement */
/*,CARD_EXPIRYDATE */
 , card_expired_flag
from
IBY_TRXN_EXTENSIONS_V
where
trxn_extension_ID = P_Source_Trx_Ext_ID;

Line: 934

    l_ext_entity_tab.DELETE;