APPS.IGS_UC_UPD_PENDING_TRANS_PKG SQL Statements

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

Line: 28

      SELECT max(current_cycle) current_cycle, max(configured_cycle) configured_cycle
      FROM igs_uc_defaults ;

Line: 34

      SELECT TO_NUMBER(LPAD(entry_year,4,200))
      FROM igs_uc_ucas_control
      WHERE system_code = 'U'
      AND ucas_cycle = c_cycle_rec.configured_cycle;

Line: 40

      SELECT TRANS.ROWID,
             TRANS.UC_TRAN_ID,
             TRANS.TRANSACTION_ID,
             TRANS.DATETIMESTAMP,
             TRANS.UPDATER,
             TRANS.ERROR_CODE,
             TRANS.TRANSACTION_TYPE,
             TRANS.APP_NO,
             TRANS.CHOICE_NO,
             TRANS.DECISION,
             TRANS.PROGRAM_CODE,
             TRANS.CAMPUS,
             TRANS.ENTRY_MONTH,
             TRANS.ENTRY_YEAR,
             TRANS.ENTRY_POINT,
             TRANS.SOC,
             TRANS.COMMENTS_IN_OFFER,
             TRANS.RETURN1,
             TRANS.RETURN2,
             TRANS.HOLD_FLAG,
             TRANS.SENT_TO_UCAS,
             TRANS.TEST_COND_CAT,
             TRANS.TEST_COND_NAME,
             TRANS.INST_REFERENCE ,
             TRANS.AUTO_GENERATED_FLAG,
             TRANS.SYSTEM_CODE,
             TRANS.UCAS_CYCLE,
             TRANS.MODULAR,
             TRANS.PART_TIME
         FROM
             IGS_UC_TRANSACTIONS TRANS,
             IGS_UC_CYC_DEFAULTS DFLTS
         WHERE
             TRANS.ERROR_CODE = -1
             AND TRANS.SENT_TO_UCAS = 'Y'
             AND TRANS.UCAS_CYCLE = cp_conf_cycle
             AND TRANS.SYSTEM_CODE = DFLTS.SYSTEM_CODE
             AND TRANS.UCAS_CYCLE  = DFLTS.UCAS_CYCLE
             AND DFLTS.UCAS_INTERFACE = 'H'
         ORDER BY TRANS.CREATION_DATE;

Line: 82

     SELECT COUNT(*)
     FROM
         IGS_UC_TRANSACTIONS TRANS,
         IGS_UC_CYC_DEFAULTS DFLTS
     WHERE
         TRANS.ERROR_CODE = -1
         AND TRANS.SENT_TO_UCAS = 'Y'
         AND TRANS.UCAS_CYCLE = cp_conf_cycle
         AND TRANS.SYSTEM_CODE = DFLTS.SYSTEM_CODE
         AND TRANS.UCAS_CYCLE  = DFLTS.UCAS_CYCLE
         AND DFLTS.UCAS_INTERFACE = 'H';

Line: 96

     SELECT APPNO,
            CHOICENO,
            TRANSACTIONID,
            ERRORCODE,
            TIMESTAMP,
            UPDATER,
            RETURN1,
            RETURN2,
            SOC
     FROM
            IGS_UC_U_TRANIN_2004
     WHERE
            TRANSACTIONID = cp_trans_id
            AND APPNO = cp_app_no;

Line: 115

      SELECT TO_NUMBER(APP_NO || CHECK_DIGIT)
      FROM IGS_UC_APPLICANTS
      WHERE APP_NO = CP_APPNO;

Line: 216

              igs_uc_transactions_pkg.update_row (
                    x_mode                              => 'R',
                    x_rowid                             => c_pending_trans_rec.ROWID,
                    x_uc_tran_id                        => c_pending_trans_rec.uc_tran_id,
                    x_transaction_id                    => c_pending_trans_rec.transaction_id,
                    x_datetimestamp                     => c_tranin_info_rec.timestamp,
                    x_updater                           => c_tranin_info_rec.updater,
                    x_error_code                        => c_tranin_info_rec.errorcode,
                    x_transaction_type                  => c_pending_trans_rec.transaction_type,
                    x_app_no                            => c_pending_trans_rec.app_no,
                    x_choice_no                         => c_pending_trans_rec.choice_no,
                    x_decision                          => c_pending_trans_rec.decision,
                    x_program_code                      => c_pending_trans_rec.program_code,
                    x_campus                            => c_pending_trans_rec.campus,
                    x_entry_month                       => c_pending_trans_rec.entry_month,
                    x_entry_year                        => c_pending_trans_rec.entry_year,
                    x_entry_point                       => c_pending_trans_rec.entry_point,
                    x_soc                               => l_soc,
                    x_comments_in_offer                 => c_pending_trans_rec.comments_in_offer,
                    x_return1                           => c_tranin_info_rec.return1,
                    x_return2                           => c_tranin_info_rec.return2,
                    x_hold_flag                         => c_pending_trans_rec.hold_flag,
                    x_sent_to_ucas                      => c_pending_trans_rec.sent_to_ucas,
                    x_test_cond_cat                     => c_pending_trans_rec.test_cond_cat,
                    x_test_cond_name                    => c_pending_trans_rec.test_cond_name,
                    x_inst_reference                    => c_pending_trans_rec.inst_reference ,
                    x_auto_generated_flag               => c_pending_trans_rec.auto_generated_flag,
                    x_system_code                       => c_pending_trans_rec.system_code,
                    x_ucas_cycle                        => c_pending_trans_rec.ucas_cycle,
                    x_modular                           => c_pending_trans_rec.modular,
                    x_part_time                         => c_pending_trans_rec.part_time);