APPS.ENG_CHANGE_STATUSES_PKG dependencies on ENG_CHANGE_STATUSES_TL

Line 59: insert into ENG_CHANGE_STATUSES_TL (

55: X_STATUS_TYPE,
56: l_object_name
57: );
58:
59: insert into ENG_CHANGE_STATUSES_TL (
60: CREATION_DATE,
61: CREATED_BY,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,

Line 85: from ENG_CHANGE_STATUSES_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from ENG_CHANGE_STATUSES_TL T
86: where T.STATUS_CODE = X_STATUS_CODE
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88:
89: open c;

Line 124: from ENG_CHANGE_STATUSES_TL

120: cursor c1 is select
121: STATUS_NAME,
122: DESCRIPTION,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from ENG_CHANGE_STATUSES_TL
125: where STATUS_CODE = X_STATUS_CODE
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of STATUS_CODE nowait;
128: begin

Line 218: update ENG_CHANGE_STATUSES_TL set

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: update ENG_CHANGE_STATUSES_TL set
219: STATUS_NAME = X_STATUS_NAME,
220: DESCRIPTION = X_DESCRIPTION,
221: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
222: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 237: delete from ENG_CHANGE_STATUSES_TL

233: procedure DELETE_ROW (
234: X_STATUS_CODE in NUMBER
235: ) is
236: begin
237: delete from ENG_CHANGE_STATUSES_TL
238: where STATUS_CODE = X_STATUS_CODE;
239:
240: if (sql%notfound) then
241: raise no_data_found;

Line 255: delete from ENG_CHANGE_STATUSES_TL T

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

Line 262: update ENG_CHANGE_STATUSES_TL T set (

258: from ENG_CHANGE_STATUSES B
259: where B.STATUS_CODE = T.STATUS_CODE
260: );
261:
262: update ENG_CHANGE_STATUSES_TL T set (
263: STATUS_NAME,
264: DESCRIPTION
265: ) = (select
266: B.STATUS_NAME,

Line 268: from ENG_CHANGE_STATUSES_TL B

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

Line 277: from ENG_CHANGE_STATUSES_TL SUBB, ENG_CHANGE_STATUSES_TL SUBT

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

Line 286: insert into ENG_CHANGE_STATUSES_TL (

282: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
283: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
284: ));
285:
286: insert into ENG_CHANGE_STATUSES_TL (
287: CREATION_DATE,
288: CREATED_BY,
289: LAST_UPDATE_DATE,
290: LAST_UPDATED_BY,

Line 308: from ENG_CHANGE_STATUSES_TL B, FND_LANGUAGES L

304: B.DESCRIPTION,
305: B.STATUS_CODE,
306: L.LANGUAGE_CODE,
307: B.SOURCE_LANG
308: from ENG_CHANGE_STATUSES_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 ENG_CHANGE_STATUSES_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 ENG_CHANGE_STATUSES_TL T
314: where T.STATUS_CODE = B.STATUS_CODE
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317: