APPS.IEM_NEXT_GEN_PROCESS_EMAIL_PVT dependencies on IEM_COMP_RT_STATS

Line 67: SELECT VALUE into l_status from IEM_COMP_RT_STATS -- New Table

63: FND_MSG_PUB.initialize;
64: END IF;
65:
66: BEGIN
67: SELECT VALUE into l_status from IEM_COMP_RT_STATS -- New Table
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 -- New Table
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 100: SELECT value into l_status from IEM_COMP_RT_STATS

96: END IF;
97:
98: LOOP
99: BEGIN
100: SELECT value into l_status from IEM_COMP_RT_STATS
101: WHERE type='MAILPROC' and param='RUNTIME STATUS';
102: EXIT when l_status='F';
103: EXCEPTION WHEN OTHERS THEN
104: EXIT;

Line 217: UPDATE IEM_COMP_RT_STATS

213: FND_MSG_PUB.initialize;
214: END IF;
215:
216: -- Initialize API return status to SUCCESS
217: UPDATE IEM_COMP_RT_STATS
218: set VALUE='F'
219: WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';
220: COMMIT;
221: