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_PATHS_PKG dependencies on HR_NAVIGATION_PATHS

Line 1: package body HR_NAVIGATION_PATHS_PKG as

1: package body HR_NAVIGATION_PATHS_PKG as
2: /* $Header: hrnvplct.pkb 120.3 2011/05/20 05:36:12 vepravee ship $ */
3:
4: procedure OWNER_TO_WHO (
5: X_OWNER in VARCHAR2,

Line 36: cursor C is select ROWID from HR_NAVIGATION_PATHS

32: X_OVERRIDE_LABEL in VARCHAR2,
33: X_LANGUAGE_CODE in varchar2 default hr_api.userenv_lang
34: ) is
35: l_language_code varchar2(3);
36: cursor C is select ROWID from HR_NAVIGATION_PATHS
37: where NAV_PATH_ID = X_NAV_PATH_ID
38: ;
39: begin
40: -- Validate the language parameter. l_language_code should be passed

Line 55: p_entity_name => 'HR_NAVIGATION_PATHS',

51:
52: /* Commented and Added as a part of fix for bug#12554709 Starts
53: BEGIN
54: PER_RIC_PKG.chk_integrity (
55: p_entity_name => 'HR_NAVIGATION_PATHS',
56: p_ref_entity => 'HR_NAVIGATION_NODE_USAGES',
57: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
58: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL) ,
59: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_TO_NAV_NODE_USAGE_ID,NULL)

Line 67: p_entity_name => 'HR_NAVIGATION_PATHS',

63: END;*/
64:
65: BEGIN
66: PER_RIC_PKG.chk_integrity (
67: p_entity_name => 'HR_NAVIGATION_PATHS',
68: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
69: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(
70: PER_RIC_PKG.col_info_rec('NAV_NODE_USAGE_ID',NULL,X_FROM_NAV_NODE_USAGE_ID,NULL))),
71: PER_RIC_PKG.ref_info_rec('HR_NAVIGATION_NODE_USAGES', PER_RIC_PKG.column_info_tbl(

Line 84: insert into HR_NAVIGATION_PATHS (

80: --
81: -- Code Ends Here.
82: --
83:
84: insert into HR_NAVIGATION_PATHS (
85: NAV_PATH_ID,
86: FROM_NAV_NODE_USAGE_ID,
87: TO_NAV_NODE_USAGE_ID,
88: NAV_BUTTON_REQUIRED,

Line 108: p_entity_name => 'HR_NAVIGATION_PATHS_TL',

104: --
105:
106: BEGIN
107: PER_RIC_PKG.chk_integrity (
108: p_entity_name => 'HR_NAVIGATION_PATHS_TL',
109: p_ref_entity => 'HR_NAVIGATION_PATHS',
110: p_ref_column_name => 'NAV_PATH_ID',
111: p_ref_col_value_number => X_NAV_PATH_ID,
112: p_ref_col_value_varchar => NULL,

Line 109: p_ref_entity => 'HR_NAVIGATION_PATHS',

105:
106: BEGIN
107: PER_RIC_PKG.chk_integrity (
108: p_entity_name => 'HR_NAVIGATION_PATHS_TL',
109: p_ref_entity => 'HR_NAVIGATION_PATHS',
110: p_ref_column_name => 'NAV_PATH_ID',
111: p_ref_col_value_number => X_NAV_PATH_ID,
112: p_ref_col_value_varchar => NULL,
113: p_ref_col_value_date => NULL,

Line 121: INSERT INTO HR_NAVIGATION_PATHS_TL(

117: --
118: -- Code Ends Here.
119: --
120:
121: INSERT INTO HR_NAVIGATION_PATHS_TL(
122: nav_path_id,
123: override_label,
124: language,
125: source_lang)

Line 135: from HR_NAVIGATION_PATHS_TL T

131: from FND_LANGUAGES L
132: where L.INSTALLED_FLAG in ('I', 'B')
133: and not exists
134: (select NULL
135: from HR_NAVIGATION_PATHS_TL T
136: where T.NAV_PATH_ID = X_NAV_PATH_ID
137: and T.LANGUAGE = L.LANGUAGE_CODE);
138:
139: open c;

Line 163: from HR_NAVIGATION_PATHS

159: TO_NAV_NODE_USAGE_ID,
160: NAV_BUTTON_REQUIRED,
161: SEQUENCE,
162: OVERRIDE_LABEL
163: from HR_NAVIGATION_PATHS
164: where NAV_PATH_ID = X_NAV_PATH_ID
165: for update of NAV_PATH_ID nowait;
166:
167: cursor CSR_HR_NAVIGATION_PATHS_TL is

Line 167: cursor CSR_HR_NAVIGATION_PATHS_TL is

163: from HR_NAVIGATION_PATHS
164: where NAV_PATH_ID = X_NAV_PATH_ID
165: for update of NAV_PATH_ID nowait;
166:
167: cursor CSR_HR_NAVIGATION_PATHS_TL is
168: select OVERRIDE_LABEL,
169: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
170: from HR_NAVIGATION_PATHS_TL TL
171: where nav_path_id = x_nav_path_id

Line 170: from HR_NAVIGATION_PATHS_TL TL

166:
167: cursor CSR_HR_NAVIGATION_PATHS_TL is
168: select OVERRIDE_LABEL,
169: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
170: from HR_NAVIGATION_PATHS_TL TL
171: where nav_path_id = x_nav_path_id
172: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
173: for update of nav_path_id nowait;
174:

Line 190: for tlinf in CSR_HR_NAVIGATION_PATHS_TL loop

186: app_exception.raise_exception;
187: end if;
188: end loop;
189:
190: for tlinf in CSR_HR_NAVIGATION_PATHS_TL loop
191: if (tlinf.BASELANG = 'Y') then
192: if ( ((tlinf.OVERRIDE_LABEL = X_OVERRIDE_LABEL)
193: OR ((tlinf.OVERRIDE_LABEL is null) AND (X_OVERRIDE_LABEL is null)))
194: ) then

Line 224: update HR_NAVIGATION_PATHS set

220: --
221: l_language_code := x_language_code;
222: hr_api.validate_language_code(p_language_code => l_language_code);
223:
224: update HR_NAVIGATION_PATHS set
225: FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID,
226: TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID,
227: NAV_BUTTON_REQUIRED = X_NAV_BUTTON_REQUIRED,
228: SEQUENCE = X_SEQUENCE,

Line 236: update HR_NAVIGATION_PATHS_TL

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: update HR_NAVIGATION_PATHS_TL
237: set
238: OVERRIDE_LABEL = X_OVERRIDE_LABEL,
239: SOURCE_LANG = userenv('LANG')
240: where NAV_PATH_ID = X_NAV_PATH_ID

Line 254: delete from HR_NAVIGATION_PATHS_TL

250: X_NAV_PATH_ID in NUMBER
251: ) is
252: begin
253:
254: delete from HR_NAVIGATION_PATHS_TL
255: where NAV_PATH_ID = X_NAV_PATH_ID;
256:
257: if (sql%notfound) then
258: raise no_data_found;

Line 261: delete from HR_NAVIGATION_PATHS

257: if (sql%notfound) then
258: raise no_data_found;
259: end if;
260:
261: delete from HR_NAVIGATION_PATHS
262: where NAV_PATH_ID = X_NAV_PATH_ID;
263:
264: if (sql%notfound) then
265: raise no_data_found;

Line 273: delete from HR_NAVIGATION_PATHS_TL T

269:
270: procedure ADD_LANGUAGE
271: is
272: begin
273: delete from HR_NAVIGATION_PATHS_TL T
274: where not exists
275: (select NULL
276: from HR_NAVIGATION_PATHS B
277: where B.NAV_PATH_ID = T.NAV_PATH_ID

Line 276: from HR_NAVIGATION_PATHS B

272: begin
273: delete from HR_NAVIGATION_PATHS_TL T
274: where not exists
275: (select NULL
276: from HR_NAVIGATION_PATHS B
277: where B.NAV_PATH_ID = T.NAV_PATH_ID
278: );
279:
280: update HR_NAVIGATION_PATHS_TL T set (

Line 280: update HR_NAVIGATION_PATHS_TL T set (

276: from HR_NAVIGATION_PATHS B
277: where B.NAV_PATH_ID = T.NAV_PATH_ID
278: );
279:
280: update HR_NAVIGATION_PATHS_TL T set (
281: OVERRIDE_LABEL
282: ) = (select
283: B.OVERRIDE_LABEL
284: from HR_NAVIGATION_PATHS_TL B

Line 284: from HR_NAVIGATION_PATHS_TL B

280: update HR_NAVIGATION_PATHS_TL T set (
281: OVERRIDE_LABEL
282: ) = (select
283: B.OVERRIDE_LABEL
284: from HR_NAVIGATION_PATHS_TL B
285: where B.NAV_PATH_ID = T.NAV_PATH_ID
286: and B.LANGUAGE = T.SOURCE_LANG)
287: where (
288: T.NAV_PATH_ID,

Line 293: from HR_NAVIGATION_PATHS_TL SUBB, HR_NAVIGATION_PATHS_TL SUBT

289: T.LANGUAGE
290: ) in (select
291: SUBT.NAV_PATH_ID,
292: SUBT.LANGUAGE
293: from HR_NAVIGATION_PATHS_TL SUBB, HR_NAVIGATION_PATHS_TL SUBT
294: where SUBB.NAV_PATH_ID = SUBT.NAV_PATH_ID
295: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
296: and (SUBB.OVERRIDE_LABEL <> SUBT.OVERRIDE_LABEL
297: or (SUBB.OVERRIDE_LABEL is null and SUBT.OVERRIDE_LABEL is not null)

Line 301: insert into HR_NAVIGATION_PATHS_TL (

297: or (SUBB.OVERRIDE_LABEL is null and SUBT.OVERRIDE_LABEL is not null)
298: or (SUBB.OVERRIDE_LABEL is not null and SUBT.OVERRIDE_LABEL is null)
299: ));
300:
301: insert into HR_NAVIGATION_PATHS_TL (
302: NAV_PATH_ID,
303: OVERRIDE_LABEL,
304: LANGUAGE,
305: SOURCE_LANG

Line 311: from HR_NAVIGATION_PATHS_TL B, FND_LANGUAGES L

307: B.NAV_PATH_ID,
308: B.OVERRIDE_LABEL,
309: L.LANGUAGE_CODE,
310: B.SOURCE_LANG
311: from HR_NAVIGATION_PATHS_TL B, FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL

Line 316: from HR_NAVIGATION_PATHS_TL T

312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL
316: from HR_NAVIGATION_PATHS_TL T
317: where T.NAV_PATH_ID = B.NAV_PATH_ID
318: and T.LANGUAGE = L.LANGUAGE_CODE);
319: end ADD_LANGUAGE;
320:

Line 412: from HR_NAVIGATION_PATHS

408: if l_flag = 'Y' then
409: begin
410: select NAV_PATH_ID
411: into X_NAV_PATH_ID
412: from HR_NAVIGATION_PATHS
413: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
414: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
415: exception
416: when no_data_found then

Line 417: select HR_NAVIGATION_PATHS_S.NEXTVAL

413: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
414: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
415: exception
416: when no_data_found then
417: select HR_NAVIGATION_PATHS_S.NEXTVAL
418: into X_NAV_PATH_ID
419: from dual;
420: end;
421:

Line 525: from HR_NAVIGATION_PATHS

521:
522: begin
523: select NAV_PATH_ID
524: into X_NAV_PATH_ID
525: from HR_NAVIGATION_PATHS
526: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
527: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
528: exception
529: when no_data_found then

Line 530: select HR_NAVIGATION_PATHS_S.NEXTVAL

526: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
527: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
528: exception
529: when no_data_found then
530: select HR_NAVIGATION_PATHS_S.NEXTVAL
531: into X_NAV_PATH_ID
532: from dual;
533: end;
534:

Line 536: update HR_NAVIGATION_PATHS_TL

532: from dual;
533: end;
534:
535: begin
536: update HR_NAVIGATION_PATHS_TL
537: set OVERRIDE_LABEL = X_OVERRIDE_LABEL,
538: SOURCE_LANG = userenv('LANG')
539: where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
540: and nav_path_id = x_nav_path_id;

Line 553: end HR_NAVIGATION_PATHS_PKG;

549: raise;
550: -- Fix for bug 4109347 ends here.
551: end TRANSLATE_ROW;
552:
553: end HR_NAVIGATION_PATHS_PKG;