Search Results jtf_tty

Overview

APPS.JTF_TTY_NA_TERRGP is a PL/SQL package body in the Oracle E-Business Suite CRM/TeleSales foundation layer that implements the Custom Assignment API for Territory Manager named accounts. The package coordinates the definition of territories and territory groups, the association of resources and roles to those groups, and the automatic assignment of named accounts to the appropriate territory owner. It is part of the JTF (Java Technology Foundation) family of packages used by the TeleSales and Territory Manager modules, and its header comment explicitly identifies its purpose as "Custom Assignment API" while marking it "ORACLE INTERNAL USE ONLY: NOT for customer use."

The package was first created in March 2002 and evolved through a series of defect corrections addressing named account creation, group ownership validation, hierarchy checking, and performance of account summarization routines. The final recorded revision in the source header dates to July 2006 (version 120.6).

Key Procedures and Functions

The documented API surface comprises twenty-six procedures and functions organized around four functional areas:

• Territory group lifecycle: DELETE_TERRGP removes a territory group, while ENTER_TERRGP_DETAILS and ADD_ORGS_TO_TERRGP populate group details and attach organizations to the group.
• Roles, access, and interest: TERRGP_DEFINE_ROLE, TERRGP_CREATE_ACCESS, TERRGP_DEFINE_ACCESS, and TERRGP_DEFINE_INTEREST establish which roles and resources may act within a territory group and what interests they represent.
• Named account management: CREATE_TGP_NAMED_ACCOUNT and DELETE_TGP_NAMED_ACCOUNT create and remove named accounts tied to territory groups. ASSIGN_ACCTS, ASSIGN_ACCT, DELETE_ASSIGN_ACCTS, and PROCESS_ASSIGN_ACCTS assign accounts to owners, and TERRGP_ASSIGN_OWNERS and DELETE_TERRGP_OWNERS_ROLES manage owner and role associations.
• Summarization and utilities: SUM_ACCTS, SUM_OWNER_ACCTS, and SUM_RES_GP_ACCTS aggregate account counts by owner, resource, and group. GET_SITE_TYPE and GET_SITE_TYPE_CODE resolve site type codes from party identifiers, and GENERATENUMLIST produces numeric list values used in assignment processing.

Historical comments indicate that assignment flags are initialized to 'N' at creation time, that assigned_to_direct_flag is set to 'N' for new territory-group named accounts, and that later revisions removed dependency on denormalized summary tables and added hierarchy validation.

Tables Accessed

The package operates against Trading Community Architecture and resource management tables. Party and location data is read from HZ_PARTIES, HZ_PARTY_SITES, HZ_LOCATIONS, and HZ_RELATIONSHIPS, supporting site type resolution and relationship validation. Resource and group structure is drawn from JTF_RS_GROUP_MEMBERS, JTF_RS_GROUPS_DENORM, JTF_RS_REP_MANAGERS, JTF_RS_RESOURCE_EXTNS, JTF_RS_ROLES_B, and JTF_RS_ROLE_RELATIONS. Territory and assignment data is persisted in JTF_TTY_GEO_TERR, JTF_TTY_GEO_TERR_RSC, JTF_TTY_NAMED_ACCTS, and the JTF_TTY_ACCT_QUAL_MAPS and JTF_TTY_ACCT_QUAL_MAPS_S tables, which hold account-to-qualifier mappings.

Usage Notes

Because the package is documented as internal, it is not intended for direct customer invocation. It is called by Territory Manager and TeleSales assignment processing, typically triggered from the Territory Manager forms and from concurrent programs that run the custom assignment algorithms. The metadata records three other packages that reference JTF_TTY_NA_TERRGP. Customizations should avoid calling this body directly; instead, they should target the supported public APIs or configuration mechanisms, since internal signatures and behavior may change across patch levels in 12.1.1 and 12.2.2.