APPS.POS_SUP_PROF_MRG_GRP dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 75: UPDATE ak_web_user_sec_attr_values

71:
72: IF (p_new_vendor_site_id <> p_old_vendor_site_id) THEN
73:
74: -- Merge site
75: UPDATE ak_web_user_sec_attr_values
76: SET number_value = p_new_vendor_site_id
77: WHERE attribute_code = 'ICX_SUPPLIER_SITE_ID'
78: AND attribute_application_id = 177
79: AND number_value = p_old_vendor_site_id;

Line 83: UPDATE ak_web_user_sec_attr_values

79: AND number_value = p_old_vendor_site_id;
80:
81: -- If it is the last site then merge vendor
82: IF (l_num_active_sites = 0) THEN
83: UPDATE ak_web_user_sec_attr_values
84: SET number_value = p_new_vendor_id
85: WHERE attribute_code = 'ICX_SUPPLIER_ORG_ID'
86: AND attribute_application_id = 177
87: AND number_value = p_old_vendor_id;