APPS.IEC_O_ALG_DATA_DEFS_PKG dependencies on IEC_O_ALG_DATA_DEFS_TL

Line 62: insert into IEC_O_ALG_DATA_DEFS_TL (

58: X_LAST_UPDATED_BY,
59: X_LAST_UPDATE_LOGIN
60: );
61:
62: insert into IEC_O_ALG_DATA_DEFS_TL (
63: DATA_CODE,
64: OWNER_CODE,
65: OWNER_TYPE_CODE,
66: NAME,

Line 92: from IEC_O_ALG_DATA_DEFS_TL T

88: from FND_LANGUAGES L
89: where L.INSTALLED_FLAG in ('I', 'B')
90: and not exists
91: (select NULL
92: from IEC_O_ALG_DATA_DEFS_TL T
93: where T.DATA_CODE = X_DATA_CODE
94: and T.OWNER_CODE = X_OWNER_CODE
95: and T.OWNER_TYPE_CODE = X_OWNER_TYPE_CODE
96: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 139: from IEC_O_ALG_DATA_DEFS_TL

135:
136: cursor c1 is select
137: NAME,
138: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
139: from IEC_O_ALG_DATA_DEFS_TL
140: where DATA_CODE = X_DATA_CODE
141: and OWNER_CODE = X_OWNER_CODE
142: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE
143: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 223: update IEC_O_ALG_DATA_DEFS_TL set

219: if (sql%notfound) then
220: raise no_data_found;
221: end if;
222:
223: update IEC_O_ALG_DATA_DEFS_TL set
224: NAME = X_NAME,
225: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
226: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
227: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 308: UPDATE iec_o_alg_data_defs_tl SET

304: X_OWNER_TYPE_CODE in VARCHAR2,
305: X_NAME in VARCHAR2,
306: P_OWNER IN VARCHAR2)is
307: BEGIN
308: UPDATE iec_o_alg_data_defs_tl SET
309: source_lang = userenv('LANG'),
310: NAME = X_NAME,
311: last_update_date = sysdate,
312: last_updated_by = fnd_load_util.owner_id(P_OWNER),

Line 327: delete from IEC_O_ALG_DATA_DEFS_TL

323: X_OWNER_CODE in VARCHAR2,
324: X_OWNER_TYPE_CODE in VARCHAR2
325: ) is
326: begin
327: delete from IEC_O_ALG_DATA_DEFS_TL
328: where DATA_CODE = X_DATA_CODE
329: and OWNER_CODE = X_OWNER_CODE
330: and OWNER_TYPE_CODE = X_OWNER_TYPE_CODE;
331:

Line 349: delete from IEC_O_ALG_DATA_DEFS_TL T

345:
346: procedure ADD_LANGUAGE
347: is
348: begin
349: delete from IEC_O_ALG_DATA_DEFS_TL T
350: where not exists
351: (select NULL
352: from IEC_O_ALG_DATA_DEFS_B B
353: where B.DATA_CODE = T.DATA_CODE

Line 358: update IEC_O_ALG_DATA_DEFS_TL T set (

354: and B.OWNER_CODE = T.OWNER_CODE
355: and B.OWNER_TYPE_CODE = T.OWNER_TYPE_CODE
356: );
357:
358: update IEC_O_ALG_DATA_DEFS_TL T set (
359: NAME
360: ) = (select
361: B.NAME
362: from IEC_O_ALG_DATA_DEFS_TL B

Line 362: from IEC_O_ALG_DATA_DEFS_TL B

358: update IEC_O_ALG_DATA_DEFS_TL T set (
359: NAME
360: ) = (select
361: B.NAME
362: from IEC_O_ALG_DATA_DEFS_TL B
363: where B.DATA_CODE = T.DATA_CODE
364: and B.OWNER_CODE = T.OWNER_CODE
365: and B.OWNER_TYPE_CODE = T.OWNER_TYPE_CODE
366: and B.LANGUAGE = T.SOURCE_LANG)

Line 377: from IEC_O_ALG_DATA_DEFS_TL SUBB, IEC_O_ALG_DATA_DEFS_TL SUBT

373: SUBT.DATA_CODE,
374: SUBT.OWNER_CODE,
375: SUBT.OWNER_TYPE_CODE,
376: SUBT.LANGUAGE
377: from IEC_O_ALG_DATA_DEFS_TL SUBB, IEC_O_ALG_DATA_DEFS_TL SUBT
378: where SUBB.DATA_CODE = SUBT.DATA_CODE
379: and SUBB.OWNER_CODE = SUBT.OWNER_CODE
380: and SUBB.OWNER_TYPE_CODE = SUBT.OWNER_TYPE_CODE
381: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 385: insert into IEC_O_ALG_DATA_DEFS_TL (

381: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
382: and (SUBB.NAME <> SUBT.NAME
383: ));
384:
385: insert into IEC_O_ALG_DATA_DEFS_TL (
386: DATA_CODE,
387: OWNER_CODE,
388: OWNER_TYPE_CODE,
389: NAME,

Line 411: from IEC_O_ALG_DATA_DEFS_TL B, FND_LANGUAGES L

407: B.LAST_UPDATE_LOGIN,
408: B.OBJECT_VERSION_NUMBER,
409: L.LANGUAGE_CODE,
410: B.SOURCE_LANG
411: from IEC_O_ALG_DATA_DEFS_TL B, FND_LANGUAGES L
412: where L.INSTALLED_FLAG in ('I', 'B')
413: and B.LANGUAGE = userenv('LANG')
414: and not exists
415: (select NULL

Line 416: from IEC_O_ALG_DATA_DEFS_TL T

412: where L.INSTALLED_FLAG in ('I', 'B')
413: and B.LANGUAGE = userenv('LANG')
414: and not exists
415: (select NULL
416: from IEC_O_ALG_DATA_DEFS_TL T
417: where T.DATA_CODE = B.DATA_CODE
418: and T.OWNER_CODE = B.OWNER_CODE
419: and T.OWNER_TYPE_CODE = B.OWNER_TYPE_CODE
420: and T.LANGUAGE = L.LANGUAGE_CODE);