Search Results approval_process

Overview

APPS.IRC_WEB is a PL/SQL package body belonging to the Oracle E-Business Suite iRecruitment module. Its primary business function is to generate the web-facing entry points for the iRecruitment self-service pages. Rather than containing business logic itself, the package acts as a presentation and navigation layer: it decrypts parameters passed from external or portlet URLs, validates the ICX session, resolves the appropriate FND function, and constructs the target executable URL used to redirect the visitor to the correct iRecruitment page. In effect, IRC_WEB bridges generic Oracle EBS web plumbing (ICX session utilities, FND function and portlet APIs, HTP output) with iRecruitment-specific data such as vacancies, postings, candidates, and approvals.

Key Procedures and Functions

The package body documents four procedures:

• SHOW_VACANCY — Renders or redirects to the vacancy display page. It decrypts the incoming parameter string, unpacks the vacancy and posting identifiers, validates the ICX session, and then builds a URL through either icx_portlet.createExecLink or icx_portlet.createExecLink2 depending on whether the configured notification function exists. This determines whether the visitor is routed to the internal function or to the external site visitor responsibility.
• SHOW_CANDIDATE — Provides the equivalent entry point for the candidate-facing page, following the same decrypt-validate-resolve-URL pattern for a candidate context.
• SHOW_APPROVAL — Serves the approval display entry point, directing the user to the iRecruitment approval page. This is the procedure most relevant to a search on "approval_process", since it governs how an approver reaches a pending approval action from a notification or external link.
• CORRECT_APPROVAL — Handles the corrective approval entry point, used when an approval action must be revisited or amended (for example, a re-submission or correction path within the approval workflow).

All four procedures share a common invocation pattern: an encrypted parameter token is decrypted with icx_call.decrypt, unpacked via icx_on_utilities.unpack_parameters, and the session is validated before any output is produced.

Tables Accessed

The package queries a small, focused set of tables through APPS synonyms:

• PER_RECRUITMENT_ACTIVITIES and PER_RECRUITMENT_ACTIVITY_FOR — joined to resolve the posting content identifier for a given vacancy, ordered by activity start date. This supplies the posting identifier needed to build the target URL.
• FND_FORM_FUNCTIONS — read to retrieve the function name and function identifier for the configured iRecruitment notification URL, which determines the link-building branch taken.
• PER_ALL_PEOPLE_F — referenced for person-level data associated with the candidate or approver context.
• HTP — the Oracle HTML toolkit, used to emit page output rather than to store data.

Usage Notes

IRC_WEB is not a general-purpose API and is not referenced by any other documented package. It is invoked indirectly, typically from iRecruitment notifications, portlet links, or externally generated URLs that carry an encrypted parameter token. The two link-construction branches (createExecLink versus createExecLink2) reflect the decision between routing an authenticated internal user and routing an external site visitor through the IRC_EXT_SITE_VISITOR responsibility with the STANDARD security group. Because the procedures rely on icx_sec.validateSession and FND profile values, they must execute within an established Oracle EBS web session. Customizations that need to launch iRecruitment pages should call these procedures rather than constructing URLs directly, ensuring parameter encryption and session validation remain consistent. The procedures return no application data; their output is a redirect URL or rendered HTML.