PR Date Assigned To Buyers

Hello Experts,

I created a custom trigger in PO_REQUISITION_LINES_ALL, the trigger will check if the buyer is not null then stores the value of the suggested_buyer_id, sysdate to a custom table. The sysdate insert will be the "assigned date" to the buyer.

In PO creation, some of our PR Assigned date is greater than the PO creation. PR Assigned date should be earlier than the PO creation date.

Have attached the trigger I created and hopefully could get some inputs on why the PR Date is Greater than the PO creation date.

Thanks in advance...Wilbert