APPS.OKC_OCE_PVT dependencies on FND_APPLICATION

Line 938: -- Description : Checks if application_id exists in fnd_application

934: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
935: END validate_seeded_flag;
936: -- Start of comments
937: -- Procedure Name : validate_application_id
938: -- Description : Checks if application_id exists in fnd_application
939: -- Version : 1.0
940: -- End of comments
941:
942: PROCEDURE validate_application_id(

Line 947: from fnd_application

943: x_return_status OUT NOCOPY VARCHAR2,
944: p_ocev_rec IN ocev_rec_type) IS
945: Cursor application_id_cur(p_application_id IN NUMBER) IS
946: select '1'
947: from fnd_application
948: where application_id = p_application_id;
949: l_dummy VARCHAR2(1) := '?';
950: BEGIN
951: -- initialize return status

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

951: -- initialize return status
952: x_return_status := OKC_API.G_RET_STS_SUCCESS;
953:
954: IF p_ocev_rec.application_id IS NOT NULL THEN
955: --Check if application id exists in the fnd_application or not
956: OPEN application_id_cur(p_ocev_rec.application_id);
957: FETCH application_id_cur INTO l_dummy;
958: CLOSE application_id_cur ;
959: IF l_dummy = '?' THEN