Search Results p_qte_header_rec

Overview

ASO_SALES_TEAM_PVT is a private PL/SQL package in the Oracle EBS Applications (APPS) schema that supports sales team processing for Oracle Quoting (ASO) quotations. The package is declared with AUTHID CURRENT_USER, signifying it executes with the privileges of the calling schema, consistent with Oracle EBS API conventions. It is classified as a PVT (private) API, meaning it is intended for internal use by Oracle Quoting modules rather than as a public integration interface. Its central responsibility is resolving, assigning, and maintaining the sales team associated with a quote header and its lines, including territory-based real-time assignment of sales representatives, groups, and teams.

The presence of P_Qte_Header_Rec — the quote header record parameter referenced in the search — reflects the package's reliance on the ASO_QUOTE_PUB.Qte_Header_Rec_Type record structure, which carries the quote header context into and out of each API call.

Key Procedures and Functions

• ASSIGN_SALES_TEAM — Assigns a sales team to a quote header and its lines. It accepts the quote header record and quote line table, an operation indicator, and standard FND_API message-list, commit, and return-status parameters. It returns the updated quote header record and messaging outputs.
• GET_SALES_TEAM — Retrieves the applicable sales team for a quote using the header record and line table as input. It returns a bulk winners record (X_Winners_Rec) drawn from JTY_ASSIGN_REALTIME_PUB, reflecting territory-based real-time assignment results, along with return status and message data.
• UPDATE_PRIMARY_SALESINFO — Updates primary sales information on a quote header, accepting the primary sales agent and sales group identifiers plus a reassignment flag, and returning the updated header record.
• OPP_QUOTE_PRIMARY_SALESREP — Handles primary sales representative resolution in the context of quotes associated with opportunities.
• EXPLODE_GROUPS_ACCOUNTS — Expands sales group definitions to their constituent accounts, supporting team derivation.
• EXPLODE_TEAMS — Expands a sales team into its member resources and subordinate groups.
• INSERT_ACCESSES_ACCOUNTS — Inserts quote access records for accounts, populating the quote access structures used for sales team visibility and security.

Tables Accessed

The package reads and writes quotation access data through ASO_QUOTE_ACCESSES and ASO_QUOTE_ACCESSES_S, and references the quote header through ASO_QUOTE_HEADERS_ALL. Working data is staged in ASO_STEAM_TEMP. Resource and team structures are drawn from JTF_RS_GROUPS_B, JTF_RS_GROUP_MEMBERS, JTF_RS_GROUP_USAGES, JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, JTF_RS_ROLE_RELATIONS, JTF_RS_SALESREPS_MO_V, JTF_RS_TEAMS_B, JTF_RS_TEAM_MEMBERS, and JTF_RS_TEAM_USAGES. Sales credit type validation is supported via OE_SALES_CREDIT_TYPES.

Usage Notes

As a private API, ASO_SALES_TEAM_PVT is not intended for direct customer invocation; it is referenced by four other packages within the Oracle Quoting stream. It is invoked during quote creation and update when sales team assignment, primary sales representative changes, or quote access generation are required. The Assign_Sales_Team and Update_Primary_SalesInfo procedures may be called with commit control, allowing callers to manage transaction boundaries. Custom code requiring comparable functionality should use supported public APIs such as ASO_QUOTE_PUB rather than calling this private package directly.