APPS.CS_CTX_PKG SQL Statements

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

Line: 88

      string := 'Select unique pa.pat_value From ctxsys.dr$preference_attribute
	 pa, ctxsys.dr$preference pr, ctxsys.dr$policy po,
	 ctxsys.dr$preference_usage pu Where pa.pat_name = ''STOP_WORD''
	 AND pa.pat_pre_id = pu.pus_pre_id AND pu.pus_pol_id = po.pol_id
	 AND po.pol_name in (' || policies || ')' ;

Line: 221

     Update_Context_Index: Reindex a policy for the given key.
  ***********************************************************************/

  PROCEDURE Update_Context_Index(policy_name IN VARCHAR2,
                                 primary_key IN VARCHAR2)
  IS
      cursor_name INTEGER;

Line: 243

  END; -- update_context_index.

Line: 266

      dbms_sql.parse(cursor_name,'DELETE FROM '||results_table||' WHERE conid IN (:c1,:c2,:c3,:c4)',dbms_sql.v7);

Line: 308

      dbms_sql.parse(cursor_name,'SELECT CS_INCIDENTS_CTX_S.nextval FROM DUAL', dbms_sql.v7);

Line: 317

	  SELECT cs_incidents_ctx_s.nextval
	  INTO conid1
	  FROM dual;

Line: 325

	  SELECT cs_incidents_ctx_s.nextval
	  INTO conid2
	  FROM dual;

Line: 331

	  SELECT cs_incidents_ctx_s.nextval
	  INTO conid3
	  FROM dual;

Line: 337

	  SELECT cs_incidents_ctx_s.nextval
	  INTO conid4
	  FROM dual;