APPS.IGF_AP_LG_VER_IMP dependencies on IGF_LOOKUPS_VIEW

Line 52: l_yes_no igf_lookups_view.meaning%TYPE ;

48: l_lkup_code VARCHAR2(60) ;
49: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
50: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
51: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
52: l_yes_no igf_lookups_view.meaning%TYPE ;
53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

Line 53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

49: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
50: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
51: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
52: l_yes_no igf_lookups_view.meaning%TYPE ;
53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
57: l_error igf_lookups_view.meaning%TYPE ;

Line 54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

50: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
51: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
52: l_yes_no igf_lookups_view.meaning%TYPE ;
53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
57: l_error igf_lookups_view.meaning%TYPE ;
58:

Line 55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;

51: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
52: l_yes_no igf_lookups_view.meaning%TYPE ;
53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
57: l_error igf_lookups_view.meaning%TYPE ;
58:
59: BEGIN -- begin log parameters

Line 56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

52: l_yes_no igf_lookups_view.meaning%TYPE ;
53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
57: l_error igf_lookups_view.meaning%TYPE ;
58:
59: BEGIN -- begin log parameters
60:

Line 57: l_error igf_lookups_view.meaning%TYPE ;

53: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
54: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
55: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
56: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
57: l_error igf_lookups_view.meaning%TYPE ;
58:
59: BEGIN -- begin log parameters
60:
61: -- get the batch description

Line 446: l_error igf_lookups_view.meaning%TYPE ;

442: l_person_id igf_ap_fa_base_rec.person_id%TYPE;
443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;
446: l_error igf_lookups_view.meaning%TYPE ;
447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;
449: l_corr_exist BOOLEAN ;
450: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;

Line 447: l_person_number igf_lookups_view.meaning%TYPE ;

443: l_dup_item_found BOOLEAN;
444: l_pay_isir_id igf_ap_isir_matched.isir_id%TYPE ;
445: l_act_isir_id igf_ap_isir_matched.isir_id%TYPE ;
446: l_error igf_lookups_view.meaning%TYPE ;
447: l_person_number igf_lookups_view.meaning%TYPE ;
448: l_token VARCHAR2(60) ;
449: l_corr_exist BOOLEAN ;
450: l_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;
451: l_new_fed_verif_status igf_ap_fa_base_rec_all.fed_verif_status%TYPE ;