[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
awd.ROWID row_id,awd.*,fmast.fund_code
FROM
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE
awd.award_id = c_award_id AND
awd.base_id = c_base_id AND
fmast.fund_id = awd.fund_id AND
DECODE(c_run_mode,
'L',NVL(awd.lock_award_flag,'N'),
'U',NVL(awd.lock_award_flag,'N'),
'PB',NVL(awd.publish_in_ss_flag,'N'),
'UP',NVL(awd.publish_in_ss_flag,'N')
) <> DECODE(c_run_mode,
'L','Y',
'U','N',
'PB','Y',
'UP','N'
)
FOR UPDATE OF awd.lock_award_flag,awd.awd_proc_status_code,awd.publish_in_ss_flag NOWAIT;
SELECT
awd.ROWID row_id,awd.*,fmast.fund_code
FROM
igf_aw_award_all awd,
igf_aw_fund_mast_all fmast
WHERE
awd.award_id = c_award_id AND
awd.base_id = c_base_id AND
fmast.fund_id = awd.fund_id
FOR UPDATE OF awd.lock_award_flag,
awd.awd_proc_status_code,
awd.publish_in_ss_flag NOWAIT;
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 => lc_awd.OFFERED_AMT,
x_accepted_amt => lc_awd.ACCEPTED_AMT,
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 => lc_awd.AWARD_STATUS,
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 => lc_awd.legacy_record_flag,
x_adplans_id => lc_awd.adplans_id,
x_lock_award_flag => lv_lock_award_flag,
x_app_trans_num_txt => lc_awd.app_trans_num_txt,
x_awd_proc_status_code => lv_awd_proc_status_code,
x_notification_status_code => lc_awd.notification_status_code,
x_notification_status_date => lc_awd.notification_status_date,
x_publish_in_ss_flag => lv_publish_in_ss_flag
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.process_award.debug','End of Update');
SELECT fab.*
FROM igf_ap_fa_base_rec fab
WHERE fab.base_id = c_base_id
AND NVL(lock_awd_flag,'N') <> DECODE(c_run_mode,'L','Y','N')
FOR UPDATE OF lock_coa_flag NOWAIT;
igf_ap_fa_base_rec_pkg.update_row
(x_Mode => 'R',
x_rowid => cur_fbr_rec.row_id,
x_base_id => cur_fbr_rec.base_id,
x_ci_cal_type => cur_fbr_rec.ci_cal_type,
x_person_id => cur_fbr_rec.person_id,
x_ci_sequence_number => cur_fbr_rec.ci_sequence_number,
x_org_id => cur_fbr_rec.org_id,
x_coa_pending => cur_fbr_rec.coa_pending,
x_verification_process_run => cur_fbr_rec.verification_process_run,
x_inst_verif_status_date => cur_fbr_rec.inst_verif_status_date,
x_manual_verif_flag => cur_fbr_rec.manual_verif_flag,
x_fed_verif_status => cur_fbr_rec.fed_verif_status,
x_fed_verif_status_date => cur_fbr_rec.fed_verif_status_date,
x_inst_verif_status => cur_fbr_rec.inst_verif_status,
x_nslds_eligible => cur_fbr_rec.nslds_eligible,
x_ede_correction_batch_id => cur_fbr_rec.ede_correction_batch_id,
x_fa_process_status_date => cur_fbr_rec.fa_process_status_date,
x_ISIR_corr_status => cur_fbr_rec.ISIR_corr_status,
x_ISIR_corr_status_date => cur_fbr_rec.ISIR_corr_status_date,
x_ISIR_status => cur_fbr_rec.ISIR_status,
x_ISIR_status_date => cur_fbr_rec.ISIR_status_date,
x_coa_code_f => cur_fbr_rec.coa_code_f,
x_coa_code_i => cur_fbr_rec.coa_code_i,
x_coa_f => cur_fbr_rec.coa_f,
x_coa_i => cur_fbr_rec.coa_i,
x_disbursement_hold => cur_fbr_rec.disbursement_hold,
x_fa_process_status => cur_fbr_rec.fa_process_status,
x_notification_status => cur_fbr_rec.notification_status,
x_notification_status_date => cur_fbr_rec.notification_status_date,
x_packaging_status => cur_fbr_rec.packaging_status,
x_packaging_status_date => cur_fbr_rec.packaging_status_date,
x_total_package_accepted => cur_fbr_rec.total_package_accepted,
x_total_package_offered => cur_fbr_rec.total_package_offered,
x_admstruct_id => cur_fbr_rec.admstruct_id,
x_admsegment_1 => cur_fbr_rec.admsegment_1,
x_admsegment_2 => cur_fbr_rec.admsegment_2,
x_admsegment_3 => cur_fbr_rec.admsegment_3,
x_admsegment_4 => cur_fbr_rec.admsegment_4,
x_admsegment_5 => cur_fbr_rec.admsegment_5,
x_admsegment_6 => cur_fbr_rec.admsegment_6,
x_admsegment_7 => cur_fbr_rec.admsegment_7,
x_admsegment_8 => cur_fbr_rec.admsegment_8,
x_admsegment_9 => cur_fbr_rec.admsegment_9,
x_admsegment_10 => cur_fbr_rec.admsegment_10,
x_admsegment_11 => cur_fbr_rec.admsegment_11,
x_admsegment_12 => cur_fbr_rec.admsegment_12,
x_admsegment_13 => cur_fbr_rec.admsegment_13,
x_admsegment_14 => cur_fbr_rec.admsegment_14,
x_admsegment_15 => cur_fbr_rec.admsegment_15,
x_admsegment_16 => cur_fbr_rec.admsegment_16,
x_admsegment_17 => cur_fbr_rec.admsegment_17,
x_admsegment_18 => cur_fbr_rec.admsegment_18,
x_admsegment_19 => cur_fbr_rec.admsegment_19,
x_admsegment_20 => cur_fbr_rec.admsegment_20,
x_packstruct_id => cur_fbr_rec.packstruct_id,
x_packsegment_1 => cur_fbr_rec.packsegment_1,
x_packsegment_2 => cur_fbr_rec.packsegment_2,
x_packsegment_3 => cur_fbr_rec.packsegment_3,
x_packsegment_4 => cur_fbr_rec.packsegment_4,
x_packsegment_5 => cur_fbr_rec.packsegment_5,
x_packsegment_6 => cur_fbr_rec.packsegment_6,
x_packsegment_7 => cur_fbr_rec.packsegment_7,
x_packsegment_8 => cur_fbr_rec.packsegment_8,
x_packsegment_9 => cur_fbr_rec.packsegment_9,
x_packsegment_10 => cur_fbr_rec.packsegment_10,
x_packsegment_11 => cur_fbr_rec.packsegment_11,
x_packsegment_12 => cur_fbr_rec.packsegment_12,
x_packsegment_13 => cur_fbr_rec.packsegment_13,
x_packsegment_14 => cur_fbr_rec.packsegment_14,
x_packsegment_15 => cur_fbr_rec.packsegment_15,
x_packsegment_16 => cur_fbr_rec.packsegment_16,
x_packsegment_17 => cur_fbr_rec.packsegment_17,
x_packsegment_18 => cur_fbr_rec.packsegment_18,
x_packsegment_19 => cur_fbr_rec.packsegment_19,
x_packsegment_20 => cur_fbr_rec.packsegment_20,
x_miscstruct_id => cur_fbr_rec.miscstruct_id,
x_miscsegment_1 => cur_fbr_rec.miscsegment_1,
x_miscsegment_2 => cur_fbr_rec.miscsegment_2,
x_miscsegment_3 => cur_fbr_rec.miscsegment_3,
x_miscsegment_4 => cur_fbr_rec.miscsegment_4,
x_miscsegment_5 => cur_fbr_rec.miscsegment_5,
x_miscsegment_6 => cur_fbr_rec.miscsegment_6,
x_miscsegment_7 => cur_fbr_rec.miscsegment_7,
x_miscsegment_8 => cur_fbr_rec.miscsegment_8,
x_miscsegment_9 => cur_fbr_rec.miscsegment_9,
x_miscsegment_10 => cur_fbr_rec.miscsegment_10,
x_miscsegment_11 => cur_fbr_rec.miscsegment_11,
x_miscsegment_12 => cur_fbr_rec.miscsegment_12,
x_miscsegment_13 => cur_fbr_rec.miscsegment_13,
x_miscsegment_14 => cur_fbr_rec.miscsegment_14,
x_miscsegment_15 => cur_fbr_rec.miscsegment_15,
x_miscsegment_16 => cur_fbr_rec.miscsegment_16,
x_miscsegment_17 => cur_fbr_rec.miscsegment_17,
x_miscsegment_18 => cur_fbr_rec.miscsegment_18,
x_miscsegment_19 => cur_fbr_rec.miscsegment_19,
x_miscsegment_20 => cur_fbr_rec.miscsegment_20,
x_prof_judgement_flg => cur_fbr_rec.prof_judgement_flg,
x_nslds_data_override_flg => cur_fbr_rec.nslds_data_override_flg,
x_target_group => cur_fbr_rec.target_group,
x_coa_fixed => cur_fbr_rec.coa_fixed,
x_profile_status => cur_fbr_rec.profile_status,
x_profile_status_date => cur_fbr_rec.profile_status_date,
x_profile_fc => cur_fbr_rec.profile_fc,
x_coa_pell => cur_fbr_rec.coa_pell,
x_manual_disb_hold => cur_fbr_rec.manual_disb_hold,
x_pell_alt_expense => cur_fbr_rec.pell_alt_expense,
x_assoc_org_num => cur_fbr_rec.assoc_org_num,
x_award_fmly_contribution_type => cur_fbr_rec.award_fmly_contribution_type,
x_packaging_hold => cur_fbr_rec.packaging_hold,
x_isir_locked_by => cur_fbr_rec.isir_locked_by ,
x_adnl_unsub_loan_elig_flag => cur_fbr_rec.adnl_unsub_loan_elig_flag,
x_lock_awd_flag => lv_lock_award_flag,
x_lock_coa_flag => cur_fbr_rec.lock_coa_flag
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_manage_awd.lock_unlock_stud.debug','End of Update');
SELECT fa.base_id
FROM igf_ap_fa_base_rec_all fa
WHERE fa.ci_cal_type = c_ci_cal_type
AND fa.ci_sequence_number = c_ci_sequence_number
ORDER BY fa.base_id;
SELECT group_cd
FROM igs_pe_persid_group_all
WHERE group_id = c_grp_id;
SELECT fund_code
FROM igf_aw_fund_mast_all
WHERE fund_id = c_fund_id;
SELECT awd.award_id
FROM igf_aw_award_all awd
WHERE awd.base_id = c_base_id AND
awd.fund_id = NVL(c_fund_id, awd.fund_id) AND
NOT EXISTS
(SELECT disb.ld_cal_type,
disb.ld_sequence_number
FROM igf_aw_awd_disb_all disb
WHERE disb.award_id = awd.award_id
MINUS
SELECT ld_cal_type,
ld_sequence_number
FROM igf_aw_awd_prd_term apt
WHERE apt.ci_cal_type = c_ci_cal_type AND
apt.ci_sequence_number = c_ci_sequence_number AND
apt.award_prd_cd = c_award_prd_cd
);
SELECT party_number
FROM hz_parties
WHERE party_id = c_person_id;
SELECT awd.award_id
FROM igf_aw_award_all awd
WHERE awd.base_id = c_base_id AND
awd.fund_id = NVL(c_fund_id, awd.fund_id);
'SELECT person_id,
person_number
FROM igs_pe_person_base_v
WHERE person_id IN ('||lv_sql_stmt||') ' USING p_pid_group;
'SELECT person_id,
person_number
FROM igs_pe_person_base_v
WHERE person_id IN ('||lv_sql_stmt||')';