APPS.PV_ATTRIBUTE_PKG dependencies on PV_ATTRIBUTES_TL

Line 136: INSERT INTO pv_attributes_tl(

132: DECODE( p_sequence_number, FND_API.g_miss_num, NULL, p_sequence_number)
133:
134: );
135:
136: INSERT INTO pv_attributes_tl(
137: attribute_id,
138: language,
139: last_update_date,
140: last_updated_by,

Line 165: FROM pv_attributes_tl t

161: FROM fnd_languages l
162: WHERE l.installed_flag in ('I', 'B')
163: AND NOT EXISTS(
164: SELECT NULL
165: FROM pv_attributes_tl t
166: WHERE t.attribute_id = decode( px_attribute_id, FND_API.G_MISS_NUM, NULL, px_attribute_id)
167: AND t.language = l.language_code );
168:
169:

Line 260: update pv_attributes_tl set

256: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID
257: AND object_version_number = p_object_version_number;
258:
259:
260: update pv_attributes_tl set
261: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
262: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
263: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
264: last_update_date = SYSDATE,

Line 375: update pv_attributes_tl set

371: IF (SQL%NOTFOUND) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: END IF;
374:
375: update pv_attributes_tl set
376: name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
377: description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
378: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
379: last_update_date = SYSDATE,

Line 442: update pv_attributes_tl set

438: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category)
439: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
440: end if;
441:
442: update pv_attributes_tl set
443: --name = decode( p_name, FND_API.G_MISS_CHAR, name, p_name),
444: --description = decode( p_description, FND_API.G_MISS_CHAR, description, p_description),
445: short_name = decode( p_short_name, FND_API.G_MISS_CHAR, short_name, p_short_name),
446: last_update_date = SYSDATE,

Line 491: DELETE FROM PV_ATTRIBUTES_TL

487: If (SQL%NOTFOUND) then
488: RAISE NO_DATA_FOUND;
489: End If;
490:
491: DELETE FROM PV_ATTRIBUTES_TL
492: WHERE ATTRIBUTE_ID = p_ATTRIBUTE_ID;
493:
494: If (SQL%NOTFOUND) then
495: RAISE NO_DATA_FOUND;

Line 673: delete from PV_ATTRIBUTES_TL T

669:
670: procedure ADD_LANGUAGE
671: is
672: begin
673: delete from PV_ATTRIBUTES_TL T
674: where not exists
675: (select NULL
676: from PV_ATTRIBUTES_B B
677: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID

Line 680: update PV_ATTRIBUTES_TL T set (

676: from PV_ATTRIBUTES_B B
677: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
678: );
679:
680: update PV_ATTRIBUTES_TL T set (
681: NAME,
682: DESCRIPTION
683: ) = (select
684: B.NAME,

Line 686: from PV_ATTRIBUTES_TL B

682: DESCRIPTION
683: ) = (select
684: B.NAME,
685: B.DESCRIPTION
686: from PV_ATTRIBUTES_TL B
687: where B.ATTRIBUTE_ID = T.ATTRIBUTE_ID
688: and B.LANGUAGE = T.SOURCE_LANG)
689: where (
690: T.ATTRIBUTE_ID,

Line 695: from PV_ATTRIBUTES_TL SUBB, PV_ATTRIBUTES_TL SUBT

691: T.LANGUAGE
692: ) in (select
693: SUBT.ATTRIBUTE_ID,
694: SUBT.LANGUAGE
695: from PV_ATTRIBUTES_TL SUBB, PV_ATTRIBUTES_TL SUBT
696: where SUBB.ATTRIBUTE_ID = SUBT.ATTRIBUTE_ID
697: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
698: and (SUBB.NAME <> SUBT.NAME
699: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 704: insert into PV_ATTRIBUTES_TL (

700: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
701: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
702: ));
703:
704: insert into PV_ATTRIBUTES_TL (
705: NAME,
706: DESCRIPTION,
707: ATTRIBUTE_ID,
708: SHORT_NAME,

Line 728: from PV_ATTRIBUTES_TL B, FND_LANGUAGES L

724: B.CREATED_BY,
725: B.LAST_UPDATE_LOGIN,
726: L.LANGUAGE_CODE,
727: B.SOURCE_LANG
728: from PV_ATTRIBUTES_TL B, FND_LANGUAGES L
729: where L.INSTALLED_FLAG in ('I', 'B')
730: and B.LANGUAGE = userenv('LANG')
731: and not exists
732: (select NULL

Line 733: from PV_ATTRIBUTES_TL T

729: where L.INSTALLED_FLAG in ('I', 'B')
730: and B.LANGUAGE = userenv('LANG')
731: and not exists
732: (select NULL
733: from PV_ATTRIBUTES_TL T
734: where T.ATTRIBUTE_ID = B.ATTRIBUTE_ID
735: and T.LANGUAGE = L.LANGUAGE_CODE);
736: end ADD_LANGUAGE;
737:

Line 747: update PV_ATTRIBUTES_TL set

743: , p_description in VARCHAR2
744: , p_owner in VARCHAR2
745: ) is
746: begin
747: update PV_ATTRIBUTES_TL set
748: name = nvl(p_name, name),
749: description = nvl(p_description, description),
750: source_lang = userenv('LANG'),
751: last_update_date = sysdate,