DBA Data[Home] [Help]

APPS.PVX_ATTACHMENT_INT dependencies on FND_LOBS

Line 54: FROM FND_lobs

50: l_file_name varchar2(200);
51:
52: CURSOR c_get_file_name (l_file_id number) IS
53: SELECT file_name
54: FROM FND_lobs
55: WHERE fnd_lobs.file_id =l_file_id;
56:
57:
58: BEGIN

Line 55: WHERE fnd_lobs.file_id =l_file_id;

51:
52: CURSOR c_get_file_name (l_file_id number) IS
53: SELECT file_name
54: FROM FND_lobs
55: WHERE fnd_lobs.file_id =l_file_id;
56:
57:
58: BEGIN
59:

Line 291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;

287: CLOSE c_get_document_id_rows;
288: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
289: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is not from an Opportunity...', 1, 'Y');
290: END IF;
291: DELETE FROM fnd_lobs WHERE file_id = l_media_id;
292: ELSE
293: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
294: aso_debug_pub.add ( 'DELETE_ATTACHMENTS: Attachment is from an Opportunity...', 1, 'Y');
295: END IF;