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.IEX_CASES_PKG dependencies on IEX_CASES_TL

Line 147: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_case_All_b Insert and before iex_cases_tl insert');

143: X_ORG_ID,
144: decode( x_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, x_CLOSE_REASON));
145: -- IF PG_DEBUG < 10 THEN
146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_case_All_b Insert and before iex_cases_tl insert');
148: END IF;
149:
150: insert into IEX_CASES_TL (
151: CAS_ID,

Line 150: insert into IEX_CASES_TL (

146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_case_All_b Insert and before iex_cases_tl insert');
148: END IF;
149:
150: insert into IEX_CASES_TL (
151: CAS_ID,
152: COMMENTS,
153: CREATED_BY,
154: CREATION_DATE,

Line 176: from iex_cases_tl T

172: from FND_LANGUAGES L
173: where L.INSTALLED_FLAG in ('I', 'B')
174: and not exists
175: ( select NULL
176: from iex_cases_tl T
177: where T.cas_id = X_cas_id
178: and T.active_flag = X_active_flag
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:

Line 183: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_cases_tl insert');

179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_cases_tl insert');
184: END IF;
185: open c;
186: fetch c into X_ROWID;
187: -- IF PG_DEBUG < 10 THEN

Line 320: from IEX_CASES_TL

316: recinfo c%rowtype;
317:
318: cursor c1 is select Comments,
319: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
320: from IEX_CASES_TL
321: where CAS_ID = X_CAS_ID
322: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
323: for update of CAS_ID nowait;
324: begin

Line 504: update IEX_CASES_TL set

500: if (sql%notfound) then
501: raise no_data_found;
502: end if;
503:
504: update IEX_CASES_TL set
505: COMMENTS = decode( x_COMMENTS, FND_API.G_MISS_CHAR, COMMENTS, x_COMMENTS),
506: LAST_UPDATED_BY = decode( x_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, x_LAST_UPDATED_BY),
507: LAST_UPDATE_DATE = decode( x_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, x_LAST_UPDATE_DATE),
508: LAST_UPDATE_LOGIN = decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, x_LAST_UPDATE_LOGIN),

Line 530: delete from IEX_CASES_TL

526: -- IF PG_DEBUG < 10 THEN
527: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
528: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.DELETE_ROW ******** ');
529: END IF;
530: delete from IEX_CASES_TL
531: where CAS_ID = X_CAS_ID;
532:
533: if (sql%notfound) then
534: raise no_data_found;

Line 552: delete from IEX_CASES_TL T

548:
549: procedure ADD_LANGUAGE
550: is
551: begin
552: delete from IEX_CASES_TL T
553: where not exists
554: (select NULL
555: from IEX_CASES_ALL_B B
556: where B.CAS_ID = T.CAS_ID

Line 559: update IEX_CASES_TL T

555: from IEX_CASES_ALL_B B
556: where B.CAS_ID = T.CAS_ID
557: );
558:
559: update IEX_CASES_TL T
560: set (COMMENTS) =
561: (select B.COMMENTS
562: from IEX_CASES_TL B
563: where B.CAS_ID = T.CAS_ID

Line 562: from IEX_CASES_TL B

558:
559: update IEX_CASES_TL T
560: set (COMMENTS) =
561: (select B.COMMENTS
562: from IEX_CASES_TL B
563: where B.CAS_ID = T.CAS_ID
564: and B.LANGUAGE = T.SOURCE_LANG)
565: where (
566: T.CAS_ID,T.LANGUAGE

Line 570: from IEX_CASES_TL SUBB,

566: T.CAS_ID,T.LANGUAGE
567: ) in (select
568: SUBT.CAS_ID,
569: SUBT.LANGUAGE
570: from IEX_CASES_TL SUBB,
571: IEX_CASES_TL SUBT
572: where SUBB.CAS_ID = SUBT.CAS_ID
573: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
574: and SUBB.COMMENTS<> SUBT.COMMENTS

Line 571: IEX_CASES_TL SUBT

567: ) in (select
568: SUBT.CAS_ID,
569: SUBT.LANGUAGE
570: from IEX_CASES_TL SUBB,
571: IEX_CASES_TL SUBT
572: where SUBB.CAS_ID = SUBT.CAS_ID
573: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
574: and SUBB.COMMENTS<> SUBT.COMMENTS
575: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)

Line 579: insert into IEX_CASES_TL (

575: OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
576: OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
577: );
578:
579: insert into IEX_CASES_TL (
580: CAS_ID,
581: COMMENTS,
582: LAST_UPDATE_DATE,
583: LAST_UPDATED_BY,

Line 601: from IEX_CASES_TL B, FND_LANGUAGES L

597: B.LAST_UPDATE_LOGIN,
598: L.LANGUAGE_CODE,
599: B.SOURCE_LANG,
600: B.ACTIVE_FLAG
601: from IEX_CASES_TL B, FND_LANGUAGES L
602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL

Line 606: from IEX_CASES_TL T

602: where L.INSTALLED_FLAG in ('I', 'B')
603: and B.LANGUAGE = userenv('LANG')
604: and not exists
605: (select NULL
606: from IEX_CASES_TL T
607: where T.CAS_ID = B.CAS_ID
608: and T.LANGUAGE = L.LANGUAGE_CODE);
609:
610: end ADD_LANGUAGE;

Line 621: UPDATE IEX_CASES_tl SET

617: X_OWNER in VARCHAR2
618: ) IS
619:
620: begin
621: UPDATE IEX_CASES_tl SET
622: comments=X_COMMENTS,
623: last_update_date = sysdate,
624: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
625: last_update_login = 0,