Results for “create_or_update_phone”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.HR_PROCESS_PHONE_NUMBERS_SS is a server-side PL/SQL package body that supports the Oracle Self-Service Human Resources (SSHR) telephone number maintenance flow within Oracle E-Business Suite 12.1.1 and 12.2.2. The package functions as the transaction-handling layer behind the SSHR "Phone Numbers" pages, which allow employees and managers to add, change, or remove phone records associated with a person during self-service registration and personal information updates.

The "_SS" suffix identifies the package as a Self-Service component. Its design follows the standard SSHR pattern: a Java-based middle tier passes a tabular payload of phone details to PL/SQL, which validates and persists the data through the public HR Phone API rather than performing direct DML. By routing all inserts, updates, and deletes through HR_PHONE_API, the package preserves the Row-Key (RK) and unique-key validation, date-tracked history, and business-group security rules that Oracle HRMS enforces on phone data.

The body is documented with a status of VALID in the APPS schema and is classified under API type OTHER. It is not referenced by any other database object, which confirms that it sits at the top of the SSHR phone-number call stack and is invoked from the Java/OAF layer, WF_ENGINE, or the transaction framework rather than from other PL/SQL packages.

Key Procedures and Functions

The documented package exposes the following entry points:

• CREATE_PHONE — Creates a new telephone record for a person, delegating the actual insert to the HR Phone API after validating the supplied phone type and number.
• UPDATE_PHONE — Modifies an existing phone record, typically resolving the target row by phone ID or object version number and applying date-tracked changes.
• DELETE_PHONE — Removes a phone record through the API's delete path, honoring the effective-dating rules of the underlying phone entity.
• CREATE_OR_UPDATE_PHONE — A combined handler that determines whether the incoming phone row is new or existing and dispatches to the appropriate create or update logic; this is the typical entry point for a "save" action on the SSHR page.
• GET_PHONE_DATA_FROM_TT — Extracts phone attributes from an incoming PL/SQL table type (the SSHR_CON_PHONE_DETAILS / SSHR_PHONE_DETAILS collections) so the values can be processed by the remaining routines.
• PROCESS_API — Orchestrates the API call sequence, coordinating the transaction and API framework before handing control to HR_PHONE_API.
• GET_TRANSACTION_DETAILS — Returns transaction-level context, such as the transaction step and value collections used by the HR API transaction framework.

Additional helper logic is implied by the two remaining documented routines; parameter signatures are not exposed in the ETRM metadata and should be inspected in the database.

Tables Accessed

The package accesses the following documented objects:

• PER_PHONES — The base table storing all phone records for persons; read and written indirectly via HR_PHONE_API.
• PER_ALL_PEOPLE_F — Used to resolve the person, business group, and effective date context for the phone operation.
• HR_API_TRANSACTION_STEPS and HR_API_TRANSACTION_VALUES — Populated by the HR transaction framework to record each API call made during the SSHR transaction, enabling rollback and auditing.
• WF_ITEM_ATTRIBUTES — Supports the SSHR Workflow integration, holding item attributes such as person and transaction identifiers.

Usage Notes

HR_PROCESS_PHONE_NUMBERS_SS is invoked from the SSHR self-service layer, not directly by end users. Typical call paths include the personal information and contact details pages, the new user registration flow (via HR_NEW_USER_REG_SS and HR_PROCESS_CONTACT_SS), and concurrent or workflow-driven processes where phone data is synchronized. Because the package is not referenced by any other database object, customizations should call HR_PHONE_API directly rather than extending this SSHR wrapper, preserving supportability across 12.1.1 and 12.2.2 upgrades.