Search Results process_trans_data

Overview

AS_ATA_TOTAL_PUB is a public PL/SQL package in the Oracle E-Business Suite Advanced Sales (AS) module that orchestrates territory assignment processing across multiple sales entities within Oracle Territory Manager. The package body is identified internally as "ATA TOTAL MODE," and its constants and private routines indicate that it coordinates the assignment of territory access for accounts, leads, opportunities, quotes, and proposals. In Oracle EBS 12.1.1 and 12.2.2, territory assignment is the mechanism by which sales resources are matched to the customers, prospects, and pipeline objects they are authorized to work on. AS_ATA_TOTAL_PUB serves as the aggregate driver that processes changed entities and generates the corresponding territory access records. The documented API classification is PUB, meaning it is intended for external invocation by other EBS components or controlled custom code rather than being purely internal.

Key Procedures and Functions

The ETRM metadata documents six public procedures within this package:

• ASSIGN_ACCOUNT_TERR_ACCESSES — Processes territory access assignments for account records, based on the account type and an optional additional WHERE clause. This is the primary entry point for account-based territory assignment and is associated with the private constant "PROCESS ACCOUNT TRANS."
• ASSIGN_LEAD_TERR_ACCESSES — Processes territory access assignments for lead records, corresponding to the "PROCESS LEAD TRANS" constant.
• ASSIGN_OPPTY_TERR_ACCESSES — Processes territory access assignments for opportunity records, associated with "PROCESS OPPORTUNITY TRANS."
• ASSIGN_QUOTE_TERR_ACCESSES — Processes territory access assignments for quote records, associated with "PROCESS QUOTES TRANS."
• ASSIGN_PROPOSAL_TERR_ACCESSES — Processes territory access assignments for proposal records, associated with "PROCESS PROPOSAL TRANS."
• DELETE_CHANGED_ENTITY — Removes processed entries from the changed-entity staging tables after territory assignment has completed, preventing redundant reprocessing.

The body also declares a private procedure, Process_trans_data, which accepts a transaction identifier, an optional additional WHERE clause, a percentage-analyzed parameter, a trace mode flag, and an OUT return status. This private routine performs the core per-entity processing invoked by the public procedures. A deadlock detection exception (-60) is declared, indicating the package anticipates concurrent processing contention.

Tables Accessed

The package operates against the following documented tables, accessed via APPS synonyms:

• AS_CHANGED_ACCOUNTS_ALL, ASO_CHANGED_QUOTES, PRP_CHANGED_PROPOSALS — staging tables holding entities whose territory assignments have changed and require reprocessing.
• AS_TERR_RESOURCES_TMP — temporary table holding territory resource matches generated during assignment.
• FND_PROFILE_OPTIONS, FND_PROFILE_OPTION_VALUES — profile option definitions and values used to drive runtime behavior and defaults.
• FND_USER — resolves the current user context for processing.
• DBMS_STATS and PLITBLM — invoked for statistics collection and PL/SQL table manipulation respectively.

Usage Notes

AS_ATA_TOTAL_PUB is typically invoked from the Territory Manager assignment concurrent programs and from Territory Manager forms where administrators trigger territory access regeneration for changed entities. Because it is classified as a public API, it may also be called from controlled custom code that integrates with territory assignment. Invocations should supply the appropriate account type or entity filter and an optional additional WHERE clause to constrain the population processed. The package is not referenced by any other package per the documented metadata, so its callers are concurrent programs, forms, or external custom code. The deadlock detection logic and the use of temporary staging tables indicate that it should not be run concurrently for overlapping entity populations without coordinating the changed-entity tables.