APPS.WMS_RULE_GEN_PKGS SQL Statements

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

Line: 23

   g_build_package_tbl.delete;

Line: 33

 select count(rule_id) into l_rule_count
 from wms_rules_b
 where type_code = p_type_code
  and  enabled_flag = 'Y';

Line: 119

      SELECT 1
        FROM dual
        WHERE exists(
        SELECT status
        FROM all_objects
       WHERE object_name = p_package_name
         AND object_type = 'PACKAGE'
         AND status <> 'VALID'
         AND owner = g_owner);

Line: 130

      SELECT 1
        FROM dual
        WHERE exists(
        SELECT status
        FROM all_objects
      WHERE object_name = p_package_name
         AND object_type = 'PACKAGE BODY'
         AND status <> 'VALID'
         AND owner = g_owner);

Line: 273

  /*SELECT rule_id
    FROM WMS_RULES_B
   WHERE enabled_flag  = 'Y'
   AND   type_code = p_type_code
   ORDER BY rule_weight DESC, creation_date;*/

Line: 280

   SELECT /*+ leading(rl) */ rl.rule_id
         FROM WMS_RULES_B rl  , all_objects obj
      WHERE rl.enabled_flag  = 'Y'
      AND   rl.type_code = p_type_code
      AND (obj.object_name  =  'WMS_RULE_'|| to_char(rl.rule_id)
      AND  obj.object_type = 'PACKAGE BODY'
      AND  obj.owner = g_owner AND obj.status = 'VALID' )
   ORDER BY  rl.rule_weight DESC, rl.creation_date;

Line: 1278

         g_tbl_pkg_body.DELETE;

Line: 1281

         g_tbl_pkg_body_f.DELETE;

Line: 1284

         g_tbl_pkg_body_f_avail.DELETE;

Line: 1287

         g_tbl_pkg_body_c.DELETE;

Line: 1367

      select oracle_username into g_owner
       from  fnd_oracle_userid
      where  read_only_flag = 'U';

Line: 1439

                update_count(l_type_name, l_counter );

Line: 1481

                 update_count(l_type_name, l_counter );

Line: 1520

                   update_count(l_type_name, l_counter );

Line: 1562

                  update_count(l_type_name, l_counter );

Line: 1603

                   update_count(l_type_name, l_counter );

Line: 1642

	    update_count(l_type_name, l_counter );

Line: 1670

  SELECT package_name_count
    FROM WMS_RULE_LIST_PACKAGE
    WHERE rule_type = p_rule_type for update;

Line: 1714

  SELECT package_name_count
    FROM WMS_RULE_LIST_PACKAGE
    WHERE rule_type = p_rule_type;

Line: 1743

PROCEDURE  update_count(
                  p_rule_type IN VARCHAR2
                , p_count     IN  NUMBER ) IS
BEGIN
  UPDATE WMS_RULE_LIST_PACKAGE
     SET PACKAGE_NAME_COUNT = p_count
   WHERE RULE_TYPE = p_rule_type;

Line: 1753

END update_count;