Search Results g_modify

Overview

CAC_SYNC_TASK_COMMON is a shared utility package in the Oracle E-Business Suite Applications (APPS) schema that supports the synchronization of tasks, appointments, and collaboration records between the EBS database and external clients such as calendar and groupware systems. Declared with AUTHID CURRENT_USER, the package executes with the privileges of its invoker, which allows it to be called safely from multiple application contexts while still honoring the security model of the calling session.

The package centralizes constants and helper routines used by the broader CAC synchronization infrastructure. It defines standardized literals for task types, update modes, and object categories — for example G_TASK_TYPE_GENERAL, G_NEW, G_MODIFY, G_DELETE, G_APPOINTMENT, and G_TASK — and it resolves timezone identifiers through FND profile options such as SERVER_TIMEZONE_ID and CLIENT_TIMEZONE_ID. These shared definitions ensure that all consumers of the synchronization framework apply consistent status codes, prefixes, and date handling rules. The package also holds package-level records such as collab_details_rec and delete_tasks used to pass structured data among internal routines.

Key Procedures and Functions

The documented interface exposes fifty-six procedures and functions. The most relevant groups are summarized below; parameter lists are not reproduced here.

• Resource and group resolution: GET_RESOURCE_DETAILS, GET_GROUP_RESOURCE, GET_GROUP_CALENDAR, and GET_RESOURCE_DETAILS retrieve resource, group, and calendar attributes needed to align client-side participants with EBS resources.
• Ownership, assignment, and access: GET_OWNER_INFO returns ownership information for a task or appointment; GET_ASSIGNMENT_INFO, GET_ASSIGNMENT_ID, and GET_ASSIGNMENT_STATUS_ID resolve assignment records and their statuses; GET_ACCESS determines whether a resource may view or modify a given record.
• Timezone and date conversion: CONVERT_GMT_TO_CLIENT, CONVERT_GMT_TO_TASK, CONVERT_TASK_TO_GMT, CONVERT_SERVER_TO_GMT, CONVERT_GMT_TO_SERVER, CONVERT_DATES, ADJUST_TIMEZONE, and GET_MAX_ENDDATE normalize dates across the server, client, and GMT timezones.
• Processing helpers: GET_CLIENT_PRIORITY, GET_ALARM_MINS, MAKE_PREFIX, and CHECK_DELETE_DATA support priority mapping, alarm offsets, XML/Oracle text prefixes, and deletion validation.

The frequent reference to GET_OWNER_INFO in administration and troubleshooting queries reflects its role in determining which resource owns a synchronized record, a prerequisite step in most downstream synchronization decisions.

Tables Accessed

The package reads and writes through APPS synonyms. Collaboration data is maintained in CAC_SYNC_PRINCIPALS and the CAC_VIEW_COLLAB_DETAILS base, translation, and security views. Task mapping and exclusion rules reside in JTA_SYNC_TASK_MAPPING and its _S synonym and JTA_TASK_EXCLUSIONS. Resource and group structures are drawn from JTF_RS_RESOURCE_EXTNS, JTF_RS_GROUPS_B, JTF_RS_GROUPS_TL, JTF_RS_GROUP_MEMBERS, and JTF_RS_GROUP_USAGES. Menu and grant security data come from FND_GRANTS, FND_MENUS, and FND_OBJECTS. Together these objects supply the ownership, membership, security, and mapping context required for consistent synchronization behavior.

Usage Notes

This package is not typically invoked directly by end users. It is called by the EBS Calendar and collaboration synchronization flows — including concurrent programs that import and export task and appointment data — and by the three dependent packages documented in the ETRM metadata. Because the routines encapsulate timezone conversion, ownership lookup, access checks, and mapping logic, customization efforts should call the documented procedures rather than replicating their logic. In 12.1.1 and 12.2.2 the package resides in the APPS schema and remains available to any session with execute privileges, making it suitable for use in forms-based personalizations and custom concurrent programs that participate in the synchronization framework.