Search Results validate_process_rec

Overview

AMW_PROCESS_PVT_W is a private PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema. The trailing _W suffix identifies it as a wrapper generated by Oracle's Rosetta/AD business logic infrastructure, which bridges Java-based middle-tier components with PL/SQL database APIs. Its logical name, AMW_PROCESS, belongs to the Application Management Workspace (AMW) product family, which supports the configuration and management of process definitions used by EBS application modules.

The package encapsulates the business logic required to create, update, and validate process records, and exposes a bulk array-copy mechanism that converts between the JDBC-style typed arrays (JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_200, JTF_NUMBER_TABLE, and JTF_DATE_TABLE) and the record-based collection type AMW_PROCESS_PVT.PROCESS_TBL_TYPE. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the package owner. Its API classification is OTHER, reflecting that it is an internal implementation package rather than a public, documented integration API.

Key Procedures and Functions

The nine documented procedures divide into three functional groups.

• ROSETTA_TABLE_COPY_IN_P3 — Converts a set of positional JTF typed-array parameters into a PROCESS_TBL_TYPE PL/SQL collection. It is the inbound half of the Rosetta array bridge, used when a Java or middle-tier caller passes bulk data into PL/SQL.
• ROSETTA_TABLE_COPY_OUT_P3 — Performs the inverse transformation, unpacking a PROCESS_TBL_TYPE collection back into individual JTF typed arrays for return to a non-PL/SQL caller.
• CREATE_PROCESS_REC — Creates a single process record, applying the record-level business logic required before persistence.
• CREATE_PROCESS — Creates process entities, typically operating against the collection payload prepared by the copy-in routine.
• UPDATE_PROCESS_REC — Updates a single process record by applying modifications to an existing record structure.
• UPDATE_PROCESS — Updates process entities as a whole, again driven by the collection structure.
• VALIDATE_PROCESS — Performs validation on the process collection prior to commit, enforcing data-integrity rules defined for process definitions.
• VALIDATE_PROCESS_REC — Performs single-record validation, giving row-by-row diagnostics during processing.
• CHECK_PROCESS_ITEMS — The procedure matched by the user's search term. It verifies the line-item details associated with a process, checking the child or item-level records against the expected structure and rules before the parent process record is accepted. This check supports the pre-validation sequence and can also be invoked independently for diagnostic purposes.

Tables Accessed

The only documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is the PL/SQL interface table used by the Oracle Forms/AD infrastructure for large-object and item storage during interactive processing. Because AMW_PROCESS_PVT_W is a Rosetta wrapper, most of its persistence work is delegated to the underlying AMW_PROCESS_PVT package; the wrapper itself mainly manages parameter marshalling for that interface table and the surrounding process tables.

Usage Notes

AMW_PROCESS_PVT_W is not intended for direct invocation by end users or integrators. It is referenced by zero other packages in the documented dependency set, which is typical for a top-level Rosetta wrapper: it is called from the Java/middle-tier business logic layer, from Oracle Forms invocations of the AMW process setup windows, or indirectly by concurrent programs that manage process definitions. Custom code should avoid calling this package directly. The correct integration surface is the underlying public package, AMW_PROCESS_PVT, whose procedures (CREATE_PROCESS, UPDATE_PROCESS, VALIDATE_PROCESS) remain stable across EBS 12.1.1 and 12.2.2. The behavior of the wrapper is functionally identical in both release levels; differences are confined to the surrounding Rosetta runtime and the Java classes that generate the JTF typed-array signatures.