APPS.IEB_SERVICEPLAN_PVT dependencies on IEB_SERVICE_LEVELS_TL

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 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 1439: insert into IEB_SERVICE_LEVELS_TL (

1435:
1436:
1437:
1438:
1439: insert into IEB_SERVICE_LEVELS_TL (
1440: SERVICE_LEVEL_ID,
1441: CREATED_BY,
1442: CREATION_DATE,
1443: LAST_UPDATED_BY,

Line 1469: from IEB_SERVICE_LEVELS_TL T

1465: from FND_LANGUAGES L
1466: where L.INSTALLED_FLAG in ('I', 'B')
1467: and not exists
1468: (select NULL
1469: from IEB_SERVICE_LEVELS_TL T
1470: where T.SERVICE_LEVEL_ID = l_service_lvl_id
1471: and T.LANGUAGE = L.LANGUAGE_CODE);
1472:
1473:

Line 1626: 'delete from IEB_SERVICE_LEVELS_TL '||

1622: x_msg_data := '';
1623:
1624:
1625: EXECUTE immediate
1626: 'delete from IEB_SERVICE_LEVELS_TL '||
1627: ' where SERVICE_LEVEL_ID = :1 and language= :2'
1628: USING x_service_level_id, l_language;
1629:
1630: if (sql%notfound) then