APPS.IEC_O_ALG_EXPR_DEFS_PKG dependencies on IEC_O_ALG_EXPR_DEFS_TL

Line 37: insert into IEC_O_ALG_EXPR_DEFS_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into IEC_O_ALG_EXPR_DEFS_TL (
38: EXPR_CODE,
39: DESCRIPTION,
40: SUBST_TEXT,
41: CREATED_BY,

Line 65: from IEC_O_ALG_EXPR_DEFS_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from IEC_O_ALG_EXPR_DEFS_TL T
66: where T.EXPR_CODE = X_EXPR_CODE
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 96: from IEC_O_ALG_EXPR_DEFS_TL

92: cursor c1 is select
93: DESCRIPTION,
94: SUBST_TEXT,
95: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
96: from IEC_O_ALG_EXPR_DEFS_TL
97: where EXPR_CODE = X_EXPR_CODE
98: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
99: for update of EXPR_CODE nowait;
100: begin

Line 152: update IEC_O_ALG_EXPR_DEFS_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update IEC_O_ALG_EXPR_DEFS_TL set
153: DESCRIPTION = X_DESCRIPTION,
154: SUBST_TEXT = X_SUBST_TEXT,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from IEC_O_ALG_EXPR_DEFS_TL

167: procedure DELETE_ROW (
168: X_EXPR_CODE in VARCHAR2
169: ) is
170: begin
171: delete from IEC_O_ALG_EXPR_DEFS_TL
172: where EXPR_CODE = X_EXPR_CODE;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 189: delete from IEC_O_ALG_EXPR_DEFS_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from IEC_O_ALG_EXPR_DEFS_TL T
190: where not exists
191: (select NULL
192: from IEC_O_ALG_EXPR_DEFS_B B
193: where B.EXPR_CODE = T.EXPR_CODE

Line 196: update IEC_O_ALG_EXPR_DEFS_TL T set (

192: from IEC_O_ALG_EXPR_DEFS_B B
193: where B.EXPR_CODE = T.EXPR_CODE
194: );
195:
196: update IEC_O_ALG_EXPR_DEFS_TL T set (
197: DESCRIPTION,
198: SUBST_TEXT
199: ) = (select
200: B.DESCRIPTION,

Line 202: from IEC_O_ALG_EXPR_DEFS_TL B

198: SUBST_TEXT
199: ) = (select
200: B.DESCRIPTION,
201: B.SUBST_TEXT
202: from IEC_O_ALG_EXPR_DEFS_TL B
203: where B.EXPR_CODE = T.EXPR_CODE
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.EXPR_CODE,

Line 211: from IEC_O_ALG_EXPR_DEFS_TL SUBB, IEC_O_ALG_EXPR_DEFS_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.EXPR_CODE,
210: SUBT.LANGUAGE
211: from IEC_O_ALG_EXPR_DEFS_TL SUBB, IEC_O_ALG_EXPR_DEFS_TL SUBT
212: where SUBB.EXPR_CODE = SUBT.EXPR_CODE
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
215: or SUBB.SUBST_TEXT <> SUBT.SUBST_TEXT

Line 218: insert into IEC_O_ALG_EXPR_DEFS_TL (

214: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
215: or SUBB.SUBST_TEXT <> SUBT.SUBST_TEXT
216: ));
217:
218: insert into IEC_O_ALG_EXPR_DEFS_TL (
219: EXPR_CODE,
220: DESCRIPTION,
221: SUBST_TEXT,
222: CREATED_BY,

Line 242: from IEC_O_ALG_EXPR_DEFS_TL B, FND_LANGUAGES L

238: B.LAST_UPDATE_LOGIN,
239: B.OBJECT_VERSION_NUMBER,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from IEC_O_ALG_EXPR_DEFS_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from IEC_O_ALG_EXPR_DEFS_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from IEC_O_ALG_EXPR_DEFS_TL T
248: where T.EXPR_CODE = B.EXPR_CODE
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 307: update IEC_O_ALG_EXPR_DEFS_TL set

303: begin
304:
305: -- only UPDATE rows that have not been altered by user
306:
307: update IEC_O_ALG_EXPR_DEFS_TL set
308: DESCRIPTION = X_DESCRIPTION,
309: SUBST_TEXT = X_SUBST_TEXT,
310: SOURCE_LANG = userenv('LANG'),
311: LAST_UPDATE_DATE = SYSDATE,