82:
83: );
84:
85:
86: INSERT INTO PV_ATTRIBUTE_CODES_TL(
87: attr_code_id,
88: language,
89: source_lang,
90: last_update_date,
110: FROM fnd_languages FNDL
111: WHERE FNDL.installed_flag in ('I', 'B')
112: AND NOT EXISTS(
113: SELECT NULL
114: FROM pv_attribute_codes_tl T
115: WHERE T.attr_code_id = px_attr_code_id
116: AND T.language = FNDL.language_code );
117:
118: END Insert_Row;
168: IF (SQL%NOTFOUND) THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171:
172: Update PV_ATTRIBUTE_CODES_TL
173: SET
174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
264: IF (SQL%NOTFOUND) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: Update PV_ATTRIBUTE_CODES_TL
269: SET
270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
308: IF (SQL%NOTFOUND) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: Update PV_ATTRIBUTE_CODES_TL
313: SET
314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
361: If (SQL%NOTFOUND) then
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;
364:
365: DELETE FROM PV_ATTRIBUTE_CODES_TL
366: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID;
367: If (SQL%NOTFOUND) then
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: End If;
411:
412: cursor C1 is select
413: DESCRIPTION,
414: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
415: from PV_ATTRIBUTE_CODES_TL
416: where ATTR_CODE_ID = p_attr_code_id
417: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
418: for update of ATTR_CODE_ID nowait;
419:
481: --procedure ADD_LANGUAGE
482: procedure ADD_LANGUAGE
483: is
484: begin
485: delete from PV_ATTRIBUTE_CODES_TL T
486: where not exists
487: (select NULL
488: from PV_ATTRIBUTE_CODES_B B
489: where B.ATTR_CODE_ID = T.ATTR_CODE_ID
488: from PV_ATTRIBUTE_CODES_B B
489: where B.ATTR_CODE_ID = T.ATTR_CODE_ID
490: );
491:
492: update PV_ATTRIBUTE_CODES_TL T set (
493: DESCRIPTION
494: ) = (select
495: B.DESCRIPTION
496: from PV_ATTRIBUTE_CODES_TL B
492: update PV_ATTRIBUTE_CODES_TL T set (
493: DESCRIPTION
494: ) = (select
495: B.DESCRIPTION
496: from PV_ATTRIBUTE_CODES_TL B
497: where B.ATTR_CODE_ID = T.ATTR_CODE_ID
498: and B.LANGUAGE = T.SOURCE_LANG)
499: where (
500: T.ATTR_CODE_ID,
501: T.LANGUAGE
502: ) in (select
503: SUBT.ATTR_CODE_ID,
504: SUBT.LANGUAGE
505: from PV_ATTRIBUTE_CODES_TL SUBB, PV_ATTRIBUTE_CODES_TL SUBT
506: where SUBB.ATTR_CODE_ID = SUBT.ATTR_CODE_ID
507: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
508: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
509: ));
507: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
508: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
509: ));
510:
511: insert into PV_ATTRIBUTE_CODES_TL (
512: ATTR_CODE_ID,
513: LAST_UPDATE_DATE,
514: LAST_UPDATED_BY,
515: CREATION_DATE,
531: B.DESCRIPTION,
532: --B.SECURITY_GROUP_ID,
533: L.LANGUAGE_CODE,
534: B.SOURCE_LANG
535: from PV_ATTRIBUTE_CODES_TL B, FND_LANGUAGES L
536: where L.INSTALLED_FLAG in ('I', 'B')
537: and B.LANGUAGE = userenv('LANG')
538: and not exists
539: (select NULL
536: where L.INSTALLED_FLAG in ('I', 'B')
537: and B.LANGUAGE = userenv('LANG')
538: and not exists
539: (select NULL
540: from PV_ATTRIBUTE_CODES_TL T
541: where T.ATTR_CODE_ID = B.ATTR_CODE_ID
542: and T.LANGUAGE = L.LANGUAGE_CODE);
543: end ADD_LANGUAGE;
544:
548: , p_description in VARCHAR2
549: , p_owner in VARCHAR2
550: ) is
551: begin
552: update PV_ATTRIBUTE_CODES_TL set
553: description = nvl(p_description, description),
554: source_lang = userenv('LANG'),
555: last_update_date = sysdate,
556: last_updated_by = decode(p_owner, 'SEED', 1, 0),