APPS.IEU_SH_CON_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

  l_update_time_format VARCHAR2(32);

Line: 16

       SELECT resource_id, count(resource_id) count, max(last_update_date) last_update
        FROM ieu_sh_sessions where active_flag = l_sh_active_flag
        and application_id = l_application_id
        GROUP BY resource_id HAVING count(resource_id) > 1;

Line: 29

        SELECT session_id, last_update_date
        FROM ieu_sh_sessions
        WHERE resource_id = l_resource_id
        AND active_flag = l_sh_active_flag
        AND application_id = l_application_id;

Line: 38

        SELECT session_id, resource_id
        FROM ieu_sh_sessions ses
        WHERE end_date_time is NULL
        AND   active_flag = l_sh_active_flag
        AND   application_id = l_application_id;

Line: 47

          SELECT activity_id, media_id, activity_type_code, session_id, BEGIN_DATE_TIME
          FROM ieu_sh_activities
  WHERE end_date_time is NULL
          AND   active_flag = l_sh_active_flag
          AND  session_id = l_ses_id;

Line: 56

          SELECT activity_id, session_id, media_id, BEGIN_DATE_TIME
          FROM ieu_sh_activities
  WHERE end_date_time is NULL
          AND   active_flag = l_sh_active_flag
          AND  session_id in (select session_id from ieu_sh_sessions
      where application_id = l_application_id
                              and   end_date_time is not null
                              and   active_flag is null)
                ;

Line: 71

  l_last_update_date DATE;

Line: 72

  l_last_update_time NUMBER;

Line: 97

      l_update_time_format := 'hh24';

Line: 130

          select max(trunc(last_update_date)), max(to_number(to_char(last_update_date, l_update_time_format)))
          into   l_last_update_date, l_last_update_time
          from ieu_sh_activities act
          where act.session_id = ses_cur_rec.session_id;

Line: 135

          IF ( ( (trunc(sysdate) > l_last_update_date)
                 and
                 (trunc(sysdate) - l_last_update_date  > 0.00000)
                 and
                 (trunc(sysdate) - l_last_update_date < 1.00000)
                 and
                 ( (23 - l_last_update_time + to_number(to_char(sysdate, l_update_time_format)) >= l_ses_timeout      )
               )
               or
               (trunc(sysdate) - l_last_update_date > 1.00000)
               or
                ((trunc(sysdate) = l_last_update_date )
                  and
                 ((to_number(to_char(sysdate, l_update_time_format)) - l_ses_timeout) >= l_last_update_time )
                )
              )
          )
          THEN

             for act_cur_rec_1 in l_act_cur1(ses_cur_rec.session_id)
             loop

  --              dbms_output.put_line('Activity Id : '||act_cur_rec_1.activity_id||' Session Id : '||ses_cur_rec.session_id);

Line: 159

                select count(*), max(end_date_time)
                  into l_count_lc_segs, l_cal_end_date_time
                  FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
                  media_id = act_cur_rec_1.media_id AND
                  resource_id = ses_cur_rec.resource_id AND
                  ACTIVE = l_media_not_active;

Line: 166

                select count(*)
                  into l_count_lc_segs_active
                  FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
                  media_id = act_cur_rec_1.media_id AND
                  resource_id = ses_cur_rec.resource_id AND
                  ACTIVE = l_media_active;

Line: 178

                  update IEU_SH_ACTIVITIES set
                  OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                  END_DATE_TIME = l_cal_end_date_time,
                  ACTIVE_FLAG = NULL,
                  STATE_CODE = l_end_state_code,
                  FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                  WHERE ACTIVITY_ID = act_cur_rec_1.activity_id;

Line: 206

                        select decode ( greatest (max(end_date_time), max(deliver_date_time), max(begin_date_time) ), null,
act_cur_rec_1.begin_date_time, greatest (max(end_date_time), max(deliver_date_time), max(begin_date_time) ) )
                        into l_cycle_end_date_time
		              from IEU_SH_ACTIVITIES where
		              parent_cycle_id = act_cur_rec_1.activity_id;

Line: 227

                    update IEU_SH_ACTIVITIES set
                    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                    END_DATE_TIME = l_cycle_end_date_time,
                    ACTIVE_FLAG = NULL,
                    STATE_CODE = l_end_state_code,
                    FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                    WHERE ACTIVITY_ID = act_cur_rec_1.activity_id;

Line: 247

                 select max(end_date_time)
                 into   l_end_date_time
                 from   ieu_sh_activities
                 where  session_id = ses_cur_rec.session_id;

Line: 257

                 select begin_date_time
                 into   l_end_date_time
                 from   ieu_sh_sessions
                 where  session_id = ses_cur_rec.session_id;

Line: 265

                update IEU_SH_SESSIONS set
                  OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                  END_DATE_TIME = l_end_date_time,
                  ACTIVE_FLAG = NULL,
                  FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                WHERE SESSION_ID = ses_cur_rec.session_id;

Line: 274

            ELSIF ( (l_last_update_date is null) and (l_last_update_time is null) )
            THEN

  --             dbms_output.put_line('Session id for sessions with no activities: '||ses_cur_rec.session_id);

Line: 279

               select trunc(last_update_date), to_number(to_char(last_update_date, l_update_time_format))
               into   l_last_update_date, l_last_update_time
               from   ieu_sh_sessions ses
               where  ses.session_id = ses_cur_rec.session_id;

Line: 284

          IF ( ( (trunc(sysdate) > l_last_update_date)
                 and
                 (trunc(sysdate) - l_last_update_date  > 0.00000)
                 and
                 (trunc(sysdate) - l_last_update_date < 1.00000)
                    and
                 ( (23 - l_last_update_time + to_number(to_char(sysdate, l_update_time_format))
  >= l_ses_timeout      )
                 )
                  or
                  ( trunc(sysdate) - l_last_update_date > 1.00000 )
                  or
                    ((trunc(sysdate) = l_last_update_date )
                    and
                    ((to_number(to_char(sysdate, l_update_time_format)) - l_ses_timeout) >= l_last_update_time )
                   )
                 )
               )
               THEN

                  update IEU_SH_SESSIONS set
                    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                    END_DATE_TIME = BEGIN_DATE_TIME,
                    ACTIVE_FLAG = NULL,
                    FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                  WHERE SESSION_ID = ses_cur_rec.session_id;

Line: 337

        select resource_id into l_agent_resource_id
        FROM JTF_RS_RESOURCE_EXTNS
        where user_name=l_upper_agent;

Line: 362

            update IEU_SH_SESSIONS set
                    OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                    END_DATE_TIME = BEGIN_DATE_TIME,
                    ACTIVE_FLAG = NULL,
                    FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                  WHERE SESSION_ID = cur_ses.session_id;

Line: 378

              select RESOURCE_ID into
              l_act_resource_id from
              IEU_SH_SESSIONS where
              SESSION_ID = cur_act.session_id;

Line: 383

              select count(*), max(end_date_time)
                  into l_count_lc_segs, l_cal_end_date_time
                  FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
                  media_id = cur_act.media_id AND
                  resource_id = l_act_resource_id AND
                  ACTIVE = l_media_not_active;

Line: 397

              update IEU_SH_ACTIVITIES set
                OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                END_DATE_TIME =  l_act_end_date,
                ACTIVE_FLAG = NULL,
                STATE_CODE = l_end_state_code,
                FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                WHERE ACTIVITY_ID = cur_act.activity_id;

Line: 408

             select max(end_date_time)
             into   l_end_date_time
             from   ieu_sh_activities
             where  session_id = cur_ses.session_id;

Line: 418

             select begin_date_time
             into   l_end_date_time
             from   ieu_sh_sessions
             where  session_id = cur_ses.session_id;

Line: 426

            update IEU_SH_SESSIONS set
              OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
              END_DATE_TIME = l_end_date_time,
              ACTIVE_FLAG = NULL,
              FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
            WHERE SESSION_ID = cur_ses.session_id;

Line: 458

            IF (cur_ses.last_update_date < cur_user.last_update)
            THEN

              -- New introduction 09/03/03 not updating session table with last_update_time anymore
              /*
              update IEU_SH_SESSIONS set
                OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                END_DATE_TIME = cur_user.last_update,
                ACTIVE_FLAG = NULL,
                FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
              WHERE SESSION_ID = cur_ses.session_id;

Line: 480

                select RESOURCE_ID into
                l_act_resource_id from
                IEU_SH_SESSIONS where
                SESSION_ID = cur_act.session_id;

Line: 485

                select count(*), max(end_date_time)
                    into l_count_lc_segs, l_cal_end_date_time
                    FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
                    media_id = cur_act.media_id AND
                    resource_id = l_act_resource_id AND
                    ACTIVE = l_media_not_active;

Line: 499

                update IEU_SH_ACTIVITIES set
                  OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                  END_DATE_TIME =  l_act_end_date,
                  ACTIVE_FLAG = NULL,
                  STATE_CODE = l_end_state_code,
                  FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
                  WHERE ACTIVITY_ID = cur_act.activity_id;

Line: 510

               select max(end_date_time)
               into   l_end_date_time
               from   ieu_sh_activities
               where  session_id = cur_ses.session_id;

Line: 520

               select begin_date_time
               into   l_end_date_time
               from   ieu_sh_sessions
               where  session_id = cur_ses.session_id;

Line: 528

              update IEU_SH_SESSIONS set
                OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
                END_DATE_TIME = l_end_date_time,
                ACTIVE_FLAG = NULL,
                FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
              WHERE SESSION_ID = cur_ses.session_id;

Line: 557

          select RESOURCE_ID into
          l_act_resource_id from
          IEU_SH_SESSIONS where
          SESSION_ID = act_cur_rec_2.session_id;

Line: 562

          select count(*), max(end_date_time)
              into l_count_lc_segs, l_cal_end_date_time
              FROM JTF_IH_MEDIA_ITEM_LC_SEGS WHERE
              media_id = act_cur_rec_2.media_id AND
              resource_id = l_act_resource_id AND
              ACTIVE = l_media_not_active;

Line: 576

          update IEU_SH_ACTIVITIES set
            OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
            END_DATE_TIME =  l_act_end_date,
            ACTIVE_FLAG = NULL,
            STATE_CODE = l_end_state_code,
            FORCE_CLOSED_BY_UWQ_FLAG = l_force_close_flag
          WHERE ACTIVITY_ID = act_cur_rec_2.activity_id;

Line: 610

          SELECT to_number(attribute2) APPL_ID
          FROM FND_LOOKUP_VALUES
          WHERE LOOKUP_TYPE = l_app_names and
          LOOKUP_CODE = l_app_uwq;

Line: 617

          SELECT to_number(attribute2) APPL_ID
          FROM FND_LOOKUP_VALUES
          WHERE LOOKUP_TYPE = l_app_names and
          LOOKUP_CODE = l_app_emc;

Line: 624

          SELECT to_number(attribute2) APPL_ID
          FROM FND_LOOKUP_VALUES
          WHERE LOOKUP_TYPE = l_app_names;