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 92: p_entity_name=>'HR_NAVIGATION_UNITS_TL',

88: -- Added the following code as a part of Zero Downtime Patching Project.
89: -- Code Starts Here.
90: --
91: per_ric_pkg.Chk_integrity (
92: p_entity_name=>'HR_NAVIGATION_UNITS_TL',
93: p_ref_entity=>'HR_NAVIGATION_UNITS',
94: p_ref_column_name=>'NAV_UNIT_ID',
95: p_ref_col_value_number=>X_Nav_Unit_Id,
96: p_ref_col_value_varchar=>NULL,

Line 103: INSERT INTO HR_NAVIGATION_UNITS_TL(

99: --
100: -- Code Ends Here
101: --
102:
103: INSERT INTO HR_NAVIGATION_UNITS_TL(
104: nav_unit_id,
105: default_label,
106: language,
107: source_lang)

Line 117: from HR_NAVIGATION_UNITS_TL T

113: from FND_LANGUAGES L
114: where L.INSTALLED_FLAG in ('I', 'B')
115: and not exists
116: (select NULL
117: from HR_NAVIGATION_UNITS_TL T
118: where T.NAV_UNIT_ID = X_NAV_UNIT_ID
119: and T.LANGUAGE = L.LANGUAGE_CODE);
120:
121: OPEN C;

Line 149: cursor CSR_HR_NAVIGATION_UNITS_TL is

145: WHERE rowid = X_Rowid
146: FOR UPDATE of Nav_Unit_Id NOWAIT;
147: Recinfo C%ROWTYPE;
148:
149: cursor CSR_HR_NAVIGATION_UNITS_TL is
150: select DEFAULT_LABEL,
151: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
152: from HR_NAVIGATION_UNITS_TL TL
153: where nav_unit_id = x_nav_unit_id

Line 152: from HR_NAVIGATION_UNITS_TL TL

148:
149: cursor CSR_HR_NAVIGATION_UNITS_TL is
150: select DEFAULT_LABEL,
151: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
152: from HR_NAVIGATION_UNITS_TL TL
153: where nav_unit_id = x_nav_unit_id
154: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
155: for update of nav_unit_id nowait;
156:

Line 199: for tlinfo in CSR_HR_NAVIGATION_UNITS_TL loop

195: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
196: APP_EXCEPTION.RAISE_EXCEPTION;
197: end if;
198:
199: for tlinfo in CSR_HR_NAVIGATION_UNITS_TL loop
200: if (tlinfo.BASELANG = 'Y') then
201: if ( ((tlinfo.DEFAULT_LABEL = X_DEFAULT_LABEL)
202: OR ((tlinfo.DEFAULT_LABEL is null) AND (X_DEFAULT_LABEL is null)))
203: ) then

Line 255: update HR_NAVIGATION_UNITS_TL

251: hr_utility.set_message_token('STEP','1');
252: hr_utility.raise_error;
253: end if;
254:
255: update HR_NAVIGATION_UNITS_TL
256: set
257: DEFAULT_LABEL = X_DEFAULT_LABEL,
258: SOURCE_LANG = userenv('LANG')
259: where NAV_UNIT_ID = X_NAV_UNIT_ID

Line 307: update HR_NAVIGATION_UNITS_TL

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update HR_NAVIGATION_UNITS_TL
308: set
309: DEFAULT_LABEL = X_DEFAULT_LABEL,
310: SOURCE_LANG = userenv('LANG')
311: where NAV_UNIT_ID = X_NAV_UNIT_ID

Line 323: delete from HR_NAVIGATION_UNITS_TL

319:
320: PROCEDURE Delete_Row(x_nav_unit_id varchar2, X_Rowid VARCHAR2) IS
321: BEGIN
322:
323: delete from HR_NAVIGATION_UNITS_TL
324: where NAV_UNIT_ID = X_NAV_UNIT_ID;
325:
326: if (sql%notfound) then
327: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

Line 349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(

345: PER_RIC_PKG.ref_info_rec('HR_NAV_UNIT_GLOBAL_USAGES',PER_RIC_PKG.column_info_tbl(
346: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
347: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODES',PER_RIC_PKG.column_info_tbl(
348: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),
349: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_UNITS_TL',PER_RIC_PKG.column_info_tbl(
350: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID', NULL,x_nav_unit_id, NULL)))),
351: p_ref_type=>'DEL');
352: --
353: -- Code Ends Here

Line 370: delete from HR_NAVIGATION_UNITS_TL T

366:
367: procedure ADD_LANGUAGE
368: is
369: begin
370: delete from HR_NAVIGATION_UNITS_TL T
371: where not exists
372: (select NULL
373: from HR_NAVIGATION_UNITS B
374: where B.NAV_UNIT_ID = T.NAV_UNIT_ID

Line 377: update HR_NAVIGATION_UNITS_TL T set (

373: from HR_NAVIGATION_UNITS B
374: where B.NAV_UNIT_ID = T.NAV_UNIT_ID
375: );
376:
377: update HR_NAVIGATION_UNITS_TL T set (
378: DEFAULT_LABEL
379: ) = (select
380: B.DEFAULT_LABEL
381: from HR_NAVIGATION_UNITS_TL B

Line 381: from HR_NAVIGATION_UNITS_TL B

377: update HR_NAVIGATION_UNITS_TL T set (
378: DEFAULT_LABEL
379: ) = (select
380: B.DEFAULT_LABEL
381: from HR_NAVIGATION_UNITS_TL B
382: where B.NAV_UNIT_ID = T.NAV_UNIT_ID
383: and B.LANGUAGE = T.SOURCE_LANG)
384: where (
385: T.NAV_UNIT_ID,

Line 390: from HR_NAVIGATION_UNITS_TL SUBB, HR_NAVIGATION_UNITS_TL SUBT

386: T.LANGUAGE
387: ) in (select
388: SUBT.NAV_UNIT_ID,
389: SUBT.LANGUAGE
390: from HR_NAVIGATION_UNITS_TL SUBB, HR_NAVIGATION_UNITS_TL SUBT
391: where SUBB.NAV_UNIT_ID = SUBT.NAV_UNIT_ID
392: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
393: and (SUBB.DEFAULT_LABEL <> SUBT.DEFAULT_LABEL
394: or (SUBB.DEFAULT_LABEL is null and SUBT.DEFAULT_LABEL is not null)

Line 398: insert into HR_NAVIGATION_UNITS_TL (

394: or (SUBB.DEFAULT_LABEL is null and SUBT.DEFAULT_LABEL is not null)
395: or (SUBB.DEFAULT_LABEL is not null and SUBT.DEFAULT_LABEL is null)
396: ));
397:
398: insert into HR_NAVIGATION_UNITS_TL (
399: NAV_UNIT_ID,
400: DEFAULT_LABEL,
401: LANGUAGE,
402: SOURCE_LANG

Line 408: from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L

404: B.NAV_UNIT_ID,
405: B.DEFAULT_LABEL,
406: L.LANGUAGE_CODE,
407: B.SOURCE_LANG
408: from HR_NAVIGATION_UNITS_TL B, FND_LANGUAGES L
409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL

Line 413: from HR_NAVIGATION_UNITS_TL T

409: where L.INSTALLED_FLAG in ('I', 'B')
410: and B.LANGUAGE = userenv('LANG')
411: and not exists
412: (select NULL
413: from HR_NAVIGATION_UNITS_TL T
414: where T.NAV_UNIT_ID = B.NAV_UNIT_ID
415: and T.LANGUAGE = L.LANGUAGE_CODE);
416:
417: end ADD_LANGUAGE;

Line 514: FROM HR_NAVIGATION_UNITS_TL

510: Y_SOURCE_LANG varchar2(4);
511: --
512: Cursor database_row(p_nav_unit_id number) IS
513: SELECT DEFAULT_LABEL, SOURCE_LANG
514: FROM HR_NAVIGATION_UNITS_TL
515: WHERE userenv('LANG') in (LANGUAGE,SOURCE_LANG)
516: AND nav_unit_id = p_nav_unit_id;
517: --
518: begin

Line 535: update HR_NAVIGATION_UNITS_TL

531: if database_row%found then
532: if X_DEFAULT_LABEL <> Y_DEFAULT_LABEL OR
533: Y_SOURCE_LANG <> userenv('LANG') THEN
534:
535: update HR_NAVIGATION_UNITS_TL
536: set DEFAULT_LABEL = X_DEFAULT_LABEL,
537: SOURCE_LANG = userenv('LANG')
538: where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
539: and nav_unit_id = x_nav_unit_id;