APPS.IEM_COMP_RT_STATS_PVT dependencies on IEM_COMP_RT_STATS

Line 1: PACKAGE BODY IEM_COMP_RT_STATS_PVT as

1: PACKAGE BODY IEM_COMP_RT_STATS_PVT as
2: /* $Header: iemvcrsb.pls 115.2 2002/12/04 02:40:51 chtang noship $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_COMP_RT_STATS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,

Line 3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_COMP_RT_STATS_PVT ';

1: PACKAGE BODY IEM_COMP_RT_STATS_PVT as
2: /* $Header: iemvcrsb.pls 115.2 2002/12/04 02:40:51 chtang noship $ */
3: G_PKG_NAME CONSTANT varchar2(30) :='IEM_COMP_RT_STATS_PVT ';
4:
5: PROCEDURE create_item (p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2,
7: p_commit IN VARCHAR2,

Line 43: SELECT IEM_COMP_RT_STATS_s1.nextval

39: -- Initialize API return status to SUCCESS
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
42:
43: SELECT IEM_COMP_RT_STATS_s1.nextval
44: INTO l_seq_id
45: FROM dual;
46:
47: INSERT INTO IEM_COMP_RT_STATS

Line 47: INSERT INTO IEM_COMP_RT_STATS

43: SELECT IEM_COMP_RT_STATS_s1.nextval
44: INTO l_seq_id
45: FROM dual;
46:
47: INSERT INTO IEM_COMP_RT_STATS
48: (
49: COMP_RT_STATS_ID,
50: TYPE,
51: PARAM,

Line 148: update IEM_COMP_RT_STATS

144: END IF;
145: -- Initialize API return status to SUCCESS
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: update IEM_COMP_RT_STATS
149: set type=decode(p_type,FND_API.G_MISS_CHAR, null, null, type,p_type),
150: param=decode(p_param,FND_API.G_MISS_CHAR, null, null,param,p_param),
151: value=decode(p_value,FND_API.G_MISS_CHAR, null, null,value,p_value),
152: LAST_UPDATE_DATE = l_LAST_UPDATE_DATE,

Line 230: delete from IEM_COMP_RT_STATS

226: END IF;
227: -- Initialize API return status to SUCCESS
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
230: delete from IEM_COMP_RT_STATS
231: where comp_rt_stats_id=p_comp_rt_stats_id;
232:
233: -- Standard Check Of p_commit.
234: IF FND_API.To_Boolean(p_commit) THEN

Line 304: delete from iem_comp_rt_stats where type IN ('EMAIL_ACCOUNT', 'AGENT_ACCOUNT',

300: END IF;
301: -- Initialize API return status to SUCCESS
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: delete from iem_comp_rt_stats where type IN ('EMAIL_ACCOUNT', 'AGENT_ACCOUNT',
305: 'AGENT', 'IMAP', 'SMTP', 'OES') and sysdate - last_update_date >1;
306:
307: -- Standard Check Of p_commit.
308: IF FND_API.To_Boolean(p_commit) THEN

Line 349: END IEM_COMP_RT_STATS_PVT ;

345: );
346:
347: END delete_item_for_cache;
348:
349: END IEM_COMP_RT_STATS_PVT ;