[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
COUNT(origination_id) rec_count
FROM
igf_gr_rfms
WHERE
ci_cal_type = p_ci_cal_type AND
ci_sequence_number = p_ci_sequence_number AND
p_orig_id = origination_id;
SELECT
COUNT(origination_id) rec_count
FROM
igf_gr_rfms
WHERE
ci_cal_type = p_ci_cal_type AND
ci_sequence_number = p_ci_sequence_number AND
p_orig_id = origination_id;
PROCEDURE insert_in_ytdor_table ( p_orig_rec IN igf_gr_ytd_orig%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);
igf_gr_ytd_orig_pkg.insert_row (
x_rowid => lv_rowid,
x_ytdor_id => lv_ytdor_id,
x_origination_id => p_orig_rec.origination_id,
x_original_ssn => p_orig_rec.original_ssn,
x_original_name_cd => p_orig_rec.original_name_cd,
x_attend_pell_id => p_orig_rec.attend_pell_id,
x_ed_use => P_orig_rec.ed_use,
x_inst_cross_ref_code => p_orig_rec.inst_cross_ref_code,
x_action_code => p_orig_rec.action_code,
x_accpt_awd_amt => p_orig_rec.accpt_awd_amt,
x_accpt_disb_dt1 => p_orig_rec.accpt_disb_dt1,
x_accpt_disb_dt2 => p_orig_rec.accpt_disb_dt2,
x_accpt_disb_dt3 => p_orig_rec.accpt_disb_dt3,
x_accpt_disb_dt4 => p_orig_rec.accpt_disb_dt4,
x_accpt_disb_dt5 => p_orig_rec.accpt_disb_dt5,
x_accpt_disb_dt6 => p_orig_rec.accpt_disb_dt6,
x_accpt_disb_dt7 => p_orig_rec.accpt_disb_dt7,
x_accpt_disb_dt8 => p_orig_rec.accpt_disb_dt8,
x_accpt_disb_dt9 => p_orig_rec.accpt_disb_dt9,
x_accpt_disb_dt10 => p_orig_rec.accpt_disb_dt10,
x_accpt_disb_dt11 => p_orig_rec.accpt_disb_dt11,
x_accpt_disb_dt12 => p_orig_rec.accpt_disb_dt12,
x_accpt_disb_dt13 => p_orig_rec.accpt_disb_dt13,
x_accpt_disb_dt14 => p_orig_rec.accpt_disb_dt14,
x_accpt_disb_dt15 => p_orig_rec.accpt_disb_dt15,
x_accpt_enrl_dt => p_orig_rec.accpt_enrl_dt,
x_accpt_low_tut_flg => p_orig_rec.accpt_low_tut_flg,
x_accpt_ver_stat_flg => p_orig_rec.accpt_ver_stat_flg,
x_accpt_incr_pell_cd => p_orig_rec.accpt_incr_pell_cd,
x_accpt_tran_num => p_orig_rec.accpt_tran_num,
x_accpt_efc => p_orig_rec.accpt_efc,
x_accpt_sec_efc => p_orig_rec.accpt_sec_efc,
x_accpt_acad_cal => p_orig_rec.accpt_acad_cal,
x_accpt_pymt_method => p_orig_rec.accpt_pymt_method,
x_accpt_coa => p_orig_rec.accpt_coa,
x_accpt_enrl_stat => p_orig_rec.accpt_enrl_stat,
x_accpt_wks_inst_pymt => p_orig_rec.accpt_wks_inst_pymt,
x_wk_inst_time_calc_pymt => p_orig_rec.wk_inst_time_calc_pymt,
x_accpt_wks_acad => p_orig_rec.accpt_wks_acad,
x_accpt_cr_acad_yr => p_orig_rec.accpt_cr_acad_yr,
x_inst_seq_num => p_orig_rec.inst_seq_num,
x_sch_full_time_pell => p_orig_rec.sch_full_time_pell,
x_stud_name => p_orig_rec.stud_name,
x_ssn => p_orig_rec.ssn ,
x_stud_dob => p_orig_rec.stud_dob,
x_cps_ver_sel_cd => p_orig_rec.cps_ver_sel_cd,
x_ytd_disb_amt => p_orig_rec.ytd_disb_amt,
x_batch_id => p_orig_rec.batch_id ,
x_process_date => p_orig_rec.process_date,
x_mode => 'R',
x_ci_cal_type => g_ci_cal_type,
x_ci_sequence_number => g_ci_sequence_number
);
fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdor_table');
END insert_in_ytdor_table;
PROCEDURE insert_in_ytdds_table ( p_orig_rec IN igf_gr_ytd_disb%ROWTYPE )
AS
/***************************************************************
Created By : avenkatr
Date Created By : 2000/12/22
Purpose : To Load data into IGF_GR_YTD_DISB table
Known Limitations,Enhancements or Remarks
Change History :
Who When What
***************************************************************/
lv_rowid VARCHAR2(25);
igf_gr_ytd_disb_pkg.insert_row (
x_rowid => lv_rowid,
x_ytdds_id => lv_ytdds_id,
x_origination_id => p_orig_rec.origination_id,
x_inst_cross_ref_code => p_orig_rec.inst_cross_ref_code,
x_action_code => p_orig_rec.action_code,
x_disb_ref_num => NVL(p_orig_rec.disb_ref_num,0),
x_disb_accpt_amt => NVL(p_orig_rec.disb_accpt_amt,0),
x_db_cr_flag => p_orig_rec.db_cr_flag,
x_disb_dt => p_orig_rec.disb_dt,
x_pymt_prd_start_dt => NVL(p_orig_rec.pymt_prd_start_dt,TRUNC(SYSDATE)),
x_disb_batch_id => p_orig_rec.disb_batch_id,
x_mode => 'R',
x_ci_cal_type => g_ci_cal_type,
x_ci_sequence_number => g_ci_sequence_number,
x_student_name => p_orig_rec.student_name,
x_current_ssn_txt => p_orig_rec.current_ssn_txt,
x_student_birth_date => p_orig_rec.student_birth_date,
x_disb_process_date => p_orig_rec.disb_process_date,
x_routing_id_txt => p_orig_rec.routing_id_txt,
x_fin_award_year_num => p_orig_rec.fin_award_year_num,
x_attend_entity_id_txt => p_orig_rec.attend_entity_id_txt,
x_disb_seq_num => p_orig_rec.disb_seq_num,
x_disb_rel_ind => p_orig_rec.disb_rel_ind,
x_prev_disb_seq_num => p_orig_rec.prev_disb_seq_num
) ;
fnd_message.set_token('NAME','igf_gr_ytd_load_data.insert_in_ytdds_table');
END insert_in_ytdds_table;
SELECT
record_data
FROM
igf_gr_load_file_t
WHERE
gldr_id BETWEEN 2 AND (l_last_gldr_id - 1)
AND
file_type = 'YTD'
ORDER BY
gldr_id;
insert_in_ytdor_table (lv_ytdor_row );
insert_in_ytdds_table (lv_ytdds_row ) ;