Search Results po_session_gt

Overview

PO_AUTOCREATE_UTIL_PVT is a private (PVT) utility package in the Oracle E-Business Suite Purchasing module. Its header comment, $Header: POXVACUB.pls 120.0 2005/06/01, indicates it belongs to the automatic creation (Autocreate) feature set that converts approved requisitions into purchase orders and releases. The package provides the server-side plumbing that supports the Autocreate user interface and its associated workflows, allowing the application to persist transient selection state, validate document option combinations, and coordinate concurrent access to requisition lines while an Autocreate session is in progress.

The name and header constants — G_PKG_NAME, G_MODULE_PREFIX ('po.plsql.' || g_pkg_name || '.') and g_debug_stmt derived from PO_DEBUG.is_debug_stmt_on — confirm that the package is instrumented with the standard EBS debug/logging framework. Although it is classified as a private API and is not intended for direct customer invocation, it is referenced by one other package, reflecting its role as a shared utility layer within the Autocreate code base.

Key Procedures and Functions

The 12.2.2 metadata documents seven procedures and functions, which fall into three functional groupings:

• ADD_REQ_LINES_GT – Adds requisition line identifiers into the PO_SESSION_GT global temporary table for a given session key. The private add_to_builder_reqs_gt routine shown in the source excerpt performs a bulk FORALL insert of the supplied PO_TBL_NUMBER collection into PO_SESSION_GT (key, index_num1), so that builder requisitions are tracked server-side.
• SYNCHRONIZE_BUILDER_REQS and CLEAR_BUILDER_REQS_GT – Synchronize the contents of PO_SESSION_GT with the current set of builder requisitions, first cleaning up existing rows and then reinserting the supplied list; the clear routine removes the session's tracked rows outright.
• GET_AND_LOCK_REQ_LINES_IN_POOL – Retrieves and locks requisition lines held in the Autocreate pool, enforcing concurrency control so that two users do not process the same requisition lines simultaneously.
• CROSSLINKED_OPTION_EXIST, IS_CROSSLINKED_CHILD and IS_PAR_OPTION_LINE_EDITABLE – Validation helpers that determine whether crosslinked sourcing options exist, whether a given item is a crosslinked child, and whether a parallel (PAR) option line remains editable. These support the document-option logic applied when building purchase documents.

Tables Accessed

The package references the following tables through APPS synonyms:

• PO_SESSION_GT — the primary state table, used to hold the session key and index values that track selected requisition lines.
• PO_REQUISITION_LINES_ALL — read during pool retrieval and locking.
• PO_LINES_DRAFT_ALL — accessed in the draft-line validation paths.
• FND_LOG_MESSAGES — written via the standard logging framework when debug output is enabled.
• PLITBLM and DUAL — auxiliary structures used by the PL/SQL table APIs and single-row expression evaluation.

Usage Notes

Because PO_AUTOCREATE_UTIL_PVT is classified as PVT, it is invoked internally by the Autocreate forms and concurrent programs rather than by end users or custom code. It is referenced by one other package in the EBS schema, which is the standard pattern for this utility layer. Developers troubleshooting Autocreate behavior — particularly the po_session_gt search term — should note that residual rows in PO_SESSION_GT generally indicate an Autocreate session that was not cleanly cleared, since the package's synchronize and clear routines are responsible for maintaining that table's contents.