procedure APPS_INITIALIZE(user_id in number,
resp_id in number,
resp_appl_id in number);

This procedure sets up global variables and profile values in a database
session. Call this procedure to initialize the global security context for
a database session. You can use it for routines such as Java, PL/SQL,
or other programs that are not integrated with either the Oracle
Applications concurrent processing facility or Oracle Forms (both of
which already do a similar initialization for a database session).

The typical use for this routine would be as part of the logic for launching a
separate non–Forms session (such as a Java program) from an
established Oracle Applications form session. You can also use this
procedure to set up a database session for manually testing application
code using SQL*Plus. This routine should only be used when the
session must be established outside of a normal form or concurrent
program connection.

You can obtain valid values to use with this procedure by using profile
option routines to retrieve these values in an existing Oracle
Applications form session. For manual testing purposes, you can use
Examine during an Oracle Applications form session to retrieve the
profile option values.

USER_ID : The USER_ID number
RESP_ID : The ID number of the responsibility
RESP_APPL_ID : The ID number of the application to which the responsibility belongs


fnd_global.APPS_INITIALIZE (1010, 20417, 201);

Leave a Comment