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 STANDARD

Line 381: STANDARD_NOTES_ID ,

377: ) RETURN note_rec_type IS
378:
379: CURSOR note_pk_csr (p_id IN NUMBER) IS
380: SELECT
381: STANDARD_NOTES_ID ,
382: CREATION_DATE ,
383: CREATED_BY ,
384: LAST_UPDATE_DATE ,
385: LAST_UPDATED_BY ,

Line 408: FROM OKE_K_STANDARD_NOTES_B

404: ATTRIBUTE13 ,
405: ATTRIBUTE14 ,
406: ATTRIBUTE15 ,
407: default_flag
408: FROM OKE_K_STANDARD_NOTES_B
409: WHERE OKE_K_STANDARD_NOTES_B.STANDARD_NOTES_ID = p_id;
410:
411: CURSOR note_pk_csr2 (p_id IN NUMBER) IS
412: SELECT

Line 409: WHERE OKE_K_STANDARD_NOTES_B.STANDARD_NOTES_ID = p_id;

405: ATTRIBUTE14 ,
406: ATTRIBUTE15 ,
407: default_flag
408: FROM OKE_K_STANDARD_NOTES_B
409: WHERE OKE_K_STANDARD_NOTES_B.STANDARD_NOTES_ID = p_id;
410:
411: CURSOR note_pk_csr2 (p_id IN NUMBER) IS
412: SELECT
413: SFWT_FLAG ,

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 430: OPEN note_pk_csr(p_note_rec.STANDARD_NOTES_ID);

426:
427: -- get current database value
428:
429:
430: OPEN note_pk_csr(p_note_rec.STANDARD_NOTES_ID);
431: FETCH note_pk_csr INTO
432: l_note_rec.STANDARD_NOTES_ID ,
433: l_note_rec.CREATION_DATE ,
434: l_note_rec.CREATED_BY ,

Line 432: l_note_rec.STANDARD_NOTES_ID ,

428:
429:
430: OPEN note_pk_csr(p_note_rec.STANDARD_NOTES_ID);
431: FETCH note_pk_csr INTO
432: l_note_rec.STANDARD_NOTES_ID ,
433: l_note_rec.CREATION_DATE ,
434: l_note_rec.CREATED_BY ,
435: l_note_rec.LAST_UPDATE_DATE ,
436: l_note_rec.LAST_UPDATED_BY ,

Line 468: OPEN note_pk_csr2(p_note_rec.STANDARD_NOTES_ID);

464: IF(x_no_data_found) THEN
465: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
466: END IF;
467:
468: OPEN note_pk_csr2(p_note_rec.STANDARD_NOTES_ID);
469: FETCH note_pk_csr2 INTO
470: l_note_rec.SFWT_FLAG ,
471: l_note_rec.DESCRIPTION ,
472: l_note_rec.NAME ,

Line 609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;

605: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
606: RAISE OKE_API.G_EXCEPTION_ERROR;
607: END IF;
608:
609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;
610:
611: INSERT INTO OKE_K_STANDARD_NOTES_B(
612:
613: STANDARD_NOTES_ID ,

Line 611: INSERT INTO OKE_K_STANDARD_NOTES_B(

607: END IF;
608:
609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;
610:
611: INSERT INTO OKE_K_STANDARD_NOTES_B(
612:
613: STANDARD_NOTES_ID ,
614: CREATION_DATE ,
615: CREATED_BY ,

Line 613: STANDARD_NOTES_ID ,

609: SELECT OKE_K_STANDARD_NOTES_S.nextval INTO l_seq FROM dual;
610:
611: INSERT INTO OKE_K_STANDARD_NOTES_B(
612:
613: STANDARD_NOTES_ID ,
614: CREATION_DATE ,
615: CREATED_BY ,
616: LAST_UPDATE_DATE ,
617: LAST_UPDATED_BY ,

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 673: STANDARD_NOTES_ID ,

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 ,
677: LAST_UPDATE_DATE ,

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 704: where T.STANDARD_NOTES_ID = l_seq

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:
708: -- Set OUT values

Line 710: x_note_rec.STANDARD_NOTES_ID := l_seq;

706:
707:
708: -- Set OUT values
709: x_note_rec := l_def_note_rec;
710: x_note_rec.STANDARD_NOTES_ID := l_seq;
711: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
712:
713: EXCEPTION
714: WHEN OKE_API.G_EXCEPTION_ERROR THEN

Line 897: -- IF x_note_rec.STANDARD_NOTES_ID = OKE_API.G_MISS_NUM THEN

893:
894:
895: -- this is key
896: --????????????????????????????????????????
897: -- IF x_note_rec.STANDARD_NOTES_ID = OKE_API.G_MISS_NUM THEN
898: -- x_note_rec.STANDARD_NOTES_ID := l_note_rec.STANDARD_NOTES_ID;
899: -- END IF;
900:
901: IF x_note_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN

Line 898: -- x_note_rec.STANDARD_NOTES_ID := l_note_rec.STANDARD_NOTES_ID;

894:
895: -- this is key
896: --????????????????????????????????????????
897: -- IF x_note_rec.STANDARD_NOTES_ID = OKE_API.G_MISS_NUM THEN
898: -- x_note_rec.STANDARD_NOTES_ID := l_note_rec.STANDARD_NOTES_ID;
899: -- END IF;
900:
901: IF x_note_rec.CREATION_DATE = OKE_API.G_MISS_DATE THEN
902: x_note_rec.CREATION_DATE := l_note_rec.CREATION_DATE;

Line 1094: UPDATE OKE_K_STANDARD_NOTES_B

1090: RAISE OKE_API.G_EXCEPTION_ERROR;
1091: END IF;
1092:
1093:
1094: UPDATE OKE_K_STANDARD_NOTES_B
1095: SET
1096: CREATION_DATE = l_def_note_rec.CREATION_DATE,
1097: CREATED_BY = l_def_note_rec.CREATED_BY,
1098: LAST_UPDATE_DATE = l_def_note_rec.LAST_UPDATE_DATE,

Line 1122: WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID;

1118: ATTRIBUTE13 = l_def_note_rec.ATTRIBUTE13,
1119: ATTRIBUTE14 = l_def_note_rec.ATTRIBUTE14,
1120: ATTRIBUTE15 = l_def_note_rec.ATTRIBUTE15,
1121: default_flag= l_def_note_rec.default_flag
1122: WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID;
1123:
1124:
1125:
1126:

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 1138: WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID

1134: SFWT_FLAG = l_def_note_rec.SFWT_FLAG,
1135: DESCRIPTION = l_def_note_rec.DESCRIPTION,
1136: NAME = l_def_note_rec.NAME,
1137: TEXT = l_def_note_rec.TEXT
1138: WHERE STANDARD_NOTES_ID = l_def_note_rec.STANDARD_NOTES_ID
1139: AND userenv('LANG') in (language , source_lang);
1140:
1141: x_note_rec := l_def_note_rec;
1142:

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 1291: WHERE STANDARD_NOTES_ID IN (

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:
1295: DELETE FROM OKE_K_STANDARD_NOTES_B

Line 1292: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B

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:
1295: DELETE FROM OKE_K_STANDARD_NOTES_B
1296: WHERE DELIVERABLE_ID = p_del_id;

Line 1295: DELETE FROM OKE_K_STANDARD_NOTES_B

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:
1295: DELETE FROM OKE_K_STANDARD_NOTES_B
1296: WHERE DELIVERABLE_ID = p_del_id;
1297:
1298: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1299:

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 1363: WHERE STANDARD_NOTES_ID IN (

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:
1367: DELETE FROM OKE_K_STANDARD_NOTES_B

Line 1364: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B

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:
1367: DELETE FROM OKE_K_STANDARD_NOTES_B
1368: WHERE K_LINE_ID = p_cle_id;

Line 1367: DELETE FROM OKE_K_STANDARD_NOTES_B

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:
1367: DELETE FROM OKE_K_STANDARD_NOTES_B
1368: WHERE K_LINE_ID = p_cle_id;
1369:
1370: OKE_API.END_ACTIVITY(x_msg_count, x_msg_data);
1371:

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 1434: WHERE STANDARD_NOTES_ID IN (

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
1438: (K_LINE_ID IS NULL) AND

Line 1435: SELECT STANDARD_NOTES_ID FROM OKE_K_STANDARD_NOTES_B

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
1438: (K_LINE_ID IS NULL) AND
1439: (DELIVERABLE_ID IS NULL));

Line 1441: DELETE FROM OKE_K_STANDARD_NOTES_B

1437: (K_HEADER_ID = p_hdr_id) AND
1438: (K_LINE_ID IS NULL) AND
1439: (DELIVERABLE_ID IS NULL));
1440:
1441: DELETE FROM OKE_K_STANDARD_NOTES_B
1442: WHERE (K_HEADER_ID = p_hdr_id) AND
1443: (K_LINE_ID IS NULL) AND
1444: (DELIVERABLE_ID IS NULL);
1445:

Line 1509: DELETE FROM OKE_K_STANDARD_NOTES_B

1505: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1506: RAISE OKE_API.G_EXCEPTION_ERROR;
1507: END IF;
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;

Line 1510: WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;

1506: RAISE OKE_API.G_EXCEPTION_ERROR;
1507: END IF;
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:

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 1513: WHERE STANDARD_NOTES_ID = l_note_rec.STANDARD_NOTES_ID;

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:
1517: EXCEPTION

Line 1811: SELECT standard_notes_id FROM oke_k_standard_notes_b

1807: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1808:
1809:
1810: CURSOR lock_csr1 (p_note_rec IN note_rec_type) IS
1811: SELECT standard_notes_id FROM oke_k_standard_notes_b
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

Line 1812: WHERE standard_notes_id = p_note_rec.standard_notes_id

1808:
1809:
1810: CURSOR lock_csr1 (p_note_rec IN note_rec_type) IS
1811: SELECT standard_notes_id FROM oke_k_standard_notes_b
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

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 1817: 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:
1821: BEGIN

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 1907: from OKE_K_STANDARD_NOTES_B B

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
1909: );
1910:
1911: update OKE_K_STANDARD_NOTES_TL T set (

Line 1908: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

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
1909: );
1910:
1911: update OKE_K_STANDARD_NOTES_TL T set (
1912: NAME,

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 1920: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

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,
1924: T.LANGUAGE

Line 1923: T.STANDARD_NOTES_ID,

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,
1924: T.LANGUAGE
1925: ) in (select
1926: SUBT.STANDARD_NOTES_ID,
1927: SUBT.LANGUAGE

Line 1926: SUBT.STANDARD_NOTES_ID,

1922: where (
1923: T.STANDARD_NOTES_ID,
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

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 1929: where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID

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)
1933: or (SUBB.NAME is not null and SUBT.NAME is 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 1943: STANDARD_NOTES_ID,

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,
1947: LAST_UPDATED_BY,

Line 1956: B.STANDARD_NOTES_ID,

1952: TEXT,
1953: LANGUAGE,
1954: SOURCE_LANG
1955: ) select
1956: B.STANDARD_NOTES_ID,
1957: B.CREATION_DATE,
1958: B.CREATED_BY,
1959: B.LAST_UPDATE_DATE,
1960: B.LAST_UPDATED_BY,

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 1974: where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID

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: --
1978: -- History table

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 1983: from OKE_K_STANDARD_NOTES_BH B

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
1985: AND B.MAJOR_VERSION = T.MAJOR_VERSION
1986: );
1987:

Line 1984: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

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
1985: AND B.MAJOR_VERSION = T.MAJOR_VERSION
1986: );
1987:
1988: update OKE_K_STANDARD_NOTES_TLH T set (

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 1997: where B.STANDARD_NOTES_ID = T.STANDARD_NOTES_ID

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 (
2001: T.STANDARD_NOTES_ID,

Line 2001: T.STANDARD_NOTES_ID,

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 (
2001: T.STANDARD_NOTES_ID,
2002: T.MAJOR_VERSION,
2003: T.LANGUAGE
2004: ) in (select
2005: SUBT.STANDARD_NOTES_ID,

Line 2005: SUBT.STANDARD_NOTES_ID,

2001: T.STANDARD_NOTES_ID,
2002: T.MAJOR_VERSION,
2003: T.LANGUAGE
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

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 2009: where SUBB.STANDARD_NOTES_ID = SUBT.STANDARD_NOTES_ID

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
2013: or (SUBB.NAME is null and SUBT.NAME is not null)

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 2024: STANDARD_NOTES_ID,

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,
2028: LAST_UPDATE_DATE,

Line 2038: B.STANDARD_NOTES_ID,

2034: TEXT,
2035: LANGUAGE,
2036: SOURCE_LANG
2037: ) select
2038: B.STANDARD_NOTES_ID,
2039: B.MAJOR_VERSION,
2040: B.CREATION_DATE,
2041: B.CREATED_BY,
2042: B.LAST_UPDATE_DATE,

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;

Line 2057: where T.STANDARD_NOTES_ID = B.STANDARD_NOTES_ID

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;
2061: