PL/SQL Stored Procedure registration in Oracle Apps

Step1) Create a Procedure

Package Specification:
CREATE OR REPLACE PACKAGE H_EMP_PKG
AS
   PROCEDURE H_EMP_DATA (ERRBUF OUT VARCHAR2, RETCODE OUT VARCHAR2);
END H_EMP_PKG;

Package Specification:  
CREATE OR REPLACE PACKAGE BODY H_EMP_PKG
AS
   PROCEDURE H_EMP_DATA (ERRBUF OUT VARCHAR2, RETCODE OUT VARCHAR2)
   IS
      CURSOR C_EMP
      IS
         SELECT EMPNO,
                ENAME,
                SAL,
                HIREDATE,
                DEPTNO
           FROM H_EMP;
   BEGIN
      FOR C_EMP_REC IN C_EMP
      LOOP
         FND_FILE.PUT_LINE (
            FND_FILE.OUTPUT,
               RPAD (C_EMP_REC.EMPNO, 3)
            || ' -- '
            || RPAD (C_EMP_REC.ENAME, 15)
            || ' -- '
            || RPAD (C_EMP_REC.SAL, 10)
            || ' -- '
            || RPAD (C_EMP_REC.HIREDATE, 10)
            || ' -- '
            || C_EMP_REC.DEPTNO);
      END LOOP;
   END H_EMP_DATA;
END H_EMP_PKG;

Step2) Create Executable
Navigation : Application Developer --> Concurrent --> Executable 
Give Execution File Name as Package.Procedure name.


PL/SQL Stored Procedure registration in Oracle Apps, askhareesh blog for Oracle Apps

Step3) Create Concurrent Program
Navigation : Application Developer --> Concurrent --> Program


PL/SQL Stored Procedure registration in Oracle Apps, askhareesh blog for Oracle Apps

Step4) Assign Program to Request group.
 Navigation : System Administrator --> Security --> Responsibility --> Request


PL/SQL Stored Procedure registration in Oracle Apps, askhareesh blog for Oracle Apps

Step5) Run program from Responsibility


PL/SQL Stored Procedure registration in Oracle Apps, askhareesh blog for Oracle Apps

The output is


PL/SQL Stored Procedure registration in Oracle Apps, askhareesh blog for Oracle Apps


*/

No comments:

Post a Comment