178: , VENDOR_NUMBER = decode(VENDOR_NUMBER, NULL, NULL, p_segment1)
179: where VENDOR_ID = p_dup_vendor_id;
180:
181: -- **********************************************************
182: -- Updating FA_WARRANTIES : PO_VENDOR_ID
183: -- **********************************************************
184: l_location := 'FA_WARRANTIES';
185: update FA_WARRANTIES
186: set PO_VENDOR_ID = p_vendor_id
180:
181: -- **********************************************************
182: -- Updating FA_WARRANTIES : PO_VENDOR_ID
183: -- **********************************************************
184: l_location := 'FA_WARRANTIES';
185: update FA_WARRANTIES
186: set PO_VENDOR_ID = p_vendor_id
187: where PO_VENDOR_ID = p_dup_vendor_id;
188:
181: -- **********************************************************
182: -- Updating FA_WARRANTIES : PO_VENDOR_ID
183: -- **********************************************************
184: l_location := 'FA_WARRANTIES';
185: update FA_WARRANTIES
186: set PO_VENDOR_ID = p_vendor_id
187: where PO_VENDOR_ID = p_dup_vendor_id;
188:
189: -- **********************************************************