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_AP_LI_BAT_INTS

Line 1693: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints

1689: || Who When What
1690: || (reverse chronological order - newest change first)
1691: */
1692:
1693: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
1694: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
1695: SELECT batch_desc, batch_type
1696: FROM igf_ap_li_bat_ints
1697: WHERE batch_num = cp_batch_num ;

Line 1696: FROM igf_ap_li_bat_ints

1692:
1693: -- cursor to get batch desc for the batch id from igf_ap_li_bat_ints
1694: CURSOR c_batch_desc(cp_batch_num igf_aw_li_coa_ints.batch_num%TYPE ) IS
1695: SELECT batch_desc, batch_type
1696: FROM igf_ap_li_bat_ints
1697: WHERE batch_num = cp_batch_num ;
1698:
1699: -- cursor for getting the message from fnd_new_messages
1700: CURSOR c_get_message(cp_message_name VARCHAR2) IS

Line 1709: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;

1705: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
1706:
1707: l_lkup_type VARCHAR2(60) ;
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 ;

Line 1710: l_batch_type igf_ap_li_bat_ints.batch_type%TYPE ;

1706:
1707: l_lkup_type VARCHAR2(60) ;
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 ;

Line 1711: l_batch_id igf_ap_li_bat_ints.batch_type%TYPE ;

1707: l_lkup_type VARCHAR2(60) ;
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 ;