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_ACTIONS_PKG dependencies on ENG_CHANGE_ACTIONS

Line 1: package body ENG_CHANGE_ACTIONS_PKG as

1: package body ENG_CHANGE_ACTIONS_PKG as
2: /* $Header: ENGUCAMB.pls 120.3 2005/12/22 04:23:17 lkasturi noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 38: cursor C is select ROWID from ENG_CHANGE_ACTIONS

34: X_LAST_UPDATE_LOGIN in NUMBER,
35: X_IMPLEMENTATION_REQ_ID in NUMBER DEFAULT NULL,
36: X_LOCAL_ORGANIZATION_ID in NUMBER DEFAULT NULL -- Bug 4704384
37: ) is
38: cursor C is select ROWID from ENG_CHANGE_ACTIONS
39: where ACTION_ID = X_ACTION_ID;
40: begin
41: insert into ENG_CHANGE_ACTIONS (
42: ORIGINAL_SYSTEM_REFERENCE,

Line 41: insert into ENG_CHANGE_ACTIONS (

37: ) is
38: cursor C is select ROWID from ENG_CHANGE_ACTIONS
39: where ACTION_ID = X_ACTION_ID;
40: begin
41: insert into ENG_CHANGE_ACTIONS (
42: ORIGINAL_SYSTEM_REFERENCE,
43: WORKFLOW_ITEM_KEY,
44: REQUEST_ID,
45: STATUS_CODE,

Line 105: insert into ENG_CHANGE_ACTIONS_TL (

101: X_IMPLEMENTATION_REQ_ID,
102: X_LOCAL_ORGANIZATION_ID -- Bug 4704384
103: );
104:
105: insert into ENG_CHANGE_ACTIONS_TL (
106: LAST_UPDATED_BY,
107: LAST_UPDATE_LOGIN,
108: LAST_UPDATE_DATE,
109: CREATED_BY,

Line 129: from ENG_CHANGE_ACTIONS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from ENG_CHANGE_ACTIONS_TL T
130: where T.ACTION_ID = X_ACTION_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 207: from ENG_CHANGE_ACTIONS

203: PROGRAM_APPLICATION_ID,
204: PROGRAM_UPDATE_DATE,
205: IMPLEMENTATION_REQ_ID,
206: LOCAL_ORGANIZATION_ID
207: from ENG_CHANGE_ACTIONS
208: where ACTION_ID = X_ACTION_ID
209: for update of ACTION_ID nowait;
210: recinfo c%rowtype;
211:

Line 215: from ENG_CHANGE_ACTIONS_TL

211:
212: cursor c1 is select
213: DESCRIPTION,
214: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
215: from ENG_CHANGE_ACTIONS_TL
216: where ACTION_ID = X_ACTION_ID
217: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
218: for update of ACTION_ID nowait;
219: begin

Line 330: update ENG_CHANGE_ACTIONS set

326: X_LOCAL_ORGANIZATION_ID in NUMBER DEFAULT NULL -- Bug 4704384
327:
328: ) is
329: begin
330: update ENG_CHANGE_ACTIONS set
331: ORIGINAL_SYSTEM_REFERENCE = X_ORIGINAL_SYSTEM_REFERENCE,
332: WORKFLOW_ITEM_KEY = X_WORKFLOW_ITEM_KEY,
333: REQUEST_ID = X_REQUEST_ID,
334: STATUS_CODE = X_STATUS_CODE,

Line 364: update ENG_CHANGE_ACTIONS_TL set

360: if (sql%notfound) then
361: raise no_data_found;
362: end if;
363:
364: update ENG_CHANGE_ACTIONS_TL set
365: DESCRIPTION = X_DESCRIPTION,
366: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
367: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
368: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 382: delete from ENG_CHANGE_ACTIONS_TL

378: procedure DELETE_ROW (
379: X_ACTION_ID in NUMBER
380: ) is
381: begin
382: delete from ENG_CHANGE_ACTIONS_TL
383: where ACTION_ID = X_ACTION_ID;
384:
385: if (sql%notfound) then
386: raise no_data_found;

Line 389: delete from ENG_CHANGE_ACTIONS

385: if (sql%notfound) then
386: raise no_data_found;
387: end if;
388:
389: delete from ENG_CHANGE_ACTIONS
390: where ACTION_ID = X_ACTION_ID;
391:
392: if (sql%notfound) then
393: raise no_data_found;

Line 400: delete from ENG_CHANGE_ACTIONS_TL T

396:
397: procedure ADD_LANGUAGE
398: is
399: begin
400: delete from ENG_CHANGE_ACTIONS_TL T
401: where not exists
402: (select NULL
403: from ENG_CHANGE_ACTIONS B
404: where B.ACTION_ID = T.ACTION_ID

Line 403: from ENG_CHANGE_ACTIONS B

399: begin
400: delete from ENG_CHANGE_ACTIONS_TL T
401: where not exists
402: (select NULL
403: from ENG_CHANGE_ACTIONS B
404: where B.ACTION_ID = T.ACTION_ID
405: );
406:
407: update ENG_CHANGE_ACTIONS_TL T set (

Line 407: update ENG_CHANGE_ACTIONS_TL T set (

403: from ENG_CHANGE_ACTIONS B
404: where B.ACTION_ID = T.ACTION_ID
405: );
406:
407: update ENG_CHANGE_ACTIONS_TL T set (
408: DESCRIPTION
409: ) = (select
410: B.DESCRIPTION
411: from ENG_CHANGE_ACTIONS_TL B

Line 411: from ENG_CHANGE_ACTIONS_TL B

407: update ENG_CHANGE_ACTIONS_TL T set (
408: DESCRIPTION
409: ) = (select
410: B.DESCRIPTION
411: from ENG_CHANGE_ACTIONS_TL B
412: where B.ACTION_ID = T.ACTION_ID
413: and B.LANGUAGE = T.SOURCE_LANG)
414: where (
415: T.ACTION_ID,

Line 420: from ENG_CHANGE_ACTIONS_TL SUBB, ENG_CHANGE_ACTIONS_TL SUBT

416: T.LANGUAGE
417: ) in (select
418: SUBT.ACTION_ID,
419: SUBT.LANGUAGE
420: from ENG_CHANGE_ACTIONS_TL SUBB, ENG_CHANGE_ACTIONS_TL SUBT
421: where SUBB.ACTION_ID = SUBT.ACTION_ID
422: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
423: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
424: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 428: insert into ENG_CHANGE_ACTIONS_TL (

424: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
425: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
426: ));
427:
428: insert into ENG_CHANGE_ACTIONS_TL (
429: LAST_UPDATED_BY,
430: LAST_UPDATE_LOGIN,
431: LAST_UPDATE_DATE,
432: CREATED_BY,

Line 448: from ENG_CHANGE_ACTIONS_TL B, FND_LANGUAGES L

444: B.CREATION_DATE,
445: B.ACTION_ID,
446: L.LANGUAGE_CODE,
447: B.SOURCE_LANG
448: from ENG_CHANGE_ACTIONS_TL B, FND_LANGUAGES L
449: where L.INSTALLED_FLAG in ('I', 'B')
450: and B.LANGUAGE = userenv('LANG')
451: and not exists
452: (select NULL

Line 453: from ENG_CHANGE_ACTIONS_TL T

449: where L.INSTALLED_FLAG in ('I', 'B')
450: and B.LANGUAGE = userenv('LANG')
451: and not exists
452: (select NULL
453: from ENG_CHANGE_ACTIONS_TL T
454: where T.ACTION_ID = B.ACTION_ID
455: and T.LANGUAGE = L.LANGUAGE_CODE);
456: end ADD_LANGUAGE;
457:

Line 459: end ENG_CHANGE_ACTIONS_PKG;

455: and T.LANGUAGE = L.LANGUAGE_CODE);
456: end ADD_LANGUAGE;
457:
458:
459: end ENG_CHANGE_ACTIONS_PKG;