1: package body AMV_C_CHANNELS_PKG as
2: /* $Header: amvtchab.pls 120.1 2005/06/29 10:28:03 appldev ship $ */
3: procedure LOAD_ROW (
4: X_CHANNEL_ID in VARCHAR2,
5: X_OBJECT_VERSION_NUMBER in VARCHAR2,
74: l_expiration_date := to_date(x_expiration_date, 'DD/MM/YYYY');
75: l_last_match_time := to_date(x_last_match_time, 'DD/MM/YYYY');
76: l_last_notification_time :=to_date(x_last_notification_time,'DD/MM/YYYY');
77: --
78: AMV_C_CHANNELS_PKG.UPDATE_ROW (
79: X_CHANNEL_ID => l_channel_id,
80: X_OBJECT_VERSION_NUMBER => l_object_version_number,
81: X_CHANNEL_TYPE => x_channel_type,
82: X_CHANNEL_CATEGORY_ID => l_channel_category_id,
124: X_LAST_UPDATE_LOGIN => 0
125: );
126: exception
127: when NO_DATA_FOUND then
128: AMV_C_CHANNELS_PKG.INSERT_ROW (
129: X_ROWID => l_row_id,
130: X_CHANNEL_ID => l_channel_id,
131: X_OBJECT_VERSION_NUMBER => l_object_version_number,
132: X_CHANNEL_TYPE => x_channel_type,
779: where T.CHANNEL_ID = B.CHANNEL_ID
780: and T.LANGUAGE = L.LANGUAGE_CODE);
781: end ADD_LANGUAGE;
782:
783: end AMV_C_CHANNELS_PKG;