Search Results submission_check_copydoc

Overview

APPS.PO_COPYDOC_SUB is a subordinate PL/SQL package in the Oracle E-Business Suite Purchasing module, classified in the E-Business Suite Technical Reference Manual (ETRM) as an OTHER API. The name reflects its role: a "sub" or helper package that supports the document copy ("Copy Doc") capability in Purchasing. When a user copies an existing purchase order or purchase agreement to create a new document, the application must validate that the source document is eligible for copying, resolve the correct operating unit and inventory context for the copied document, and populate derived attributes. PO_COPYDOC_SUB encapsulates the submission-time validation logic that governs these checks. The package header carries the directive AUTHID CURRENT_USER, indicating that it executes with the privileges of the invoker rather than the definer, so callers must themselves possess the necessary object privileges. The version string in the header dates the source to 2008 and identifies it as a non-shipped (noship) internal unit, consistent with its status as an internal helper rather than a published public API.

Key Procedures and Functions

The ETRM documents a single procedure for this package: SUBMISSION_CHECK_COPYDOC. Its purpose is to perform validation at the point a copy-document request is submitted. Based on the documented parameters, the procedure receives the source purchase order header identifier, a context value for the online report or concurrent request, the set of books identifier, and the inventory organization identifier. It uses these inputs to confirm that the requested copy operation is valid for the specified header within the given financial and inventory context. No parameter list is reproduced here; readers should consult the package specification for exact signatures. No functions are documented for this package.

Tables Accessed

The package reads from a broad set of Purchasing, financials, inventory, and reference tables through APPS synonyms. PO_HEADERS supplies the source document being validated. FINANCIALS_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMS_ALL provide operating unit and set-of-books defaults used to validate the supplied SOB and inventory organization. GL_CODE_COMBINATIONS supports validation of accounting flexfield combinations referenced by the document. Inventory-related reads include MTL_SYSTEM_ITEMS, MTL_ITEM_CATEGORIES, MTL_CATEGORIES_KFV, MTL_CATEGORY_SET_VALID_CATS, MTL_SECONDARY_INVENTORIES, and MTL_ITEM_SUB_INVENTORIES, which are used to confirm item, category, and subinventory validity for the copied lines. BOM_STANDARD_OPERATIONS is accessed for outside-processing or service-related line validation. Organizational and location data come from HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL, and HZ_LOCATIONS, while PA_PROJECTS_ALL supports project-referenced purchasing validation.

Usage Notes

PO_COPYDOC_SUB is invoked indirectly rather than as a standalone public API. It is called by one other package in the application, which supplies the header identifier and financial context during the copy-document flow. In a typical EBS 12.1.1 or 12.2.2 environment, a user initiates a copy from the Purchasing forms or from a concurrent program, and the calling package delegates submission-check logic to SUBMISSION_CHECK_COPYDOC. Because the package uses AUTHID CURRENT_USER, custom code that calls it must run under a schema with appropriate grants on the referenced tables. Customizations should avoid modifying this internal package directly; instead, the supported extension points are the calling APIs and form personalizations. Administrators troubleshooting copy failures should examine the validation conditions enforced here, particularly those relating to the set of books, inventory organization, and item or category eligibility of the source document.