278:
279: IF STATUS_IS_PROCESSING(l_current_status) THEN
280: UPDATE fnd_oam_dscram_tasks
281: SET task_status = G_STATUS_STOPPING,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.user_id,
284: last_update_date = SYSDATE
285: WHERE task_id = l_id;
286: COMMIT;
279: IF STATUS_IS_PROCESSING(l_current_status) THEN
280: UPDATE fnd_oam_dscram_tasks
281: SET task_status = G_STATUS_STOPPING,
282: last_updated_by = fnd_global.user_id,
283: last_update_login = fnd_global.user_id,
284: last_update_date = SYSDATE
285: WHERE task_id = l_id;
286: COMMIT;
287: ELSE
298:
299: IF STATUS_IS_PROCESSING(l_current_status) THEN
300: UPDATE fnd_oam_dscram_bundles
301: SET bundle_status = G_STATUS_STOPPING,
302: last_updated_by = fnd_global.user_id,
303: last_update_login = fnd_global.user_id,
304: last_update_date = SYSDATE
305: WHERE bundle_id = l_id;
306: COMMIT;
299: IF STATUS_IS_PROCESSING(l_current_status) THEN
300: UPDATE fnd_oam_dscram_bundles
301: SET bundle_status = G_STATUS_STOPPING,
302: last_updated_by = fnd_global.user_id,
303: last_update_login = fnd_global.user_id,
304: last_update_date = SYSDATE
305: WHERE bundle_id = l_id;
306: COMMIT;
307: ELSE
318:
319: IF STATUS_IS_PROCESSING(l_current_status) THEN
320: UPDATE fnd_oam_dscram_runs_b
321: SET run_status = G_STATUS_STOPPING,
322: last_updated_by = fnd_global.user_id,
323: last_update_login = fnd_global.user_id,
324: last_update_date = SYSDATE
325: WHERE run_id = l_id;
326: COMMIT;
319: IF STATUS_IS_PROCESSING(l_current_status) THEN
320: UPDATE fnd_oam_dscram_runs_b
321: SET run_status = G_STATUS_STOPPING,
322: last_updated_by = fnd_global.user_id,
323: last_update_login = fnd_global.user_id,
324: last_update_date = SYSDATE
325: WHERE run_id = l_id;
326: COMMIT;
327: ELSE