Oracle Forms

Hi ,

I've In Tabular Custom Form , Need to Select Multiple Records And update their Flag with F when button Finalized is pressed , Below is the form screenshot & the code i wrote when button pressed , the problem that with the below code Only one record id from the selected ones that gets updated while i want to update all the records selected one time

Will You be please advice ...

Code :

*********

IF :XXDWTC_ES_TEMP_STAFF_SCHEDULES.SELECTED_FLG = 'Y'

THEN

 fnd\_message.set\_name ('Fnd','Do You want to Finalize The Selected Record(s) !!');

 IF (fnd\_message.warn) THEN

UPDATE XXDWTC_ES_TEMP_STAFF_SCHEDULES

SET SCHEDULE_FLAG = 'Y'

WHERE RECORD_ID = :XXDWTC_ES_TEMP_STAFF_SCHEDULES.RECORD_ID

AND (SCHEDULE_FLAG = 'N' OR SCHEDULE_FLAG IS NULL ) ;

COMMIT ;

fnd_message.set_String ('Record(s) Finallized Successfully ');

fnd_message.show;

 ELSE

 -- fnd\_message.set\_String ('Error in Finallizing Record(s) ');

 -- fnd\_message.show;

 null;

  END IF ;

ELSE

fnd_message.set_String ('Please Select The Requested Record(s)');

fnd_message.show;

END IF ;

**************************

ScreenShot