APPS.IEB_SERVICEPLAN_PVT dependencies on DUAL

Line 49: select IEB_SVC_PLAN_S1.nextval into l_svc_plan_id from dual;

45: x_msg_count := 0;
46: l_temp_str := null;
47:
48:
49: select IEB_SVC_PLAN_S1.nextval into l_svc_plan_id from dual;
50:
51: EXECUTE immediate 'INSERT INTO IEB_SERVICE_PLANS '||
52: '( SVCPLN_ID, ' ||
53: ' CREATED_BY, ' ||

Line 231: select IEB_SVC_COV_S2.nextval into l_osvccov_id from dual;

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:
231: select IEB_SVC_COV_S2.nextval into l_osvccov_id from dual;
232:
233: if l_quota IS NULL then
234: l_quota :=0;
235: end if;

Line 310: select IEB_SVC_COV_S1.nextval into l_isvccov_id from dual;

306: and tl.LANGUAGE = l_language
307: and b.SERVICE_LEVEL_ID = rec_obj.slevel_id;
308:
309:
310: select IEB_SVC_COV_S1.nextval into l_isvccov_id from dual;
311:
312: if l_minagent IS NULL then
313: l_minagent := 0;
314: end if;

Line 657: select IEB_SVC_CAT_RULES_S1.nextval into l_wbscrule_id from dual;

653: l_source_lang :=FND_GLOBAL.BASE_LANGUAGE;
654: x_msg_data := '';
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, '||

Line 792: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;

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;
793:
794: l_svr_cat_name := p_svc_plan_id||p_name||to_char(l_time_stamp);
795:
796:

Line 797: select IEB_SVC_CATS_S1.nextval into l_wbsc_id from dual;

793:
794: l_svr_cat_name := p_svc_plan_id||p_name||to_char(l_time_stamp);
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, '||

Line 950: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;

946: select media_type into l_media_type
947: from IEB_SVC_CAT_TEMPS_B where media_type_id = p_media_type_id;
948:
949:
950: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;
951:
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;

Line 954: select IEB_SVC_CATS_S1.nextval into l_wbsc_id from dual;

950: SELECT DBMS_UTILITY.GET_TIME INTO l_time_stamp FROM dual;
951:
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, '||

Line 1198: select IEB_GROUP_PLAN_MAPS_S1.nextval into l_map_id from dual;

1194: x_msg_data := '';
1195: x_msg_count := 0;
1196:
1197:
1198: select IEB_GROUP_PLAN_MAPS_S1.nextval into l_map_id from dual;
1199: EXECUTE immediate 'INSERT INTO IEB_GROUP_PLAN_MAPS '||
1200: '(MAP_ID, '||
1201: ' SERVICE_PLAN_ID, '||
1202: ' CREATED_BY, '||

Line 1378: select IEB_SVC_LEVEL_S1.nextval into l_service_lvl_id from dual;

1374: x_msg_count := 0;
1375: l_temp_str := null;
1376:
1377:
1378: select IEB_SVC_LEVEL_S1.nextval into l_service_lvl_id from dual;
1379:
1380: EXECUTE immediate 'insert into IEB_SERVICE_LEVELS_B '||
1381: '(SERVICE_LEVEL_ID, '||
1382: ' CREATED_BY, '||