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.OKE_CHG_STATUSES_PKG dependencies on OKE_CHG_STATUSES_TL

Line 100: insert into OKE_CHG_STATUSES_TL (

96: , X_ATTRIBUTE14
97: , X_ATTRIBUTE15
98: );
99:
100: insert into OKE_CHG_STATUSES_TL (
101: CHG_STATUS_CODE
102: , LANGUAGE
103: , CREATION_DATE
104: , CREATED_BY

Line 126: from OKE_CHG_STATUSES_TL T

122: from FND_LANGUAGES L
123: where L.INSTALLED_FLAG in ('I', 'B')
124: and not exists
125: (select NULL
126: from OKE_CHG_STATUSES_TL T
127: where T.CHG_STATUS_CODE = X_CHG_STATUS_CODE
128: and T.LANGUAGE = L.LANGUAGE_CODE)
129: ;
130:

Line 201: from OKE_CHG_STATUSES_TL

197: cursor c1 is select
198: CHG_STATUS_NAME
199: ,DESCRIPTION
200: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
201: from OKE_CHG_STATUSES_TL
202: where CHG_STATUS_CODE= X_CHG_STATUS_CODE
203: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
204: for update of CHG_STATUS_CODE nowait;
205: tlinfo c1%rowtype;

Line 351: update OKE_CHG_STATUSES_TL set

347: if (sql%notfound) then
348: raise no_data_found;
349: end if;
350:
351: update OKE_CHG_STATUSES_TL set
352: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
353: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
354: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
355: , CHG_STATUS_NAME = X_CHG_STATUS_NAME

Line 370: delete from OKE_CHG_STATUSES_TL T

366:
367: procedure ADD_LANGUAGE
368: is
369: begin
370: delete from OKE_CHG_STATUSES_TL T
371: where not exists
372: (select NULL
373: from OKE_CHG_STATUSES_B B
374: where B.CHG_STATUS_CODE = T.CHG_STATUS_CODE

Line 377: update OKE_CHG_STATUSES_TL T set (

373: from OKE_CHG_STATUSES_B B
374: where B.CHG_STATUS_CODE = T.CHG_STATUS_CODE
375: );
376:
377: update OKE_CHG_STATUSES_TL T set (
378: CHG_STATUS_NAME,
379: DESCRIPTION
380: ) = (select
381: B.CHG_STATUS_NAME,

Line 383: from OKE_CHG_STATUSES_TL B

379: DESCRIPTION
380: ) = (select
381: B.CHG_STATUS_NAME,
382: B.DESCRIPTION
383: from OKE_CHG_STATUSES_TL B
384: where B.CHG_STATUS_CODE = T.CHG_STATUS_CODE
385: and B.LANGUAGE = T.SOURCE_LANG)
386: where (
387: T.CHG_STATUS_CODE,

Line 392: from OKE_CHG_STATUSES_TL SUBB, OKE_CHG_STATUSES_TL SUBT

388: T.LANGUAGE
389: ) in (select
390: SUBT.CHG_STATUS_CODE,
391: SUBT.LANGUAGE
392: from OKE_CHG_STATUSES_TL SUBB, OKE_CHG_STATUSES_TL SUBT
393: where SUBB.CHG_STATUS_CODE = SUBT.CHG_STATUS_CODE
394: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
395: and (SUBB.CHG_STATUS_NAME <> SUBT.CHG_STATUS_NAME
396: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 401: insert into OKE_CHG_STATUSES_TL (

397: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
398: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
399: ));
400:
401: insert into OKE_CHG_STATUSES_TL (
402: LAST_UPDATE_DATE,
403: LAST_UPDATED_BY,
404: LAST_UPDATE_LOGIN,
405: CHG_STATUS_NAME,

Line 423: from OKE_CHG_STATUSES_TL B, FND_LANGUAGES L

419: B.CREATION_DATE,
420: B.CREATED_BY,
421: L.LANGUAGE_CODE,
422: B.SOURCE_LANG
423: from OKE_CHG_STATUSES_TL B, FND_LANGUAGES L
424: where L.INSTALLED_FLAG in ('I', 'B')
425: and B.LANGUAGE = userenv('LANG')
426: and not exists
427: (select NULL

Line 428: from OKE_CHG_STATUSES_TL T

424: where L.INSTALLED_FLAG in ('I', 'B')
425: and B.LANGUAGE = userenv('LANG')
426: and not exists
427: (select NULL
428: from OKE_CHG_STATUSES_TL T
429: where T.CHG_STATUS_CODE = B.CHG_STATUS_CODE
430: and T.LANGUAGE = L.LANGUAGE_CODE);
431: end ADD_LANGUAGE;
432: