Search Results sync_ear_sch_limit_cache




Overview
Explore in AI Chat

Overview

The APPS.ONT_EAR_SCH_LIMIT_DEF_UTIL package body is a utility module in the Oracle E-Business Suite Order Management (ONT) schema. Its name reflects its purpose: it manages the "Earliest Schedule Limit" (EAR_SCH_LIMIT) definition used by Oracle's scheduling and availability logic. The package provides a lightweight caching and retrieval mechanism for the earliest schedule limit value, which governs how far into the past or future a line can be scheduled during order entry and scheduling activities. The header comment records a creation date of 30-MAR-09, placing it within the R12 development lineage and making it applicable to both 12.1.1 and 12.2.2 environments.

Functionally, the package wraps a single-row view, OE_AK_EAR_SCH_LIMIT_V, and exposes typed accessors plus cache-maintenance routines. It is classified in the ETRM metadata as a UTIL API, indicating it is an internal helper rather than a public business API, and it is referenced by one other package.

Key Procedures and Functions

  • GET_ATTR_VAL_VARCHAR2 — Accepts an attribute code and a record from the OE_AK_EAR_SCH_LIMIT_V view, returning the earliest schedule limit as a VARCHAR2. It checks the code against EARLIEST_SCHEDULE_LIMIT and uses the FND_API.G_MISS_NUM sentinel to distinguish a populated value from a missing one, returning NULL otherwise.
  • GET_ATTR_VAL_DATE — Parallel to the above but returns the earliest schedule limit as a DATE, converting the stored value using the RRRR/MM/DD HH24:MI:SS format mask. It applies the same missing-value handling.
  • SYNC_EAR_SCH_LIMIT_CACHE — Refreshes the package's in-memory cache from the view. It opens a cursor selecting from OE_AK_EAR_SCH_LIMIT_V where EARLIEST_SCHEDULE_LIMIT matches the input parameter, and uses the G_MISS_NUM sentinel to detect whether the caller supplied a meaningful value. This is the routine most directly associated with the user search term "sync_ear_sch_limit_cache."

The body also declares an internal Clear_EAR_SCH_LIMIT_Cache procedure that nulls the cached record, and a global variable g_cached_record anchored to the view's row type. A constant G_PKG_NAME supplies the package name for error and logging messages.

Tables Accessed

The package reads exclusively from the view OE_AK_EAR_SCH_LIMIT_V, referenced through the APPS synonym layer per ETRM metadata. This view exposes the earliest schedule limit definition used by availability and scheduling engines. No direct DML against base tables is documented; the package's role is read-only retrieval and caching, so no INSERT, UPDATE, or DELETE statements are present in the excerpt.

Usage Notes

Because this is a UTIL-classified package, it is not intended for direct customer invocation. It is typically called from scheduling-related forms, order entry logic, or other ONT packages that need to validate or display the earliest permissible schedule date. The caching design means callers should invoke SYNC_EAR_SCH_LIMIT_CACHE when the underlying definition changes, and Clear_EAR_SCH_LIMIT_Cache when the cache must be invalidated. The single documented dependent package reinforces its role as a shared internal service. Custom code should avoid modifying this package and instead consume the accessor functions through supported ONT APIs.