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.OKC_CONTRACT_PVT dependencies on OKC_ANCESTRYS

Line 1280: from OKC_ANCESTRYS

1276:
1277: -- cursor to get the next level_sequence
1278: Cursor l_acyv_csr Is
1279: select NVL(MAX(level_sequence),0) + 1
1280: from OKC_ANCESTRYS
1281: where cle_id = p_clev_rec.cle_id;
1282:
1283: -- cursor to get other ascendants
1284: Cursor l_acyv_csr2 Is

Line 1286: from OKC_ANCESTRYS

1282:
1283: -- cursor to get other ascendants
1284: Cursor l_acyv_csr2 Is
1285: select cle_id_ascendant, level_sequence
1286: from OKC_ANCESTRYS
1287: where cle_id = p_clev_rec.cle_id;
1288:
1289: BEGIN
1290: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 1686: from OKC_ANCESTRYS

1682:
1683: -- cursor to get ancestry records to delete
1684: Cursor l_acyv_csr Is
1685: select cle_id, cle_id_ascendant
1686: from OKC_ANCESTRYS
1687: where cle_id = p_cle_id;
1688:
1689: BEGIN
1690: -- delete all ancestry records if p_cle_id is not null