1: package body AMV_I_CONTENT_TYPES_PKG as
2: /* $Header: amvvcthb.pls 120.1 2005/06/21 17:42:14 appldev ship $ */
3: procedure Load_Row(
4: x_content_type_id in VARCHAR2,
5: x_object_version_number in varchar2,
17: end if;
18: l_content_type_id := to_number(x_content_type_id);
19: l_object_version_number := to_number(x_object_version_number);
20: --
21: AMV_I_CONTENT_TYPES_PKG.UPDATE_ROW (
22: X_CONTENT_TYPE_ID => l_content_type_id,
23: X_OBJECT_VERSION_NUMBER => l_object_version_number,
24: X_CONTENT_TYPE_NAME => x_content_type_name,
25: X_DESCRIPTION => x_description,
28: X_LAST_UPDATE_LOGIN => 0
29: );
30: exception
31: when NO_DATA_FOUND then
32: AMV_I_CONTENT_TYPES_PKG.INSERT_ROW (
33: X_ROWID => l_row_id,
34: X_CONTENT_TYPE_ID => l_content_type_id,
35: X_OBJECT_VERSION_NUMBER => l_object_version_number,
36: X_CONTENT_TYPE_NAME => x_content_type_name,
315: where T.CONTENT_TYPE_ID = B.CONTENT_TYPE_ID
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317: end ADD_LANGUAGE;
318:
319: end AMV_I_CONTENT_TYPES_PKG;