How to add where condition to the sql stament....?

public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processFormRequest(pageContext, webBean);
    String resourceId=pageContext.getParameter("ResourceId");
    OAApplicationModule am = pageContext.getRootApplicationModule();
     String projectId = (String)pageContext.getSessionValue("paProjectId");
    String sWhereClauseValue = "";

    String dynVoQuery = "SELECT ppp.person_id, ppp.start_date_active, ppp.end_date_active  FROM pa_project_players ppp, pa_project_role_types ppr,pa_project_parties pp WHERE ppp.project_id = :1 and pp.project_id=ppp.project_id   AND ppp.project_role_type = ppr.project_role_type AND ppr.description = 'Delivery Manager' AND pp.project_role_id =ppr.PROJECT_ROLE_TYPE AND NVL (ppp.end_date_active, NVL (pp.START_DATE_ACTIVE, SYSDATE)) BETWEEN NVL (pp.START_DATE_ACTIVE, SYSDATE) AND NVL (pp.END_DATE_ACTIVE, TO_DATE ('01/01/4712', 'DD/MM/YYYY'))";
    ViewObject dynViewObject = am.findViewObject("ExistingDeliveryMgrVO");
    if(dynViewObject == null)
    {
      dynViewObject = am.createViewObjectFromQueryStmt("ExistingDeliveryMgrVO", dynVoQuery);
//      ExistingDeliveryMgrVORowImpl row=null;
      dynViewObject.setWhereClauseParams(null);
      dynViewObject.setWhereClauseParam(0,projectId);
      dynViewObject.executeQuery();
      if(dynViewObject.getRowCountInRange() >0)
      {
        oracle.jbo.Row row1 = dynViewObject.first();
        if(row1 != null)
        {
          String existingDeliveryMgr = row1.getAttribute(0).toString();
          if(existingDeliveryMgr != resourceId)
          {
            throw new OAException("Duplicate Delivery Manager");
          }
        }
      }

Loop Throught the Fetched Records in VO

Example 1:

 

This particular example was written for Oracle Sourcing.
       OAApplicationModule rootAM = pageContext.getRootApplicationModule();           
       OAViewObject ReqVO   =      (OAViewObject)rootAM.findViewObject("BidHeaderSectionsVO");
           
            if (null!=ReqVO) {
                Row ReqRow = ReqVO.first();           
                if (null != ReqRow) {
                           
                int idx = ReqVO.getRowCount();
   
                for (int xx = 0; xx < idx; xx++) {
                    if (null != ReqRow) {
                       // Do some work....
                       ReqRow = ReqVO.next();
                    }
                    else {}
                }
              }
            }

Example 2:

OAViewObject vo = (OAViewObject)getPPVCMHeadersVO2();
   PPVCMHeadersVORowImpl row = null;
   int fetchedRowCount = vo.getRowCount();
   RowSetIterator insertIter = vo.createRowSetIterator("insertIter");
   if (fetchedRowCount > 0)
    {
     insertIter.setRangeStart(0);
     insertIter.setRangeSize(fetchedRowCount);
     for (int i = 0; i < fetchedRowCount; i++)
      {  
        row = (PPVCMHeadersVORowImpl)insertIter.getRowAtRangeIndex(i);
        row.setAttribute("Sno",new Integer(i+1));
      }
    } 
  insertIter.closeRowSetIterator();

CSS Class names in OAF

Oracle Application Framework (OAF) Predefined CSS Classes List

as documented in Oracle BLAF Guidelines

commonly used

• OraFieldText           Updatable Fields
• OraDataText           Display Only Fields
• OraPromptText       Used for Prompts, Checkboxes
• OraLinkText            For Links/URLs
• OraInstructionText   For Plain Text Instruction

complete list

GENERAL COMPONENT CSS DEFINITIONS
OraBody	used on the element to define the default bgcolor/font family for the entire page
OraApplicationSwitcherText	label of Application Switcher
OraPromptText	Text Prompts (Labels)
OraDataText	Data text string anywhere in page except in tables - also often used for numeric values which don't need to be right-aligned
OraFieldText	Text and numeric data in standard Web widget (field, poplist)
OraFieldTextDisabled	Renders gray text in disabled form controls such as text fields, radio buttons, check boxes - does not match current BLAF guidelines
OraFieldNumber	Right-aligned numeric Data in Field
OraFieldNumberDisabled	Renders gray text for disabled Numeric Data fields - does not match current BLAF guidelines
OraInstructionText	Instruction Text
OraInstructionTextStrong	Instruction Text with Emphasis
OraPageStampText	Page stamp text
OraPageStampLabel	Page stamp label
OraButtonText	Action/Navigation Button Text
OraButtonTextDisabled	Button Text - disabled
OraLinkText	Link Text (would be underlined with href tag)
OraVLinkText	visited link text (would be underlined with href tag)
OraALinkText	active link text - color change on mouse button down (would be underlined with href tag)
OraGlobalButtonText	Global Button Enabled} (This would be an "a href" link
OraGlobalButtonTextSelected	Global Button Active
OraGlobalButtonTextDisabled	Global Button Disabled
OraTipText	Tip Text for page or section of page
OraTipLabel	Tip label (the word "Tip") in bold
OraInlineErrorText	Inline Error Text embedded in page content (not in message box; not for other message types)
OraInlineInfoText	Inline Info and Hint Text embedded in page content (not in message box; not for other message types)
OraTextInline	Variant of OraInlineInfoText - not specified in current BLAF guidelines
OraErrorHeader	Header for Error Message Only
OraErrorNameText	Error Name Text
OraMessageBoxList	numbered list within message box for list of informational or warning messages (not for error messages)
OraMessageBoxLink	blue links in message boxes - current BLAF guidelines specify brown links
OraMessageBoxParagraph	body text in non-error message boxes
OraMessageBoxErrorList	numbered list in red text within message box for list of error messages
OraMessageBoxErrorLink	blue links in message boxes - current BLAF guidelines specify brown links
OraMessageBoxErrorParagraph	red paragraph text in Error message boxes
OraPrivacy	Link in Footer to Privacy Statement
OraCopyright	Copyright Statement Text in Footer
OraCalendarTitle	Title of Date Picker - usually name of the month
OraCalendarHeader	Date Picker column headers - usually days of the week
OraCalendarEnabled	Days in Date Picker that can be selected
OraCalendarDisabled	Days in Date Picker that are invalid for the current context
OraCalendarSelected	Selected days(s) in the in Date Picker
OraShuttleLinkText	Link text placed below each arrow button in the middle of the shuttle
TAB/NAVIGATION/LOCATOR CSS DEFINITIONS
OraNav1Selected	Tab [level 1] selected
OraNav1Enabled	Tab [level 1] enabled
OraNav1Disabled	Tab [level 1] disabled
OraNav2Selected	Horizontal Navigation [level 2] selected
OraNav2Enabled	Horizontal Navigation [level 2] enabled
OraNav2Disabled	Horizontal Navigation [level 2] disabled
OraNav3Selected	Side Navigation [level 3] selected
OraNav3Enabled	Side Navigation [level 3] enabled
OraNav3Disabled	Side Navigation [level 3] disabled
OraNavBarActiveLink	used for enabled NavigationBarBean links (a "next" link when there are more items to view.)
OraNavBarInactiveLink	used for NavigationBarBean Next/Previous links when there are no more Next/Previous contents to be viewed
OraNavBarViewOnly	used for the step text (such as "Step 1 of 5") in a single-item NavigationBarBean
OraTrainActive	current page in step-by-step locator a.k.a. "train"
OraTrainVisited	visited page(s) in step by step locator a.k.a. "train"
OraTrainUnvisited	page(s) not yet visited page in step-by-step locator a.k.a. "train"
OraCrumbsSelected	current page (without link) in breadcrumbs
OraCrumbsEnabled	Pages higher in the hierarchy (with links enabled) in breadcrumbs
HEADER CSS DEFINITIONS
OraHeader	Standard dark blue header on white background
OraHeaderSub	Standard dark blue subheader on white background
OraHeaderSubSub	Standard dark blue subsubheader on white background
OraDarkHeader	Dark Header on dark beige in Side Navigation of Home page - usually subheader and subsubheader are used instead
OraDarkHeaderSub	Dark Subheader on dark beige in Side Navigation of Home page
OraDarkHeaderSubSub	Dark Subsubheader on dark beige in Side Navigation of Home page
OraLightHeader	Light blue header on light or medium beige background for content containers - usually subheader and subsubheader are used instead
OraLightHeaderSub	Light blue subheader on light or medium beige background - typically in content containers
OraLightHeaderSubSub	Light blue subsubheader on light background - typically in content containers
OraColorHeader	Header on Blue for content containers - usually subheader and subsubheader are used instead
OraColorHeaderSub	Subheader on Blue - typically in content containers
OraColorHeaderSubSub	SubsubHeader on Blue - typically in content containers
OraPortletHeader	Portlet Content Header on White - currently only used for a Portal demo
OraDarkPortletHeader	Portlet Content Header on Beige - currently only used for a Portal demo
OraGlobalPageTitle	Global header when there are no Tab links
TABLE CSS DEFINITIONS
OraTableTitle	Table Title - used instead of Subheader when other elements separate the subheader from the table AND no control bar is present
OraTable	Background color for table gridlines
OraTableControlBarText	text in table Control Bar (band appearing at top of some tables that contains controls)
OraTableColumnHeader	Table Column Header
OraTableColumnHeaderNumber	same as Table Column Header but with right aligned numeric header
OraTableColumnHeaderIconButton	Table Column Header with centered action button
OraTableSortableColumnHeader	Sortable Table Column Header -- cursor turns to hand over header cell
OraTableSortableColumnHeaderNumber	sortable form of numeric Table Column Header
OraTableSortableColumnHeaderIconButton	sortable form of Table Column Header with centered action button
OraTableRowHeader	Table Row Header
OraTableColumnFooter	for left-aligned text in table column footer, except for totals
OraTableTotal	right-aligned "Total" label that appears in footer cell to left of numeric total
OraTableAddTotal	left-aligned "Total" label that appears in column header cell
OraTableTotalNumber	right-aligned total value that appears in footer cell below the totalled column
OraTableTotalText	left-aligned total value -- useful in updateable tables with more than one totaled column
OraTableCellText	Table Cell Text
OraTableCellTextBand	Table Cell Text in row with band of color
OraTableCellNumber	numeric Table Cell Text - only required if column features calculations
OraTableCellNumberBand	numeric Table Cell Text in row with band of color - only required if column features calculations
OraTableCellIconButton	Table Cell containing an action/navigation button
OraTableCellIconButtonBand	numeric band color table cell containing an action/navigation button
OraTableCellSelect	select column with check box or radio button
OraTableCellSelectBand	select column with check box or radio button in row with band of color
OraTableVerticalGrid	Table Background Vertical Grid Color
OraTableVerticalHeaderGrid	Table Background Vertical Grid Color in Column Header
OraTableHorizontalGrid	Table Background Horizontal Grid Color
OraTableHorizontalHeaderGrid	Table Background Horizontal Grid Color in Row Header
OraTableShadowHeaderGrid	renders shadow for sortable table headers???
OraTableHeaderLink	Used for column headers rendered by SortableHeaderBean for headers which aren't sortable
OraTableSortableHeaderLink	Link in Header of Sortable Column
OraTableDetail	Used for details child in conjunction with Hide/Show in a table row
SPACING AND LAYOUT CSS DEFINITIONS
OraIndentHeader	Indents second and later occurrences of subheaders 20 pixels relative to page header
OraSpacingHeader	Spacing for Page Title Header: 7 pixels above and 2 below
OraSpacingHeaderSub	Spacing for first SubHeader on page: 10 pixels above and 2 below
OraSpacingHeaderLarge	Spacing for second and later occurrences of subheaders: 20 pixels above and 2 below

Dynamically Change the color of rows in advanced table region

Step1: Call this below code from ProcessRequest(............,.............) 

OAAdvancedTableBean table = (OAAdvancedTableBean)webBean.
findIndexedChildRecursive("ResultsTable");
OAColumnBean ejobcol = (OAColumnBean)webBean.
findIndexedChildRecursive("Column3");
OAMessageStyledTextBean job = (OAMessageStyledTextBean)ejobcol.
findIndexedChildRecursive("Job");
OADataBoundValueViewObject cssjob = new OADataBoundValueViewObject(job,"Color");
job.setAttributeValue(oracle.cabo.ui.UIConstants.STYLE_CLASS_ATTR, cssjob);

Step2: Edit custom.xss and paste the below Code:

Path:   C:\santhoshJdev\jdevhome\jdev\myhtml\OA_HTML\cabo\styles.

Write the following code at <!--Please start your customization at here ----!> 

<style selector=".1">
<includeStyle name="DefaultFontFamily"/>
<property name="background-color">#FF0000</property>
</style>
<style selector=".2">
<includeStyle name="DefaultFontFamily"/>
<property name="background-color">#FFCC00</property>
</style 

Step 3: save and run...now the output will be

Creation of Side Navigation dynamically...to the page

/*===========================================================================+
| Copyright (c) 2001, 2005 Oracle Corporation, Redwood Shores, CA, USA |
| All rights reserved. |
+===========================================================================+
| HISTORY |
+===========================================================================*/
package cisco.oracle.apps.pa.revenue.webui;

import oracle.apps.fnd.common.VersionInfo;
import oracle.apps.fnd.framework.webui.OAControllerImpl;
import oracle.apps.fnd.framework.webui.OAPageContext;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean;
import oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean;
import oracle.apps.fnd.framework.webui.beans.OAWebBean;
import oracle.apps.fnd.framework.webui.OASideBarHelper;
import oracle.apps.fnd.framework.webui.beans.nav.OASideNavBean;
import oracle.apps.fnd.framework.webui.OAWebBeanConstants;
import oracle.apps.fnd.framework.webui.beans.nav.OALinkBean;

/**
* Controller for ...
*/
public class SideNavigationCO1 extends OAControllerImpl
{
public static final String RCS_ID="$Header$";
public static final boolean RCS_ID_RECORDED =
VersionInfo.recordClassVersion(RCS_ID, "%packagename%");

/**
* Layout and page setup logic for a region.
* @param pageContext the current OA page context
* @param webBean the web bean corresponding to the region
*/
public void processRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processRequest(pageContext, webBean);
createSideNavigation(pageContext, webBean);
}

/**
* Procedure to handle form submissions for form elements in
* a region.
* @param pageContext the current OA page context
* @param webBean the web bean corresponding to the region
*/
public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
{
super.processFormRequest(pageContext, webBean);
}

public void createSideNavigation(OAPageContext pageContext, OAWebBean webBean)
{
OASideNavBean sideNav = (OASideNavBean)createWebBean(pageContext,
OAWebBeanConstants.SIDE_NAV_BEAN,
null, // no need to specify a data type
"sideNav" // always specify name
);
OAStackLayoutBean search =
(OAStackLayoutBean)createWebBean(pageContext,
"/cisco/oracle/apps/pa/revenue/webui/SideSearchRN",
"SideSearchRN", // always specify name
true); // region created in Oracle
sideNav.addIndexedChild(search);
OAPageLayoutBean pageBean = (OAPageLayoutBean)webBean.findIndexedChildRecursive("pageLayoutRN");

pageBean.addIndexedChild(sideNav);

OALinkBean link1 = (OALinkBean)createWebBean(pageContext,
OAWebBeanConstants.LINK_BEAN,
null,
"AllOfferings");
link1.setText("All Offerings");
link1.setDestination("OA.jsp?page=/cisco/oracle/apps/pa/revenue/webui/AllIOfferingPG&retainAM=Y");
sideNav.addIndexedChild(link1);

OALinkBean link2 = (OALinkBean)createWebBean(pageContext,
OAWebBeanConstants.LINK_BEAN,
null,
"MyOfferings");
link1.setText("My Offerings");
link1.setDestination("OA.jsp?page=/cisco/oracle/apps/pa/revenue/webui/MyOfferingPG&retainAM=Y");
sideNav.addIndexedChild(link2);

OALinkBean link3 = (OALinkBean)createWebBean(pageContext,
OAWebBeanConstants.LINK_BEAN,
null,
"Alerts");
link1.setText("My Offerings");
link1.setDestination("OA.jsp?page=/cisco/oracle/apps/pa/revenue/webui/AlertPG&retainAM=Y");
sideNav.addIndexedChild(link3);
search.render(true);
sideNav.render(true);
link1.render(true);
link2.render(true);
link3.render(true);
pageBean.render(true);
}
}

OAF Page Personalization....adding two columns and button as programatically to the table region

  private void addSelectColumn(OAPageContext pageContext, OAWebBean webBean)
  {
    String voName = "AvailableCCTrxnVO";
   
    OAAdvancedTableBean unUsedCCTxnsTable = (OAAdvancedTableBean)webBean.findIndexedChildRecursive("TransactionsListOnlyT");
   
    if(unUsedCCTxnsTable != null) //If not able to find the table, skip the process
    {
      //Create new column Category to the table
       OAColumnBean categoryCol = (OAColumnBean)createWebBean(pageContext, COLUMN_BEAN, null, "XxcfiCategoryColumn1");
       OASortableHeaderBean column1Header = (OASortableHeaderBean)createWebBean(pageContext, SORTABLE_HEADER_BEAN, null, "XxcfiCategoryColumn1Header1");
       column1Header.setText("Category");
       categoryCol.setColumnHeader(column1Header);
       // Create the actual leaf item under the first column
       OAMessageStyledTextBean leaf1 = (OAMessageStyledTextBean)createWebBean(pageContext, MESSAGE_STYLED_TEXT_BEAN, null, "XxcfiCategoryColumnLeaf1");
       leaf1.setViewAttributeName("Category");
       categoryCol.addIndexedChild(leaf1);
      
      //Create Multi Select Check box
      OAMultipleSelectionBean mBean = (OAMultipleSelectionBean)createWebBean(pageContext, MULTIPLE_SELECTION_BEAN, null, "XxcfiMultiSelect1");
      mBean.setViewUsageName(voName);
      mBean.setViewAttributeName("SelectFlag");
      mBean.setDisabledBinding(new OADataBoundValueViewObject(mBean, "DisableSelection", voName));
      mBean.setText("Select:");
     
      //Create selection button Categorize as Personal and add it to Multi Select Check box
      OASelectionButtonBean categorizePersoanlBtn = (OASelectionButtonBean)createWebBean(pageContext, BUTTON_SELECTION_BEAN, null, "XxcfiCategorizeAsPersonal1");
      categorizePersoanlBtn.setText("Categorize as Personal");
      mBean.addIndexedChild(categorizePersoanlBtn);
     
      /*
      //Create selection button Categorize as Business and add it to Multi Select Check box
      OASelectionButtonBean categorizeBusinessBtn = (OASelectionButtonBean)createWebBean(pageContext, BUTTON_SELECTION_BEAN, null, "XxcfiCategorizeAsBusiness1");
      categorizeBusinessBtn.setText("Categorize as Business");
      mBean.addIndexedChild(categorizeBusinessBtn);
      */

      //Add Multi Select Check box to the table
      unUsedCCTxnsTable.setTableSelection(mBean);
     
      //Add new column Categroy to the table
       unUsedCCTxnsTable.addIndexedChild(categoryCol);
    }
  }


For multiple selection bean item
the following code has to be use for selecting or deselecting


  /*
   * Get the specified VO from application module. If not found in AM, create a view object and return
   */
  public OAViewObjectImpl getVO(OAPageContext pageContext, OAWebBean webBean, String voName, String voPath)
  {
 
      logDebugMessage(pageContext, "Entered getVO", OAFwkConstants.STATEMENT);
      OAApplicationModule am = pageContext.getApplicationModule(webBean);
      OAViewObjectImpl vo = (OAViewObjectImpl)am.findViewObject(voName);
     
      logDebugMessage(pageContext, "vo = "+vo, OAFwkConstants.STATEMENT);
     
      if (vo == null) {
          return (OAViewObjectImpl)am.createViewObject(voName, voPath);
      }

      String path = vo.getViewDefinition().getFullName();
      if (path.equals(voPath)) {
          return vo;
      } else {
          vo.remove();
          return (OAViewObjectImpl)am.createViewObject(voName, voPath);
      }
  }
 
  public void logDebugMessage(OAPageContext pageContext,String messageText, int logLevel)
  {
    if (pageContext.isLoggingEnabled(logLevel))
      pageContext.writeDiagnostics(this, messageText,logLevel);
  }


  private void categorizeCCTransactions(OAPageContext pageContext, OAWebBean webBean)
  {
    String voName = "AvailableCCTrxnVO";
   
    String categorizeAsPersonal = pageContext.getParameter("XxcfiCategorizeAsPersonal1");
    String categorizeAsBusiness = pageContext.getParameter("XxcfiCategorizeAsBusiness1");
   
    if(categorizeAsPersonal != null || categorizeAsBusiness != null)
    {
      OAApplicationModule am = pageContext.getApplicationModule(webBean);
      OAViewObject vo = (OAViewObject)am.findViewObject(voName);
      Row[] rows = vo.getFilteredRows("SelectFlag", "Y");
      StringBuffer whereClause = new StringBuffer();
      if(rows != null && rows.length > 0)
      {
        OAViewObject ccVO = getVO(pageContext, webBean, "XxcfiCreditCardTransactionsVO1", "oracle.apps.ap.oie.creditCard.server.CreditCardTransactionsVO");
        whereClause.append(" trx_id in (");
        for (int i = 0; i < rows.length; i++)
        {
          whereClause.append(rows[i].getAttribute("TrxId"));
          if(i+1 < rows.length)
            whereClause.append(",");

        }
        whereClause.append(")");
        ccVO.setWhereClause(null);
        ccVO.setWhereClause(whereClause.toString());
        ccVO.executeQuery();
      
        CreditCardTransactionsVORowImpl row = (CreditCardTransactionsVORowImpl)ccVO.first();
        while(row != null)
        {
          CreditCardTransactionEOImpl eo = ((CreditCardTransactionEOImpl)row.getEntity(0));
         
          if(categorizeAsPersonal != null)
          {
            row.setCategory("PERSONAL");
            eo.setCategory("PERSONAL");
            eo.setReportHeaderId(new Number(-888999));
          }
          else if(categorizeAsBusiness != null)
          {
            row.setCategory("BUSINESS");
            eo.setCategory("BUSINESS");
          }
         
          row = (CreditCardTransactionsVORowImpl)ccVO.next();
        }
       
        am.getOADBTransaction().commit();
       
        String selectedCard = pageContext.getParameter("CreditCardPoplist");
        pageContext.putTransactionValue("SelectedCard", selectedCard);
        Serializable[] params = {selectedCard};
        am.invokeMethod("initCCTrxn", params);
      }
    }

  }

before page change

We need to add two more columns to the table region such as select check box and category

And we need to add one button as category as personal

after page change:

when category as personal select flag is disable

when category as business then select flag is enabled

How to Use JAVA Script in OAF Page

Call this method from Process Request Or Process Form Request based on the requirement

protected void changeLinkColor(OAPageContext pageContext, OAWebBean webBean)
      {
        //Create Java script function to hide Select All and Select None links
        StringBuffer scriptFunction = new StringBuffer(400);
        scriptFunction.append("function changeLinkColor(){");
        scriptFunction.append("  var arrElements = document.getElementsByTagName(\"a\");");
        scriptFunction.append("  for (var i=0; i<arrElements.length; i++) {");
        scriptFunction.append("      var element=arrElements[i];");
        scriptFunction.append("    if(element.id.indexOf(\"ManagerName\") != -1)");
        scriptFunction.append("      element.style.color = '#ed1c24'; ");
        scriptFunction.append("    }");
        scriptFunction.append("  }");

        //put the java script function in pagecontext
        pageContext.putJavaScriptFunction("changeTableLinksColorToRed", scriptFunction.toString());

        OAWebBean body = pageContext.getRootWebBean();
        if (body instanceof OABodyBean)
          ((OABodyBean)body).setOnLoad("changeLinkColor();"); //call the javascript function when the page loads
      }