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.HR_ITEM_PROPERTIES_PKG dependencies on HR_ITEM_PROPERTIES_TL

Line 195: update HR_ITEM_PROPERTIES_TL set

191: where ITEM_PROPERTY_ID = l_copy.ITEM_PROPERTY_ID;
192: if (sql%notfound) then
193: raise no_data_found;
194: end if;
195: update HR_ITEM_PROPERTIES_TL set
196: DEFAULT_VALUE = decode(nvl(DEFAULT_VALUE,hr_api.g_varchar2),nvl(l_original.DEFAULT_VALUE,hr_api.g_varchar2),X_DEFAULT_VALUE,DEFAULT_VALUE),
197: INFORMATION_PROMPT = decode(nvl(INFORMATION_PROMPT,hr_api.g_varchar2),nvl(l_original.INFORMATION_PROMPT,hr_api.g_varchar2),X_INFORMATION_PROMPT,INFORMATION_PROMPT),
198: LABEL = decode(nvl(LABEL,hr_api.g_varchar2),nvl(l_original.LABEL,hr_api.g_varchar2),X_LABEL,LABEL),
199: PROMPT_TEXT = decode(nvl(PROMPT_TEXT,hr_api.g_varchar2),nvl(l_original.PROMPT_TEXT,hr_api.g_varchar2),X_PROMPT_TEXT,PROMPT_TEXT),

Line 477: insert into HR_ITEM_PROPERTIES_TL (

473: X_LAST_UPDATED_BY,
474: X_LAST_UPDATE_LOGIN
475: );
476:
477: insert into HR_ITEM_PROPERTIES_TL (
478: DEFAULT_VALUE,
479: INFORMATION_PROMPT,
480: LABEL,
481: LAST_UPDATED_BY,

Line 509: from HR_ITEM_PROPERTIES_TL T

505: from FND_LANGUAGES L
506: where L.INSTALLED_FLAG in ('I', 'B')
507: and not exists
508: (select NULL
509: from HR_ITEM_PROPERTIES_TL T
510: where T.ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
511: and T.LANGUAGE = L.LANGUAGE_CODE);
512:
513: open c;

Line 680: from HR_ITEM_PROPERTIES_TL

676: LABEL,
677: PROMPT_TEXT,
678: TOOLTIP_TEXT,
679: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
680: from HR_ITEM_PROPERTIES_TL
681: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
682: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
683: for update of ITEM_PROPERTY_ID nowait;
684: begin

Line 1017: update HR_ITEM_PROPERTIES_TL set

1013: if (sql%notfound) then
1014: raise no_data_found;
1015: end if;
1016:
1017: update HR_ITEM_PROPERTIES_TL set
1018: DEFAULT_VALUE = X_DEFAULT_VALUE,
1019: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
1020: LABEL = X_LABEL,
1021: PROMPT_TEXT = X_PROMPT_TEXT,

Line 1039: delete from HR_ITEM_PROPERTIES_TL

1035: procedure DELETE_ROW (
1036: X_ITEM_PROPERTY_ID in NUMBER
1037: ) is
1038: begin
1039: delete from HR_ITEM_PROPERTIES_TL
1040: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID;
1041:
1042: if (sql%notfound) then
1043: raise no_data_found;

Line 1057: delete from HR_ITEM_PROPERTIES_TL T

1053:
1054: procedure ADD_LANGUAGE
1055: is
1056: begin
1057: delete from HR_ITEM_PROPERTIES_TL T
1058: where not exists
1059: (select NULL
1060: from HR_ITEM_PROPERTIES_B B
1061: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID

Line 1064: update HR_ITEM_PROPERTIES_TL T set (

1060: from HR_ITEM_PROPERTIES_B B
1061: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1062: );
1063:
1064: update HR_ITEM_PROPERTIES_TL T set (
1065: DEFAULT_VALUE,
1066: INFORMATION_PROMPT,
1067: LABEL,
1068: PROMPT_TEXT,

Line 1076: from HR_ITEM_PROPERTIES_TL B

1072: B.INFORMATION_PROMPT,
1073: B.LABEL,
1074: B.PROMPT_TEXT,
1075: B.TOOLTIP_TEXT
1076: from HR_ITEM_PROPERTIES_TL B
1077: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1078: and B.LANGUAGE = T.SOURCE_LANG)
1079: where (
1080: T.ITEM_PROPERTY_ID,

Line 1085: from HR_ITEM_PROPERTIES_TL SUBB, HR_ITEM_PROPERTIES_TL SUBT

1081: T.LANGUAGE
1082: ) in (select
1083: SUBT.ITEM_PROPERTY_ID,
1084: SUBT.LANGUAGE
1085: from HR_ITEM_PROPERTIES_TL SUBB, HR_ITEM_PROPERTIES_TL SUBT
1086: where SUBB.ITEM_PROPERTY_ID = SUBT.ITEM_PROPERTY_ID
1087: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1088: and (SUBB.INFORMATION_PROMPT <> SUBT.INFORMATION_PROMPT
1089: or (SUBB.INFORMATION_PROMPT is null and SUBT.INFORMATION_PROMPT is not null)

Line 1105: insert into HR_ITEM_PROPERTIES_TL (

1101: or (SUBB.TOOLTIP_TEXT is null and SUBT.TOOLTIP_TEXT is not null)
1102: or (SUBB.TOOLTIP_TEXT is not null and SUBT.TOOLTIP_TEXT is null)
1103: ));
1104:
1105: insert into HR_ITEM_PROPERTIES_TL (
1106: DEFAULT_VALUE,
1107: INFORMATION_PROMPT,
1108: LABEL,
1109: LAST_UPDATED_BY,

Line 1133: from HR_ITEM_PROPERTIES_TL B, FND_LANGUAGES L

1129: B.PROMPT_TEXT,
1130: B.TOOLTIP_TEXT,
1131: L.LANGUAGE_CODE,
1132: B.SOURCE_LANG
1133: from HR_ITEM_PROPERTIES_TL B, FND_LANGUAGES L
1134: where L.INSTALLED_FLAG in ('I', 'B')
1135: and B.LANGUAGE = userenv('LANG')
1136: and not exists
1137: (select NULL

Line 1138: from HR_ITEM_PROPERTIES_TL T

1134: where L.INSTALLED_FLAG in ('I', 'B')
1135: and B.LANGUAGE = userenv('LANG')
1136: and not exists
1137: (select NULL
1138: from HR_ITEM_PROPERTIES_TL T
1139: where T.ITEM_PROPERTY_ID = B.ITEM_PROPERTY_ID
1140: and T.LANGUAGE = L.LANGUAGE_CODE);
1141: end ADD_LANGUAGE;
1142:

Line 1813: from HR_ITEM_PROPERTIES_TL

1809: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
1810:
1811: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1812: into db_luby, db_ludate
1813: from HR_ITEM_PROPERTIES_TL
1814: where item_property_id = x_item_property_id
1815: and LANGUAGE=userenv('LANG');
1816:
1817: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2325: from HR_ITEM_PROPERTIES_TL

2321: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2322:
2323: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2324: into db_luby, db_ludate
2325: from HR_ITEM_PROPERTIES_TL
2326: where item_property_id = x_item_property_id
2327: and LANGUAGE=userenv('LANG');
2328:
2329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2332: update HR_ITEM_PROPERTIES_TL set

2328:
2329: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2330: db_ludate,X_CUSTOM_MODE)) then
2331:
2332: update HR_ITEM_PROPERTIES_TL set
2333: DEFAULT_VALUE = X_DEFAULT_VALUE,
2334: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
2335: LABEL = X_LABEL,
2336: PROMPT_TEXT = X_PROMPT_TEXT,

Line 2614: from HR_ITEM_PROPERTIES_TL

2610: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
2611:
2612: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2613: into db_luby, db_ludate
2614: from HR_ITEM_PROPERTIES_TL
2615: where item_property_id = x_item_property_id
2616: and LANGUAGE=userenv('LANG');
2617:
2618: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2621: update HR_ITEM_PROPERTIES_TL set

2617:
2618: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2619: db_ludate,X_CUSTOM_MODE)) then
2620:
2621: update HR_ITEM_PROPERTIES_TL set
2622: DEFAULT_VALUE = X_DEFAULT_VALUE,
2623: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
2624: LABEL = X_LABEL,
2625: PROMPT_TEXT = X_PROMPT_TEXT,