Search Results validate_timeframe_id

Overview

APPS.AML_TIMEFRAME_PVT is a private PL/SQL package in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment, belonging to the Application Management Ledger (AML) module family. Its API classification as a Private (PVT) package indicates that it is intended strictly for internal use by the public API layer rather than direct invocation by external consumers. The package encapsulates the low-level business logic that governs sales lead timeframes — the configurable time windows used within AML to qualify, age, and track sales leads through their lifecycle. As the private implementation counterpart to AML_TIMEFRAME_PUB, this package centralizes record-level validation, DML operations, and concurrency-safe persistence of timeframe definitions.

Key Procedures and Functions

The ETRM metadata documents six procedures and functions that constitute the timeframe-management operation set:

• CREATE_TIMEFRAME — Inserts a new sales lead timeframe definition, performing the necessary internal validation before persisting the record.
• UPDATE_TIMEFRAME — Modifies an existing timeframe record, applying the same validation rules used at creation time.
• DELETE_TIMEFRAME — Removes a timeframe definition, subject to any dependency or referential integrity checks enforced internally.
• VALIDATE_TIMEFRAME_ID — Verifies that a supplied timeframe identifier corresponds to an existing, valid record.
• VALIDATE_DECN_TIMEFRAME_CODE — Confirms that a supplied decision timeframe code is valid and recognized by the application.
• VALIDATE_TIMEFRAME_DAYS — Ensures that the day-count value associated with a timeframe is logically valid (e.g., within acceptable bounds and non-negative).

These routines work collectively to guarantee that timeframe data is both consistent and accurately validated before any committed write.

Tables Accessed

Via APPS synonyms, the package operates on a single documented base table:

• AML_SALES_LEAD_TIMEFRAMES — The core storage table for sales lead timeframe definitions. The create, update, and delete procedures perform DML against this table, while the validation routines query it to confirm the existence and validity of IDs, codes, and day values.

Usage Notes

Because AML_TIMEFRAME_PVT is a private package, it should never be called directly by forms, concurrent programs, or custom code; its operations are exposed through the public wrapper package AML_TIMEFRAME_PUB, which is the documented dependent referencing it. In practice, this package is invoked indirectly when users or interfaces maintain sales lead timeframe configuration — for example, through AML setup forms, concurrent programs that load or refresh timeframe data, and any public APIs that require the internal validation and DML logic. Its dependency on FND_API and AS_UTILITY_PUB confirms conformance to the standard EBS API error-handling and utility conventions.