Results for “jtf_tty_overlap_webadi_pkg”

38 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.JTF_TTY_OVERLAP_WEBADI_PKG is a public PL/SQL package body in the Oracle E-Business Suite Territory Management (JTF / TTY) module. Its declared purpose is the population of an interface table used by the Overlapping Territory Group Report. The package therefore acts as a data-preparation utility: it evaluates territory assignments for a named account and materializes the results into a staging interface structure that a reporting or WebADI-based consumer reads.

The package header comment records creation on 08/13/2003 and a modification on 07/08/2008 to handle up to twenty overlapping territories. The 2008 revision is reflected directly in the source, which declares paired local variables (l_TG1 … l_TG20 and l_PARENT1 … l_PARENT20) to hold each overlapping territory group and its corresponding parent territory. The presence of the l_PARENT variable set is the direct technical link to the search term parent_territory: the package resolves, for each overlapping territory group detected, the parent territory in the territory hierarchy and writes that value into the interface record.

Key Procedures and Functions

The package exposes a single documented procedure, POPULATE_INTERFACE. It is the sole entry point and performs all interface population work. Conceptually it accepts a named account identifier, a territory group identifier, a DUNS number, and a user identifier, and returns an output sequence value (x_seq) that identifies the generated interface batch or row set. The DUNS value supplies the external account identifier used to match the account record, while the territory group identifier scopes the overlap evaluation to a specific group.

Internally, the procedure queries the named-account, territory-group, and territory-assignment data, derives the set of overlapping territory groups for the account, and for each one determines its parent territory. The twenty paired local variables indicate the procedure pivots up to twenty overlaps into discrete columns rather than into repeating rows. Once resolved, the results are inserted into the interface table, and the sequence value is returned to the caller. No other procedures or functions are documented in the metadata.

Tables Accessed

  • JTF_TTY_NAMED_ACCTS — source of the named account driving the overlap analysis.
  • JTF_TTY_TERR_GROUPS — territory group definitions, used to scope the overlap set.
  • JTF_TTY_TERR_GRP_ACCTS — association between territory groups and accounts; primary driver for determining which groups overlap for the account.
  • JTF_TERR_ALL — the territory hierarchy view, used to resolve the parent territory for each overlapping territory group.
  • HZ_PARTIES — party/account master data used to validate and enrich the account context.
  • JTF_TTY_WEBADI_INTERFACES and JTF_TTY_INTERFACE_S — the interface and sequence structures written by the procedure; JTF_TTY_INTERFACE_S supplies the sequence returned in x_seq.
  • DUAL — used for scalar evaluations and sequence retrieval.

Usage Notes

The package is documented as publicly available for use, and the metadata records zero packages referencing it, indicating no internal caller. It is therefore invoked externally — typically from a WebADI integrator/uploader, a concurrent program, or customer-written code that needs the Overlapping Territory Group Report interface populated before the report is run. Because the procedure takes a user identifier and returns a sequence, it is suited to batch-style invocation where each run produces an identifiable interface batch. Implementations upgrading from 12.1.1 to 12.2.2 should note that the twenty-territory capacity is fixed by the revised package and that no shipped object depends on it, so direct customization of the interface structure carries limited regression risk.