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_ORG_INFORMATION_TYPES_PKG dependencies on HR_ORG_INFORMATION_TYPES

Line 1: package body HR_ORG_INFORMATION_TYPES_PKG as

1: package body HR_ORG_INFORMATION_TYPES_PKG as
2: /* $Header: peoit01t.pkb 120.3 2006/05/25 08:14:28 srenukun noship $ */
3: --
4: function APPLICATION_ID (
5: X_APPLICATION_SHORT_NAME in VARCHAR2

Line 57: insert into HR_ORG_INFORMATION_TYPES (

53: X_LAST_UPDATED_BY in NUMBER,
54: X_LAST_UPDATE_LOGIN in NUMBER
55: ) is
56: begin
57: insert into HR_ORG_INFORMATION_TYPES (
58: ORG_INFORMATION_TYPE,
59: DESTINATION,
60: LEGISLATION_CODE,
61: NAVIGATION_METHOD,

Line 85: insert into HR_ORG_INFORMATION_TYPES_TL (

81: X_LAST_UPDATED_BY,
82: X_LAST_UPDATE_LOGIN
83: );
84:
85: insert into HR_ORG_INFORMATION_TYPES_TL (
86: ORG_INFORMATION_TYPE,
87: DISPLAYED_ORG_INFORMATION_TYPE,
88: CREATED_BY,
89: CREATION_DATE,

Line 109: from HR_ORG_INFORMATION_TYPES_TL T

105: from FND_LANGUAGES L
106: where L.INSTALLED_FLAG in ('I', 'B')
107: and not exists
108: (select NULL
109: from HR_ORG_INFORMATION_TYPES_TL T
110: where T.ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
111: and T.LANGUAGE = L.LANGUAGE_CODE);
112:
113: end INSERT_ROW;

Line 132: from HR_ORG_INFORMATION_TYPES

128: ,LEGISLATION_CODE
129: ,NAVIGATION_METHOD
130: ,FND_APPLICATION_ID
131: ,DESCRIPTION
132: from HR_ORG_INFORMATION_TYPES
133: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
134: for update of ORG_INFORMATION_TYPE nowait;
135: RECINFO CSR_ORG_INFORMATION_TYPE%rowtype;
136:

Line 140: from HR_ORG_INFORMATION_TYPES_TL

136:
137: cursor CSR_ORG_INFORMATION_TYPE_TL is
138: select DISPLAYED_ORG_INFORMATION_TYPE,
139: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
140: from HR_ORG_INFORMATION_TYPES_TL
141: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
142: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
143: for update of ORG_INFORMATION_TYPE nowait;
144:

Line 200: update HR_ORG_INFORMATION_TYPES set

196: X_LAST_UPDATED_BY in NUMBER,
197: X_LAST_UPDATE_LOGIN in NUMBER
198: ) is
199: begin
200: update HR_ORG_INFORMATION_TYPES set
201: DESTINATION = X_DESTINATION,
202: LEGISLATION_CODE = X_LEGISLATION_CODE,
203: NAVIGATION_METHOD = X_NAVIGATION_METHOD,
204: FND_APPLICATION_ID = X_FND_APPLICATION_ID,

Line 215: update HR_ORG_INFORMATION_TYPES_TL set

211: if (sql%notfound) then
212: raise no_data_found;
213: end if;
214:
215: update HR_ORG_INFORMATION_TYPES_TL set
216: DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
217: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
219: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 234: delete from HR_ORG_INFORMATION_TYPES_TL

230: procedure DELETE_ROW (
231: X_ORG_INFORMATION_TYPE in VARCHAR2
232: ) is
233: begin
234: delete from HR_ORG_INFORMATION_TYPES_TL
235: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
236:
237: if (sql%notfound) then
238: raise no_data_found;

Line 241: delete from HR_ORG_INFORMATION_TYPES

237: if (sql%notfound) then
238: raise no_data_found;
239: end if;
240:
241: delete from HR_ORG_INFORMATION_TYPES
242: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
243: if (sql%notfound) then
244: raise no_data_found;
245: end if;

Line 251: delete from HR_ORG_INFORMATION_TYPES_TL T

247: --
248: procedure ADD_LANGUAGE
249: is
250: begin
251: delete from HR_ORG_INFORMATION_TYPES_TL T
252: where not exists
253: (select NULL
254: from HR_ORG_INFORMATION_TYPES B
255: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE

Line 254: from HR_ORG_INFORMATION_TYPES B

250: begin
251: delete from HR_ORG_INFORMATION_TYPES_TL T
252: where not exists
253: (select NULL
254: from HR_ORG_INFORMATION_TYPES B
255: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
256: );
257:
258: update HR_ORG_INFORMATION_TYPES_TL T set (

Line 258: update HR_ORG_INFORMATION_TYPES_TL T set (

254: from HR_ORG_INFORMATION_TYPES B
255: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
256: );
257:
258: update HR_ORG_INFORMATION_TYPES_TL T set (
259: DISPLAYED_ORG_INFORMATION_TYPE
260: ) = (select
261: B.DISPLAYED_ORG_INFORMATION_TYPE
262: from HR_ORG_INFORMATION_TYPES_TL B

Line 262: from HR_ORG_INFORMATION_TYPES_TL B

258: update HR_ORG_INFORMATION_TYPES_TL T set (
259: DISPLAYED_ORG_INFORMATION_TYPE
260: ) = (select
261: B.DISPLAYED_ORG_INFORMATION_TYPE
262: from HR_ORG_INFORMATION_TYPES_TL B
263: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (
266: T.ORG_INFORMATION_TYPE,

Line 271: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT

267: T.LANGUAGE
268: ) in (select
269: SUBT.ORG_INFORMATION_TYPE,
270: SUBT.LANGUAGE
271: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT
272: where SUBB.ORG_INFORMATION_TYPE = SUBT.ORG_INFORMATION_TYPE
273: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
274: and (SUBB.DISPLAYED_ORG_INFORMATION_TYPE <> SUBT.DISPLAYED_ORG_INFORMATION_TYPE
275: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)

Line 279: insert into HR_ORG_INFORMATION_TYPES_TL (

275: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)
276: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is not null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is null)
277: ));
278:
279: insert into HR_ORG_INFORMATION_TYPES_TL (
280: ORG_INFORMATION_TYPE,
281: DISPLAYED_ORG_INFORMATION_TYPE,
282: CREATED_BY,
283: CREATION_DATE,

Line 299: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L

295: B.LAST_UPDATE_DATE,
296: B.LAST_UPDATE_LOGIN,
297: L.LANGUAGE_CODE,
298: B.SOURCE_LANG
299: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L
300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL

Line 304: from HR_ORG_INFORMATION_TYPES_TL T

300: where L.INSTALLED_FLAG in ('I', 'B')
301: and B.LANGUAGE = userenv('LANG')
302: and not exists
303: (select NULL
304: from HR_ORG_INFORMATION_TYPES_TL T
305: where T.ORG_INFORMATION_TYPE = B.ORG_INFORMATION_TYPE
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307: end ADD_LANGUAGE;
308:

Line 349: from HR_ORG_INFORMATION_TYPES

345: -- Translate char last_update_date to date
346: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
347: select LAST_UPDATED_BY, LAST_UPDATE_DATE
348: into db_luby, db_ludate
349: from HR_ORG_INFORMATION_TYPES
350: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
351:
352: -- Test for customization and version
353: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 356: HR_ORG_INFORMATION_TYPES_PKG.Update_Row(

352: -- Test for customization and version
353: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
354: db_ludate, X_CUSTOM_MODE)) then
355: -- Update existing row
356: HR_ORG_INFORMATION_TYPES_PKG.Update_Row(
357: X_ORG_INFORMATION_TYPE,
358: X_DESTINATION,
359: X_LEGISLATION_CODE,
360: X_NAVIGATION_METHOD,

Line 371: HR_ORG_INFORMATION_TYPES_PKG.Insert_Row(

367: END IF;
368: exception
369: when no_data_found then
370: -- Record doesn't exist - insert in all cases
371: HR_ORG_INFORMATION_TYPES_PKG.Insert_Row(
372: X_ORG_INFORMATION_TYPE,
373: X_DESTINATION,
374: X_LEGISLATION_CODE,
375: X_NAVIGATION_METHOD,

Line 423: from HR_ORG_INFORMATION_TYPES_TL

419: -- the correct row is fetched instead of multiple rows
420:
421: select LAST_UPDATED_BY, LAST_UPDATE_DATE
422: into db_luby, db_ludate
423: from HR_ORG_INFORMATION_TYPES_TL
424: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
425: and LANGUAGE=userenv('LANG');
426:
427: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 432: update HR_ORG_INFORMATION_TYPES_TL

428: db_ludate,X_CUSTOM_MODE)) then
429: -- Update translations for this language
430: -- bug 5235538 nls date issue, changed to LAST_UPDATE_DATE = f_ludate, LAST_UPDATED_BY = f_luby
431:
432: update HR_ORG_INFORMATION_TYPES_TL
433: set DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP
434: , LAST_UPDATE_DATE = f_ludate
435: , LAST_UPDATED_BY = f_luby
436: , LAST_UPDATE_LOGIN = 0

Line 448: end HR_ORG_INFORMATION_TYPES_PKG;

444: null;
445:
446: end TRANSLATE_ROW;
447: --
448: end HR_ORG_INFORMATION_TYPES_PKG;