[Home] [Help]
414: begin
415:
416: select LAST_UPDATED_BY, LAST_UPDATE_DATE
417: into db_luby, db_ludate
418: from XDO_TRANS_UNIT_PROPS
419: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME
420: and TEMPLATE_CODE = X_TEMPLATE_CODE
421: and UNIT_ID = X_UNIT_ID
422: and PROP_TYPE = X_PROP_TYPE;
428: p_db_lud => db_ludate,
429: p_custom_mode => x_custom_mode))
430: then
431:
432: update xdo_trans_unit_props
433: set prop_value = X_PROP_VALUE,
434: last_update_date = X_LAST_UPDATE_DATE,
435: last_updated_by = X_LAST_UPDATED_BY,
436: last_update_login = X_LAST_UPDATE_LOGIN
442: end if;
443:
444: exception when no_data_found then
445:
446: insert into xdo_trans_unit_props
447: (
448: application_short_name,
449: template_code,
450: unit_id,