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_ISIR_IMP_PROC dependencies on IGF_LOOKUPS_VIEW

Line 522: l_error igf_lookups_view.meaning%TYPE ;

518:
519: l_cps_int_data_rec c_cps_int_data%rowtype;
520: l_blank VARCHAR2(30) := ' ' ;
521: l_debug_str VARCHAR2(4000) := NULL;
522: l_error igf_lookups_view.meaning%TYPE ;
523: l_cps_log VARCHAR2(1) ;
524: g_import_type VARCHAR2(1);
525: g_sys_award_year igf_ap_batch_aw_map.sys_award_year%TYPE ;
526:

Line 1712: l_yes_no igf_lookups_view.meaning%TYPE ;

1708: l_lkup_code VARCHAR2(60) ;
1709: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
1710: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
1711: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
1712: l_yes_no igf_lookups_view.meaning%TYPE ;
1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

Line 1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;

1709: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;
1710: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
1711: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
1712: l_yes_no igf_lookups_view.meaning%TYPE ;
1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
1717:

Line 1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;

1710: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;
1711: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
1712: l_yes_no igf_lookups_view.meaning%TYPE ;
1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
1717:
1718: BEGIN -- begin log parameters

Line 1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;

1711: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;
1712: l_yes_no igf_lookups_view.meaning%TYPE ;
1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
1717:
1718: BEGIN -- begin log parameters
1719:

Line 1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;

1712: l_yes_no igf_lookups_view.meaning%TYPE ;
1713: l_award_year_pmpt igf_lookups_view.meaning%TYPE ;
1714: l_params_pass_prmpt igf_lookups_view.meaning%TYPE ;
1715: l_person_number_prmpt igf_lookups_view.meaning%TYPE ;
1716: l_batch_num_prmpt igf_lookups_view.meaning%TYPE ;
1717:
1718: BEGIN -- begin log parameters
1719:
1720: -- get the batch description

Line 3129: FROM igf_lookups_view

3125: CURSOR c_meaning(p_lookup_code VARCHAR2,
3126: p_lookup_type VARCHAR2)
3127: IS
3128: SELECT meaning
3129: FROM igf_lookups_view
3130: WHERE lookup_code=p_lookup_code
3131: AND lookup_type = p_lookup_type
3132: AND enabled_flag = 'Y' ;
3133: c_meaning_rec c_meaning%ROWTYPE;

Line 3265: FROM igf_lookups_view

3261: */
3262: CURSOR c_lkup_values(p_lookup_code VARCHAR2 )
3263: IS
3264: SELECT meaning
3265: FROM igf_lookups_view
3266: WHERE lookup_type ='IGF_AW_LOOKUPS_MSG'
3267: AND lookup_code =p_lookup_code
3268: AND enabled_flag = 'Y' ;
3269: