APPS.IBE_PHYSICALMAP_GRP dependencies on JTF_AMV_ATTACHMENTS

Line 846: from ibe_dsp_lgl_phys_map a, jtf_amv_attachments b

842:
843:
844: CURSOR attachment_ids IS
845: SELECT distinct b.attachment_id
846: from ibe_dsp_lgl_phys_map a, jtf_amv_attachments b
847: where a.item_id = p_deliverable_id
848: and a.attachment_id = b.attachment_id
849: and b.attachment_used_by_id = -1
850: and (b.file_id <=0 or b.file_id is null)

Line 867: -- delete from jtf_amv_attachments

863: fetch attachment_ids into l_attachment_id;
864: while attachment_ids%found
865: loop
866: --hft
867: -- delete from jtf_amv_attachments
868: -- where attachment_id = l_attachment_id;
869: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS
870: WHERE attachment_id = l_attachment_id;
871: JTF_AMV_ATTACHMENT_PUB.delete_act_attachment(

Line 869: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS

865: loop
866: --hft
867: -- delete from jtf_amv_attachments
868: -- where attachment_id = l_attachment_id;
869: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS
870: WHERE attachment_id = l_attachment_id;
871: JTF_AMV_ATTACHMENT_PUB.delete_act_attachment(
872: p_api_version => l_api_version,
873: x_return_status => x_return_status,

Line 1696: FROM JTF_AMV_ATTACHMENTS

1692: AND item_id = l_deliverable_id;
1693:
1694: -- added by YAXU, delete the attachment if the its file_id =0 and no realted mapping
1695: SELECT file_id into l_file_id
1696: FROM JTF_AMV_ATTACHMENTS
1697: WHERE attachment_id = l_attachment_id;
1698:
1699: IF l_file_id <= 0 or l_file_id is null THEN
1700: SELECT count(1) into l_other_item_count

Line 1709: -- DELETE FROM JTF_AMV_ATTACHMENTS

1705:
1706: IF l_other_item_count = 0 THEN
1707: -- delete the attachment
1708: --hft
1709: -- DELETE FROM JTF_AMV_ATTACHMENTS
1710: -- WHERE attachment_id = l_attachment_id;
1711: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS
1712: WHERE attachment_id = l_attachment_id;
1713: JTF_AMV_ATTACHMENT_PUB.delete_act_attachment(

Line 1711: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS

1707: -- delete the attachment
1708: --hft
1709: -- DELETE FROM JTF_AMV_ATTACHMENTS
1710: -- WHERE attachment_id = l_attachment_id;
1711: SELECT OBJECT_VERSION_NUMBER into l_obj_ver FROM JTF_AMV_ATTACHMENTS
1712: WHERE attachment_id = l_attachment_id;
1713: JTF_AMV_ATTACHMENT_PUB.delete_act_attachment(
1714: p_api_version => l_api_version,
1715: x_return_status => x_return_status,