APPS.IEB_SERVICEPLAN_PVT dependencies on IEB_WB_SVC_CAT_RULES

Line 644: l_wbscrule_id IEB_WB_SVC_CAT_RULES.WBSCRULE_ID%type;

640: l_return_status VARCHAR2(4);
641:
642: l_msg_count NUMBER(2);
643:
644: l_wbscrule_id IEB_WB_SVC_CAT_RULES.WBSCRULE_ID%type;
645:
646: BEGIN
647:
648:

Line 659: EXECUTE immediate 'INSERT into IEB_WB_SVC_CAT_RULES '||

655: x_msg_count := 0;
656:
657: select IEB_SVC_CAT_RULES_S1.nextval into l_wbscrule_id from dual;
658:
659: EXECUTE immediate 'INSERT into IEB_WB_SVC_CAT_RULES '||
660: '(WBSCRULE_ID, '||
661: ' RULE_TYPE, '||
662: ' CREATED_BY, '||
663: ' CREATION_DATE, '||

Line 1792: ' delete from IEB_WB_SVC_CAT_RULES '||

1788: x_msg_count := 0;
1789: x_msg_data := '';
1790:
1791: EXECUTE immediate
1792: ' delete from IEB_WB_SVC_CAT_RULES '||
1793: ' where WBSC_WBSC_ID in (select distinct c.WBSC_ID from '||
1794: ' IEB_WB_SVC_CATS c,IEB_WB_SVC_CAT_RULES r , IEB_REGIONAL_PLANS p '||
1795: ' where c.WBSC_ID = r.WBSC_WBSC_ID '||
1796: ' and (c.SVCPLN_SVCPLN_ID = :1 or p.BASE_PLAN_ID = :2) '||

Line 1794: ' IEB_WB_SVC_CATS c,IEB_WB_SVC_CAT_RULES r , IEB_REGIONAL_PLANS p '||

1790:
1791: EXECUTE immediate
1792: ' delete from IEB_WB_SVC_CAT_RULES '||
1793: ' where WBSC_WBSC_ID in (select distinct c.WBSC_ID from '||
1794: ' IEB_WB_SVC_CATS c,IEB_WB_SVC_CAT_RULES r , IEB_REGIONAL_PLANS p '||
1795: ' where c.WBSC_ID = r.WBSC_WBSC_ID '||
1796: ' and (c.SVCPLN_SVCPLN_ID = :1 or p.BASE_PLAN_ID = :2) '||
1797: ' and c.MEDIA_TYPE_ID = :3 '||
1798: ' and p.SERVICE_PLAN_ID (+)= c.SVCPLN_SVCPLN_ID ) '