Update the complete status of a source entry.
Input
Parameter | Type | Description |
|---|---|---|
v_sourceregistry_id | NUMBER | The primary key of the source entry to be edited. |
v_complete | VARCHAR2 | 'Y' or 'N'. |
Example
declare v_SOURCEREGISTRY_ID CONSTANT NUMBER := 1; v_COMPLETE CONSTANT VARCHAR2(1) := 'N'; begin P_REGISTRY_MANAGER.UPDATEREGISTRYENTRY(v_SOURCEREGISTRY_ID, v_COMPLETE); end; / |
Exceptions
• REGISTRY SOURCE ID is required.
• Input REGISTRY SOURCE ID does not exist
• COMPLETION STATUS is required
• Invalid Value for Completion Status
• Error in UPDATEREGISTRYENTRY: (SQL code)