[Home] [Help]
564: -- Fix for perf bug 2854588, sql id 5044302
565: PROCEDURE attachType IS
566: CURSOR c_get_attachment_csr IS
567: SELECT DISTINCT file_name
568: FROM jtf_amv_attachments a
569: WHERE application_id = 671
570: AND file_id IS NOT NULL
571: AND attachment_used_by = 'ITEM'
572: AND NOT EXISTS (
622: c_msite_id NUMBER, c_default_msite VARCHAR2,
623: c_language_code VARCHAR2, c_default_lang VARCHAR2) IS
624: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
625: SELECT b.file_id, b.display_height, b.display_width, b.file_name
626: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
627: WHERE a.attachment_id = b.attachment_id
628: AND a.default_language = c_default_lang
629: AND a.language_code = c_language_code
630: AND a.default_site = c_default_msite
634: CURSOR c_get_any_mapping(c_item_id NUMBER,
635: c_msite_id NUMBER, c_default_msite VARCHAR2) IS
636: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
637: SELECT b.file_id, b.display_height, b.display_width, b.file_name
638: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
639: WHERE a.attachment_id = b.attachment_id
640: AND a.default_site = c_default_msite
641: AND a.msite_id = c_msite_id
642: AND a.item_id = c_item_id;
761: c_msite_id NUMBER, c_default_msite VARCHAR2,
762: c_language_code VARCHAR2, c_default_lang VARCHAR2) IS
763: -- SELECT b.file_id, b.display_width, b.display_height, b.file_name
764: SELECT b.file_id, b.display_height, b.display_width, b.file_name
765: FROM jtf_amv_attachments b, ibe_dsp_lgl_phys_map a
766: WHERE a.attachment_id = b.attachment_id
767: AND a.default_language = c_default_lang
768: AND a.language_code = c_language_code
769: AND a.default_site = c_default_msite
1611: FROM IBE_MIGRATION_HISTORY
1612: WHERE migration_code = c_code
1613: AND status = c_status;
1614: CURSOR c1(l_date IN DATE) IS
1615: SELECT attachment_id,object_version_number FROM jtf_amv_attachments a
1616: WHERE file_id IS NOT NULL
1617: AND application_id = 671
1618: AND last_update_date < l_date
1619: AND attachment_used_by = 'ITEM'
1662: p_act_attachment_id =>r1.attachment_id,
1663: p_object_version =>r1.object_version_number);
1664: END LOOP;
1665:
1666: -- DELETE FROM jtf_amv_attachments a
1667: -- WHERE file_id IS NOT NULL
1668: -- AND application_id = 671
1669: -- AND last_update_date < l_date
1670: -- AND attachment_used_by = 'ITEM'
1745: -- yet
1746: -- Fix bug 2854588, sql id 5044448
1747: CURSOR c_get_content_repository_csr IS
1748: SELECT distinct file_id, file_name, display_height, display_width
1749: FROM jtf_amv_attachments a
1750: WHERE application_id = 671
1751: AND file_id IS NOT NULL
1752: AND attachment_used_by = 'ITEM'
1753: AND NOT EXISTS (