Search Results hr_scl_bus

Overview

HR_SCL_BUS is a generated Business Rules (BUS) layer package in the Oracle E-Business Suite Human Resources (HR) schema. It belongs to the family of packages produced by the Oracle Designer/Forms Generator, which emits a triad of packages for each database entity: a DML package (e.g., HR_SCL_DML) that performs physical inserts, updates, and deletes; a Business Rules package (this object, HR_SCL_BUS) that encapsulates row-level validation and business logic; and a Shared package (HR_SCL_SHD) that declares the record type and other common constructs. The prefix "SCL" associates the package with the HR "Salary Cost" entity family in Oracle HRMS.

Its role is to act as the single point of enforcement for business validation before a row is written to the underlying table. Because it is a generated shell, the delivered version behaves as a pass-through in many EBS releases: the generated code declares the validation entry points but ships them with empty bodies, to be extended by customers or by later patch levels when entity-specific rules must be applied.

Key Procedures and Functions

• INSERT_VALIDATE — Receives the entity's shared record type (declared in HR_SCL_SHD.G_REC_TYPE) and performs validation of the column values supplied for a new row. In the delivered source the procedure body contains only location-tracing calls to HR_UTILITY.SET_LOCATION ("Entering" and "Leaving" markers) with no substantive validation statements, indicating that the delivered behavior is a no-op that unconditionally permits the insert.

No other procedures or functions are documented for this package body, and no additional parameters beyond the IN record should be assumed. Custom validation logic is typically added by customers into this procedure, or into a wrapper, when entity-specific edit checks are required.

Tables Accessed

The documented metadata records no table references via APPS synonyms. This is consistent with a generated BUS package whose INSERT_VALIDATE body contains no DML or query statements. When extended, the package would normally read the target entity table (and any parent/child tables that constrain the row) solely for validation lookups, while all physical writes remain the responsibility of the companion DML package. Foreign-key population and WHO column (CREATED_BY, CREATION_DATE, etc.) stamping are likewise handled outside this package.

Usage Notes

• Invocation path — HR_SCL_BUS.INSERT_VALIDATE is not intended to be called directly by end users. It is invoked by the entity's DML layer (HR_SCL_DML.INSERT_ROW) immediately before the physical INSERT is issued, so that validation and persistence are kept strictly separated.
• Callers — The ETRM metadata records that this package is referenced by one other package, confirming it is consumed internally within the HR schema rather than exposed as a public API.
• Forms and concurrent programs — Where the entity is maintained through an Oracle Forms block, the form calls the DML package, which in turn routes through this BUS package; users therefore exercise INSERT_VALIDATE transparently each time a new record is saved.
• Customization — Because the delivered body performs no validation, sites needing additional edit checks commonly modify HR_SCL_BUS.INSERT_VALIDATE to raise HR_UTILITY application errors. Any such change must be reapplied after patches, and the file should not be regenerated by Designer without preserving the customization. Direct calls from custom PL/SQL are discouraged; custom code should use the same DML entry point the forms use.
• Version applicability — The header revision ($Header: hrsclrhi.pkb 115.3, dated 2002) predates both 12.1.1 and 12.2.2, and the package remains present in both releases with the same generated structure.