101: log_output('================= ============== ====================='
102: ||' ====================== ');
103: END IF;
104:
105: IF (NVL(fnd_profile.value('MSC_RETAIN_RELEASED_DATA'), 'N') ='N' )THEN
106:
107: lv_sql_stmt := 'DELETE msc_wip_job_schedule_interface'||g_dblink
108: ||' where sr_instance_id ='|| P_SR_INSTANCE_ID
109: ||' and nvl(group_id,-1) = nvl('||g_group_id||',-1)'