APPS.FND_PRIVACY_ATTRIBUTES_PKG dependencies on FND_PRIVACY_ATTRIBUTES_TL

Line 104: insert into FND_PRIVACY_ATTRIBUTES_TL (

100: X_DSCRAM_LEVEL,
101: X_DSCRAM_ALGO_ID
102: );
103:
104: insert into FND_PRIVACY_ATTRIBUTES_TL (
105: PRIVACY_ATTRIBUTE_CODE,
106: PRIVACY_ATTRIBUTE_NAME,
107: DESCRIPTION,
108: DESCRIPTION_INT,

Line 132: from FND_PRIVACY_ATTRIBUTES_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from FND_PRIVACY_ATTRIBUTES_TL T
133: where T.PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: open c;

Line 209: from FND_PRIVACY_ATTRIBUTES_TL

205: PRIVACY_ATTRIBUTE_NAME,
206: DESCRIPTION,
207: DESCRIPTION_INT,
208: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
209: from FND_PRIVACY_ATTRIBUTES_TL
210: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE
211: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
212: for update of PRIVACY_ATTRIBUTE_CODE nowait;
213: begin

Line 354: update FND_PRIVACY_ATTRIBUTES_TL set

350: if (sql%notfound) then
351: raise no_data_found;
352: end if;
353:
354: update FND_PRIVACY_ATTRIBUTES_TL set
355: PRIVACY_ATTRIBUTE_NAME = X_PRIVACY_ATTRIBUTE_NAME,
356: DESCRIPTION = X_DESCRIPTION,
357: DESCRIPTION_INT = X_DESCRIPTION_INT,
358: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 374: delete from FND_PRIVACY_ATTRIBUTES_TL

370: procedure DELETE_ROW (
371: X_PRIVACY_ATTRIBUTE_CODE in VARCHAR2
372: ) is
373: begin
374: delete from FND_PRIVACY_ATTRIBUTES_TL
375: where PRIVACY_ATTRIBUTE_CODE = X_PRIVACY_ATTRIBUTE_CODE;
376:
377: if (sql%notfound) then
378: raise no_data_found;

Line 392: delete from FND_PRIVACY_ATTRIBUTES_TL T

388:
389: procedure ADD_LANGUAGE
390: is
391: begin
392: delete from FND_PRIVACY_ATTRIBUTES_TL T
393: where not exists
394: (select NULL
395: from FND_PRIVACY_ATTRIBUTES_B B
396: where B.PRIVACY_ATTRIBUTE_CODE = T.PRIVACY_ATTRIBUTE_CODE

Line 399: update FND_PRIVACY_ATTRIBUTES_TL T set (

395: from FND_PRIVACY_ATTRIBUTES_B B
396: where B.PRIVACY_ATTRIBUTE_CODE = T.PRIVACY_ATTRIBUTE_CODE
397: );
398:
399: update FND_PRIVACY_ATTRIBUTES_TL T set (
400: PRIVACY_ATTRIBUTE_NAME,
401: DESCRIPTION,
402: DESCRIPTION_INT
403: ) = (select

Line 407: from FND_PRIVACY_ATTRIBUTES_TL B

403: ) = (select
404: B.PRIVACY_ATTRIBUTE_NAME,
405: B.DESCRIPTION,
406: B.DESCRIPTION_INT
407: from FND_PRIVACY_ATTRIBUTES_TL B
408: where B.PRIVACY_ATTRIBUTE_CODE = T.PRIVACY_ATTRIBUTE_CODE
409: and B.LANGUAGE = T.SOURCE_LANG)
410: where (
411: T.PRIVACY_ATTRIBUTE_CODE,

Line 416: from FND_PRIVACY_ATTRIBUTES_TL SUBB, FND_PRIVACY_ATTRIBUTES_TL SUBT

412: T.LANGUAGE
413: ) in (select
414: SUBT.PRIVACY_ATTRIBUTE_CODE,
415: SUBT.LANGUAGE
416: from FND_PRIVACY_ATTRIBUTES_TL SUBB, FND_PRIVACY_ATTRIBUTES_TL SUBT
417: where SUBB.PRIVACY_ATTRIBUTE_CODE = SUBT.PRIVACY_ATTRIBUTE_CODE
418: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
419: and (SUBB.PRIVACY_ATTRIBUTE_NAME <> SUBT.PRIVACY_ATTRIBUTE_NAME
420: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 428: insert into FND_PRIVACY_ATTRIBUTES_TL (

424: or (SUBB.DESCRIPTION_INT is null and SUBT.DESCRIPTION_INT is not null)
425: or (SUBB.DESCRIPTION_INT is not null and SUBT.DESCRIPTION_INT is null)
426: ));
427:
428: insert into FND_PRIVACY_ATTRIBUTES_TL (
429: PRIVACY_ATTRIBUTE_CODE,
430: PRIVACY_ATTRIBUTE_NAME,
431: DESCRIPTION,
432: DESCRIPTION_INT,

Line 452: from FND_PRIVACY_ATTRIBUTES_TL B, FND_LANGUAGES L

448: B.LAST_UPDATE_DATE,
449: B.LAST_UPDATE_LOGIN,
450: L.LANGUAGE_CODE,
451: B.SOURCE_LANG
452: from FND_PRIVACY_ATTRIBUTES_TL B, FND_LANGUAGES L
453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL

Line 457: from FND_PRIVACY_ATTRIBUTES_TL T

453: where L.INSTALLED_FLAG in ('I', 'B')
454: and B.LANGUAGE = userenv('LANG')
455: and not exists
456: (select NULL
457: from FND_PRIVACY_ATTRIBUTES_TL T
458: where T.PRIVACY_ATTRIBUTE_CODE = B.PRIVACY_ATTRIBUTE_CODE
459: and T.LANGUAGE = L.LANGUAGE_CODE);
460: end ADD_LANGUAGE;
461:

Line 471: UPDATE FND_PRIVACY_ATTRIBUTES_TL SET

467: x_last_update_login in number)
468: is
469: begin
470:
471: UPDATE FND_PRIVACY_ATTRIBUTES_TL SET
472: privacy_attribute_name = nvl(x_PRIVACY_ATTRIBUTE_NAME,privacy_attribute_name),
473: last_update_date = nvl(x_last_update_date,sysdate),
474: last_updated_by = x_last_updated_by,
475: last_update_login = 0,