APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on FND_NEW_MESSAGES

Line 2976: -- CURSOR FOR GETTING THE MESSAGE FROM FND_NEW_MESSAGES

2972: SELECT batch_desc, batch_type
2973: FROM igf_ap_li_bat_ints
2974: WHERE batch_num = cp_batch_num ;
2975:
2976: -- CURSOR FOR GETTING THE MESSAGE FROM FND_NEW_MESSAGES
2977: CURSOR c_get_message(cp_message_name VARCHAR2) IS
2978: SELECT message_text
2979: FROM fnd_new_messages
2980: WHERE message_name = cp_message_name;

Line 2979: FROM fnd_new_messages

2975:
2976: -- CURSOR FOR GETTING THE MESSAGE FROM FND_NEW_MESSAGES
2977: CURSOR c_get_message(cp_message_name VARCHAR2) IS
2978: SELECT message_text
2979: FROM fnd_new_messages
2980: WHERE message_name = cp_message_name;
2981:
2982: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
2983:

Line 2982: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;

2978: SELECT message_text
2979: FROM fnd_new_messages
2980: WHERE message_name = cp_message_name;
2981:
2982: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
2983:
2984: l_lkup_type VARCHAR2(60) ;
2985: l_lkup_code VARCHAR2(60) ;
2986: l_batch_desc igf_ap_li_bat_ints.batch_desc%TYPE ;