2 Replies Latest reply: Feb 5, 2013 8:37 AM by Braj Pratap RSS

    how to pass values in std.procedure

    Aravinda
      Dear Friends

      I have a procedure in my OAF CO. below one

      String s31 = "BEGIN eam_materialissue_pvt.fork_logic( p_api_version =>1.0, p_init_m" +
      "sg_list => fnd_api.g_true, p_commit => FND_API.G_FALSE, p" +
      "_validation_level => fnd_api.g_valid_level_full, x_return_status =>" +
      " :1, x_msg_count => :2, x_msg_data => :3, p_wip_entity_" +
      "type => wip_constants.discrete , p_organization_id => :4 , p_wip_e" +
      "ntity_id => :5 , p_operation_seq_num => :6 , p_inventory_item_id " +
      " => :7 , p_requested_quantity => :8 , p_source_subinventory " +
      "=> :9 , p_source_locator => :10 , p_lot_number => :11 , p_fm_s" +
      "erial => :12 , p_to_serial => :13 , p_reasons => :14 , p_refer" +
      "ence => :15 , p_rebuild_item_id => :16 , p_rebuild_serial_numb" +
      "er => :17 , p_rebuild_activity_id => :18 , p_rebuild_job_name => " +
      ":19 , p_user_id => :20, p_revision => :21, p_date => :22 );" +
      " END;"
      ;

      Now i want to pass id values to the pareameters :9 and :10 with CO extension...is it possible.can any one suggest any idea.

      Thanks
      Aravinda
        • 1. Re: how to pass values in std.procedure
          shreevat
          If you PG has id values stored (e.g. for messageChoice etc you can display meaning but pass id values or you can have formValues created for storing ids), you can use getValue method to fetch the id value. If this is not the case, you need to fetch the id values based on the actual values through SQL queries and pass it to the procedure. Let me know if this is what you want.

          Thanks
          Shree
          • 2. Re: how to pass values in std.procedure
            Braj Pratap
            Hi

            You should call this same procedure again in your extended controller by giving values for parameter 9 and 10 , this will override the call of seeded controller abd give the expected result

            Thanks
            Pratap