Search Results jtf_number_table

Overview

OZF_FUND_ALLOCATIONS_PVT_W is a private PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the Fund Allocations functionality within the Trade Management / Channel Revenue Management product family (the OZF schema prefix). The package is declared with AUTHID CURRENT_USER, meaning its programs execute with the privileges of the invoking user rather than the definer, which is characteristic of invoker-rights private APIs generated to support Oracle Forms and Java-based middle-tier interaction. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases this package acts as a server-side wrapper that marshals collection-based (table) parameters between the Forms or OAF layer and the underlying Fund Allocation business logic implemented in the OZF_FUND_ALLOCATIONS_PVT package. It is classified in ETRM as an OTHER API and exposes seven documented programs.

Key Procedures and Functions

The package's documented programs fall into two categories: generated Rosetta conversion routines and transactional business routines.

• ROSETTA_TABLE_COPY_IN_P0 — Copies inbound PL/SQL collection data from the caller's JTF typed tables into the ozf_fund_allocations_pvt.fact_table_type record structure used internally. The signature accepts a long sequence of typed parameters (JTF_NUMBER_TABLE, JTF_DATE_TABLE, and JTF_VARCHAR2_TABLE_100), reflecting the wide fact table that underpins fund allocation worksheets.
• ROSETTA_TABLE_COPY_OUT_P0 — Performs the inverse marshalling, moving the internal fact table type back out to the JTF typed collection parameters for return to the client.
• ROSETTA_TABLE_COPY_IN_P2 — A second conversion entry point (variant P2) that maps inbound JTF collections into the appropriate internal structure.
• ROSETTA_TABLE_COPY_OUT_P2 — The corresponding outbound conversion for the P2 variant.
• UPDATE_WORKSHEET_AMOUNT — Updates an allocation amount on a fund allocation worksheet, typically the transactional operation triggered when a user edits a worksheet line.
• APPROVE_LEVELS — Advances a fund allocation request through its approval hierarchy, applying the configured approval levels.
• REJECT_REQUEST — Rejects a fund allocation request, returning it to a prior state in the approval workflow.

Tables Accessed

ETRM documents a single referenced table via the APPS synonym: PLITBLM. This is the standard EBS registration table used by the Forms PL/SQL table-of-records mechanism (the "PL/SQL table" backed by the PLITBLM table and its associated DDL). Its presence confirms that the Rosetta procedures are designed to bridge Forms-managed PL/SQL tables with the package's strongly typed collections. The underlying fund allocation data itself resides in OZF base tables manipulated by the parent OZF_FUND_ALLOCATIONS_PVT package, not directly by this wrapper.

Usage Notes

This package is a private wrapper and is not intended for direct invocation by customers. It is called from the Fund Allocations OAF/Forms user interface when a user edits worksheet amounts, submits a request for approval, or rejects a request. Because the Rosetta procedures reference JTF_NUMBER_TABLE and JTF_VARCHAR2_TABLE_100, they depend on the JTF collection type definitions that ship with the CRM/Trade Management technology stack. The package is referenced by zero other PL/SQL packages, indicating that its call surface is almost entirely UI-driven. Customizations should target the public OZF_FUND_ALLOCATIONS_PVT API rather than this wrapper, and any direct use must honor the invoker-rights semantics of the package.