APPS.ENG_CHANGE_LINES_PKG dependencies on ENG_CHANGE_LINES_TL

Line 93: insert into ENG_CHANGE_LINES_TL (

89: X_COMPLETE_BEFORE_STATUS_CODE,
90: X_START_AFTER_STATUS_CODE
91: );
92:
93: insert into ENG_CHANGE_LINES_TL (
94: CHANGE_LINE_ID,
95: CREATION_DATE,
96: CREATED_BY,
97: LAST_UPDATE_DATE,

Line 119: from ENG_CHANGE_LINES_TL T

115: from FND_LANGUAGES L
116: where L.INSTALLED_FLAG in ('I', 'B')
117: and not exists
118: (select NULL
119: from ENG_CHANGE_LINES_TL T
120: where T.CHANGE_LINE_ID = X_CHANGE_LINE_ID
121: and T.LANGUAGE = L.LANGUAGE_CODE);
122:
123: open c;

Line 187: from ENG_CHANGE_LINES_TL

183: cursor c1 is select
184: NAME,
185: DESCRIPTION,
186: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
187: from ENG_CHANGE_LINES_TL
188: where CHANGE_LINE_ID = X_CHANGE_LINE_ID
189: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
190: for update of CHANGE_LINE_ID nowait;
191: begin

Line 315: update ENG_CHANGE_LINES_TL set

311: if (sql%notfound) then
312: raise no_data_found;
313: end if;
314:
315: update ENG_CHANGE_LINES_TL set
316: NAME = X_NAME,
317: DESCRIPTION = X_DESCRIPTION,
318: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
319: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 334: delete from ENG_CHANGE_LINES_TL

330: procedure DELETE_ROW (
331: X_CHANGE_LINE_ID in NUMBER
332: ) is
333: begin
334: delete from ENG_CHANGE_LINES_TL
335: where CHANGE_LINE_ID = X_CHANGE_LINE_ID;
336:
337: if (sql%notfound) then
338: raise no_data_found;

Line 352: delete from ENG_CHANGE_LINES_TL T

348:
349: procedure ADD_LANGUAGE
350: is
351: begin
352: delete from ENG_CHANGE_LINES_TL T
353: where not exists
354: (select NULL
355: from ENG_CHANGE_LINES B
356: where B.CHANGE_LINE_ID = T.CHANGE_LINE_ID

Line 359: update ENG_CHANGE_LINES_TL T set (

355: from ENG_CHANGE_LINES B
356: where B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
357: );
358:
359: update ENG_CHANGE_LINES_TL T set (
360: NAME,
361: DESCRIPTION
362: ) = (select
363: B.NAME,

Line 365: from ENG_CHANGE_LINES_TL B

361: DESCRIPTION
362: ) = (select
363: B.NAME,
364: B.DESCRIPTION
365: from ENG_CHANGE_LINES_TL B
366: where B.CHANGE_LINE_ID = T.CHANGE_LINE_ID
367: and B.LANGUAGE = T.SOURCE_LANG)
368: where (
369: T.CHANGE_LINE_ID,

Line 374: from ENG_CHANGE_LINES_TL SUBB, ENG_CHANGE_LINES_TL SUBT

370: T.LANGUAGE
371: ) in (select
372: SUBT.CHANGE_LINE_ID,
373: SUBT.LANGUAGE
374: from ENG_CHANGE_LINES_TL SUBB, ENG_CHANGE_LINES_TL SUBT
375: where SUBB.CHANGE_LINE_ID = SUBT.CHANGE_LINE_ID
376: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
377: and (SUBB.NAME <> SUBT.NAME
378: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 383: insert into ENG_CHANGE_LINES_TL (

379: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
380: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
381: ));
382:
383: insert into ENG_CHANGE_LINES_TL (
384: CHANGE_LINE_ID,
385: CREATION_DATE,
386: CREATED_BY,
387: LAST_UPDATE_DATE,

Line 405: from ENG_CHANGE_LINES_TL B, FND_LANGUAGES L

401: B.NAME,
402: B.DESCRIPTION,
403: L.LANGUAGE_CODE,
404: B.SOURCE_LANG
405: from ENG_CHANGE_LINES_TL B, FND_LANGUAGES L
406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL

Line 410: from ENG_CHANGE_LINES_TL T

406: where L.INSTALLED_FLAG in ('I', 'B')
407: and B.LANGUAGE = userenv('LANG')
408: and not exists
409: (select NULL
410: from ENG_CHANGE_LINES_TL T
411: where T.CHANGE_LINE_ID = B.CHANGE_LINE_ID
412: and T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414: