698: p_org_id VARCHAR2,
699: p_item_no OUT NOCOPY VARCHAR2) IS
700: CURSOR cur_get_item_no IS
701: SELECT concatenated_segments
702: FROM mtl_system_items_kfv
703: WHERE inventory_item_Id = p_item_id
704: AND ORGANIZATION_ID = p_org_id;
705: BEGIN
706: OPEN cur_get_item_no;
711: PROCEDURE get_item_number1(p_item_id VARCHAR2,
712: p_item_no OUT NOCOPY VARCHAR2) IS
713: CURSOR cur_get_item_no IS
714: SELECT distinct concatenated_segments
715: FROM mtl_system_items_kfv
716: WHERE inventory_item_Id = p_item_id ;
717: BEGIN
718: OPEN cur_get_item_no;
719: FETCH cur_get_item_no INTO p_item_no;
724: p_org_id VARCHAR2,
725: p_item_desc OUT NOCOPY VARCHAR2) IS
726: CURSOR cur_get_item_desc IS
727: SELECT description
728: FROM mtl_system_items_kfv
729: WHERE inventory_item_Id = p_item_id
730: AND ORGANIZATION_ID = p_org_id;
731: BEGIN
732: OPEN cur_get_item_desc;