APPS.OKL_STM_PVT dependencies on OKL_STRM_TYPE_V

Line 639: FROM okl_strm_type_v

635: ,x_return_status OUT NOCOPY VARCHAR2 ) IS
636:
637: CURSOR l_styid_csr IS
638: SELECT '1'
639: FROM okl_strm_type_v
640: WHERE id=p_stmv_rec.sty_id;
641:
642: l_dummy_sty_id VARCHAR2(1);
643: l_row_notfound BOOLEAN :=TRUE;

Line 665: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_STM_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'STY_ID',G_PARENT_TABLE_TOKEN,'OKL_STRM_TYPE_V');

661: l_row_notfound :=l_styid_csr%NOTFOUND;
662: CLOSE l_styid_csr;
663:
664: IF(l_row_notfound ) THEN
665: OKC_API.SET_MESSAGE(G_APP_NAME,G_OKL_STM_NO_PARENT_RECORD,G_COL_NAME_TOKEN,'STY_ID',G_PARENT_TABLE_TOKEN,'OKL_STRM_TYPE_V');
666: x_return_status := Okc_Api.G_RET_STS_ERROR;
667: -- raise the exception as there's no matching foreign key value
668:
669: RAISE G_EXCEPTION_HALT_VALIDATION;