Search Results get_default_sales_group

Overview

The APPS.JTF_RS_INTEGRATION_PUB package is a public PL/SQL API belonging to the Oracle CRM Foundation (JTF) product family, specifically the Resource Manager (RS) module. Its declared purpose, as stated in the source header, is to expose common procedures and functions that other Oracle applications and external products can call to retrieve resource-related data without directly querying the underlying Resource Manager tables. The package is classified as PUB in the ETRM metadata for 12.2.2, confirming it is a supported public interface rather than an internal implementation detail, and it is registered against the business entity JTF_RS_RESOURCE. In the 12.1.1 / 12.2.2 code line, the header revision ($Header: jtfrspxs.pls 120.0) reflects the consolidated 11i-era source that remains in service across both releases. The primary business function it serves is the identification of suitable salespeople or service resources — either by their default organizational grouping or by matching their recorded skill sets against a requested combination of product, component, platform, and problem code attributes.

Key Procedures and Functions

ETRM documents two callable program units within the package specification:

• GET_DEFAULT_SALES_GROUP — a function that returns the primary resource group identifier for a given salesperson. According to the source documentation it takes a salesperson identifier, an organization identifier, and an effective date (defaulting to SYSDATE when not supplied), and returns a group identifier as a NUMBER. It is typically used when a transaction or assignment needs to resolve which resource group owns a salesperson on a particular date, allowing historical accuracy through the date parameter.
• GET_RESOURCES_BY_SKILL — a procedure that returns the set of resources whose recorded skills match a supplied skill combination. The documented parameters span the full skill classification model: category, subcategory, product, product organization, component, subcomponent, platform, platform organization, problem code, and skill level. The procedure uses the public collection type Resource_table_type (a PL/SQL associative array of Resource_Rec_type records keyed by BINARY_INTEGER, each record carrying a RESOURCE_ID) to return the matching resource identifiers to the caller. This design lets a calling application retrieve a variable-length list of candidates in a single call.

Tables Accessed

The package operates against the following APPS synonyms, which represent the core Resource Manager schema:

• JTF_RS_RESOURCE_EXTNS — the primary resource extension table, supplying RESOURCE_ID and the anchor for resource identity lookups.
• JTF_RS_RESOURCE_SKILLS — stores the skill assignments (category, product, component, platform, problem code, and level) used by GET_RESOURCES_BY_SKILL to qualify candidate resources.
• JTF_RS_SRP_GROUPS — the salesperson group table from which the default primary group value is derived by GET_DEFAULT_SALES_GROUP.
• PLITBLM — the standard EBS PL/SQL table-to-view utility, referenced internally to materialize PL/SQL collections (such as the returned resource list) into a queryable form.

The package is read-oriented; no documented interface writes to these tables.

Usage Notes

Because the package is classified as public, it is the sanctioned integration point for external and cross-product code that needs resource or salesperson-group information. It is commonly invoked from Oracle Forms (for example within CRM resource selection and assignment flows), from concurrent programs that batch-assign resources by skill, and from custom PL/SQL extensions written against the 12.1.1 or 12.2.2 data model. ETRM records eight other packages referencing this API, indicating its role as a shared dependency across Resource Manager and adjacent modules. Callers should be aware of the following conventions:

• Use the p_date parameter on GET_DEFAULT_SALES_GROUP rather than assuming the current group, since group membership is date-effective.
• When invoking GET_RESOURCES_BY_SKILL, note that the returned collection is a PL/SQL associative array indexed by BINARY_INTEGER and must be consumed programmatically; it is not a SQL query result set.
• Because the package is a PUB API, its signature is intended to remain stable within the release, making it preferable to direct DML against the JTF_RS tables for supported custom development.