149: SELECT
150: decode( px_attribute_ID, FND_API.G_MISS_NUM, NULL, px_attribute_ID),
151: l.language_code,
152: SYSDATE,
153: FND_GLOBAL.user_id,
154: SYSDATE,
155: FND_GLOBAL.user_id,
156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
151: l.language_code,
152: SYSDATE,
153: FND_GLOBAL.user_id,
154: SYSDATE,
155: FND_GLOBAL.user_id,
156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
152: SYSDATE,
153: FND_GLOBAL.user_id,
154: SYSDATE,
155: FND_GLOBAL.user_id,
156: FND_GLOBAL.conc_login_id,
157: USERENV('LANG'),
158: decode( p_name, FND_API.G_MISS_CHAR, NULL, p_name),
159: decode( p_description, FND_API.G_MISS_CHAR, NULL, p_description),
160: decode( p_short_name, FND_API.G_MISS_CHAR, NULL, p_short_name)
261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,
265: last_updated_by = FND_GLOBAL.user_id,
266: last_update_login = FND_GLOBAL.conc_login_id,
267: source_lang = USERENV('LANG')
268: WHERE attribute_id = p_attribute_ID
269: AND USERENV('LANG') IN (language, source_lang);
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,
265: last_updated_by = FND_GLOBAL.user_id,
266: last_update_login = FND_GLOBAL.conc_login_id,
267: source_lang = USERENV('LANG')
268: WHERE attribute_id = p_attribute_ID
269: AND USERENV('LANG') IN (language, source_lang);
270:
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,
380: last_updated_by = FND_GLOBAL.user_id,
381: last_update_login = FND_GLOBAL.conc_login_id,
382: source_lang = USERENV('LANG')
383: WHERE attribute_id = p_attribute_ID
384: AND USERENV('LANG') IN (language, source_lang);
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,
380: last_updated_by = FND_GLOBAL.user_id,
381: last_update_login = FND_GLOBAL.conc_login_id,
382: source_lang = USERENV('LANG')
383: WHERE attribute_id = p_attribute_ID
384: AND USERENV('LANG') IN (language, source_lang);
385:
443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id,
449: source_lang = USERENV('LANG')
450: WHERE attribute_id = p_attribute_ID
451: AND USERENV('LANG') IN (language, source_lang);
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,
447: last_updated_by = FND_GLOBAL.user_id,
448: last_update_login = FND_GLOBAL.conc_login_id,
449: source_lang = USERENV('LANG')
450: WHERE attribute_id = p_attribute_ID
451: AND USERENV('LANG') IN (language, source_lang);
452: