200: ) is
201: begin
202: update AMV_I_CONTENT_TYPES_B set
203: OBJECT_VERSION_NUMBER = decode(X_OBJECT_VERSION_NUMBER,
204: FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER + 1,
205: X_OBJECT_VERSION_NUMBER),
206: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
207: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
208: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
213: end if;
214:
215: update AMV_I_CONTENT_TYPES_TL set
216: CONTENT_TYPE_NAME =
217: decode(X_CONTENT_TYPE_NAME, FND_API.G_MISS_CHAR, CONTENT_TYPE_NAME,
218: X_CONTENT_TYPE_NAME),
219: DESCRIPTION =
220: decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION,
221: X_DESCRIPTION),
216: CONTENT_TYPE_NAME =
217: decode(X_CONTENT_TYPE_NAME, FND_API.G_MISS_CHAR, CONTENT_TYPE_NAME,
218: X_CONTENT_TYPE_NAME),
219: DESCRIPTION =
220: decode(X_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION,
221: X_DESCRIPTION),
222: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
223: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
224: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,