The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rowid row_id, resp.*
from igf_aw_awd_cert_resps resp
where BASE_ID = cp_base_id
and CI_CAL_TYPE = cp_ci_cal_type
and CI_SEQUENCE_NUMBER = cp_ci_sequence_number
and AWARD_PRD_CD = cp_award_prd_cd
and AWD_CERT_CODE = cp_cert_code;
igf_aw_awd_cert_resps_pkg.update_row( x_rowid => cert_resps_detail.row_id,
x_ci_cal_type => cert_resps_detail.ci_cal_type,
x_ci_sequence_number => cert_resps_detail.ci_sequence_number,
x_award_prd_cd => cert_resps_detail.award_prd_cd,
x_base_id => cert_resps_detail.base_id,
x_awd_cert_code => cert_resps_detail.awd_cert_code,
x_response_txt => p_response,
x_object_version_number => cert_resps_detail.object_version_number,
x_mode => 'R');
igf_aw_awd_cert_resps_pkg.insert_row( x_rowid => l_rowid,
x_ci_cal_type => p_ci_cal_type,
x_ci_sequence_number => p_ci_sequence_number,
x_award_prd_cd => p_award_prd_cd,
x_base_id => p_base_id,
x_awd_cert_code => p_cert_code,
x_response_txt => p_response,
x_object_version_number => 1,
x_mode => 'R');
PROCEDURE update_awards_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
p_offered_amt NUMBER,
p_accepted_amt NUMBER,
p_award_status VARCHAR2
) AS
------------------------------------------------------------------
--Created by : rasahoo, Oracle India
--Date created:
--
--Purpose:
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE) IS
SELECT disb.rowid row_id,
disb.*
FROM IGF_AW_AWD_DISB_ALL disb
WHERE award_id = cp_award_id
AND trans_type IN ('A', 'P');
SELECT mast.*
FROM igf_aw_award awd,
igf_aw_fund_mast mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
update_award_status(p_award_id, l_award_status, l_lock_status);
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 => l_net_amt,
x_disb_date => disb_rec.disb_date,
x_trans_type => l_trans_type,
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 => l_dis_amt,
x_disb_paid_amt => disb_rec.disb_paid_amt,
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
);
END update_awards_from_ss;
SELECT apt.ld_cal_type ld_cal_type,
apt.ld_sequence_number ld_sequence_number
FROM IGF_AW_AWD_PRD_TERM apt,
IGS_CA_INST cal
WHERE apt.ci_sequence_number = cp_ci_sequence_number
AND apt.ci_cal_type = cp_ci_cal_type
AND award_prd_cd = cp_award_prd_cd
AND apt.ld_cal_type = cal.cal_type
AND apt.ld_sequence_number = cal.sequence_number
ORDER BY cal.start_dt ASC;
SELECT apt.ld_cal_type ld_cal_type,
apt.ld_sequence_number ld_sequence_number
FROM IGF_AW_AWD_PRD_TERM apt,
IGS_CA_INST cal
WHERE apt.ci_sequence_number = cp_ci_sequence_number
AND apt.ci_cal_type = cp_ci_cal_type
AND award_prd_cd = cp_award_prd_cd
AND apt.ld_cal_type = cal.cal_type
AND apt.ld_sequence_number = cal.sequence_number
ORDER BY cal.start_dt ASC;
SELECT awd.*
FROM IGF_AW_AWARD_ALL awd,
IGF_AW_AWD_DISB_ALL disb,
IGF_AW_AWD_PRD_TERM ap
WHERE awd.base_id = cp_base_id
AND awd.publish_in_ss_flag = 'Y'
AND awd.award_id = disb.award_id
AND disb.ld_cal_type = ap.ld_cal_type
AND disb.ld_sequence_number = ap.ld_sequence_number
AND ap.ci_cal_type = cp_ci_cal_type
AND ap.ci_sequence_number = cp_ci_sequence_number
AND ap.award_prd_cd = cp_award_prd_cd;
SELECT *
FROM IGF_AW_SS_DISB_V
WHERE base_id = cp_base_id
AND ci_cal_type = cp_ci_cal_type
AND ci_sequence_number = cp_ci_sequence_number
AND award_prd_cd = cp_award_prd_cd;
Select Person_Id
from igf_ap_fa_con_v
where base_id = cp_base_id;
SELECT fa.lock_awd_flag
FROM igf_ap_fa_base_rec fa
WHERE fa.base_id = cp_base_id;
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status, loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
SELECT award_status
FROM IGF_AW_AWARD
WHERE award_id = cp_award_id;
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'VIEW';
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status, loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
SELECT award_status
FROM IGF_AW_AWARD
WHERE award_id = cp_award_id;
and the Accepted Amount field to prevent further updates
*/
IF (NVL(fund_mast_rec.allow_inc_post_accept_flag,'N') <> 'Y') AND (NVL(fund_mast_rec.allow_dec_post_accept_flag,'N') <> 'Y') THEN
IF l_award_status = 'ACCEPTED' THEN
RETURN 'VW';
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'VW';
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status,loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
SELECT *
FROM IGF_AW_AWARD awd
WHERE awd.award_id = cp_award_id;
SELECT award_status
FROM IGF_AW_AWARD
WHERE award_id = cp_award_id;
If the "Allow Decline After Accept" checkbox IS selected on the Fund Manager form,
Student Self-Service tab, then if the award has an accepted status,
the Decline radio button for that award will be enabled.
If the "Allow Decline After Accept" checkbox IS NOT selected on the Fund Manager form,
Student Self-Service tab, then if the award has an accepted status,
the Decline radio button for that award will NOT be enabled.
Note: An award cannot be declined once any part of it has been 'Paid'
(i.e. if any part of the award is paid, then the decline radio button for that
award should not be enabled).
*/
OPEN cur_award_details(p_award_id);
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
In either case, if the award is declined, it is made read-only.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'V';
PROCEDURE update_award_status ( p_award_id igf_aw_award_all.award_id%TYPE,
p_award_status VARCHAR2,
p_lock_status VARCHAR2
) AS
------------------------------------------------------------------
--Created by : rasahoo, Oracle India
--Date created:
--
--Purpose:
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
-- Get an award
CURSOR c_award (cp_award_id igf_aw_award_all.award_id%TYPE) IS
SELECT awd.rowid row_id,
awd.*
FROM IGF_AW_AWARD_ALL awd
WHERE award_id = cp_award_id;
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 => awd_rec.accepted_amt,
x_paid_amt => awd_rec.paid_amt,
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 => p_award_status,
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 => p_lock_status,
x_app_trans_num_txt => awd_rec.app_trans_num_txt,
x_awd_proc_status_code => awd_rec.awd_proc_status_code,
x_publish_in_ss_flag => awd_rec.publish_in_ss_flag
);
END update_award_status;
PROCEDURE update_awards_by_term_from_ss ( p_award_id igf_aw_award_all.award_id%TYPE,
p_ld_cal_type VARCHAR2,
p_ld_seq_num NUMBER,
p_offered_amt NUMBER,
p_accepted_amt NUMBER,
p_term_awd_status VARCHAR2
) AS
------------------------------------------------------------------
--Created by : rasahoo, Oracle India
--Date created:
--
--Purpose:
--
--
--Known limitations/enhancements and/or remarks:
--
--Change History:
--Who When What
-------------------------------------------------------------------
CURSOR c_disb ( cp_award_id igf_aw_award_all.award_id%TYPE,
cp_ld_cal_type VARCHAR2,
cp_ld_seq_num NUMBER) IS
SELECT disb.rowid row_id,
disb.*
FROM IGF_AW_AWD_DISB_ALL disb
WHERE award_id = cp_award_id
AND ld_cal_type = cp_ld_cal_type
AND ld_sequence_number = cp_ld_seq_num
AND trans_type IN ('A', 'P');
SELECT fmast.disb_rounding_code
FROM igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE awd.fund_id = fmast.fund_id
AND awd.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 => l_net_amt,
x_disb_date => disb_rec.disb_date,
x_trans_type => l_trans_type,
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 => l_dis_amt,
x_disb_paid_amt => disb_rec.disb_paid_amt,
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
);
END update_awards_by_term_from_ss;
SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;
SELECT base_id
FROM igf_aw_award_all
WHERE award_id = cp_award_id;
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status, loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'VIEW';
SELECT base_id
FROM igf_aw_award_all
WHERE award_id = cp_award_id;
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status, loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
and the Accepted Amount field to prevent further updates
*/
IF (NVL(fund_mast_rec.allow_inc_post_accept_flag,'N') <> 'Y') AND (NVL(fund_mast_rec.allow_dec_post_accept_flag,'N') <> 'Y') THEN
IF l_award_status = 'ACCEPTED' THEN
RETURN 'VW';
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'VW';
SELECT base_id
FROM igf_aw_award_all
WHERE award_id = cp_award_id;
SELECT awd.lock_award_flag lock_awd_flag, mast.*
FROM IGF_AW_AWARD awd,
IGF_AW_FUND_MAST mast
WHERE awd.award_id = cp_award_id
AND awd.fund_id = mast.fund_id;
SELECT MIN(disb_date)
FROM IGF_AW_AWD_DISB
WHERE award_id = cp_award_id;
SELECT cat.fed_fund_code
FROM igf_aw_fund_mast_all fund,
igf_aw_fund_cat_all cat
WHERE fund.fund_code = cat.fund_code
AND fund.fund_id = cp_fund_id;
SELECT orig_action_code
FROM igf_gr_rfms
WHERE award_id = cp_award_id;
SELECT loan_status,loan_chg_status
FROM igf_sl_loans_all
WHERE award_id = cp_award_id;
SELECT *
FROM IGF_AW_AWARD awd
WHERE awd.award_id = cp_award_id;
If the "Allow Decline After Accept" checkbox IS selected on the Fund Manager form,
Student Self-Service tab, then if the award has an accepted status,
the Decline radio button for that award will be enabled.
If the "Allow Decline After Accept" checkbox IS NOT selected on the Fund Manager form,
Student Self-Service tab, then if the award has an accepted status,
the Decline radio button for that award will NOT be enabled.
Note: An award cannot be declined once any part of it has been 'Paid'
(i.e. if any part of the award is paid, then the decline radio button for that
award should not be enabled).
*/
l_award_status := igf_aw_ss_gen_pkg.get_term_award_status(p_award_id,p_ld_cal_type,p_ld_seq_num);
If the "View-only After Decline" radio button IS selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
make the award view-only on the Fund Manager form, Student Self-Service tab.
This award will still be picked up during the repackaging process.
If the "View-only After Decline" radio button IS NOT selected on the Fund Manager form,
Student Self-Service tab, then when a student declines an award via student self-service,
the award remains editable. This award will still be picked up during the repackaging process.
In either case, if the award is declined, it is made read-only.
*/
IF l_award_status = 'DECLINED' AND NVL(fund_mast_rec.status_after_decline,'VIEW') = 'VIEW' THEN
RETURN 'V';
SELECT award_id, disb_num, trans_type, disb_accepted_amt
FROM igf_aw_awd_disb_all
WHERE award_id = cp_award_id
AND ld_cal_type = cp_ld_cal_type
AND ld_sequence_number = cp_ld_seq_num;