Results for “rosetta_table_copy_in_p1”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TERRITORY_PUB_W is a public wrapper package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 technology stack, owned by the APPS schema and classified as an OTHER API. It belongs to the JTF (Java Technology Foundation / CRM Foundation) product family and supports Oracle Territory Manager, the shared territory assignment engine used across CRM and order capture modules. The package name suffix "_W" denotes a generated wrapper whose primary purpose is to expose PL/SQL table (collection) types defined inside JTF_TERRITORY_PUB to external callers, including Java, JDBC, and other PL/SQL packages. Because Oracle's Java and thin-client integration layers cannot natively pass or receive associative PL/SQL record collections, wrapper packages such as this one bridge that gap by flattening structured collection types into parallel scalar collections.

Functionally, the package underpins qualification and territory-matching logic: given a set of inbound entities (for example, a customer, contact, or opportunity), the territory engine returns the territory members that won the assignment. The wrapper standardizes the marshalling of that data through the database boundary.

Key Procedures and Functions

The package exposes exactly two documented procedures, both generated. They are:

• ROSETTA_TABLE_COPY_IN_P1 — Converts an inbound set of parallel scalar collections supplied by the caller into the structured PL/SQL collection type jtf_territory_pub.winningterrmember_tbl_type. This is the "copy in" half of the Rosetta marshalling pattern, named after the Rosetta Stone analogy for translation between two representations.
• ROSETTA_TABLE_COPY_OUT_P1 — Performs the reverse translation, taking an instance of jtf_territory_pub.winningterrmember_tbl_type and unpacking it into the caller-supplied parallel scalar collections for consumption outside PL/SQL.

The "p1" suffix indicates a generated partition (P1) of the copy routines, consistent with Oracle's standard Rosetta code-generation convention. Neither procedure contains business logic; they are purely representational translators, and parameter lists should not be assumed beyond the documented signature.

Tables Accessed

The ETRM metadata documents a single referenced table via APPS synonyms: PLITBLM. PLITBLM is an Oracle Applications internal utility table used by PL/SQL table-handling APIs, typically associated with the temporary storage and management of PL/SQL index-by tables during inter-language operations. The wrapper relies on this table indirectly as part of the infrastructure that supports collection marshalling between the Java and PL/SQL layers rather than as a business-data store. No territory definition, territory member, or assignment tables are documented as accessed by this wrapper; those reside in the underlying JTF_TERRITORY_PUB implementation package that this wrapper fronts.

Usage Notes

JTF_TERRITORY_PUB_W is not intended for direct invocation by end users or by typical custom form logic. It is referenced by one other package within the documented dependency set, confirming that it sits beneath a higher-level consumer. Typical invocation paths include:

• Java or JDBC clients calling the territory-matching APIs across the database boundary, where structured territory-member results must be decomposed into scalar arrays.
• Other PL/SQL packages (the documented single referencing package) that need to move jtf_territory_pub.winningterrmember_tbl_type data into or out of a flat representation.
• Integration middleware and concurrent processing that serializes territory results for downstream use.

Because the procedures are generated translation routines, customizations should not modify them; any regeneration of the wrapper will overwrite changes. Developers needing territory logic should call JTF_TERRITORY_PUB directly and treat the _W wrapper as an internal plumbing layer. Note that the originating search string ("Fallout76 ３０８ウルトラサイト") does not relate to this object; the correct reference topic is the EBS territory wrapper package described above.