Search Results irc_web




Overview
Explore in AI Chat

Overview

IRC_WEB is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM metadata as an OTHER API. The package belongs to the Oracle iRecruitment product family, as indicated by the IRC prefix, and its header comment (ircweb.pkh 120.0, dated 2005/07/26) places its origin in the early iRecruitment development cycle that predates the 12.1.1 and 12.2.2 releases.

The package provides a thin server-side interface used by iRecruitment web pages to render and manage recruiting-related content. Rather than exposing business logic directly, IRC_WEB acts as a presentation-oriented entry point: each procedure accepts a single VARCHAR2 parameter, conventionally named M, which carries a mode or context token that the procedure uses to determine what to display or correct. The procedures emit output through Oracle's HTP package, which generates HTML directly from the database tier. This design reflects the classic Oracle EBS web architecture in which PL/SQL packages produce markup consumed by the self-service iRecruitment pages.

IRC_WEB is not a general-purpose business API. It is intended for internal use by the iRecruitment application layer, and the source header carries the noship designation, indicating that it is not shipped as a standalone object but delivered as part of the broader iRecruitment codebase. The package is not referenced by any other documented package, confirming its role as a leaf-level utility invoked directly from the application tier.

Key Procedures and Functions

The package exposes four documented procedures, each taking a single VARCHAR2 parameter (named M in the source header) that controls its behavior. No additional parameter lists are defined in the documented metadata.

  • SHOW_VACANCY — Renders vacancy-related content for the iRecruitment web interface. The M parameter supplies the mode or context that determines which vacancy view is produced.
  • SHOW_CANDIDATE — Renders candidate-related content, supporting the display of candidate information within the iRecruitment self-service pages.
  • SHOW_APPROVAL — Displays approval-related content, used when a recruiting action requires review or authorization within the iRecruitment workflow.
  • CORRECT_APPROVAL — Supports correction of approval data. Unlike the three SHOW procedures, which are read-oriented, this procedure implies a write or adjustment path for approval records that require remediation.

Each procedure is driven by the same single-argument convention, which keeps the public interface compact and consistent across the four operations.

Tables Accessed

The documented tables accessed via APPS synonyms indicate the package's functional dependencies:

  • FND_FORM_FUNCTIONS — The Oracle Application Object Library table that defines form functions. IRC_WEB likely uses it for function security or menu context associated with the iRecruitment pages.
  • PER_ALL_PEOPLE_F — The effective-dated HR people table, providing person records for candidates and approvers.
  • PER_RECRUITMENT_ACTIVITIES — Stores recruitment activity definitions used by the iRecruitment process.
  • PER_RECRUITMENT_ACTIVITY_FOR — Associates recruitment activities with the entities they apply to, supporting activity assignment logic.
  • HTP — Oracle's HTML generation package. While not a data table, HTP is the output mechanism through which all four procedures produce their web content.

Usage Notes

IRC_WEB is typically invoked from the iRecruitment web application tier, where the procedures are called to generate the HTML fragments that compose vacancy, candidate, and approval pages. Because the procedures accept a single mode token, callers are expected to supply the appropriate context value for the desired display or correction behavior.

The package is not designed for direct invocation from Oracle Forms or concurrent programs; it is a web-rendering utility tied to the iRecruitment self-service flow. Custom code should avoid calling these procedures unless it is extending the iRecruitment web layer, since the M parameter is undocumented in detail and behavior is driven by internal conventions. The presence of CORRECT_APPROVAL means any direct use should account for potential data modification. As with all noship objects, supportability is limited to the standard iRecruitment application behavior. The search term "whastwhat web" does not correspond to any documented feature of this package.