Advanced Search

Hold concurrent requests by name

/ Published in: PL/SQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. UPDATE FND_CONCURRENT_REQUESTS
  2. SET hold_flag = 'Y'
  3. WHERE REQUEST_ID IN (
  4.     SELECT cr.REQUEST_ID
  5.     FROM fnd_concurrent_programs_tl cp, fnd_concurrent_requests cr
  6.     WHERE cp.application_id = cr.program_application_id 
  7.     AND cp.concurrent_program_id = cr.concurrent_program_id
  8.     AND DECODE(cp.USER_CONCURRENT_PROGRAM_NAME,'Report Set', cr.DESCRIPTION, cp.USER_CONCURRENT_PROGRAM_NAME) = '&arg'
  9.     AND cr.phase_code = 'P');

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.