Peoplecode to Delete Multiple File Attachments

Peoplecode to Delete Multiple File Attachments

Local Rowset &rs1;

&URL_ID = “RECORD://HRS_ATTACHMENTS”;

&rs1 = CreateRowset(Record.HRS_ATTACHMENTS);
&rs1.Fill(“where ATTACHSYSFILENAME like :1”, “%OSGN%”);

For &i = 1 To &rs1.ActiveRowCount
&Value1 = &rs1(&i).HRS_ATTACHMENTS.ATTACHSYSFILENAME.Value;
&return_code = DeleteAttachment(&URL_ID, &Value1);
End-For;

References:
http://www.pscustomizer.com/peoplesoft-examples/attachments/
http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/write-file-into-database-using-sqr-2528747
https://forums.oracle.com/forums/thread.jspa?messageID=10320192
http://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/tpcl/book.htm?File=tpcl/htm/tpcl02.htm#H4541
http://docs.oracle.com/cd/E15645_01/pt850pbr0/eng/psbooks/tpcd/chapter.htm?File=tpcd/htm/tpcd11.htm
http://peoplesoftstuff.blogspot.com/2012/07/upload-file-from-local-to-server.html
http://peoplesoft.ittoolbox.com/groups/technical-functional/peopletools-l/browse-functionality-on-run-control-page-819632