APPS.CN_SCA_RULES_BATCH_GEN_PVT SQL Statements

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

Line: 41

FUNCTION search_delimiter_select(
   p_input_str 		varchar2,
   p_start 		number)
  RETURN  number IS
     l_position_min         NUMBER ;

Line: 133

         IF sql_type = 'SELECT' THEN
            l_next := search_delimiter_select(p_input_str, l_next_prev+1 );

Line: 192

   SELECT COUNT(1)
     INTO dummy
     FROM cn_objects
    WHERE name = x_name
      AND object_type = x_object_type;

Line: 201

      cn_objects_pkg.insert_row( x_rowid                   => x_rowid,
                                 x_object_id               => x_object_id,
                                 x_org_id                  => g_org_id,
                                 x_dependency_map_complete => 'N',
                                 x_name                    => x_name,
                                 x_description             => null,
                                 x_object_type             => x_object_type,
                                 x_repository_id           => X_repository_id,
                                 x_next_synchronization_date => null,
                                 x_synchronization_frequency => null,
                                 x_object_status           => 'A',
                                 x_object_value            => NULL );

Line: 215

      SELECT object_id
        INTO x_object_id
        FROM cn_objects
       WHERE name = x_name
         AND object_type = x_object_type;

Line: 237

	SELECT  user
	INTO    x_userid
	FROM    sys.dual;

Line: 287

	-- Delete module source code from cn_source
	-- Delete module object dependencies for this module
	cn_utils.delete_module(module_id, package_spec_id, package_body_id, g_org_id);

Line: 309

   SELECT user INTO X_userid FROM sys.dual;

Line: 390

   SELECT distinct rule_attr_comb_value
     FROM cn_sca_combinations sc
     WHERE transaction_source = x_transaction_source
     AND   org_id = g_org_id; -- vensrini

Line: 396

   SELECT ra.sca_rule_attribute_id,
          ra.src_column_name,
	  ra.datatype
     FROM cn_sca_combinations sc,
          cn_sca_rule_attributes ra
     WHERE sc.sca_rule_attribute_id = ra.sca_rule_attribute_id
     AND sc.org_id = ra.org_id --vensrini
     AND sc.org_id = g_org_id -- vensrini
      AND rule_attr_comb_value = l_comb_value
      AND sc.transaction_source = x_transaction_source
	order by sc.sca_rule_attribute_id;

Line: 409

   SELECT lookup_code,meaning
     FROM cn_lookups cl
    WHERE lookup_type = 'SCA_OPERATORS'
      AND EXISTS (
          SELECT 'S'
            FROM cn_sca_conditions csc,
	         cn_sca_cond_details cscd
           WHERE csc.sca_condition_id = cscd.sca_condition_id
             AND csc.org_id = cscd.org_id -- vensrini
             AND csc.org_id = g_org_id   -- vensrini
	     AND cscd.OPERATOR_ID =  cl.lookup_code
	     AND csc.sca_rule_attribute_id = l_attribute_id);

Line: 457

   cn_utils.appendcr(body_code, '      SELECT DISTINCT rule_attr_comb_value ');

Line: 491

      cn_utils.appendcr(body_code, 'INSERT /*+ APPEND */ INTO cn_sca_matches(');

Line: 500

      cn_utils.appendcr(body_code, '       last_updated_by,');

Line: 501

      cn_utils.appendcr(body_code, '       last_update_date,');

Line: 502

      cn_utils.appendcr(body_code, '       last_update_login)');

Line: 503

      cn_utils.appendcr(body_code, 'SELECT result.sca_credit_rule_id,');

Line: 524

         cn_utils.appendcr(body_code, '       SELECT b.sca_credit_rule_id, ');

Line: 545

         cn_utils.appendcr(body_code, '              SELECT DISTINCT sca_rule_attribute_id ');

Line: 546

	 cn_utils.appendcr(body_code, '                FROM ( SELECT a.*, rownum rnum ');

Line: 547

	 cn_utils.appendcr(body_code, '                         FROM ( SELECT sca_rule_attribute_id ');

Line: 662

      cn_utils.appendcr(body_code, '	SELECT r.sca_credit_rule_id,r.num_rule_attributes ');

Line: 706

	select repository_id into l_repository_id
	from cn_repositories where org_id = g_org_id;

Line: 809

         SELECT co.object_id
           INTO l_pkg_object_id
           FROM cn_objects co
           WHERE co.name =  l_pkg_name
           AND co.object_type = 'PKS'
	   AND co.org_id = g_org_id;

Line: 816

         SELECT cs.text bulk collect INTO sqlstring
           FROM cn_source cs
           WHERE cs.object_id = l_pkg_object_id
           AND cs.org_id = g_org_id
           ORDER BY cs.line_no ;

Line: 834

         SELECT co.object_id
           INTO l_pkg_object_id
           FROM cn_objects co
           WHERE co.name =  l_pkg_name
           AND co.object_type = 'PKB'
	   AND co.org_id = g_org_id;

Line: 843

         SELECT cs.text bulk collect INTO sqlstring
           FROM cn_source cs
           WHERE cs.object_id = l_pkg_object_id
           AND cs.org_id = g_org_id
           ORDER BY cs.line_no ;

Line: 862

         SELECT  COUNT(*)
           INTO  l_error_count
           FROM user_errors
           WHERE name = upper(l_pkg_name)
           AND  TYPE IN ('PACKAGE', 'PACKAGE BODY');