Add a new source usage to the product. After a usage is added to a product, updates from that usage are 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 added to the product. |
Example
DECLARE v_usage_name constant VARCHAR2(50 char) := 'Harbour(4000-21999)'; v_product_id constant NUMBER := 8; BEGIN p_vectorapi.add_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.
• This usage has already been added to the product.