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 532: p_entity_name => 'HR_ITEM_PROPERTIES_TL',

528: --
529:
530: BEGIN
531: PER_RIC_PKG.chk_integrity (
532: p_entity_name => 'HR_ITEM_PROPERTIES_TL',
533: p_ref_entity => 'HR_ITEM_PROPERTIES_B',
534: p_ref_column_name => 'ITEM_PROPERTY_ID',
535: p_ref_col_value_number => X_ITEM_PROPERTY_ID,
536: p_ref_col_value_varchar => NULL,

Line 545: insert into HR_ITEM_PROPERTIES_TL (

541: --
542: -- Code Ends Here.
543: --
544:
545: insert into HR_ITEM_PROPERTIES_TL (
546: DEFAULT_VALUE,
547: INFORMATION_PROMPT,
548: LABEL,
549: LAST_UPDATED_BY,

Line 577: from HR_ITEM_PROPERTIES_TL T

573: from FND_LANGUAGES L
574: where L.INSTALLED_FLAG in ('I', 'B')
575: and not exists
576: (select NULL
577: from HR_ITEM_PROPERTIES_TL T
578: where T.ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
579: and T.LANGUAGE = L.LANGUAGE_CODE);
580:
581: open c;

Line 748: from HR_ITEM_PROPERTIES_TL

744: LABEL,
745: PROMPT_TEXT,
746: TOOLTIP_TEXT,
747: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
748: from HR_ITEM_PROPERTIES_TL
749: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID
750: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
751: for update of ITEM_PROPERTY_ID nowait;
752: begin

Line 1085: update HR_ITEM_PROPERTIES_TL set

1081: if (sql%notfound) then
1082: raise no_data_found;
1083: end if;
1084:
1085: update HR_ITEM_PROPERTIES_TL set
1086: DEFAULT_VALUE = X_DEFAULT_VALUE,
1087: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
1088: LABEL = X_LABEL,
1089: PROMPT_TEXT = X_PROMPT_TEXT,

Line 1107: delete from HR_ITEM_PROPERTIES_TL

1103: procedure DELETE_ROW (
1104: X_ITEM_PROPERTY_ID in NUMBER
1105: ) is
1106: begin
1107: delete from HR_ITEM_PROPERTIES_TL
1108: where ITEM_PROPERTY_ID = X_ITEM_PROPERTY_ID;
1109:
1110: if (sql%notfound) then
1111: raise no_data_found;

Line 1121: p_ref_entity => 'HR_ITEM_PROPERTIES_TL',

1117:
1118: BEGIN
1119: PER_RIC_PKG.chk_integrity (
1120: p_entity_name => 'HR_ITEM_PROPERTIES_B',
1121: p_ref_entity => 'HR_ITEM_PROPERTIES_TL',
1122: p_ref_column_name => 'ITEM_PROPERTY_ID',
1123: p_ref_col_value_number => X_ITEM_PROPERTY_ID,
1124: p_ref_col_value_varchar => NULL,
1125: p_ref_col_value_date => NULL,

Line 1143: delete from HR_ITEM_PROPERTIES_TL T

1139:
1140: procedure ADD_LANGUAGE
1141: is
1142: begin
1143: delete from HR_ITEM_PROPERTIES_TL T
1144: where not exists
1145: (select NULL
1146: from HR_ITEM_PROPERTIES_B B
1147: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID

Line 1150: update HR_ITEM_PROPERTIES_TL T set (

1146: from HR_ITEM_PROPERTIES_B B
1147: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1148: );
1149:
1150: update HR_ITEM_PROPERTIES_TL T set (
1151: DEFAULT_VALUE,
1152: INFORMATION_PROMPT,
1153: LABEL,
1154: PROMPT_TEXT,

Line 1162: from HR_ITEM_PROPERTIES_TL B

1158: B.INFORMATION_PROMPT,
1159: B.LABEL,
1160: B.PROMPT_TEXT,
1161: B.TOOLTIP_TEXT
1162: from HR_ITEM_PROPERTIES_TL B
1163: where B.ITEM_PROPERTY_ID = T.ITEM_PROPERTY_ID
1164: and B.LANGUAGE = T.SOURCE_LANG)
1165: where (
1166: T.ITEM_PROPERTY_ID,

Line 1171: from HR_ITEM_PROPERTIES_TL SUBB, HR_ITEM_PROPERTIES_TL SUBT

1167: T.LANGUAGE
1168: ) in (select
1169: SUBT.ITEM_PROPERTY_ID,
1170: SUBT.LANGUAGE
1171: from HR_ITEM_PROPERTIES_TL SUBB, HR_ITEM_PROPERTIES_TL SUBT
1172: where SUBB.ITEM_PROPERTY_ID = SUBT.ITEM_PROPERTY_ID
1173: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1174: and (SUBB.INFORMATION_PROMPT <> SUBT.INFORMATION_PROMPT
1175: or (SUBB.INFORMATION_PROMPT is null and SUBT.INFORMATION_PROMPT is not null)

Line 1191: insert into HR_ITEM_PROPERTIES_TL (

1187: or (SUBB.TOOLTIP_TEXT is null and SUBT.TOOLTIP_TEXT is not null)
1188: or (SUBB.TOOLTIP_TEXT is not null and SUBT.TOOLTIP_TEXT is null)
1189: ));
1190:
1191: insert into HR_ITEM_PROPERTIES_TL (
1192: DEFAULT_VALUE,
1193: INFORMATION_PROMPT,
1194: LABEL,
1195: LAST_UPDATED_BY,

Line 1219: from HR_ITEM_PROPERTIES_TL B, FND_LANGUAGES L

1215: B.PROMPT_TEXT,
1216: B.TOOLTIP_TEXT,
1217: L.LANGUAGE_CODE,
1218: B.SOURCE_LANG
1219: from HR_ITEM_PROPERTIES_TL B, FND_LANGUAGES L
1220: where L.INSTALLED_FLAG in ('I', 'B')
1221: and B.LANGUAGE = userenv('LANG')
1222: and not exists
1223: (select NULL

Line 1224: from HR_ITEM_PROPERTIES_TL T

1220: where L.INSTALLED_FLAG in ('I', 'B')
1221: and B.LANGUAGE = userenv('LANG')
1222: and not exists
1223: (select NULL
1224: from HR_ITEM_PROPERTIES_TL T
1225: where T.ITEM_PROPERTY_ID = B.ITEM_PROPERTY_ID
1226: and T.LANGUAGE = L.LANGUAGE_CODE);
1227: end ADD_LANGUAGE;
1228:

Line 1899: from HR_ITEM_PROPERTIES_TL

1895: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
1896:
1897: select LAST_UPDATED_BY, LAST_UPDATE_DATE
1898: into db_luby, db_ludate
1899: from HR_ITEM_PROPERTIES_TL
1900: where item_property_id = x_item_property_id
1901: and LANGUAGE=userenv('LANG');
1902:
1903: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2411: from HR_ITEM_PROPERTIES_TL

2407: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
2408:
2409: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2410: into db_luby, db_ludate
2411: from HR_ITEM_PROPERTIES_TL
2412: where item_property_id = x_item_property_id
2413: and LANGUAGE=userenv('LANG');
2414:
2415: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2418: update HR_ITEM_PROPERTIES_TL set

2414:
2415: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2416: db_ludate,X_CUSTOM_MODE)) then
2417:
2418: update HR_ITEM_PROPERTIES_TL set
2419: DEFAULT_VALUE = X_DEFAULT_VALUE,
2420: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
2421: LABEL = X_LABEL,
2422: PROMPT_TEXT = X_PROMPT_TEXT,

Line 2700: from HR_ITEM_PROPERTIES_TL

2696: f_ludate := nvl(X_LAST_UPDATE_DATE, sysdate);
2697:
2698: select LAST_UPDATED_BY, LAST_UPDATE_DATE
2699: into db_luby, db_ludate
2700: from HR_ITEM_PROPERTIES_TL
2701: where item_property_id = x_item_property_id
2702: and LANGUAGE=userenv('LANG');
2703:
2704: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 2707: update HR_ITEM_PROPERTIES_TL set

2703:
2704: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
2705: db_ludate,X_CUSTOM_MODE)) then
2706:
2707: update HR_ITEM_PROPERTIES_TL set
2708: DEFAULT_VALUE = X_DEFAULT_VALUE,
2709: INFORMATION_PROMPT = X_INFORMATION_PROMPT,
2710: LABEL = X_LABEL,
2711: PROMPT_TEXT = X_PROMPT_TEXT,