11.5.10 Script to load Attachments as URL

Dear All

I have a third party system that have PDF's and XML AP invoices images.Therefore I was wondering how I can insert the URL as an attachments to each invoice in Oracle AP.

I have the following example, however I was wondering if you can share with me any ideas.

Please advise

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

declare
l_rowid rowid;
l_attached_document_id number;
l_document_id number;
l_media_id number;
l_category_id number := 291; -- Invoice Internal
l_pk1_value fnd_attached_documents.pk1_value%TYPE := '63227';
l_description fnd_documents_tl.description%TYPE   := 'Gareth Document Attach Demo';