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.4 2011/04/28 10:12:15 sidsaxen ship $ */
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 92: p_entity_name => 'HR_ORG_INFORMATION_TYPES_TL',

88: --
89:
90: BEGIN
91: PER_RIC_PKG.chk_integrity (
92: p_entity_name => 'HR_ORG_INFORMATION_TYPES_TL',
93: p_ref_entity => 'HR_ORG_INFORMATION_TYPES',
94: p_ref_column_name => 'ORG_INFORMATION_TYPE',
95: p_ref_col_value_number => NULL,
96: p_ref_col_value_varchar => X_ORG_INFORMATION_TYPE,

Line 93: p_ref_entity => 'HR_ORG_INFORMATION_TYPES',

89:
90: BEGIN
91: PER_RIC_PKG.chk_integrity (
92: p_entity_name => 'HR_ORG_INFORMATION_TYPES_TL',
93: p_ref_entity => 'HR_ORG_INFORMATION_TYPES',
94: p_ref_column_name => 'ORG_INFORMATION_TYPE',
95: p_ref_col_value_number => NULL,
96: p_ref_col_value_varchar => X_ORG_INFORMATION_TYPE,
97: p_ref_col_value_date => NULL,

Line 104: insert into HR_ORG_INFORMATION_TYPES_TL (

100: END;
101: --
102: -- Code Ends Here.
103: --
104: insert into HR_ORG_INFORMATION_TYPES_TL (
105: ORG_INFORMATION_TYPE,
106: DISPLAYED_ORG_INFORMATION_TYPE,
107: CREATED_BY,
108: CREATION_DATE,

Line 128: from HR_ORG_INFORMATION_TYPES_TL T

124: from FND_LANGUAGES L
125: where L.INSTALLED_FLAG in ('I', 'B')
126: and not exists
127: (select NULL
128: from HR_ORG_INFORMATION_TYPES_TL T
129: where T.ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
130: and T.LANGUAGE = L.LANGUAGE_CODE);
131:
132: end INSERT_ROW;

Line 151: from HR_ORG_INFORMATION_TYPES

147: ,LEGISLATION_CODE
148: ,NAVIGATION_METHOD
149: ,FND_APPLICATION_ID
150: ,DESCRIPTION
151: from HR_ORG_INFORMATION_TYPES
152: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
153: for update of ORG_INFORMATION_TYPE nowait;
154: RECINFO CSR_ORG_INFORMATION_TYPE%rowtype;
155:

Line 159: from HR_ORG_INFORMATION_TYPES_TL

155:
156: cursor CSR_ORG_INFORMATION_TYPE_TL is
157: select DISPLAYED_ORG_INFORMATION_TYPE,
158: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
159: from HR_ORG_INFORMATION_TYPES_TL
160: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
161: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
162: for update of ORG_INFORMATION_TYPE nowait;
163:

Line 219: update HR_ORG_INFORMATION_TYPES set

215: X_LAST_UPDATED_BY in NUMBER,
216: X_LAST_UPDATE_LOGIN in NUMBER
217: ) is
218: begin
219: update HR_ORG_INFORMATION_TYPES set
220: DESTINATION = X_DESTINATION,
221: LEGISLATION_CODE = X_LEGISLATION_CODE,
222: NAVIGATION_METHOD = X_NAVIGATION_METHOD,
223: FND_APPLICATION_ID = X_FND_APPLICATION_ID,

Line 234: update HR_ORG_INFORMATION_TYPES_TL set

230: if (sql%notfound) then
231: raise no_data_found;
232: end if;
233:
234: update HR_ORG_INFORMATION_TYPES_TL set
235: DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP,
236: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
237: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
238: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 253: delete from HR_ORG_INFORMATION_TYPES_TL

249: procedure DELETE_ROW (
250: X_ORG_INFORMATION_TYPE in VARCHAR2
251: ) is
252: begin
253: delete from HR_ORG_INFORMATION_TYPES_TL
254: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
255:
256: if (sql%notfound) then
257: raise no_data_found;

Line 267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',

263: --
264:
265: BEGIN
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(

Line 269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(

265: BEGIN
266: PER_RIC_PKG.chk_integrity (
267: p_entity_name => 'HR_ORG_INFORMATION_TYPES',
268: p_ref_entity_info => PER_RIC_PKG.ref_entity_tbl(
269: PER_RIC_PKG.ref_info_rec('HR_ORG_INFORMATION_TYPES_TL', PER_RIC_PKG.column_info_tbl(
270: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL))),
271: PER_RIC_PKG.ref_info_rec('HR_ORG_INFO_TYPES_BY_CLASS', PER_RIC_PKG.column_info_tbl(
272: PER_RIC_PKG.col_info_rec('ORG_INFORMATION_TYPE',X_ORG_INFORMATION_TYPE,NULL,NULL)))
273: ),

Line 281: delete from HR_ORG_INFORMATION_TYPES

277: --
278: -- Code Ends Here.
279: --
280:
281: delete from HR_ORG_INFORMATION_TYPES
282: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
283: if (sql%notfound) then
284: raise no_data_found;
285: end if;

Line 291: delete from HR_ORG_INFORMATION_TYPES_TL T

287: --
288: procedure ADD_LANGUAGE
289: is
290: begin
291: delete from HR_ORG_INFORMATION_TYPES_TL T
292: where not exists
293: (select NULL
294: from HR_ORG_INFORMATION_TYPES B
295: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE

Line 294: from HR_ORG_INFORMATION_TYPES B

290: begin
291: delete from HR_ORG_INFORMATION_TYPES_TL T
292: where not exists
293: (select NULL
294: from HR_ORG_INFORMATION_TYPES B
295: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
296: );
297:
298: update HR_ORG_INFORMATION_TYPES_TL T set (

Line 298: update HR_ORG_INFORMATION_TYPES_TL T set (

294: from HR_ORG_INFORMATION_TYPES B
295: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
296: );
297:
298: update HR_ORG_INFORMATION_TYPES_TL T set (
299: DISPLAYED_ORG_INFORMATION_TYPE
300: ) = (select
301: B.DISPLAYED_ORG_INFORMATION_TYPE
302: from HR_ORG_INFORMATION_TYPES_TL B

Line 302: from HR_ORG_INFORMATION_TYPES_TL B

298: update HR_ORG_INFORMATION_TYPES_TL T set (
299: DISPLAYED_ORG_INFORMATION_TYPE
300: ) = (select
301: B.DISPLAYED_ORG_INFORMATION_TYPE
302: from HR_ORG_INFORMATION_TYPES_TL B
303: where B.ORG_INFORMATION_TYPE = T.ORG_INFORMATION_TYPE
304: and B.LANGUAGE = T.SOURCE_LANG)
305: where (
306: T.ORG_INFORMATION_TYPE,

Line 311: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT

307: T.LANGUAGE
308: ) in (select
309: SUBT.ORG_INFORMATION_TYPE,
310: SUBT.LANGUAGE
311: from HR_ORG_INFORMATION_TYPES_TL SUBB, HR_ORG_INFORMATION_TYPES_TL SUBT
312: where SUBB.ORG_INFORMATION_TYPE = SUBT.ORG_INFORMATION_TYPE
313: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
314: and (SUBB.DISPLAYED_ORG_INFORMATION_TYPE <> SUBT.DISPLAYED_ORG_INFORMATION_TYPE
315: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)

Line 319: insert into HR_ORG_INFORMATION_TYPES_TL (

315: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is not null)
316: or (SUBB.DISPLAYED_ORG_INFORMATION_TYPE is not null and SUBT.DISPLAYED_ORG_INFORMATION_TYPE is null)
317: ));
318:
319: insert into HR_ORG_INFORMATION_TYPES_TL (
320: ORG_INFORMATION_TYPE,
321: DISPLAYED_ORG_INFORMATION_TYPE,
322: CREATED_BY,
323: CREATION_DATE,

Line 339: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L

335: B.LAST_UPDATE_DATE,
336: B.LAST_UPDATE_LOGIN,
337: L.LANGUAGE_CODE,
338: B.SOURCE_LANG
339: from HR_ORG_INFORMATION_TYPES_TL B, FND_LANGUAGES L
340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL

Line 344: from HR_ORG_INFORMATION_TYPES_TL T

340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL
344: from HR_ORG_INFORMATION_TYPES_TL T
345: where T.ORG_INFORMATION_TYPE = B.ORG_INFORMATION_TYPE
346: and T.LANGUAGE = L.LANGUAGE_CODE);
347: end ADD_LANGUAGE;
348:

Line 389: from HR_ORG_INFORMATION_TYPES

385: -- Translate char last_update_date to date
386: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
387: select LAST_UPDATED_BY, LAST_UPDATE_DATE
388: into db_luby, db_ludate
389: from HR_ORG_INFORMATION_TYPES
390: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE;
391:
392: -- Test for customization and version
393: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 396: HR_ORG_INFORMATION_TYPES_PKG.Update_Row(

392: -- Test for customization and version
393: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
394: db_ludate, X_CUSTOM_MODE)) then
395: -- Update existing row
396: HR_ORG_INFORMATION_TYPES_PKG.Update_Row(
397: X_ORG_INFORMATION_TYPE,
398: X_DESTINATION,
399: X_LEGISLATION_CODE,
400: X_NAVIGATION_METHOD,

Line 411: HR_ORG_INFORMATION_TYPES_PKG.Insert_Row(

407: END IF;
408: exception
409: when no_data_found then
410: -- Record doesn't exist - insert in all cases
411: HR_ORG_INFORMATION_TYPES_PKG.Insert_Row(
412: X_ORG_INFORMATION_TYPE,
413: X_DESTINATION,
414: X_LEGISLATION_CODE,
415: X_NAVIGATION_METHOD,

Line 463: from HR_ORG_INFORMATION_TYPES_TL

459: -- the correct row is fetched instead of multiple rows
460:
461: select LAST_UPDATED_BY, LAST_UPDATE_DATE
462: into db_luby, db_ludate
463: from HR_ORG_INFORMATION_TYPES_TL
464: where ORG_INFORMATION_TYPE = X_ORG_INFORMATION_TYPE
465: and LANGUAGE=userenv('LANG');
466:
467: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 472: update HR_ORG_INFORMATION_TYPES_TL

468: db_ludate,X_CUSTOM_MODE)) then
469: -- Update translations for this language
470: -- bug 5235538 nls date issue, changed to LAST_UPDATE_DATE = f_ludate, LAST_UPDATED_BY = f_luby
471:
472: update HR_ORG_INFORMATION_TYPES_TL
473: set DISPLAYED_ORG_INFORMATION_TYPE = X_DISPLAYED_ORG_INFORMATION_TP
474: , LAST_UPDATE_DATE = f_ludate
475: , LAST_UPDATED_BY = f_luby
476: , LAST_UPDATE_LOGIN = 0

Line 488: end HR_ORG_INFORMATION_TYPES_PKG;

484: null;
485:
486: end TRANSLATE_ROW;
487: --
488: end HR_ORG_INFORMATION_TYPES_PKG;