Search Results pa_perf_object_rules_pub




Overview
Explore in AI Chat

Overview

PA_PERF_OBJECT_RULES_PUB is a public PL/SQL API package in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema. It provides the programmatic interface for maintaining records in the PA_PERF_OBJECT_RULES table, which associates performance rules with specific project objects. In the Oracle Projects architecture, performance rules drive the calculation and application of performance-based attributes — for example, how burden schedules, revenue accrual, or billing characteristics are applied to a given project, task, or resource object. The package encapsulates the data manipulation logic for the PA_PERF_OBJECT_RULES entity so that forms, concurrent programs, and custom extensions can create, modify, and validate these associations without issuing direct DML against the underlying table.

The package header carries the version identifier 120.1 (dated 2005/08/19), indicating that the interface has remained stable across the 11i, 12.1.1, and 12.2.2 releases. Its classification as a PUB package means it is documented and supported for external invocation by Oracle development standards.

Key Procedures and Functions

The package exposes four documented procedures:

  • CREATE_RULE_OBJECT — Inserts a new row into the PA_PERF_OBJECT_RULES table, establishing a relationship between a performance rule and a project object. This is the procedure most frequently sought when users search for "create_rule_object." It accepts the object rule identifier, object type and identifier, rule identifier, record version number, and standard WHO audit columns (creation date, created by, last update date, last updated by, last update login), several of which default from FND_GLOBAL and SYSDATE.
  • UPDATE_RULE_OBJECT — Modifies an existing row in PA_PERF_OBJECT_RULES, allowing the object-to-rule association and its audit attributes to be revised.
  • DELETE_RULE_OBJECT — Removes a rule-object association from the table.
  • VALIDATE_RULE_OBJECT — Performs validation logic on a proposed rule-object association, verifying data integrity and business-rule compliance before the record is persisted.

All four procedures follow the standard Oracle EBS API convention of returning a status indicator together with message count and message data output parameters, enabling callers to detect and report errors programmatically.

Tables Accessed

The package operates primarily against the PA_PERF_OBJECT_RULES table, accessed through its APPS synonym. This table stores the intersection data linking performance rules to project objects. CREATE_RULE_OBJECT inserts into it, UPDATE_RULE_OBJECT and DELETE_RULE_OBJECT modify and remove its rows, and VALIDATE_RULE_OBJECT reads it to confirm the validity of the proposed association. The API also references FND_GLOBAL for session context values (user ID and login ID) used to populate audit columns.

Usage Notes

PA_PERF_OBJECT_RULES_PUB is typically invoked by Oracle Projects setup and maintenance forms that manage performance rules, and by concurrent programs or batch processes that configure or migrate rule-object associations. Custom code should call this public API rather than inserting or updating PA_PERF_OBJECT_RULES directly, so that validation and WHO audit-column handling are applied consistently. Because the metadata records no other packages referencing this one, it functions as a leaf-level API within the Projects rule configuration chain. When calling the procedures, always inspect the returned status and message parameters to handle validation failures gracefully, and ensure the caller's FND_GLOBAL session context is initialized so that default audit values are populated correctly.