[Home] [Help]
4629: c_dept_tsk_rec c_dept_tsk%ROWTYPE;
4630:
4631: /*sowsubra - part-chgER - 18 July, 2007 - start*/
4632: CURSOR c_get_inst_item (c_instance_id IN NUMBER) IS
4633: SELECT INVENTORY_ITEM_ID, INSTANCE_NUMBER FROM CSI_ITEM_INSTANCES
4634: WHERE instance_id = c_instance_id;
4635:
4636: c_inst_item_rec c_get_inst_item%ROWTYPE;
4637: /*sowsubra - part-chgER - end*/
4639: -- To find out if the item instances associated to a visit or task is still active
4640: -- CURSOR c_serial (p_serial_id IN NUMBER, p_item_id IN NUMBER, p_org_id IN NUMBER) IS
4641: -- part-chgER - changed the name of the cusror.
4642: CURSOR c_instance (c_instance_id IN NUMBER, c_item_id IN NUMBER, c_org_id IN NUMBER) IS
4643: SELECT count(*)FROM CSI_ITEM_INSTANCES
4644: WHERE Instance_Id = c_instance_id
4645: AND Inventory_Item_Id = c_item_id
4646: AND Inv_Master_Organization_Id = c_org_id
4647: AND ACTIVE_START_DATE <= sysdate
4653: -- To check the current status of the Unit
4654: CURSOR c_uc_status (p_instance_id IN NUMBER) IS
4655: SELECT name, AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(UNIT_CONFIG_HEADER_ID) uc_status
4656: FROM ahl_unit_config_headers uc,
4657: csi_item_instances csis
4658: WHERE uc.csi_item_instance_id=csis.instance_id
4659: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
4660: AND csis.instance_id = p_instance_id;
4661:
6307: -- Cursor to get any instance from UC table
6308: CURSOR get_any_uc_inst_csr IS
6309: SELECT INST.inventory_item_id, UC.csi_item_instance_id
6310: FROM AHL_UNIT_CONFIG_HEADERS UC,
6311: CSI_ITEM_INSTANCES INST
6312: WHERE UC.unit_config_status_code = 'COMPLETE'
6313: AND NVL(UC.active_end_date, SYSDATE+1) > SYSDATE
6314: AND INST.instance_id = UC.csi_item_instance_id
6315: AND rownum = 1;
6317: -- MANESING::Component Maintenance Planning Project, 02-Nov-2011, added following cursor
6318: -- Cursor to get serial number given the item instance id
6319: CURSOR get_inst_serial_no_csr (c_instance_id NUMBER) IS
6320: SELECT serial_number
6321: FROM CSI_ITEM_INSTANCES
6322: WHERE instance_id = c_instance_id;
6323: l_serial_number VARCHAR2(30);
6324:
6325: -- MANESING::Component Maintenance Planning Project, 02-Nov-2011, added following cursor
6326: -- Cursor to find a serialized instance in any of Repair Batches within the given Component Visit
6327: CURSOR get_serialized_inst_csr (c_visit_id NUMBER) IS
6328: SELECT INST.inventory_item_id, INST.instance_id
6329: FROM AHL_VISIT_TASKS_B TSK,
6330: CSI_ITEM_INSTANCES INST
6331: WHERE TSK.visit_id = c_visit_id
6332: AND TSK.status_code NOT IN ('DELETED', 'CANCELLED', 'CLOSED')
6333: AND TSK.instance_id = INST.instance_id
6334: AND INST.serial_number IS NOT NULL