APPS.IGS_AS_SUARC_LGCY_PUB SQL Statements

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

Line: 99

                FND_MSG_PUB.DELETE_MSG(l_msg_count);

Line: 115

                FND_MSG_PUB.DELETE_MSG(l_msg_count);

Line: 131

                FND_MSG_PUB.DELETE_MSG(l_msg_count);

Line: 147

                FND_MSG_PUB.DELETE_MSG(l_msg_count);

Line: 163

                FND_MSG_PUB.DELETE_MSG(l_msg_count);

Line: 206

    SELECT refcd.reference_code_id
      FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
     WHERE refcd.reference_cd_type = refcdt.reference_cd_type
       AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
       AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;

Line: 225

                 X_DELETED_DATE => TO_DATE(null)
         ) THEN
                FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_AS_UK_CHK_REF_CD' );

Line: 294

    l_insert_flag           BOOLEAN := TRUE;

Line: 317

    SELECT unit_attempt_status
      FROM igs_en_su_attempt_all
     where person_id = l_person_id
       AND course_cd =p_suarc_dtls_rec.program_cd
       AND uoo_id = l_uoo_id ;

Line: 325

    SELECT 'X'
      FROM igs_ge_ref_cd refcd
     WHERE refcd.reference_cd = p_suarc_dtls_rec.reference_cd
       AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;

Line: 332

    SELECT 'X'
      FROM igs_ge_ref_cd refcd, igs_ge_ref_cd_type refcdt
     WHERE refcd.reference_cd_type = refcdt.reference_cd_type
       AND refcd.reference_cd = p_suarc_dtls_rec.reference_cd
       AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type
       AND refcdt.UNIT_FLAG='Y'
       AND refcdt.UNIT_SECTION_FLAG='Y'
       AND refcdt.UNIT_SECTION_OCCURRENCE_FLAG='Y';

Line: 343

    SELECT refcd.reference_code_id
      FROM igs_ge_ref_cd refcd
     WHERE refcd.reference_cd = p_suarc_dtls_rec.reference_cd
       AND refcd.reference_cd_type = p_suarc_dtls_rec.reference_cd_type;

Line: 461

  SELECT IGS_AS_SUA_REF_CDS_S.nextval INTO l_suar_id from dual;

Line: 464

          INSERT INTO IGS_AS_SUA_REF_CDS (
             SUAR_ID,
             person_id,
             course_cd,
             uoo_id,
             REFERENCE_CODE_ID,
             REFERENCE_CD_TYPE,
             REFERENCE_CD,
             APPLIED_COURSE_CD,
	          CREATED_BY,
              CREATION_DATE,
             last_update_date,
             last_updated_by,
             last_update_login
               )
             VALUES (
             l_suar_id,
             l_person_id,
             p_suarc_dtls_rec.program_cd,
             l_uoo_id,
	           l_ref_cd_id,
             p_suarc_dtls_rec.reference_cd_type,
             p_suarc_dtls_rec.reference_cd,
             p_suarc_dtls_rec.applied_program_cd,
             nvl(fnd_global.user_id,-1),
             SYSDATE,
             SYSDATE,
             NVL(fnd_global.user_id,-1),
             NVL(fnd_global.login_id,-1));