Search Results insert_group

Overview

JTF_RS_GROUPS_AUD_PVT is a private PL/SQL package in the Oracle E-Business Suite Resource Manager (JTF_RS) module. It encapsulates the audit-enabled data manipulation logic for resource groups, which are the organizational containers used by the CRM and resource scheduling components to categorize sales teams, service groups, and other logical collections of resources. The package is declared AUTHID CURRENT_USER and is explicitly documented as private, meaning it is not intended as a public integration API. Its single stated purpose in the header is to insert records into JTF_RS_GROUPS_AUD_VL. In practice, the package provides the low-level insert, update, and delete primitives that the corresponding public resource-group API layer invokes, so that every write to the base group table is mirrored into the audit and translation-enabled structures. This design guarantees that group history, multi-language group names and descriptions, and object version tracking remain consistent for downstream consumers such as synchronous and asynchronous CRM processes.

Key Procedures and Functions

• INSERT_GROUP — Creates a new resource group record. It receives the API version, standard FND_API control flags for message-list initialization and commit behavior, and the group attributes (group identifier, group number, e-mail address, active start and end dates, accounting code, exclusive flag, group name, group description, object version number, and time zone). It returns the standard X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA out parameters. This is the procedure returned when users search for insert_group.
• UPDATE_GROUP — Modifies an existing group. It shares the same parameter profile as INSERT_GROUP, with the date parameter defaulting to FND_API.G_MISS_DATE so that callers can selectively leave attributes untouched, and follows the same FND_API return convention.
• DELETE_GROUP — Removes a group by group identifier, taking the API version and FND_API control flags and returning the standard status, message count, and message data outputs.

No functions are declared; the package exposes exactly three documented procedures.

Tables Accessed

• JTF_RS_GROUPS_AUDIT_S — The audit shadow table that captures change history for group records written by these procedures.
• JTF_RS_GROUPS_AUD_B — The base (untranslated) audit table that stores the audit-enabled master rows.
• JTF_RS_GROUPS_B — The base table holding the current group definition, which the insert, update, and delete logic targets.
• DUAL — Used for singleton evaluations and sequence or default-value lookups.
• Writes are surfaced through the view JTF_RS_GROUPS_AUD_VL, the documented target of the package's insert logic, which exposes the audit base table with translation overlays.

Usage Notes

Because the package is classified PVT, it should not be called directly from customer extensions. It is invoked internally by the public resource-group API and by the Resource Manager forms and concurrent programs that maintain groups. The documented table list shows it is referenced by one other package, confirming its role as a subordinate layer rather than an entry point. Callers that do reach this package must supply a valid P_API_VERSION, should pass P_INIT_MSG_LIST and P_COMMIT consistent with their transaction boundaries, and must inspect X_RETURN_STATUS and X_MSG_DATA rather than relying on exceptions. In 12.1.1 and 12.2.2 the same specification applies, with the header revision indicating maintenance through release 12.1. Any custom code requiring group creation should use the corresponding public JTF_RS group API, which delegates to INSERT_GROUP.