APPS.POS_SUP_PROF_MRG_GRP dependencies on AK_WEB_USER_SEC_ATTR_VALUES

Line 84: UPDATE ak_web_user_sec_attr_values ak1 SET ak1.number_value = p_new_vendor_site_id

80: IF (p_new_vendor_site_id <> p_old_vendor_site_id) THEN
81:
82: -- Merge site
83: -- Bugfix#12817586 check for unique constraint violation before while updating
84: UPDATE ak_web_user_sec_attr_values ak1 SET ak1.number_value = p_new_vendor_site_id
85: WHERE ak1.attribute_code = 'ICX_SUPPLIER_SITE_ID' AND ak1.attribute_application_id = 177
86: AND ak1.number_value = p_old_vendor_site_id
87: AND NOT EXISTS
88: (SELECT 'DUPLICATE'

Line 89: FROM ak_web_user_sec_attr_values ak2

85: WHERE ak1.attribute_code = 'ICX_SUPPLIER_SITE_ID' AND ak1.attribute_application_id = 177
86: AND ak1.number_value = p_old_vendor_site_id
87: AND NOT EXISTS
88: (SELECT 'DUPLICATE'
89: FROM ak_web_user_sec_attr_values ak2
90: WHERE ak2.web_user_id = ak1.web_user_id
91: AND ak2.attribute_code = 'ICX_SUPPLIER_SITE_ID'
92: AND ak2.attribute_application_id = 177
93: AND ak2.number_value = p_new_vendor_site_id

Line 98: UPDATE ak_web_user_sec_attr_values

94: );
95: --End bugfix#12817586
96: -- If it is the last site then merge vendor
97: IF (l_num_active_sites = 0) THEN
98: UPDATE ak_web_user_sec_attr_values
99: SET number_value = p_new_vendor_id
100: WHERE attribute_code = 'ICX_SUPPLIER_ORG_ID'
101: AND attribute_application_id = 177
102: AND number_value = p_old_vendor_id;