Search Results g_less_than

Overview

CSD_PARAMETER_EFFECTIVITY_PVT is a private (PVT) PL/SQL package in the APPS schema that supports the Depot Repair rules engine within Oracle E-Business Suite. Its header identifies the package as created in March 2011 by the developer "subhat" and carries the version tag csdvpres.pls 120.2, shipped with the "noship" designation typical of internal support objects. The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the definer, a pattern commonly used for private helper packages that are not meant to be called directly by end users or external integrations.

Functionally, the package supplies the evaluation logic for return-rule conditions defined in Depot Repair. It exposes the comparison operators used to test parameter values against configured thresholds — equality, inequality, less-than, and greater-than — and packages these as public constants (G_EQUALS, G_NOT_EQUALS, G_LESS_THAN, and G_GREATER_THAN). This constant set is directly relevant to the search term "greater_than": the literal 'GREATER_THAN' is the canonical operator token the rules engine uses when a return rule is defined to fire only when a parameter value exceeds a configured boundary.

Key Procedures and Functions

• PARAMETER_VALUE — Resolves and returns the effective value of a Depot Repair parameter for a given rule condition. It is the core of the "parameter effectivity" behavior implied by the package name: rather than reading a static value, it determines which value applies in the current context.
• GET_SQL_OPERATOR — Maps a rule's stored condition operator (such as the GREATER_THAN constant) into the SQL comparison operator used to build the dynamic predicate the rules engine evaluates. This is the bridge between the declarative operator constants and executable SQL.

No public parameter lists are documented in the ETRM metadata; consumers should treat both routines as internal to the rules engine and reach them only through supported product flows.

Tables Accessed

The package references the following tables through APPS synonyms:

• CSD_PARAMETER_VALUES — stores the parameter values against which effectivity is determined; the primary source for PARAMETER_VALUE.
• CSD_RETURN_RULES_B — the base table holding return-rule definitions, supplying rule identity and header context.
• CSD_RET_RULE_CONDITIONS_B — holds the individual conditions, including the operator token compared against the GREATER_THAN and sibling constants.
• PLITBLM — an Oracle Applications internal table used in PL/SQL table and index-by structures; its presence is a build artifact rather than a business data dependency.

Usage Notes

This package is invoked indirectly by the Depot Repair rules engine when return authorization rules are evaluated, typically from the Depot Repair forms or from concurrent processing that scores return rules. It is classified as PVT, so it is not a supported public API: custom code should not call PARAMETER_VALUE or GET_SQL_OPERATOR directly. The same behavior is available in both 12.1.1 and 12.2.2; the file header version (120.2) indicates no functional divergence between the two releases. Because it is referenced by one other package, changes to it can propagate through the rule-evaluation path, and any debugging of "greater_than" style rule mismatches should begin with the operator mapping returned by GET_SQL_OPERATOR and the value returned by PARAMETER_VALUE.