245:
246: l_stmt_num := 480;
247:
248: /* Added for Enhancement # 3321626
249: * To Delete data from flm_exe_operations table also.
250: */
251:
252: DELETE FROM FLM_EXE_OPERATIONS
253: WHERE WIP_ENTITY_ID = arg_wip_entity_id;
248: /* Added for Enhancement # 3321626
249: * To Delete data from flm_exe_operations table also.
250: */
251:
252: DELETE FROM FLM_EXE_OPERATIONS
253: WHERE WIP_ENTITY_ID = arg_wip_entity_id;
254:
255: l_stmt_num := 481 ;
256: delete_exe_tables (arg_wip_entity_id, arg_org_id);
445: l_records_deleted := G_ZERO;
446: end if;
447:
448: /* Added for Enhancement # 3321626
449: * To Delete data from flm_exe_operations table if purge_option = 3
450: */
451: elsif (arg_purge_option = 3) and (l_flag) then
452:
453: DELETE FROM FLM_EXE_OPERATIONS
449: * To Delete data from flm_exe_operations table if purge_option = 3
450: */
451: elsif (arg_purge_option = 3) and (l_flag) then
452:
453: DELETE FROM FLM_EXE_OPERATIONS
454: WHERE WIP_ENTITY_ID = l_wip_entity_id;
455:
456: l_stmt_num := 325;
457: