This content has been marked as final. Show 4 replies
You can create an item level validation of type PL/SQL Expression on the popup page opened from the report.
The item you would create the validation on would be P2_FINAL_DATE and the pl/sql expression you would use would be:
:p2_final_date >= :p2_last_date;
I did this way but it does not work. as i mentioned from same SUBMIT button both process should work. so when hit the button then it check date and then open another page (popup). So I created button called SUBMIT -> action: defined by dynamic action . then created a DA .
S type: Button
Acttion: seq 10: execute plsql code: code: update table
seq 20: skillbuilders modal page -> it will open another window.
so it work without validation. Howerver, if I defne button (SUBMIT) -> Action: SUBMIT then it validate but not open popup window.
Any clue that how to control both action (valdiate and open a popup window) from same button.
I have managed in this way. created another button and then Dynamic action so first time only first button say (Apply Changes) will be enable for update and validate and if successful then it is disbaled and other button say (Enter Other Info) will be enabled.
so if you guys know better way then please let me know.