DBA Data[Home] [Help]

APPS.IGS_PE_WF_GEN dependencies on FND_NEW_MESSAGES

Line 974: CURSOR cur_message_text (cp_message_name fnd_new_messages.message_name%TYPE) IS

970: WHERE lookup_type=cp_lookup_type
971: AND lookup_code=cp_lookup_code;
972: l_party_type igs_lookup_values.meaning%TYPE;
973:
974: CURSOR cur_message_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
975: SELECT message_text
976: FROM fnd_new_messages
977: WHERE message_name=cp_message_name
978: AND application_id = 8405

Line 976: FROM fnd_new_messages

972: l_party_type igs_lookup_values.meaning%TYPE;
973:
974: CURSOR cur_message_text (cp_message_name fnd_new_messages.message_name%TYPE) IS
975: SELECT message_text
976: FROM fnd_new_messages
977: WHERE message_name=cp_message_name
978: AND application_id = 8405
979: AND LANGUAGE_CODE = USERENV('LANG');
980: l_message_text fnd_new_messages.message_text%TYPE;

Line 980: l_message_text fnd_new_messages.message_text%TYPE;

976: FROM fnd_new_messages
977: WHERE message_name=cp_message_name
978: AND application_id = 8405
979: AND LANGUAGE_CODE = USERENV('LANG');
980: l_message_text fnd_new_messages.message_text%TYPE;
981:
982: l_c_per_org VARCHAR2(1);
983:
984: BEGIN