Search Results check_sr_updated

Overview

APPS.CS_SR_WF_DUP_CHK_PVT is a private PL/SQL package within the Oracle EBS Service (Service Request) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its name indicates its role as a Workflow duplicate-check utility for Service Requests (SR). The package supplies the procedural logic executed by Oracle Workflow function activities belonging to the Service Request workflow item type, governing how the system evaluates whether an incoming or updated Service Request duplicates an existing one, whether its channel or profile characteristics warrant a duplicate check, and how related notification and task records are prepared.

Although classified as PVT (private), these procedures are invoked by the Workflow engine rather than by user-facing forms. They are therefore part of the internal automation that runs behind the Service Request and TeleService flows, and they are not intended for direct invocation by customer extensions. The header comment dates the package to 2003 and marks it noship, indicating it ships with the application rather than being a customer modification.

Key Procedures and Functions

The package exposes seven documented procedures. Each follows the standard Oracle Workflow PL/SQL activity signature, receiving the workflow item type, item key, activity ID, function mode, and returning a result string through an OUT NOCOPY parameter. The procedures are:

• Check_SR_Channel — the procedure corresponding to the user's search term. It evaluates the channel through which the Service Request was created to determine whether that channel participates in duplicate checking.
• Check_SR_Updated — determines whether the Service Request record has been updated in a manner that requires the duplicate-check logic to run again.
• Check_Duplicate_Profile — inspects the duplicate-check profile configuration to decide whether duplication checking is enabled for the Service Request type in question.
• Check_And_Perf_Dup_Check — performs the consolidated duplicate evaluation, combining the preceding checks and executing the duplicate comparison itself.
• Auto_Task_Create — handles the automatic creation of a task record associated with the Service Request as part of the duplicate-handling workflow.
• Setup_Notify_Name — prepares the notification recipient or notification name used by the workflow when a duplicate condition is detected.
• Check_SR_Owner_To_Notify — determines the appropriate Service Request owner or owners to whom duplicate-related notifications should be directed.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• CS_INCIDENTS_ALL_B — the base Service Request (incident) table, used to retrieve and validate the SR under evaluation.
• CUG_SR_TYPE_DUP_CHK_INFO — holds the duplicate-check configuration per Service Request type, consulted to decide whether and how checking applies.
• JTF_NOTES_B — the notes table, used where duplicate findings or workflow commentary are recorded.
• JTF_RS_RESOURCE_EXTNS — the resource extension table, used to resolve owners and notification recipients.
• JTF_TASKS_B — the tasks base table, written by the auto-task creation logic.

Usage Notes

This package is invoked exclusively from Oracle Workflow function activities embedded in the Service Request workflow. It is not referenced by any other documented package, and it is not exposed through a concurrent program or standard form. Administrators and developers encounter it when troubleshooting why a duplicate check did or did not fire, why a task was or was not created, or why a duplicate notification was routed to a particular owner. Because the package is private and its procedures require a valid workflow context, any custom invocation should be approached with caution; the supported configuration points for duplicate checking are the Service Request type setup records, not the package itself.