Search Results set_pad_object

Overview

APPS.BEN_PERSON_OBJECT is a PL/SQL caching package within the Oracle E-Business Suite Benefits module, formally titled "Person Object Caching Routine." Its stated purpose is to return person object information to calling code with reduced database access overhead. The package is declared with AUTHID CURRENT_USER, meaning it executes under the privileges of the invoking schema rather than the package owner.

The package originated in 1999 as part of the Benefits performance architecture and accumulated a substantial version history, reflecting successive additions of cached data structures — person date information, full-time-equivalent (FTE), active life events, benefits balances, assignment extra information, contacts, assignment status types, soft coding keyflex, and person type information. By release 12.1.1 and 12.2.2, the package is classified as an OTHER API in ETRM and is referenced by 29 other packages, making it a foundational dependency in the Benefits object layer.

Key Procedures and Functions

ETRM documents 62 procedures and functions, of which the principal SET_* routines are surfaced. These routines populate the package's global cache structures from underlying base tables:

• SET_OBJECT — the primary entry point for populating the general person object cache.
• SET_PER_OBJECT, SET_TYP_PER_OBJECT, SET_TYP_OBJECT — cache person-level and person-type information.
• SET_ASS_OBJECT, SET_ALL_ASS_OBJECT, SET_APP_ASS_OBJECT, SET_ALLASS_OBJECT — cache assignment information, including applicant assignment variants, designed (per history notes) to handle multirow cases and to resolve employee assignments.
• SET_BENASS_OBJECT, SET_APPASS_OBJECT — cache benefits assignment and applicant assignment records.
• SET_BAL_OBJECT, SET_BAL_PER_OBJECT, SET_BNB_OBJECT — cache benefits balance data, including balances keyed by person and the ben_bnfts_bal_f balance fact.
• SET_CON_OBJECT, SET_PER_OBJECT — cache contacts and contact relationships. The user search term "set_con_object" corresponds to this procedure.
• SET_AST_OBJECT — caches assignment status types.
• SET_HSC_OBJECT — caches soft coding keyflex data.
• SET_PPS_OBJECT — caches periods of service.
• SET_PAD_OBJECT — caches person address information.
• SET_PIL_OBJECT — caches person-in-life-event records.

No parameter lists are documented in the available metadata; callers should inspect the package specification (benperde.pkh) in the target environment.

Tables Accessed

The package reads from the following base tables via APPS synonyms:

• PER_ALL_PEOPLE_F and PER_PERSON_TYPES, PER_PERSON_TYPE_USAGES_F — person and person type data.
• PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_EXTRA_INFO, PER_ASSIGNMENT_STATUS_TYPES, PER_ASSIGNMENT_BUDGET_VALUES_F — assignment details and status.
• PER_ADDRESSES, PER_CONTACT_RELATIONSHIPS — addresses and contacts.
• PER_PERIODS_OF_SERVICE — periods of service.
• BEN_BNFTS_BAL_F, BEN_PER_BNFTS_BAL_F — benefits balance facts.
• BEN_PER_IN_LER — person-in-life-event records.
• HR_SOFT_CODING_KEYFLEX — soft coding keyflex combinations.
• PLITBLM — PL/SQL table storage used internally for caching.

Usage Notes

BEN_PERSON_OBJECT is an internal caching layer rather than a public API. It is invoked from Benefits forms and concurrent programs, and referenced by 29 other packages that rely on its cached person object structures to avoid repeated queries against PER_ALL_PEOPLE_F and assignment tables. Custom code should treat the package as read-oriented cache-population utility: call the appropriate SET_*_OBJECT routine to load data into package globals, then read the cached structures. Because state resides in package globals for the duration of a database session, callers must re-invoke the SET routines whenever underlying data changes or when switching context between persons or assignments. The procedure SET_CON_OBJECT, corresponding to the search term, is the contacts cache loader.