APPS.ENG_CHANGE_LOGS_PKG dependencies on ENG_CHANGE_LOGS_TL

Line 63: insert into ENG_CHANGE_LOGS_TL (

59: X_LAST_UPDATE_LOGIN,
60: X_CHANGE_PROPAGATION_MAP_ID
61: );
62:
63: insert into ENG_CHANGE_LOGS_TL (
64: CHANGE_LOG_ID,
65: LOG_TEXT,
66: CREATION_DATE,
67: CREATED_BY,

Line 87: from ENG_CHANGE_LOGS_TL T

83: from FND_LANGUAGES L
84: where L.INSTALLED_FLAG in ('I', 'B')
85: and not exists
86: (select NULL
87: from ENG_CHANGE_LOGS_TL T
88: where T.CHANGE_LOG_ID = X_CHANGE_LOG_ID
89: and T.LANGUAGE = L.LANGUAGE_CODE);
90:
91: open c;

Line 134: from ENG_CHANGE_LOGS_TL

130:
131: cursor c1 is select
132: LOG_TEXT,
133: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
134: from ENG_CHANGE_LOGS_TL
135: where CHANGE_LOG_ID = X_CHANGE_LOG_ID
136: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
137: for update of CHANGE_LOG_ID nowait;
138: begin

Line 226: update ENG_CHANGE_LOGS_TL set

222: if (sql%notfound) then
223: raise no_data_found;
224: end if;
225:
226: update ENG_CHANGE_LOGS_TL set
227: LOG_TEXT = X_LOG_TEXT,
228: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
229: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
230: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 244: delete from ENG_CHANGE_LOGS_TL

240: procedure DELETE_ROW (
241: X_CHANGE_LOG_ID in NUMBER
242: ) is
243: begin
244: delete from ENG_CHANGE_LOGS_TL
245: where CHANGE_LOG_ID = X_CHANGE_LOG_ID;
246:
247: if (sql%notfound) then
248: raise no_data_found;

Line 262: delete from ENG_CHANGE_LOGS_TL T

258:
259: procedure ADD_LANGUAGE
260: is
261: begin
262: delete from ENG_CHANGE_LOGS_TL T
263: where not exists
264: (select NULL
265: from ENG_CHANGE_LOGS_B B
266: where B.CHANGE_LOG_ID = T.CHANGE_LOG_ID

Line 269: update ENG_CHANGE_LOGS_TL T set (

265: from ENG_CHANGE_LOGS_B B
266: where B.CHANGE_LOG_ID = T.CHANGE_LOG_ID
267: );
268:
269: update ENG_CHANGE_LOGS_TL T set (
270: LOG_TEXT
271: ) = (select
272: B.LOG_TEXT
273: from ENG_CHANGE_LOGS_TL B

Line 273: from ENG_CHANGE_LOGS_TL B

269: update ENG_CHANGE_LOGS_TL T set (
270: LOG_TEXT
271: ) = (select
272: B.LOG_TEXT
273: from ENG_CHANGE_LOGS_TL B
274: where B.CHANGE_LOG_ID = T.CHANGE_LOG_ID
275: and B.LANGUAGE = T.SOURCE_LANG)
276: where (
277: T.CHANGE_LOG_ID,

Line 282: from ENG_CHANGE_LOGS_TL SUBB, ENG_CHANGE_LOGS_TL SUBT

278: T.LANGUAGE
279: ) in (select
280: SUBT.CHANGE_LOG_ID,
281: SUBT.LANGUAGE
282: from ENG_CHANGE_LOGS_TL SUBB, ENG_CHANGE_LOGS_TL SUBT
283: where SUBB.CHANGE_LOG_ID = SUBT.CHANGE_LOG_ID
284: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
285: and (SUBB.LOG_TEXT <> SUBT.LOG_TEXT
286: or (SUBB.LOG_TEXT is null and SUBT.LOG_TEXT is not null)

Line 290: insert into ENG_CHANGE_LOGS_TL (

286: or (SUBB.LOG_TEXT is null and SUBT.LOG_TEXT is not null)
287: or (SUBB.LOG_TEXT is not null and SUBT.LOG_TEXT is null)
288: ));
289:
290: insert into ENG_CHANGE_LOGS_TL (
291: CHANGE_LOG_ID,
292: LOG_TEXT,
293: CREATION_DATE,
294: CREATED_BY,

Line 310: from ENG_CHANGE_LOGS_TL B, FND_LANGUAGES L

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

Line 315: from ENG_CHANGE_LOGS_TL T

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