222: set PO_VENDOR_ID = p_vendor_id
223: where PO_VENDOR_ID = p_dup_vendor_id;
224:
225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)
224:
225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)
231: , LESSOR_ID = decode(LESSOR_ID, p_dup_vendor_id, p_vendor_id, LESSOR_ID)
232: , VENDOR_NUMBER = decode(PO_VENDOR_ID, p_dup_vendor_id,
225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)
231: , LESSOR_ID = decode(LESSOR_ID, p_dup_vendor_id, p_vendor_id, LESSOR_ID)
232: , VENDOR_NUMBER = decode(PO_VENDOR_ID, p_dup_vendor_id,
233: decode(VENDOR_NUMBER, NULL, NULL, p_segment1),