eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CCT_ROUTINGWORKFLOW_PUB dependencies on DBMS_SQL

Line 595: l_select_csr := DBMS_SQL.OPEN_CURSOR;

591:
592:
593: -- now run the select clause using dynamic sql
594: begin
595: l_select_csr := DBMS_SQL.OPEN_CURSOR;
596:
597: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
598: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

Line 597: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);

593: -- now run the select clause using dynamic sql
594: begin
595: l_select_csr := DBMS_SQL.OPEN_CURSOR;
596:
597: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
598: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
600:
601: l_sort_num := 0;

Line 598: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);

594: begin
595: l_select_csr := DBMS_SQL.OPEN_CURSOR;
596:
597: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
598: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
600:
601: l_sort_num := 0;
602: LOOP

Line 599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

595: l_select_csr := DBMS_SQL.OPEN_CURSOR;
596:
597: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
598: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
600:
601: l_sort_num := 0;
602: LOOP
603: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

Line 603: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

599: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
600:
601: l_sort_num := 0;
602: LOOP
603: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
604: EXIT;
605: end if;
606:
607: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

Line 607: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

603: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
604: EXIT;
605: end if;
606:
607: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);
608:
609: -- insert the cursor record into the l_agents_tbl Table
610: l_sort_num := l_sort_num + 1;
611: l_agents_tbl(l_sort_num) := l_agent_ID;

Line 621: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);

617: -- no agents were found
618: -- use any call center agent
619: l_dynamic_select := l_default_select;
620:
621: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
622: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
623: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
624:
625: l_sort_num := 0;

Line 622: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);

618: -- use any call center agent
619: l_dynamic_select := l_default_select;
620:
621: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
622: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
623: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
624:
625: l_sort_num := 0;
626:

Line 623: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

619: l_dynamic_select := l_default_select;
620:
621: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
622: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
623: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
624:
625: l_sort_num := 0;
626:
627: LOOP

Line 628: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

624:
625: l_sort_num := 0;
626:
627: LOOP
628: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
629: EXIT;
630: end if;
631:
632: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

Line 632: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

628: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
629: EXIT;
630: end if;
631:
632: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);
633:
634: -- insert the cursor record into the l_agents_tbl Table
635: l_sort_num := l_sort_num + 1;
636: l_agents_tbl(l_sort_num) := l_agent_ID;

Line 642: DBMS_SQL.CLOSE_CURSOR(l_select_csr);

638: END LOOP;
639: END IF;
640:
641: -- Close the cursor
642: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
643:
644: -- delete the entries for this call from CCT_TEMPAGENTS
645: -- delete the entries for this call from CCT_TEMPAGENTS
646: -- Donot delete if in testmode, then need to explicitly delete this table later

Line 684: DBMS_SQL.CLOSE_CURSOR (l_select_csr);

680: --commit work;
681: exception
682: WHEN OTHERS THEN
683: -- close the cursor
684: DBMS_SQL.CLOSE_CURSOR (l_select_csr);
685: RAISE;
686: end;
687: END IF;
688:

Line 1119: l_select_csr := DBMS_SQL.OPEN_CURSOR;

1115:
1116:
1117: -- now run the select clause using dynamic sql
1118: begin
1119: l_select_csr := DBMS_SQL.OPEN_CURSOR;
1120:
1121: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
1122: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

Line 1121: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);

1117: -- now run the select clause using dynamic sql
1118: begin
1119: l_select_csr := DBMS_SQL.OPEN_CURSOR;
1120:
1121: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
1122: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1124:
1125: l_sort_num := 0;

Line 1122: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);

1118: begin
1119: l_select_csr := DBMS_SQL.OPEN_CURSOR;
1120:
1121: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
1122: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1124:
1125: l_sort_num := 0;
1126: LOOP

Line 1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

1119: l_select_csr := DBMS_SQL.OPEN_CURSOR;
1120:
1121: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.native);
1122: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1124:
1125: l_sort_num := 0;
1126: LOOP
1127: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

Line 1127: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

1123: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1124:
1125: l_sort_num := 0;
1126: LOOP
1127: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
1128: EXIT;
1129: end if;
1130:
1131: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

Line 1131: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

1127: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
1128: EXIT;
1129: end if;
1130:
1131: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);
1132:
1133: -- insert the cursor record into the l_agents_tbl Table
1134: l_sort_num := l_sort_num + 1;
1135: l_agents_tbl(l_sort_num) := l_agent_ID;

Line 1145: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);

1141: -- no agents were found
1142: -- use any call center agent
1143: l_dynamic_select := l_default_select;
1144:
1145: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
1146: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1147: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1148:
1149: l_sort_num := 0;

Line 1146: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);

1142: -- use any call center agent
1143: l_dynamic_select := l_default_select;
1144:
1145: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
1146: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1147: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1148:
1149: l_sort_num := 0;
1150:

Line 1147: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);

1143: l_dynamic_select := l_default_select;
1144:
1145: DBMS_SQL.PARSE(l_select_csr, l_dynamic_select, DBMS_SQL.NATIVE);
1146: DBMS_SQL.DEFINE_COLUMN(l_select_csr, 1, l_agent_ID, 32);
1147: l_dummy := DBMS_SQL.EXECUTE(l_select_csr);
1148:
1149: l_sort_num := 0;
1150:
1151: LOOP

Line 1152: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then

1148:
1149: l_sort_num := 0;
1150:
1151: LOOP
1152: if DBMS_SQL.FETCH_ROWS(l_select_csr) = 0 then
1153: IF l_reroute is NULL THEN
1154: -- If the call is already rerouted once don't reroute again
1155: -- even if no agents found
1156: -- Set Rerouted to Y as this call is about to be rerouted

Line 1172: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);

1168: END IF;
1169: EXIT;
1170: end if;
1171:
1172: DBMS_SQL.COLUMN_VALUE(l_select_csr, 1, l_agent_ID);
1173:
1174: -- insert the cursor record into the l_agents_tbl Table
1175: l_sort_num := l_sort_num + 1;
1176: l_agents_tbl(l_sort_num) := l_agent_ID;

Line 1186: DBMS_SQL.CLOSE_CURSOR(l_select_csr);

1182: resultout := 'COMPLETE:N';
1183: END IF;
1184:
1185: -- Close the cursor
1186: DBMS_SQL.CLOSE_CURSOR(l_select_csr);
1187:
1188: -- delete the entries for this call from CCT_TEMPAGENTS
1189: DELETE from CCT_TEMPAGENTS
1190: WHERE CALL_ID = l_call_ID;

Line 1225: DBMS_SQL.CLOSE_CURSOR (l_select_csr);

1221: --commit work;
1222: exception
1223: WHEN OTHERS THEN
1224: -- close the cursor
1225: DBMS_SQL.CLOSE_CURSOR (l_select_csr);
1226: RAISE;
1227: end;
1228: END reroute;
1229: