Search Results is_enabled

Overview

APPS.POS_UTIL_PKG is a utility package body in Oracle E-Business Suite Purchasing (Oracle Purchasing / iProcurement). It consolidates helper routines that are common to the Purchasing module—boolean conversion, document security clause generation, revision maintenance, and a set of enabled/active flags used for supplier, site, address, and contact-related validation. The package is classified as OTHER in ETRM metadata; it is not a public workflow API but rather an internal service layer invoked by other Purchasing objects. The header file, POSUTILB.pls, is at version 120.1.12000000.3 (2007-08-22). Because POS_UTIL_PKG contains reusable primitives, it is referenced by other packages, making it a candidate for impact analysis whenever Purchasing security or supplier-site logic changes. The is_enabled search that led here typically corresponds to the family of predicate functions (IS_FV_ENABLED, IS_CCR_SITE_ACTIVE, and the various IS_*_CCR checks) that developers use to gate conditional logic at runtime.

Key Procedures and Functions

• BOOL_TO_VARCHAR – Converts a PL/SQL BOOLEAN to a single-character VARCHAR2 ('Y' or 'N'). Used to persist or compare boolean results in SQL contexts where BOOLEAN is not supported.
• RETRIEVE_DOC_SECURITY – Wrapper API that retrieves the WHERE clause enforcing Purchasing document security. It calls PO_DOCUMENT_CHECKS_GRP.PO_Security_Check six times (PO STANDARD/PLANNED, PA BLANKET/CONTRACT, RELEASE BLANKET/SCHEDULED), concatenating clauses and returning status, message, and clause.
• UPDATE_REVISION – Maintains item revision data associated with Purchasing lines.
• IS_FV_ENABLED – Predicate indicating whether a given feature or First-Value/validation capability is enabled.
• FV_IS_CCR – Predicate to determine whether a supplier (or value) is a CCR-registered entity.
• IS_ADDR_CCR – Checks whether an address is CCR-related.
• IS_SITE_CCR – Determines whether a supplier site is CCR-related.
• IS_SUPP_CCR – Determines whether a supplier is CCR-registered.
• IS_CCR_SITE_ACTIVE – Confirms that a CCR supplier site is active.

The CCR functions support federal/central contractor registration compliance used in public-sector purchasing configurations.

Tables Accessed

• AP_SUPPLIER_SITES_ALL – Read by IS_SITE_CCR and IS_CCR_SITE_ACTIVE to inspect supplier site attributes, including CCR status and active flag.
• MTL_ITEM_REVISIONS – Read and updated by UPDATE_REVISION to maintain revision designations on items.
• MTL_SYSTEM_ITEMS_B – Joined to validate item-level revision and inventory context.
• PO_REQUISITIONS_INTERFACE – Referenced for requisition import interface data when validating revisions or document context.

Usage Notes

POS_UTIL_PKG is invoked from Purchasing forms, concurrent programs, and custom code that need consistent boolean conversion, document security WHERE clauses, revision updates, or CCR/is-enabled predicates. Typical call sites include forms raising document security during query execution, and batch processes checking supplier-site CCR status. Because two other packages reference it, changes affect a small dependency chain; regression testing should cover document security queries and supplier site validation.