Search Results chk_position_info_type

Overview

APPS.PE_POI_BUS is an Oracle EBS PL/SQL business logic package that supports the Position Extra Information entity within the Oracle Human Resources (HR) module. In the Oracle E-Business Suite Release 12.1.1 and 12.2.2 codebase, this package belongs to the PE product family and is classified under the OTHER API category in the ETRM repository. It is a business (BUS) layer package, meaning it encapsulates the validation, security context resolution, and datatype conversion rules applied against the underlying Position Extra Information base table.

Position Extra Information is the mechanism through which customers attach user-defined descriptive and validation attributes to positions in the HR organization structure. Each record in the underlying base table is identified by POSITION_EXTRA_INFO_ID and is typed by a corresponding Position Information Type. PE_POI_BUS provides the encapsulated checks and validations that govern inserts, updates, and deletes of these records, together with the security-group resolution and legislation-code resolution routines required in a multi-business-group and multi-legislation Oracle HR installation.

Key Procedures and Functions

The package exposes nine documented procedures and functions, grouped as follows.

• SET_SECURITY_GROUP_ID — resolves and sets the SECURITY_GROUP_ID in CLIENT_INFO for the business-group context that owns the position extra information record identified by P_POSITION_EXTRA_INFO_ID. This is the standard Oracle HR multi-tenant context initialization step executed before DML on the entity.
• RETURN_LEGISLATION_CODE — returns the legislation code associated with the primary key of a specific position extra information record, required for legal-entity and legislative-data processing.
• CHK_POSITION_INFO_TYPE — validates the Position Information Type referenced by the record against the defined information types.
• CHK_POSITION_ID — validates the referenced position identifier.
• CHK_MULTIPLE_OCCURENCES_FLAG — enforces the multiple-occurrence rule, ensuring that a non-repeating information type is not assigned more than once to the same position.
• CHK_NON_UPDATEABLE_ARGS — guards columns that must not be modified on an existing record, raising an error where a protected attribute is supplied on update.
• INSERT_VALIDATE — performs the row-level validation suite required before a new position extra information row is created.
• UPDATE_VALIDATE — performs the row-level validation suite required before an existing row is modified.
• DELETE_VALIDATE — performs the row-level validation suite required before a row is removed.

Tables Accessed

• PER_POSITION_EXTRA_INFO — the primary entity table; read and validated for the target record and written by the insert and update paths.
• PER_POSITION_INFO_TYPES — supplies the definition of the information type, including the multiple-occurrence rule checked by CHK_MULTIPLE_OCCURENCES_FLAG.
• HR_ALL_POSITIONS_F — the positions date-tracked table, used by CHK_POSITION_ID to confirm the referenced position is valid.
• FND_SESSIONS — the application sessions table, consulted in resolving the security group and session context.

Usage Notes

PE_POI_BUS is an internal development layer, reflected in the source header marked "Internal Development Use Only." It is not intended as a public integration API; customers and partners should not call it directly from custom code, as its signature and validation behaviour may change between patch levels. In practice it is invoked from the HR Position Extra Information maintenance forms and from the generated table-handler and business-layer code that Oracle HR forms use for insert, update, and delete operations on the entity. It is also referenced by three dependent packages within the HR object dependency chain. Because each DML path requires the business-group security context, SET_SECURITY_GROUP_ID is typically the first call made before any validation or DML routine. When extending or integrating with Position Extra Information, the supported approach is to use the forms or the higher-level HR public APIs rather than this BUS package.