APPS.IEU_SH_CON_PVT dependencies on IEU_SH_SESSIONS

Line 17: FROM ieu_sh_sessions where active_flag = l_sh_active_flag

13: --Select all users who have more than one session open by UWQ
14:
15: cursor l_users(l_application_id in NUMBER) is
16: SELECT resource_id, count(resource_id) count, max(last_update_date) last_update
17: FROM ieu_sh_sessions where active_flag = l_sh_active_flag
18: and application_id = l_application_id
19: GROUP BY resource_id HAVING count(resource_id) > 1;
20:
21: -- SELECT resource_id

Line 30: FROM ieu_sh_sessions

26: --which are open by UWQ
27:
28: cursor l_ses_resource(l_resource_id in NUMBER, l_application_id in NUMBER) is
29: SELECT session_id, last_update_date
30: FROM ieu_sh_sessions
31: WHERE resource_id = l_resource_id
32: AND active_flag = l_sh_active_flag
33: AND application_id = l_application_id;
34:

Line 39: FROM ieu_sh_sessions ses

35: -- Select the session id if the sessions are open by UWQ
36:
37: cursor l_ses_cur(l_application_id in NUMBER) is
38: SELECT session_id, resource_id
39: FROM ieu_sh_sessions ses
40: WHERE end_date_time is NULL
41: AND active_flag = l_sh_active_flag
42: AND application_id = l_application_id;
43:

Line 60: AND session_id in (select session_id from ieu_sh_sessions

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
62: and end_date_time is not null
63: and active_flag is null)
64: ;

Line 259: from ieu_sh_sessions

255:
256: if (l_end_date_time is null) then
257: select begin_date_time
258: into l_end_date_time
259: from ieu_sh_sessions
260: where session_id = ses_cur_rec.session_id;
261: end if;
262:
263: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);

Line 265: update IEU_SH_SESSIONS set

261: end if;
262:
263: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);
264:
265: update IEU_SH_SESSIONS set
266: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
267: END_DATE_TIME = l_end_date_time,
268: ACTIVE_FLAG = NULL,
269: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 281: from ieu_sh_sessions ses

277: -- dbms_output.put_line('Session id for sessions with no activities: '||ses_cur_rec.session_id);
278:
279: select trunc(last_update_date), to_number(to_char(last_update_date, l_update_time_format))
280: into l_last_update_date, l_last_update_time
281: from ieu_sh_sessions ses
282: where ses.session_id = ses_cur_rec.session_id;
283:
284: IF ( ( (trunc(sysdate) > l_last_update_date)
285: and

Line 304: update IEU_SH_SESSIONS set

300: )
301: )
302: THEN
303:
304: update IEU_SH_SESSIONS set
305: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
306: END_DATE_TIME = BEGIN_DATE_TIME,
307: ACTIVE_FLAG = NULL,
308: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 362: update IEU_SH_SESSIONS set

358: for cur_ses in l_ses_resource(l_agent_resource_id, l_applId)
359: loop
360:
361: /*
362: update IEU_SH_SESSIONS set
363: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
364: END_DATE_TIME = BEGIN_DATE_TIME,
365: ACTIVE_FLAG = NULL,
366: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 380: IEU_SH_SESSIONS where

376:
377: -- Should delete this block in future, use l_agent_resource_id straight way
378: select RESOURCE_ID into
379: l_act_resource_id from
380: IEU_SH_SESSIONS where
381: SESSION_ID = cur_act.session_id;
382:
383: select count(*), max(end_date_time)
384: into l_count_lc_segs, l_cal_end_date_time

Line 420: from ieu_sh_sessions

416:
417: if (l_end_date_time is null) then
418: select begin_date_time
419: into l_end_date_time
420: from ieu_sh_sessions
421: where session_id = cur_ses.session_id;
422: end if;
423:
424: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);

Line 426: update IEU_SH_SESSIONS set

422: end if;
423:
424: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);
425:
426: update IEU_SH_SESSIONS set
427: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
428: END_DATE_TIME = l_end_date_time,
429: ACTIVE_FLAG = NULL,
430: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 463: update IEU_SH_SESSIONS set

459: THEN
460:
461: -- New introduction 09/03/03 not updating session table with last_update_time anymore
462: /*
463: update IEU_SH_SESSIONS set
464: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
465: END_DATE_TIME = cur_user.last_update,
466: ACTIVE_FLAG = NULL,
467: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 482: IEU_SH_SESSIONS where

478:
479: -- Should delete this block in future, use cur_user.resource_id straight way
480: select RESOURCE_ID into
481: l_act_resource_id from
482: IEU_SH_SESSIONS where
483: SESSION_ID = cur_act.session_id;
484:
485: select count(*), max(end_date_time)
486: into l_count_lc_segs, l_cal_end_date_time

Line 522: from ieu_sh_sessions

518:
519: if (l_end_date_time is null) then
520: select begin_date_time
521: into l_end_date_time
522: from ieu_sh_sessions
523: where session_id = cur_ses.session_id;
524: end if;
525:
526: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);

Line 528: update IEU_SH_SESSIONS set

524: end if;
525:
526: -- dbms_output.put_line(' end_date_time : '||l_end_date_time);
527:
528: update IEU_SH_SESSIONS set
529: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
530: END_DATE_TIME = l_end_date_time,
531: ACTIVE_FLAG = NULL,
532: FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag

Line 559: IEU_SH_SESSIONS where

555: l_count_lc_segs := 0;
556:
557: select RESOURCE_ID into
558: l_act_resource_id from
559: IEU_SH_SESSIONS where
560: SESSION_ID = act_cur_rec_2.session_id;
561:
562: select count(*), max(end_date_time)
563: into l_count_lc_segs, l_cal_end_date_time