APPS.CZ_PB_USG SQL Statements

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

Line: 42

  SELECT model_usage_id INTO usageId
    FROM  cz_model_usages
  WHERE name = usage_name;

Line: 58

  SELECT model_usage_id INTO usageId
    FROM  cz_model_usages
  WHERE name = usage_name;

Line: 89

  SELECT model_usage_id INTO usageId
    FROM  cz_model_usages
  WHERE name = usage_name;

Line: 138

PROCEDURE DELETE_USAGE(usageId		IN	NUMBER,
		       	delete_status    IN OUT NOCOPY  VARCHAR2)
AS


TYPE t_indexes IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line: 157

	v_nodes.DELETE;

Line: 158

	v_rules.DELETE;

Line: 159

	v_masks_nodes.DELETE;

Line: 160

	v_masks_rules.DELETE;

Line: 164

		SELECT ps_node_id,
		       effective_usage_mask
		BULK
		COLLECT
		INTO	v_nodes,
			v_masks_nodes
		FROM cz_ps_nodes
		WHERE   effective_usage_mask NOT IN ('0', '0000000000000000')
		ORDER BY effective_usage_mask;

Line: 179

		SELECT rule_id,
		       effective_usage_mask
		BULK
		COLLECT
		INTO	v_rules,
			v_masks_rules
		FROM cz_rules
		WHERE   effective_usage_mask NOT IN ('0', '0000000000000000')
		ORDER BY effective_usage_mask;

Line: 195

		UPDATE cz_model_usages
		SET     in_use = 'X'
		WHERE model_usage_id = usageId;

Line: 199

  		DELETE FROM cz_publication_usages
    		WHERE usage_id = usageId;

Line: 202

		DELETE FROM cz_rp_entries
		WHERE object_type ='USG' and object_id = usageId;

Line: 224

	 		 UPDATE cz_ps_nodes
	 		    SET effective_usage_mask = v_masks_nodes(i)
	 		 WHERE  ps_node_id = v_nodes(i);

Line: 249

	  		UPDATE cz_rules
	     		SET    effective_usage_mask = v_masks_rules(i)
	  		WHERE  rule_id = v_rules(i);

Line: 255

	delete_status := '-1';

Line: 259

  		delete_status := '0';

Line: 263

END DELETE_USAGE;