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.EGO_CATG_MAP_PKG dependencies on EGO_CATG_MAP_HDRS_TL

Line 44: insert into EGO_CATG_MAP_HDRS_TL (

40: X_LAST_UPDATED_BY,
41: X_LAST_UPDATE_LOGIN
42: );
43:
44: insert into EGO_CATG_MAP_HDRS_TL (
45: CATG_MAP_ID,
46: CATG_MAP_NAME,
47: CATG_MAP_DESC,
48: CREATION_DATE,

Line 70: from EGO_CATG_MAP_HDRS_TL T

66: from FND_LANGUAGES L
67: where L.INSTALLED_FLAG in ('I', 'B')
68: and not exists
69: (select NULL
70: from EGO_CATG_MAP_HDRS_TL T
71: where T.CATG_MAP_ID = X_CATG_MAP_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);
73: open c;
74: fetch c into X_ROWID;

Line 105: from EGO_CATG_MAP_HDRS_TL

101: cursor c1 is select
102: CATG_MAP_NAME,
103: CATG_MAP_DESC,
104: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
105: from EGO_CATG_MAP_HDRS_TL
106: where CATG_MAP_ID = X_CATG_MAP_ID
107: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
108: for update of CATG_MAP_ID nowait;
109: begin

Line 174: update EGO_CATG_MAP_HDRS_TL set

170: if (sql%notfound) then
171: raise no_data_found;
172: end if;
173:
174: update EGO_CATG_MAP_HDRS_TL set
175: CATG_MAP_NAME = X_CATG_MAP_NAME,
176: CATG_MAP_DESC = X_CATG_MAP_DESC,
177: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
178: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 194: delete from EGO_CATG_MAP_HDRS_TL

190: procedure DELETE_ROW (
191: X_CATG_MAP_ID in NUMBER
192: ) is
193: begin
194: delete from EGO_CATG_MAP_HDRS_TL
195: where CATG_MAP_ID = X_CATG_MAP_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 297: INSERT INTO EGO_CATG_MAP_HDRS_TL

293: sysdate,
294: l_current_login_id
295: );
296:
297: INSERT INTO EGO_CATG_MAP_HDRS_TL
298: (
299: CATG_MAP_ID,
300: LANGUAGE,
301: SOURCE_LANG,

Line 322: AND NOT EXISTS(SELECT 'X' FROM EGO_CATG_MAP_HDRS_TL A

318: sysdate,
319: l_current_login_id
320: FROM FND_LANGUAGES L
321: WHERE L.INSTALLED_FLAG IN ('I','B')
322: AND NOT EXISTS(SELECT 'X' FROM EGO_CATG_MAP_HDRS_TL A
323: WHERE A.CATG_MAP_ID = l_catg_map_id
324: AND A.LANGUAGE = L.LANGUAGE_CODE);
325: ELSE
326:

Line 337: UPDATE EGO_CATG_MAP_HDRS_TL

333: WHERE SOURCE_CATG_SET_ID = l_source_catg_set_id
334: AND TARGET_CATG_SET_ID = l_target_catg_set_id
335: AND CATG_MAP_ID = l_catg_map_id;
336:
337: UPDATE EGO_CATG_MAP_HDRS_TL
338: SET CATG_MAP_DESC = X_CATG_MAP_DESC,
339: LAST_UPDATED_BY = l_current_user_id,
340: LAST_UPDATE_DATE = sysdate,
341: LAST_UPDATE_LOGIN = l_current_login_id

Line 513: FROM EGO_CATG_MAP_HDRS_TL TL

509: f_ludate := SYSDATE;
510:
511: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE
512: INTO db_luby, db_ludate
513: FROM EGO_CATG_MAP_HDRS_TL TL
514: WHERE TL.catg_map_id = X_CATG_MAP_ID
515: AND userenv('LANG') IN (language, source_lang);
516:
517: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 520: UPDATE EGO_CATG_MAP_HDRS_TL TL

516:
517: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
518: db_ludate, NULL)) THEN
519:
520: UPDATE EGO_CATG_MAP_HDRS_TL TL
521: SET TL.CATG_MAP_NAME = NVL(x_CATG_MAP_NAME, CATG_MAP_NAME)
522: , TL.CATG_MAP_DESC = NVL(x_CATG_MAP_DESC, CATG_MAP_DESC)
523: , last_update_date = db_ludate
524: , last_updated_by = db_luby

Line 538: delete from EGO_CATG_MAP_HDRS_TL T

534:
535: procedure ADD_LANGUAGE
536: is
537: begin
538: delete from EGO_CATG_MAP_HDRS_TL T
539: where not exists
540: (select NULL
541: from EGO_CATG_MAP_HDRS_B B
542: where B.CATG_MAP_ID = T.CATG_MAP_ID

Line 545: update EGO_CATG_MAP_HDRS_TL T set (

541: from EGO_CATG_MAP_HDRS_B B
542: where B.CATG_MAP_ID = T.CATG_MAP_ID
543: );
544:
545: update EGO_CATG_MAP_HDRS_TL T set (
546: CATG_MAP_NAME,
547: CATG_MAP_DESC
548: ) = (select
549: B.CATG_MAP_NAME,

Line 551: from EGO_CATG_MAP_HDRS_TL B

547: CATG_MAP_DESC
548: ) = (select
549: B.CATG_MAP_NAME,
550: B.CATG_MAP_DESC
551: from EGO_CATG_MAP_HDRS_TL B
552: where B.CATG_MAP_ID = T.CATG_MAP_ID
553: and B.LANGUAGE = T.SOURCE_LANG)
554: where (
555: T.CATG_MAP_ID,

Line 560: from EGO_CATG_MAP_HDRS_TL SUBB, EGO_CATG_MAP_HDRS_TL SUBT

556: T.LANGUAGE
557: ) in (select
558: SUBT.CATG_MAP_ID,
559: SUBT.LANGUAGE
560: from EGO_CATG_MAP_HDRS_TL SUBB, EGO_CATG_MAP_HDRS_TL SUBT
561: where SUBB.CATG_MAP_ID = SUBT.CATG_MAP_ID
562: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
563: and (SUBB.CATG_MAP_NAME <> SUBT.CATG_MAP_NAME
564: or (SUBB.CATG_MAP_NAME is null and SUBT.CATG_MAP_NAME is not null)

Line 571: insert into EGO_CATG_MAP_HDRS_TL (

567: or (SUBB.CATG_MAP_DESC is null and SUBT.CATG_MAP_DESC is not null)
568: or (SUBB.CATG_MAP_DESC is not null and SUBT.CATG_MAP_DESC is null)
569: ));
570:
571: insert into EGO_CATG_MAP_HDRS_TL (
572: CATG_MAP_ID,
573: CATG_MAP_NAME,
574: CATG_MAP_DESC,
575: CREATION_DATE,

Line 593: from EGO_CATG_MAP_HDRS_TL B, FND_LANGUAGES L

589: B.LAST_UPDATED_BY,
590: B.LAST_UPDATE_LOGIN,
591: L.LANGUAGE_CODE,
592: B.SOURCE_LANG
593: from EGO_CATG_MAP_HDRS_TL B, FND_LANGUAGES L
594: where L.INSTALLED_FLAG in ('I', 'B')
595: and B.LANGUAGE = userenv('LANG')
596: and not exists
597: (select NULL

Line 598: from EGO_CATG_MAP_HDRS_TL T

594: where L.INSTALLED_FLAG in ('I', 'B')
595: and B.LANGUAGE = userenv('LANG')
596: and not exists
597: (select NULL
598: from EGO_CATG_MAP_HDRS_TL T
599: where T.CATG_MAP_ID = B.CATG_MAP_ID
600: and T.LANGUAGE = L.LANGUAGE_CODE);
601: end ADD_LANGUAGE;
602: