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

Line 1: PACKAGE BODY HR_NAVIGATION_UNITS_PKG as

1: PACKAGE BODY HR_NAVIGATION_UNITS_PKG as
2: /* $Header: pewfl01t.pkb 120.1 2011/04/28 09:45:15 sidsaxen ship $ */
3: procedure OWNER_TO_WHO (
4: X_OWNER in VARCHAR2,
5: X_CREATION_DATE out nocopy DATE,

Line 34: CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS

30: X_Max_Number_Of_Nav_Buttons NUMBER,
31: X_Block_Name VARCHAR2,
32: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
33: ) IS
34: CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS
35:
36: WHERE nav_unit_id = X_Nav_Unit_Id;
37:
38: CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;

Line 38: CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;

34: CURSOR C IS SELECT rowid FROM HR_NAVIGATION_UNITS
35:
36: WHERE nav_unit_id = X_Nav_Unit_Id;
37:
38: CURSOR C2 IS SELECT hr_navigation_units_s.nextval FROM sys.dual;
39: l_language_code varchar2(3);
40: BEGIN
41:
42: -- Validate the language parameter. l_language_code should be passed

Line 59: p_entity_name=>'HR_NAVIGATION_UNITS',

55: -- Added the following code as a part of Zero Downtime Patching Project.
56: -- Code Starts Here.
57: --
58: per_ric_pkg.Chk_integrity(
59: p_entity_name=>'HR_NAVIGATION_UNITS',
60: p_ref_entity=>'HR_WORKFLOWS',
61: p_ref_column_name=>'DEFAULT_WORKFLOW_ID',
62: p_ref_col_value_number=>X_Default_Workflow_Id,
63: p_ref_col_value_varchar=>NULL,

Line 70: INSERT INTO HR_NAVIGATION_UNITS(

66: --
67: -- Code Ends Here
68: --
69:
70: INSERT INTO HR_NAVIGATION_UNITS(
71: nav_unit_id,
72: default_workflow_id,
73: application_abbrev,
74: default_label,

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 93: p_ref_entity=>'HR_NAVIGATION_UNITS',

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,
97: p_ref_col_value_date=>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 144: FROM HR_NAVIGATION_UNITS

140: X_Block_Name VARCHAR2
141: ) IS
142: CURSOR C IS
143: SELECT *
144: FROM HR_NAVIGATION_UNITS
145: WHERE rowid = X_Rowid
146: FOR UPDATE of Nav_Unit_Id NOWAIT;
147: Recinfo C%ROWTYPE;
148:

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 237: UPDATE HR_NAVIGATION_UNITS

233: --
234: l_language_code := x_language_code;
235: hr_api.validate_language_code(p_language_code => l_language_code);
236:
237: UPDATE HR_NAVIGATION_UNITS
238: SET
239: nav_unit_id = X_Nav_Unit_Id,
240: default_workflow_id = X_Default_Workflow_Id,
241: application_abbrev = X_Application_Abbrev,

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 294: update HR_NAVIGATION_UNITS set

290: l_language_code := x_language_code;
291: hr_api.validate_language_code(p_language_code => l_language_code);
292:
293:
294: update HR_NAVIGATION_UNITS set
295: DEFAULT_WORKFLOW_ID = X_DEFAULT_WORKFLOW_ID,
296: APPLICATION_ABBREV = X_APPLICATION_ABBREV,
297: DEFAULT_LABEL = X_DEFAULT_LABEL,
298: FORM_NAME = X_FORM_NAME,

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 338: p_entity_name=> 'HR_NAVIGATION_UNITS',

334: -- Added the following code as a part of Zero Downtime Patching Project.
335: -- Code Starts Here.
336: --
337: PER_RIC_PKG.chk_integrity(
338: p_entity_name=> 'HR_NAVIGATION_UNITS',
339: p_ref_entity_info =>
340: PER_RIC_PKG.ref_entity_tbl(
341: PER_RIC_PKG.ref_info_rec('HR_INCOMPATIBILITY_RULES',PER_RIC_PKG.column_info_tbl(
342: PER_RIC_PKG.col_info_rec('FROM_NAV_UNIT_ID',NULL, x_nav_unit_id,NULL))),

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 356: DELETE FROM HR_NAVIGATION_UNITS

352: --
353: -- Code Ends Here
354: --
355:
356: DELETE FROM HR_NAVIGATION_UNITS
357: WHERE rowid = X_Rowid;
358:
359: if (SQL%NOTFOUND) then
360: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

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 373: from HR_NAVIGATION_UNITS B

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
375: );
376:
377: update HR_NAVIGATION_UNITS_TL T set (

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 454: from hr_navigation_units

450: begin
451: select NAV_UNIT_ID,DEFAULT_WORKFLOW_ID, APPLICATION_ABBREV, DEFAULT_LABEL,MAX_NUMBER_OF_NAV_BUTTONS
452: into X_NAV_UNIT_ID, Y_DEFAULT_WORKFLOW_ID, Y_APPLICATION_ABBREV,
453: Y_DEFAULT_LABEL,Y_MAX_NUMBER_OF_NAV_BUTTONS
454: from hr_navigation_units
455: where FORM_NAME = X_FORM_NAME
456: and nvl(block_name,hr_api.g_varchar2) = nvl(x_block_name,hr_api.g_varchar2);
457:
458: --

Line 481: select HR_NAVIGATION_UNITS_S.NEXTVAL

477: END IF;
478:
479: exception
480: when no_data_found then
481: select HR_NAVIGATION_UNITS_S.NEXTVAL
482: into X_NAV_UNIT_ID
483: from dual;
484:
485: INSERT_ROW(

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 521: from hr_navigation_units

517: --
518: begin
519: select nav_unit_id
520: into x_nav_unit_id
521: from hr_navigation_units
522: where FORM_NAME = X_FORM_NAME
523: and ( (BLOCK_NAME = X_BLOCK_NAME)
524: or (BLOCK_NAME is null and X_BLOCK_NAME is null));
525:

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;

Line 560: END HR_NAVIGATION_UNITS_PKG;

556: --
557: end TRANSLATE_ROW;
558:
559:
560: END HR_NAVIGATION_UNITS_PKG;