APPS.IEC_O_ALG_OP_DEFS_PKG dependencies on IEC_O_ALG_OP_DEFS_TL

Line 42: insert into IEC_O_ALG_OP_DEFS_TL (

38: X_LAST_UPDATED_BY,
39: X_LAST_UPDATE_LOGIN
40: );
41:
42: insert into IEC_O_ALG_OP_DEFS_TL (
43: OBJECT_VERSION_NUMBER,
44: CREATED_BY,
45: CREATION_DATE,
46: LAST_UPDATED_BY,

Line 68: from IEC_O_ALG_OP_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_OP_DEFS_TL T
69: where T.OPERATOR_CODE = X_OPERATOR_CODE
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 101: from IEC_O_ALG_OP_DEFS_TL

97:
98: cursor c1 is select
99: NAME,
100: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
101: from IEC_O_ALG_OP_DEFS_TL
102: where OPERATOR_CODE = X_OPERATOR_CODE
103: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
104: for update of OPERATOR_CODE nowait;
105: begin

Line 163: update IEC_O_ALG_OP_DEFS_TL set

159: if (sql%notfound) then
160: raise no_data_found;
161: end if;
162:
163: update IEC_O_ALG_OP_DEFS_TL set
164: NAME = X_NAME,
165: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
166: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
167: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 181: delete from IEC_O_ALG_OP_DEFS_TL

177: procedure DELETE_ROW (
178: X_OPERATOR_CODE in VARCHAR2
179: ) is
180: begin
181: delete from IEC_O_ALG_OP_DEFS_TL
182: where OPERATOR_CODE = X_OPERATOR_CODE;
183:
184: if (sql%notfound) then
185: raise no_data_found;

Line 199: delete from IEC_O_ALG_OP_DEFS_TL T

195:
196: procedure ADD_LANGUAGE
197: is
198: begin
199: delete from IEC_O_ALG_OP_DEFS_TL T
200: where not exists
201: (select NULL
202: from IEC_O_ALG_OP_DEFS_B B
203: where B.OPERATOR_CODE = T.OPERATOR_CODE

Line 206: update IEC_O_ALG_OP_DEFS_TL T set (

202: from IEC_O_ALG_OP_DEFS_B B
203: where B.OPERATOR_CODE = T.OPERATOR_CODE
204: );
205:
206: update IEC_O_ALG_OP_DEFS_TL T set (
207: NAME
208: ) = (select
209: B.NAME
210: from IEC_O_ALG_OP_DEFS_TL B

Line 210: from IEC_O_ALG_OP_DEFS_TL B

206: update IEC_O_ALG_OP_DEFS_TL T set (
207: NAME
208: ) = (select
209: B.NAME
210: from IEC_O_ALG_OP_DEFS_TL B
211: where B.OPERATOR_CODE = T.OPERATOR_CODE
212: and B.LANGUAGE = T.SOURCE_LANG)
213: where (
214: T.OPERATOR_CODE,

Line 219: from IEC_O_ALG_OP_DEFS_TL SUBB, IEC_O_ALG_OP_DEFS_TL SUBT

215: T.LANGUAGE
216: ) in (select
217: SUBT.OPERATOR_CODE,
218: SUBT.LANGUAGE
219: from IEC_O_ALG_OP_DEFS_TL SUBB, IEC_O_ALG_OP_DEFS_TL SUBT
220: where SUBB.OPERATOR_CODE = SUBT.OPERATOR_CODE
221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.NAME <> SUBT.NAME
223: ));

Line 225: insert into IEC_O_ALG_OP_DEFS_TL (

221: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
222: and (SUBB.NAME <> SUBT.NAME
223: ));
224:
225: insert into IEC_O_ALG_OP_DEFS_TL (
226: OBJECT_VERSION_NUMBER,
227: CREATED_BY,
228: CREATION_DATE,
229: LAST_UPDATED_BY,

Line 247: from IEC_O_ALG_OP_DEFS_TL B, FND_LANGUAGES L

243: B.OPERATOR_CODE,
244: B.NAME,
245: L.LANGUAGE_CODE,
246: B.SOURCE_LANG
247: from IEC_O_ALG_OP_DEFS_TL B, FND_LANGUAGES L
248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL

Line 252: from IEC_O_ALG_OP_DEFS_TL T

248: where L.INSTALLED_FLAG in ('I', 'B')
249: and B.LANGUAGE = userenv('LANG')
250: and not exists
251: (select NULL
252: from IEC_O_ALG_OP_DEFS_TL T
253: where T.OPERATOR_CODE = B.OPERATOR_CODE
254: and T.LANGUAGE = L.LANGUAGE_CODE);
255: end ADD_LANGUAGE;
256:

Line 314: update IEC_O_ALG_OP_DEFS_TL set

310: begin
311:
312: -- only UPDATE rows that have not been altered by user
313:
314: update IEC_O_ALG_OP_DEFS_TL set
315: NAME = X_NAME,
316: SOURCE_LANG = userenv('LANG'),
317: LAST_UPDATE_DATE = SYSDATE,
318: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),