Search Results add_rule

Overview

PON_BIZRULE_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It encapsulates the business logic governing document-type rules used within the Advanced Pricing and purchasing negotiation model, specifically the rule definitions that map against buyer auction document types. Within EBS 12.1.1 and 12.2.2 the package is classified under the ETRM metadata as an "OTHER" API, indicating it is not a primary public interface intended for external integration but rather an internal maintenance layer. Its principal role is to provide a controlled, centralized mechanism for creating, modifying, and removing business rules associated with document types. By isolating this logic in a single package, Oracle ensures that referential integrity between a rule and its owning document type is preserved whenever a rule is added, changed, or deleted.

Key Procedures and Functions

The package exposes three documented procedures. The entry point most commonly referenced by developers and support personnel is ADD_RULE, identified in the source header as the first public routine. It accepts a rule identifier and performs the insertion of a new business rule tied to a document type. The companion procedure DELETE_RULE removes an existing rule by its identifier, cleaning up the associated rule record. The third procedure, EDIT_RULE, applies modifications to an existing rule. Each procedure is parameterized by a single rule identifier (p_rule_id NUMBER); no other parameters are documented, and no parameter lists should be assumed beyond this identifier. Together the three routines form a complete maintenance cycle — create, update, delete — for the underlying rule data. The header comment (PONBIZRS.pls 120.0, dated 2005) reflects the long-standing stability of this interface across EBS releases.

Tables Accessed

Two tables are documented as being referenced through APPS synonyms. PON_AUC_DOCTYPES holds the auction or negotiation document type definitions and serves as the parent entity against which rules are defined. PON_AUC_DOCTYPE_RULES stores the individual rule records that link back to those document types. The ADD_RULE, EDIT_RULE, and DELETE_RULE procedures operate primarily against PON_AUC_DOCTYPE_RULES while validating the associated document type in PON_AUC_DOCTYPES. Because both objects are accessed via APPS synonyms, any custom code invoking this package must do so from an environment where those synonyms resolve correctly, typically an APPS-privileged session.

Usage Notes

ETRM metadata records that PON_BIZRULE_PKG is referenced by zero other packages, indicating it is invoked directly rather than chained through other PL/SQL units. Typical invocation paths include the purchasing or sourcing setup forms that administrators use to configure document-type rule behavior, and custom extensions or data-migration scripts that need to programmatically seed rule definitions. Because the package is classified as OTHER rather than a supported public API, Oracle does not guarantee interface stability; custom code should call it only after confirming compatibility with the target EBS version. In 12.1.1 and 12.2.2 the procedures remain unchanged, so existing invocations referencing p_rule_id continue to function without modification. Developers should treat the rule identifier as a pre-existing key sourced from the rule tables, since the package does not document any rule-creation side effects beyond the identifiers supplied.