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_LINES_PKG dependencies on ENG_CHANGE_LINES

Line 1: package body ENG_CHANGE_LINES_PKG as

1: package body ENG_CHANGE_LINES_PKG as
2: /* $Header: ENGCHLUB.pls 115.8 2003/11/22 18:59:27 sshrikha ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_CHANGE_LINE_ID in NUMBER,

Line 36: cursor C is select ROWID from ENG_CHANGE_LINES

32: X_COMPLETE_BEFORE_STATUS_CODE IN NUMBER,
33: X_START_AFTER_STATUS_CODE IN NUMBER
34:
35: ) is
36: cursor C is select ROWID from ENG_CHANGE_LINES
37: where CHANGE_LINE_ID = X_CHANGE_LINE_ID
38: ;
39: begin
40: insert into ENG_CHANGE_LINES (

Line 40: insert into ENG_CHANGE_LINES (

36: cursor C is select ROWID from ENG_CHANGE_LINES
37: where CHANGE_LINE_ID = X_CHANGE_LINE_ID
38: ;
39: begin
40: insert into ENG_CHANGE_LINES (
41: CHANGE_LINE_ID,
42: REQUEST_ID,
43: CHANGE_ID,
44: SEQUENCE_NUMBER,

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 178: from ENG_CHANGE_LINES

174: ROUTE_ID,
175: REQUIRED_FLAG,
176: COMPLETE_BEFORE_STATUS_CODE,
177: START_AFTER_STATUS_CODE
178: from ENG_CHANGE_LINES
179: where CHANGE_LINE_ID = X_CHANGE_LINE_ID
180: for update of CHANGE_LINE_ID nowait;
181: recinfo c%rowtype;
182:

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 287: update ENG_CHANGE_LINES set

283: X_START_AFTER_STATUS_CODE IN NUMBER
284:
285: ) is
286: begin
287: update ENG_CHANGE_LINES set
288: REQUEST_ID = X_REQUEST_ID,
289: CHANGE_ID = X_CHANGE_ID,
290: SEQUENCE_NUMBER = X_SEQUENCE_NUMBER,
291: CHANGE_TYPE_ID = X_CHANGE_TYPE_ID,

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 341: delete from ENG_CHANGE_LINES

337: if (sql%notfound) then
338: raise no_data_found;
339: end if;
340:
341: delete from ENG_CHANGE_LINES
342: where CHANGE_LINE_ID = X_CHANGE_LINE_ID;
343:
344: if (sql%notfound) then
345: 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 355: from ENG_CHANGE_LINES B

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
357: );
358:
359: update ENG_CHANGE_LINES_TL T set (

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:

Line 415: end ENG_CHANGE_LINES_PKG;

411: where T.CHANGE_LINE_ID = B.CHANGE_LINE_ID
412: and T.LANGUAGE = L.LANGUAGE_CODE);
413: end ADD_LANGUAGE;
414:
415: end ENG_CHANGE_LINES_PKG;