Hi
I have a procedure that i need to schedule to run. I created a concurrent program for that. But the procedure has four parameters. I need to call this concurrent program from one more procedure where the values are retrieved.
- create or replace procedure cbtt_update(fromname IN Varchar2, sender IN varchar2, begindate IN date, enddate IN varchar2)
-
is
-
begin
-
..............
-
-
Business logic
-
...........
-
-
end cbtt_update
I created a concurrent program cbttupdate for the above code. Now i have one more procedure which calls this concurrent program and also the parent procedure for getting the parameter values.
- create or replace procedure cbtt_getvalues()
-
is
-
fromname varchar2(100);
-
sender varchar2(100);
-
begindate date;
-
enddate date;
-
conreqid number :=0;
-
begin
-
-
select creator_id,selector,begin_date,end_date into fromname,sender,begindate,enddate from table where..................
-
-
concreqid := fnd_request.submit_request ('FND',cbttupdate,'',SYSDATE,FALSE,CHR (0));
-
-
end cbtt_getvalues;
Now the above request wil just cal the procedure. Where should i add the parameters. Is this the right way to call.
concreqid := fnd_request.submit_request ('FND',cbttupdate,'',SYSDATE,FALSE,CHR (0),fromname,sender,begindate,enddate);
vamsi
