APPS.WMS_WCS_DIAGNOSTICS SQL Statements

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

Line: 32

         SELECT CONFIG_VALUE
           FROM wms_carousel_configuration
          WHERE CONFIG_NAME = p_name
            AND NVL (sequence_id, 0) = NVL (p_sequence_id, 0)
            AND active_ind = 'Y';

Line: 92

         SELECT COUNT (*)
           FROM all_objects
          WHERE object_name = p_name
            AND owner = p_owner
            AND object_type = p_type;

Line: 104

         SELECT status
           FROM all_objects
          WHERE object_name = p_name
            AND owner = p_owner
            AND object_type = p_type;

Line: 117

         SELECT COUNT (*)
           FROM all_source
          WHERE NAME = p_name
            AND TYPE = p_type
            AND UPPER (text) LIKE '%' || p_version_key || '%';

Line: 130

         SELECT SUBSTR (text,
                        INSTR (text, p_version_key) + LENGTH (p_version_key)
                        + 1,
                          LENGTH (text)
                        - INSTR (text, p_version_key)
                        - LENGTH (p_version_key)
                        - 1
                       )
           FROM all_source
          WHERE NAME = p_name
            AND TYPE = p_type
            AND UPPER (text) LIKE '%' || p_version_key || '%';

Line: 146

      SELECT MAX (sequence_id)
        INTO v_object_count
        FROM wms_carousel_configuration
       WHERE CONFIG_NAME = 'DIAG_OBJECT_NAME';

Line: 313

         SELECT COUNT (*)
           FROM all_tab_privs
          WHERE table_schema = p_owner
            AND table_name = p_object
            AND grantee = p_grantee
            AND PRIVILEGE = p_type;

Line: 325

         SELECT COUNT (*)
           FROM all_procedures
          WHERE owner = p_owner AND object_name = p_object;

Line: 332

      SELECT MAX (sequence_id)
        INTO v_privilege_count
        FROM wms_carousel_configuration
       WHERE CONFIG_NAME = 'DIAG_PRIVILEGE_OBJECT';

Line: 364

                         ('SELECT', 'UPDATE', 'INSERT', 'DELETE', 'EXECUTE')
            THEN
               -- Lookup table privilege
               OPEN c_table_privilege_count (v_privilege_owner,
                                             v_privilege_object,
                                             v_privilege_grantee,
                                             v_privilege_type
                                            );

Line: 430

      SELECT COUNT (*)
        INTO v_cnt
        FROM user_source
       WHERE NAME = 'WMS_DEVICE_INTEGRATION_PUB'
         AND LOWER (text) LIKE
                          '%wms_carousel_integration_pub.sync_device_request%';

Line: 449

      SELECT COUNT (*)
        INTO v_cnt
        FROM user_source
       WHERE NAME = 'WMS_DEVICE_INTEGRATION_PUB'
         AND LOWER (text) LIKE '%wms_carousel_integration_pub.sync_device%'
         AND LOWER (text) NOT LIKE
                          '%wms_carousel_integration_pub.sync_device_request%';

Line: 517

         SELECT *
           FROM wms_carousel_configuration
          WHERE CONFIG_NAME <> 'DIAG_CONFIG_HASH_VALUE';

Line: 549

   PROCEDURE update_hash_value
   IS
      v_calc_hash_value   NUMBER := 0;

Line: 558

      UPDATE wms_carousel_configuration
         SET CONFIG_VALUE = v_calc_hash_value
       WHERE CONFIG_NAME = 'DIAG_CONFIG_HASH_VALUE' AND active_ind = 'Y';

Line: 617

      And all this procedure does is create an insert script which when run
      on another DB will insert all the config data into it
      */

   --
   --  examples: export_configuration('10,11','BA,BD'); export_configuration('*'/*all*/,'*'/*all*/);

Line: 631

      v_insert            VARCHAR2 (10240);

Line: 649

      DBMS_OUTPUT.put_line ('delete from wms_carousel_configuration;');

Line: 652

                  'select * from wms.wms_carousel_configuration where (1 = 0 ';

Line: 693

         DBMS_OUTPUT.put_line ('insert into wms_carousel_configuration');

Line: 699

         v_insert :=
               '   ('
            || ''''
            || v_row.CONFIG_NAME
            || ''','
            || NVL ('' || v_row.device_type_id, 'null')
            || ','
            || NVL ('' || v_row.sequence_id, 'null')
            || ',';

Line: 712

            v_insert := v_insert || 'null,';

Line: 714

            v_insert := v_insert || '''' || v_row.SUBINVENTORY || ''',';

Line: 718

         v_insert := v_insert || '''' || v_row.active_ind || ''',';

Line: 720

         DBMS_OUTPUT.put_line (v_insert);

Line: 741

               v_insert := SUBSTR (v_row.CONFIG_VALUE, v_i1, v_i2 - v_i1);

Line: 744

               IF NVL (v_insert, '') = ''
               THEN
                  v_insert := 'null';

Line: 749

                  v_insert := '''' || REPLACE (v_insert, '''', '''''')
                              || '''';

Line: 756

                  v_insert := '      ' || v_insert;

Line: 758

                  v_insert := '      ||chr(10)||' || v_insert;

Line: 762

               DBMS_OUTPUT.put_line (v_insert);

Line: 796

      DBMS_OUTPUT.put_line ('insert into wms_carousel_configuration');

Line: 824

         SELECT *
           FROM wms_carousel_configuration
          WHERE CONFIG_NAME = 'RECEIVE_PIPE' AND active_ind = 'Y';

Line: 830

         SELECT *
           FROM all_jobs
          WHERE what LIKE
                      'wms_carousel_integration_pub.pipe_listener_loop%,'''
                   || p_zone
                   || '''%'
            AND schema_user = 'APPS';

Line: 1019

      DELETE FROM wms_wcs_request_test;

Line: 1021

      INSERT INTO wms_wcs_request_test
                  (request_id, task_id, sequence_id, task_type_id, quantity,
                   subinventory_code, LOCATOR, device_name, device_id,
                   device_type_id, business_event, business_event_id,
                   relation_id, lpn, item, segment1, segment2,
                   segment3, segment4, segment5, segment6,
                   segment7, segment8, segment9, segment10
                  )
           VALUES (v_request_id, 1, 1, p_task_type_id, p_quantity,
                   'TestSI', p_locator, 'TestDev', p_device_id,
                   p_device_type_id, 'TestPick', p_business_event_id,
                   NULL, p_lpn, 'TestItem', v_segment1, v_segment2,
                   v_segment3, v_segment4, v_segment5, v_segment6,
                   v_segment7, v_segment8, v_segment9, v_segment10
                  );

Line: 1041

      UPDATE wms_carousel_configuration
         SET CONFIG_VALUE = 'ON'
       WHERE CONFIG_NAME = 'SIMULATION_MODE'
         AND (device_type_id = p_device_type_id OR device_type_id IS NULL)
         AND (SUBINVENTORY = p_zone OR SUBINVENTORY IS NULL);

Line: 1081

      SELECT status, attempts
        INTO v_status_code, v_status
        FROM wms_carousel_directive_queue
       WHERE request_id = v_request_id AND directive = p_directive;

Line: 1103

      UPDATE wms_carousel_configuration
         SET CONFIG_VALUE = 'OFF'
       WHERE CONFIG_NAME = 'SIMULATION_MODE'
         AND (device_type_id = p_device_type_id OR device_type_id IS NULL)
         AND (SUBINVENTORY = p_zone OR SUBINVENTORY IS NULL);

Line: 1122

      DELETE FROM wms_carousel_directive_queue
            WHERE request_id = v_request_id;