Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SET RECORD PROPERTY

A.AzizAug 28 2012 — edited Sep 3 2012
hi

this from has multirecords and multiblocks for every date it shows employees' attendance record, there is a button that should disable selected records for that specific date

**part from the code**

Code:
---------------------------------------------------------------------------------------------------------------------------------
LOOP
if :ATTENDANCE.SIGGNED = 'Y' AND GET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',STATUS) = 'CHANGED' THEN
:ATTENDANCE.LAST_UPDATED_BY:=fnd_global.user_id;
:ATTENDANCE.LAST_UPDATE_DATE:=sysdate;
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',ENABLED,PROPERTY_FALSE);
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',UPDATE_ALLOWED,PROPERTY_FALSE);
SET_RECORD_PROPERTY(:SYSTEM.CURSOR_RECORD, 'ATTENDANCE',insert_allowed,PROPERTY_FALSE);
end if;
EXIT WHEN :SYSTEM.LAST_RECORD = 'TRUE' ;
NEXT_RECORD;
END LOOP;
---------------------------------------------------------------------------------------------------------------------------------

what happen that it is confirming that selected records are disabled AND it is NOT!!

**i can still change the records if i want **

but if I changed the date and go back "the date which i disabled its records" (reload that data) then it will be disabled

i need you guys to help me finding a way so it will be disabled immediately so i don't need to change dates to be disabled


**maybe if the is a code that will refresh records ?! i don't know !! just an idea which i search and didn't find information about it


thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2012
Added on Aug 28 2012
4 comments
11,995 views