APPS.CZ_QC_MGR SQL Statements

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

Line: 52

PROCEDURE Propogate_DeletedFlag IS
    TYPE t_arr      IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;

Line: 58

     SELECT config_hdr_id,config_rev_nbr
     BULK COLLECT INTO t_cfg_id,t_cfg_nbr
     FROM CZ_CONFIG_HDRS WHERE deleted_flag='1';

Line: 65

                 UPDATE CZ_CONFIG_EXT_ATTRIBUTES
                 SET deleted_flag='1'
                 WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
                 AND deleted_flag='0';

Line: 72

                 UPDATE CZ_CONFIG_ATTRIBUTES
                 SET deleted_flag='1'
                 WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
                 AND deleted_flag='0';

Line: 79

                 UPDATE CZ_CONFIG_ITEMS
                 SET deleted_flag='1'
                 WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
                 AND deleted_flag='0';

Line: 86

                 UPDATE CZ_CONFIG_INPUTS
                 SET deleted_flag='1'
                 WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
                 AND deleted_flag='0';

Line: 93

                 UPDATE CZ_CONFIG_MESSAGES
                 SET deleted_flag='1'
                 WHERE config_hdr_id=t_cfg_id(i) AND config_rev_nbr=t_cfg_nbr(i)
                 AND deleted_flag='0';

Line: 113

  PurgeDeleteConfigBatchsize NUMBER;

Line: 115

    SELECT config_hdr_id, config_rev_nbr
    FROM   cz_config_hdrs
    WHERE  (to_be_deleted_flag = '1'
    OR     deleted_flag = '1') and
	   component_instance_type = 'R';

Line: 122

    SELECT value
    INTO   PurgeDeleteConfigBatchsize
    FROM   cz_db_settings
    WHERE  setting_id = 'PurgeDeleteConfigBatchsize';

Line: 128

      PurgeDeleteConfigBatchsize := 100;

Line: 133

    BULK COLLECT INTO t_cfg_id, t_cfg_nbr LIMIT PurgeDeleteConfigBatchsize;

Line: 137

        cz_cf_api.delete_configuration (
          t_cfg_id(i),
          t_cfg_nbr(i),
          l_usage_exists,
          l_error_message,
          l_Return_value
        );