Long running SQL query begin fndcp_tmsrv.read_message in Database
Hi,
begin fndcp_tmsrv.read_message(:ec, :to, :typ, :enddt, :rid, :retid, :nl, :nc, :dl, :secgrp, :usr, :rspap, :rsp, :log, :app, :prg, :argc, :orgt, :orgid, :a1, :a2, :a3, :a4, :a5, :a6, :a7, :a8, :a9, :a10, :a11, :a12, :a13, :a14, :a15, :a16, :a17, :a18, :a19, :a20); end;
Insert into FND_CRM_HISTORY (requests_examined, requests_standby, requests_released, requests_returned, work_start, work_end) (Select :exmd, :stby, :rels, :retd, Decode(Work_Start,NULL, Sysdate, Work_Start), Decode(Work_End,NULL, Sysdate, Work_End) from Fnd_Concurrent_Queues WHERE Application_ID = 0 AND Concurrent_Queue_Id = 4)
begin WF_EVENT.setNavigationParams ( p_agentName => :1, p_navigationThreshold => :2 ); WF_EVENT.LISTEN ( p_agent_name =>