Results for “set_called_from_form”
48 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PER_PHN_SHD is a shadow (suffix _SHD) specification package owned by the APPS schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Human Resources (PER) product family and provides a shared, server-side PL/SQL definition layer for telephone information stored against persons, parties, and related entities. The package is classified under ETRM as an "OTHER" API rather than a public or private business API, reflecting its role as an internal supporting object rather than a supported integration interface.
The core artifact of the package is the global record type g_rec_type, which mirrors the column structure of the PER_PHONES table. This record includes the primary key phone_id, effective-dating columns (date_from, date_to), descriptive fields (phone_type, phone_number), polymorphic parent linkage columns (parent_id, parent_table), the TCA-related party_id that supports the HR/TCA merge model, the descriptive flexfield attribute columns attribute1 through attribute30, a validity indicator, and the object_version_number used for optimistic locking. The specification also declares the global record variable g_old_rec, a table-name constant g_tab_nam bound to 'PER_PHONES', and the g_called_from_form Boolean flag that tracks whether the package is being driven by an Oracle Forms session. Together these declarations give dependent packages a consistent, reusable type and state definition for phone record manipulation.
Key Procedures and Functions
- CONSTRAINT_ERROR — Error-handling routine invoked when a constraint violation or related integrity condition is detected during processing of PER_PHONES data. It centralises the raising and formatting of constraint-related exceptions so that callers receive a consistent error signal.
- API_UPDATING — Internal guard procedure that determines or asserts whether an API-driven update is currently in progress. It is used to control behaviour such as row version checking and to prevent conflicting direct updates.
- LCK — Locking procedure that acquires and manages row-level locks on the underlying PER_PHONES records, supporting the
object_version_numberoptimistic concurrency scheme. - CONVERT_ARGS — Argument-conversion routine that populates and normalises the fields of the shared
g_rec_typerecord, allowing callers to pass data in a uniform structure regardless of the originating entry point. - SET_CALLED_FROM_FORM — Setter for the
g_called_from_formglobal flag, allowing the calling context (typically an Oracle Forms block handler) to inform the package that execution originates from a form, which affects validation and error-display behaviour.
No parameter lists are documented in the ETRM extract; consumers should treat these as internal helpers rather than callable public APIs.
Tables Accessed
- PER_PHONES (via APPS synonym) — the primary table. It stores telephone records for the Human Resources and TCA data model. The package reads and writes it through the shared record type, and also references its
party_idcolumn datatype as the anchor for the merged HR/TCA party identifier. - ALL_CONSTRAINTS (via APPS synonym) — the data dictionary view over constraints, queried by the constraint-handling logic to resolve and validate constraint names associated with PER_PHONES operations.
Usage Notes
PER_PHN_SHD is referenced by seven other packages, confirming its role as a shared definition and helper layer rather than an end-user entry point. It is typically invoked indirectly: Oracle Forms phone-entry blocks set the called-from-form flag and delegate validation, locking, and update processing to packages that consume this specification. Concurrent programs and custom PL/SQL that manipulate telephone data for HR or TCA records may also reference the record type and helper routines, but direct calls to the internal procedures are unsupported. Because the package is a shadow specification, changes to PER_PHONES column definitions on which g_rec_type depends should be reviewed against this package before an upgrade, ensuring the record type remains consistent with the table in both 12.1.1 and 12.2.2 environments.
-
PACKAGE: APPS.PER_PHN_SHD 12.1.1
-
PACKAGE: APPS.PER_PHN_SHD 12.2.2
-
PACKAGE: APPS.PE_AEI_SHD 12.1.1
-
PACKAGE: APPS.PER_PTU_SHD 12.2.2
-
PACKAGE: APPS.PER_ADD_BUS 12.2.2
-
PACKAGE: APPS.PER_REI_SHD 12.2.2
-
PACKAGE: APPS.PER_PDM_BUS 12.2.2
-
PACKAGE: APPS.PER_PDM_BUS 12.1.1
-
PACKAGE: APPS.PE_AEI_SHD 12.2.2
-
PACKAGE: APPS.PER_ADD_BUS 12.1.1
-
PACKAGE: APPS.PER_PTU_SHD 12.1.1
-
PACKAGE: APPS.PER_REI_SHD 12.1.1
-
PACKAGE: APPS.PER_PDM_BUS 12.1.1
-
PACKAGE: APPS.PER_PDM_BUS 12.2.2
-
PACKAGE: APPS.PER_ADD_BUS 12.1.1
-
PACKAGE: APPS.PER_ADD_BUS 12.2.2
-
PACKAGE: APPS.PER_PHN_SHD 12.1.1
-
PACKAGE: APPS.PER_PHN_SHD 12.2.2
-
PACKAGE: APPS.PE_AEI_SHD 12.2.2
-
PACKAGE: APPS.PE_AEI_SHD 12.1.1
-
PACKAGE: APPS.PER_PTU_SHD 12.2.2
-
PACKAGE: APPS.PER_PTU_SHD 12.1.1
-
PACKAGE: APPS.PER_REI_SHD 12.2.2
-
PACKAGE: APPS.PER_REI_SHD 12.1.1