APPS.CS_QKMENU_DML_PKG SQL Statements

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

Line: 17

      SELECT function_id, filter_id, function_filter_id
      FROM   cs_qm_function_filters
      WHERE  active_flag = 'Y';

Line: 27

     SELECT NVL(COUNT(*), 0)
     INTO record_exist
     FROM cs_qm_user_folders
     WHERE folder_name = l_folder_name
	AND user_id = l_user_id;

Line: 33

     SELECT CS_QM_USER_FOLDERS_S.NextVal
     INTO next_sequence
     FROM dual;

Line: 38

        UPDATE cs_qm_user_folders
  	   SET description = l_description
	   WHERE folder_name = l_folder_name
	   AND user_id = l_user_id;

Line: 44

   	   INSERT INTO cs_qm_user_folders
	       (user_folder_id, last_update_date, last_updated_by, creation_date,
		   created_by,  user_id, folder_name, description, default_flag,
	        active_flag, object_version_number)
	   VALUES
	       (next_sequence, sysdate, l_user_id, sysdate, l_user_id,
	        l_user_id, l_folder_name,
		   l_description, 'N', 'Y', 1);

Line: 61

       UPDATE cs_qm_user_folders
  	  SET default_flag = 'N'
	  WHERE default_flag = 'Y';

Line: 67

	     UPDATE cs_qm_user_folders
	     SET default_flag = 'Y'
	     WHERE folder_name = l_folder_name
		AND user_id = l_user_id;

Line: 73

          UPDATE cs_qm_user_folders
	     SET default_flag = 'Y'
	     WHERE user_folder_id = next_sequence
		AND user_id = l_user_id;

Line: 84

  PROCEDURE insert_holder(l_user_folder_id        NUMBER,
			  l_function_filter_id    NUMBER,
			  l_user_id               NUMBER,
                          l_filter_value          VARCHAR2,
                          l_filter_value_id       NUMBER)
 IS

  BEGIN

    INSERT INTO cs_qm_folder_filters
	  (folder_filter_id, user_folder_id, function_filter_id,
           filter_operator, filter_value, filter_value_id,
 	   last_update_date, last_updated_by, last_update_login,
	   creation_date, created_by, object_version_number)
    VALUES
       (cs_qm_folder_filters_s.nextVal, l_user_folder_id, l_function_filter_id,
        '=', l_filter_value, l_filter_value_id,
	   sysdate, l_user_id, l_user_id, sysdate, l_user_id, 1);

Line: 104

  END insert_holder;

Line: 107

  PROCEDURE update_holder(l_user_folder_id        NUMBER,
			           l_function_filter_id    NUMBER,
			           l_user_id               NUMBER,
                          l_filter_value          VARCHAR2,
                          l_filter_value_id       NUMBER
                          )
IS

  BEGIN

    UPDATE cs_qm_folder_filters
    SET filter_value = l_filter_value,
        filter_value_id = l_filter_value_id
    WHERE user_folder_id = l_user_folder_id
    AND   function_filter_id = l_function_filter_id;

Line: 124

  END update_holder;

Line: 127

  PROCEDURE insert_empty_folder(l_user_id       NUMBER,
						  l_folder_name   VARCHAR2) IS

    l_user_folder_id      NUMBER;

Line: 133

	 SELECT function_filter_id
	 FROM   cs_qm_function_filters;

Line: 139

    SELECT user_folder_id
    INTO   l_user_folder_id
    FROM   cs_qm_user_folders
    WHERE  user_id = l_user_id
    AND    folder_name = l_folder_name;

Line: 147

        INSERT INTO cs_qm_folder_filters
         (folder_filter_id, user_folder_id, function_filter_id, filter_operator,
   	     filter_value,
	     last_update_date, last_updated_by, last_update_login,
		creation_date, created_by, object_version_number)
        VALUES
	    (cs_qm_folder_filters_s.nextVal, l_user_folder_id,
		filter_item.function_filter_id, '=', '',
		sysdate, l_user_id, l_user_id, sysdate, l_user_id, 1);

Line: 161

  END insert_empty_folder;

Line: 172

     SELECT CS_QM_USER_FOLDERS_s.NextVal
     INTO next_sequence
     FROM dual;

Line: 176

     INSERT INTO cs_qm_user_folders
              (user_folder_id, last_update_date, last_updated_by, creation_date,
	  	     created_by,  user_id, folder_name, description, default_flag,
	          active_flag, object_version_number)
	VALUES
	         (next_sequence, sysdate, l_user_id, sysdate, l_user_id,
	          l_user_id, folder_name,
	   	     description, 'N', 'Y', 1);

Line: 187

  PROCEDURE update_default_flag(l_user_id      NUMBER,
                                l_folder_name    VARCHAR2,
						  l_default_flag VARCHAR2) IS

    record_exist         NUMBER;

Line: 198

       UPDATE cs_qm_user_folders
  	  SET default_flag = 'N'
	  WHERE default_flag = 'Y'
	  AND user_id = l_user_id;

Line: 204

       UPDATE cs_qm_user_folders
       SET default_flag = 'Y'
       WHERE folder_name = l_folder_name
	  AND user_id = l_user_id;

Line: 212

  END update_default_flag;