DBA Data[Home] [Help]

APPS.OKL_CRA_PVT dependencies on OKL_CURE_REPORTS

Line 549: l_approval_status OKL_CURE_REPORTS.approval_status%TYPE;

545: PROCEDURE validate_cure_report_id(
546: x_return_status OUT NOCOPY VARCHAR2,
547: p_crav_rec IN crav_rec_type) IS
548: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
549: l_approval_status OKL_CURE_REPORTS.approval_status%TYPE;
550:
551: -- Check if the request is still in WIP status
552: CURSOR get_request_status (p_cure_report_id IN NUMBER) IS
553: SELECT approval_status

Line 554: FROM OKL_cure_reports

550:
551: -- Check if the request is still in WIP status
552: CURSOR get_request_status (p_cure_report_id IN NUMBER) IS
553: SELECT approval_status
554: FROM OKL_cure_reports
555: WHERE cure_report_id = p_cure_report_id;
556:
557: BEGIN
558: