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_OUTB_SVC_COVERAGES

Line 187: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;

183: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
184:
185: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
186:
187: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
188:
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;

Line 189: l_begin_time IEB_OUTB_SVC_COVERAGES.BEGIN_TIME_HHMM%type;

185: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
186:
187: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
188:
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;

Line 191: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;

187: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
188:
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;

Line 242: EXECUTE immediate 'INSERT into IEB_OUTB_SVC_COVERAGES '||

238: end if;
239:
240: l_quota := ((rec_obj.end_time - rec_obj.start_time)/100)*l_quota;
241:
242: EXECUTE immediate 'INSERT into IEB_OUTB_SVC_COVERAGES '||
243: ' ( OSVCCOV_ID, '||
244: ' CREATED_BY, '||
245: ' CREATION_DATE, '||
246: ' LAST_UPDATED_BY, '||

Line 456: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;

452: l_svc_plan_id IEB_SERVICE_PLANS.SVCPLN_ID%type;
453:
454: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
455:
456: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
457:
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;

Line 458: l_begin_time IEB_OUTB_SVC_COVERAGES.BEGIN_TIME_HHMM%type;

454: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;
455:
456: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
457:
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;

Line 460: l_end_time IEB_OUTB_SVC_COVERAGES.END_TIME_HHMM%type;

456: l_osvccov_id IEB_OUTB_SVC_COVERAGES.OSVCCOV_ID%type;
457:
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;

Line 504: update IEB_OUTB_SVC_COVERAGES

500:
501:
502: if(rec_obj.schedule_type = 'R') then
503:
504: update IEB_OUTB_SVC_COVERAGES
505: set BEGIN_TIME_HHMM = rec_obj.start_time,
506: END_TIME_HHMM = rec_obj.end_time,
507: MIN_AGENT = l_minagent,
508: QUOTA = l_quota,

Line 519: update IEB_OUTB_SVC_COVERAGES

515: and REGULAR_SCHD_DAY = rec_obj.regular_schd_day;
516:
517: elsif(rec_obj.schedule_type ='S') then
518:
519: update IEB_OUTB_SVC_COVERAGES
520: set BEGIN_TIME_HHMM = rec_obj.start_time,
521: END_TIME_HHMM = rec_obj.end_time,
522: MIN_AGENT = l_minagent,
523: QUOTA = l_quota,

Line 1727: ' delete from IEB_OUTB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1 or SVCPLN_SVCPLN_ID in (select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id =:2)'

1723: null;
1724: end if;
1725:
1726: EXECUTE immediate
1727: ' delete from IEB_OUTB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1 or SVCPLN_SVCPLN_ID in (select SERVICE_PLAN_ID from ieb_regional_plans where base_plan_id =:2)'
1728: USING x_service_plan_id, x_service_plan_id;
1729:
1730: if (sql%notfound) then
1731: null;

Line 1935: ' delete from IEB_OUTB_SVC_COVERAGES where svcpln_svcpln_id =:1 '

1931: end if;
1932: elsif (p_direction = 'O') then
1933:
1934: EXECUTE immediate
1935: ' delete from IEB_OUTB_SVC_COVERAGES where svcpln_svcpln_id =:1 '
1936: USING p_plan_id;
1937:
1938: if (sql%notfound) then
1939: null;

Line 2014: ' delete from IEB_OUTB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1'

2010: null;
2011: end if;
2012:
2013: EXECUTE immediate
2014: ' delete from IEB_OUTB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1'
2015: USING p_reg_plan_id;
2016:
2017: if (sql%notfound) then
2018: null;

Line 2139: ' delete from IEB_OUTB_SVC_COVERAGES where svcpln_svcpln_id =:1 and SPEC_SCHD_DATE=:2 and SCHEDULE_TYPE = :3'

2135: end if;
2136: elsif (p_direction = 'O') then
2137:
2138: EXECUTE immediate
2139: ' delete from IEB_OUTB_SVC_COVERAGES where svcpln_svcpln_id =:1 and SPEC_SCHD_DATE=:2 and SCHEDULE_TYPE = :3'
2140: USING p_plan_id, p_spec_date, 'S';
2141:
2142: if (sql%notfound) then
2143: null;