APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on FND_NEW_MESSAGES

Line 186: l_c_message_name fnd_new_messages.message_name%TYPE;

182: AND approved_ind='Y'
183: AND unit_cd=cp_unit_cd
184: AND version_number=cp_version_number;
185: l_c_var VARCHAR2(1);
186: l_c_message_name fnd_new_messages.message_name%TYPE;
187: l_func_name VARCHAR2(50) := 'UNIT_VERSION_LGCY';
188:
189: TYPE c_ref_cur IS REF CURSOR;
190: c_org_cur c_ref_cur;

Line 1746: l_message_name fnd_new_messages.message_name%TYPE;

1742: FROM igs_ps_unit_ofr_opt_all
1743: WHERE
1744: uoo_id = cp_uoo_id ;
1745: rec_usec_dates c_usec_dates%ROWTYPE;
1746: l_message_name fnd_new_messages.message_name%TYPE;
1747: --
1748: CURSOR c_room_id(cp_bld_id IN NUMBER, cp_rom_id IN NUMBER) IS
1749: SELECT 'X'
1750: FROM igs_ad_room

Line 3619: FROM fnd_new_messages

3615: AND ROWNUM < 2;
3616:
3617: CURSOR c_null IS
3618: SELECT message_text
3619: FROM fnd_new_messages
3620: WHERE message_name = 'IGS_PS_NULL'
3621: AND application_id = 8405
3622: AND LANGUAGE_CODE = USERENV('LANG');
3623:

Line 3624: l_c_null fnd_new_messages.message_text%TYPE;

3620: WHERE message_name = 'IGS_PS_NULL'
3621: AND application_id = 8405
3622: AND LANGUAGE_CODE = USERENV('LANG');
3623:
3624: l_c_null fnd_new_messages.message_text%TYPE;
3625:
3626: l_n_count NUMBER;
3627: l_n_from NUMBER;
3628: l_n_to NUMBER;