DBA Data[Home] [Help]

APPS.IBE_ATTACHMENT_GRP dependencies on JTF_AMV_ATTACHMENTS

Line 8: g_view_name CONSTANT VARCHAR2(48) := 'jtf_amv_attachments a';

4:
5: TYPE AthCurTyp IS REF CURSOR;
6:
7: --modifed by G. Zhang 05/09/2001 04:06PM
8: g_view_name CONSTANT VARCHAR2(48) := 'jtf_amv_attachments a';
9:
10: PROCEDURE list_attachment (
11: p_api_version IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

Line 805: from jtf_amv_attachments

801: );
802:
803: --added by YAXU on 07/31/02
804: select file_id into l_file_id
805: from jtf_amv_attachments
806: where attachment_id = p_ath_id_ver_tbl(l_index).attachment_id;
807:
808:
809: -- Delete the attachment

Line 823: from jtf_amv_attachments

819: --added by YAXU on 07/31/02
820: IF l_file_id>0
821: THEN
822: select count(1) into l_count
823: from jtf_amv_attachments
824: where file_id = l_file_id;
825: IF l_count=0
826: THEN
827: fnd_gfm.delete_lob(l_file_id );