APPS.OKC_AAE_PVT dependencies on FND_APPLICATION

Line 888: -- Description : Checks id application id exists in fnd_application

884: ---------------------------------------------------------------------------
885: -- Start of comments
886: --
887: -- Procedure Name : Validate_Application_id
888: -- Description : Checks id application id exists in fnd_application
889: -- Business Rules :
890: -- Parameters :
891: -- Version : 1.0
892: -- End of comments

Line 900: from fnd_application

896: x_return_status OUT NOCOPY VARCHAR2,
897: p_aaev_rec IN aaev_rec_type) IS
898: Cursor application_id_cur(p_application_id IN NUMBER) IS
899: select '1'
900: from fnd_application
901: where application_id = p_application_id;
902: l_dummy VARCHAR2(1) := '?';
903: BEGIN
904: -- initialize return status

Line 908: --Check if application id exists in the fnd_application or not

904: -- initialize return status
905: x_return_status := OKC_API.G_RET_STS_SUCCESS;
906:
907: IF p_aaev_rec.application_id IS NOT NULL THEN
908: --Check if application id exists in the fnd_application or not
909: OPEN application_id_cur(p_aaev_rec.application_id);
910: FETCH application_id_cur INTO l_dummy;
911: CLOSE application_id_cur ;
912: IF l_dummy = '?' THEN