Search Results self_register_user_init

Overview

APPS.IRC_REGISTER_EX_EMP_WF is a PL/SQL package body belonging to the Oracle iRecruitment application module. Its role is to implement the workflow-enabled business logic that supports external employee and candidate self-registration within Oracle E-Business Suite. The package acts as the server-side engine behind the iRecruitment self-service registration flow, bridging Oracle Workflow item attributes with the underlying recruitment data model.

The package name and the workflow-oriented signatures indicate that it is invoked as a Workflow Function Activity rather than as a conventional callable API. Procedures within the package receive standard Oracle Workflow parameters (itemtype, itemkey, actid, funcmode, resultout), which is the canonical contract for PL/SQL functions called from a workflow process definition. The business purpose is to capture, validate, and persist the details supplied by an external registrant during self-registration, including identity data, contact information, and access configuration.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package:

• SELF_REGISTER_USER_INIT — This is the initialization procedure associated with the self-registration workflow. It corresponds to the user search term "self_register_user_init." It is designed to run at the start of the registration activity to establish and initialize the workflow item attributes required by the subsequent save step, such as defaulting or deriving context values before the registration data is written.
• SELF_REGISTER_USER_SAVE — This is the save procedure responsible for persisting the self-registration data. In the documented source excerpt, it declares an extensive set of local variables covering personal and contact attributes: current email address, responsibility and application identifiers, security group, first name, last name, middle names, previous last name, employee number, national identifier, date of birth, email address, home and work phone numbers, address line, manager last name, access flag, language, and user name. Within the RUN function mode it reads workflow item attributes using WF_ENGINE.GETITEMATTRTEXT and WF_ENGINE.GETITEMATTRNUMBER, then processes the registration.

No parameter lists should be assumed beyond the standard workflow function signature evident in the source, which follows the itemtype, itemkey, actid, funcmode, resultout pattern.

Tables Accessed

The documented tables referenced through APPS synonyms are:

• IRC_WF_S — The iRecruitment workflow staging table. This table stores the transient self-registration data captured from the external user before it is processed or transferred into the core recruitment schema. The package reads from and writes to this table to hold registrant attributes.
• DUAL — The standard Oracle single-row utility table, typically used for evaluating expressions, sequences, or simple lookups.

The package additionally interacts with Oracle Workflow engine item attributes via WF_ENGINE calls, which persist workflow state in the workflow runtime tables rather than through direct DML in this package.

Usage Notes

This package is invoked from Oracle Workflow as a Function Activity within the iRecruitment external employee self-registration process. It is not intended to be called directly from a form, concurrent program, or custom code; the standard entry point is the workflow engine, which supplies the itemtype, itemkey, actid, and funcmode parameters. The SELF_REGISTER_USER_INIT procedure runs during activity initialization, while SELF_REGISTER_USER_SAVE executes in RUN mode to persist the collected data.

Because the package is classified as OTHER in the ETRM metadata and is referenced by zero other packages, it is a leaf-level implementation object with no downstream API dependencies. Customizations should avoid modifying the package body directly; instead, standard extension mechanisms should be used to prevent patch conflicts during upgrades across EBS 12.1.1 and 12.2.2.