34: p_svr_types_rec.max_major_load_factor,
35: p_svr_types_rec.max_minor_load_factor
36: );
37:
38: INSERT INTO ieo_svr_types_tl (
39: type_id,
40: language,
41: created_by,
42: creation_date,
62: FROM fnd_languages l
63: WHERE l.installed_flag IN ('I', 'B')
64: AND NOT EXISTS
65: (SELECT NULL
66: FROM ieo_svr_types_tl t
67: WHERE t.type_id = p_svr_types_rec.type_id
68: AND t.language = l.language_code);
69:
70: OPEN c;
95: IF (SQL%NOTFOUND) THEN
96: RAISE no_data_found;
97: END IF;
98:
99: UPDATE ieo_svr_types_tl SET
100: type_name = p_svr_types_rec.type_name,
101: source_lang = USERENV('LANG'),
102: type_description = p_svr_types_rec.type_description,
103: last_updated_by = p_svr_types_rec.last_updated_by,
179: BEGIN
180:
181: -- only UPDATE rows that have not been altered by user
182:
183: UPDATE ieo_svr_types_tl SET
184: type_name = p_type_name,
185: source_lang = userenv('LANG'),
186: type_description = p_type_description,
187: type_extra = p_type_extra,