Search Results derive_standard_price

Overview

APPS.OTA_TEA_BUS is an internal PL/SQL business-rule package within the Oracle E-Business Suite Training and Events (OTA/ETRM) module. Its name reflects its role as the "business" layer of the OTA_TEA (Training Event Administration) entity group, and its declared header (AUTHID CURRENT_USER, RDBMS 8.1.7-era comments dated November 2002) confirms that it is a generated or template-driven Table Event API (TEA) package. Practically, OTA_TEA_BUS encapsulates the validation and derivation logic that supports the event, price-list, booking, and delegate-processing transactions executed through the OTA entity APIs. It is classified as OTHER in the ETRM 12.1.1/12.2.2 API inventory, meaning Oracle does not expose it as a public or supported integration API; it is called from within the module during the normal DML lifecycle of the surrounding TEA packages. The documentation marks the source as "Internal Development Use Only," indicating that the procedures are private helpers rather than external entry points.

Key Procedures and Functions

Eight callable units are documented in the ETRM metadata. The first three are the standard TEA validation hooks:

• INSERT_VALIDATE — Controls execution of all insert business rules; invoked from the entity's ins procedure before a row is committed. It receives the entity PL/SQL record structure and an association type.
• UPDATE_VALIDATE — Performs the equivalent validation sweep for updates, called from the upd procedure.
• DELETE_VALIDATE — Validates that a delete is permissible under current business rules prior to removal.
• CLIENT_CHECK_EVENT_CUSTOMER — Verifies the customer/organization context associated with an event, supporting the event-to-customer relationship enforced through HZ tables.
• DERIVE_STANDARD_PRICE — The unit most commonly searched by users; it determines the standard price applicable to an event or registration by resolving the effective price list and its entries.
• NEW_PRICE_LIST_HIT — Detects when a transaction qualifies for a different (new) price-list tier or entry, typically invoked during pricing recalculation.
• CHECK_PRE_PURCHASE_AGREEMENT — Evaluates whether a pre-purchase or vendor supply agreement governs the transaction.
• NUMBER_OF_DELEGATES — Calculates or validates the count of delegates attached to a booking, supporting capacity and pricing rules.

These units operate on a shared record structure and raise unhandled business-rule errors unless explicitly trapped by the caller, consistent with the TEA generator convention.

Tables Accessed

Through APPS synonyms the package reads and writes the core ETRM and reference tables:

• OTA_EVENTS, OTA_EVENT_ASSOCIATIONS — Event header and its associations with customers, vendors and offerings.
• OTA_PRICE_LISTS, OTA_PRICE_LIST_ENTRIES — Price derivation for DERIVE_STANDARD_PRICE and NEW_PRICE_LIST_HIT.
• OTA_BOOKING_DEALS, OTA_BOOKING_STATUS_TYPES, OTA_DELEGATE_BOOKINGS — Booking and delegate processing, including status validation.
• OTA_FINANCE_LINES, OTA_VENDOR_SUPPLIES — Financial lines and pre-purchase/vendor supply checks.
• HZ_CUST_ACCOUNTS, HZ_PARTIES, HR_ALL_ORGANIZATION_UNITS — Customer, party and organization context used by CLIENT_CHECK_EVENT_CUSTOMER and delegate rules.
• PER_ALL_POSITIONS, PER_JOBS — Position and job reference data used for delegate/attendee validation.

Usage Notes

OTA_TEA_BUS is not intended for direct invocation from custom code, forms or concurrent programs. It is called by the OTA entity packages (referenced by four other packages per the ETRM metadata) and indirectly by the standard Training and Events forms and concurrent pricing/registration processes. Customizations requiring changes to pricing or delegate rules should be made in the calling entity package or via supported extension points rather than by modifying OTA_TEA_BUS, which may be regenerated on patch application.