1 Reply Latest reply: Aug 26, 2011 1:03 AM by Srikkanth.M RSS

    How to pass two global variable in fnd_function

    Srikkanth.M
      Hi All

      I am using oracle apps r12

      I am using Fnd_function.execute to call my new form and am using this syntax

      begin
      :global.requisition_number :=:XXMBHOTRESREQ_DB.requisition_no;

      fnd_function.execute(FUNCTION_NAME=>'XXMBREQHIST_FUN',OPEN_FLAG=>'Y',SESSION_FLAG=>'N',
      other_params=>:Global.requisition_number);

      End

      Now i need pass another parameter called Line_no

      I tried like this

      begin
      :global.requisition_number :=:XXMBHOTRESREQ_DB.requisition_no;

      :global.Line_no :=:XXMBHOTRESREQ_DB.line_no;

      fnd_function.execute(FUNCTION_NAME=>'XXMBREQHIST_FUN',OPEN_FLAG=>'Y',SESSION_FLAG=>'N',
      other_params=>:Global.requisition_number,:Global.line_no);

      end;

      but it gives error

      Can any correct me where i went wrong.

      Regards
      Srikkanth
        • 1. Re: How to pass two global variable in fnd_function
          Srikkanth.M
          Fixed by passing like this

          begin
          :global.requisition_number :=:XXMBHOTRESREQ_DB.requisition_no;
          :global.Line_no :=:XXMBHOTRESREQ_DB.line_no;
          fnd_function.execute(FUNCTION_NAME=>'XXMBREQHIST_FUN',OPEN_FLAG=>'Y',SESSION_FLAG=>'N',
          other_params=>:Global.requisition_number||:Global.line_no);


          --OTHER_PARAMS=>'ORDER_ID="'||param_to_pass1||'" CUSTOMER_NAME="'||param_to_pass2||'"');

          clear_block();
          end;