APPS.IEO_SVR_TYPES_SEED_PKG dependencies on IEO_SVR_TYPES_TL

Line 40: INSERT INTO ieo_svr_types_tl (

36: p_svr_types_rec.max_minor_load_factor,
37: p_svr_types_rec.application_short_name
38: );
39:
40: INSERT INTO ieo_svr_types_tl (
41: type_id,
42: language,
43: created_by,
44: creation_date,

Line 68: FROM ieo_svr_types_tl t

64: FROM fnd_languages l
65: WHERE l.installed_flag IN ('I', 'B')
66: AND NOT EXISTS
67: (SELECT NULL
68: FROM ieo_svr_types_tl t
69: WHERE t.type_id = p_svr_types_rec.type_id
70: AND t.language = l.language_code);
71:
72: OPEN c;

Line 102: UPDATE ieo_svr_types_tl SET

98: IF (SQL%NOTFOUND) THEN
99: RAISE no_data_found;
100: END IF;
101:
102: UPDATE ieo_svr_types_tl SET
103: type_name = p_svr_types_rec.type_name,
104: source_lang = USERENV('LANG'),
105: type_description = p_svr_types_rec.type_description,
106: last_updated_by = p_svr_types_rec.last_updated_by,

Line 189: UPDATE ieo_svr_types_tl SET

185: BEGIN
186:
187: -- only UPDATE rows that have not been altered by user
188:
189: UPDATE ieo_svr_types_tl SET
190: type_name = p_type_name,
191: source_lang = userenv('LANG'),
192: type_description = p_type_description,
193: type_extra = p_type_extra,

Line 205: delete from IEO_SVR_TYPES_TL T

201:
202: PROCEDURE ADD_LANGUAGE
203: is
204: begin
205: delete from IEO_SVR_TYPES_TL T
206: where not exists
207: (select NULL
208: from IEO_SVR_TYPES_B B
209: where B.TYPE_ID = T.TYPE_ID

Line 212: update IEO_SVR_TYPES_TL T set (

208: from IEO_SVR_TYPES_B B
209: where B.TYPE_ID = T.TYPE_ID
210: );
211:
212: update IEO_SVR_TYPES_TL T set (
213: TYPE_NAME,
214: TYPE_DESCRIPTION,
215: TYPE_EXTRA
216: ) = (select

Line 220: from IEO_SVR_TYPES_TL B

216: ) = (select
217: B.TYPE_NAME,
218: B.TYPE_DESCRIPTION,
219: B.TYPE_EXTRA
220: from IEO_SVR_TYPES_TL B
221: where B.TYPE_ID = T.TYPE_ID
222: and B.LANGUAGE = T.SOURCE_LANG)
223: where (
224: T.TYPE_ID,

Line 229: from IEO_SVR_TYPES_TL SUBB, IEO_SVR_TYPES_TL SUBT

225: T.LANGUAGE
226: ) in (select
227: SUBT.TYPE_ID,
228: SUBT.LANGUAGE
229: from IEO_SVR_TYPES_TL SUBB, IEO_SVR_TYPES_TL SUBT
230: where SUBB.TYPE_ID = SUBT.TYPE_ID
231: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
232: and (SUBB.TYPE_NAME <> SUBT.TYPE_NAME
233: or SUBB.TYPE_DESCRIPTION <> SUBT.TYPE_DESCRIPTION

Line 241: insert into IEO_SVR_TYPES_TL (

237: or (SUBB.TYPE_EXTRA is null and SUBT.TYPE_EXTRA is not null)
238: or (SUBB.TYPE_EXTRA is not null and SUBT.TYPE_EXTRA is null)
239: ));
240:
241: insert into IEO_SVR_TYPES_TL (
242: TYPE_ID,
243: CREATED_BY,
244: CREATION_DATE,
245: LAST_UPDATED_BY,

Line 265: from IEO_SVR_TYPES_TL B, FND_LANGUAGES L

261: B.TYPE_DESCRIPTION,
262: B.TYPE_EXTRA,
263: L.LANGUAGE_CODE,
264: B.SOURCE_LANG
265: from IEO_SVR_TYPES_TL B, FND_LANGUAGES L
266: where L.INSTALLED_FLAG in ('I', 'B')
267: and B.LANGUAGE = userenv('LANG')
268: and not exists
269: (select NULL

Line 270: from IEO_SVR_TYPES_TL T

266: where L.INSTALLED_FLAG in ('I', 'B')
267: and B.LANGUAGE = userenv('LANG')
268: and not exists
269: (select NULL
270: from IEO_SVR_TYPES_TL T
271: where T.TYPE_ID = B.TYPE_ID
272: and T.LANGUAGE = L.LANGUAGE_CODE);
273: end ADD_LANGUAGE;
274: