Dynamically passing input parameter to alert
Hi,
We have an existing program which calls Oracle Alert. I am trying to modify that program to pass an input parameter to the alert.
Can someone please tell me how an Input parameter is passed to Oracle Alert?
Below is the snippet from the existing program and my changes.
Procedure Submit_Alert (
.....
Set_CP_Param_Value(TO_CHAR(l_appl_id),1);
Set_CP_Param_Value(TO_CHAR(l_alert_id),2);
Set_CP_Param_Value('A',3);
li_ret := Submit_Request ('ALR',
'ALECDC',
p_alert_name,
NULL,
FALSE);
.....
)
Procedure Submit_Request(
.....
li_ret := fnd_request.submit_request (application => p_app,
program => p_prog,