846: PROCEDURE validate_interest_index_id(
847: x_return_status OUT NOCOPY VARCHAR2,
848: p_interest_index_id IN NUMBER) IS
849: CURSOR C1(p_id NUMBER) IS 850: SELECT ID from OKL_INDICES 851: WHERE ID = p_id;
852: BEGIN
853: x_return_status := OKL_API.G_RET_STS_ERROR;
854: FOR r IN C1(p_interest_index_id)