132: set VENDOR_ID = p_vendor_id
133: where VENDOR_ID = p_dup_vendor_id;
134:
135: -- **********************************************************
136: -- Updating FA_INS_MST_POLS : VENDOR_ID, VENDOR_SITE_ID
137: -- **********************************************************
138: l_location := 'FA_INS_MST_POLS';
139: update FA_INS_MST_POLS
140: set VENDOR_ID = p_vendor_id
134:
135: -- **********************************************************
136: -- Updating FA_INS_MST_POLS : VENDOR_ID, VENDOR_SITE_ID
137: -- **********************************************************
138: l_location := 'FA_INS_MST_POLS';
139: update FA_INS_MST_POLS
140: set VENDOR_ID = p_vendor_id
141: , VENDOR_SITE_ID = decode(VENDOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, VENDOR_SITE_ID)
142: where VENDOR_ID = p_dup_vendor_id
135: -- **********************************************************
136: -- Updating FA_INS_MST_POLS : VENDOR_ID, VENDOR_SITE_ID
137: -- **********************************************************
138: l_location := 'FA_INS_MST_POLS';
139: update FA_INS_MST_POLS
140: set VENDOR_ID = p_vendor_id
141: , VENDOR_SITE_ID = decode(VENDOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, VENDOR_SITE_ID)
142: where VENDOR_ID = p_dup_vendor_id
143: and nvl(VENDOR_SITE_ID, 0) = decode(VENDOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);