APPS.IEB_SERVICEPLAN_PVT dependencies on IEB_INB_SVC_COVERAGES

Line 185: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;

181: l_msg_count NUMBER(2);
182:
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;

Line 333: EXECUTE immediate ' INSERT INTO IEB_INB_SVC_COVERAGES '||

329: l_reroute_war_time := 1;
330: end if;
331:
332:
333: EXECUTE immediate ' INSERT INTO IEB_INB_SVC_COVERAGES '||
334: ' ( ISVCCOV_ID, '||
335: ' CREATED_BY, '||
336: ' CREATION_DATE, '||
337: ' LAST_UPDATED_BY, '||

Line 454: l_isvccov_id IEB_INB_SVC_COVERAGES.ISVCCOV_ID%type;

450: l_msg_count NUMBER(2);
451:
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;

Line 554: update IEB_INB_SVC_COVERAGES

550: end if;
551:
552: if(rec_obj.schedule_type = 'R') then
553:
554: update IEB_INB_SVC_COVERAGES
555: set BEGIN_TIME_HHMM = rec_obj.start_time,
556: END_TIME_HHMM = rec_obj.end_time,
557: MIN_AGENT = l_minagent,
558: PERCENTAGE = l_percentage,

Line 573: update IEB_INB_SVC_COVERAGES

569: and REGULAR_SCHD_DAY = rec_obj.regular_schd_day;
570:
571: elsif(rec_obj.schedule_type ='S') then
572:
573: update IEB_INB_SVC_COVERAGES
574: set BEGIN_TIME_HHMM = rec_obj.start_time,
575: END_TIME_HHMM = rec_obj.end_time,
576: MIN_AGENT = l_minagent,
577: PERCENTAGE = l_percentage,

Line 1719: ' delete from IEB_INB_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)'

1715: end if;
1716:
1717:
1718: EXECUTE immediate
1719: ' delete from IEB_INB_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)'
1720: USING x_service_plan_id, x_service_plan_id;
1721:
1722: if (sql%notfound) then
1723: null;

Line 1926: ' delete from IEB_INB_SVC_COVERAGES where svcpln_svcpln_id =:1 '

1922:
1923: if( p_direction = 'I') then
1924:
1925: EXECUTE immediate
1926: ' delete from IEB_INB_SVC_COVERAGES where svcpln_svcpln_id =:1 '
1927: USING p_plan_id;
1928:
1929: if (sql%notfound) then
1930: null;

Line 2006: ' delete from IEB_INB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1 '

2002: null;
2003: end if;
2004:
2005: EXECUTE immediate
2006: ' delete from IEB_INB_SVC_COVERAGES where SVCPLN_SVCPLN_ID = :1 '
2007: USING p_reg_plan_id;
2008:
2009: if (sql%notfound) then
2010: null;

Line 2130: ' delete from IEB_INB_SVC_COVERAGES where svcpln_svcpln_id =:1 and SPEC_SCHD_DATE =:2 and SCHEDULE_TYPE = :3'

2126:
2127: if( p_direction = 'I') then
2128:
2129: EXECUTE immediate
2130: ' delete from IEB_INB_SVC_COVERAGES where svcpln_svcpln_id =:1 and SPEC_SCHD_DATE =:2 and SCHEDULE_TYPE = :3'
2131: USING p_plan_id, p_spec_date, 'S';
2132:
2133: if (sql%notfound) then
2134: null;