APPS.IGS_AS_TRNCMT_LGCY_PUB SQL Statements

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

Line: 87

           SELECT 'x'
           FROM   igs_lookup_values
           WHERE  lookup_type = 'IGS_AS_STDNT_TRNS_CMNT_TYPE'
           AND    lookup_code = p_lookup_code
           AND    NVL(enabled_flag, 'N') = 'Y';

Line: 278

        SELECT uoo_id
        FROM   igs_ps_unit_ofr_opt_all
        WHERE  unit_cd            = p_unit_cd
           AND version_number     = p_version_number
           AND cal_type           = p_cal_type
           AND ci_sequence_number = p_ci_sequence_number
           AND location_cd        = p_location_cd
           AND unit_class         = p_unit_class;

Line: 381

        SELECT 'X'
        FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva
       WHERE spa.course_cd      = pva.course_cd
         AND spa.version_number = pva.version_number
         AND spa.person_id      = cp_person_id
         AND pva.course_type    = cp_course_type;

Line: 394

        SELECT 'X'
          FROM igs_pr_acad_load_v
         WHERE person_id = cp_person_id
           AND course_type = cp_course_type
           AND load_cal_type = cp_load_cal_type
           AND load_ci_sequence_number = cp_load_ci_sequence_number;

Line: 406

      SELECT   'X'
      FROM     IGS_AS_SU_SETATMPT
      WHERE    person_id   = cp_person_id
      AND      course_cd   = cp_course_cd
      AND      unit_set_cd = cp_unit_set_cd;

Line: 417

      SELECT   'X'
      FROM     igs_he_en_susa
      WHERE    person_id   = cp_person_id
      AND      course_cd   = cp_course_cd
      AND      unit_set_cd = cp_unit_set_cd;

Line: 491

               FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.COUNT_MSG);

Line: 644

    SELECT   igs_as_stu_trns_cmts_s.NEXTVAL
    INTO     l_comment_id
    FROM     dual
    WHERE    ROWNUM = 1;

Line: 649

    INSERT INTO IGS_AS_STU_TRN_CMTS
                                 (
                                    COMMENT_ID               ,
                                    COMMENT_TYPE_CODE        ,
                                    COMMENT_TXT              ,
                                    PERSON_ID                ,
                                    COURSE_CD                ,
                                    COURSE_TYPE              ,
                                    AWARD_CD                 ,
                                    LOAD_CAL_TYPE            ,
                                    LOAD_CI_SEQUENCE_NUMBER  ,
                                    UNIT_SET_CD              ,
                                    US_VERSION_NUMBER        ,
                                    UOO_ID                   ,
                                    CREATED_BY               ,
                                    CREATION_DATE            ,
                                    LAST_UPDATED_BY          ,
                                    LAST_UPDATE_DATE         ,
                                    LAST_UPDATE_LOGIN
                                  )
                                  VALUES (
                                         l_comment_id                          ,
                                   UPPER(p_lgcy_trncmt_rec.comment_type_code)  ,
                                         p_lgcy_trncmt_rec.comment_txt         ,
                                         l_person_id                           ,
                                   UPPER(p_lgcy_trncmt_rec.program_cd)         ,
                                   UPPER(p_lgcy_trncmt_rec.program_type)       ,
                                   UPPER(p_lgcy_trncmt_rec.award_cd)           ,
                                   UPPER(l_load_cal_type)                      ,
                                         l_load_sequence_number                ,
                                   UPPER(p_lgcy_trncmt_rec.unit_set_cd)        ,
                                         p_lgcy_trncmt_rec.us_version_number   ,
                                         l_uoo_id                              ,
                                     NVL(FND_GLOBAL.USER_ID, -1)               ,
                                         SYSDATE                               ,
                                     NVL(FND_GLOBAL.USER_ID,-1)                ,
                                         SYSDATE                               ,
                                     NVL(FND_GLOBAL.LOGIN_ID,-1)
                                 );