Removes the source usage from the product. Once a usage is removed from a product updates from that usage will no longer be available to the product.
There is one set of usages for each edition of a product, so this affects all versions of an edition.
Input
Parameter | Type | Description |
|---|---|---|
v_product_id | NUMBER | The primary key of the vector product. |
v_usage_name | VARCHAR2 | The name of the usage to be removed from the product. |
Example
DECLARE v_usage_name constant VARCHAR2(50 char) := 'Harbour(4000-21999)'; v_product_id constant NUMBER := 8; BEGIN p_vectorapi.del_source_usage (v_product_id, v_usage_name); END; / |
Exceptions
• Product p_product_id is inactive and cannot be modified.
• Product product_id is status and cannot be modified.
• Cannot find usage with this name.