Workflow function
Does any one have PL/SQL Function example on how to change the 'Performer Value' based on the
requisition inventory_org.
Function pseudo code logic:
select max('Y') from PO_REQUISITION_LINES_all where requisition_header_id = :wf_to_pass and destination_organiation_id in ( 47,48,52 )
then PO_REQ_APPROVED ( Performer Value: 'Role for requisition approved notification_2'
else PO_REQ_APPROVED ( Performer Value: 'Role for requisition approved notification'; -- This attribute is already created in the workflow and available in the list of value of performer value.
MC0wMDAwMDAwMDAwMDAvYXR0YWNobWVudC5vdXRsb29rLmxpdmUubmV0QDg0ZGY5ZTdmLWU5ZjYtNDBhZi1iNDM1LWFhYWFhYWFhYWFhYSJ9.Rq1QTlPvuwFWNPCxwsWMi6TEiUjU1WELw1KvhCxDs1zb44EfIGZ_DOpy50gnXjZr5g1zEePDhytACaAa8GFCXoTPyJ_nnHNEYICStMYyiDolEjvh3IXqZGtlDSFS8pizzgtvXd_UMq4_J9w_9i3LPTI4R4haiUKrqON_tejyB8K1_u7AQGZ-Xt1tmYlNE2gh8dmfDAfGWmfQ-nOL_y7Nl9WW8AXLvI6JKZLpQ-2CI-k7kud8srZt1tVkxFM9uS_CshSViw6D9Q__WNpk7P83FxZuAQhoaXEZvrKzr0OUKgxISbMdO-9YsNKlJruPnr3TH40fcmPu4p2TBjtxMVtmAg&animation=true" loading="lazy" srcset="https://us.v-cdn.net/cdn-cgi/image/quality=80,format=auto,fit=scale-down,height=300,width=300/https://attachment.outlook.live.net/owa/raomanchi@hotmail.com/service.svc/s/GetAttachmentThumbnail?id=AQMkADAwATE2ZTIwLWZhY2UtNmMzZS0wMAItMDAKAEYAAANcdtsWLyE8Q4ONMRsrNFB%2FBwA1C7%2FU7MazRJrryjILAdKwAAACAQwAAAA1C7%2FU7MazRJrryjILAdKwAAQCBQaKAAAAARIAEACtP9ch6v3pRK9pMR%2F5yngZ&thumbnailType=2&owa=outlook.live.com&scriptVer=2020022303.09&isc=1&X-OWA-CANARY=8e-5oF-0m0SWXSi3EZ3kTSDI8lscvdcY4kBhH6MMNI3SisZOLSBbSb4PnuE3m1QZtlNjGyZ6hDM.&token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjU2MzU4ODUyMzRCOTI1MkRERTAwNTc2NkQ5RDlGMjc2NTY1RjYzRTIiLCJ4NXQiOiJWaldJVWpTNUpTM2VBRmRtMmRueWRsWmZZLUkiLCJ0eXAiOiJKV1QifQ.eyJvcmlnaW4iOiJodHRwczovL291dGxvb2subGl2ZS5jb20iLCJ2ZXIiOiJFeGNoYW5nZS5DYWxsYmFjay5WMSIsImFwcGN0eHNlbmRlciI6Ik93YURvd25sb2FkQDg0ZGY5ZTdmLWU5ZjYtNDBhZi1iNDM1LWFhYWFhYWFhYWFhYSIsImlzc3JpbmciOiJXVyIsImFwcGN0eCI6IntcIm1zZXhjaHByb3RcIjpcIm93YVwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTI4MjctOTM3MjgtNDIwNzgzMjEyNlwiLFwicHVpZFwiOlwiNDAyNTYyOTAyNTUxNjE0XCIsXCJvaWRcIjpcIjAwMDE2ZTIwLWZhY2UtNmMzZS0wMDAwLTAwMDAwMDAwMDAwMFwiLFwic2NvcGVcIjpcIk93YURvd25sb2FkXCJ9IiwibmJmIjoxNTgyOTgzMjE1LCJleHAiOjE1ODI5ODM4MTUsImlzcyI6IjAwMDAwMDAyLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMEA4NGRmOWU3Zi1lOWY2LTQwYWYtYjQzNS1hYWFhYWFhYWFhYWEiLCJhdWQiOiIwMDAwMDAwMi0wMDAwLTBmZjEtY2Uw