DBA Data[Home] [Help]

APPS.OKC_ACN_PVT dependencies on FND_APPLICATION

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

1044: ---------------------------------------------------------------------------
1045: -- Start of comments
1046: --
1047: -- Procedure Name : Validate_Application_id
1048: -- Description : Checks id application id exists in fnd_application
1049: -- Business Rules :
1050: -- Parameters :
1051: -- Version : 1.0
1052: -- End of comments

Line 1060: from fnd_application

1056: x_return_status OUT NOCOPY VARCHAR2,
1057: p_acnv_rec IN acnv_rec_type) IS
1058: Cursor application_id_cur(p_application_id IN NUMBER) IS
1059: select '1'
1060: from fnd_application
1061: where application_id = p_application_id;
1062: l_dummy VARCHAR2(1) := '?';
1063: BEGIN
1064: -- initialize return status

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

1064: -- initialize return status
1065: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1066:
1067: IF p_acnv_rec.application_id IS NOT NULL THEN
1068: --Check if application id exists in the fnd_application or not
1069: OPEN application_id_cur(p_acnv_rec.application_id);
1070: FETCH application_id_cur INTO l_dummy;
1071: CLOSE application_id_cur ;
1072: IF l_dummy = '?' THEN