294: g_upd_awd_notif_status VARCHAR2(30);
295: g_verif_stat VARCHAR2(10);
296: -- g_sf_packaging VARCHAR2(1) := 'F';
297: g_sf_packaging VARCHAR2(1);
298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;
299: g_fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE;
300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;
302: g_sf_fund igf_aw_fund_mast_all.fund_id%TYPE;
13021: --
13022: --Change History:
13023: --Who When What
13024: -------------------------------------------------------------------
13025: l_param_pass_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13022: --Change History:
13023: --Who When What
13024: -------------------------------------------------------------------
13025: l_param_pass_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13023: --Who When What
13024: -------------------------------------------------------------------
13025: l_param_pass_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13024: -------------------------------------------------------------------
13025: l_param_pass_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13025: l_param_pass_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13026: l_awd_yr_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13027: l_pers_number_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13028: l_pers_id_grp_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13029: l_ap_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13030: l_fund_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13031: l_dp_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13032: l_sf_min_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13040: l_publish_log igf_lookups_view.meaning%TYPE ;
13033: l_sf_max_log igf_lookups_view.meaning%TYPE ;
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13040: l_publish_log igf_lookups_view.meaning%TYPE ;
13041:
13034: l_allow_log igf_lookups_view.meaning%TYPE ;
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13040: l_publish_log igf_lookups_view.meaning%TYPE ;
13041:
13042: -- Get alternate code
13035: l_notif_log igf_lookups_view.meaning%TYPE ;
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13040: l_publish_log igf_lookups_view.meaning%TYPE ;
13041:
13042: -- Get alternate code
13043: CURSOR c_alternate_code(
13036: l_lock_log igf_lookups_view.meaning%TYPE ;
13037: l_agrp_log igf_lookups_view.meaning%TYPE ;
13038: l_sim_log igf_lookups_view.meaning%TYPE ;
13039: l_runm_log igf_lookups_view.meaning%TYPE ;
13040: l_publish_log igf_lookups_view.meaning%TYPE ;
13041:
13042: -- Get alternate code
13043: CURSOR c_alternate_code(
13044: cp_award_year VARCHAR2