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_ORG_INFORMATION_TYPES_PKG dependencies on HR_ORG_INFORMATION_TYPES_TL

Line 85: insert into HR_ORG_INFORMATION_TYPES_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into HR_ORG_INFORMATION_TYPES_TL (
86: ORG_INFORMATION_TYPE,
87: DISPLAYED_ORG_INFORMATION_TYPE,
88: CREATED_BY,
89: CREATION_DATE,

Line 109: from HR_ORG_INFORMATION_TYPES_TL T

105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from HR_ORG_INFORMATION_TYPES_TL T
110: where T.ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112:
113: end INSERT_ROW;

Line 140: from HR_ORG_INFORMATION_TYPES_TL

136:
137: cursor CSR_ORG_INFORMATION_TYPE_TL is
138: select DISPLAYED_ORG_INFORMATION_TYPE,
139: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
140: from HR_ORG_INFORMATION_TYPES_TL
141: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
142: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
143: for update of ORG_INFORMATION_TYPE nowait;
144:

Line 215: update HR_ORG_INFORMATION_TYPES_TL set

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: update HR_ORG_INFORMATION_TYPES_TL set
216: DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
217: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
219: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 234: delete from HR_ORG_INFORMATION_TYPES_TL

230: procedure DELETE_ROW (
231: X_ORG_INFORMATION_TYPE in VARCHAR2
232: ) is
233: begin
234: delete from HR_ORG_INFORMATION_TYPES_TL
235: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
236:
237: if (sql%notfound) then
238: raise no_data_found;

Line 251: delete from HR_ORG_INFORMATION_TYPES_TL T

247: --
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from HR_ORG_INFORMATION_TYPES_TL T
252: where not exists
253: (select NULL
254: from HR_ORG_INFORMATION_TYPES B
255: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE

Line 258: update HR_ORG_INFORMATION_TYPES_TL T set (

254: from HR_ORG_INFORMATION_TYPES B
255: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
256: );
257:
258: update HR_ORG_INFORMATION_TYPES_TL T set (
259: DISPLAYED_ORG_INFORMATION_TYPE
260: ) = (select
261: B.DISPLAYED_ORG_INFORMATION_TYPE
262: from HR_ORG_INFORMATION_TYPES_TL B

Line 262: from HR_ORG_INFORMATION_TYPES_TL B

258: update HR_ORG_INFORMATION_TYPES_TL T set (
259: DISPLAYED_ORG_INFORMATION_TYPE
260: ) = (select
261: B.DISPLAYED_ORG_INFORMATION_TYPE
262: from HR_ORG_INFORMATION_TYPES_TL B
263: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (
266: T.ORG_INFORMATION_TYPE,

Line 271: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.ORG_INFORMATION_TYPE,
270: SUBT.LANGUAGE
271: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT
272: where SUBB.ORG_INFORMATION_TYPE = SUBT.ORG_INFORMATION_TYPE
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.DISPLAYED_ORG_INFORMATION_TYPE <> SUBT.DISPLAYED_ORG_INFORMATION_TYPE
275: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)

Line 279: insert into HR_ORG_INFORMATION_TYPES_TL (

275: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)
276: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is not null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is null)
277: ));
278:
279: insert into HR_ORG_INFORMATION_TYPES_TL (
280: ORG_INFORMATION_TYPE,
281: DISPLAYED_ORG_INFORMATION_TYPE,
282: CREATED_BY,
283: CREATION_DATE,

Line 299: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L

295: B.LAST_UPDATE_DATE,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from HR_ORG_INFORMATION_TYPES_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from HR_ORG_INFORMATION_TYPES_TL T
305: where T.ORG_INFORMATION_TYPE = B.ORG_INFORMATION_TYPE
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308:

Line 423: from HR_ORG_INFORMATION_TYPES_TL

419: -- the correct row is fetched instead of multiple rows
420:
421: select LAST_UPDATED_BY, LAST_UPDATE_DATE
422: into db_luby, db_ludate
423: from HR_ORG_INFORMATION_TYPES_TL
424: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
425: and LANGUAGE=userenv('LANG');
426:
427: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 432: update HR_ORG_INFORMATION_TYPES_TL

428: db_ludate,X_CUSTOM_MODE)) then
429: -- Update translations for this language
430: -- bug 5235538 nls date issue, changed to LAST_UPDATE_DATE = f_ludate, LAST_UPDATED_BY = f_luby
431:
432: update HR_ORG_INFORMATION_TYPES_TL
433: set DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP
434: , LAST_UPDATE_DATE = f_ludate
435: , LAST_UPDATED_BY = f_luby
436: , LAST_UPDATE_LOGIN = 0