APPS.IEM_MDTSTARTPROCESS_PUB dependencies on IEM_COMP_RT_STATS

Line 67: SELECT VALUE into l_status from IEM_COMP_RT_STATS

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: BEGIN
67: SELECT VALUE into l_status from IEM_COMP_RT_STATS
68: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
69: EXCEPTION WHEN NO_DATA_FOUND THEN
70: INSERT into IEM_COMP_RT_STATS
71: (

Line 70: INSERT into IEM_COMP_RT_STATS

66: BEGIN
67: SELECT VALUE into l_status from IEM_COMP_RT_STATS
68: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
69: EXCEPTION WHEN NO_DATA_FOUND THEN
70: INSERT into IEM_COMP_RT_STATS
71: (
72: COMP_RT_STATS_ID,
73: TYPE,
74: PARAM,

Line 86: delete from iem_comp_rt_Stats

82: 'T',
83: 99999,
84: SYSDATE);
85: WHEN TOO_MANY_ROWS THEN
86: delete from iem_comp_rt_Stats
87: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS'
88: and rownum<
89: (select count(*) from iem_comp_rt_stats
90: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS');

Line 89: (select count(*) from iem_comp_rt_stats

85: WHEN TOO_MANY_ROWS THEN
86: delete from iem_comp_rt_Stats
87: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS'
88: and rownum<
89: (select count(*) from iem_comp_rt_stats
90: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS');
91: WHEN OTHERS THEN
92: NULL;
93: END;

Line 98: --UPDATE IEM_COMP_RT_STATS

94: IF l_status='F'
95: THEN RAISE STOP_ALL_WORKERS;
96: END IF;
97: -- Fix for bug 3410951
98: --UPDATE IEM_COMP_RT_STATS
99: --set VALUE='T'
100: --WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
101:
102: LOOP

Line 104: SELECT value into l_status from iem_comp_rt_stats

100: --WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
101:
102: LOOP
103: BEGIN
104: SELECT value into l_status from iem_comp_rt_stats
105: WHERE type='MAILPROC' and param='RUNTIME STATUS';
106: EXIT when l_status='F';
107: --IF l_status='F'
108: -- THEN RAISE STOP_ALL_WORKERS;

Line 273: UPDATE IEM_COMP_RT_STATS

269: THEN
270: FND_MSG_PUB.initialize;
271: END IF;
272: -- Initialize API return status to SUCCESS
273: UPDATE IEM_COMP_RT_STATS
274: set VALUE='F'
275: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
276: COMMIT;
277: EXCEPTION