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.JTF_GRID_COLS_PKG dependencies on JTF_GRID_COLS_TL

Line 111: insert into JTF_GRID_COLS_TL (

107: X_FIRE_POST_QUERY_FLAG,
108: X_IMAGE_DESCRIPTION_COL
109: );
110:
111: insert into JTF_GRID_COLS_TL (
112: GRID_DATASOURCE_NAME,
113: GRID_COL_ALIAS,
114: LABEL_TEXT,
115: CREATED_BY,

Line 137: from JTF_GRID_COLS_TL T

133: from FND_LANGUAGES L
134: where L.INSTALLED_FLAG in ('I', 'B')
135: and not exists
136: (select NULL
137: from JTF_GRID_COLS_TL T
138: where T.GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
139: and T.GRID_COL_ALIAS = X_GRID_COL_ALIAS
140: and T.LANGUAGE = L.LANGUAGE_CODE);
141:

Line 218: from JTF_GRID_COLS_TL

214:
215: cursor c1 is select
216: LABEL_TEXT,
217: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
218: from JTF_GRID_COLS_TL
219: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
220: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
221: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
222: for update of GRID_DATASOURCE_NAME nowait;

Line 356: update JTF_GRID_COLS_TL set

352: if (sql%notfound) then
353: raise no_data_found;
354: end if;
355:
356: update JTF_GRID_COLS_TL set
357: LABEL_TEXT = X_LABEL_TEXT,
358: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
359: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
360: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 399: delete from JTF_GRID_COLS_TL

395: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
396: and custom_grid_id=grid_id;
397: End If;
398:
399: delete from JTF_GRID_COLS_TL
400: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
401: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
402:
403: delete from JTF_GRID_COLS_B

Line 435: delete from JTF_GRID_COLS_TL

431: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
432: and CUSTOM_GRID_ID=GRID_ID;
433: End If;
434:
435: delete from JTF_GRID_COLS_TL
436: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;
437:
438: delete from JTF_GRID_COLS_B
439: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME;

Line 450: delete from JTF_GRID_COLS_TL T

446:
447: procedure ADD_LANGUAGE
448: is
449: begin
450: delete from JTF_GRID_COLS_TL T
451: where not exists
452: (select NULL
453: from JTF_GRID_COLS_B B
454: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME

Line 458: update JTF_GRID_COLS_TL T set (

454: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
455: and B.GRID_COL_ALIAS = T.GRID_COL_ALIAS
456: );
457:
458: update JTF_GRID_COLS_TL T set (
459: LABEL_TEXT
460: ) = (select
461: B.LABEL_TEXT
462: from JTF_GRID_COLS_TL B

Line 462: from JTF_GRID_COLS_TL B

458: update JTF_GRID_COLS_TL T set (
459: LABEL_TEXT
460: ) = (select
461: B.LABEL_TEXT
462: from JTF_GRID_COLS_TL B
463: where B.GRID_DATASOURCE_NAME = T.GRID_DATASOURCE_NAME
464: and B.GRID_COL_ALIAS = T.GRID_COL_ALIAS
465: and B.LANGUAGE = T.SOURCE_LANG)
466: where (

Line 474: from JTF_GRID_COLS_TL SUBB, JTF_GRID_COLS_TL SUBT

470: ) in (select
471: SUBT.GRID_DATASOURCE_NAME,
472: SUBT.GRID_COL_ALIAS,
473: SUBT.LANGUAGE
474: from JTF_GRID_COLS_TL SUBB, JTF_GRID_COLS_TL SUBT
475: where SUBB.GRID_DATASOURCE_NAME = SUBT.GRID_DATASOURCE_NAME
476: and SUBB.GRID_COL_ALIAS = SUBT.GRID_COL_ALIAS
477: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
478: and (SUBB.LABEL_TEXT <> SUBT.LABEL_TEXT

Line 481: insert into JTF_GRID_COLS_TL (

477: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
478: and (SUBB.LABEL_TEXT <> SUBT.LABEL_TEXT
479: ));
480:
481: insert into JTF_GRID_COLS_TL (
482: GRID_DATASOURCE_NAME,
483: GRID_COL_ALIAS,
484: LABEL_TEXT,
485: CREATED_BY,

Line 503: from JTF_GRID_COLS_TL B, FND_LANGUAGES L

499: B.LAST_UPDATE_DATE,
500: B.LAST_UPDATE_LOGIN,
501: L.LANGUAGE_CODE,
502: B.SOURCE_LANG
503: from JTF_GRID_COLS_TL B, FND_LANGUAGES L
504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL

Line 508: from JTF_GRID_COLS_TL T

504: where L.INSTALLED_FLAG in ('I', 'B')
505: and B.LANGUAGE = userenv('LANG')
506: and not exists
507: (select NULL
508: from JTF_GRID_COLS_TL T
509: where T.GRID_DATASOURCE_NAME = B.GRID_DATASOURCE_NAME
510: and T.GRID_COL_ALIAS = B.GRID_COL_ALIAS
511: and T.LANGUAGE = L.LANGUAGE_CODE);
512: end ADD_LANGUAGE;

Line 686: from JTF_GRID_COLS_TL

682:
683:
684: select LAST_UPDATED_BY, LAST_UPDATE_DATE
685: into db_luby, db_ludate
686: from JTF_GRID_COLS_TL
687: where GRID_DATASOURCE_NAME = x_grid_datasource_name
688: and GRID_COL_ALIAS = X_GRID_COL_ALIAS
689: and LANGUAGE = userenv('LANG');
690:

Line 697: -- on jtf_grid_cols_tl, if so add an '@'

693: db_ludate, X_CUSTOM_MODE)) then
694:
695: -- we we need to check that we are not
696: -- going to violate the unique key
697: -- on jtf_grid_cols_tl, if so add an '@'
698: -- character to the label_text and try again
699: -- this will be a recursive call until the
700: -- label is unique
701: open c_check_unique;

Line 715: update JTF_GRID_COLS_TL

711: ,X_LAST_UPDATE_DATE => X_LAST_UPDATE_DATE);
712: else
713: close c_check_unique;
714: begin
715: update JTF_GRID_COLS_TL
716: set LABEL_TEXT = nvl(X_LABEL_TEXT,LABEL_TEXT)
717: ,LAST_UPDATE_DATE = f_ludate
718: ,LAST_UPDATED_BY = f_luby
719: ,LAST_UPDATE_LOGIN = 0

Line 761: delete from JTF_GRID_COLS_TL

757: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
758: and custom_grid_id=grid_id;
759: end If;
760:
761: delete from JTF_GRID_COLS_TL
762: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;
763:
764: delete from JTF_GRID_COLS_B
765: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME ;

Line 807: delete from JTF_GRID_COLS_TL

803: delete from JTF_CUSTOM_GRID_COLS
804: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
805: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
806:
807: delete from JTF_GRID_COLS_TL
808: where GRID_DATASOURCE_NAME = X_GRID_DATASOURCE_NAME
809: and GRID_COL_ALIAS = X_GRID_COL_ALIAS;
810:
811: delete from JTF_GRID_COLS_B