[Home] [Help]
164: *
165: * 24-JUN-2004 V.Ravichandran o Bug 3714636.Modified do_create_cust_acct_site() and
166: * to reduce cost of query
167: * which checks whether the message name in
168: * FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
169: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019. If status is NULL and the corresponding
170: * status is 'A', then warning HZ_ACCT_SITE_INHERIT_STATUS
171: * will not be displayed.
172: * o Rowid and object_version_number in
241: --
242: -- Code modified for Bug 3714636 starts here
243: IF(g_message_name is null) THEN
244: BEGIN
245: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
246: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
247: AND language_code = userenv('LANG')
248: AND application_id = 222
249: AND rownum =1;
608: *
609: * 24-JUN-2004 V.Ravichandran o Bug 3714636.Modified do_update_cust_acct_site()
610: * to reduce cost of query
611: * which checks whether the message name in
612: * FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
613: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019.party_site_id can be null during update.
614: * Therefore read the value of party_site_id from the
615: * database instead of using p_cust_acct_site_rec.party_site_id
616: * for synchronizing the status in HZ_PARTY_SITES.
727: IF p_cust_acct_site_rec.status <> l_status THEN
728: -- Code modified for Bug 3714636 starts here
729: IF(g_message_name is null) THEN
730: BEGIN
731: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
732: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
733: AND language_code = userenv('LANG')
734: AND application_id = 222
735: AND rownum =1;