Search Results chk_exist

Overview

APPS.PER_SPINAL_PT_PLCMT_PKG is a PL/SQL package in Oracle EBS Human Resources (PER) that manages spinal point placements — the assignment of employees or positions to specific points on a grade spine (pay/grade progression structure). It encapsulates the business logic behind the PER_SPINAL_POINT_PLACEMENTS_F and _S tables, which store dated placement records linking an assignment to a placement step within a grade spine. The package declares AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than the definer, and it originates from an 11i-era header (pespp01t.pkh, version 115.4, dated 2003), which remains the basis for its 12.1.1 and 12.2.2 behavior. In ETRM 12.2.2 it is classified as API classification OTHER: a maintenance package used internally by the placement forms and related PER logic rather than a formally published open interface.

Key Procedures and Functions

• CHECK_ASS_END — Validates the end of an assignment (or placement) relative to a session and grade, ensuring the placement does not extend beyond permitted assignment boundaries.
• B_DELETE_VALID — Performs business-rule validation before a placement record is deleted, checking assignment, placement, and effective date context.
• POP_FLDS — Populates derived display fields (step description, step number, spinal point ID, reason description) from a session, step, and reason; its IN OUT NOCOPY parameters return the resolved values to the calling form.
• CHK_EXIST — Checks whether a placement already exists for a given assignment and session date, enforcing uniqueness/overlap rules.
• INSERT_ROW — Inserts a new placement row, including all placement attributes (placement ID, effective dates, business group, assignment, step, parent spine, reason, information category, and the Information1–Information30 descriptive columns) and returns the new rowid and placement ID.
• LOCK_ROW — Issues a row-level lock and consistency check on an existing placement row, supporting the standard Oracle Forms lost-update protection pattern.
• UPDATE_ROW — Updates an existing placement row with the same attribute set as INSERT_ROW.
• DELETE_ROW — Deletes a placement row identified by its rowid.
• POP_CTRL — The procedure surfaced by the user's "pop_ctrl" search; it drives the population/control logic for placement fields (control-level population), typically invoked to refresh or initialize the placement block based on the current placement context before POP_FLDS fills individual field values.
• TEST_PATH_TO_PERWSSPP — A utility procedure testing the code path or journey into the PERWSSPP (Employee Self-Service spinal point placement) functionality.

Tables Accessed

Via APPS synonyms, the package reads and writes PER_SPINAL_POINT_PLACEMENTS_F and PER_SPINAL_POINT_PLACEMENTS_S (the primary dated placement entities), and reads PER_SPINAL_POINT_STEPS_F and PER_SPINAL_POINTS to resolve step and point details used by POP_FLDS and the validation routines. It references PER_GRADE_SPINES_F and PER_PARENT_SPINES to validate hierarchy/grade-spine context, PER_ALL_ASSIGNMENTS_F to validate assignment relationships, BEN_PGM_F for benefits program context, and FND_SESSIONS to identify the current Oracle Forms session in which population and validation calls occur.

Usage Notes

PER_SPINAL_PT_PLCMT_PKG is normally invoked from the Oracle Forms-based grade/spinal point placement maintenance screens and from internal PER server-side logic rather than from concurrent programs. Forms call LOCK_ROW/INSERT_ROW/UPDATE_ROW/DELETE_ROW for standard DML, POP_CTRL and POP_FLDS to initialize and populate placement fields, CHK_EXIST and CHECK_ASS_END for validation, and B_DELETE_VALID before deletions. The package is documented as referenced by one other package, indicating it is also called programmatically from dependent PER API code. Customizations should call these procedures rather than writing directly to the placement tables, since the package encapsulates the required validation, session, and row-locking behavior.