1: package body HZ_STYLES_PKG as
2: /* $Header: ARHPSTYB.pls 115.9 2004/02/25 23:16:25 geliu noship $ */
3:
4: L_USER_ID_FOR_SEED NUMBER := NULL;
5:
330: if ((x_custom_mode = 'FORCE') or
331: ((l_f_luby = 0) and (l_db_luby = 1)) or
332: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
333: then
334: hz_styles_pkg.update_row (
335: X_STYLE_CODE => X_STYLE_CODE,
336: X_DATABASE_OBJECT_NAME => X_DATABASE_OBJECT_NAME,
337: X_STYLE_NAME => X_STYLE_NAME,
338: X_DESCRIPTION => X_DESCRIPTION,
342:
343: exception
344: when no_data_found then
345: -- record not found, insert in all cases
346: hz_styles_pkg.insert_row(
347: x_rowid => l_rowid,
348: x_style_code => X_STYLE_CODE,
349: x_database_object_name => X_DATABASE_OBJECT_NAME,
350: x_style_name => X_STYLE_NAME,
411: end;
412:
413: end TRANSLATE_ROW;
414:
415: end HZ_STYLES_PKG;