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.IEB_SERVICEPLAN_PVT dependencies on IEB_SERVICE_LEVELS_B

Line 193: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;

189: l_begin_time IEB_OUTB_SVC_COVERAGES.BEGIN_TIME_HHMM%type;
190:
191: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;
192:
193: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
194:
195: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
196:
197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

Line 195: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;

191: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;
192:
193: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
194:
195: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
196:
197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
198:
199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;

Line 197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

193: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
194:
195: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
196:
197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
198:
199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
200:
201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;

Line 199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;

195: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
196:
197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
198:
199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
200:
201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
202:
203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;

Line 201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;

197: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
198:
199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
200:
201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
202:
203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
204:
205: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;

Line 203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;

199: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
200:
201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
202:
203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
204:
205: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
206:
207: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;

Line 205: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;

201: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
202:
203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
204:
205: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
206:
207: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;
208: l_temp_str varchar2(80);
209:

Line 207: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;

203: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
204:
205: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
206:
207: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;
208: l_temp_str varchar2(80);
209:
210:
211: BEGIN

Line 226: into l_quota, l_minagent from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl

222:
223: if ( rec_obj.direction = 'O') then
224:
225: select b.HOURLY_QUOTA, b.MIN_AGENTS
226: into l_quota, l_minagent from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl
227: where b.SERVICE_LEVEL_ID = tl.SERVICE_LEVEL_ID
228: and tl.LANGUAGE = l_language
229: and b.SERVICE_LEVEL_ID = rec_obj.slevel_id;
230:

Line 304: from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl

300: b.MAX_WAIT_TIME,b.REROUTE_TIME, b.REROUTE_WARNING_TIME
301: into l_minagent, l_percentage,
302: l_time_threshold, l_max_wait_time, l_reroute_time,
303: l_reroute_war_time
304: from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl
305: where b.SERVICE_LEVEL_ID = tl.SERVICE_LEVEL_ID
306: and tl.LANGUAGE = l_language
307: and b.SERVICE_LEVEL_ID = rec_obj.slevel_id;
308:

Line 462: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;

458: l_begin_time IEB_OUTB_SVC_COVERAGES.BEGIN_TIME_HHMM%type;
459:
460: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;
461:
462: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
463:
464: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
465:
466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

Line 464: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;

460: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;
461:
462: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
463:
464: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
465:
466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
467:
468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;

Line 466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

462: l_minagent IEB_SERVICE_LEVELS_B.MIN_AGENTS%type;
463:
464: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
465:
466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
467:
468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
469:
470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;

Line 468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;

464: l_quota IEB_SERVICE_LEVELS_B.HOURLY_QUOTA%type;
465:
466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
467:
468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
469:
470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
471:
472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;

Line 470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;

466: l_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
467:
468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
469:
470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
471:
472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
473:
474: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;

Line 472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;

468: l_max_wait_time IEB_SERVICE_LEVELS_B.MAX_WAIT_TIME%type;
469:
470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
471:
472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
473:
474: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
475:
476: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;

Line 474: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;

470: l_percentage IEB_SERVICE_LEVELS_B.GOAL_PERCENT%type;
471:
472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
473:
474: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
475:
476: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;
477: l_temp_str varchar2(80);
478:

Line 476: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;

472: l_time_threshold IEB_SERVICE_LEVELS_B.GOAL_TIME%type;
473:
474: l_reroute_time IEB_SERVICE_LEVELS_B.REROUTE_TIME%type;
475:
476: l_reroute_war_time IEB_SERVICE_LEVELS_B.REROUTE_WARNING_TIME%type;
477: l_temp_str varchar2(80);
478:
479:
480: BEGIN

Line 494: into l_quota, l_minagent from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl

490: l_temp_str := null;
491: if ( rec_obj.direction = 'O') then
492:
493: select b.HOURLY_QUOTA, b.MIN_AGENTS
494: into l_quota, l_minagent from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl
495: where b.SERVICE_LEVEL_ID = tl.SERVICE_LEVEL_ID
496: and tl.LANGUAGE = l_language
497: and b.SERVICE_LEVEL_ID = rec_obj.slevel_id;
498:

Line 540: from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl

536: b.MAX_WAIT_TIME,b.REROUTE_TIME, b.REROUTE_WARNING_TIME
537: into l_minagent, l_percentage,
538: l_time_threshold, l_max_wait_time, l_reroute_time,
539: l_reroute_war_time
540: from IEB_SERVICE_LEVELS_B b, IEB_SERVICE_LEVELS_tl tl
541: where b.SERVICE_LEVEL_ID = tl.SERVICE_LEVEL_ID
542: and tl.LANGUAGE = l_language
543: and b.SERVICE_LEVEL_ID = rec_obj.slevel_id;
544:

Line 1362: l_service_lvl_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

1358: l_return_status VARCHAR2(4);
1359:
1360: l_msg_count NUMBER(2);
1361:
1362: l_service_lvl_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
1363: l_temp_str varchar2(80);
1364:
1365: BEGIN
1366:

Line 1380: EXECUTE immediate 'insert into IEB_SERVICE_LEVELS_B '||

1376:
1377:
1378: select IEB_SVC_LEVEL_S1.nextval into l_service_lvl_id from dual;
1379:
1380: EXECUTE immediate 'insert into IEB_SERVICE_LEVELS_B '||
1381: '(SERVICE_LEVEL_ID, '||
1382: ' CREATED_BY, '||
1383: ' CREATION_DATE, '||
1384: ' LAST_UPDATED_BY, '||

Line 1526: l_service_lvl_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

1522: l_return_status VARCHAR2(4);
1523:
1524: l_msg_count NUMBER(2);
1525:
1526: l_service_lvl_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
1527:
1528: BEGIN
1529:
1530:

Line 1540: update IEB_SERVICE_LEVELS_B set

1536: x_msg_data := '';
1537:
1538: if (rec_obj.direction = 'I') then
1539: -- dbms_output.put_line('inbound');
1540: update IEB_SERVICE_LEVELS_B set
1541: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1542: LAST_UPDATE_DATE = SYSDATE,
1543: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1544: GOAL_PERCENT = rec_obj.goal_percent,

Line 1553: update IEB_SERVICE_LEVELS_B set

1549: SERVICE_LEVEL_ID = rec_obj.service_level_id;
1550:
1551: elsif (rec_obj.direction = 'O') then
1552: -- dbms_output.put_line('outbound');
1553: update IEB_SERVICE_LEVELS_B set
1554: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1555: LAST_UPDATE_DATE = SYSDATE,
1556: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1557: HOURLY_QUOTA = rec_obj.hourly_quota,

Line 1615: l_service_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;

1611: is
1612:
1613: l_language VARCHAR2(4);
1614:
1615: l_service_level_id IEB_SERVICE_LEVELS_B.SERVICE_LEVEL_ID%type;
1616:
1617: BEGIN
1618:
1619: l_language := FND_GLOBAL.CURRENT_LANGUAGE;

Line 1635: ' delete from IEB_SERVICE_LEVELS_B '||

1631: null;
1632: end if;
1633:
1634: EXECUTE immediate
1635: ' delete from IEB_SERVICE_LEVELS_B '||
1636: ' where SERVICE_LEVEL_ID = :1'
1637: USING x_service_level_id;
1638:
1639: if (sql%notfound) then