Search Results chk_position_id

Overview

APPS.IRC_IDP_BUS is the business-layer PL/SQL package that implements the server-side row handling logic for the IRC_DEFAULT_POSTINGS entity within Oracle E-Business Suite Release 12.1.1 and 12.2.2. In the Oracle EBS Row Handler architecture, each base table is normally accompanied by a triad of packages: a Table Handler (_TH), a Row Handler (_RH), and a Business package (_BUS). The IRC_IDP_BUS package occupies the business layer of this triad and encapsulates the validation rules that must be satisfied before default posting records are inserted, updated, or deleted.

The package belongs to the iRecruitment module, where default postings define reusable posting templates and default values applied when requisitions or job postings are created. By centralizing validation logic in the business layer, the package ensures that all callers — concurrent programs, forms, and custom APIs — enforce identical data integrity rules regardless of entry path.

Key Procedures and Functions

The documented interface of IRC_IDP_BUS consists of three procedures, each invoked as the final validation step of a corresponding Row Handler DML operation:

• INSERT_VALIDATE — Validates the column values supplied for a new IRC_DEFAULT_POSTINGS row before the insert is committed. It is called from the row handler's insert processing after all individual column checks have completed.
• UPDATE_VALIDATE — Validates proposed column changes on an existing IRC_DEFAULT_POSTINGS record, ensuring updates do not violate cross-column or referential rules before the update is applied.
• DELETE_VALIDATE — Confirms that a default posting record may be removed, allowing the package to block deletion where dependent data or business rules would be violated.

Each procedure accepts the row handler record structure (irc_idp_shd.g_rec_type) as its input argument so that both old and new column values are available for comparison. The package also contains an internally scoped chk_df procedure, marked "Internal Row Handler Use Only," which validates Descriptive Flexfield values and must be invoked as the last step from the insert and update validation paths.

Tables Accessed

Through APPS synonyms, IRC_IDP_BUS references four tables during its validation processing:

• IRC_DEFAULT_POSTINGS — the base table whose rows are being validated; supplies the current and proposed values for the record under processing.
• HR_ALL_POSITIONS_F — the position definition table, consulted to verify that a referenced position identifier (the search term chk_position_id relates directly to this check) exists and is valid.
• PER_JOBS — the job definition table, accessed alongside position validation to confirm the job context of the default posting.
• HR_ALL_ORGANIZATION_UNITS — the organization hierarchy table, used to validate the organization associated with the posting against defined business group structures.

Usage Notes

IRC_IDP_BUS is not intended for direct invocation by end users or custom code. It is called exclusively by the IRC_DEFAULT_POSTINGS row handler as part of the standard Row Handler flow: the table handler delegates to the row handler, which performs per-column validation and then invokes the corresponding INSERT_VALIDATE, UPDATE_VALIDATE, or DELETE_VALIDATE procedure in the business package.

Because the package is referenced by three other packages — the associated row handler, table handler, and any subscribing entity handlers — modifications require careful regression testing across the iRecruitment posting setup paths. The package was last shipped at version 120.0.12010000.2 (file header iridprhi.pkb), consistent across both 12.1.1 and 12.2.2. Customizations should never be applied directly to this seeded package; instead, business rules should be extended through supported personalization or wrapper APIs that invoke the row handler interface.