APPS.IEU_SH_PVT dependencies on IEU_SH_SESSIONS

Line 53: INSERT INTO IEU_SH_SESSIONS (

49: THEN
50: FND_MSG_PUB.INITIALIZE;
51: END IF;
52:
53: INSERT INTO IEU_SH_SESSIONS (
54: SESSION_ID,
55: OBJECT_VERSION_NUMBER,
56: CREATED_BY,
57: CREATION_DATE,

Line 69: IEU_SH_SESSIONS_S1.NEXTVAL,

65: EXTENSION,
66: APPLICATION_ID
67: ) values
68: (
69: IEU_SH_SESSIONS_S1.NEXTVAL,
70: l_object_version_number,
71: P_USER_ID,
72: SYSDATE,
73: P_USER_ID,

Line 195: update IEU_SH_SESSIONS set

191: THEN
192: FND_MSG_PUB.INITIALIZE;
193: END IF;
194:
195: update IEU_SH_SESSIONS set
196: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
197: END_DATE_TIME = SYSDATE,
198: ACTIVE_FLAG = NULL,
199: END_REASON_CODE = P_END_REASON_CODE,

Line 343: UPDATE ieu_sh_sessions

339: THEN
340: FND_MSG_PUB.INITIALIZE;
341: END IF;
342:
343: UPDATE ieu_sh_sessions
344: SET active_flag = 'Y',
345: end_date_time = NULL
346: WHERE session_id = p_session_id
347: AND end_date_time is not null