APPS.IEC_O_ALG_ACTION_DEFS_PKG dependencies on IEC_O_ALG_ACTION_DEFS_TL

Line 40: insert into IEC_O_ALG_ACTION_DEFS_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into IEC_O_ALG_ACTION_DEFS_TL (
41: ACTION_CODE,
42: DESCRIPTION,
43: SUBST_TEXT,
44: CREATED_BY,

Line 68: from IEC_O_ALG_ACTION_DEFS_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from IEC_O_ALG_ACTION_DEFS_TL T
69: where T.ACTION_CODE = X_ACTION_CODE
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 100: from IEC_O_ALG_ACTION_DEFS_TL

96: cursor c1 is select
97: DESCRIPTION,
98: SUBST_TEXT,
99: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
100: from IEC_O_ALG_ACTION_DEFS_TL
101: where ACTION_CODE = X_ACTION_CODE
102: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
103: for update of ACTION_CODE nowait;
104: begin

Line 158: update IEC_O_ALG_ACTION_DEFS_TL set

154: if (sql%notfound) then
155: raise no_data_found;
156: end if;
157:
158: update IEC_O_ALG_ACTION_DEFS_TL set
159: DESCRIPTION = X_DESCRIPTION,
160: SUBST_TEXT = X_SUBST_TEXT,
161: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
162: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 221: UPDATE iec_o_alg_action_defs_tl SET

217: X_DESCRIPTION in VARCHAR2,
218: X_SUBST_TEXT in VARCHAR2,
219: P_OWNER IN VARCHAR2)is
220: BEGIN
221: UPDATE iec_o_alg_action_defs_tl SET
222: source_lang = userenv('LANG'),
223: DESCRIPTION = X_DESCRIPTION,
224: SUBST_TEXT = X_SUBST_TEXT ,
225: last_update_date = sysdate,

Line 237: delete from IEC_O_ALG_ACTION_DEFS_TL

233: procedure DELETE_ROW (
234: X_ACTION_CODE in VARCHAR2
235: ) is
236: begin
237: delete from IEC_O_ALG_ACTION_DEFS_TL
238: where ACTION_CODE = X_ACTION_CODE;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 255: delete from IEC_O_ALG_ACTION_DEFS_TL T

251:
252: procedure ADD_LANGUAGE
253: is
254: begin
255: delete from IEC_O_ALG_ACTION_DEFS_TL T
256: where not exists
257: (select NULL
258: from IEC_O_ALG_ACTION_DEFS_B B
259: where B.ACTION_CODE = T.ACTION_CODE

Line 262: update IEC_O_ALG_ACTION_DEFS_TL T set (

258: from IEC_O_ALG_ACTION_DEFS_B B
259: where B.ACTION_CODE = T.ACTION_CODE
260: );
261:
262: update IEC_O_ALG_ACTION_DEFS_TL T set (
263: DESCRIPTION,
264: SUBST_TEXT
265: ) = (select
266: B.DESCRIPTION,

Line 268: from IEC_O_ALG_ACTION_DEFS_TL B

264: SUBST_TEXT
265: ) = (select
266: B.DESCRIPTION,
267: B.SUBST_TEXT
268: from IEC_O_ALG_ACTION_DEFS_TL B
269: where B.ACTION_CODE = T.ACTION_CODE
270: and B.LANGUAGE = T.SOURCE_LANG)
271: where (
272: T.ACTION_CODE,

Line 277: from IEC_O_ALG_ACTION_DEFS_TL SUBB, IEC_O_ALG_ACTION_DEFS_TL SUBT

273: T.LANGUAGE
274: ) in (select
275: SUBT.ACTION_CODE,
276: SUBT.LANGUAGE
277: from IEC_O_ALG_ACTION_DEFS_TL SUBB, IEC_O_ALG_ACTION_DEFS_TL SUBT
278: where SUBB.ACTION_CODE = SUBT.ACTION_CODE
279: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
280: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
281: or SUBB.SUBST_TEXT <> SUBT.SUBST_TEXT

Line 284: insert into IEC_O_ALG_ACTION_DEFS_TL (

280: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
281: or SUBB.SUBST_TEXT <> SUBT.SUBST_TEXT
282: ));
283:
284: insert into IEC_O_ALG_ACTION_DEFS_TL (
285: ACTION_CODE,
286: DESCRIPTION,
287: SUBST_TEXT,
288: CREATED_BY,

Line 308: from IEC_O_ALG_ACTION_DEFS_TL B, FND_LANGUAGES L

304: B.LAST_UPDATE_LOGIN,
305: B.OBJECT_VERSION_NUMBER,
306: L.LANGUAGE_CODE,
307: B.SOURCE_LANG
308: from IEC_O_ALG_ACTION_DEFS_TL B, FND_LANGUAGES L
309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL

Line 313: from IEC_O_ALG_ACTION_DEFS_TL T

309: where L.INSTALLED_FLAG in ('I', 'B')
310: and B.LANGUAGE = userenv('LANG')
311: and not exists
312: (select NULL
313: from IEC_O_ALG_ACTION_DEFS_TL T
314: where T.ACTION_CODE = B.ACTION_CODE
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317: