Search Results gen_last_change_date

Overview

APPS.PER_PYP_BUS is a business-layer PL/SQL package within the Oracle E-Business Suite Human Resources (HRMS) schema, dedicated to the validation and maintenance of salary proposals held in the Pay Proposals entity (PER_PAY_PROPOSALS). The object is classified in the ETRM as an "OTHER" API, indicating it is a supporting business-rules package rather than a formally published public API with a fixed interface contract. Its role is to enforce the business rules that govern when a salary proposal may be created, modified, or removed, and to compute and return derived attributes required by the surrounding Pay Proposals processing logic. The package is documented as VALID in the APPS schema for both 12.1.1 and 12.2.2 and exposes sixteen documented procedures and functions, most of which are check or validation routines. It sits beneath the DML-layer packages and user-interface callers and above the base tables and the shadow (audit) table PER_PYP_SHD.

Key Procedures and Functions

The documented routines fall into three functional groups. The first group comprises the record-level validators invoked before database changes are committed: INSERT_VALIDATE, UPDATE_VALIDATE, and DELETE_VALIDATE. These are the primary entry points for the other packages that perform DML on pay proposals. The second group comprises field-level business-rule checks, each addressing a specific attribute of a salary proposal:

• CHECK_NON_UPDATEABLE_ARGS — verifies that protected attributes have not been altered on an update.
• CHK_ASSIGNMENT_ID_CHANGE_DATE — validates the assignment and the associated change date.
• CHK_NEXT_SAL_REVIEW_DATE, CHK_PAY_BASIS_CHANGE_DATE, CHK_CHG_NEXT_SAL_REVIEW_DATE — validate the next salary review date and pay basis change dates against the assignment and legislation rules.
• CHK_PROPOSED_SALARY and IS_SALARY_IN_RANGE_INT — validate that the proposed salary amount is permissible, including range checking against grade rate structures.
• CHK_APPROVED, CHK_FORCED_RANKING, CHK_PERFORMANCE_REVIEW_ID — validate approval status, forced-ranking input, and the performance review reference.

The third group provides derived or utility values: GEN_LAST_CHANGE_DATE generates or defaults the last change date, and RETURN_LEGISLATION_CODE returns the legislation code applicable to the proposal, enabling downstream rule selection. Parameter lists are intentionally not reproduced here; callers should reference the package specification for exact signatures.

Tables Accessed

Through APPS synonyms the package reads and writes PER_PAY_PROPOSALS, the primary salary-proposal table, and references PER_ALL_ASSIGNMENTS_F and PER_ASSIGNMENT_STATUS_TYPES to confirm that the assignment exists and is active on the effective date. Validation of organization and position context uses HR_ALL_ORGANIZATION_UNITS, HR_ALL_POSITIONS_F, and HR_ORGANIZATION_INFORMATION. Payroll and range validation relies on PER_PAY_BASES, PER_PAY_PROPOSAL_COMPONENTS, and PAY_GRADE_RULES_F. Element-related checks access PAY_ELEMENT_TYPES_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_INPUT_VALUES_F, and PAY_LINK_INPUT_VALUES_F. Performance review validation references PER_PERFORMANCE_REVIEWS. The package also references PER_PYP_SHD, the shadow table used for audit and date-tracked history, and the PL/SQL STANDARD package.

Usage Notes

PER_PYP_BUS is not typically invoked directly by end users. It is called by the Pay Proposals DML layer — PER_PYP_INS, PER_PYP_UPD, and PER_PYP_DEL — which in turn are driven by the Pay Proposals form, by Self-Service HR (PER_SSHR_CHANGE_PAY), and by the PERWSEPY_PKG web-service wrapper. In 12.2 the manager and employee self-service salary-change flows route through these same packages, so any customization that alters validation behaviour should be implemented by wrapping or extending the DML packages rather than by modifying PER_PYP_BUS. Because it is classified as OTHER and is not a published API, Oracle does not guarantee interface stability across patches; custom code should call the documented DML packages instead of PER_PYP_BUS directly wherever possible.