Results for “create_person_address”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR_PERSON_ADDRESS_SWI is a self-service wrapper package within the Oracle E-Business Suite APPS schema. It provides a controlled entry point through which Oracle Self-Service Human Resources (SSHR) and related web-facing components create and maintain person address records. The "_SWI" suffix denotes a "Self-Service Web Interface" wrapper: rather than exposing the underlying business logic directly, the package layers an internet-facing API over the core person address API, hr_person_address_api. This design isolates the self-service tier from the base HR API, allowing Oracle to apply additional validation, security, and derivations appropriate to web use without altering the core API contract.
In practical terms, the package underpins the address capture and maintenance functionality available to employees and managers through SSHR pages — for example, recording a work or home address, associating a location with a specific city or region, and storing related telephone contact numbers. Because address data is inherently personal and frequently referenced by other HR and payroll processes, the wrapper enforces consistency and validation before the record reaches the base tables.
Key Procedures and Functions
Two procedures are documented for this package:
- CREATE_PERSON_ADDRESS — The self-service wrapper for
hr_person_address_api.create_person_address. It accepts a full set of address attributes (effective dating, primary flag, style, address type, address lines, town or city, regions, postal code, country, and telephone numbers) and returns a status value indicating success or failure. It supports a validation mode through which the caller may test the operation without committing, and includes an overlap-validation override option for handling date-range conflicts. - UPDATE_PERSON_ADDRESS — The self-service wrapper for
hr_person_address_api.update_person_address. It applies modifications to an existing person address record, preserving the same effective-dating and status-return conventions as the create operation.
Both procedures are classified under the "OTHER" API category and are marked in the source header as being for internal development use only.
Tables Accessed
The documented metadata does not enumerate specific base tables accessed via APPS synonyms. Functionally, the procedures operate against the person address entity managed by hr_person_address_api, which persists records in the PER_ADDRESSES table and associated address usage and telephone tables. The wrapper itself does not introduce separate storage; it delegates all data manipulation to the underlying API, which in turn enforces the business rules governing primary addresses, address styles, and effective-date validity.
Usage Notes
This package is typically invoked indirectly from SSHR web pages and related self-service flows rather than being called directly by end users. The metadata records that two other packages reference HR_PERSON_ADDRESS_SWI, confirming its role as a dependency within the broader HR self-service call stack. Custom development should, as a general rule, call the underlying hr_person_address_api directly rather than the SWI wrapper, since the header explicitly restricts the wrapper to internal development use. Developers integrating with this object should also be aware of its effective-dating and validation parameters, which allow callers to preview changes before committing them. Note that addresses such as regional office or contact details captured for an individual — for instance, a Gurgaon office location recorded against an employee record — would be created and maintained through the procedures described above, with the specific data values held in the underlying address tables rather than in this package definition.