APPS.IEM_OP_STAT_PUB dependencies on IEM_OP_CONTROLLER_STATS

Line 60: select IEM_OP_CONTROLLER_STATS_S1.nextval into l_con_sequence from dual;

56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: -----------------------Code------------------------
59:
60: select IEM_OP_CONTROLLER_STATS_S1.nextval into l_con_sequence from dual;
61:
62: l_CONTROLLER_ID := l_con_sequence;
63:
64: x_controller_id := l_CONTROLLER_ID;

Line 66: insert into IEM_OP_CONTROLLER_STATS

62: l_CONTROLLER_ID := l_con_sequence;
63:
64: x_controller_id := l_CONTROLLER_ID;
65:
66: insert into IEM_OP_CONTROLLER_STATS
67: (
68: CONTROLLER_ID,
69: JSERV_ID,
70: JSERV_PORT,

Line 187: UPDATE IEM_OP_CONTROLLER_STATS SET

183:
184: l_CONTROLLER_ID := p_controller_id;
185:
186: IF (l_CONTROLLER_ID > 0) THEN
187: UPDATE IEM_OP_CONTROLLER_STATS SET
188: LAST_UPDATE_DATE = SYSDATE
189: WHERE CONTROLLER_ID = l_CONTROLLER_ID;
190:
191: BEGIN