eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_NOTE_PVT dependencies on OKE_K_STANDARD_NOTES_TL

Line 417: FROM OKE_K_STANDARD_NOTES_TL

413: SFWT_FLAG ,
414: DESCRIPTION ,
415: NAME ,
416: TEXT
417: FROM OKE_K_STANDARD_NOTES_TL
418: WHERE OKE_K_STANDARD_NOTES_TL.STANDARD_NOTES_ID = p_id;
419:
420:
421: l_note_pk note_pk_csr%ROWTYPE;

Line 418: WHERE OKE_K_STANDARD_NOTES_TL.STANDARD_NOTES_ID = p_id;

414: DESCRIPTION ,
415: NAME ,
416: TEXT
417: FROM OKE_K_STANDARD_NOTES_TL
418: WHERE OKE_K_STANDARD_NOTES_TL.STANDARD_NOTES_ID = p_id;
419:
420:
421: l_note_pk note_pk_csr%ROWTYPE;
422: l_note_rec note_rec_type;

Line 672: INSERT INTO OKE_K_STANDARD_NOTES_TL(

668: l_def_note_rec.ATTRIBUTE15 ,
669: l_def_note_rec.default_flag
670: );
671:
672: INSERT INTO OKE_K_STANDARD_NOTES_TL(
673: STANDARD_NOTES_ID ,
674: LANGUAGE ,
675: CREATION_DATE ,
676: CREATED_BY ,

Line 703: from OKE_K_STANDARD_NOTES_TL T

699: FROM fnd_languages L
700: WHERE L.INSTALLED_FLAG in ('I', 'B')
701: AND NOT EXISTS
702: (select NULL
703: from OKE_K_STANDARD_NOTES_TL T
704: where T.STANDARD_NOTES_ID = l_seq
705: and T.LANGUAGE = L.LANGUAGE_CODE);
706:
707:

Line 1128: UPDATE OKE_K_STANDARD_NOTES_TL

1124:
1125:
1126:
1127:
1128: UPDATE OKE_K_STANDARD_NOTES_TL
1129: SET
1130: LAST_UPDATE_DATE = l_def_note_rec.LAST_UPDATE_DATE,
1131: LAST_UPDATED_BY = l_def_note_rec.LAST_UPDATED_BY,
1132: LAST_UPDATE_LOGIN = l_def_note_rec.LAST_UPDATE_LOGIN,

Line 1290: DELETE FROM OKE_K_STANDARD_NOTES_TL

1286: RAISE OKE_API.G_EXCEPTION_ERROR;
1287: END IF;
1288:
1289:
1290: DELETE FROM OKE_K_STANDARD_NOTES_TL
1291: WHERE STANDARD_NOTES_ID IN (
1292: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
1293: WHERE DELIVERABLE_ID = p_del_id);
1294:

Line 1362: DELETE FROM OKE_K_STANDARD_NOTES_TL

1358: RAISE OKE_API.G_EXCEPTION_ERROR;
1359: END IF;
1360:
1361:
1362: DELETE FROM OKE_K_STANDARD_NOTES_TL
1363: WHERE STANDARD_NOTES_ID IN (
1364: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
1365: WHERE K_LINE_ID = p_cle_id);
1366:

Line 1433: DELETE FROM OKE_K_STANDARD_NOTES_TL

1429: RAISE OKE_API.G_EXCEPTION_ERROR;
1430: END IF;
1431:
1432:
1433: DELETE FROM OKE_K_STANDARD_NOTES_TL
1434: WHERE STANDARD_NOTES_ID IN (
1435: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B
1436: WHERE
1437: (K_HEADER_ID = p_hdr_id) AND

Line 1512: DELETE FROM OKE_K_STANDARD_NOTES_TL

1508:
1509: DELETE FROM OKE_K_STANDARD_NOTES_B
1510: WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;
1511:
1512: DELETE FROM OKE_K_STANDARD_NOTES_TL
1513: WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;
1514:
1515: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1516:

Line 1816: SELECT standard_notes_id FROM oke_k_standard_notes_tl

1812: WHERE standard_notes_id = p_note_rec.standard_notes_id
1813: FOR UPDATE NOWAIT;
1814:
1815: CURSOR lock_csr2 (p_note_rec IN note_rec_type) IS
1816: SELECT standard_notes_id FROM oke_k_standard_notes_tl
1817: WHERE standard_notes_id = p_note_rec.standard_notes_id
1818: FOR UPDATE NOWAIT;
1819:
1820:

Line 1904: delete from OKE_K_STANDARD_NOTES_TL T

1900: begin
1901: --
1902: -- Regular table
1903: --
1904: delete from OKE_K_STANDARD_NOTES_TL T
1905: where not exists
1906: (select NULL
1907: from OKE_K_STANDARD_NOTES_B B
1908: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

Line 1911: update OKE_K_STANDARD_NOTES_TL T set (

1907: from OKE_K_STANDARD_NOTES_B B
1908: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
1909: );
1910:
1911: update OKE_K_STANDARD_NOTES_TL T set (
1912: NAME,
1913: DESCRIPTION,
1914: TEXT
1915: ) = (select

Line 1919: from OKE_K_STANDARD_NOTES_TL B

1915: ) = (select
1916: B.NAME,
1917: B.DESCRIPTION,
1918: B.TEXT
1919: from OKE_K_STANDARD_NOTES_TL B
1920: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID
1921: and B.LANGUAGE = T.SOURCE_LANG)
1922: where (
1923: T.STANDARD_NOTES_ID,

Line 1928: from OKE_K_STANDARD_NOTES_TL SUBB, OKE_K_STANDARD_NOTES_TL SUBT

1924: T.LANGUAGE
1925: ) in (select
1926: SUBT.STANDARD_NOTES_ID,
1927: SUBT.LANGUAGE
1928: from OKE_K_STANDARD_NOTES_TL SUBB, OKE_K_STANDARD_NOTES_TL SUBT
1929: where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID
1930: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1931: and (SUBB.NAME <> SUBT.NAME
1932: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 1942: insert into OKE_K_STANDARD_NOTES_TL (

1938: or (SUBB.TEXT is null and SUBT.TEXT is not null)
1939: or (SUBB.TEXT is not null and SUBT.TEXT is null)
1940: ));
1941:
1942: insert into OKE_K_STANDARD_NOTES_TL (
1943: STANDARD_NOTES_ID,
1944: CREATION_DATE,
1945: CREATED_BY,
1946: LAST_UPDATE_DATE,

Line 1968: from OKE_K_STANDARD_NOTES_TL B, FND_LANGUAGES L

1964: B.NAME,
1965: B.TEXT,
1966: L.LANGUAGE_CODE,
1967: B.SOURCE_LANG
1968: from OKE_K_STANDARD_NOTES_TL B, FND_LANGUAGES L
1969: where L.INSTALLED_FLAG in ('I', 'B')
1970: and B.LANGUAGE = userenv('LANG')
1971: and not exists
1972: (select NULL

Line 1973: from OKE_K_STANDARD_NOTES_TL T

1969: where L.INSTALLED_FLAG in ('I', 'B')
1970: and B.LANGUAGE = userenv('LANG')
1971: and not exists
1972: (select NULL
1973: from OKE_K_STANDARD_NOTES_TL T
1974: where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID
1975: and T.LANGUAGE = L.LANGUAGE_CODE);
1976:
1977: --

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;