[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;
687: *
688: * 24-JUN-2004 V.Ravichandran o Bug 3714636.Modified do_update_cust_acct_site()
689: * to reduce cost of query
690: * which checks whether the message name in
691: * FND_NEW_MESSAGES is 'HZ_INACTIVATE_ACCOUNT_SITE_UI'.
692: * 02-AUG-2004 Rajib Ranjan Borah o Bug 3805019.party_site_id can be null during update.
693: * Therefore read the value of party_site_id from the
694: * database instead of using p_cust_acct_site_rec.party_site_id
695: * for synchronizing the status in HZ_PARTY_SITES.
806: IF p_cust_acct_site_rec.status <> l_status THEN
807: -- Code modified for Bug 3714636 starts here
808: IF(g_message_name is null) THEN
809: BEGIN
810: SELECT 'X' into g_message_name FROM FND_NEW_MESSAGES
811: WHERE message_name = 'HZ_INACTIVATE_ACCOUNT_SITE_UI'
812: AND language_code = userenv('LANG')
813: AND application_id = 222
814: AND rownum =1;