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_NAVIGATION_UNITS_PKG dependencies on HR_NAVIGATION_UNITS_TL

Line 72: INSERT INTO HR_NAVIGATION_UNITS_TL(

68: X_Max_Number_Of_Nav_Buttons,
69: X_Block_Name
70: );
71:
72: INSERT INTO HR_NAVIGATION_UNITS_TL(
73: nav_unit_id,
74: default_label,
75: language,
76: source_lang)

Line 86: from HR_NAVIGATION_UNITS_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from HR_NAVIGATION_UNITS_TL T
87: where T.NAV_UNIT_ID = X_NAV_UNIT_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: OPEN C;

Line 118: cursor CSR_HR_NAVIGATION_UNITS_TL is

114: WHERE rowid = X_Rowid
115: FOR UPDATE of Nav_Unit_Id NOWAIT;
116: Recinfo C%ROWTYPE;
117:
118: cursor CSR_HR_NAVIGATION_UNITS_TL is
119: select DEFAULT_LABEL,
120: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
121: from HR_NAVIGATION_UNITS_TL TL
122: where nav_unit_id = x_nav_unit_id

Line 121: from HR_NAVIGATION_UNITS_TL TL

117:
118: cursor CSR_HR_NAVIGATION_UNITS_TL is
119: select DEFAULT_LABEL,
120: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
121: from HR_NAVIGATION_UNITS_TL TL
122: where nav_unit_id = x_nav_unit_id
123: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
124: for update of nav_unit_id nowait;
125:

Line 168: for tlinfo in CSR_HR_NAVIGATION_UNITS_TL loop

164: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
165: APP_EXCEPTION.RAISE_EXCEPTION;
166: end if;
167:
168: for tlinfo in CSR_HR_NAVIGATION_UNITS_TL loop
169: if (tlinfo.BASELANG = 'Y') then
170: if ( ((tlinfo.DEFAULT_LABEL = X_DEFAULT_LABEL)
171: OR ((tlinfo.DEFAULT_LABEL is null) AND (X_DEFAULT_LABEL is null)))
172: ) then

Line 224: update HR_NAVIGATION_UNITS_TL

220: hr_utility.set_message_token('STEP','1');
221: hr_utility.raise_error;
222: end if;
223:
224: update HR_NAVIGATION_UNITS_TL
225: set
226: DEFAULT_LABEL = X_DEFAULT_LABEL,
227: SOURCE_LANG = userenv('LANG')
228: where NAV_UNIT_ID = X_NAV_UNIT_ID

Line 276: update HR_NAVIGATION_UNITS_TL

272: if (sql%notfound) then
273: raise no_data_found;
274: end if;
275:
276: update HR_NAVIGATION_UNITS_TL
277: set
278: DEFAULT_LABEL = X_DEFAULT_LABEL,
279: SOURCE_LANG = userenv('LANG')
280: where NAV_UNIT_ID = X_NAV_UNIT_ID

Line 291: delete from HR_NAVIGATION_UNITS_TL

287: end UPDATE_ROW;
288:
289: PROCEDURE Delete_Row(x_nav_unit_id varchar2, X_Rowid VARCHAR2) IS
290: BEGIN
291: delete from HR_NAVIGATION_UNITS_TL
292: where NAV_UNIT_ID = X_NAV_UNIT_ID;
293:
294: if (sql%notfound) then
295: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 315: delete from HR_NAVIGATION_UNITS_TL T

311:
312: procedure ADD_LANGUAGE
313: is
314: begin
315: delete from HR_NAVIGATION_UNITS_TL T
316: where not exists
317: (select NULL
318: from HR_NAVIGATION_UNITS B
319: where B.NAV_UNIT_ID = T.NAV_UNIT_ID

Line 322: update HR_NAVIGATION_UNITS_TL T set (

318: from HR_NAVIGATION_UNITS B
319: where B.NAV_UNIT_ID = T.NAV_UNIT_ID
320: );
321:
322: update HR_NAVIGATION_UNITS_TL T set (
323: DEFAULT_LABEL
324: ) = (select
325: B.DEFAULT_LABEL
326: from HR_NAVIGATION_UNITS_TL B

Line 326: from HR_NAVIGATION_UNITS_TL B

322: update HR_NAVIGATION_UNITS_TL T set (
323: DEFAULT_LABEL
324: ) = (select
325: B.DEFAULT_LABEL
326: from HR_NAVIGATION_UNITS_TL B
327: where B.NAV_UNIT_ID = T.NAV_UNIT_ID
328: and B.LANGUAGE = T.SOURCE_LANG)
329: where (
330: T.NAV_UNIT_ID,

Line 335: from HR_NAVIGATION_UNITS_TL SUBB, HR_NAVIGATION_UNITS_TL SUBT

331: T.LANGUAGE
332: ) in (select
333: SUBT.NAV_UNIT_ID,
334: SUBT.LANGUAGE
335: from HR_NAVIGATION_UNITS_TL SUBB, HR_NAVIGATION_UNITS_TL SUBT
336: where SUBB.NAV_UNIT_ID = SUBT.NAV_UNIT_ID
337: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
338: and (SUBB.DEFAULT_LABEL <> SUBT.DEFAULT_LABEL
339: or (SUBB.DEFAULT_LABEL is null and SUBT.DEFAULT_LABEL is not null)

Line 343: insert into HR_NAVIGATION_UNITS_TL (

339: or (SUBB.DEFAULT_LABEL is null and SUBT.DEFAULT_LABEL is not null)
340: or (SUBB.DEFAULT_LABEL is not null and SUBT.DEFAULT_LABEL is null)
341: ));
342:
343: insert into HR_NAVIGATION_UNITS_TL (
344: NAV_UNIT_ID,
345: DEFAULT_LABEL,
346: LANGUAGE,
347: SOURCE_LANG

Line 353: from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L

349: B.NAV_UNIT_ID,
350: B.DEFAULT_LABEL,
351: L.LANGUAGE_CODE,
352: B.SOURCE_LANG
353: from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L
354: where L.INSTALLED_FLAG in ('I', 'B')
355: and B.LANGUAGE = userenv('LANG')
356: and not exists
357: (select NULL

Line 358: from HR_NAVIGATION_UNITS_TL T

354: where L.INSTALLED_FLAG in ('I', 'B')
355: and B.LANGUAGE = userenv('LANG')
356: and not exists
357: (select NULL
358: from HR_NAVIGATION_UNITS_TL T
359: where T.NAV_UNIT_ID = B.NAV_UNIT_ID
360: and T.LANGUAGE = L.LANGUAGE_CODE);
361:
362: end ADD_LANGUAGE;

Line 459: FROM HR_NAVIGATION_UNITS_TL

455: Y_SOURCE_LANG varchar2(4);
456: --
457: Cursor database_row(p_nav_unit_id number) IS
458: SELECT DEFAULT_LABEL, SOURCE_LANG
459: FROM HR_NAVIGATION_UNITS_TL
460: WHERE userenv('LANG') in (LANGUAGE,SOURCE_LANG)
461: AND nav_unit_id = p_nav_unit_id;
462: --
463: begin

Line 480: update HR_NAVIGATION_UNITS_TL

476: if database_row%found then
477: if X_DEFAULT_LABEL <> Y_DEFAULT_LABEL OR
478: Y_SOURCE_LANG <> userenv('LANG') THEN
479:
480: update HR_NAVIGATION_UNITS_TL
481: set DEFAULT_LABEL = X_DEFAULT_LABEL,
482: SOURCE_LANG = userenv('LANG')
483: where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
484: and nav_unit_id = x_nav_unit_id;