APPS.IGF_GR_MRR_LOAD_DATA SQL Statements

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

Line: 107

PROCEDURE insert_in_mrr_table ( p_mrr_rec  IN  igf_gr_mrr%ROWTYPE )
AS
  /***************************************************************
  Created By            :       avenkatr
  Date Created By       :       2000/12/19
  Purpose               :       To Load data into IGF_GR_MRR table

  Known Limitations,Enhancements or Remarks
  Change History        :
  Who                   When            What
  ***************************************************************/
  lv_rowid VARCHAR2(25);

Line: 122

    /* Call the table handler of the table igf_gr_mrr to insert data */
    igf_gr_mrr_pkg.insert_row (
        x_rowid             => lv_rowid,
        x_mrr_id            => lv_mrr_id,
        x_record_type       => p_mrr_rec.record_type,
        x_req_inst_pell_id  => p_mrr_rec.req_inst_pell_id,
        x_mrr_code1         => p_mrr_rec.mrr_code1,
        x_mrr_code2         => p_mrr_rec.mrr_code2,
        x_mr_stud_id        => p_mrr_rec.mr_stud_id,
        x_mr_inst_pell_id   => p_mrr_rec.mr_inst_pell_id,
        x_stud_orig_ssn     => p_mrr_rec.stud_orig_ssn,
        x_orig_name_cd      => p_mrr_rec.orig_name_cd,
        x_inst_pell_id      => p_mrr_rec.inst_pell_id,
        x_inst_name         => p_mrr_rec.inst_name,
        x_inst_addr1        => p_mrr_rec.inst_addr1,
        x_inst_addr2        => p_mrr_rec.inst_addr2,
        x_inst_city         => p_mrr_rec.inst_city,
        x_inst_state        => p_mrr_rec.inst_state,
        x_zip_code          => p_mrr_rec.zip_code,
        x_faa_name          => p_mrr_rec.faa_name,
        x_faa_tel           => p_mrr_rec.faa_tel,
        x_faa_fax           => p_mrr_rec.faa_fax,
        x_faa_internet_addr => p_mrr_rec.faa_internet_addr,
        x_schd_pell_grant   => p_mrr_rec.schd_pell_grant,
        x_orig_awd_amt      => p_mrr_rec.orig_awd_amt,
        x_tran_num          => p_mrr_rec.tran_num,
        x_efc               => p_mrr_rec.efc ,
        x_enrl_dt           => p_mrr_rec.enrl_dt,
        x_orig_creation_dt  => p_mrr_rec.orig_creation_dt,
        x_disb_accepted_amt => p_mrr_rec.disb_accepted_amt,
        x_last_active_dt    => p_mrr_rec.last_active_dt,
        x_next_est_disb_dt  => p_mrr_rec.next_est_disb_dt,
        x_eligibility_used  => p_mrr_rec.eligibility_used,
        x_ed_use_flags      => p_mrr_rec.ed_use_flags,
        x_stud_last_name    => p_mrr_rec.stud_last_name,
        x_stud_first_name   => p_mrr_rec.stud_first_name,
        x_stud_middle_name  => p_mrr_rec.stud_middle_name,
        x_stud_dob          => p_mrr_rec.stud_dob,
        x_current_ssn       => p_mrr_rec.current_ssn,
        x_mode              => 'R'
      ) ;

Line: 167

      fnd_message.set_token('NAME','igf_gr_mrr_load_data.insert_in_mrr_table');

Line: 170

END insert_in_mrr_table;

Line: 222

       SELECT
       record_data
       FROM
       igf_gr_load_file_t
       WHERE
       gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
       AND
       file_type = 'MRR'
       ORDER BY
       gldr_id;

Line: 256

               insert_in_mrr_table (lv_mrr_row );