1 Reply Latest reply: Jan 21, 2011 8:01 AM by 669990 RSS

    Want Arguments passed for CMCICU (Update Std. Cost) Concurrent

    460568
      I want to know the arguments to be paddes while calling the concurrent UPDATE
      STANDARD COST - CMCICU... I want to call the concurrent from a procedure...
      using fnd_request.submit_request ... Pease advice what paramters to pass..
      Also I wnat to wait for a specific period of time ...
      fnd_concurrent.wait_for_request .... what parameters have to be passed to
      that...
      Can you please suggest the arguments to be passed for both whie calling from a
      procedure..

      Thank you
      Ali
        • 1. Re: Want Arguments passed for CMCICU (Update Std. Cost) Concurrent
          669990
          Please use below code,

          fnd_file.put_line (fnd_file.output,
          'Entered into Update Standard Costs');

          vv_request_id1 :=
          FND_REQUEST.SUBMIT_REQUEST (
          APPLICATION => 'BOM',
          PROGRAM => 'CMCICU',
          DESCRIPTION => '',
          START_TIME => NULL,
          SUB_REQUEST => FALSE,
          ARGUMENT1 => 85, --- Organization Id
          ARGUMENT2 => 1,--BOM Install flag
          ARGUMENT3 => 3, -- Cost Type
          ARGUMENT4 => 1, -- Validate Accounting Flexfield
          ARGUMENT5 => 2005, -- Adjustment Account
          ARGUMENT6 => 'Test For Update Standard Cost : '||to_char(sysdate,'DD-MM-RRRR HH12:MI:SS'),-- Description
          ARGUMENT7 => 1, -- Item Range
          ARGUMENT8 => 1, -- Sort Option
          ARGUMENT9 => 2, -- Update Option
          ARGUMENT10 => NULL, -- Item dummy
          ARGUMENT11 => NULL, -- Category dummy
          ARGUMENT12 => NULL, -- Specific Item
          ARGUMENT13 => NULL, -- Category set
          ARGUMENT14 => NULL, -- Category validate flag
          ARGUMENT15 => NULL, -- Category structure
          ARGUMENT16 => NULL, -- Specific Category
          ARGUMENT17 => NULL, -- Item From
          ARGUMENT18 => NULL, -- Item To
          ARGUMENT19 => NULL, -- Resource From
          ARGUMENT20 => NULL, -- Resource To
          ARGUMENT21 => NULL, -- Overhead From
          ARGUMENT22 => NULL, -- Overhead To
          ARGUMENT23 => 2, -- Run Adjustment Reports
          ARGUMENT24 => 1 -- Save Details
          );

          COMMIT;
          fnd_file.put_line (fnd_file.output,
          'After Update Standard Costs');