[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_number
FROM hz_parties parties,
igf_ap_fa_base_rec_all fabase
WHERE fabase.person_id = parties.party_id
AND fabase.base_id = cp_base_id;
SELECT alternate_code
FROM igs_ca_inst_all
WHERE cal_type = cp_cal_type
AND sequence_number = cp_seq_number;
SELECT group_cd group_name
FROM igs_pe_persid_group_all
WHERE group_id = cp_persid_grp;
SELECT awd.rowid row_id,
awd.*
FROM igf_aw_award_all awd
WHERE award_id = cp_award_id;
SELECT disb.rowid row_id,
disb.*
FROM igf_aw_awd_disb_all disb
WHERE award_id = cp_award_id;
igf_aw_awd_disb_pkg.update_row(
x_rowid => disb_rec.row_id,
x_award_id => disb_rec.award_id,
x_disb_num => disb_rec.disb_num,
x_tp_cal_type => disb_rec.tp_cal_type,
x_tp_sequence_number => disb_rec.tp_sequence_number,
x_disb_gross_amt => disb_rec.disb_gross_amt,
x_fee_1 => disb_rec.fee_1,
x_fee_2 => disb_rec.fee_2,
x_disb_net_amt => disb_rec.disb_net_amt,
x_disb_date => disb_rec.disb_date,
x_trans_type => 'C',
x_elig_status => disb_rec.elig_status,
x_elig_status_date => disb_rec.elig_status_date,
x_affirm_flag => disb_rec.affirm_flag,
x_hold_rel_ind => disb_rec.hold_rel_ind,
x_manual_hold_ind => disb_rec.manual_hold_ind,
x_disb_status => disb_rec.disb_status,
x_disb_status_date => disb_rec.disb_status_date,
x_late_disb_ind => disb_rec.late_disb_ind,
x_fund_dist_mthd => disb_rec.fund_dist_mthd,
x_prev_reported_ind => disb_rec.prev_reported_ind,
x_fund_release_date => disb_rec.fund_release_date,
x_fund_status => disb_rec.fund_status,
x_fund_status_date => disb_rec.fund_status_date,
x_fee_paid_1 => disb_rec.fee_paid_1,
x_fee_paid_2 => disb_rec.fee_paid_2,
x_cheque_number => disb_rec.cheque_number,
x_ld_cal_type => disb_rec.ld_cal_type,
x_ld_sequence_number => disb_rec.ld_sequence_number,
x_disb_accepted_amt => 0,
x_disb_paid_amt => 0,
x_rvsn_id => disb_rec.rvsn_id,
x_int_rebate_amt => disb_rec.int_rebate_amt,
x_force_disb => disb_rec.force_disb,
x_min_credit_pts => disb_rec.min_credit_pts,
x_disb_exp_dt => disb_rec.disb_exp_dt,
x_verf_enfr_dt => disb_rec.verf_enfr_dt,
x_fee_class => disb_rec.fee_class,
x_show_on_bill => disb_rec.show_on_bill,
x_mode => 'R',
x_attendance_type_code => disb_rec.attendance_type_code,
x_base_attendance_type_code => disb_rec.base_attendance_type_code,
x_payment_prd_st_date => disb_rec.payment_prd_st_date,
x_change_type_code => disb_rec.change_type_code,
x_fund_return_mthd_code => disb_rec.fund_return_mthd_code,
x_direct_to_borr_flag => disb_rec.direct_to_borr_flag
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.cancel_invalid_award.debug','updated disbursement number '||disb_rec.disb_num);
igf_aw_award_pkg.update_row(
x_rowid => awd_rec.row_id,
x_award_id => awd_rec.award_id,
x_fund_id => awd_rec.fund_id,
x_base_id => awd_rec.base_id,
x_offered_amt => awd_rec.offered_amt,
x_accepted_amt => 0,
x_paid_amt => 0,
x_packaging_type => awd_rec.packaging_type,
x_batch_id => awd_rec.batch_id,
x_manual_update => awd_rec.manual_update,
x_rules_override => awd_rec.rules_override,
x_award_date => awd_rec.award_date,
x_award_status => 'CANCELLED',
x_attribute_category => awd_rec.attribute_category,
x_attribute1 => awd_rec.attribute1,
x_attribute2 => awd_rec.attribute2,
x_attribute3 => awd_rec.attribute3,
x_attribute4 => awd_rec.attribute4,
x_attribute5 => awd_rec.attribute5,
x_attribute6 => awd_rec.attribute6,
x_attribute7 => awd_rec.attribute7,
x_attribute8 => awd_rec.attribute8,
x_attribute9 => awd_rec.attribute9,
x_attribute10 => awd_rec.attribute10,
x_attribute11 => awd_rec.attribute11,
x_attribute12 => awd_rec.attribute12,
x_attribute13 => awd_rec.attribute13,
x_attribute14 => awd_rec.attribute14,
x_attribute15 => awd_rec.attribute15,
x_attribute16 => awd_rec.attribute16,
x_attribute17 => awd_rec.attribute17,
x_attribute18 => awd_rec.attribute18,
x_attribute19 => awd_rec.attribute19,
x_attribute20 => awd_rec.attribute20,
x_rvsn_id => awd_rec.rvsn_id,
x_alt_pell_schedule => awd_rec.alt_pell_schedule,
x_mode => 'R',
x_award_number_txt => awd_rec.award_number_txt,
x_legacy_record_flag => awd_rec.legacy_record_flag,
x_adplans_id => awd_rec.adplans_id,
x_lock_award_flag => awd_rec.lock_award_flag,
x_app_trans_num_txt => awd_rec.app_trans_num_txt,
x_awd_proc_status_code => awd_rec.awd_proc_status_code,
x_notification_status_code => awd_rec.notification_status_code,
x_notification_status_date => awd_rec.notification_status_date,
x_publish_in_ss_flag => awd_rec.publish_in_ss_flag
);
SELECT awd.base_id,
awd.award_id,
awd.fund_id,
awd.award_status,
fmast.fund_code
FROM igf_aw_fund_cat_all fcat,
igf_aw_fund_mast_all fmast,
igf_aw_award_all awd
WHERE fcat.fed_fund_code = 'PELL'
AND fcat.fund_code = fmast.fund_code
AND fmast.fund_id = awd.fund_id
AND awd.base_id = cp_base_id
AND NVL(awd.lock_award_flag,'N') = 'N';
SELECT rfms.*
FROM igf_gr_rfms rfms
WHERE award_id = cp_award_id;
SELECT row_id,
disb_ack_act_status
FROM igf_gr_rfms_disb rfmd
WHERE origination_id = cp_origination_id;
SELECT awd.rowid row_id,
awd.*
FROM igf_aw_award_all awd
WHERE awd.award_id = cp_award_id
AND awd.award_status IN ('OFFERED','ACCEPTED');
SELECT isir_id
FROM igf_ap_isir_matched_all
WHERE base_id = cp_base_id
AND active_isir = 'Y';
SELECT isir_id
FROM igf_ap_isir_matched_all
WHERE base_id = cp_base_id
AND payment_isir = 'Y';
SELECT alternate_code
FROM igs_ca_inst_all
WHERE cal_type = cp_cal_type
AND sequence_number = cp_sequence_number;
SELECT *
FROM igf_gr_pell_setup
WHERE pell_seq_id = cp_pell_seq_id;
SELECT *
FROM igf_aw_awd_disb
WHERE award_id = cp_award_id
AND disb_num > cp_disb_num;
SELECT disb.rowid row_id,
disb.*
FROM igf_aw_awd_disb_all disb
WHERE
award_id = cp_award_id AND
disb_num = cp_disb_num ;
SELECT rfmd.rowid row_id,
rfmd.*
FROM igf_gr_rfms_disb_all rfmd
WHERE
rfmd.origination_id = cp_origination_id AND
rfmd.disb_ref_num = cp_disb_num ;
SELECT rfmd.rowid row_id,
rfmd.*
FROM igf_gr_rfms_disb_all rfmd
WHERE
rfmd.origination_id = cp_origination_id AND
rfmd.disb_ref_num > cp_disb_num ;
SELECT party_number
FROM hz_parties parties,
igf_ap_fa_base_rec_all fabase
WHERE fabase.person_id = parties.party_id
AND fabase.base_id = cp_base_id;
igf_gr_rfms_pkg.update_row(
x_rowid => lc_rfms.row_id,
x_origination_id => lc_rfms.origination_id,
x_ci_cal_type => lc_rfms.ci_cal_type,
x_ci_sequence_number => lc_rfms.ci_sequence_number,
x_base_id => lc_rfms.base_id,
x_award_id => lc_rfms.award_id,
x_rfmb_id => lc_rfms.rfmb_id,
x_sys_orig_ssn => lc_rfms.sys_orig_ssn,
x_sys_orig_name_cd => lc_rfms.sys_orig_name_cd,
x_transaction_num => lc_rfms.transaction_num,
x_efc => lc_rfms.efc,
x_ver_status_code => lc_rfms.ver_status_code,
x_secondary_efc => lc_rfms.secondary_efc,
x_secondary_efc_cd => lc_rfms.secondary_efc_cd,
x_pell_amount => l_offered_amt,
x_pell_profile => lc_rfms.pell_profile,
x_enrollment_status => lc_rfms.enrollment_status,
x_enrollment_dt => lc_rfms.enrollment_dt,
x_coa_amount => lc_rfms.coa_amount,
x_academic_calendar => lc_rfms.academic_calendar,
x_payment_method => lc_rfms.payment_method,
x_total_pymt_prds => lc_rfms.total_pymt_prds,
x_incrcd_fed_pell_rcp_cd => lc_rfms.incrcd_fed_pell_rcp_cd,
x_attending_campus_id => lc_rfms.attending_campus_id,
x_est_disb_dt1 => lc_rfms.est_disb_dt1,
x_orig_action_code => lc_rfms.orig_action_code,
x_orig_status_dt => lc_rfms.orig_status_dt,
x_orig_ed_use_flags => lc_rfms.orig_ed_use_flags,
x_ft_pell_amount => l_pell_ft_aid,
x_prev_accpt_efc => lc_rfms.prev_accpt_efc,
x_prev_accpt_tran_no => lc_rfms.prev_accpt_tran_no,
x_prev_accpt_sec_efc_cd => lc_rfms.prev_accpt_sec_efc_cd,
x_prev_accpt_coa => lc_rfms.prev_accpt_coa,
x_orig_reject_code => lc_rfms.orig_reject_code,
x_wk_inst_time_calc_pymt => lc_rfms.wk_inst_time_calc_pymt,
x_wk_int_time_prg_def_yr => lc_rfms.wk_int_time_prg_def_yr,
x_cr_clk_hrs_prds_sch_yr => lc_rfms.cr_clk_hrs_prds_sch_yr,
x_cr_clk_hrs_acad_yr => lc_rfms.cr_clk_hrs_acad_yr,
x_inst_cross_ref_cd => lc_rfms.inst_cross_ref_cd,
x_low_tution_fee => lc_rfms.low_tution_fee,
x_rec_source => lc_rfms.rec_source,
x_pending_amount => lc_rfms.pending_amount,
x_mode => 'R',
x_birth_dt => lc_rfms.birth_dt,
x_last_name => lc_rfms.last_name,
x_first_name => lc_rfms.first_name,
x_middle_name => lc_rfms.middle_name,
x_current_ssn => lc_rfms.current_ssn,
x_legacy_record_flag => lc_rfms.legacy_record_flag,
x_reporting_pell_cd => lc_rfms.rep_pell_id,
x_rep_entity_id_txt => lc_rfms.rep_entity_id_txt,
x_atd_entity_id_txt => lc_rfms.atd_entity_id_txt,
x_note_message => lc_rfms.note_message,
x_full_resp_code => lc_rfms.full_resp_code,
x_document_id_txt => lc_rfms.document_id_txt
);
Since PELL is an entitlement, we should not insert overaward holds on the award.
we show a message to the user saying that this award will result in an overaward, but we are not
inserting overaward holds as the fund is an entitlement
*/
fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
igf_aw_awd_disb_pkg.update_row(
x_rowid => l_disb_rec.row_id,
x_award_id => lc_stud_det.award_id,
x_disb_num => l_pell_tab(i).sl_number,
x_tp_cal_type => l_pell_tab(i).tp_cal_type,
x_tp_sequence_number => l_pell_tab(i).tp_sequence_number,
x_disb_gross_amt => l_pell_tab(i).offered_amt,
x_fee_1 => l_disb_rec.fee_1,
x_fee_2 => l_disb_rec.fee_2,
x_disb_net_amt => l_pell_tab(i).accepted_amt,
x_disb_date => l_pell_tab(i).disb_dt,
x_trans_type => l_disb_rec.trans_type,
x_elig_status => l_disb_rec.elig_status,
x_elig_status_date => l_disb_rec.elig_status_date,
x_affirm_flag => l_disb_rec.affirm_flag,
x_hold_rel_ind => l_disb_rec.hold_rel_ind,
x_manual_hold_ind => l_disb_rec.manual_hold_ind,
x_disb_status => l_disb_rec.disb_status,
x_disb_status_date => l_disb_rec.disb_status_date,
x_late_disb_ind => l_disb_rec.late_disb_ind,
x_fund_dist_mthd => l_disb_rec.fund_dist_mthd,
x_prev_reported_ind => l_disb_rec.prev_reported_ind,
x_fund_release_date => l_disb_rec.fund_release_date,
x_fund_status => l_disb_rec.fund_status,
x_fund_status_date => l_disb_rec.fund_status_date,
x_fee_paid_1 => l_disb_rec.fee_paid_1,
x_fee_paid_2 => l_disb_rec.fee_paid_2,
x_cheque_number => l_disb_rec.cheque_number,
x_ld_cal_type => l_pell_tab(i).ld_cal_type,
x_ld_sequence_number => l_pell_tab(i).ld_sequence_number,
x_disb_accepted_amt => l_pell_tab(i).accepted_amt,
x_disb_paid_amt => l_disb_rec.disb_paid_amt,
x_rvsn_id => l_disb_rec.rvsn_id,
x_int_rebate_amt => l_disb_rec.int_rebate_amt,
x_force_disb => l_disb_rec.force_disb,
x_min_credit_pts => l_pell_tab(i).min_credit_pts,
x_disb_exp_dt => l_pell_tab(i).disb_exp_dt,
x_verf_enfr_dt => l_pell_tab(i).verf_enfr_dt,
x_fee_class => l_disb_rec.fee_class,
x_show_on_bill => l_pell_tab(i).show_on_bill,
x_mode => 'R',
x_attendance_type_code => l_pell_tab(i).attendance_type_code,
x_base_attendance_type_code => l_pell_tab(i).base_attendance_type_code,
x_payment_prd_st_date => l_disb_rec.payment_prd_st_date,
x_change_type_code => l_disb_rec.change_type_code,
x_fund_return_mthd_code => l_disb_rec.fund_return_mthd_code,
x_direct_to_borr_flag => l_disb_rec.direct_to_borr_flag
);
ELSE -- Disbursement Does not Exist ..So Insert it
--
lv_row_id := NULL;
igf_aw_awd_disb_pkg.insert_row(
x_rowid => lv_row_id,
x_award_id => lc_stud_det.award_id,
x_disb_num => l_pell_tab(i).sl_number,
x_tp_cal_type => l_pell_tab(i).tp_cal_type,
x_tp_sequence_number => l_pell_tab(i).tp_sequence_number,
x_disb_gross_amt => l_pell_tab(i).offered_amt,
x_fee_1 => NULL,
x_fee_2 => NULL,
x_disb_net_amt => l_pell_tab(i).accepted_amt,
x_disb_date => l_pell_tab(i).disb_dt,
x_trans_type => 'P',
x_elig_status => 'N',
x_elig_status_date => NULL,
x_affirm_flag => 'N',
x_hold_rel_ind => NULL,
x_manual_hold_ind => 'N',
x_disb_status => NULL,
x_disb_status_date => NULL,
x_late_disb_ind => NULL,
x_fund_dist_mthd => 'E',
x_prev_reported_ind => 'N',
x_fund_release_date => NULL,
x_fund_status => NULL,
x_fund_status_date => NULL,
x_fee_paid_1 => 0,
x_fee_paid_2 => 0,
x_cheque_number => NULL,
x_ld_cal_type => l_pell_tab(i).ld_cal_type,
x_ld_sequence_number => l_pell_tab(i).ld_sequence_number,
x_disb_accepted_amt => l_pell_tab(i).accepted_amt,
x_disb_paid_amt => 0,
x_rvsn_id => NULL,
x_int_rebate_amt => 0,
x_force_disb => NULL,
x_min_credit_pts => l_pell_tab(i).min_credit_pts,
x_disb_exp_dt => l_pell_tab(i).disb_exp_dt,
x_verf_enfr_dt => l_pell_tab(i).verf_enfr_dt,
x_fee_class => NULL,
x_show_on_bill => l_pell_tab(i).show_on_bill,
x_mode => 'R',
x_attendance_type_code => l_pell_tab(i).attendance_type_code,
x_base_attendance_type_code => l_pell_tab(i).base_attendance_type_code,
x_payment_prd_st_date => NULL,
x_change_type_code => NULL,
x_fund_return_mthd_code => NULL,
x_direct_to_borr_flag => 'N'
);
END IF; -- Disbursement Record Insert
igf_gr_rfms_disb_pkg.update_row(
x_mode => 'R',
x_rowid => l_rfmb_disb_rec.row_id,
x_rfmd_id => l_rfmb_disb_rec.rfmd_id,
x_origination_id => l_rfmb_disb_rec.origination_id,
x_disb_ref_num => l_rfmb_disb_rec.disb_ref_num,
x_disb_dt => l_rfmb_disb_rec.disb_dt,
x_disb_amt => l_rfmb_disb_rec.disb_amt,
x_db_cr_flag => l_rfmb_disb_rec.db_cr_flag,
x_disb_ack_act_status => l_rfmb_disb_rec.disb_ack_act_status ,
x_disb_status_dt => l_rfmb_disb_rec.disb_status_dt ,
x_accpt_disb_dt => l_rfmb_disb_rec.accpt_disb_dt ,
x_disb_accpt_amt => l_rfmb_disb_rec.disb_accpt_amt ,
x_accpt_db_cr_flag => l_rfmb_disb_rec.accpt_db_cr_flag ,
x_disb_ytd_amt => l_rfmb_disb_rec.disb_ytd_amt ,
x_pymt_prd_start_dt => l_rfmb_disb_rec.pymt_prd_start_dt ,
x_accpt_pymt_prd_start_dt => l_rfmb_disb_rec.accpt_pymt_prd_start_dt ,
x_edit_code => l_rfmb_disb_rec.edit_code ,
x_rfmb_id => l_rfmb_disb_rec.rfmb_id,
x_ed_use_flags => l_rfmb_disb_rec.ed_use_flags
);
igf_gr_rfms_disb_pkg.insert_row(
x_mode => 'R',
x_rowid => lv_row_id,
x_rfmd_id => lv_rfmd_id,
x_origination_id => lc_rfms.origination_id,
x_disb_ref_num => i,
x_disb_dt => l_pell_tab(i).disb_dt ,
x_disb_amt => l_pell_tab(i).accepted_amt ,
x_db_cr_flag => 'P',
x_disb_ack_act_status => 'R',
x_disb_status_dt => TRUNC(SYSDATE) ,
x_accpt_disb_dt => NULL ,
x_disb_accpt_amt => NULL ,
x_accpt_db_cr_flag => NULL ,
x_disb_ytd_amt => NULL ,
x_pymt_prd_start_dt => NULL ,
x_accpt_pymt_prd_start_dt => NULL ,
x_edit_code => NULL ,
x_rfmb_id => NULL ,
x_ed_use_flags => NULL
);
igf_aw_awd_disb_pkg.update_row(
x_rowid => disb_cancel_rec.row_id,
x_award_id => disb_cancel_rec.award_id,
x_disb_num => disb_cancel_rec.disb_num,
x_tp_cal_type => disb_cancel_rec.tp_cal_type,
x_tp_sequence_number => disb_cancel_rec.tp_sequence_number,
x_disb_gross_amt => disb_cancel_rec.disb_gross_amt,
x_fee_1 => disb_cancel_rec.fee_1,
x_fee_2 => disb_cancel_rec.fee_2,
x_disb_net_amt => disb_cancel_rec.disb_net_amt,
x_disb_date => disb_cancel_rec.disb_date,
x_trans_type => 'C',
x_elig_status => disb_cancel_rec.elig_status,
x_elig_status_date => disb_cancel_rec.elig_status_date,
x_affirm_flag => disb_cancel_rec.affirm_flag,
x_hold_rel_ind => disb_cancel_rec.hold_rel_ind,
x_manual_hold_ind => disb_cancel_rec.manual_hold_ind,
x_disb_status => disb_cancel_rec.disb_status,
x_disb_status_date => disb_cancel_rec.disb_status_date,
x_late_disb_ind => disb_cancel_rec.late_disb_ind,
x_fund_dist_mthd => disb_cancel_rec.fund_dist_mthd,
x_prev_reported_ind => disb_cancel_rec.prev_reported_ind,
x_fund_release_date => disb_cancel_rec.fund_release_date,
x_fund_status => disb_cancel_rec.fund_status,
x_fund_status_date => disb_cancel_rec.fund_status_date,
x_fee_paid_1 => disb_cancel_rec.fee_paid_1,
x_fee_paid_2 => disb_cancel_rec.fee_paid_2,
x_cheque_number => disb_cancel_rec.cheque_number,
x_ld_cal_type => disb_cancel_rec.ld_cal_type,
x_ld_sequence_number => disb_cancel_rec.ld_sequence_number,
x_disb_accepted_amt => 0,
x_disb_paid_amt => 0,
x_rvsn_id => disb_cancel_rec.rvsn_id,
x_int_rebate_amt => disb_cancel_rec.int_rebate_amt,
x_force_disb => disb_cancel_rec.force_disb,
x_min_credit_pts => disb_cancel_rec.min_credit_pts,
x_disb_exp_dt => disb_cancel_rec.disb_exp_dt,
x_verf_enfr_dt => disb_cancel_rec.verf_enfr_dt,
x_fee_class => disb_cancel_rec.fee_class,
x_show_on_bill => disb_cancel_rec.show_on_bill,
x_mode => 'R',
x_attendance_type_code => disb_cancel_rec.attendance_type_code,
x_base_attendance_type_code => disb_cancel_rec.base_attendance_type_code,
x_payment_prd_st_date => disb_cancel_rec.payment_prd_st_date,
x_change_type_code => disb_cancel_rec.change_type_code,
x_fund_return_mthd_code => disb_cancel_rec.fund_return_mthd_code,
x_direct_to_borr_flag => disb_cancel_rec.direct_to_borr_flag
);
igf_gr_rfms_disb_pkg.delete_row(rfms_disb_rec.row_id);
END IF; -- Delete of Extra RFMS Disbursement Records
igf_aw_award_pkg.update_row(
x_rowid => lc_award.row_id,
x_award_id => lc_award.award_id,
x_fund_id => lc_award.fund_id,
x_base_id => lc_award.base_id,
x_offered_amt => lc_award.offered_amt,
x_accepted_amt => lc_award.accepted_amt,
x_paid_amt => lc_award.paid_amt,
x_packaging_type => lc_award.packaging_type,
x_batch_id => lc_award.batch_id,
x_manual_update => lc_award.manual_update,
x_rules_override => lc_award.rules_override,
x_award_date => lc_award.award_date,
x_award_status => lc_award.award_status,
x_attribute_category => lc_award.attribute_category,
x_attribute1 => lc_award.attribute1,
x_attribute2 => lc_award.attribute2,
x_attribute3 => lc_award.attribute3,
x_attribute4 => lc_award.attribute4,
x_attribute5 => lc_award.attribute5,
x_attribute6 => lc_award.attribute6,
x_attribute7 => lc_award.attribute7,
x_attribute8 => lc_award.attribute8,
x_attribute9 => lc_award.attribute9,
x_attribute10 => lc_award.attribute10,
x_attribute11 => lc_award.attribute11,
x_attribute12 => lc_award.attribute12,
x_attribute13 => lc_award.attribute13,
x_attribute14 => lc_award.attribute14,
x_attribute15 => lc_award.attribute15,
x_attribute16 => lc_award.attribute16,
x_attribute17 => lc_award.attribute17,
x_attribute18 => lc_award.attribute18,
x_attribute19 => lc_award.attribute19,
x_attribute20 => lc_award.attribute20,
x_rvsn_id => lc_award.rvsn_id,
x_alt_pell_schedule => l_pell_schedule_code,--update the pell schedule
x_mode => 'R',
x_award_number_txt => lc_award.award_number_txt,
x_legacy_record_flag => lc_award.legacy_record_flag,
x_adplans_id => lc_award.adplans_id,
x_lock_award_flag => lc_award.lock_award_flag,
x_app_trans_num_txt => lc_award.app_trans_num_txt,
x_awd_proc_status_code => lc_award.awd_proc_status_code,
x_notification_status_code => lc_award.notification_status_code,
x_notification_status_date => lc_award.notification_status_date,
x_publish_in_ss_flag => lc_award.publish_in_ss_flag
);
SELECT awd.base_id
FROM igf_aw_award_all awd,
igf_aw_fund_mast_all fmast,
igf_aw_fund_cat_all fcat
WHERE fmast.ci_sequence_number = cp_seq_number
AND fmast.ci_cal_type = cp_cal_type
AND awd.fund_id = fmast.fund_id
AND fmast.fund_code = fcat.fund_code
AND fcat.fed_fund_code = 'PELL';
OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number,p_persid_grp;
OPEN cur_base_id FOR ' SELECT base_id FROM igf_ap_fa_base_rec_all WHERE ci_cal_type = :p_ci_cal_type AND ci_sequence_number = :p_ci_sequence_number AND person_id IN (' || l_list || ') ' USING l_ci_cal_type, l_ci_sequence_number;