APPS.CN_SCA_RULES_ONLINE_GEN_PVT SQL Statements

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

Line: 19

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

Line: 109

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

Line: 167

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

Line: 177

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

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

Line: 210

   SELECT user INTO X_userid FROM sys.dual;

Line: 286

    SELECT *
    FROM   cn_sca_rule_attributes csra
    WHERE  transaction_source = x_transaction_source
    -- codeCheck: This condition is not required when inner has it.
    AND    org_id = g_org_id
--    AND    enabled_flag = 'Y'
    AND EXISTS (SELECT 'S'
                  FROM cn_sca_conditions csc
                 WHERE csc.sca_rule_attribute_id = csra.sca_rule_attribute_id
		   AND csc.org_id = g_org_id)  ;

Line: 298

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

Line: 327

     cn_utils.appendcr(body_code, '''INSERT INTO cn_sca_winning_rules_gtt (sca_batch_id ,       ''||');

Line: 332

     cn_utils.appendcr(body_code, 'SELECT  sca_batch_id,                             ');

Line: 338

     cn_utils.appendcr(body_code, '''            SELECT     sca_batch_id    ,     ''||');

Line: 343

     cn_utils.appendcr(body_code, '''                SELECT ''||x_sca_batch_id||'' sca_batch_id,            ''||');

Line: 350

     cn_utils.appendcr(body_code, '''                         SELECT cshi.sca_headers_interface_id, ''||');

Line: 354

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

Line: 472

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

Line: 526

    SELECT repository_id INTO l_repository_id FROM cn_repositories;

Line: 611

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

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

         SELECT co.object_id
           INTO l_pkg_object_id
           FROM cn_objects co
           WHERE co.name =  l_pkg_name --'cn_formula_'|| p_formula_id || '_pkg'
           AND co.object_type = 'PKB'
	   AND co.org_id = g_org_id;

Line: 645

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

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