811: END IF;
812:
813: SELECT customer_item_id
814: INTO x_customer_item_id
815: FROM mtl_customer_items
816: WHERE customer_item_number = p_customer_item_num
817: AND customer_id = p_customer_id;
818:
819: RETURN x_customer_item_id;
840: END IF;
841:
842: SELECT customer_item_number
843: INTO x_customer_item_num
844: FROM mtl_customer_items
845: WHERE customer_item_id = p_customer_item_id;
846:
847: RETURN x_customer_item_num;
848: EXCEPTION