APPS.IGS_SESSION_VALIDITY SQL Statements

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

Line: 62

   SELECT
    first_connect,
    last_connect,
    limit_time,
    disabled_flag
   FROM
    icx_sessions
   WHERE
    session_id = p_session_id;

Line: 107

  ||  bdeviset      08-jn-2006      Modified such that in all the cases planning sheet error records/swap records are deleted.
                                    For student irrespective of the profile cart units are also purged but for admin it is
                                    done based on the profile. bug# 5306874
  */

 PRAGMA AUTONOMOUS_TRANSACTION;

Line: 114

  Cursor to select all the records which are added through the self service page
  and are still in the enrollment worksheet
  */

  CURSOR all_sessions_cur IS
   SELECT
    DISTINCT session_id
   FROM
    igs_en_su_attempt_all
   WHERE
    cart = 'S';

Line: 127

  Cursor to select the enrollment worksheet records which are added in a session, not valid
  anymore
  */

  CURSOR unit_attempt_del_cur (c_session_id NUMBER) IS
   SELECT
    rowid row_id, person_id
   FROM
    igs_en_su_attempt_all
   WHERE
    session_id = c_session_id AND
    cart = 'S'
  ORDER BY sup_unit_cd ASC;

Line: 144

  Cursor to select the enrollment worksheet records which are added in a session by a student, not valid
  anymore
  */

  CURSOR std_unit_attempt_del_cur (c_session_id NUMBER) IS
   SELECT
    rowid row_id, person_id
   FROM
    igs_en_su_attempt_all
   WHERE
    session_id = c_session_id AND
    cart = 'S' AND
    ss_source_ind <> 'A'
  ORDER BY sup_unit_cd ASC;

Line: 160

  Cursor to select all the records which are added through the self service page
   and are still in the enrollment worksheet except for the records added by admin
  */
  CURSOR all_stud_sessions_cur IS
   SELECT
    DISTINCT session_id
   FROM
    igs_en_su_attempt_all
   WHERE cart = 'S'
   AND ss_source_ind <> 'A';

Line: 172

  Cursor to select all the distinct session ids of cart, created from planned sheet and swap page.
  */
  CURSOR c_stud_cart_ses IS
    SELECT DISTINCT session_id
    FROM   igs_en_su_attempt
    WHERE  cart = 'S'
    AND    ss_source_ind IN ('P','S');

Line: 181

  Cursor to select details of the cart, created from planned sheet and swap page.
  */
  CURSOR c_stud_cart_row (p_session_id igs_en_su_attempt.session_id%TYPE) IS
    SELECT a.rowid, a.person_id,a.course_cd, a.uoo_id, a.ss_source_ind
    FROM   igs_en_su_attempt a
    WHERE  a.cart = 'S'
    AND    a.ss_source_ind IN ('P','S')
    AND    a.session_id  = p_session_id
    ORDER BY a.sup_unit_cd asc;

Line: 192

  Cursor to select rowid of error carts for deleting.
  */
  CURSOR c_plan_error( p_session_id igs_en_plan_units.session_id%TYPE,
                       p_person_id  igs_en_plan_units.person_id%TYPE,
                       p_course_cd  igs_en_plan_units.course_cd%TYPE,
                       p_uoo_id     igs_en_plan_units.uoo_id%TYPE ) IS
    SELECT ROWID
    FROM   igs_en_plan_units
    WHERE  person_id       = p_person_id
    AND    course_cd       = p_course_cd
    AND    uoo_id          = p_uoo_id
    AND    cart_error_flag = 'Y'
    AND    session_id      = p_session_id;

Line: 207

  Cursor to select value of term_cal_type and term_ci_sequence_number.
  */
  CURSOR c_cal_type( p_person_id  igs_en_plan_units.person_id%TYPE,
                     p_course_cd  igs_en_plan_units.course_cd%TYPE,
                     p_uoo_id     igs_en_plan_units.uoo_id%TYPE ) IS
    SELECT term_cal_type, term_ci_sequence_number
    FROM   igs_en_plan_units
    WHERE  person_id       = p_person_id
    AND    course_cd       = p_course_cd
    AND    uoo_id          = p_uoo_id;

Line: 219

    curosor to select warnings of invalid sessions
    */
    CURSOR c_stud_warn_row(p_session_id IGS_EN_STD_WARNINGS.SESSION_ID%type) is
    SELECT rowid
    from IGS_EN_STD_WARNINGS
    where SESSION_ID = p_session_id;

Line: 229

    SELECT DISTINCT session_id
    FROM   igs_en_plan_units
    WHERE  cart_error_flag= 'Y';

Line: 234

    SELECT ROWID
    FROM igs_en_plan_units
    WHERE session_id = p_session_id
    AND   cart_error_flag = 'Y';

Line: 256

        IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid =>c_stud_warn_rec.rowid );

Line: 276

                igs_en_su_attempt_pkg.delete_row (c_stud_cart_rec.rowid);

Line: 288

                        UPDATE  igs_en_spa_terms spa SET spa.plan_sht_status = 'PLAN'
                        WHERE   spa.plan_sht_status                      = 'SUB_PLAN'
                         AND     spa.person_id                          = c_stud_cart_rec.person_id
                         AND     spa.program_cd                         = c_stud_cart_rec.course_cd
                         AND     spa.term_cal_type                      = c_cal_type_rec.term_cal_type
                         AND     spa.term_sequence_number               = c_cal_type_rec.term_ci_sequence_number
	                     AND    EXISTS ( SELECT pl.uoo_id FROM igs_en_plan_units pl WHERE pl.person_id=spa.person_id AND pl.course_cd = spa.program_cd AND
				        pl.term_cal_type = spa.term_cal_type  AND pl.term_ci_sequence_number = spa.term_sequence_number AND  pl.uoo_id =c_stud_cart_rec.uoo_id);

Line: 307

                        igs_en_plan_units_pkg.delete_row(c_plan_error_rec.rowid) ;

Line: 343

                igs_en_plan_units_pkg.delete_row(c_get_all_plan_error_units_rec.rowid);

Line: 360

                IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid =>c_stud_warn_rec.rowid );

Line: 389

                  IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid =>c_stud_warn_rec.rowid );

Line: 402

                  igs_en_su_attempt_pkg.delete_row ( unit_attempt_del_rec.row_id);

Line: 427

                  IGS_EN_STD_WARNINGS_PKG.delete_row(x_rowid =>c_stud_warn_rec.rowid );

Line: 440

                  igs_en_su_attempt_pkg.delete_row ( std_unit_attempt_del_rec.row_id);