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.
-
JTF_TASK_STATUSES stores all the task statuses.
-
JTF_TASK_STATUSES stores all the task statuses.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel