Main plsql function is not working in custom subscription
hi All,
We have a have custom subscription under which we have attached our plsql function.
There are scenarios where we have observed that if there are 6 lines in a sales order only 2 are getting processed. So we added two insert statements right above and below where main is called and got to know about this issue.
Can anyone guide why this is happening and better ways to debug it?
create or replace PACKAGE BODY "GEPS_ONT_SMAX_INT_PKG" IS
FUNCTION co_subscription (
p_subscription_guid IN RAW,
p_event IN OUT wf_event_t
)
RETURN VARCHAR2
AS
ln_header_id NUMBER;