Importing Oracle Applications Functions and Procedures
You import procedures and functions from an Oracle Applications system using the following process definition:
- System_OraApps_PackageMethodImport - imports a specific function or procedure from the specified
<application_short_name>/<package_name>/<procedure_name>
The imported method process definitions have the following syntax:
PLSQL
APPL_SHORT_NAME=<application_short_name>
APPL_PACKAGE_NAME=<package_name>
APPL_METHOD_NAME=<procedure_name>
The ALR/ALR_PROFILE/VALUE function, for example, would have the following Source:
PLSQL
APPL_SHORT_NAME=ALR
APPL_PACKAGE_NAME=ALR_PROFILE
APPL_METHOD_NAME=VALUE
You add function/procedure parameters as required to the process definition; parameter names starting with _ are not passed on to Oracle Applications and can be used for Redwood Server-specific functionality.