APPS.IGF_AP_LG_COA_IMP dependencies on IGF_LOOKUPS_VIEW

Line 39: l_yes_no igf_lookups_view.meaning%TYPE ;

35: l_lkup_code VARCHAR2(60) ;
36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

Line 40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

36: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
44: l_error igf_lookups_view.meaning%TYPE ;

Line 41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

37: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
44: l_error igf_lookups_view.meaning%TYPE ;
45:

Line 42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;

38: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
44: l_error igf_lookups_view.meaning%TYPE ;
45:
46: BEGIN -- begin log parameters

Line 43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

39: l_yes_no igf_lookups_view.meaning%TYPE ;
40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
44: l_error igf_lookups_view.meaning%TYPE ;
45:
46: BEGIN -- begin log parameters
47:

Line 44: l_error igf_lookups_view.meaning%TYPE ;

40: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
41: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
42: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
43: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
44: l_error igf_lookups_view.meaning%TYPE ;
45:
46: BEGIN -- begin log parameters
47:
48: -- get the batch description

Line 454: l_error igf_lookups_view.meaning%TYPE ;

450: l_dup_item_found BOOLEAN;
451: l_dup_coa_found BOOLEAN;
452: l_per_terms_match BOOLEAN;
453: l_oss_terms_match BOOLEAN;
454: l_error igf_lookups_view.meaning%TYPE ;
455: l_person_number igf_lookups_view.meaning%TYPE ;
456: l_token VARCHAR2(60) ;
457: l_item_amount igf_aw_coa_items.amount%TYPE := 0;
458: lv_rowid ROWID ;

Line 455: l_person_number igf_lookups_view.meaning%TYPE ;

451: l_dup_coa_found BOOLEAN;
452: l_per_terms_match BOOLEAN;
453: l_oss_terms_match BOOLEAN;
454: l_error igf_lookups_view.meaning%TYPE ;
455: l_person_number igf_lookups_view.meaning%TYPE ;
456: l_token VARCHAR2(60) ;
457: l_item_amount igf_aw_coa_items.amount%TYPE := 0;
458: lv_rowid ROWID ;
459: lv_term_rowid ROWID ;