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.0 2005/05/31 01:37:32 appldev noship $ */
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 47: insert into HR_NAVIGATION_PATHS (

43: --
44: l_language_code := x_language_code;
45: hr_api.validate_language_code(p_language_code => l_language_code);
46:
47: insert into HR_NAVIGATION_PATHS (
48: NAV_PATH_ID,
49: FROM_NAV_NODE_USAGE_ID,
50: TO_NAV_NODE_USAGE_ID,
51: NAV_BUTTON_REQUIRED,

Line 63: INSERT INTO HR_NAVIGATION_PATHS_TL(

59: X_SEQUENCE,
60: X_OVERRIDE_LABEL
61: );
62:
63: INSERT INTO HR_NAVIGATION_PATHS_TL(
64: nav_path_id,
65: override_label,
66: language,
67: source_lang)

Line 77: from HR_NAVIGATION_PATHS_TL T

73: from FND_LANGUAGES L
74: where L.INSTALLED_FLAG in ('I', 'B')
75: and not exists
76: (select NULL
77: from HR_NAVIGATION_PATHS_TL T
78: where T.NAV_PATH_ID = X_NAV_PATH_ID
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:
81: open c;

Line 105: from HR_NAVIGATION_PATHS

101: TO_NAV_NODE_USAGE_ID,
102: NAV_BUTTON_REQUIRED,
103: SEQUENCE,
104: OVERRIDE_LABEL
105: from HR_NAVIGATION_PATHS
106: where NAV_PATH_ID = X_NAV_PATH_ID
107: for update of NAV_PATH_ID nowait;
108:
109: cursor CSR_HR_NAVIGATION_PATHS_TL is

Line 109: cursor CSR_HR_NAVIGATION_PATHS_TL is

105: from HR_NAVIGATION_PATHS
106: where NAV_PATH_ID = X_NAV_PATH_ID
107: for update of NAV_PATH_ID nowait;
108:
109: cursor CSR_HR_NAVIGATION_PATHS_TL is
110: select OVERRIDE_LABEL,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from HR_NAVIGATION_PATHS_TL TL
113: where nav_path_id = x_nav_path_id

Line 112: from HR_NAVIGATION_PATHS_TL TL

108:
109: cursor CSR_HR_NAVIGATION_PATHS_TL is
110: select OVERRIDE_LABEL,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from HR_NAVIGATION_PATHS_TL TL
113: where nav_path_id = x_nav_path_id
114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
115: for update of nav_path_id nowait;
116:

Line 132: for tlinf in CSR_HR_NAVIGATION_PATHS_TL loop

128: app_exception.raise_exception;
129: end if;
130: end loop;
131:
132: for tlinf in CSR_HR_NAVIGATION_PATHS_TL loop
133: if (tlinf.BASELANG = 'Y') then
134: if ( ((tlinf.OVERRIDE_LABEL = X_OVERRIDE_LABEL)
135: OR ((tlinf.OVERRIDE_LABEL is null) AND (X_OVERRIDE_LABEL is null)))
136: ) then

Line 166: update HR_NAVIGATION_PATHS set

162: --
163: l_language_code := x_language_code;
164: hr_api.validate_language_code(p_language_code => l_language_code);
165:
166: update HR_NAVIGATION_PATHS set
167: FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID,
168: TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID,
169: NAV_BUTTON_REQUIRED = X_NAV_BUTTON_REQUIRED,
170: SEQUENCE = X_SEQUENCE,

Line 178: update HR_NAVIGATION_PATHS_TL

174: if (sql%notfound) then
175: raise no_data_found;
176: end if;
177:
178: update HR_NAVIGATION_PATHS_TL
179: set
180: OVERRIDE_LABEL = X_OVERRIDE_LABEL,
181: SOURCE_LANG = userenv('LANG')
182: where NAV_PATH_ID = X_NAV_PATH_ID

Line 196: delete from HR_NAVIGATION_PATHS_TL

192: X_NAV_PATH_ID in NUMBER
193: ) is
194: begin
195:
196: delete from HR_NAVIGATION_PATHS_TL
197: where NAV_PATH_ID = X_NAV_PATH_ID;
198:
199: if (sql%notfound) then
200: raise no_data_found;

Line 203: delete from HR_NAVIGATION_PATHS

199: if (sql%notfound) then
200: raise no_data_found;
201: end if;
202:
203: delete from HR_NAVIGATION_PATHS
204: where NAV_PATH_ID = X_NAV_PATH_ID;
205:
206: if (sql%notfound) then
207: raise no_data_found;

Line 215: delete from HR_NAVIGATION_PATHS_TL T

211:
212: procedure ADD_LANGUAGE
213: is
214: begin
215: delete from HR_NAVIGATION_PATHS_TL T
216: where not exists
217: (select NULL
218: from HR_NAVIGATION_PATHS B
219: where B.NAV_PATH_ID = T.NAV_PATH_ID

Line 218: from HR_NAVIGATION_PATHS B

214: begin
215: delete from HR_NAVIGATION_PATHS_TL T
216: where not exists
217: (select NULL
218: from HR_NAVIGATION_PATHS B
219: where B.NAV_PATH_ID = T.NAV_PATH_ID
220: );
221:
222: update HR_NAVIGATION_PATHS_TL T set (

Line 222: update HR_NAVIGATION_PATHS_TL T set (

218: from HR_NAVIGATION_PATHS B
219: where B.NAV_PATH_ID = T.NAV_PATH_ID
220: );
221:
222: update HR_NAVIGATION_PATHS_TL T set (
223: OVERRIDE_LABEL
224: ) = (select
225: B.OVERRIDE_LABEL
226: from HR_NAVIGATION_PATHS_TL B

Line 226: from HR_NAVIGATION_PATHS_TL B

222: update HR_NAVIGATION_PATHS_TL T set (
223: OVERRIDE_LABEL
224: ) = (select
225: B.OVERRIDE_LABEL
226: from HR_NAVIGATION_PATHS_TL B
227: where B.NAV_PATH_ID = T.NAV_PATH_ID
228: and B.LANGUAGE = T.SOURCE_LANG)
229: where (
230: T.NAV_PATH_ID,

Line 235: from HR_NAVIGATION_PATHS_TL SUBB, HR_NAVIGATION_PATHS_TL SUBT

231: T.LANGUAGE
232: ) in (select
233: SUBT.NAV_PATH_ID,
234: SUBT.LANGUAGE
235: from HR_NAVIGATION_PATHS_TL SUBB, HR_NAVIGATION_PATHS_TL SUBT
236: where SUBB.NAV_PATH_ID = SUBT.NAV_PATH_ID
237: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
238: and (SUBB.OVERRIDE_LABEL <> SUBT.OVERRIDE_LABEL
239: or (SUBB.OVERRIDE_LABEL is null and SUBT.OVERRIDE_LABEL is not null)

Line 243: insert into HR_NAVIGATION_PATHS_TL (

239: or (SUBB.OVERRIDE_LABEL is null and SUBT.OVERRIDE_LABEL is not null)
240: or (SUBB.OVERRIDE_LABEL is not null and SUBT.OVERRIDE_LABEL is null)
241: ));
242:
243: insert into HR_NAVIGATION_PATHS_TL (
244: NAV_PATH_ID,
245: OVERRIDE_LABEL,
246: LANGUAGE,
247: SOURCE_LANG

Line 253: from HR_NAVIGATION_PATHS_TL B, FND_LANGUAGES L

249: B.NAV_PATH_ID,
250: B.OVERRIDE_LABEL,
251: L.LANGUAGE_CODE,
252: B.SOURCE_LANG
253: from HR_NAVIGATION_PATHS_TL B, FND_LANGUAGES L
254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL

Line 258: from HR_NAVIGATION_PATHS_TL T

254: where L.INSTALLED_FLAG in ('I', 'B')
255: and B.LANGUAGE = userenv('LANG')
256: and not exists
257: (select NULL
258: from HR_NAVIGATION_PATHS_TL T
259: where T.NAV_PATH_ID = B.NAV_PATH_ID
260: and T.LANGUAGE = L.LANGUAGE_CODE);
261: end ADD_LANGUAGE;
262:

Line 354: from HR_NAVIGATION_PATHS

350: if l_flag = 'Y' then
351: begin
352: select NAV_PATH_ID
353: into X_NAV_PATH_ID
354: from HR_NAVIGATION_PATHS
355: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
356: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
357: exception
358: when no_data_found then

Line 359: select HR_NAVIGATION_PATHS_S.NEXTVAL

355: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
356: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
357: exception
358: when no_data_found then
359: select HR_NAVIGATION_PATHS_S.NEXTVAL
360: into X_NAV_PATH_ID
361: from dual;
362: end;
363:

Line 467: from HR_NAVIGATION_PATHS

463:
464: begin
465: select NAV_PATH_ID
466: into X_NAV_PATH_ID
467: from HR_NAVIGATION_PATHS
468: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
469: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
470: exception
471: when no_data_found then

Line 472: select HR_NAVIGATION_PATHS_S.NEXTVAL

468: where FROM_NAV_NODE_USAGE_ID = X_FROM_NAV_NODE_USAGE_ID
469: and TO_NAV_NODE_USAGE_ID = X_TO_NAV_NODE_USAGE_ID;
470: exception
471: when no_data_found then
472: select HR_NAVIGATION_PATHS_S.NEXTVAL
473: into X_NAV_PATH_ID
474: from dual;
475: end;
476:

Line 478: update HR_NAVIGATION_PATHS_TL

474: from dual;
475: end;
476:
477: begin
478: update HR_NAVIGATION_PATHS_TL
479: set OVERRIDE_LABEL = X_OVERRIDE_LABEL,
480: SOURCE_LANG = userenv('LANG')
481: where userenv('LANG') in (LANGUAGE,SOURCE_LANG)
482: and nav_path_id = x_nav_path_id;

Line 495: end HR_NAVIGATION_PATHS_PKG;

491: raise;
492: -- Fix for bug 4109347 ends here.
493: end TRANSLATE_ROW;
494:
495: end HR_NAVIGATION_PATHS_PKG;