Search Results chk_approved

Overview

PER_PPC_BUS is the business-layer PL/SQL package responsible for maintaining and validating records in the Pay Proposal Components entity within Oracle EBS Human Resources and Payroll. It functions as the internal table handler for the PER_PAY_PROPOSAL_COMPONENTS table, encapsulating the row-level validation rules that govern insert, update, and delete operations on pay proposal component data. Pay proposals represent proposed changes to an employee's pay, such as adjustments to a salary basis, changes to a rate or amount, or modifications to grade and step progression; the components table stores the individual line items that make up a given proposal. The package is bound to the underlying table handler generated by Oracle's PL/SQL table-handler framework: the header comment (peppcrhi.pkh) and the presence of return_legislation_code, insert_validate, update_validate, and delete_validate confirm that PER_PPC_BUS supplies the business rules invoked by that framework. Its procedures enforce data integrity before DML reaches the base table and, where a rule is violated, raise application errors that terminate processing. The package is classified as OTHER, indicating it is an internal implementation package rather than a formally published public API, and is referenced by four other packages in the applications schema.

Key Procedures and Functions

• CHK_APPROVED — The procedure surfaced by the "chk_approved" search. It validates that a pay proposal component cannot be flagged as approved when its change amount or change percentage is null. The documented preconditions are a valid pay_proposal_id and already-validated or derived change amount and change percentage values; on failure it raises an application error and halts processing. Access status is documented as "Internal Table Handler Use Only."
• INSERT_VALIDATE — Enforces the validation rules applied when a new row is created in PER_PAY_PROPOSAL_COMPONENTS, ensuring required attributes and cross-field relationships are satisfied before the insert proceeds.
• UPDATE_VALIDATE — Applies the corresponding validation logic when an existing component row is modified, guarding against updates that would leave the record in an inconsistent state.
• DELETE_VALIDATE — Confirms that a component row may be removed, preventing deletion of records that are still referenced or otherwise protected by business rules.
• RETURN_LEGISLATION_CODE — A framework support function that returns the legislation code associated with the record being processed. The package body maintains dedicated global variables (g_legislation_code and g_component_id) documented as reserved for use solely by this function, supporting legislation-specific validation branching.

Tables Accessed

• PER_PAY_PROPOSAL_COMPONENTS — The primary entity table; the package reads current column values and participates in the insert, update, and delete validation cycle for its rows.
• PER_PAY_PROPOSALS — The parent pay proposal header, consulted to validate the owning proposal and its context.
• PER_PAY_BASES — Pay basis definitions used to validate or derive amount and percentage change attributes relative to the basis in effect.
• PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F — Payroll element and input value definitions referenced to confirm that component changes map to valid element configuration.
• PER_ALL_ASSIGNMENTS_F — The assignment record for the affected employee, used to establish the employment context against which proposal components are validated.

Usage Notes

PER_PPC_BUS is not intended for direct invocation by end users or custom code. Its procedures are called by the generated table handler that sits beneath the Pay Proposal Components maintenance forms and by the four dependent packages that orchestrate pay proposal processing. The documented access status for CHK_APPROVED explicitly restricts it to internal table handler use. The practical flow is that the table handler performs its standard insert, update, or delete preprocessing, then calls the matching *_VALIDATE routine in this package; chk_approved is invoked within that path whenever the approved flag is being set, ensuring an approval cannot be recorded while the change amount and change percentage remain null. Because the package enforces its rules by raising application errors, callers should expect an exception to propagate when validation fails. Developers extending or troubleshooting pay proposal functionality on 12.1.1 or 12.2.2 should treat PER_PPC_BUS as the authoritative location of component-level validation logic and avoid bypassing it through direct DML on PER_PAY_PROPOSAL_COMPONENTS.