APEX

Hi All,

I have done the process by creating the modal dialog box every thing is wroking fine but agian when the page loads it is showing the dialog box again.
How we can restrict the dialog process.

Steps Involved#

1. Created a onload function as onload="promptUserSearch();"
2. Created a hidden vaibale as "P6_CHECK"
3. Setting the hidden as "Y" in javascript funcation as
function promptUserSearch() {
if(document.getElementById('P6_CHECK').value=='Y') {
$('#dialog-confirm').dialog('open');}}
4. Created a page Header process and checking the count is greater than or not.
5. Based on that i am seeting the P6_CHECK as "Y" or "N".
6. Intally when the page loads in mine scrren it will empty and by deafult if they click on search button then i need to display the dialog box which is showing, but when i click the "enter the key" in that dialog box it will load the same page but again the dialog box is apperaing agaian in this scenerio. How i need to fix this?



For your refernece i have placed the Query in page header process

declare
v_count number;

begin

SELECT count(*) into v_count
FROM form MF,
bench BM,
part PP,
tag KT
WHERE MF.ENGAGEMENT_ID=BM.ENGAGEMENT_ID
AND BM.ENGAGEMENT_ID =PP.ENGAGEMENT_ID
AND PP.ENGAGEMENT_ID =KT.ENGAGEMENT_ID
AND (MF.ENGAGEMENT_ID=:P6_ENG_ID OR KT.KEY_TAG=:P6_ENG_KEY OR BM.BENCHMARK=:P6_ENG_BENCH OR PP.PARTICIPANT=:P6_ENG_LEAD
OR MF.ENGAGEMENT_COUNTRY=:P6_ENG_CNTY OR MF.ENGAGEMENT_COUNTRY=:P6_ENG_CNTY OR MF.ENGAGEMENT_STATE=:P6_ENG_STA
);

if v_count > 0 then
:P6_CHECK:='N';
else
:P6_CHECK:='Y';
end if;
end;


Thanks,
Anoo..