Search Results po_doc_style_grp




Overview
Explore in AI Chat

Overview

PO_DOC_STYLE_GRP is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM API classification "GRP" (group). It provides the group-level (header-independent) business logic that governs Purchasing document styles — the configurable layouts, terminology, and behavior templates applied to purchase orders, purchase agreements, quotations, and RFQs within Oracle Purchasing. The package encapsulates the validation and lookup rules that determine whether a given document style is standard, whether a proposed style name or alias conflicts with an existing definition, what settings apply to a document style, and whether required attributes have been supplied for a style. It operates as a supporting layer beneath the document style maintenance forms and the PO_DOC_STYLE_PVT private package, exposing reusable validation and query primitives that other Purchasing modules call rather than duplicating logic. Its status is VALID, and it is referenced by thirteen other database objects, confirming its role as a shared utility layer in the document style subsystem.

Key Procedures and Functions

  • IS_STYLE_ALIAS_CONFLICT — Evaluates whether a proposed style alias collides with an alias already assigned to another document style. Used during style creation and update to enforce uniqueness of alias values.
  • IS_STYLE_NAME_CONFLICT — Determines whether a proposed document style name duplicates an existing style name. Invoked by validation flows prior to insert or update of a style definition.
  • IS_STANDARD_DOC_STYLE — Returns whether a given document style is one of the seeded standard (system) styles, which are typically protected from modification or deletion.
  • GET_STANDARD_DOC_STYLE — Retrieves the identifier or definition of the standard document style, allowing callers to default to seeded style behavior.
  • GET_DOCUMENT_STYLE_SETTINGS — Fetches the configuration settings associated with a document style, supplying downstream logic with the style's behavioral attributes.
  • STYLE_VALIDATE_REQ_ATTRS — Validates that required attributes for a document style have been provided, returning validation results to the calling form or API.

Tables Accessed

The package reads PO_DOC_STYLE_HEADERS, the base table holding document style header definitions, to resolve style names, aliases, standard-style flags, and settings. DUAL is referenced for singleton SELECT constructs used in the boolean-style validation functions. Through its dependency chain the package also leans on PO_DOC_STYLE_LINES_VL (the translatable lines view) and PO_DOC_STYLE_PVT (the private implementation package for style maintenance), plus FND_API and PO_MESSAGE_S for API return status and message retrieval. All table references resolve through APPS synonyms.

Usage Notes

PO_DOC_STYLE_GRP is typically invoked indirectly. The Document Styles setup form and the document style maintenance APIs call its validation functions before committing header or line changes; IS_STYLE_NAME_CONFLICT, IS_STYLE_ALIAS_CONFLICT, and STYLE_VALIDATE_REQ_ATTRS act as pre-commit guards. GET_STANDARD_DOC_STYLE and GET_DOCUMENT_STYLE_SETTINGS are consumed by purchasing document entry and by other packages needing default style behavior without opening the setup UI. Because no database object references this package directly from outside its dependency set, customizations should treat it as an internal supporting package: call it from custom PL/SQL only where style validation or style setting retrieval is required, and rely on PO_DOC_STYLE_PVT for full create/update transactions. It is valid and available in both 12.1.1 and 12.2.2.