I CAN TO SEARCH FOR BLOCK MASTER
BLOCK 1 :CHECK_HDR FROM_NO TO_NO LOV
BLOCK 2 :CHECK_DTL Tabular BLOCK For Retrieve DATA Display ITEM
BLock 3 : Along Side BLock 2

PROBLEM

BLOCK 3 I Can to click checkBox (Y/N) -- Triggers when-checkbox-changed
BEGIN
IF :XX_AUDIT_CHECK.CHECK_CONDITION='Y'THEN
:XX_AUDIT_CHECK.CHECK_ID :=:CHECKS_DTL.VOUCHER_NUM;
:XX_AUDIT_CHECK.CHECK_NO:=:CHECKS_DTL.CHECK_NO;
:XX_AUDIT_CHECK.CHECK_CONDITION:='Y';
:XX_AUDIT_CHECK.USER_CHECK:=FND_GLOBAL.USER_NAME;
:XX_AUDIT_CHECK.DATE_CHECK:=SYSDATE;
:XX_AUDIT_CHECK.REMARK:=:XX_AUDIT_CHECK.REMARK;
ELSIF :XX_AUDIT_CHECK.CHECK_CONDITION='N' THEN
:XX_AUDIT_CHECK.CHECK_ID :=:CHECKS_DTL.VOUCHER_NUM;
:XX_AUDIT_CHECK.CHECK_NO:=:CHECKS_DTL.CHECK_NO;
:XX_AUDIT_CHECK.CHECK_CONDITION:='N';
:XX_AUDIT_CHECK.USER_CHECK:=FND_GLOBAL.USER_NAME;
:XX_AUDIT_CHECK.DATE_CHECK:=SYSDATE;
:XX_AUDIT_CHECK.REMARK:=:XX_AUDIT_CHECK.REMARK;
END IF;
END;

this code its Ok

but if we can to search for new Data from_no To_no
for the new search he is not correct data to Retrieve in the block 3 Tabulare

the code for Icone NEW SERACH IN Block 1 when-Bottom-Pressed


DECLARE
CURSOR XX IS
SELECT XX_AUD.CHECK_ID,XX_AUD.CHECK_NO,
XX_AUD.CHECK_CONDITION,XX_AUD.DATE_CHECK,
XX_AUD.USER_CHECK,XX_AUD.REMARK,
XX_AUD.UPDATE_NAME
FROM AP.XX_AUDIT_CHECK XX_AUD
where XX_AUD.CHECK_NO BETWEEN :CHECKS_HDR.CHECK_NO_FROM AND :CHECKS_HDR.CHECK_NO_TO;
BEGIN
FOR X_REC IN XX
LOOP
GO_BLOCK('XX_AUDIT_CHECK ');
IF :XX_AUDIT_CHECK.CHECK_NO ='TRUE'
THEN
:XX_AUDIT_CHECK.CHECK_ID :=X_REC.CHECK_ID;
:XX_AUDIT_CHECK.CHECK_NO :=X_REC.CHECK_NO;
:XX_AUDIT_CHECK.CHECK_CONDITION :=X_REC.CHECK_CONDITION;
:XX_AUDIT_CHECK.DATE_CHECK :=X_REC.DATE_CHECK;
:XX_AUDIT_CHECK.USER_CHECK:=X_REC.USER_CHECK;
:XX_AUDIT_CHECK.REMARK:=X_REC.REMARK;
:XX_AUDIT_CHECK.UPDATE_NAME:=X_REC.UPDATE_NAME;
ELSE
:XX_AUDIT_CHECK.CHECK_ID :=NULL;
:XX_AUDIT_CHECK.CHECK_NO :=NULL;
:XX_AUDIT_CHECK.CHECK_CONDITION :=NULL;
:XX_AUDIT_CHECK.DATE_CHECK :=NULL;
:XX_AUDIT_CHECK.USER_CHECK:=NULL;
:XX_AUDIT_CHECK.REMARK:=NULL;
:XX_AUDIT_CHECK.UPDATE_NAME:=NULL;

END IF;
END LOOP;
EXCEPTION
when NO_DATA_FOUND THEN NULL;
END;


The Result :


Message

you Cant Create Records Here :-


you Can help me to Solve this Problem If we Can


Thanks Very MUCH :-