eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGF_LOOKUPS_VIEW

Line 2989: l_yes_no igf_lookups_view.meaning%TYPE ;

2985: l_lkup_code VARCHAR2(60) ;
2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

Line 2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
2994: l_error igf_lookups_view.meaning%TYPE ;

Line 2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

2987: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
2994: l_error igf_lookups_view.meaning%TYPE ;
2995:

Line 2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;

2988: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
2994: l_error igf_lookups_view.meaning%TYPE ;
2995:
2996: BEGIN -- begin log parameters

Line 2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

2989: l_yes_no igf_lookups_view.meaning%TYPE ;
2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
2994: l_error igf_lookups_view.meaning%TYPE ;
2995:
2996: BEGIN -- begin log parameters
2997:

Line 2994: l_error igf_lookups_view.meaning%TYPE ;

2990: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
2991: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
2992: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
2993: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
2994: l_error igf_lookups_view.meaning%TYPE ;
2995:
2996: BEGIN -- begin log parameters
2997:
2998: -- get the batch description

Line 3140: FROM igf_lookups_view

3136: CURSOR c_meaning(p_lookup_code VARCHAR2,
3137: p_lookup_type VARCHAR2)
3138: IS
3139: SELECT meaning
3140: FROM igf_lookups_view
3141: WHERE lookup_code=p_lookup_code
3142: AND lookup_type = p_lookup_type
3143: AND enabled_flag = 'Y' ;
3144:

Line 3177: FROM igf_lookups_view

3173: || (reverse chronological order - newest change first)
3174: */
3175: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )IS
3176: SELECT meaning
3177: FROM igf_lookups_view
3178: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
3179: AND lookup_code =p_lookup_code
3180: AND enabled_flag = 'Y' ;
3181: