This procedure finds changes in source that are applicable to the product. The list of features is accessed via the API_UPDATED_FEATURES view, and is available for the duration of this transaction as it uses temporary tables.
If the updates have been suppressed via calls to p_vectorAPI.allowSpecificCPSUpdate, then only updates for the specified features will be detected. The function returns an indication if the compare product to source functionality has been limited to specific features.
Input
Parameter | Type | Description |
|---|---|---|
v_productversion_id | NUMBER | The product version ID |
Output
Type | Description |
|---|---|
INTEGER | 0 - All updates will be detected. 1 - The compare product to source functionality has been limited to specific foids. |
View API_UPDATED_FEATURES
Parameter | Type | Description |
|---|---|---|
rep_id | NUMBER | Representation ID. |
rwf_id | NUMBER | Real World Feature ID. |
updatetype | VARCHAR2 | Type of update (added, updated, deleted, replaced, or related to updated feature). |
usage_id | NUMBER | Usage ID where this representation resides. |
foid | NUMBER | Feature ID. |
Example
DECLARE v_productversion_id CONSTANT NUMBER := 1; v_SPECIFIED_UPDATES INTEGER; BEGIN v_SPECIFIED_UPDATES := p_vectorapi.getupdates(v_productversion_id); IF v_SPECIFIED_UPDATES = 1 THEN DBMS_OUTPUT.PUT_LINE('Only updates to the specified features are reported.'); END IF; END; /
-- After the temporary tables are populated we can query the view select * from api_updated_features; |
Exceptions
None defined at this time.