Search Results check_update_attributes

Overview

APPS.OTA_TFL_API_BUSINESS_RULES is a PL/SQL package in the Oracle E-Business Suite OTA (Oracle Training Administration / iLearning) module. In EBS 12.1.1 and 12.2.2, the package is classified as an OTHER API under the APPS schema and is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer. Its stated purpose is to enforce the business rules that govern finance lines and finance headers within training and event financial tracking. Responsibility for validating transfer status, cancellation indicators, sequence numbering, currency, and type/amount constraints is centralized in this package, so that both Oracle-delivered forms and custom extensions can rely on a single, consistent rule set.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, each responsible for an individual validation or lookup rule:

• CHECK_UPDATE_ATTRIBUTES — Enforces the rule that once a finance line has been transferred, no attributes may be updated.
• CHECK_CANCELLED_FLAG — Verifies that the CANCELLED_FLAG attribute falls within the valid domain of 'Yes' / 'No'. This is the procedure most relevant to the search term check_cancelled_flag.
• CHECK_SEQUENCE_NUMBER — Ensures the sequence number of a finance line is unique within its finance_header_id.
• GET_NEXT_SEQUENCE_NUMBER — Derives the next available sequence number for a finance line within a finance_header_id.
• GET_DATE_RAISED — Returns the date a finance record was raised.
• CHECK_DELETE_ATTEMPT — Validates whether a finance line may legitimately be deleted.
• GET_CURRENCY_CODE — Retrieves the applicable currency code for the finance context.
• CHECK_CURRENCY_CODE — Validates the supplied currency code against the permitted set.
• CHECK_TYPE_CONSTRAINTS — Applies constraints associated with the finance line type.
• CHECK_TYPE_AND_AMOUNTS — Cross-validates the finance line type against its amounts.
• CHECK_UNIQUE_FINANCE_LINE — Confirms the finance line is unique.
• GET_FINANCE_HEADER — Returns the finance header associated with a given finance line.
• CHECK_FINANCE_HEADER — Validates the integrity and existence of the finance header.

Tables Accessed

The package operates against the following OTA base tables through APPS synonyms: OTA_FINANCE_HEADERS and OTA_FINANCE_LINES form the core financial structures validated by most procedures. OTA_BOOKING_DEALS, OTA_DELEGATE_BOOKINGS, OTA_EVENTS, OTA_RESOURCE_ALLOCATIONS, OTA_RESOURCE_BOOKINGS, OTA_SUPPLIABLE_RESOURCES, and OTA_PRICE_LISTS supply the booking, event, resource, and pricing context required for currency, amount, and uniqueness checks.

Usage Notes

OTA_TFL_API_BUSINESS_RULES is invoked from the OTA finance maintenance forms and from any custom code that inserts or updates finance lines, ensuring that CANCELLED_FLAG, sequence numbers, currency codes, and amount/type combinations are valid before data is committed. Because the package is AUTHID CURRENT_USER and referenced by one other package, it should be called rather than duplicated, and customizations should preserve its validation contract for 12.1.1 and 12.2.2.