[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fund_exp_da
FROM igf_aw_fund_mast_all
WHERE fund_id = cp_fund_id;
SELECT person_number
FROM igs_pe_person_base_v
WHERE person_id = cp_person_id;
SELECT base_id
FROM igf_ap_fa_base_rec_all
WHERE person_id = cp_person_id AND
ci_cal_type = cp_cal_type AND
ci_sequence_number = cp_sequence_number;
SELECT
awd.award_id,
awd.base_id,
fapv.person_number,
fmast.fund_code,
fcat.fed_fund_code
FROM
igf_aw_award awd,
igf_aw_fund_mast fmast,
igf_ap_fa_base_rec fbase,
igf_ap_person_v fapv,
igf_aw_fund_cat fcat
WHERE
fbase.ci_cal_type = cp_ci_cal_type
AND fbase.ci_sequence_number = cp_ci_seq_num
AND awd.fund_id = NVL(cp_fund_id, awd.fund_id)
AND awd.base_id = NVL(cp_base_id, awd.base_id)
AND fmast.fund_id = awd.fund_id
AND awd.award_status = 'OFFERED'
AND awd.base_id = fbase.base_id
AND fbase.person_id = fapv.person_id
AND fmast.fund_code = fcat.fund_code
AND fcat.fed_fund_code <> 'SPNSR'
AND fcat.fed_fund_code <> 'FWS' ; --Currently we are not handling FWS funds
SELECT
awd.*
FROM
igf_aw_award awd
WHERE
awd.award_id = p_award_id
FOR UPDATE OF award_status NOWAIT;
SELECT row_id,disb_num
FROM igf_aw_awd_disb
WHERE
award_id = p_award_id;
igf_aw_award_pkg.update_row (
x_mode => 'R',
x_rowid => lc_awd.ROW_ID,
x_award_id => lc_awd.AWARD_ID,
x_fund_id => lc_awd.FUND_ID,
x_base_id => lc_awd.BASE_ID,
x_offered_amt => 0,
x_accepted_amt => 0,
x_paid_amt => lc_awd.PAID_AMT,
x_packaging_type => lc_awd.PACKAGING_TYPE,
x_batch_id => lc_awd.BATCH_ID,
x_manual_update => lc_awd.MANUAL_UPDATE,
x_rules_override => lc_awd.RULES_OVERRIDE,
x_award_date => lc_awd.AWARD_DATE,
x_award_status => 'CANCELLED',
x_attribute_category => lc_awd.ATTRIBUTE_CATEGORY,
x_attribute1 => lc_awd.ATTRIBUTE1,
x_attribute2 => lc_awd.ATTRIBUTE2,
x_attribute3 => lc_awd.ATTRIBUTE3,
x_attribute4 => lc_awd.ATTRIBUTE4,
x_attribute5 => lc_awd.ATTRIBUTE5,
x_attribute6 => lc_awd.ATTRIBUTE6,
x_attribute7 => lc_awd.ATTRIBUTE7,
x_attribute8 => lc_awd.ATTRIBUTE8,
x_attribute9 => lc_awd.ATTRIBUTE9,
x_attribute10 => lc_awd.ATTRIBUTE10,
x_attribute11 => lc_awd.ATTRIBUTE11,
x_attribute12 => lc_awd.ATTRIBUTE12,
x_attribute13 => lc_awd.ATTRIBUTE13,
x_attribute14 => lc_awd.ATTRIBUTE14,
x_attribute15 => lc_awd.ATTRIBUTE15,
x_attribute16 => lc_awd.ATTRIBUTE16,
x_attribute17 => lc_awd.ATTRIBUTE17,
x_attribute18 => lc_awd.ATTRIBUTE18,
x_attribute19 => lc_awd.ATTRIBUTE19,
x_attribute20 => lc_awd.ATTRIBUTE20,
x_rvsn_id => lc_awd.RVSN_ID ,
x_alt_pell_schedule => lc_awd.ALT_PELL_SCHEDULE,
x_award_number_txt => lc_awd.AWARD_NUMBER_TXT,
x_legacy_record_flag => NULL,
x_adplans_id => lc_awd.adplans_id,
x_lock_award_flag => lc_awd.lock_award_flag,
x_app_trans_num_txt => lc_awd.app_trans_num_txt,
x_awd_proc_status_code => 'AWARDED',
x_notification_status_code => lc_awd.notification_status_code,
x_notification_status_date => lc_awd.notification_status_date,
x_publish_in_ss_flag => lc_awd.publish_in_ss_flag
);
igf_aw_gen.update_fabase_awds(lc_award.base_id,'CANCELLED');
|| veramach 1-NOV-2003 # 3160856 Added adplans_id in call to igf_aw_award.update_row
|| smadathi 03-Feb-2002 Bug 2154941. Modified cursor c_award to exclude sponsor fund
||
|| (reverse chronological order - newest change first)
*/
--Bug No:-2272349 Desc :-Cancel Award Routines
--Cursor to fetch the Fund COde for the Fund ID
CURSOR cur_get_fund_code IS
SELECT fund_code
FROM igf_aw_fund_mast
WHERE fund_id=p_fund_id;
SELECT meaning FROM igf_lookups_view
WHERE lookup_type='IGF_GE_PARAMETERS'
AND lookup_code IN ('AWARD_ID', 'FUND_CODE', 'PARAMETER_PASS', 'PERSON_NUMBER', 'RUN_MODE', 'PERSON_ID_GROUP');
SELECT alternate_code FROM igs_ca_inst
WHERE cal_type =p_cal_type
AND sequence_number = p_sequence_number;
SELECT person_number FROM
igf_ap_fa_con_v
WHERE base_id=p_base_id;
SELECT description
FROM igs_pe_persid_group_all
WHERE group_id = cp_pig_id;
OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ' USING p_pig;
OPEN l_per_cur FOR ' SELECT PARTY_ID FROM HZ_PARTIES WHERE PARTY_ID IN (' || l_list || ') ';
SELECT
fcat.*
FROM
igf_aw_fund_mast mst,
igf_aw_fund_Cat fcat
WHERE
mst.fund_id = p_fund_id AND
fcat.fund_code = mst.fund_code;
SELECT
orig_Action_code,origination_id
FROM
igf_gr_rfms
WHERE
award_id = p_award_id;
SELECT
disb.disb_ack_act_status
FROM
igf_gr_rfms_disb disb
WHERE
disb.origination_id = cp_orig_id;
SELECT disb_status
FROM
igf_db_Awd_disb_dtl
WHERE
award_id = p_award_id;