Search Results as_sales_org_manager_pvt




Overview
Explore in AI Chat

Overview

The APPS.AS_SALES_ORG_MANAGER_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Sales Foundation module. It provides the internal implementation logic that supports the management and resolution of sales organization structures, sales groups, sales members, and the role-based relationships that bind resources to a sales hierarchy. The package abstracts the complexity of querying and assembling sales force organizational data derived from the Resource Manager (JTF_RS) schema, presenting it in a form that other Sales Foundation public APIs and calling programs can consume. As a private package, it is not intended to be called directly by external applications; instead it is invoked by sibling public packages such as AS_SALES_GROUP_PUB and AS_SALES_MEMBER_PUB, which wrap its functionality with the standard FND_API error-handling and message conventions.

Key Procedures and Functions

The documented package exposes five procedures and functions, each specializing in a facet of sales organization retrieval:

  • GET_SALES_GROUPS — Returns the set of sales groups associated with a given sales organization or resource context, enabling callers to enumerate the group structure that defines a sales territory hierarchy.
  • GET_CURRENTUSER — Resolves the currently logged-in application user (typically via FND_GLOBAL or FND_USER) so that downstream logic can filter sales data by the current user's organizational membership or role.
  • GET_SALES_MEMBERS — Retrieves the individual members belonging to a specified sales group, resolving resource identifiers through the Resource Manager tables to produce a member list for the group.
  • GET_SALES_RELATIONS — Extracts the role relationships that exist between sales resources, exposing the reporting or hierarchical links defined in the JTF_RS role-relation tables.
  • GET_MEMBER_ROLE — Determines the specific sales role held by a member within a group, allowing callers to distinguish between different role types assigned to the same resource.

Together these routines form the retrieval layer that public Sales Foundation APIs depend upon. Parameter signatures are not reproduced here, as the metadata documents only procedure names and purposes.

Tables Accessed

The package reads from the following objects through APPS synonyms:

  • FND_USER — Source of application user identity for GET_CURRENTUSER.
  • JTF_RS_GROUPS_DENORM — Denormalized group grouping used to resolve sales group membership efficiently.
  • JTF_RS_GROUP_MEMBERS — Junction table linking resources to their parent groups.
  • JTF_RS_RESOURCE_EXTNS — Extended resource attributes identifying the individuals who act as sales members.
  • JTF_RS_ROLES_B — Base role definitions used to interpret the role assigned to a member.
  • JTF_RS_ROLE_RELATIONS — Hierarchical role relationships powering GET_SALES_RELATIONS.
  • DBMS_SQL and DUAL — Utility objects for dynamic SQL construction and singleton queries.

Views AS_SALESFORCE_V and AS_FC_SALESFORCE_V are also referenced, supplying consolidated sales-force data.

Usage Notes

Because AS_SALES_ORG_MANAGER_PVT is classified as a private package, it is generally invoked indirectly. It is referenced by approximately twenty other database objects, principally the public Sales Foundation APIs (AS_SALES_GROUP_PUB, AS_SALES_MEMBER_PUB) and internally by AS_SALES_ORG_MANAGER_PVT itself. Standard EBS Forms or concurrent programs that manage sales territories, sales teams, or resource assignments in the Sales Foundation module will ultimately exercise these routines through the public wrappers. Custom code should not call the private routines directly, as signatures may change between point releases and the package does not guarantee forward-compatible interfaces. It operates on both Oracle EBS 12.1.1 and 12.2.2 and relies on FND_API, FND_MESSAGE, and FND_MSG_PUB for consistent error and message handling when surfaced through its public callers.