1: package body HZ_STYLE_FMT_LAYOUTS_PKG as
2: /* $Header: ARHPSFYB.pls 115.9 2004/02/25 23:16:07 geliu noship $ */
3:
4: L_USER_ID_FOR_SEED NUMBER := NULL;
5:
503: if ((x_custom_mode = 'FORCE') or
504: ((l_f_luby = 0) and (l_db_luby = 1)) or
505: ((l_f_luby = l_db_luby) and (l_f_ludate > l_db_ludate)))
506: then
507: hz_style_fmt_layouts_pkg.update_row (
508: X_STYLE_FMT_LAYOUT_ID => l_id,
509: X_STYLE_FORMAT_CODE => X_STYLE_FORMAT_CODE,
510: X_VARIATION_NUMBER => X_VARIATION_NUMBER,
511: X_ATTRIBUTE_CODE => X_ATTRIBUTE_CODE,
529:
530: exception
531: when no_data_found then
532: -- record not found, insert in all cases
533: hz_style_fmt_layouts_pkg.insert_row(
534: x_rowid => l_rowid,
535: x_style_fmt_layout_id => l_id,
536: x_style_format_code => X_STYLE_FORMAT_CODE,
537: x_variation_number => X_VARIATION_NUMBER,
629: end;
630:
631: end TRANSLATE_ROW;
632:
633: end HZ_STYLE_FMT_LAYOUTS_PKG;