DECLARE
l_entity_name VARCHAR2 (20) := 'AR INVOICE IMAGE';
-- l_pk1_value VARCHAR2 (20) := '200487';
l_delete_document_flag VARCHAR2 (1) := 'Y';
CURSOR c1
IS
SELECT CUSTOMER_TRX_ID
FROM ra_customer_trx_all
WHERE TRUNC (CREATION_DATE) >= (SYSDATE - 51)
AND org_id=1;
BEGIN
FOR c1_rec IN c1
LOOP
fnd_attached_documents2_pkg.delete_attachments (
X_entity_name => l_entity_name,
X_pk1_value => c1_rec.CUSTOMER_TRX_ID,
X_delete_document_flag => l_delete_document_flag);
END LOOP;
Commit;
END;
Such as very important information for this one and i like these kind of information.Thank you sharing that valuable information.
ReplyDeletehtml5 training in chennai
Thank you for sharing such a nice story with us. I really enjoyed very much And please keep updating like this with this site.
ReplyDeletedigital marketing training Chennai
Helpful script, Keep up good work Kadiyala... :)
ReplyDelete