Search Results get_progress_status

Overview

CSF_MAP_PVT is a private PL/SQL package in the APPS schema of Oracle E-Business Suite, shipping under the CSF (Field Service) product family. The package encapsulates the internal business logic used by Oracle's resource-mapping and task-assignment functionality to estimate scheduling effort against resource capacity. As an API classification of "PVT" indicates, CSF_MAP_PVT is not a public, supported integration interface; it is an internal implementation package whose functions are called by other CSF components rather than by customer-written code.

The package header carries the revision marker "$Header: CSFVMAPS.pls 120.0 2005/09/15 21:33:48 sseshaiy noship $", indicating the file was originally authored in 2005 and that its source is delivered "noship" (not shipped as a standalone script). The package body observes the standard EBS layering convention: it exposes a small, stable header of two functions while hiding the remainder of its scheduling calculations, and it references transactional tables exclusively through APPS synonyms.

Key Procedures and Functions

The documented package specification exposes two functions:

• PREDICT_TIME_DIFFERENCE — Accepts a task assignment identifier and returns a numeric result. Its purpose is to compute the predicted variance between the scheduled or expected duration of a task assignment and the effort actually implied by the assignment's parameters. This value supports field service dispatch decisions by quantifying how far an assignment is likely to deviate from plan.
• GET_PROGRESS_STATUS — Accepts a resource identifier, a resource type code, and a date, and returns a numeric status indicator. It derives the progress state of a resource as of the supplied date, allowing callers to determine whether a resource is available, committed, or otherwise occupied within a scheduling window.

No other functions or procedures are documented for this package. Parameter lists beyond those shown in the header excerpt are not enumerated in the ETRM metadata and should not be assumed.

Tables Accessed

The package reads from three documented tables via APPS synonyms:

• CAC_SR_OBJECT_CAPACITY — Stores capacity definitions for service objects and provides the throughput or capacity constraints against which resource progress is evaluated.
• JTF_TASKS_B — The base tasks table in the JTF (CRM Foundation) schema, holding task headers used to resolve task-level attributes needed for time-difference prediction.
• JTF_TASK_ASSIGNMENTS — Holds the association between tasks and the resources assigned to them, supplying the assignment records keyed by task assignment identifier.

All access is read-oriented; the metadata does not document insert, update, or delete operations.

Usage Notes

CSF_MAP_PVT is invoked from the Oracle Field Service scheduling and dispatch flows wherever assignment effort must be estimated or resource availability must be resolved. Because the package is classified PVT and referenced by zero other documented packages, it is not exposed through supported public APIs, concurrent program parameters, or discoverable form hooks. Customers searching for "predict_time_difference" are most likely investigating an error stack or a debugging trace originating from internal CSF code. Customizations should not call these functions directly, as signatures are not guaranteed across releases (12.1.1 versus 12.2.2) and the "noship" designation signals the package is subject to change without notice. Where equivalent public functionality is required, the corresponding CSF or JTF public APIs should be used instead.