Search Results get_att




Overview
Explore in AI Chat

Overview

APPS.PO_WF_REQ_FLEXBUILDER_UPGRADE is a PL/SQL package body in the Oracle E-Business Suite Purchasing module. Its primary business function is to integrate Oracle Purchasing with the Oracle Workflow FlexBuilder account generation framework, specifically for requisition-related workflows. The package builds and validates key accounting flexfield combinations — charge account, budget account, variance account, and accrual account — that are required during the workflow-driven processing of purchase requisitions. These account generation routines are called by workflow activities to derive and return a valid Accounting Flexfield combination based on the FlexBuilder definition associated with a requisition's distribution. By encapsulating this logic in a single package, Oracle ensures that account derivation is consistent across different workflow processes.

The header comments indicate the package was originally created in 1997 and later reworked in 1998 to refine initialization code. The relatively old revision marker (115.9, dated 2002) confirms the object is legacy but still shipped in 12.1.1 and 12.2.2 for backward compatibility.

Key Procedures and Functions

Four public procedures are documented in the ETRM metadata. Each corresponds to a distinct accounting flexfield account type and follows the same design pattern: it is invoked as a workflow notification/function activity handler, accepts the workflow item context, and returns a result string indicating success or failure.

  • CHARGE_ACCOUNT — Builds the charge (expense) account for the specified accounting structure, deriving a valid code combination to be posted against the requisition distribution.
  • BUDGET_ACCOUNT — Derives the budget account used for budgetary control and funds checking during requisition workflow processing.
  • VARIANCE_ACCOUNT — Produces the variance account used to record purchase price or receipt variance when the requisitioned item is processed.
  • ACCRUAL_ACCOUNT — Generates the accrual account applied for period-end accrual entries associated with requisition receipts.

The package body also declares private helper routines, including req_build_account and the workflow attribute accessors Get_att, Get_number_att, and Get_date_att. The user's search term "get_att" refers to this private Get_att procedure, which reads a named workflow item attribute (itemtype, itemkey, attribute name) and returns its varchar2 value for use by the account-building logic. Because these are not exposed in the documented procedure list, they are internal implementation details supporting the four public account procedures.

Tables Accessed

The ETRM metadata does not enumerate any base tables or APPS synonyms directly referenced by this package. Based on the FlexBuilder account-generation purpose, the package operates primarily against workflow runtime data and the Accounting Flexfield structures rather than owning transactional tables. It reads workflow item attributes through the Oracle Workflow APIs and invokes FlexBuilder key flexfield combination validation. No direct DML against Purchasing tables is documented.

Usage Notes

This package is invoked from Oracle Workflow as an activity handler within the requisition approval and account generation workflow. It is not intended for direct concurrent program execution or interactive Forms invocation. It is most relevant when a requisition workflow is configured to use FlexBuilder to construct accounting flexfield combinations dynamically. The metadata indicates it is referenced by zero other PL/SQL packages, confirming that its consumers are workflow definitions rather than other code units. Customizations should treat the four account procedures as the supported interface and avoid dependence on the private Get_att accessors, whose signatures are internal and subject to change. The profile option PO_SET_DEBUG_WORKFLOW_ON controls debug logging, useful when diagnosing account derivation failures.