APPS.IEM_CONCURRENT_MDT_PVT dependencies on IEM_COMP_RT_STATS

Line 35: SELECT count(*) into l_status_count from IEM_COMP_RT_STATS

31: reqid number;
32:
33: BEGIN
34:
35: SELECT count(*) into l_status_count from IEM_COMP_RT_STATS
36: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
37: if l_status_count = 0 THEN
38: INSERT into IEM_COMP_RT_STATS
39: (

Line 38: INSERT into IEM_COMP_RT_STATS

34:
35: SELECT count(*) into l_status_count from IEM_COMP_RT_STATS
36: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
37: if l_status_count = 0 THEN
38: INSERT into IEM_COMP_RT_STATS
39: (
40: COMP_RT_STATS_ID,
41: TYPE,
42: PARAM,

Line 63: -- If this is the first run, we'll set i = 1. and update iem_comp_rt_stats

59: --
60: req_data := fnd_conc_global.request_data;
61:
62: --
63: -- If this is the first run, we'll set i = 1. and update iem_comp_rt_stats
64: -- and set it to T
65: -- Otherwise, we'll set i = request_data + 1, and we'll exit
66: -- if we're done.
67: --

Line 70: SELECT value into l_status from iem_comp_rt_stats

66: -- if we're done.
67: --
68: if (req_data is not null) then
69: --this means the conc program has been running
70: SELECT value into l_status from iem_comp_rt_stats
71: WHERE type='MAILPROC' and param='RUNTIME STATUS' and rownum = 1;
72: i := to_number(req_data);
73: i := i + 1;
74: --if (i > MAXREQS ) then

Line 79: DELETE FROM iem_comp_rt_Stats

75: if (l_status = 'F' ) then
76: errbuf := 'Done!';
77: retcode := 0 ;
78: --delete the record so that next time it we start we insert a value
79: DELETE FROM iem_comp_rt_Stats
80: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
81: commit;
82: return;
83: end if;