Custom Class path setting in Oracle Apps R12

Custom Class path setting in Oracle Apps R12

1) Custom class path setting:

Find Full Class path:

$CLASSPATH

Setting Custom class path for Java compilation:

CLASSPATH=$CLASSPATH:/dbappsd/apps/apps_st/appl/XXLSP/12.0.0/java/classes

Before compilation we have to add entry in ojsp and orien_application files.

2)  Creating array[] (like custom record type) for getter:  

a) XXLSPPrdRec.java
package custom.java.xxlsp;

public class XXLSPPrdRec {   
       public int rowCount;
       public int prdId;
       public String name;
       public int categoryId;
       public int nearness;
       public String partNumber;
       public String UOMCode;
       public String UOMDescription;
       public String type;
     }

b) XXLSPMainClass.java

 package custom.java.xxlsp;

import custom.java.xxlsp.XXLSPPrdRec;

public classXXLSPMainClass
{
private static XXLSPPrdRec[] arrayOfPrdRec = null; 


//Some method call
try
{
       arrayOfPrdRec = new XXLSPPrdRec[i];
      arrayOfPrdRec = getPrdRec(localResultSet, paramString7, paramString8, paramBoolean, "I"); 
}


private static XXLSPPrdRec[] Sample(ResultSet paramResultSet, String paramString1, String paramString2, boolean paramBoolean, String type)
    throws SQLException
  {
    boolean bool = IBEUtil.logEnabled();
    int i = 0;
int m=0;
    int j = 0;
    int k = 0;

    for (m = index; m < i; m++) {
      arrayOfPrdRec[m] = new XXLSPPrdRec();
    }
    m = index;

   
    while (paramResultSet.next()) {
        rsCount++;

      arrayOfPrdRec[m].rowCount = -1;

      arrayOfPrdRec[m].prdId = paramResultSet.getInt(1);

      arrayOfPrdRec[m].name = paramResultSet.getString(2);

      arrayOfPrdRec[m].categoryId = paramResultSet.getInt(3);

      arrayOfPrdRec[m].nearness = paramResultSet.getInt(4);

      if (paramBoolean) {
        arrayOfPrdRec[m].partNumber = paramResultSet.getString(5);
        arrayOfPrdRec[m].UOMCode = paramResultSet.getString(6);
        arrayOfPrdRec[m].UOMDescription = paramResultSet.getString(7);
      }

      m++;
    }



 }