DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_V2PUB dependencies on FND_NEW_MESSAGES

Line 934: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES

930: IF p_party_site_rec.status <> db_status THEN
931: -- Code modified for Bug 3714636 starts here
932: IF(g_message_name is null) THEN
933: BEGIN
934: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
935: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
936: AND language_code = userenv('LANG')
937: AND application_id = 222
938: AND rownum =1;

Line 2171: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES

2167: IF l_party_site_rec.status <> l_old_party_site_rec.status THEN
2168: -- Code modified for Bug 3714636 starts here
2169: IF(g_message_name is null) THEN
2170: BEGIN
2171: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
2172: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
2173: AND language_code = userenv('LANG')
2174: AND application_id = 222
2175: AND rownum =1;