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_WB_SVC_CATS

Line 755: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;

751: l_return_status VARCHAR2(4);
752:
753: l_msg_count NUMBER(2);
754:
755: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
756:
757: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
758:
759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;

Line 759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;

755: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
756:
757: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
758:
759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
760:
761: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
762:
763: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;

Line 761: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;

757: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
758:
759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
760:
761: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
762:
763: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;
764:
765: l_time_stamp NUMBER(15);

Line 763: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;

759: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
760:
761: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
762:
763: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;
764:
765: l_time_stamp NUMBER(15);
766:
767: --create cursor to get the all servers

Line 788: from IEB_WB_SVC_CATS where media_type_id= p_media_type_id

784:
785: for c_rec in c_cur LOOP
786:
787: select parent_id into l_parent_id
788: from IEB_WB_SVC_CATS where media_type_id= p_media_type_id
789: and wbsvr_wbsvr_id= c_rec.WBSVR_ID
790: and default_flag= 'Y';
791:
792: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;

Line 799: EXECUTE immediate 'INSERT into IEB_WB_SVC_CATS '||

795:
796:
797: select IEB_SVC_CATS_S1.nextval into l_wbsc_id from dual;
798:
799: EXECUTE immediate 'INSERT into IEB_WB_SVC_CATS '||
800: ' (WBSC_ID, '||
801: ' CREATED_BY, '||
802: ' CREATION_DATE, '||
803: ' LAST_UPDATED_BY, '||

Line 917: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;

913: l_return_status VARCHAR2(4);
914:
915: l_msg_count NUMBER(2);
916:
917: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
918:
919: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
920:
921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;

Line 921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;

917: l_wbsc_id IEB_WB_SVC_CATS.WBSC_ID%type;
918:
919: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
920:
921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
922:
923: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
924:
925: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;

Line 923: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;

919: l_media_type IEB_SVC_CAT_TEMPS_B.media_type%type;
920:
921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
922:
923: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
924:
925: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;
926:
927: l_time_stamp NUMBER(15);

Line 925: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;

921: l_parent_id IEB_WB_SVC_CATS.parent_id%type;
922:
923: l_cpn_svr_name IEB_WB_SVC_CATS.campaign_server_name%type;
924:
925: l_svr_cat_name IEB_WB_SVC_CATS.service_category_name%type;
926:
927: l_time_stamp NUMBER(15);
928:
929: BEGIN

Line 942: from IEB_WB_SVC_CATS where media_type_id= p_media_type_id

938: x_msg_count := 0;
939:
940:
941: select parent_id into l_parent_id
942: from IEB_WB_SVC_CATS where media_type_id= p_media_type_id
943: and wbsvr_wbsvr_id= p_server_id
944: and default_flag= 'Y';
945:
946: select media_type into l_media_type

Line 956: EXECUTE immediate 'INSERT into IEB_WB_SVC_CATS '||

952: l_svr_cat_name := p_svc_plan_id||p_name||to_char(l_time_stamp);
953:
954: select IEB_SVC_CATS_S1.nextval into l_wbsc_id from dual;
955:
956: EXECUTE immediate 'INSERT into IEB_WB_SVC_CATS '||
957: ' (WBSC_ID, '||
958: ' CREATED_BY, '||
959: ' CREATION_DATE, '||
960: ' LAST_UPDATED_BY, '||

Line 1302: update IEB_WB_SVC_CATS set

1298: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
1299: x_msg_data := '';
1300:
1301:
1302: update IEB_WB_SVC_CATS set
1303: svcpln_svcpln_id = p_reg_plan_id,
1304: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1305: LAST_UPDATE_DATE = SYSDATE,
1306: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

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 ) '

Line 1806: ' delete from IEB_WB_SVC_CATS s '||

1802: null;
1803: end if;
1804:
1805: EXECUTE immediate
1806: ' delete from IEB_WB_SVC_CATS s '||
1807: ' where s.WBSC_ID in ( select c.WBSC_ID from '||
1808: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||
1809: ' where c.MEDIA_TYPE_ID = :1'||
1810: ' and (c.svcpln_svcpln_id = :2 or p.BASE_PLAN_ID = :3) '||

Line 1808: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||

1804:
1805: EXECUTE immediate
1806: ' delete from IEB_WB_SVC_CATS s '||
1807: ' where s.WBSC_ID in ( select c.WBSC_ID from '||
1808: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||
1809: ' where c.MEDIA_TYPE_ID = :1'||
1810: ' and (c.svcpln_svcpln_id = :2 or p.BASE_PLAN_ID = :3) '||
1811: ' and p.SERVICE_PLAN_ID (+)= c.SVCPLN_SVCPLN_ID ) '
1812: USING p_media_type_id, p_svc_plan_id, p_svc_plan_id;

Line 1865: ' delete from IEB_WB_SVC_CATS s '||

1861: x_msg_count := 0;
1862: x_msg_data := '';
1863:
1864: EXECUTE immediate
1865: ' delete from IEB_WB_SVC_CATS s '||
1866: ' where s.WBSC_ID in ( select c.WBSC_ID from '||
1867: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||
1868: ' where c.MEDIA_TYPE_ID = :1'||
1869: ' and (c.svcpln_svcpln_id = :2 or p.BASE_PLAN_ID = :3) '||

Line 1867: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||

1863:
1864: EXECUTE immediate
1865: ' delete from IEB_WB_SVC_CATS s '||
1866: ' where s.WBSC_ID in ( select c.WBSC_ID from '||
1867: ' IEB_WB_SVC_CATS c, IEB_REGIONAL_PLANS p '||
1868: ' where c.MEDIA_TYPE_ID = :1'||
1869: ' and (c.svcpln_svcpln_id = :2 or p.BASE_PLAN_ID = :3) '||
1870: ' and p.SERVICE_PLAN_ID (+)= c.SVCPLN_SVCPLN_ID ) '
1871: USING p_media_type_id, p_svc_plan_id, p_svc_plan_id;

Line 1979: update IEB_WB_SVC_CATS set

1975: x_msg_data := '';
1976:
1977: select MEDIA_TYPE_ID into l_media_type_id from IEB_SERVICE_PLANS where SVCPLN_ID = p_base_plan_id;
1978:
1979: update IEB_WB_SVC_CATS set
1980: svcpln_svcpln_id = p_base_plan_id,
1981: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1982: LAST_UPDATE_DATE = SYSDATE,
1983: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID

Line 2078: update IEB_WB_SVC_CATS set

2074: null;
2075: end if;
2076:
2077:
2078: update IEB_WB_SVC_CATS set
2079: svcpln_svcpln_id = p_base_plan_id,
2080: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
2081: LAST_UPDATE_DATE = SYSDATE,
2082: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID