Search Results ota_bjs_bus




Overview
Explore in AI Chat

Overview

OTA_BJS_SHD is an Oracle Application Object Library package in the APPS schema that supports the Booking Justification functionality within Oracle iRecruitment (part of the Oracle HRMS/OTA module family). Its name follows the common EBS shadow-table convention: the "_SHD" suffix indicates the package participates in maintaining a shadow (mirror) copy of the booking justification records held in the base table OTA_BKNG_JUSTIFICATIONS_B. Shadow packages in Oracle EBS are used by the DateTrack and record-versioning framework to keep a parallel history table synchronized with the base table whenever insert, update, or delete operations occur.

In Oracle EBS 12.1.1 and 12.2.2, this package is classified as API classification OTHER, meaning it is not a public, supported integration API. It is an internal utility invoked by the surrounding OTA_BJS_* package family rather than by external callers. It is documented as VALID in the ETRM repository, and it depends only on the SYS-owned STANDARD package and the PUBLIC synonym ALL_CONSTRAINTS, confirming that its operations are largely generic, metadata-driven PL/SQL logic rather than business-specific computation.

Key Procedures and Functions

ETRM documents four procedures/functions. Parameter lists are not published and must not be assumed.

  • CONSTRAINT_ERROR — A helper that raises or traps constraint-related exceptions. It is typically called when a Data Manipulation Language operation against the justification records violates a database constraint, allowing the caller to translate an Oracle error into an application-level message.
  • API_UPDATING — Signals or tracks that an API-driven update is currently in progress. This is a common EBS pattern used to suppress redundant shadow maintenance or prevent recursive triggers while a base record is being modified.
  • LCK — A locking routine that obtains a row-level or logical lock on a booking justification record, serializing concurrent modifications.
  • CONVERT_ARGS — Converts or normalizes incoming arguments to the internal representation expected by the shadow maintenance logic.

Tables Accessed

The documented references are ALL_CONSTRAINTS and OTA_BKNG_JUSTIFICATIONS_B.

  • OTA_BKNG_JUSTIFICATIONS_B — The base table holding booking justification definitions. OTA_BJS_SHD reads and writes this table as part of maintaining its shadow counterpart, which stores the corresponding effective-dated or historical rows.
  • ALL_CONSTRAINTS — Data dictionary view queried to resolve constraint metadata, most likely to drive the CONSTRAINT_ERROR logic or to validate referential and check constraints dynamically.

Usage Notes

OTA_BJS_SHD is not invoked directly from forms, concurrent programs, or external integrations. It is referenced by four other packages — OTA_BJS_BUS, OTA_BJS_DEL, OTA_BJS_INS, and OTA_BJS_UPD — which respectively provide the business logic, delete, insert, and update entry points for booking justifications. Custom code should call those higher-level packages (or the supported public APIs in OTA_BJS_BUS) rather than this shadow package, since its interface is unsupported and subject to change. Because it is marked API classification OTHER, it should be treated as internal infrastructure in both release 12.1.1 and 12.2.2.