APPS.IEU_SH_CON_PVT dependencies on IEU_SH_ACTIVITIES

Line 48: FROM ieu_sh_activities

44: -- Select all activity id for all open sessions
45:
46: cursor l_act_cur1(l_ses_id IN NUMBER) is
47: SELECT activity_id, media_id, activity_type_code, session_id, BEGIN_DATE_TIME
48: FROM ieu_sh_activities
49: WHERE end_date_time is NULL
50: AND active_flag = l_sh_active_flag
51: AND session_id = l_ses_id;
52:

Line 57: FROM ieu_sh_activities

53: -- select the activity id for all activities opened by UWQ whose sessions have been closed,
54:
55: cursor l_act_cur2(l_application_id in NUMBER) is
56: SELECT activity_id, session_id, media_id, BEGIN_DATE_TIME
57: FROM ieu_sh_activities
58: WHERE end_date_time is NULL
59: AND active_flag = l_sh_active_flag
60: AND session_id in (select session_id from ieu_sh_sessions
61: where application_id = l_application_id

Line 132: from ieu_sh_activities act

128: loop
129:
130: select max(trunc(last_update_date)), max(to_number(to_char(last_update_date, l_update_time_format)))
131: into l_last_update_date, l_last_update_time
132: from ieu_sh_activities act
133: where act.session_id = ses_cur_rec.session_id;
134:
135: IF ( ( (trunc(sysdate) > l_last_update_date)
136: and

Line 178: update IEU_SH_ACTIVITIES set

174:
175: IF (l_count_lc_segs > 0)
176: THEN
177:
178: update IEU_SH_ACTIVITIES set
179: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
180: END_DATE_TIME = l_cal_end_date_time,
181: ACTIVE_FLAG = NULL,
182: STATE_CODE = l_end_state_code,

Line 209: from IEU_SH_ACTIVITIES where

205: BEGIN
206: select decode ( greatest (max(end_date_time), max(deliver_date_time), max(begin_date_time) ), null,
207: act_cur_rec_1.begin_date_time, greatest (max(end_date_time), max(deliver_date_time), max(begin_date_time) ) )
208: into l_cycle_end_date_time
209: from IEU_SH_ACTIVITIES where
210: parent_cycle_id = act_cur_rec_1.activity_id;
211: EXCEPTION
212: WHEN OTHERS THEN
213: NULL;

Line 227: update IEU_SH_ACTIVITIES set

223: l_cycle_end_date_time := act_cur_rec_1.BEGIN_DATE_TIME;
224:
225: END IF;
226:
227: update IEU_SH_ACTIVITIES set
228: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
229: END_DATE_TIME = l_cycle_end_date_time,
230: ACTIVE_FLAG = NULL,
231: STATE_CODE = l_end_state_code,

Line 249: from ieu_sh_activities

245:
246: BEGIN
247: select max(end_date_time)
248: into l_end_date_time
249: from ieu_sh_activities
250: where session_id = ses_cur_rec.session_id;
251: EXCEPTION
252: WHEN OTHERS THEN
253: NULL;

Line 397: update IEU_SH_ACTIVITIES set

393: ELSE
394: l_act_end_date := cur_act.BEGIN_DATE_TIME;
395: END IF;
396:
397: update IEU_SH_ACTIVITIES set
398: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
399: END_DATE_TIME = l_act_end_date,
400: ACTIVE_FLAG = NULL,
401: STATE_CODE = l_end_state_code,

Line 410: from ieu_sh_activities

406:
407: BEGIN
408: select max(end_date_time)
409: into l_end_date_time
410: from ieu_sh_activities
411: where session_id = cur_ses.session_id;
412: EXCEPTION
413: WHEN OTHERS THEN
414: NULL;

Line 499: update IEU_SH_ACTIVITIES set

495: ELSE
496: l_act_end_date := cur_act.BEGIN_DATE_TIME;
497: END IF;
498:
499: update IEU_SH_ACTIVITIES set
500: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
501: END_DATE_TIME = l_act_end_date,
502: ACTIVE_FLAG = NULL,
503: STATE_CODE = l_end_state_code,

Line 512: from ieu_sh_activities

508:
509: BEGIN
510: select max(end_date_time)
511: into l_end_date_time
512: from ieu_sh_activities
513: where session_id = cur_ses.session_id;
514: EXCEPTION
515: WHEN OTHERS THEN
516: NULL;

Line 576: update IEU_SH_ACTIVITIES set

572: ELSE
573: l_act_end_date := act_cur_rec_2.BEGIN_DATE_TIME;
574: END IF;
575:
576: update IEU_SH_ACTIVITIES set
577: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
578: END_DATE_TIME = l_act_end_date,
579: ACTIVE_FLAG = NULL,
580: STATE_CODE = l_end_state_code,