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 449: * To Delete data from flm_exe_operations table if purge_option = 3

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

Line 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: