Method Definitions: Create the two member functions of type PurchaseOrder_objtyp with a CREATE TYPE BODY statement. /* The getPONo method simply returns the value of the PONo attribute namely, the purchase order number of whatever instance of the type PurchaseOrder_objtyp that calls the method.*/ /* The sumLineItems method is to return the sum of the values of the line items of its associated PurchaseOrder_objtyp object. */ ________________________ PurchaseOrder_objtyp AS MAP MEMBER FUNCTION ___________ RETURN NUMBER IS BEGIN ____________; END; MEMBER FUNCTION ____________ RETURN NUMBER IS i INTEGER; StockVal StockItem_objtyp; Total NUMBER := 0; BEGIN FOR i in 1 .. SELF.LineItemList_ntab.COUNT LOOP UTL_REF.SELECT_OBJECT(LineItemList_ntab(i).Stock_ref, StockVal); _____:=_____ + SELF.LineItemList_ntab(i).______ * StockVal.____; END LOOP; RETURN _______; END; END; /

Customer CustNo CustName has Phone 0.. 10 Number has 1 1 Address Street City State Zip places 1 Purchase Order PONO Order Date ShipDate Ship To getPONOO sumLineItems contains Line Item LineItem No Quantity Discount refers to 1 Stock Item StockNo Price TaxRate 1