Search Results rosetta_table_copy_out_p9

Overview

PA_CI_IMPACT_TYPE_USAGE_PVT_W is a private PL/SQL package body in the APPS schema that supports the Oracle EBS Project Contracts (PA/OKE) integration for Change Impact (CI) impact type usage. Its role is to maintain the association between a change impact class and the impact types that apply to it, so the Contracts and Projects modules can determine which impact types are valid for a given change order scenario. The package is a wrapper (indicated by the "_W" suffix) that adapts a weakly typed public interface, using JTF_VARCHAR2_TABLE_100 collections, to strongly typed private PL/SQL record structures defined in the companion specification package PA_CI_IMPACT_TYPE_USAGE_PVT.

The package header ($Header: PACIIMUB.pls 120.0.12010000.1 2009/06/08) confirms that it has been shipped largely unchanged since 2009 and is classified in ETRM as API classification OTHER, meaning it is an internal, non-public API not intended for direct customer invocation.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P9 — Converts an inbound weakly typed table of impact type codes (JTF_VARCHAR2_TABLE_100) into the strongly typed impact_tbl_type collection used by the private package. It iterates the input collection and populates the impact_type_code attribute of each element.
• ROSETTA_TABLE_COPY_OUT_P9 — Performs the inverse conversion, taking the strongly typed impact_tbl_type collection and expanding it into a JTF_VARCHAR2_TABLE_100 output table. It initializes the output collection, extends it by the input count, and copies each impact_type_code value element by element.
• APPLY_CI_IMPACT_TYPE_USAGE — The main orchestration procedure. It accepts the standard EBS API parameters (p_api_version, p_init_msg_list, p_commit, p_validate_only, p_max_msg_count, p_ui_mode) along with the change impact class code, the change impact type identifier, and the incoming collection of impact type codes. It first invokes ROSETTA_TABLE_COPY_IN_P9 to translate the collection, then delegates processing to the private package, returning x_return_status, x_msg_count, and x_msg_data.

Tables Accessed

The only table referenced through APPS synonyms is PLITBLM, part of the Oracle Application Object Library message infrastructure used for message retrieval and validation feedback. No Project Contracts business tables are accessed directly by this wrapper; persistence of impact type usage records is delegated to the underlying private package. Consequently, the wrapper itself is essentially a data translation and delegation layer rather than a direct data manipulator.

Usage Notes

This package is an internal implementation component. It is not referenced by any other packages in the shipped codebase, and it is not exposed as a public API. It is typically invoked indirectly when a user maintains change impact types and their usage relationships through the Project Contracts or Change Management setup forms. The "_W" naming convention and the presence of the ROSETTA_* copy routines indicate the standard Oracle "rosetta" pattern used to bridge form-bound or Java-bound collection types with PL/SQL-native record types. Customizations should avoid calling APPLY_CI_IMPACT_TYPE_USAGE directly; instead, the supported public API for change impact maintenance should be used. Because the package is private and not committed to backward compatibility, any extension of its behavior should be implemented through supported public APIs, and the package should be assumed to be replaced on patch or upgrade application.