Jsp Manual Compilation process and sample shell script for package and body creation R12

1) Removing existing class files

cd $COMMON_TOP/_pages

rm _xxlsp__ibe*.class

rm _xxlsp__ibe*.stub

rm _xxlsp__ibe*.jpa

 

 2) Manually compiling jsp files

cd $FND_TOP/patch/115/bin

perl ojspCompile.pl --compile -s xxlsp_*.jsp



3) Shell script for PLSQL Package creation

#!/bin/sh
#
# User Input for the driving the shell file
#
echo  "Script to compile the Packages"

#
# Check to see that required parameters have been provided
#

cd  $XLSP_TOP/sql
#
#Connect the Sql plus
#

echo "Enter the APPS user Name"
read appsusr
echo "Enter the APPS Password"
read appspwd
echo  "Connect to SQL PLUS"
sqlplus -s $appsusr/$appspwd << ENDSQL

@XLSPPKGB.pls;
@XLSPPKGS.pls;

4) Sample pls file for spec and body creation

Spec:
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;

create or replace
PACKAGE        "XXLSP_PKG" AUTHID CURRENT_USER AS

PROCEDURE XXSP_PROCEDURE(
                                 p_party_id              IN  VARCHAR2,
                                 p_shipToPartySiteId     IN  VARCHAR2,
                                 x_billToPartySiteId     OUT NOCOPY VARCHAR2
                                 );
END XXLSP_PKG;
/
COMMIT;


body:
WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
create or replace
PACKAGE    BODY    "XXLSP_PKG" AUTHID CURRENT_USER AS
-----------------------------
G_PKG_NAME  CONSTANT VARCHAR2(30):= 'XXLSP_PKG';
G_FILE_NAME CONSTANT VARCHAR2(145):= 'XLSPPG.pls';
-----------------------------
PROCEDURE XXSP_PROCEDURE(
                                 p_party_id              IN  VARCHAR2,
                                 p_shipToPartySiteId     IN  VARCHAR2,
                                 x_billToPartySiteId     OUT NOCOPY VARCHAR2
                                 )
                                 as
                                 begin
                    end XXSP_PROCEDURE;
                               
END XXLSP_PKG;
/
COMMIT;