Search Results set_called_from_form

Overview

APPS.PER_PDM_BUS is the business-rules layer of the Person Delivery Methods (PDM) row handler in Oracle HRMS. The package encapsulates the validation logic that governs how delivery method assignments are created, modified, and removed for a person record. It sits beneath the generated row handler (RH) and above the schema-level DML package PER_PDM_SHD, forming the standard Oracle "Row Handler" architecture in which PER_PDM_SHD performs physical inserts, updates, and deletes against the underlying table, while PER_PDM_BUS enforces the declarative and programmatic business rules before that DML is permitted to proceed.

The header comment, dated 2005, identifies the package as internal plumbing generated and maintained by the Oracle HRMS development team; it is not a public, supported API in the same sense as the datetracked person or assignment APIs. Its principal consumer is the delivery-method maintenance user interface in Oracle Forms, with which it communicates through a global boolean flag named g_called_from_form. That flag is set through SET_CALLED_FROM_FORM and causes the validation routines to alter their behaviour when the caller is an interactive form rather than a batch or programmatic process.

Key Procedures and Functions

• INSERT_VALIDATE — Controls execution of all insert business rules for a new person delivery method record. It is a private procedure called from the insert path of the row handler; if a rule fails, the error is not handled internally unless explicitly coded.
• UPDATE_VALIDATE — Performs the equivalent validation for updates to existing delivery method rows, invoked from the update path of the row handler.
• DELETE_VALIDATE — Performs the equivalent validation for deletions, invoked from the delete path of the row handler.
• RETURN_LEGISLATION_CODE — Returns the legislation code associated with the record under validation. It relies on the package globals g_legislation_code and g_delivery_method_id, which the documentation notes are reserved solely for this function's use.
• SET_CALLED_FROM_FORM — Sets the global flag g_called_from_form to true so that validation routines can detect that they were invoked from Oracle Forms code. This is the entry point matched by the user's search term.

Tables Accessed

The package operates on PER_PERSON_DLVRY_METHODS, the table that stores the delivery method assignment for each person; the three validation routines exist to guard inserts, updates, and deletes against this table. It also references PER_ALL_PEOPLE_F, the datetracked people table, most plausibly to resolve the person and derive the applicable legislation context used by RETURN_LEGISLATION_CODE. Access to both objects is through APPS synonyms.

Usage Notes

PER_PDM_BUS is classified as OTHER rather than as a public API and is flagged "Internal Row Handler Use Only" in its own comments. Custom code should therefore not call INSERT_VALIDATE, UPDATE_VALIDATE, or DELETE_VALIDATE directly; the supported route to manipulate person delivery methods is through the corresponding generated row handler or the delivered person APIs. SET_CALLED_FROM_FORM is intended only for the delivered Forms layer, which invokes it before triggering row-handler processing so that g_called_from_form is true for the duration of that interaction. Because the flag is a package global, its value persists for the session and is not reset automatically; callers must account for this when mixing form-driven and programmatic processing in the same database session. The package is referenced by three other packages within the HRMS schema, consistent with its role as a shared internal validation component. In 12.1.1 and 12.2.2 the structure is effectively unchanged, and any extension of PDM validation should be implemented by wrapping the row handler rather than by modifying this package.