APPS.IGS_EN_LGCY_PRC dependencies on FND_APPLICATION

Line 394: CURSOR c_msg_text_num (cp_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE ,

390: || smaddali 19-oct-04 Modified this procedure for bug#3930425, performance issue with cursor c_msg_text_num
391: ------------------------------------------------------------------------------*/
392:
393: --smaddali: bug#3930425, modified this cursor for performance, to be based on appl_id and message_name as this is the PK
394: CURSOR c_msg_text_num (cp_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE ,
395: cp_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE) IS
396: SELECT message_number
397: FROM FND_NEW_MESSAGES msg ,fnd_application apl
398: WHERE apl.application_id = msg.application_id

Line 397: FROM FND_NEW_MESSAGES msg ,fnd_application apl

393: --smaddali: bug#3930425, modified this cursor for performance, to be based on appl_id and message_name as this is the PK
394: CURSOR c_msg_text_num (cp_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE ,
395: cp_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE) IS
396: SELECT message_number
397: FROM FND_NEW_MESSAGES msg ,fnd_application apl
398: WHERE apl.application_id = msg.application_id
399: AND apl.application_short_name = cp_appl_name
400: AND message_name = cp_message_name;
401:

Line 406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;

402: l_msg_count NUMBER(4);
403: l_msg_data VARCHAR2(4000);
404: l_enc_msg VARCHAR2(2000);
405: l_msg_index NUMBER(4);
406: l_appl_name FND_APPLICATION.APPLICATION_SHORT_NAME%TYPE;
407: l_msg_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
408: l_msg_number FND_NEW_MESSAGES.MESSAGE_NUMBER%TYPE;
409: l_msg_text FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
410: l_err_msg_id igs_en_lgcy_err_int.err_message_id%TYPE;