APPS.OKE_NOTE_PVT dependencies on OKE_K_STANDARD_NOTES_TLH

Line 1980: delete from OKE_K_STANDARD_NOTES_TLH T

1976:
1977: --
1978: -- History table
1979: --
1980: delete from OKE_K_STANDARD_NOTES_TLH T
1981: where not exists
1982: (select NULL
1983: from OKE_K_STANDARD_NOTES_BH B
1984: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

Line 1988: update OKE_K_STANDARD_NOTES_TLH T set (

1984: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
1985: AND B.MAJOR_VERSION = T.MAJOR_VERSION
1986: );
1987:
1988: update OKE_K_STANDARD_NOTES_TLH T set (
1989: NAME,
1990: DESCRIPTION,
1991: TEXT
1992: ) = (select

Line 1996: from OKE_K_STANDARD_NOTES_TLH B

1992: ) = (select
1993: B.NAME,
1994: B.DESCRIPTION,
1995: B.TEXT
1996: from OKE_K_STANDARD_NOTES_TLH B
1997: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
1998: and B.MAJOR_VERSION = T.MAJOR_VERSION
1999: and B.LANGUAGE = T.SOURCE_LANG)
2000: where (

Line 2008: from OKE_K_STANDARD_NOTES_TLH SUBB, OKE_K_STANDARD_NOTES_TLH SUBT

2004: ) in (select
2005: SUBT.STANDARD_NOTES_ID,
2006: SUBT.MAJOR_VERSION,
2007: SUBT.LANGUAGE
2008: from OKE_K_STANDARD_NOTES_TLH SUBB, OKE_K_STANDARD_NOTES_TLH SUBT
2009: where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID
2010: and SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
2011: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
2012: and (SUBB.NAME <> SUBT.NAME

Line 2023: insert into OKE_K_STANDARD_NOTES_TLH (

2019: or (SUBB.TEXT is null and SUBT.TEXT is not null)
2020: or (SUBB.TEXT is not null and SUBT.TEXT is null)
2021: ));
2022:
2023: insert into OKE_K_STANDARD_NOTES_TLH (
2024: STANDARD_NOTES_ID,
2025: MAJOR_VERSION,
2026: CREATION_DATE,
2027: CREATED_BY,

Line 2051: from OKE_K_STANDARD_NOTES_TLH B, FND_LANGUAGES L

2047: B.NAME,
2048: B.TEXT,
2049: L.LANGUAGE_CODE,
2050: B.SOURCE_LANG
2051: from OKE_K_STANDARD_NOTES_TLH B, FND_LANGUAGES L
2052: where L.INSTALLED_FLAG in ('I', 'B')
2053: and B.LANGUAGE = userenv('LANG')
2054: and not exists
2055: (select NULL

Line 2056: from OKE_K_STANDARD_NOTES_TLH T

2052: where L.INSTALLED_FLAG in ('I', 'B')
2053: and B.LANGUAGE = userenv('LANG')
2054: and not exists
2055: (select NULL
2056: from OKE_K_STANDARD_NOTES_TLH T
2057: where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID
2058: and T.MAJOR_VERSION = B.MAJOR_VERSION
2059: and T.LANGUAGE = L.LANGUAGE_CODE);
2060: end ADD_LANGUAGE;