[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;