Results for “update_effectivity”

14 results




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

Overview

ITG_ORGEFF_PVT is a private PL/SQL package in the APPS schema belonging to the Oracle E-Business Suite Trade Management (formerly Oracle Transportation Management / ETRM) family of modules. Its name follows the standard EBS API naming convention, where the "_PVT" suffix designates a private, internal implementation package that is not intended for direct invocation by external or customer-written code. The package encapsulates the core business logic governing organizational effectivity — the rules that determine whether a given organization, operating unit, or inventory organization is active and valid for a specific date range or business context.

In EBS 12.1.1 and 12.2.2, organizational effectivity controls how transactions, sourcing rules, and trade compliance validations are scoped. Organizations may be enabled or disabled over time, and downstream processes must respect these windows. ITG_ORGEFF_PVT centralizes the validation and maintenance of this effectivity data, ensuring consistent enforcement across the ETRM integration layer without duplicating logic in each calling program.

Key Procedures and Functions

The package exposes two documented procedures:

  • CHECK_EFFECTIVE — Validates whether an organization is effective for a given context, returning a status that indicates whether the organization qualifies as active. It is the primary validation entry point invoked by other packages before processing organization-dependent transactions.
  • UPDATE_EFFECTIVITY — Maintains and updates effectivity records, applying changes to the organization effectivity data so that subsequent checks reflect the revised state.

Both are declared in the package specification and implemented in the package body. As private APIs, they are not documented for direct external use.

Tables Accessed

The package interacts with the following tables, accessed through APPS synonyms:

  • ITG_ORG_EFFECTIVITY — The primary table storing organizational effectivity definitions, including effective date ranges and status.
  • ITG_ORG_EFFECTIVITY_S — The sequence source used to generate unique primary keys for new effectivity records inserted by UPDATE_EFFECTIVITY.
  • ITG_ORG_INDICATOR — Holds organization-level indicator flags that qualify or refine effectivity evaluation during CHECK_EFFECTIVE processing.
  • FND_LOOKUP_VALUES — The standard EBS lookup table, consulted to resolve coded values such as status or type meanings used in validation.

Usage Notes

ITG_ORGEFF_PVT is invoked indirectly. Its documented dependents are ITG_BOAPI_WRAPPERS, ITG_OUTBOUND_UTILS, and the package itself (internal recursion). ITG_BOAPI_WRAPPERS exposes business-object API wrappers that call into the private package to validate organizations during inbound or outbound integrations; ITG_OUTBOUND_UTILS uses it when constructing outbound messages that must reference only effective organizations. Because the package depends on FND_API and the STANDARD package, it conforms to the EBS API error-handling model.

Developers should not call ITG_ORGEFF_PVT directly. Instead, they should invoke the public wrapper layer (such as ITG_BOAPI_WRAPPERS) which enforces the same validations with a supported interface. Any custom code reusing CHECK_EFFECTIVE should be aware that the package is private and may change between releases, including the migration from 12.1.1 to 12.2.2.