DBA Data[Home] [Help]

APPS.IGF_AW_PACKAGING dependencies on IGF_LOOKUPS_VIEW

Line 298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;

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;

Line 13025: l_param_pass_log igf_lookups_view.meaning%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 ;

Line 13026: l_awd_yr_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 ;

Line 13027: l_pers_number_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 ;

Line 13028: l_pers_id_grp_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 ;

Line 13029: l_ap_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 ;

Line 13030: l_fund_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 ;

Line 13031: l_dp_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 ;

Line 13032: l_sf_min_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 ;

Line 13033: l_sf_max_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 ;

Line 13034: l_allow_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 ;

Line 13035: l_notif_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 ;

Line 13036: l_lock_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 ;

Line 13037: l_agrp_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:

Line 13038: l_sim_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:
13042: -- Get alternate code

Line 13039: l_runm_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
13043: CURSOR c_alternate_code(

Line 13040: l_publish_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(
13044: cp_award_year VARCHAR2