Search Results get_user_id

Overview

APPS.IRC_LOGIN is the login and session-establishment utility package for the Oracle iRecruitment (IRC) product family. In Oracle E-Business Suite 12.1.1 and 12.2.2, iRecruitment exposes candidate and recruiter self-service functionality to external and internal users, including guest access and secure session handoff between the E-Business Suite framework and the iRecruitment web tier. The IRC_LOGIN package body provides the low-level PL/SQL primitives that construct authenticated launch URLs, validate inbound login attempts, and translate session identifiers into the structures required by the application. It is classified under ETRM as API classification OTHER, indicating it is an internal utility rather than a published public API. The package operates exclusively within the APPS schema and depends on the FND foundation layer for user, responsibility, application, security group, node, and function resolution.

Key Procedures and Functions

• CREATEEXECLINK2 — The primary constructor function in the package. It builds a formatted execution link (URL) that references a function, an application, a responsibility, a security group, a target server node, and an optional parameter string. Internally it resolves each of those logical names to its numeric identifier through dedicated cursors against the FND tables, then assembles the link returned to the caller. The signature is not reproduced here; only the documented behavior is described.
• VALIDATE_LOGIN — Performs validation of an incoming login request. Its purpose is to confirm that the supplied credentials, responsibility context, or session attributes are legitimate before the user is granted access to iRecruitment functionality.
• CONVERTSESSION — Converts session information into a form usable by the iRecruitment application runtime. This supports the handoff between the EBS framework session and the iRecruitment web session, ensuring continuity of the authenticated user context.

Tables Accessed

The package reads from six documented tables through APPS synonyms:

• FND_USER — Resolves the guest user identifier, derived by parsing the guest username/password string returned by FND_WEB_SEC.GET_GUEST_USERNAME_PWD(). The code extracts the portion preceding the slash delimiter.
• FND_RESPONSIBILITY — Resolves a responsibility key to its responsibility_id for inclusion in the generated execution link.
• FND_APPLICATION — Resolves an application short name to its application_id.
• FND_SECURITY_GROUPS — Resolves a security group key to its security_group_id.
• FND_FORM_FUNCTIONS — Resolves a function name to its function_id, identifying the target form or function.
• FND_NODES — Resolves a server name to a node_id, with two cursors provided: one matching on node_name and one matching on webhost, both case-insensitive via LOWER().

Usage Notes

IRC_LOGIN is an internal dependency rather than a user-facing API. It is typically invoked by iRecruitment framework code, JSP or web-tier components, and helper packages that construct redirect or execution URLs during login, guest access, or session transfer. Because CREATEEXECLINK2 resolves environment-specific values such as node names and security groups at runtime, generated links are sensitive to the FND configuration in the target instance.

The ETRM metadata records zero packages referencing IRC_LOGIN, which suggests its consumers are web-tier or non-PL/SQL components rather than other documented PL/SQL packages. The package is not intended for direct invocation from custom concurrent programs or forms. Customizations should avoid overriding it, since login and session behavior is tightly coupled to iRecruitment and FND security internals.