DBA Data[Home] [Help]

APPS.CCT_QDE_PUB dependencies on CCT_QDE_AGENT_GLOBAL_LOCK

Line 923: lock table cct_qde_agent_global_lock in exclusive mode;

919: l_hex_agent_index varchar2(2000);
920: BEGIN
921: --dbms_output.put_line('CREATE_AGENT_INDEX:'
922: --|| ' agent_id = ' || p_agent_id);
923: lock table cct_qde_agent_global_lock in exclusive mode;
924: select max(agent_index) into l_max_agent_index
925: from cct_qde_agent;
926: if (l_max_agent_index is null) then
927: l_max_agent_index := -1;