APPS.IGS_PE_GEN_002 SQL Statements

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

Line: 52

     SAVEPOINT hold_insert;

Line: 56

	igs_pe_pers_encumb_pkg.insert_row
        (
              x_mode                     =>   'R'                     ,
     	      x_rowid                    =>   l_rowid                 ,
	      x_person_id                =>   p_person_id   ,
	      x_encumbrance_type         =>   p_encumbrance_type             ,
	      x_start_dt                 =>   p_start_dt            ,
	      x_expiry_dt                =>   p_end_dt                    ,
	      x_authorising_person_id    =>   p_authorising_person_id,  -- let the tbh handle this,
	      x_comments                 =>   p_comments                    ,
	      x_spo_course_cd            =>   p_spo_course_cd                    ,
              x_spo_sequence_number      =>   p_spo_sequence_number                    ,
              x_cal_type                 =>   p_cal_type              ,
              x_sequence_number          =>   p_sequence_number ,
	      x_auth_resp_id             =>   p_auth_resp_id,
	      x_external_reference       =>   p_external_reference
        ) ;

Line: 76

	ROLLBACK to hold_insert;

Line: 151

          SELECT
               IGS_PE_PE003_WF_S.nextval
          FROM
               DUAL;

Line: 211

          SELECT
	       'X'
	  FROM
	       fnd_user
          WHERE
	       user_name = cp_user AND
               email_address IS NOT NULL AND
	       person_party_id IS NOT NULL;

Line: 222

          SELECT
	       person_id,NVL(full_name,person_number) full_name
	  FROM
	       igs_pe_person_base_v
          WHERE
	       person_number = cp_person_number;

Line: 231

          SELECT
	       'X'
	  FROM
	       igs_fi_encmb_type
          WHERE
	       encumbrance_type = cp_encumbrance_type AND
	       s_encumbrance_cat = 'ADMIN';

Line: 244

          SELECT
	       expiry_dt
	  FROM
	       IGS_PE_PERS_ENCUMB
          WHERE
               person_id = cp_person_id AND
	       encumbrance_type = cp_encumbrance_type AND
	       start_dt = cp_start_dt;

Line: 259

          SELECT
	       'X'
	  FROM
	       igs_pe_pers_encumb
          WHERE
               person_id = cp_person_id AND
	       encumbrance_type = cp_encumbrance_type AND
	       start_dt = cp_start_dt AND
	       external_reference = cp_external_reference;

Line: 271

    SELECT 'X'
    FROM igs_fi_enc_dflt_eft
    WHERE encumbrance_type = cp_hold_type AND
          s_encmb_effect_type = 'SUS_COURSE';

Line: 318

 SELECT message_text
 FROM fnd_new_messages
 WHERE message_name = cp_message_name AND
       application_id=8405 AND
       LANGUAGE_CODE = USERENV('LANG');

Line: 522

	            SELECT     igs_ge_date.igsdate(igs_ge_date.igschar(cp_date))
                    FROM       DUAL;

Line: 566

	     -- in the TBH this error is trapped only when inserting and exp_dt null, but explicitly trapped in the form
	     -- hence trapping it here...SSAWHNEY

	     IF IGS_EN_VAL_PEN.enrp_val_pen_open (
                     l_student_rec.person_id,
                     l_hold_type,
                     igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
                     v_message_name) = FALSE THEN

                     IF v_message_name IS NOT NULL then


                        l_error :='IGS_EN_ENCMBR_HAS_SPECIFIED';

Line: 643

	     -- in the TBH this error is trapped only when inserting and exp_dt null, but explicitly trapped in the form
	     -- hence trapping it here...SSAWHNEY

	     IF IGS_EN_VAL_PEN.enrp_val_pen_open (
                     l_student_rec.person_id,
                     l_hold_type,
                     igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
                     v_message_name) = FALSE THEN

                     IF v_message_name IS NOT NULL then


                        l_error :='IGS_EN_ENCMBR_HAS_SPECIFIED';

Line: 838

  SELECT STATUS FROM
  FND_PRODUCT_INSTALLATIONS
  WHERE APPLICATION_ID = 800;

Line: 844

  SELECT 'Y' FROM PER_ALL_ASSIGNMENTS_F WHERE assignment_id > 1 AND ROWNUM = 1;

Line: 881

  SELECT emplmnt_category_code FROM
  IGS_PE_HR_EMP_CAT_V
  WHERE person_id = cp_person_id;

Line: 886

  SELECT emplmnt_category_code FROM
  IGS_PE_TYP_EMP_CAT_V
  WHERE person_id = cp_person_id;