APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on FND_NEW_MESSAGES

Line 1699: -- cursor for getting the message from fnd_new_messages

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
1701: SELECT message_text
1702: FROM fnd_new_messages
1703: WHERE message_name = cp_message_name;

Line 1702: FROM fnd_new_messages

1698:
1699: -- cursor for getting the message from fnd_new_messages
1700: CURSOR c_get_message(cp_message_name VARCHAR2) IS
1701: SELECT message_text
1702: FROM fnd_new_messages
1703: WHERE message_name = cp_message_name;
1704:
1705: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;
1706:

Line 1705: l_delete_flag_prmpt fnd_new_messages.message_text%TYPE;

1701: SELECT message_text
1702: FROM fnd_new_messages
1703: WHERE message_name = cp_message_name;
1704:
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 ;