DBA Data[Home] [Help]

APPS.IEB_SERVICEPLAN_PVT dependencies on DBMS_UTILITY

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 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;