5293:
5294: --
5295: -- History table
5296: --
5297: delete from OKE_K_DELIVERABLES_TLH T
5298: where not exists
5299: (select NULL
5300: from OKE_K_DELIVERABLES_BH B
5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5301: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5302: and T.MAJOR_VERSION = B.MAJOR_VERSION
5303: );
5304:
5305: update OKE_K_DELIVERABLES_TLH T set (
5306: DESCRIPTION,
5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,
5307: COMMENTS
5308: ) = (select
5309: B.DESCRIPTION,
5310: B.COMMENTS
5311: from OKE_K_DELIVERABLES_TLH B
5312: where B.DELIVERABLE_ID = T.DELIVERABLE_ID
5313: and B.LANGUAGE = T.SOURCE_LANG
5314: and T.MAJOR_VERSION = B.MAJOR_VERSION)
5315: where (
5319: ) in (select
5320: SUBT.DELIVERABLE_ID,
5321: SUBT.MAJOR_VERSION,
5322: SUBT.LANGUAGE
5323: from OKE_K_DELIVERABLES_TLH SUBB, OKE_K_DELIVERABLES_TLH SUBT
5324: where SUBB.DELIVERABLE_ID = SUBT.DELIVERABLE_ID
5325: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
5326: and SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
5327: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
5331: or (SUBB.COMMENTS is null and SUBT.COMMENTS is not null)
5332: or (SUBB.COMMENTS is not null and SUBT.COMMENTS is null)
5333: ));
5334:
5335: insert into OKE_K_DELIVERABLES_TLH (
5336: DELIVERABLE_ID,
5337: MAJOR_VERSION,
5338: CREATION_DATE,
5339: CREATED_BY,
5361: B.DESCRIPTION,
5362: B.COMMENTS,
5363: L.LANGUAGE_CODE,
5364: B.SOURCE_LANG
5365: from OKE_K_DELIVERABLES_TLH B, FND_LANGUAGES L
5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL
5366: where L.INSTALLED_FLAG in ('I', 'B')
5367: and B.LANGUAGE = userenv('LANG')
5368: and not exists
5369: (select NULL
5370: from OKE_K_DELIVERABLES_TLH T
5371: where T.DELIVERABLE_ID = B.DELIVERABLE_ID
5372: and T.LANGUAGE = L.LANGUAGE_CODE
5373: and T.MAJOR_VERSION = B.MAJOR_VERSION);
5374: