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:

Copy

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:

Copy

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.

Importing Oracle Applications Functions and Procedures

See Also