APPS.AHL_DI_FILEUPLOAD_PVT dependencies on FND_LOBS

Line 56: select FUPV.FILE_ID , FUPV.FILE_NAME from AHL_DOC_FILE_ASSOC_V FUPV, FND_LOBS FLOB

52: FROM dual;
53:
54:
55: CURSOR c_does_attach_exist (l_revid IN VARCHAR2) IS
56: select FUPV.FILE_ID , FUPV.FILE_NAME from AHL_DOC_FILE_ASSOC_V FUPV, FND_LOBS FLOB
57: where FUPV.REVISION_ID = l_revid
58: and FUPV.FILE_ID = FLOB.FILE_ID;
59:
60: l_attach_doc c_does_attach_exist%ROWTYPE;

Line 142: FROM FND_LOBS

138: IF (p_x_ahl_fileupload_rec.p_file_id IS NOT NULL) THEN
139: BEGIN
140: SELECT distinct 1
141: INTO l_dummy
142: FROM FND_LOBS
143: WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;
144: EXCEPTION
145: WHEN no_data_found THEN
146: IF G_DEBUG='Y' THEN

Line 347: select FUPV.ASSOCIATION_ID from AHL_DOC_FILE_ASSOC_V FUPV , FND_LOBS FLOB

343: l_assoc_id NUMBER;
344: l_security_group_id NUMBER;
345:
346: CURSOR c_get_association_id (l_revid IN VARCHAR2) IS
347: select FUPV.ASSOCIATION_ID from AHL_DOC_FILE_ASSOC_V FUPV , FND_LOBS FLOB
348: where FUPV.REVISION_ID = l_revid
349: and FUPV.FILE_ID = FLOB.FILE_ID;
350:
351: BEGIN

Line 424: --Validate if file exists in FND_LOBS

420: x_return_status := FND_API.G_RET_STS_ERROR;
421: END IF;
422:
423:
424: --Validate if file exists in FND_LOBS
425:
426: IF (p_x_ahl_fileupload_rec.p_file_id IS NOT NULL) THEN
427: BEGIN
428: SELECT distinct 1

Line 430: FROM FND_LOBS

426: IF (p_x_ahl_fileupload_rec.p_file_id IS NOT NULL) THEN
427: BEGIN
428: SELECT distinct 1
429: INTO l_dummy
430: FROM FND_LOBS
431: WHERE FILE_ID = p_x_ahl_fileupload_rec.p_file_id;
432: EXCEPTION
433: WHEN no_data_found THEN
434: IF G_DEBUG='Y' THEN