APPS.IGS_EN_WORKFLOW SQL Statements

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

Line: 43

  SELECT igs_en_status_mail_req_s.nextval seq_val
  FROM DUAL;

Line: 100

  SELECT igs_en_inst_action_s.nextval seq_val
  FROM DUAL;

Line: 159

  CURSOR cur_seq_val  IS  SELECT igs_en_stud_splperm_req_s.NEXTVAL seq_val   FROM DUAL;

Line: 227

          SELECT igs_en_intrmn_s.NEXTVAL
          FROM  dual;

Line: 234

        SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 240

     SELECT course_type
     FROM
     igs_en_stdnt_ps_att espa,
     igs_ps_ver psv
     WHERE
     psv.course_cd = espa.course_cd
     AND psv.version_number = espa.version_number
     AND espa.course_cd  = p_program_cd
     AND espa.person_id = p_personid ;

Line: 253

      SELECT intermission_type,description
      FROM igs_en_intm_types
      WHERE intermission_type =  p_intmtype;

Line: 329

     l_parameter_list_t.delete;

Line: 363

          SELECT igs_en_prgdsc_s.NEXTVAL
          FROM  dual;

Line: 370

        SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 376

       SELECT  FND_GLOBAL.USER_ID user_id
       FROM dual;

Line: 382

    SELECT s_discontinuation_reason_type
    FROM igs_en_dcnt_reasoncd
    WHERE discontinuation_reason_cd = p_discontincd;

Line: 451

     l_parameter_list_t.delete;

Line: 492

          SELECT igs_en_prgtrn_s.NEXTVAL
          FROM  dual;

Line: 499

        SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 505

       SELECT  FND_GLOBAL.USER_ID user_id
       FROM dual;

Line: 569

     l_parameter_list_t.delete;

Line: 610

          SELECT igs_en_profop_s.NEXTVAL
          FROM  dual;

Line: 617

        SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 623

       SELECT  FND_GLOBAL.USER_ID user_id
       FROM dual;

Line: 680

         WF_EVENT.RAISE (p_event_name => 'oracle.apps.igs.en.pgofop.update',
                         p_event_key  => 'PROFOPUPDATE'||ln_seq_val,
                         p_parameters => l_parameter_list_t);

Line: 690

     l_parameter_list_t.delete;

Line: 718

    SELECT 1
    FROM igs_ca_type
    WHERE closed_ind='N'
    AND s_cal_cat = 'ACADEMIC'
    AND cal_type = p_acad_cal_type;

Line: 725

    SELECT rec.person_id,rec.max_submission_dt, esp.course_cd, ret.ca_sequence_number, ret.sequence_number
           ,ret.logical_delete_dt,ret.thesis_result_cd , ret.title , rec.sequence_number can_sequence_number
    FROM igs_re_candidature rec,
         igs_en_stdnt_ps_att esp,
	 igs_re_thesis ret
    WHERE  max_submission_dt  IS NOT NULL
           AND max_submission_dt = (trunc(SYSDATE) - cp_offset_date )
	   AND esp.course_cd = rec.sca_course_cd
	   AND esp.person_id = rec.person_id
	   AND esp.cal_type = p_acad_cal_type
	   AND ret.person_id  = rec.person_id
	   AND ret.ca_sequence_number  = rec.sequence_number
	   ORDER BY rec.person_id;

Line: 740

    SELECT person_number,full_name
     FROM  igs_pe_person_base_v
     WHERE person_id = cp_person_id;

Line: 748

    SELECT  person_id , sequence_number
    FROM igs_re_sprvsr sup
    WHERE ca_person_id        = cp_person_id
    AND   ca_sequence_number  = cp_sequence_number
    AND   (end_dt IS NULL OR end_dt > SYSDATE );

Line: 796

					       l_cur_offset_days.logical_delete_dt,
					       l_cur_offset_days.thesis_result_cd ) = 'PENDING' ) THEN


          FOR l_cur_thesis_supervisor IN cur_thesis_supervisor(l_cur_offset_days.person_id ,l_cur_offset_days.can_sequence_number) LOOP

            IF (l_supervisor_gr IS NOT NULL) THEN
            l_supervisor_gr := l_supervisor_gr || ',' || l_cur_thesis_supervisor.person_id ;

Line: 891

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id;

Line: 899

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;

Line: 909

          SELECT full_name
	  FROM igs_pe_person_base_v
	  WHERE person_id = cp_person_id;

Line: 1035

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id
	   AND ( end_date IS NULL OR end_date > SYSDATE );

Line: 1041

           SELECT user_name
	   FROM   fnd_user
	   WHERE  user_id = cp_person_id
	   AND ( end_date IS NULL OR end_date > SYSDATE );

Line: 1052

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;

Line: 1062

          SELECT full_name
	  FROM igs_pe_person_base_v
	  WHERE person_id = cp_person_id;

Line: 1186

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id;

Line: 1193

           SELECT user_name
	   FROM   fnd_user
	   WHERE  user_id = cp_person_id
	   AND ( end_date IS NULL OR end_date > SYSDATE );

Line: 1203

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;

Line: 1213

          SELECT full_name
	  FROM igs_pe_person_base_v
	  WHERE person_id = cp_person_id;

Line: 1340

           SELECT user_name
	   FROM   fnd_user
	   WHERE  person_party_id = cp_person_id
	   AND ( end_date IS NULL OR end_date > SYSDATE );

Line: 1346

           SELECT user_name
	   FROM   fnd_user
	   WHERE  user_id = cp_person_id
	   AND ( end_date IS NULL OR end_date > SYSDATE );

Line: 1357

           SELECT count(1)
           FROM WF_LOCAL_USER_ROLES
           WHERE USER_NAME = cp_user_name
           AND ROLE_NAME = cp_role_name
           AND ROLE_ORIG_SYSTEM = 'WF_LOCAL_ROLES'
           AND ROLE_ORIG_SYSTEM_ID = 0;

Line: 1367

          SELECT full_name
	  FROM igs_pe_person_base_v
	  WHERE person_id = cp_person_id;

Line: 1373

    SELECT description
      FROM IGS_EN_DCNT_REASONCD
     WHERE DISCONTINUATION_REASON_CD = cp_discon_rsn_cd;

Line: 1379

    SELECT meaning
      FROM IGS_LOOKUP_VALUES
     WHERE lookup_code = cp_discon_rsn_type
       AND lookup_type = 'DISCONTINUATION_REASON_TYPE';

Line: 1563

    SELECT igs_en_student_placement_s.NEXTVAL
    FROM  dual;

Line: 1568

    SELECT  FND_PROFILE.VALUE('IGS_WF_ENABLE') value
	FROM dual;

Line: 1573

    SELECT party_number
    FROM hz_parties
    WHERE party_id = cp_person_id;

Line: 1627

   l_parameter_list_t.delete;

Line: 1659

  SELECT uoo.unit_cd  || '/' || uoo.unit_class AS UNIT_SECTION,
          uoo.unit_cd,
          uoo.version_number,
          uoo.cal_type,
          uoo.ci_sequence_number,
          uoo.location_cd,
          uoo.unit_class,
          ca.teach_description || ' (' || ca.teach_start_dt || ' - ' || ca.teach_end_dt || ')' teaching_prd,
          ca.load_description
   FROM   IGS_PS_UNIT_OFR_OPT_ALL uoo,
          IGS_CA_TEACH_TO_LOAD_V  ca
   WHERE  uoo.cal_type = ca.teach_cal_type
   AND    uoo.ci_sequence_number  = ca.teach_ci_sequence_number
   AND    uoo.uoo_id = cp_n_uoo_id
   AND    ca.load_cal_type = p_c_load_cal
   AND    ca.load_ci_sequence_number = p_n_load_seq_num;

Line: 1679

     SELECT usec.instructor_id
     FROM   igs_ps_usec_tch_resp usec
     WHERE  usec.uoo_id = cp_n_uoo_id
     AND    usec.lead_instructor_flag = 'Y';

Line: 1685

    SELECT person_number
    FROM   igs_pe_person_base_v
    WHERE  person_id = cp_n_person_id;

Line: 1690

    SELECT user_name
    FROM   fnd_user
    WHERE  person_party_id = cp_n_person_id;

Line: 1757

   SELECT igs_en_withdraw_perm_S.nextval INTO l_t_temp from dual;

Line: 1791

     SELECT igs_en_intm_rcond_s.nextval seq_val
     FROM DUAL;

Line: 1795

     SELECT party_number,party_name
     FROM   hz_parties
     WHERE  party_id = cp_person_id;