DBA Data[Home] [Help]

APPS.OKC_PDF_PVT dependencies on FND_APPLICATION

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

743: END validate_seeded_flag;
744:
745: -- Start of comments
746: -- Procedure Name : validate_application_id
747: -- Description : Checks if application_id exists in fnd_application
748: -- Version : 1.0
749: -- End of comments
750:
751: PROCEDURE validate_application_id(

Line 756: from fnd_application

752: x_return_status OUT NOCOPY VARCHAR2,
753: p_pdfv_rec IN pdfv_rec_type) IS
754: Cursor application_id_cur(p_application_id IN NUMBER) IS
755: select '1'
756: from fnd_application
757: where application_id = p_application_id;
758: l_dummy VARCHAR2(1) := '?';
759: BEGIN
760: -- initialize return status

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

760: -- initialize return status
761: x_return_status := OKC_API.G_RET_STS_SUCCESS;
762:
763: IF p_pdfv_rec.application_id IS NOT NULL THEN
764: --Check if application id exists in the fnd_application or not
765: OPEN application_id_cur(p_pdfv_rec.application_id);
766: FETCH application_id_cur INTO l_dummy;
767: CLOSE application_id_cur ;
768: IF l_dummy = '?' THEN