eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_CHANGE_STATUSES_PKG dependencies on ENG_CHANGE_STATUSES

Line 1: package body ENG_CHANGE_STATUSES_PKG as

1: package body ENG_CHANGE_STATUSES_PKG as
2: /* $Header: ENGUSTSB.pls 120.1 2006/01/30 02:38:20 pdutta noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_STATUS_CODE in NUMBER,

Line 20: cursor C is select ROWID from ENG_CHANGE_STATUSES

16: X_STATUS_TYPE in NUMBER,
17: X_OBJECT_NAME in VARCHAR2)
18: is
19: l_object_name VARCHAR2(30);
20: cursor C is select ROWID from ENG_CHANGE_STATUSES
21: where STATUS_CODE = X_STATUS_CODE
22: ;
23: begin
24: l_object_name := substr(X_OBJECT_NAME, 1, 30);

Line 33: insert into ENG_CHANGE_STATUSES (

29: THEN
30: l_object_name := 'DOM_DOCUMENT_REVISION';
31: END IF;
32:
33: insert into ENG_CHANGE_STATUSES (
34: STATUS_CODE,
35: SORT_SEQUENCE_NUM,
36: DISABLE_DATE,
37: SEEDED_FLAG,

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 115: from ENG_CHANGE_STATUSES

111: SORT_SEQUENCE_NUM,
112: DISABLE_DATE,
113: SEEDED_FLAG,
114: OBJECT_NAME
115: from ENG_CHANGE_STATUSES
116: where STATUS_CODE = X_STATUS_CODE
117: for update of STATUS_CODE nowait;
118: recinfo c%rowtype;
119:

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 203: update ENG_CHANGE_STATUSES set

199: THEN
200: l_object_name := 'DOM_DOCUMENT_REVISION';
201: END IF;
202:
203: update ENG_CHANGE_STATUSES set
204: SORT_SEQUENCE_NUM = X_SORT_SEQUENCE_NUM,
205: DISABLE_DATE = X_DISABLE_DATE,
206: SEEDED_FLAG = X_SEEDED_FLAG,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

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 244: delete from ENG_CHANGE_STATUSES

240: if (sql%notfound) then
241: raise no_data_found;
242: end if;
243:
244: delete from ENG_CHANGE_STATUSES
245: where STATUS_CODE = X_STATUS_CODE;
246:
247: if (sql%notfound) then
248: 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 258: from ENG_CHANGE_STATUSES B

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
260: );
261:
262: update ENG_CHANGE_STATUSES_TL T set (

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:

Line 318: end ENG_CHANGE_STATUSES_PKG;

314: where T.STATUS_CODE = B.STATUS_CODE
315: and T.LANGUAGE = L.LANGUAGE_CODE);
316: end ADD_LANGUAGE;
317:
318: end ENG_CHANGE_STATUSES_PKG;