APPS.IGF_GR_ESS_ESD_DATA SQL Statements

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

Line: 196

PROCEDURE insert_in_ess_table ( p_ess_rec  IN  igf_gr_elec_stat_sum%ROWTYPE )
AS
  /***************************************************************
  Created By		:	avenkatr
  Date Created By	:	2000/12/19
  Purpose		:	To Load data into igf_gr_elec_stat_sum table

  Known Limitations,Enhancements or Remarks
  Change History	:
  Who			When		What
  ***************************************************************/

  lv_rowid VARCHAR2(25);

Line: 212

    /* Call the table handler of the table igf_gr_elec_stat_sum to insert data */
  	     igf_gr_elec_stat_sum_pkg.insert_row (
         		 x_mode                         => 'R',
	        	 x_rowid                        => lv_rowid,
		         x_acct_schedule_number         => p_ess_rec.acct_schedule_number,
         		 x_acct_schedule_date           => p_ess_rec.acct_schedule_date,
        		 x_prev_obligation_amt          => p_ess_rec.prev_obligation_amt,
        		 x_obligation_adj_amt           => p_ess_rec.obligation_adj_amt,
        		 x_curr_obligation_amt          => p_ess_rec.curr_obligation_amt,
        		 x_prev_obligation_pymt_amt     => p_ess_rec.prev_obligation_pymt_amt,
        		 x_obligation_pymt_adj_amt      => p_ess_rec.obligation_pymt_adj_amt,
        		 x_curr_obligation_pymt_amt     => p_ess_rec.curr_obligation_pymt_amt,
        		 x_ytd_total_recp               => p_ess_rec.ytd_total_recp,
        		 x_ytd_accepted_disb_amt        => p_ess_rec.ytd_accepted_disb_amt ,
        		 x_ytd_posted_disb_amt          => p_ess_rec.ytd_posted_disb_amt ,
        		 x_ytd_admin_cost_allowance     => p_ess_rec.ytd_admin_cost_allowance ,
        		 x_caps_drwn_dn_pymts           => p_ess_rec.caps_drwn_dn_pymts,
        		 x_gaps_last_date               => p_ess_rec.gaps_last_date,
        		 x_last_pymt_number             => p_ess_rec.last_pymt_number,
        		 x_ess_id                       => lv_ess_id,
        		 x_rep_pell_id                  => p_ess_rec.rep_pell_id,
        		 x_duns_id                      => p_ess_rec.duns_id,
         		 x_gaps_award_num               => p_ess_rec.gaps_award_num  );

Line: 239

      fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_ess_table');

Line: 243

END insert_in_ess_table;

Line: 246

PROCEDURE insert_in_esd_table ( p_esd_rec  IN  igf_gr_elec_stat_det%ROWTYPE )
AS
  /***************************************************************
  Created By		:	avenkatr
  Date Created By	:	2000/12/19
  Purpose		:	To Load data into igf_gr_elec_stat_sum table

  Known Limitations,Enhancements or Remarks
  Change History	:
  Who			When		What
  ***************************************************************/

  lv_rowid VARCHAR2(25);

Line: 263

     igf_gr_elec_stat_det_pkg.insert_row (
            x_mode                       => 'R',
            x_rowid                      => lv_rowid,
            x_esd_id                     => lv_esd_id,
            x_rep_pell_id                => p_esd_rec.rep_pell_id,
            x_duns_id                    => p_esd_rec.duns_id ,
            x_gaps_award_num             => p_esd_rec.gaps_award_num,
            x_transaction_date           => p_esd_rec.transaction_date,
            x_db_cr_flag                 => p_esd_rec.db_cr_flag ,
            x_adj_amt                    => p_esd_rec.adj_amt ,
            x_gaps_process_date          => p_esd_rec.gaps_process_date,
            x_adj_batch_id               => p_esd_rec.adj_batch_id);

Line: 279

      fnd_message.set_token('NAME','igf_gr_ess_esd_data.insert_in_esd_table');

Line: 283

END insert_in_esd_table;

Line: 335

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

Line: 367

                 insert_in_ess_table(lv_ess_row);

Line: 484

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

Line: 515

                 insert_in_esd_table(lv_esd_row);