0 Replies Latest reply on May 7, 2014 10:17 AM by 634892

    Update Product Category with a value programmatically

    634892

      Hi,

      I have a Non Database LOV item "Product category" to be updated depending on another item's value Purchasing category in the PO Requisition Lines Page

      I am able to extract the value using Controller Extension, but unable to update the NonDatabase LOV Item as below,

              InsertStmt1 = "BEGIN ccc_prod_cat_ident_pkg.get_product_category(:1,:2); END; ";
              CallableStatement insproc1 = trxn.createCallableStatement(InsertStmt1, 0);
              insproc1.setInt(1, Integer.parseInt(req_line_id));
              insproc1.registerOutParameter(2,Types.VARCHAR);
              insproc1.execute();
              String L_PRODCAT = insproc1.getString(2);
              //ProdCatEx.setValue(oapagecontext,L_PRODCAT);
               PoRequisitionLinesVO.getCurrentRow().setAttribute("ProdCat", L_PRODCAT);
              insproc1.close();

      I am looping through the PORequisitionLinesVO record and trying to set the value to the ProdCat LOV Field but somehow it does not do that.

      Any pointers how to do this?


      Thanks,

      Kiran