DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on FLM_EXE_OPERATIONS

Line 249: * To Delete data from flm_exe_operations table also.

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;

Line 252: DELETE FROM FLM_EXE_OPERATIONS

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

Line 451: * To Delete data from flm_exe_operations table if purge_option = 3

447: l_records_deleted := G_ZERO;
448: end if;
449:
450: /* Added for Enhancement # 3321626
451: * To Delete data from flm_exe_operations table if purge_option = 3
452: */
453: elsif (arg_purge_option = 3) and (l_flag) then
454:
455: DELETE FROM FLM_EXE_OPERATIONS

Line 455: DELETE FROM FLM_EXE_OPERATIONS

451: * To Delete data from flm_exe_operations table if purge_option = 3
452: */
453: elsif (arg_purge_option = 3) and (l_flag) then
454:
455: DELETE FROM FLM_EXE_OPERATIONS
456: WHERE WIP_ENTITY_ID = l_wip_entity_id;
457:
458: l_stmt_num := 325;
459: