[Home] [Help]
1131:
1132: ----------------------------------------------------------------------------------------
1133: -----------------------------------------------------------------
1134: -- NOTES
1135: -- 1. Returns true if lgl_phys_map_id (IBE_DSP_LGL_PHYS_MAP) exists
1136: -- 2. If not , message IBE_DSP_PHYSMAP_NOT_EXISTS is pushed on the stack
1137: ---------------------------------------------------------------------
1138: FUNCTION check_physicalmap_exists(p_lgl_phys_map_id IN NUMBER)
1139: RETURN boolean
1144:
1145: CURSOR lgl_phys_map_cur( p_lgl_phys_map_id IN NUMBER ) IS
1146: -- SELECT lgl_phys_map_id
1147: SELECT 1
1148: FROM IBE_DSP_LGL_PHYS_MAP
1149: where lgl_phys_map_id = p_lgl_phys_map_id;
1150:
1151: l_map_not_exists_exception EXCEPTION;
1152:
1543: CURSOR attachment_cur(p_deliverable_id IN NUMBER,p_file_id IN NUMBER,p_file_name IN VARCHAR2) IS
1544: SELECT jta.attachment_id
1545: FROM JTF_AMV_ATTACHMENTS jta,
1546: JTF_AMV_ITEMS_B jtai,
1547: IBE_DSP_LGL_PHYS_MAP idlpm
1548: WHERE jta.file_name = p_file_name AND
1549: jta.file_id = p_file_id AND
1550: jta.attachment_id = idlpm.attachment_id AND
1551: idlpm.item_id = jtai.item_id AND
1554: CURSOR attachment_cur2(p_deliverable_id IN NUMBER,p_file_name IN VARCHAR2) IS
1555: SELECT jta.attachment_id
1556: FROM JTF_AMV_ATTACHMENTS jta,
1557: JTF_AMV_ITEMS_B jtai,
1558: IBE_DSP_LGL_PHYS_MAP idlpm
1559: WHERE jta.file_name = p_file_name AND
1560: jta.file_id is null AND
1561: jta.attachment_id = idlpm.attachment_id AND
1562: idlpm.item_id = jtai.item_id AND
1652:
1653: CURSOR physmap_cur(p_attachment_id IN NUMBER) IS
1654: -- SELECT attachment_id
1655: SELECT 1
1656: FROM IBE_DSP_LGL_PHYS_MAP
1657: WHERE attachment_id = p_attachment_id
1658: AND default_site = 'Y'
1659: AND default_language = 'Y';
1660: