67: FND_MSG_PUB.Add;
68:
69:
70:
71: -- modify CHV_CUM_ADJUSTMENTS
72: UPDATE CHV_CUM_ADJUSTMENTS
73: SET vendor_id = p_vendor_id,
74: vendor_site_id = p_vendor_site_id
75: WHERE vendor_id = p_dup_vendor_id
68:
69:
70:
71: -- modify CHV_CUM_ADJUSTMENTS
72: UPDATE CHV_CUM_ADJUSTMENTS
73: SET vendor_id = p_vendor_id,
74: vendor_site_id = p_vendor_site_id
75: WHERE vendor_id = p_dup_vendor_id
76: AND vendor_site_id = p_dup_vendor_site_id ;
75: WHERE vendor_id = p_dup_vendor_id
76: AND vendor_site_id = p_dup_vendor_site_id ;
77:
78: -- Prepare message name
79: FND_MESSAGE.SET_NAME('CHV','CHV_CUM_ADJUSTMENTS');
80: IF SQL%FOUND THEN
81: x_return_status := FND_API.G_RET_STS_SUCCESS;
82: l_row_count := SQL%ROWCOUNT;
83: ELSE