APPS.CCT_ROUTINGWORKFLOW_UTL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

   select lookup_code into l_result_code
   from   wf_lookups
   where  lookup_type = p_result_lookup_type
   and    meaning     = p_result_display_name;

Line: 41

PROCEDURE InsertResults (
      p_call_ID       IN      VARCHAR2
      , p_filter_type   IN      VARCHAR2
      , p_agent_ID     IN  out nocopy   VARCHAR2
)  IS

  l_dummyAgent  VARCHAR2(32) := '-1';

Line: 51

   insert into CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	tempagnet_id,last_update_date,last_updated_by,creation_date,
	created_by)
       values (p_call_id, l_dummyAgent, p_filter_type,
	   1001,sysdate,1,sysdate,1);

Line: 58

           INSERT INTO CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	       tempagnet_id,last_update_date,last_updated_by,creation_date,
		  created_by)
           VALUES ( p_call_ID, p_agent_ID, p_filter_type,
	            1002,sysdate,1,sysdate,1);

Line: 67

END INSERTRESULTS;

Line: 80

PROCEDURE InsertResults (
      p_call_ID       IN      VARCHAR2
      , p_filter_type   IN      VARCHAR2
      , p_agents_tbl     IN out nocopy     agent_tbl_type
) IS

  l_dummyAgent  VARCHAR2(32) := '-1';

Line: 90

   insert into CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	tempagnet_id,last_update_date,last_updated_by,creation_date,
	created_by)
       values (p_call_id, l_dummyAgent, p_filter_type,
	   1001,sysdate,1,sysdate,1);

Line: 99

           INSERT INTO CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	       tempagnet_id,last_update_date,last_updated_by,creation_date,
		  created_by)
           VALUES ( p_call_ID, p_agents_tbl(i), p_filter_type,
	            1002,sysdate,1,sysdate,1);

Line: 110

END INSERTRESULTS;

Line: 122

PROCEDURE InsertResults (
      p_call_ID       IN      VARCHAR2
      , p_filter_type   IN      VARCHAR2
      , p_agents_tbl     IN out nocopy      CS_ROUTING_UTL.emp_tbl_type
) IS
  l_dummyAgent  VARCHAR2(32) := '-1';

Line: 131

   insert into CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	tempagnet_id,last_update_date,last_updated_by,creation_date,
	created_by)
       values (p_call_id, l_dummyAgent, p_filter_type,
	   1001,sysdate,1,sysdate,1);

Line: 140

           INSERT INTO CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	       tempagnet_id,last_update_date,last_updated_by,creation_date,
		  created_by)
           VALUES ( p_call_ID, p_agents_tbl(i), p_filter_type,
	            1002,sysdate,1,sysdate,1);

Line: 151

END INSERTResults;

Line: 163

PROCEDURE InsertResults (
      p_call_ID       IN      VARCHAR2
      , p_filter_type   IN      VARCHAR2
      , p_agents_tbl     IN out nocopy JTF_TERRITORY_PUB.WinningTerrMember_tbl_type
) IS
  l_dummyAgent  VARCHAR2(32) := '-1';

Line: 172

   insert into CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	tempagnet_id,last_update_date,last_updated_by,creation_date,
	created_by)
       values (p_call_id, l_dummyAgent, p_filter_type,
	   1001,sysdate,1,sysdate,1);

Line: 181

           INSERT INTO CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	       tempagnet_id,last_update_date,last_updated_by,creation_date,
		  created_by)
           VALUES ( p_call_ID, p_agents_tbl(i).RESOURCE_ID, p_filter_type,
	            1002,sysdate,1,sysdate,1);

Line: 192

END INSERTResults;

Line: 203

PROCEDURE InsertResults (
      p_call_ID          IN      VARCHAR2
      , p_filter_type    IN      VARCHAR2
      , p_agents_tbl     IN out nocopy  AST_Routing_PUB.resource_access_tbl_type
) IS
  l_dummyAgent  VARCHAR2(32) := '-1';

Line: 212

   insert into CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	tempagnet_id,last_update_date,last_updated_by,creation_date,
	created_by)
       values (p_call_id, l_dummyAgent, p_filter_type,
	   1001,sysdate,1,sysdate,1);

Line: 220

           INSERT INTO CCT_TEMPAGENTS (call_id, agent_id, filter_type,
	       tempagnet_id,last_update_date,last_updated_by,creation_date,
		  created_by)
           VALUES ( p_call_ID, p_agents_tbl(i).resource_id, p_filter_type,
	            1002,sysdate,1,sysdate,1);

Line: 231

END INSERTResults;