Oracle Database Discussions

Guys,

I am getting ORA-06550 line 16, column 57
PL/SQL: ORA-00993: SQL command not properly ended
ORA-06550 line 4, column 1
PL/SQL: SQL statement ignored

DECLARE
TEMPID NUMBER(5, 0);
BEGIN
INSERT INTO PSR_PRVDR
(MAC_ID, PRVDR_ID, PRVDR_SEQ_NUM, PRVDR_UI_SEQ_NUM, PRVDR_NM_LGL_BUSNS_NM, PRVDR_NM_DNG_BUSNS_AS_NM, PRVDR_NM_SHRT_NM,
PRVDR_HRDSHP_FLAG, PRVDR_CRTFCTN_DT, PRVDR_PRNT_ID, PRVDR_PRNT_SEQ_NUM,
PRVDR_TIE_IN_DT, PRVDR_TIE_IN_NTC_RCVD_DT, MAC_SRVC_OFC_ID, PRVDR_CREAT_DT, PRVDR_CREAT_USER_ID,
PRVDR_UPDT_DT, PRVDR_UPDT_USER_ID)
(SELECT '00012', PP.PRVDR_ID, (SELECT NVL(MAX(PRVDR_SEQ_NUM)+1,1)
FROM PSR_PRVDR WHERE
PRVDR_ID = PP.PRVDR_ID), (SELECT NVL(MAX(PRVDR_UI_SEQ_NUM)+1,1) FROM PSR_PRVDR WHERE
PRVDR_ID = PP.PRVDR_ID), PP.PRVDR_NM_LGL_BUSNS_NM, PP.PRVDR_NM_DNG_BUSNS_AS_NM,
PP.PRVDR_NM_SHRT_NM, PP.PRVDR_HRDSHP_FLAG, PP.PRVDR_CRTFCTN_DT, UPP\\ER('909093'),
2, TO_DATE('01/01/2005','MM/DD/YYYY'), TO_DATE('01/01/2006','MM/DD/YYYY'),
'00090', SYSDATE, '?', SYSDATE, '?' FROM PSR_PRVDR PP
WHERE PP.PRVDR_ID = '909090' AND PP.PRVDR_SEQ_NUM = 1)
RETURNING PRVDR_SEQ_NUM INTO TEMPID;
END;


Thanks