[Home] [Help]
2574: c_dept_tsk_rec c_dept_tsk%ROWTYPE;
2575:
2576: /*sowsubra - part-chgER - 18 July, 2007 - start*/
2577: CURSOR c_get_inst_item (c_instance_id IN NUMBER) IS
2578: SELECT INVENTORY_ITEM_ID, INSTANCE_NUMBER FROM CSI_ITEM_INSTANCES
2579: WHERE instance_id = c_instance_id;
2580:
2581: c_inst_item_rec c_get_inst_item%ROWTYPE;
2582: /*sowsubra - part-chgER - end*/
2584: -- To find out if the item instances associated to a visit or task is still active
2585: -- CURSOR c_serial (p_serial_id IN NUMBER, p_item_id IN NUMBER, p_org_id IN NUMBER) IS
2586: -- part-chgER - changed the name of the cusror.
2587: CURSOR c_instance (c_instance_id IN NUMBER, c_item_id IN NUMBER, c_org_id IN NUMBER) IS
2588: SELECT count(*)FROM CSI_ITEM_INSTANCES
2589: WHERE Instance_Id = c_instance_id
2590: AND Inventory_Item_Id = c_item_id
2591: AND Inv_Master_Organization_Id = c_org_id
2592: AND ACTIVE_START_DATE <= sysdate
2598: -- To check the current status of the Unit
2599: CURSOR c_uc_status (p_instance_id IN NUMBER) IS
2600: SELECT name, AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(UNIT_CONFIG_HEADER_ID) uc_status
2601: FROM ahl_unit_config_headers uc,
2602: csi_item_instances csis
2603: WHERE uc.csi_item_instance_id=csis.instance_id
2604: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
2605: AND csis.instance_id = p_instance_id;
2606: