UPDATEREGISTRYENTRY

Parameter	Type	Description
v_sourceregistry_id	NUMBER	The primary key of the source entry to be edited.
v_new_priority_id	NUMBER	The ID of the project priority from the lookup table sourceregistry_priority. Use NULL to not change this value.
v_new_use_id	NUMBER	The ID of the source use values from the table sourceregistry_use. Use NULL to not change this value.
v_new_created_by	NUMBER	The ID of the user that created the source registry entry. Use NULL to not change this value.
v_new_name	VARCHAR2	The name of the source registry entry. This is limited to 240 characters. Use NULL to not change this value.
v_new_parent	NUMBER	The primary key of the parent source registry. Use NULL to not change this value.
v_complete	VARCHAR2	Complete Status 'Yes' or 'No'. Use NULL to not change this value.
v_new_external_id	VARCHAR2	The ID of a record external to HPD. Used to link/reference an external registry system. This is limited to 50 characters. Use NULL to not change this value.

declare

v_SOURCEREGISTRY_ID SOURCEREGISTRY.SOURCEREGISTRY_ID%TYPE := 1;

v_NEW_PRIORITY_ID SOURCEREGISTRY.SPY_SOURCEREG_PRIORITY_ID%TYPE := 2;

v_NEW_USE_ID SOURCEREGISTRY.SUE_SOURCEREG_USE_ID%TYPE := 2;

v_new_created_by SOURCEREGISTRY.created_by%TYPE := NULL;

v_NEW_NAME SOURCEREGISTRY.NAME%TYPE := NULL;

v_NEW_PARENT SOURCEREGISTRY.SO_SOURCEREGISTRY_ID%TYPE := NULL;

v_COMPLETE SOURCEREGISTRY.COMPLETE%TYPE := NULL;

v_new_external_id SOURCEREGISTRY.external_id%type := NULL;

begin

P_REGISTRY_MANAGER.UPDATEREGISTRYENTRY (

v_SOURCEREGISTRY_ID,

v_NEW_PRIORITY_ID,

v_NEW_USE_ID,

v_new_created_by,

v_NEW_NAME,

v_NEW_PARENT,

v_COMPLETE,

v_new_external_id);

end;