Calling Oracle Applications Functions and Procedures

You execute PL/SQL documents against Oracle Applications systems using the following syntax:

Copy

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:

Copy

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.

Calling Oracle Applications Functions and Procedures

See Also