APPS.HR_ORG_INFORMATION_TYPES_PKG dependencies on HR_ORG_INFORMATION_TYPES_TL

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 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 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 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 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 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 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 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