1066: arg_plan_id is null or
1067: arg_instance_id is null then
1068: select item_name
1069: into v_item_name
1070: from msc_items
1071: where inventory_item_id = arg_item_id;
1072: return v_item_name;
1073: end if;
1074:
1083:
1084: exception when no_data_found then
1085: select item_name
1086: into v_item_name
1087: from msc_items
1088: where inventory_item_id = arg_item_id;
1089: return v_item_name;
1090:
1091: END item_name;
4740: arg_plan_id is null or
4741: arg_instance_id is null then
4742: select description
4743: into v_item_desc
4744: from msc_items
4745: where inventory_item_id = arg_item_id;
4746: return v_item_desc;
4747: end if;
4748:
4757:
4758: exception when no_data_found then
4759: select description
4760: into v_item_desc
4761: from msc_items
4762: where inventory_item_id = arg_item_id;
4763: return v_item_desc;
4764:
4765: END get_equipment_desc;