CREATE OR REPLACE FUNCTION F_CONVERSION_RATE(V_RECEIPT_NUM IN VARCHAR2(30),V_ITEM_ID IN NUMBER,V_ORG_ID IN NUMBER)
return number is
V_CONVERSION_RATE number(8,6);
CURSOR C_CONV_RATE
IS
select distinct muc.CONVERSION_RATE
from rcv_transactioons rt, rcv_shipment_headers rsh,rcv_shipment_lines rsl, mtl_uom_conversions muc
where rt.SHIPMENT_HEADER_ID = rsh.SHIPMENT_HEADER_ID
and muc.UNIT_OF_MEASURE = rt.UNIT_OF_MEASURE
and rt.SHIPMENT_LINE_ID = rsl.SHIPMENT_LINE_ID
and rsh.RECEIPT_NUM = V_RECEIPT_NUM
and rt.ORGANIZATION_ID = V_ORG_ID
and rsl.ITEM_ID = V_ITEM_ID
and rt.TRANSACTION_TYPE = 'DELIVER';
begin
OPEN C_CONV_RATE;
FETCH C_CONV_RATE INTO V_CONVERSION_RATE;
CLOSE C_CONV_RATE;
RETURN V_CONVERSION_RATE;
exception when no_data_found then
return 1;
END;
when i create function then i got warnning and i get this error
PLS-00103: Encountered the symbol "(" when expecting one of the following: := . ) , [@] % default character The symbol ":=" was substituted for "(" to continue.
so someone help and guide me.
PLS-00103: Encountered the symbol "(" when expecti
Who is online
Users browsing this forum: No registered users and 0 guests