Update Supplier Sites by using interface table-ap_supplier_sites_int

Hi,

I want to update supplier sites. I was not able to do it by using AP_VENDOR_PUB_PKG.Update_Vendor_Site as getting some error and Oracle is not supported this API also.

So I'm using interface table to update the same. I'm populating the following fields in the interface table for an existing supplier site.

                     INSERT INTO ap_supplier_sites_int
                              (
                               vendor_interface_id,
                               vendor_id,
                               vendor_site_code,
                               vendor_site_interface_id,
                               last_update_date,
                               last_updated_by,
                               attribute1,
                               prepay_code_combination_id,
                               org_id,
                               address_line1,
                               country
                               )
                    values
                        (
                          NULL,    --vendor_interface_id,
                          1935,--     vendor_id,