Results for “jtf_task_statuses_b_u1”

32 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.CAC_VIEW_AVAIL_PVT package is a private PL/SQL API belonging to the Oracle E-Business Suite Customer Relationship Management (CRM) family of modules, specifically the Interaction Center / Task Management (JTF) schema components. The _PVT suffix indicates that this package encapsulates private, internal business logic that is not intended to be called directly by external integrators; instead, it is wrapped and exposed through a corresponding public wrapper package, CAC_VIEW_AVAIL_PVT_W. The package's name — "CAC View Availability" — signals its purpose: to compute and present the availability of resources (typically service agents, technicians, or calendar-based entities) for a given task or activity window. It supports the scheduling and assignment features of Oracle Task Manager and related self-service or agent-facing booking interfaces. In EBS 12.1.1 and 12.2.2, the package resides in the APPS schema and holds a VALID status, confirming it is compiled and operational in the delivered environment.

Key Procedures and Functions

The documented ETRM metadata lists three procedures/functions exposed by this package:

  • AVAILABILITY — The primary entry point for determining whether a resource or set of resources is available within a specified time window. It evaluates calendar and assignment data to return an availability result.
  • CHECK_AVAILABILITY — A complementary routine that validates availability against business rules, task statuses, and existing assignments, returning a Boolean or status indicator used by the calling wrapper.
  • (Third documented object) — The metadata confirms three total procedures/functions, though the excerpt names only two explicitly. The third is implied to be an internal helper consistent with the availability calculation flow.

Because these routines are private (_PVT), their parameter lists are not published and must not be assumed. Consumers should invoke the public wrapper CAC_VIEW_AVAIL_PVT_W instead.

Tables Accessed

The package reads from several JTF (Java Task Framework) tables via APPS synonyms:

  • JTF_TASKS_B — The base table storing task definitions; used to resolve the task context for which availability is being queried.
  • JTF_TASK_ALL_ASSIGNMENTS — Holds task-to-resource assignment records; queried to detect existing commitments that might conflict with a proposed window.
  • JTF_TASK_STATUSES_B — Base status definitions; used to filter tasks by active or assigned status when evaluating availability.
  • PLITBLM — A PL/SQL index-by table type used internally for bulk collection and processing, not a physical table.

Usage Notes

CAC_VIEW_AVAIL_PVT is typically invoked indirectly. In Oracle EBS, agent-facing scheduling forms, the Interaction Center calendar views, and self-service booking pages call the public wrapper CAC_VIEW_AVAIL_PVT_W, which in turn delegates to this private package. Concurrent programs that generate availability reports or perform bulk resource scheduling may also route through the wrapper. Custom code should never call CAC_VIEW_AVAIL_PVT directly, as its interface is not guaranteed across patches or point releases. Developers integrating availability logic must use the documented wrapper API and rely on FND_API for standardized error handling and message propagation, as referenced in the dependency metadata.