SQL & PL/SQL

Hi,

Working on EBS Version : 11.5.10.2


Table Name : ASO_QUOTE_HEADERS_ALL

COLUMNS :

QUOTE_STATUS_ID NUMBER

ATTRIBUTE6 VARCHAR2(240 BYTE);

Need to copy from quote_status_id to attribute6 for that quote_header_id


example if quote_status_id = 10 then it should copy in attribute6 = 10 for quote_header_id = 69312

again if changed to quote_status_id = 10077 then it should replace with attribute6 = 10077
for quote_header_id = 69312

i wrote a procedure posted below:

CREATE OR REPLACE procedure SLC_STATUS_CAPTURE (p_quote_header_id IN number) is
BEGIN
UPDATE aso_quote_headers_all SET attribute6 = quote_status_id
WHERE quote_header_id = p_quote_header_id;
end SLC_STATUS_CAPTURE;

then calling this trigger through table level

BEGIN
SLC_STATUS_CAPTURE(:OLD.QUOTE_HEADER_ID);
END;

it is giving an error.

Please i need some help.

Thanks and Regards
Vijay