117: X_LAST_UPDATED_BY in NUMBER,
118: X_LAST_UPDATE_LOGIN in NUMBER
119: ) is
120: begin
121: update AMS_SETUP_TYPES set
122: DISPLAY_SEQUENCE_NO = X_DISPLAY_SEQUENCE_NO,
123: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
124: OBJECT_TYPE = X_OBJECT_TYPE,
125: ACTIVITY_TYPE_CODE = X_ACTIVITY_TYPE_CODE,
200: from AMS_SETUP_TYPES
201: where setup_type_id = X_SETUP_TYPE_ID;
202:
203: cursor c_get_setid is
204: select AMS_SETUP_TYPES_S.nextval
205: from dual;
206: BEGIN
207:
208: if X_OWNER = 'SEED' then