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_TERM_PVT dependencies on OKE_K_TERMS

Line 624: FROM OKE_K_TERMS a

620: ATTRIBUTE14 ,
621: ATTRIBUTE15
622:
623:
624: FROM OKE_K_TERMS a
625: WHERE
626: (a.K_HEADER_ID = chr_id)AND(a.TERM_CODE=trm_cd)
627: AND (a.TERM_VALUE_PK1=TERM_VALUE_PK1)
628: AND (a.TERM_VALUE_PK2=TERM_VALUE_PK2)

Line 793: INSERT INTO OKE_K_TERMS(

789: RAISE OKE_API.G_EXCEPTION_ERROR;
790: END IF;
791:
792:
793: INSERT INTO OKE_K_TERMS(
794:
795: K_HEADER_ID ,
796: K_LINE_ID ,
797: TERM_CODE ,

Line 1199: UPDATE OKE_K_TERMS

1195: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1196: RAISE OKE_API.G_EXCEPTION_ERROR;
1197: END IF;
1198:
1199: UPDATE OKE_K_TERMS
1200: SET
1201: CREATION_DATE = l_def_term_rec.CREATION_DATE,
1202: CREATED_BY = l_def_term_rec.CREATED_BY,
1203: LAST_UPDATE_DATE = l_def_term_rec.LAST_UPDATE_DATE,

Line 1375: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,

1371: x_return_status OUT NOCOPY VARCHAR2,
1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_cle_id IN NUMBER,
1375: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1376: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1377: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1378:
1379: ) IS

Line 1376: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,

1372: x_msg_count OUT NOCOPY NUMBER,
1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_cle_id IN NUMBER,
1375: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1376: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1377: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1378:
1379: ) IS
1380:

Line 1377: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE

1373: x_msg_data OUT NOCOPY VARCHAR2,
1374: p_cle_id IN NUMBER,
1375: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1376: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1377: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1378:
1379: ) IS
1380:
1381: l_api_version CONSTANT NUMBER := 1;

Line 1402: DELETE FROM OKE_K_TERMS

1398: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1399: RAISE OKE_API.G_EXCEPTION_ERROR;
1400: END IF;
1401:
1402: DELETE FROM OKE_K_TERMS
1403: WHERE K_LINE_ID = p_cle_id AND TERM_CODE = p_trm_cd
1404: AND TERM_VALUE_PK1=p_trm_val_pk1
1405: AND TERM_VALUE_PK2=p_trm_val_pk2;
1406:

Line 1452: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,

1448: x_return_status OUT NOCOPY VARCHAR2,
1449: x_msg_count OUT NOCOPY NUMBER,
1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_chr_id IN NUMBER,
1452: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1453: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1454: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1455: ) IS
1456:

Line 1453: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,

1449: x_msg_count OUT NOCOPY NUMBER,
1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_chr_id IN NUMBER,
1452: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1453: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1454: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1455: ) IS
1456:
1457: l_api_version CONSTANT NUMBER := 1;

Line 1454: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE

1450: x_msg_data OUT NOCOPY VARCHAR2,
1451: p_chr_id IN NUMBER,
1452: p_trm_cd OKE_K_TERMS.TERM_CODE%TYPE,
1453: p_trm_val_pk1 OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
1454: p_trm_val_pk2 OKE_K_TERMS.TERM_VALUE_PK2%TYPE
1455: ) IS
1456:
1457: l_api_version CONSTANT NUMBER := 1;
1458: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';

Line 1478: DELETE FROM OKE_K_TERMS

1474: ELSIF (l_return_status = OKE_API.G_RET_STS_ERROR) THEN
1475: RAISE OKE_API.G_EXCEPTION_ERROR;
1476: END IF;
1477:
1478: DELETE FROM OKE_K_TERMS
1479: WHERE (K_HEADER_ID=p_chr_id) AND (TERM_CODE=p_trm_cd)
1480: AND (K_LINE_ID IS NULL)
1481: AND (TERM_VALUE_PK1=p_trm_val_pk1)
1482: AND (TERM_VALUE_PK2=p_trm_val_pk2);

Line 1881: l_trm_cd OKE_K_TERMS.TERM_CODE%TYPE;

1877: l_row_notfound BOOLEAN := FALSE;
1878:
1879: l_chr_id NUMBER;
1880: l_cle_id NUMBER;
1881: l_trm_cd OKE_K_TERMS.TERM_CODE%TYPE;
1882:
1883: E_Resource_Busy EXCEPTION;
1884: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1885:

Line 1888: SELECT k_header_id,k_line_id,term_code FROM oke_k_terms a

1884: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
1885:
1886:
1887: CURSOR lock_csr (p IN term_rec_type) IS
1888: SELECT k_header_id,k_line_id,term_code FROM oke_k_terms a
1889: WHERE
1890: (a.K_HEADER_ID = p.K_HEADER_ID)AND(a.TERM_CODE=p.TERM_CODE)
1891: AND(a.TERM_VALUE_PK1=p.TERM_VALUE_PK1)
1892: AND(a.TERM_VALUE_PK2=p.TERM_VALUE_PK2)