Hi all, 

I am new to creating custom events and a novice when it comes to PL/SQL. I am trying to achieve when a Purchase Requisition is turned into a Request for Order Quotation that the Supplier on the Purchase Requisition Line is transferred to the Supplier tab in the Request for Order Quotation LU. 

My code isn’t erroring out but I feel I am missing something as the supplier is not transferring over. 

As always, thank you for your help and time. 

-Eli

Code:

 

DECLARE

INQUIRY_NO_ VARCHAR2(32000) := '&NEW:INQUIRY_NO';
VENDOR_NO_ VARCHAR2(32000);
attr_ VARCHAR2(32000);

CURSOR get_vendor_no IS
SELECT VENDOR_NO
FROM PURCHASE_REQ_LINE_PART
WHERE vendor_no = vendor_no_; 

BEGIN

OPEN get_vendor_no;
FETCH get_vendor_no INTO vendor_no_;
CLOSE get_vendor_no;

Client_SYS.clear_attr(attr_);
Client_SYS.add_to_attr('VENDOR_NO', vendor_no_, attr_);

END;