DBA Data[Home] [Help]

APPS.HZ_PARTY_SITE_V2PUB dependencies on FND_NEW_MESSAGES

Line 930: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES

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

Line 2164: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES

2160: IF l_party_site_rec.status <> l_old_party_site_rec.status THEN
2161: -- Code modified for Bug 3714636 starts here
2162: IF(g_message_name is null) THEN
2163: BEGIN
2164: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
2165: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
2166: AND language_code = userenv('LANG')
2167: AND application_id = 222
2168: AND rownum =1;