Search Results check_again




Overview
Explore in AI Chat

Overview

CSF_ALERTS_PUB is a public PL/SQL package in the APPS schema that implements the alert and notification engine for Oracle E-Business Suite's Field Service and TeleService task-management functionality. It is the runtime component responsible for generating, evaluating, and delivering notifications tied to task assignments, service requests, and customer-product records. The package drives the notification behavior associated with "Notification Site Readiness," providing the conditional logic and message content that determine when an alert is raised, to whom it is routed, and what information it carries. Its identifier reflects its role as the publicly callable ("_PUB") API for the CSF (Customer Service Foundation) alerting subsystem.

Key Procedures and Functions

The package exposes 22 documented procedures and functions, each serving a distinct role in the notification lifecycle:

  • CHECKEVENT — Evaluates the event type driving a workflow notification.
  • CHECK_AGAIN — Tests a task precondition before a reminder notification is generated.
  • CHECK_AUTO_REJECT — Determines whether the CSF: Alert Auto Reject profile option is enabled.
  • ACCEPT_ASSGN / CANCEL_ASSGN — Handle acceptance and cancellation of task assignments, coordinating the resulting notifications.
  • SENDNOTIFICATION — Dispatches the prepared notification to its recipients.
  • GETSENDDATE / GETCLIENTTIME / GETUSERID / GETUSERNAME — Supply contextual values used to construct and schedule notifications.
  • CATEGORY_TYPE / GETITEMKEY / CHECKALERTSENABLED — Provide classification and enablement checks that gate alert generation.
  • GETASSIGNEDMESSAGE, GETREMINDERMESSAGE, GETDELETEMESSAGE, GETRESCHEDULEMESSAGE — Return the message bodies for each notification scenario (assignment, reminder, deletion, reschedule).
  • GETCONTACTDETAIL / GETTASKDETAILS — Populate the contact and task detail records declared by the package's own record types (task_asgn_record, contact_record).
  • CHECKFORALERTS — Performs the overall alert evaluation.

Tables Accessed

The package reads and writes a broad set of task, service-request, and customer tables through APPS synonyms. Core task data is drawn from JTF_TASKS_B, JTF_TASK_ASSIGNMENTS, JTF_TASK_STATUSES_B, JTF_TASK_TYPES_B, and JTF_TASK_AUDITS_B, supplying task numbers, statuses, priorities, and audit history. Service request context comes from CS_INCIDENTS_ALL_B, CS_INCIDENTS_ALL_TL, and CS_INCIDENTS_ALL. Customer and contact information is sourced from HZ_PARTIES, HZ_CONTACT_POINTS, HZ_PARTY_SITES, and HZ_RELATIONSHIPS, while CS_CUSTOMER_PRODUCTS_ALL provides installed-base and serial-number details. Resource information is retrieved from JTF_RS_RESOURCE_EXTNS, and workflow events are referenced through WF_EVENT_T.

Usage Notes

CSF_ALERTS_PUB is typically invoked by the Oracle Workflow engine as the PL/SQL function activity behind alert workflows, where the check* procedures evaluate conditions and the send* procedures deliver notifications. It is also called from Field Service and TeleService forms and supporting logic when task assignments are created, accepted, cancelled, or rescheduled. The package is referenced by one other documented package, confirming its role as a shared service within the CSF layer. Customizations should call the public procedures rather than querying the underlying tables directly, and developers extending notification behavior should respect the message-generation and enablement checks the package already enforces.