This function finds changes in source that are applicable to the panel. 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_PPRAPI.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_panelversion_id | NUMBER | Panel 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 object identifier (FOID) as a number. See FOID Conversion Functions. |
Example
DECLARE v_panelversion_id CONSTANT INTEGER := 1; v_SPECIFIED_UPDATES INTEGER; BEGIN v_SPECIFIED_UPDATES := p_pprapi.getupdates(v_panelversion_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.