Search Results as_sales_group_pub

Overview

AS_SALES_GROUP_PUB is an Oracle E-Business Suite public API package owned by the APPS schema. It belongs to the Oracle Sales (AS) product family and exposes a documented, supported interface for defining and maintaining sales group entities. Sales groups are organizational constructs that associate a named group of sales personnel with a manager, an assigned salesforce, and a general ledger cost center (accounting code). They are used throughout Oracle Sales and related modules as an assignment and reporting dimension.

The package is declared with AUTHID CURRENT_USER, which means it executes with the privileges of the calling session rather than the definer. This is typical of the PL/SQL public API infrastructure in EBS, where the caller must already hold the necessary grants on the underlying objects. The header carries the revision marker $Header: asxpsgrs.pls 115.4 2002/11/06 00:46:32 appldev ship $, and the file history indicates that it was originally created on 7/31/98. The package is therefore one of the older, stable public interfaces in the Oracle Sales API layer, and remains present in both the 12.1.1 and 12.2.2 releases with the same documented PL/SQL specification.

The stated purpose in the source comments is to provide a public API for sales group related operations, exposing the sales group entity to external callers in a controlled manner rather than allowing direct DML against the underlying base table.

Key Procedures and Functions

The ETRM metadata for AS_SALES_GROUP_PUB documents no procedures or functions, and the package specification as shipped consists of type declarations only. The specification defines the following public structures:

• sales_group_rec_type — a record type carrying the attributes of a single sales group: sales_group_id, Name, Start_Date_Active, Description, Parent_Sales_Group_id, Manager_Person_Id, Manager_Salesforce_Id, End_Date_Active, and Accounting_Code (the cost center code). Note that an Enabled_Flag attribute is present in the parameter documentation but is commented out within the declared record.
• G_MISS_SALES_GROUP_REC — a declared global instance of the record type used as the standard FND_API "missing" template, populated with FND_API.G_MISS_NUM, G_MISS_CHAR, and G_MISS_DATE sentinels.
• sales_group_tbl_type — a PL/SQL table type indexed by BINARY_INTEGER, based on sales_group_rec_type, used for bulk (array) processing of multiple sales groups in a single call.

All business logic for create, update, and validation is therefore not exposed in the documented metadata, and no parameter lists can be stated for it. Because the specification is type-only, it functions primarily as a shared definition contract consumed by the implementation body and by other Oracle Sales APIs.

Tables Accessed

No base tables are documented through APPS synonyms for this package in the ETRM metadata. The package does not declare any SQL statements in its specification, so any table access occurs in the package body and operates on the sales group base tables and the surrounding Oracle Sales objects that resolve the manager person, salesforce, parent group, and accounting code references. Because of the AUTHID CURRENT_USER clause, those tables must be reachable through the caller's own schema resolution, which in practice is the APPS synonym layer.

Usage Notes

AS_SALES_GROUP_PUB is referenced by one other documented package, indicating that its record and table types are consumed by dependent Oracle Sales APIs rather than being called directly as a standalone service. Typical invocation paths include Oracle Sales forms and concurrent programs that create and maintain sales group hierarchies, and custom extensions that need to construct or pass sales group structures into Oracle Sales APIs. Custom code should use the publicly declared record and table types and honor the FND_API.G_MISS_* conventions so that the receiving implementation can distinguish an attribute supplied by the caller from one that should be defaulted or left unchanged.