108: p_config_rec.ATTRIBUTE13,
109: p_config_rec.ATTRIBUTE14,
110: p_config_rec.ATTRIBUTE15,
111: sysdate,
112: FND_GLOBAL.user_id,
113: sysdate,
114: FND_GLOBAL.user_id,
115: FND_GLOBAL.user_id
116: );
110: p_config_rec.ATTRIBUTE15,
111: sysdate,
112: FND_GLOBAL.user_id,
113: sysdate,
114: FND_GLOBAL.user_id,
115: FND_GLOBAL.user_id
116: );
117:
118: insert into JTS_CONFIGURATIONS_TL (
111: sysdate,
112: FND_GLOBAL.user_id,
113: sysdate,
114: FND_GLOBAL.user_id,
115: FND_GLOBAL.user_id
116: );
117:
118: insert into JTS_CONFIGURATIONS_TL (
119: CONFIGURATION_ID,
128: ) select
129: X_CONFIG_ID,
130: p_config_rec.DESCRIPTION,
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.user_id,
136: L.LANGUAGE_CODE,
130: p_config_rec.DESCRIPTION,
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.user_id,
136: L.LANGUAGE_CODE,
137: userenv('LANG')
138: from FND_LANGUAGES L
131: sysdate,
132: FND_GLOBAL.user_id,
133: sysdate,
134: FND_GLOBAL.user_id,
135: FND_GLOBAL.user_id,
136: L.LANGUAGE_CODE,
137: userenv('LANG')
138: from FND_LANGUAGES L
139: where L.INSTALLED_FLAG in ('I', 'B')
399: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
400: UPDATE jts_configurations_b
401: SET config_name = p_config_name,
402: last_update_date = sysdate,
403: last_updated_by = FND_GLOBAL.user_id,
404: last_update_login = FND_GLOBAL.user_id
405: WHERE configuration_id = p_config_id;
406:
407: --take care of translation
400: UPDATE jts_configurations_b
401: SET config_name = p_config_name,
402: last_update_date = sysdate,
403: last_updated_by = FND_GLOBAL.user_id,
404: last_update_login = FND_GLOBAL.user_id
405: WHERE configuration_id = p_config_id;
406:
407: --take care of translation
408: UPDATE jts_configurations_tl
407: --take care of translation
408: UPDATE jts_configurations_tl
409: SET description = p_config_desc,
410: last_update_date = sysdate,
411: last_updated_by = FND_GLOBAL.user_id,
412: last_update_login = FND_GLOBAL.user_id,
413: source_lang = USERENV('LANG')
414: WHERE configuration_id = p_config_id
415: AND USERENV('LANG') IN (language, source_lang);
408: UPDATE jts_configurations_tl
409: SET description = p_config_desc,
410: last_update_date = sysdate,
411: last_updated_by = FND_GLOBAL.user_id,
412: last_update_login = FND_GLOBAL.user_id,
413: source_lang = USERENV('LANG')
414: WHERE configuration_id = p_config_id
415: AND USERENV('LANG') IN (language, source_lang);
416: COMMIT;