How to create a custom wait function on an standard Workflow,
I am going to create a lookup in Oracle (fnd_lookup) and insert Day and time in it
Ex:
Code = Mon Meaning = 01:00 AM
Code= Wed Meaning = 04:00 AM
Now before sending any approval request to the manager , Workflow should first check these time duration and put a hold/wait on the workflow ..
If user changes the day or time in the lookup during the wait/hold period it should honer the new time and move to the next stage/process with in the workflow.
how we can add this stage and build the wait event in standard workflow process
Thanks..