APPS.PER_ASSIGNMENT_INFO_TYPES_PKG dependencies on PER_ASSIGNMENT_INFO_TYPES_TL

Line 81: insert into PER_ASSIGNMENT_INFO_TYPES_TL (

77: X_LAST_UPDATED_BY,
78: X_LAST_UPDATE_LOGIN
79: );
80:
81: insert into PER_ASSIGNMENT_INFO_TYPES_TL (
82: INFORMATION_TYPE,
83: DESCRIPTION,
84: LAST_UPDATE_DATE,
85: LAST_UPDATED_BY,

Line 105: from PER_ASSIGNMENT_INFO_TYPES_TL T

101: from FND_LANGUAGES L
102: where L.INSTALLED_FLAG in ('I', 'B')
103: and not exists
104: (select NULL
105: from PER_ASSIGNMENT_INFO_TYPES_TL T
106: where T.INFORMATION_TYPE = X_INFORMATION_TYPE
107: and T.LANGUAGE = L.LANGUAGE_CODE);
108:
109: open c;

Line 142: from PER_ASSIGNMENT_INFO_TYPES_TL

138:
139: cursor c1 is select
140: DESCRIPTION,
141: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
142: from PER_ASSIGNMENT_INFO_TYPES_TL
143: where INFORMATION_TYPE = X_INFORMATION_TYPE
144: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
145: for update of INFORMATION_TYPE nowait;
146: begin

Line 213: update PER_ASSIGNMENT_INFO_TYPES_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update PER_ASSIGNMENT_INFO_TYPES_TL set
214: DESCRIPTION = X_DESCRIPTION,
215: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
216: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
217: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 231: delete from PER_ASSIGNMENT_INFO_TYPES_TL

227: procedure DELETE_ROW (
228: X_INFORMATION_TYPE in VARCHAR2
229: ) is
230: begin
231: delete from PER_ASSIGNMENT_INFO_TYPES_TL
232: where INFORMATION_TYPE = X_INFORMATION_TYPE;
233:
234: if (sql%notfound) then
235: raise no_data_found;

Line 315: UPDATE per_assignment_info_types_tl

311: ,X_OWNER in varchar2
312: )
313: is
314: begin
315: UPDATE per_assignment_info_types_tl
316: SET description = X_DESCRIPTION
317: ,last_update_date = SYSDATE
318: ,last_updated_by = DECODE(X_OWNER,'SEED',1,0)
319: ,last_update_login = 0

Line 328: delete from PER_ASSIGNMENT_INFO_TYPES_TL T

324:
325: procedure ADD_LANGUAGE
326: is
327: begin
328: delete from PER_ASSIGNMENT_INFO_TYPES_TL T
329: where not exists
330: (select NULL
331: from PER_ASSIGNMENT_INFO_TYPES B
332: where B.INFORMATION_TYPE = T.INFORMATION_TYPE

Line 335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (

331: from PER_ASSIGNMENT_INFO_TYPES B
332: where B.INFORMATION_TYPE = T.INFORMATION_TYPE
333: );
334:
335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (
336: DESCRIPTION
337: ) = (select
338: B.DESCRIPTION
339: from PER_ASSIGNMENT_INFO_TYPES_TL B

Line 339: from PER_ASSIGNMENT_INFO_TYPES_TL B

335: update PER_ASSIGNMENT_INFO_TYPES_TL T set (
336: DESCRIPTION
337: ) = (select
338: B.DESCRIPTION
339: from PER_ASSIGNMENT_INFO_TYPES_TL B
340: where B.INFORMATION_TYPE = T.INFORMATION_TYPE
341: and B.LANGUAGE = T.SOURCE_LANG)
342: where (
343: T.INFORMATION_TYPE,

Line 348: from PER_ASSIGNMENT_INFO_TYPES_TL SUBB, PER_ASSIGNMENT_INFO_TYPES_TL SUBT

344: T.LANGUAGE
345: ) in (select
346: SUBT.INFORMATION_TYPE,
347: SUBT.LANGUAGE
348: from PER_ASSIGNMENT_INFO_TYPES_TL SUBB, PER_ASSIGNMENT_INFO_TYPES_TL SUBT
349: where SUBB.INFORMATION_TYPE = SUBT.INFORMATION_TYPE
350: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
351: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
352: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 356: insert into PER_ASSIGNMENT_INFO_TYPES_TL (

352: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
353: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
354: ));
355:
356: insert into PER_ASSIGNMENT_INFO_TYPES_TL (
357: INFORMATION_TYPE,
358: DESCRIPTION,
359: LAST_UPDATE_DATE,
360: LAST_UPDATED_BY,

Line 376: from PER_ASSIGNMENT_INFO_TYPES_TL B, FND_LANGUAGES L

372: B.CREATED_BY,
373: B.CREATION_DATE,
374: L.LANGUAGE_CODE,
375: B.SOURCE_LANG
376: from PER_ASSIGNMENT_INFO_TYPES_TL B, FND_LANGUAGES L
377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL

Line 381: from PER_ASSIGNMENT_INFO_TYPES_TL T

377: where L.INSTALLED_FLAG in ('I', 'B')
378: and B.LANGUAGE = userenv('LANG')
379: and not exists
380: (select NULL
381: from PER_ASSIGNMENT_INFO_TYPES_TL T
382: where T.INFORMATION_TYPE = B.INFORMATION_TYPE
383: and T.LANGUAGE = L.LANGUAGE_CODE);
384: end ADD_LANGUAGE;
385: --------------------------------------------------------------------------------

Line 417: FROM per_assignment_info_types_tl aitt,

413: p_description IN VARCHAR2,
414: p_information_type IN VARCHAR2)
415: IS
416: SELECT 1
417: FROM per_assignment_info_types_tl aitt,
418: per_assignment_info_types ait
419: WHERE upper(aitt.description)=upper(p_description)
420: AND aitt.information_type = ait.information_type
421: AND aitt.language = p_language