The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DISTINCT mst.*
FROM igf_ap_td_item_mst_all mst,
igf_aw_fund_td_map_all map
WHERE map.fund_id = cp_ref_fund_id
AND map.item_sequence_number = mst.todo_number;
SELECT tdm.item_code,
tdm.career_item
FROM igf_aw_fund_td_map_all ftodo,
igf_ap_td_item_mst_all tdm
WHERE tdm.todo_number = ftodo.item_sequence_number
AND ftodo.fund_id = cp_ref_fund_id;
SELECT todo_number
FROM igf_ap_td_item_mst_all
WHERE ci_cal_type IS NULL
AND ci_sequence_number IS NULL
AND item_code = cp_item_code
AND NVL(career_item,'N') = 'Y';
SELECT todo_number
FROM igf_ap_td_item_mst_all
WHERE item_code = cp_item_code
AND ci_cal_type = cp_to_cal_type
AND ci_sequence_number = cp_to_sequence_number
AND NVL(career_item,'N') = 'N';
igf_ap_td_item_mst_pkg.insert_row(
x_rowid => l_rowid,
x_todo_number => l_todo_number,
x_item_code => l_get_fund_todo.item_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_description => l_get_fund_todo.description,
x_corsp_mesg => l_get_fund_todo.corsp_mesg,
x_career_item => l_get_fund_todo.career_item,
x_required_for_application => l_get_fund_todo.required_for_application,
x_freq_attempt => l_get_fund_todo.freq_attempt,
x_max_attempt => l_get_fund_todo.max_attempt,
x_mode => 'R',
x_system_todo_type_code => l_get_fund_todo.system_todo_type_code,
x_application_code => l_get_fund_todo.application_code,
x_display_in_ss_flag => l_get_fund_todo.display_in_ss_flag,
x_ss_instruction_txt => l_get_fund_todo.ss_instruction_txt,
x_allow_attachment_flag => l_get_fund_todo.allow_attachment_flag,
x_document_url_txt => l_get_fund_todo.document_url_txt
);
igf_aw_fund_td_map_pkg.insert_row (
x_rowid => l_rowid,
x_ftodo_id => l_ftodo_id,
x_fund_id => p_new_fund_id,
x_item_sequence_number => l_item_sequence_number
);
SELECT fcls.fclass_id, fcls.fee_class
FROM igf_aw_fund_feeclas_all fcls
WHERE fund_id = cp_ref_fund_id;
igf_aw_fund_feeclas_pkg.insert_row(
x_rowid => l_rowid,
x_fclass_id => l_fclass_id,
x_fund_id => p_new_fund_id,
x_fee_class => l_get_feeclass.fee_class
);
SELECT unt.unit_cd
FROM igf_aw_fund_unit_all unt
WHERE fund_id = cp_ref_fund_id;
SELECT version_number
FROM igs_ps_unit_ver_all
WHERE unit_cd = cp_unit_code
ORDER BY version_number asc;
igf_aw_fund_unit_pkg.insert_row(
x_rowid => l_rowid,
x_funit_id => l_funit_id,
x_fund_id => p_new_fund_id,
x_unit_cd => l_get_units.unit_cd,
x_version_number => l_get_unit_ver.version_number
);
SELECT prg.course_cd
FROM igf_aw_fund_prg_all prg
WHERE fund_id = cp_ref_fund_id;
SELECT version_number
FROM igs_ps_ver_all
WHERE course_cd = cp_program_code
ORDER BY version_number asc;
igf_aw_fund_prg_pkg.insert_row (
x_rowid => l_rowid,
x_fprg_id => l_fprg_id,
x_fund_id => p_new_fund_id,
x_course_cd => l_get_programs.course_cd,
x_version_number => l_get_program_ver.version_number
);
SELECT excl.fund_code
FROM igf_aw_fund_excl_all excl
WHERE excl.fund_id = cp_ref_fund_id;
SELECT discontinue_fund
FROM igf_aw_fund_mast_all fnd
WHERE fnd.ci_cal_type = cp_frm_cal_type
AND fnd.ci_sequence_number = cp_frm_sequence_number
AND fnd.fund_code = cp_fund_code;
igf_aw_fund_excl_pkg.insert_row(
x_rowid => l_rowid,
x_fund_id => p_new_fund_id,
x_fund_code => l_fund_excl_rec.fund_code
);
SELECT incl.fund_code
FROM igf_aw_fund_incl_all incl
WHERE incl.fund_id = cp_ref_fund_id;
SELECT discontinue_fund
FROM igf_aw_fund_mast_all fnd
WHERE fnd.ci_cal_type = cp_frm_cal_type
AND fnd.ci_sequence_number = cp_frm_sequence_number
AND fnd.fund_code = cp_fund_code;
igf_aw_fund_incl_pkg.insert_row(
x_rowid => l_rowid,
x_fund_id => p_new_fund_id,
x_fund_code => l_fund_incl_rec.fund_code
);
SELECT 'X' exist
FROM igf_aw_fund_mast_all fnd
WHERE fnd.ci_cal_type = cp_to_cal_type
AND fnd.ci_sequence_number = cp_to_sequence_number
AND fnd.fund_code = cp_fund_code;
igf_aw_fund_mast_pkg.insert_row(
x_rowid => l_rowid,
x_fund_id => l_fund_id,
x_fund_code => p_fund_rec.fund_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_description => p_fund_rec.description,
x_discontinue_fund => p_fund_rec.discontinue_fund,
x_entitlement => p_fund_rec.entitlement,
x_auto_pkg => p_fund_rec.auto_pkg,
x_self_help => p_fund_rec.self_help,
x_allow_man_pkg => p_fund_rec.allow_man_pkg,
x_update_need => p_fund_rec.update_need,
x_disburse_fund => p_fund_rec.disburse_fund,
x_available_amt => p_fund_rec.available_amt,
x_offered_amt => 0,
x_pending_amt => 0,
x_accepted_amt => 0,
x_declined_amt => 0,
x_cancelled_amt => 0,
x_remaining_amt => p_fund_rec.available_amt,
x_enrollment_status => p_fund_rec.enrollment_status,
x_prn_award_letter => p_fund_rec.prn_award_letter,
x_over_award_amt => p_fund_rec.over_award_amt,
x_over_award_perct => p_fund_rec.over_award_perct,
x_min_award_amt => p_fund_rec.min_award_amt,
x_max_award_amt => p_fund_rec.max_award_amt,
x_max_yearly_amt => p_fund_rec.max_yearly_amt,
x_max_life_amt => p_fund_rec.max_life_amt,
x_max_life_term => p_fund_rec.max_life_term,
x_fm_fc_methd => p_fund_rec.fm_fc_methd,
x_roundoff_fact => p_fund_rec.roundoff_fact,
x_replace_fc => p_fund_rec.replace_fc,
x_allow_overaward => p_fund_rec.allow_overaward,
x_pckg_awd_stat => p_fund_rec.pckg_awd_stat,
x_org_record_req => p_fund_rec.org_record_req,
x_disb_record_req => p_fund_rec.disb_record_req,
x_prom_note_req => p_fund_rec.prom_note_req,
x_min_num_disb => p_fund_rec.min_num_disb,
x_max_num_disb => p_fund_rec.max_num_disb,
x_fee_type => p_fund_rec.fee_type,
x_total_offered => 0,
x_total_accepted => 0,
x_total_declined => 0,
x_total_revoked => 0,
x_total_cancelled => 0,
x_total_disbursed => 0,
x_total_committed => 0,
x_committed_amt => 0,
x_disbursed_amt => 0,
x_awd_notice_txt => p_fund_rec.awd_notice_txt,
x_attribute_category => p_fund_rec.attribute_category,
x_attribute1 => p_fund_rec.attribute1,
x_attribute2 => p_fund_rec.attribute2,
x_attribute3 => p_fund_rec.attribute3,
x_attribute4 => p_fund_rec.attribute4,
x_attribute5 => p_fund_rec.attribute5,
x_attribute6 => p_fund_rec.attribute6,
x_attribute7 => p_fund_rec.attribute7,
x_attribute8 => p_fund_rec.attribute8,
x_attribute9 => p_fund_rec.attribute9,
x_attribute10 => p_fund_rec.attribute10,
x_attribute11 => p_fund_rec.attribute11,
x_attribute12 => p_fund_rec.attribute12,
x_attribute13 => p_fund_rec.attribute13,
x_attribute14 => p_fund_rec.attribute14,
x_attribute15 => p_fund_rec.attribute15,
x_attribute16 => p_fund_rec.attribute16,
x_attribute17 => p_fund_rec.attribute17,
x_attribute18 => p_fund_rec.attribute18,
x_attribute19 => p_fund_rec.attribute19,
x_attribute20 => p_fund_rec.attribute20,
x_disb_verf_da => p_fund_rec.disb_verf_da,
x_fund_exp_da => p_fund_rec.fund_exp_da,
x_nslds_disb_da => p_fund_rec.nslds_disb_da ,
x_disb_exp_da => p_fund_rec.disb_exp_da,
x_fund_recv_reqd => p_fund_rec.fund_recv_reqd,
x_show_on_bill => p_fund_rec.show_on_bill,
x_bill_desc => p_fund_rec.bill_desc,
x_credit_type_id => p_fund_rec.credit_type_id,
x_spnsr_ref_num => NULL,
x_party_id => p_fund_rec.party_id,
x_spnsr_fee_type => NULL,
x_min_credit_points => p_fund_rec.min_credit_points,
x_group_id => p_fund_rec.group_id ,
x_spnsr_attribute_category => NULL,
x_spnsr_attribute1 => NULL,
x_spnsr_attribute2 => NULL,
x_spnsr_attribute3 => NULL,
x_spnsr_attribute4 => NULL,
x_spnsr_attribute5 => NULL,
x_spnsr_attribute6 => NULL,
x_spnsr_attribute7 => NULL,
x_spnsr_attribute8 => NULL,
x_spnsr_attribute9 => NULL,
x_spnsr_attribute10 => NULL,
x_spnsr_attribute11 => NULL,
x_spnsr_attribute12 => NULL,
x_spnsr_attribute13 => NULL,
x_spnsr_attribute14 => NULL,
x_spnsr_attribute15 => NULL,
x_spnsr_attribute16 => NULL,
x_spnsr_attribute17 => NULL,
x_spnsr_attribute18 => NULL,
x_spnsr_attribute19 => NULL,
x_spnsr_attribute20 => NULL,
x_threshold_perct => p_fund_rec.threshold_perct,
x_threshold_value => p_fund_rec.threshold_value,
x_gift_aid => p_fund_rec.gift_aid,
x_send_without_doc => p_fund_rec.send_without_doc,
x_ver_app_stat_override => p_fund_rec.ver_app_stat_override,
x_re_pkg_verif_flag => p_fund_rec.re_pkg_verif_flag,
x_donot_repkg_if_code => p_fund_rec.donot_repkg_if_code,
x_lock_award_flag => p_fund_rec.lock_award_flag,
x_mode => 'R',
x_view_only_flag => p_fund_rec.view_only_flag,
x_accept_less_amt_flag => p_fund_rec.accept_less_amt_flag,
x_allow_inc_post_accept_flag => p_fund_rec.allow_inc_post_accept_flag,
x_min_increase_amt => p_fund_rec.min_increase_amt,
x_allow_dec_post_accept_flag => p_fund_rec.allow_dec_post_accept_flag,
x_min_decrease_amt => p_fund_rec.min_decrease_amt,
x_allow_decln_post_accept_flag => p_fund_rec.allow_decln_post_accept_flag,
x_status_after_decline => p_fund_rec.status_after_decline,
x_fund_information_txt => p_fund_rec.fund_information_txt,
x_disb_rounding_code => p_fund_rec.disb_rounding_code
);
SELECT fnd.*
FROM igf_aw_fund_mast_all fnd,igf_aw_fund_cat_all fcat
WHERE fnd.ci_cal_type = cp_frm_cal_type
AND fnd.ci_sequence_number = cp_frm_sequence_number
AND fnd.fund_code = fcat.fund_code
AND fcat.sys_fund_type <> 'SPONSOR'
ORDER BY fnd.fund_id;
fnd_message.set_name('IGF','IGF_AW_INSERT_FUND_ERR');
SELECT cr_cal_type,
sc_sequence_number
FROM igf_aw_cal_rel_all
WHERE cr_cal_type = cp_frm_cal_type
AND cr_sequence_number = cp_frm_sequence_number
AND NVL(active,'N') = 'Y';
SELECT 'X' exist
FROM igf_aw_coa_rate_det item
WHERE item.ci_cal_type = cp_to_cal_type
AND item.ci_sequence_number = cp_to_sequence_number
AND item.item_code = cp_item_code
AND rownum = 1;
SELECT item_code
FROM igf_aw_coa_rate_det
WHERE ci_cal_type = cp_frm_cal_type
AND ci_sequence_number = cp_frm_sequence_number
GROUP BY item_code
ORDER BY item_code;
SELECT rate.*
FROM igf_aw_coa_rate_det rate
WHERE rate.ci_cal_type = cp_frm_cal_type
AND rate.ci_sequence_number = cp_frm_sequence_number
AND rate.item_code = cp_item_code;
igf_aw_coa_rate_det_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_item_code => l_rate_setup.item_code,
x_rate_order_num => l_rate_setup.rate_order_num,
x_pid_group_cd => l_rate_setup.pid_group_cd,
x_org_unit_cd => l_rate_setup.org_unit_cd,
x_program_type => l_rate_setup.program_type,
x_program_location_cd => l_rate_setup.program_location_cd,
x_program_cd => l_rate_setup.program_cd,
x_class_standing => l_rate_setup.class_standing,
x_residency_status_code => l_rate_setup.residency_status_code,
x_housing_status_code => l_rate_setup.housing_status_code,
x_attendance_type => l_rate_setup.attendance_type,
x_attendance_mode => l_rate_setup.attendance_mode,
x_ld_cal_type => l_to_ld_cal_type,
x_ld_sequence_number => l_to_ld_sequence_number,
x_mult_factor_code => l_rate_setup.mult_factor_code,
x_mult_amount_num => l_rate_setup.mult_amount_num
);
SELECT appln.application_code
FROM igf_ap_appl_setup_all appln
WHERE appln.ci_cal_type = cp_frm_cal_type
AND appln.ci_sequence_number = cp_frm_sequence_number
AND NVL(appln.active_flag,'N')= 'Y'
GROUP BY appln.application_code
ORDER BY appln.application_code;
SELECT appln.*
FROM igf_ap_appl_setup_all appln
WHERE appln.ci_cal_type = cp_frm_cal_type
AND appln.ci_sequence_number = cp_frm_sequence_number
AND appln.application_code = cp_application_code
AND NVL(appln.active_flag,'N')= 'Y'
ORDER BY appln.question_id;
SELECT 'X' exist
FROM igf_ap_appl_setup_all appln
WHERE appln.ci_cal_type = cp_to_cal_type
AND appln.ci_sequence_number = cp_to_sequence_number
AND appln.application_code = cp_application_code
AND NVL(appln.active_flag,'N')= 'Y';
igf_ap_appl_setup_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_enabled => l_inst_appln_setup.enabled,
x_org_id => l_inst_appln_setup.org_id,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_question_id => l_inst_appln_setup.question_id,
x_question => l_inst_appln_setup.question,
x_application_code => l_inst_appln_setup.application_code,
x_application_name => l_inst_appln_setup.application_name,
x_active_flag => l_inst_appln_setup.active_flag,
x_answer_type_code => l_inst_appln_setup.answer_type_code,
x_destination_txt => l_inst_appln_setup.destination_txt,
x_ld_cal_type => l_to_ld_cal_type,
x_ld_sequence_number => l_to_ld_sequence_number,
x_all_terms_flag => l_inst_appln_setup.all_terms_flag,
x_override_exist_ant_data_flag => l_inst_appln_setup.override_exist_ant_data_flag,
x_required_flag => l_inst_appln_setup.required_flag,
x_minimum_value_num => l_inst_appln_setup.minimum_value_num,
x_maximum_value_num => l_inst_appln_setup.maximum_value_num,
x_minimum_date => l_inst_appln_setup.minimum_date,
x_maximium_date => l_inst_appln_setup.maximium_date,
x_lookup_code => l_inst_appln_setup.lookup_code,
x_hint_txt => l_inst_appln_setup.hint_txt
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan.debug','Insert an Award Distribution Plan');
igf_aw_awd_dist_plans_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_adplans_id => l_adplans_id,
x_awd_dist_plan_cd => p_plan_rec.awd_dist_plan_cd,
x_cal_type => p_to_cal_type,
x_sequence_number => p_to_sequence_number,
x_awd_dist_plan_cd_desc => p_plan_rec.awd_dist_plan_cd_desc,
x_active_flag => p_plan_rec.active_flag,
x_dist_plan_method_code => p_plan_rec.dist_plan_method_code
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_term.debug','Insert term attached to the plan');
igf_aw_dp_terms_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_adterms_id => l_adterms_id,
x_adplans_id => p_adplans_id,
x_ld_cal_type => p_to_ld_cal_type,
x_ld_sequence_number => p_to_ld_sequence_number,
x_ld_perct_num => p_plan_term_rec.ld_perct_num
);
fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_rollover.create_new_plan_tp.debug','Insert teaching period attached to the term');
igf_aw_dp_teach_prds_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_adteach_id => l_adteach_id,
x_adterms_id => p_adterms_id,
x_tp_cal_type => p_to_tp_cal_type,
x_tp_sequence_number => p_to_tp_sequence_number,
x_tp_perct_num => p_plan_tp_rec.tp_perct_num,
x_date_offset_cd => p_plan_tp_rec.date_offset_cd,
x_attendance_type_code => p_plan_tp_rec.attendance_type_code,
x_credit_points_num => p_plan_tp_rec.credit_points_num
);
SELECT plan.*
FROM igf_aw_awd_dist_plans plan
WHERE plan.cal_type = cp_frm_cal_type
AND plan.sequence_number = cp_frm_sequence_number
ORDER BY plan.awd_dist_plan_cd;
SELECT 'X' exist
FROM igf_aw_awd_dist_plans plan
WHERE plan.cal_type = cp_to_cal_type
AND plan.sequence_number = cp_to_sequence_number
AND plan.awd_dist_plan_cd = cp_awd_dist_plan_cd;
SELECT plan_term.*
FROM igf_aw_dp_terms plan_term
WHERE plan_term.adplans_id = cp_adplans_id
ORDER BY plan_term.adterms_id;
SELECT plan_tp.*
FROM igf_aw_dp_teach_prds plan_tp
WHERE plan_tp.adterms_id = cp_adterms_id
ORDER BY plan_tp.adteach_id;
SELECT coa.*
FROM igf_aw_coa_group_all coa
WHERE coa.ci_cal_type = cp_frm_cal_type
AND coa.ci_sequence_number = cp_frm_sequence_number
ORDER BY coa.coa_code;
SELECT 'X' exist
FROM igf_aw_coa_group_all coa
WHERE coa.ci_cal_type = cp_to_cal_type
AND coa.ci_sequence_number = cp_to_sequence_number
AND coa.coa_code = cp_coa_code;
SELECT coa_item.*
FROM igf_aw_coa_grp_item_all coa_item
WHERE coa_item.ci_cal_type = cp_frm_cal_type
AND coa_item.ci_sequence_number = cp_frm_sequence_number
AND coa_item.coa_code = cp_coa_code
AND coa_item.active = 'Y'
ORDER BY coa_item.item_code;
SELECT 'X' exist
FROM igf_aw_coa_rate_det
WHERE ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number
AND item_code = cp_item_code
AND rownum = 1;
SELECT ld_coa.*
FROM igf_aw_coa_ld_all ld_coa
WHERE ld_coa.ci_cal_type = cp_frm_cal_type
AND ld_coa.ci_sequence_number = cp_frm_sequence_number
AND ld_coa.coa_code = cp_coa_code;
SELECT over.*
FROM igf_aw_cit_ld_ovrd_all over
WHERE over.ci_cal_type = cp_frm_cal_type
AND over.ci_sequence_number = cp_frm_sequence_number
AND over.coa_code = cp_coa_code;
igf_aw_coa_group_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_coa_code => l_coa_grp_setup.coa_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_rule_order => NULL,
x_s_rule_call_cd => NULL,
x_rul_sequence_number => NULL,
x_pell_coa => NULL,
x_pell_alt_exp => NULL,
x_coa_grp_desc => l_coa_grp_setup.coa_grp_desc
);
igf_aw_coa_grp_item_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_coa_code => l_coa_item.coa_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_item_code => l_coa_item.item_code,
x_default_value => l_coa_item.default_value,
x_fixed_cost => l_coa_item.fixed_cost,
x_pell_coa => l_coa_item.pell_coa,
x_active => l_coa_item.active,
x_pell_amount => l_coa_item.pell_amount,
x_pell_alternate_amt => l_coa_item.pell_alternate_amt,
x_item_dist => l_coa_item.item_dist,
x_lock_flag => l_coa_item.lock_flag
);
igf_aw_coa_ld_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_coald_id => l_coald_id,
x_coa_code => l_ld_coa.coa_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_ld_cal_type => l_to_ld_cal_type,
x_ld_sequence_number => l_to_ld_sequence_number,
x_ld_perct => l_ld_coa.ld_perct
);
igf_aw_cit_ld_ovrd_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_cldo_id => l_cldo_id,
x_coa_code => l_overridden_item.coa_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_item_code => l_overridden_item.item_code,
x_ld_cal_type => l_to_ld_cal_type,
x_ld_sequence_number => l_to_ld_sequence_number,
x_ld_perct => l_overridden_item.ld_perct
);
SELECT todo.*
FROM igf_ap_td_item_mst_all todo
WHERE todo.ci_cal_type = cp_frm_cal_type
AND todo.ci_sequence_number = cp_frm_sequence_number
ORDER BY todo.item_code;
SELECT 'X' exist
FROM igf_ap_td_item_mst_all todo
WHERE todo.ci_cal_type = cp_to_cal_type
AND todo.ci_sequence_number = cp_to_sequence_number
AND todo.item_code = cp_item_code;
igf_ap_td_item_mst_pkg.insert_row (
x_rowid => l_rowid,
x_todo_number => l_todo_number,
x_item_code => l_todo_item_setup.item_code,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_description => l_todo_item_setup.description,
x_corsp_mesg => l_todo_item_setup.corsp_mesg,
x_career_item => l_todo_item_setup.career_item,
x_required_for_application => l_todo_item_setup.required_for_application,
x_freq_attempt => l_todo_item_setup.freq_attempt,
x_max_attempt => l_todo_item_setup.max_attempt,
x_mode => 'R',
x_system_todo_type_code => l_todo_item_setup.system_todo_type_code,
x_application_code => l_todo_item_setup.application_code,
x_display_in_ss_flag => l_todo_item_setup.display_in_ss_flag,
x_ss_instruction_txt => l_todo_item_setup.ss_instruction_txt,
x_allow_attachment_flag => l_todo_item_setup.allow_attachment_flag,
x_document_url_txt => l_todo_item_setup.document_url_txt
);
SELECT awd_dist_plan_cd
FROM igf_aw_awd_dist_plans
WHERE adplans_id = cp_adplans_id
AND cal_type = cp_cal_type
AND sequence_number = cp_sequence_number;
SELECT fund_code
FROM igf_aw_fund_mast_all
WHERE fund_id = cp_fund_id
AND ci_cal_type = cp_cal_type
AND ci_sequence_number = cp_sequence_number;
SELECT grp.*
FROM igf_aw_target_grp_all grp
WHERE grp.cal_type = cp_frm_cal_type
AND grp.sequence_number = cp_frm_sequence_number
ORDER BY grp.group_cd;
SELECT 'X' exist
FROM igf_aw_target_grp_all grp
WHERE grp.cal_type = cp_to_cal_type
AND grp.sequence_number = cp_to_sequence_number
AND grp.group_cd = cp_group_cd;
SELECT frm.*
FROM igf_aw_awd_frml_det_all frm
WHERE frm.ci_cal_type = cp_frm_cal_type
AND frm.ci_sequence_number = cp_frm_sequence_number
AND frm.formula_code = cp_group_cd
ORDER BY frm.adplans_id;
SELECT plan.adplans_id
FROM igf_aw_awd_dist_plans plan
WHERE plan.cal_type = cp_to_cal_type
AND plan.sequence_number = cp_to_sequence_number
AND plan.awd_dist_plan_cd IN
( SELECT plan_cd.awd_dist_plan_cd
FROM igf_aw_awd_dist_plans plan_cd
WHERE plan_cd.cal_type = cp_frm_cal_type
AND plan_cd.sequence_number = cp_frm_sequence_number
AND plan_cd.adplans_id = cp_adplans_id
);
SELECT fnd.fund_id
FROM igf_aw_fund_mast_all fnd
WHERE fnd.ci_cal_type = cp_to_cal_type
AND fnd.ci_sequence_number = cp_to_sequence_number
AND fnd.fund_code IN
( SELECT fnd_cd.fund_code
FROM igf_aw_fund_mast_all fnd_cd
WHERE fnd_cd.ci_cal_type = cp_frm_cal_type
AND fnd_cd.ci_sequence_number = cp_frm_sequence_number
AND fnd_cd.fund_id = cp_fund_id
);
igf_aw_target_grp_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_group_cd => l_award_grp_setup.group_cd,
x_description => l_award_grp_setup.description,
x_active => l_award_grp_setup.active,
x_max_grant_amt => l_award_grp_setup.max_grant_amt,
x_max_grant_perct => l_award_grp_setup.max_grant_perct,
x_max_grant_perct_fact => l_award_grp_setup.max_grant_perct_fact,
x_max_loan_amt => l_award_grp_setup.max_loan_amt,
x_max_loan_perct => l_award_grp_setup.max_loan_perct,
x_max_loan_perct_fact => l_award_grp_setup.max_loan_perct_fact,
x_max_work_amt => l_award_grp_setup.max_work_amt,
x_max_work_perct => l_award_grp_setup.max_work_perct,
x_max_work_perct_fact => l_award_grp_setup.max_work_perct_fact,
x_max_shelp_amt => l_award_grp_setup.max_shelp_amt,
x_max_shelp_perct => l_award_grp_setup.max_shelp_perct,
x_max_shelp_perct_fact => l_award_grp_setup.max_shelp_perct_fact,
x_max_gap_amt => l_award_grp_setup.max_gap_amt,
x_max_gap_perct => l_award_grp_setup.max_gap_perct,
x_max_gap_perct_fact => l_award_grp_setup.max_gap_perct_fact,
x_use_fixed_costs => l_award_grp_setup.use_fixed_costs,
x_max_aid_pkg => l_award_grp_setup.max_aid_pkg,
x_max_gift_amt => l_award_grp_setup.max_gift_amt,
x_max_gift_perct => l_award_grp_setup.max_gift_perct,
x_max_gift_perct_fact => l_award_grp_setup.max_gift_perct_fact,
x_max_schlrshp_amt => l_award_grp_setup.max_schlrshp_amt,
x_max_schlrshp_perct => l_award_grp_setup.max_schlrshp_perct,
x_max_schlrshp_perct_fact => l_award_grp_setup.max_schlrshp_perct_fact,
x_cal_type => p_to_cal_type,
x_sequence_number => p_to_sequence_number,
x_rule_order => l_award_grp_setup.rule_order,
x_s_rule_call_cd => l_award_grp_setup.s_rule_call_cd,
x_rul_sequence_number => l_award_grp_setup.rul_sequence_number,
x_tgrp_id => l_tgrp_id,
x_adplans_id => l_plan_exists.adplans_id
);
igf_aw_awd_frml_det_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_formula_code => l_formula_setup.formula_code,
x_fund_id => l_fund_exists.fund_id,
x_min_award_amt => l_formula_setup.min_award_amt,
x_max_award_amt => l_formula_setup.max_award_amt,
x_seq_no => l_formula_setup.seq_no,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_replace_fc => l_formula_setup.replace_fc,
x_pe_group_id => l_formula_setup.pe_group_id,
x_adplans_id => l_plan_exists.adplans_id,
x_lock_award_flag => l_formula_setup.lock_award_flag
);
SELECT appln.*
FROM igf_ap_appl_setup_all appln
WHERE appln.ci_cal_type = cp_frm_cal_type
AND appln.ci_sequence_number = cp_frm_sequence_number
AND appln.application_code = cp_application_code
AND NVL(appln.active_flag,'N')= 'Y'
ORDER BY appln.question_id;
SELECT 'X' exist
FROM igf_ap_appl_setup_all appln
WHERE appln.ci_cal_type = cp_to_cal_type
AND appln.ci_sequence_number = cp_to_sequence_number
AND appln.application_code = cp_application_code
AND NVL(appln.active_flag,'N')= 'Y';
igf_ap_appl_setup_pkg.insert_row (
x_mode => 'R',
x_rowid => l_rowid,
x_enabled => l_inst_appln_setup.enabled,
x_org_id => l_inst_appln_setup.org_id,
x_ci_cal_type => p_to_cal_type,
x_ci_sequence_number => p_to_sequence_number,
x_question_id => l_inst_appln_setup.question_id,
x_question => l_inst_appln_setup.question,
x_application_code => l_inst_appln_setup.application_code,
x_application_name => l_inst_appln_setup.application_name,
x_active_flag => l_inst_appln_setup.active_flag,
x_answer_type_code => l_inst_appln_setup.answer_type_code,
x_destination_txt => l_inst_appln_setup.destination_txt,
x_ld_cal_type => l_to_ld_cal_type,
x_ld_sequence_number => l_to_ld_sequence_number,
x_all_terms_flag => l_inst_appln_setup.all_terms_flag,
x_override_exist_ant_data_flag => l_inst_appln_setup.override_exist_ant_data_flag,
x_required_flag => l_inst_appln_setup.required_flag,
x_minimum_value_num => l_inst_appln_setup.minimum_value_num,
x_maximum_value_num => l_inst_appln_setup.maximum_value_num,
x_minimum_date => l_inst_appln_setup.minimum_date,
x_maximium_date => l_inst_appln_setup.maximium_date,
x_lookup_code => l_inst_appln_setup.lookup_code,
x_hint_txt => l_inst_appln_setup.hint_txt
);
SELECT sc_cal_type,
sc_sequence_number,
sc_alternate_code
FROM igf_aw_cal_rel_v
WHERE cr_cal_type = cp_frm_cal_type
AND cr_sequence_number = cp_frm_sequence_number
AND NVL(active,'N') = 'Y';