Search Results jtf_varchar2_table_200

Overview

APPS.CSI_PRICING_ATTRIBS_PUB_W is a public wrapper package in the Oracle E-Business Suite CSI (CustomeR Service Intelligence / Install Base) module. It exposes the pricing-attribute maintenance interface used by Install Base to store and retrieve attribute values that participate in pricing, quoting, and service-contract calculations. The package acts as the supported programmatic entry point over the underlying CSI pricing-attribute entity, so callers do not manipulate the base tables directly. The header comment ("$Header: csippaws.pls 120.11 2008/01/15") indicates the file has been stable across the 11i-to-R12 lineage and is carried forward essentially unchanged into 12.1.1 and 12.2.2. Its API classification is OTHER, meaning it is not one of the core Open Interfaces but is still a published, callable wrapper.

Key Procedures and Functions

The package documents four procedures, forming a complete create/read/update/expire lifecycle for pricing attributes:

• GET_PRICING_ATTRIBS — Retrieves pricing attribute values for the requested context. Its signature is characterized by a large number of OUT NOCOPY parameters typed as JTF_NUMBER_TABLE, JTF_DATE_TABLE, and JTF_VARCHAR2_TABLE collections. This bulk, positional parameter style (p6_a0 through p6_a37 and beyond) is what the user's search term "jtf_varchar2_table_200" resolves to: most attribute slots are declared as JTF_VARCHAR2_TABLE_200, with a few wider slots (JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300) and numeric/date slots for typed attributes. Standard API control parameters (p_api_version, p_commit, p_init_msg_list, p_validation_level, p_time_stamp) govern versioning, transaction control, message-stack initialization, validation depth, and time-stamped retrieval.
• CREATE_PRICING_ATTRIBS — Inserts a new set of pricing attribute records for the given entity.
• UPDATE_PRICING_ATTRIBS — Modifies existing pricing attribute records in place.
• EXPIRE_PRICING_ATTRIBS — Ends the effective period of pricing attribute records rather than physically deleting them, preserving history required by Install Base and service pricing.

Parameter lists for the create, update, and expire procedures are not reproduced in the supplied metadata and should be taken from the package specification in the database.

Tables Accessed

The ETRM excerpt does not enumerate the base tables referenced through APPS synonyms, and the package references no documented external tables via synonym in the metadata provided. Functionally, the package reads and writes the CSI pricing-attribute entity tables that back the Install Base pricing-attribute model, using the JTF collection types to marshal multi-row attribute values between PL/SQL and the calling layer. Because it is a public wrapper, all inserts, updates, and expirations are applied to the CSI attribute storage on behalf of the caller.

Usage Notes

CSI_PRICING_ATTRIBS_PUB_W is invoked programmatically rather than through a dedicated concurrent program. Typical callers include Install Base and service-pricing forms logic, other CSI PL/SQL APIs, and custom extensions that need to populate or read pricing attributes for an instance. The metadata records zero packages referencing it, so it is a leaf in the dependency graph and is called directly by forms or external code. Callers must initialize the message stack (p_init_msg_list) and issue an explicit COMMIT or ROLLBACK based on p_commit, consistent with standard EBS API conventions. When adapting code between 12.1.1 and 12.2.2, the wrapper specification is compatible; the primary care point is matching the correct positional attribute slot to its JTF collection type, since JTF_VARCHAR2_TABLE_200 is the dominant width for attribute slots a5 through a37.