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_B

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