Calling Oracle Applications Functions and Procedures
You execute PL/SQL documents against Oracle Applications systems using the following syntax:
PLSQL
APPL_SHORT_NAME=<application_short_name>
APPL_PACKAGE_NAME=<package_name>
APPL_METHOD_NAME=<doc_full_path>
The APPL_SHORT_NAME and APPL_PACKAGE_NAME are used to validate security, only users that can access the package from the application are allowed to execute the PL/SQL as defined in the document. The APPL_METHOD_NAME points to a document.
The PL/SQL stored in the DocumentMyDoc.pls, for example, should only be executed by users who can run methods of the ALR_PROFILE in the Alert (ALR) application; the process definition would have the following Source:
PLSQL
APPL_SHORT_NAME=ALR
APPL_PACKAGE_NAME=ALR_PROFILE
APPL_METHOD_NAME=doc:Partition1:/Partition2.MyApplication/MyDoc.pls
You add parameters to the process definition as required in your PL/SQL source.
Parameter names starting with _ are not passed on to Oracle Applications and can be used for Redwood Server-specific functionality.