Search Results is_release_110

Overview

APPS.CN_UPGRADE_UTL_PKG is a utility package within the Oracle E-Business Suite Channel Revenue Management (formerly Oracle Incentive Compensation / Channel Manager) module. Its primary business function is to provide release-identification helpers and period date-boundary lookups used during upgrade and migration processing. The package header carries the RCS identifier cnuputls.pls 120.1 dated 2006, and is marked noship, indicating it is an internal, non-shipped utility object invoked by upgrade scripts and internal processing logic rather than by end users directly.

In the context of EBS 12.1.1 and 12.2.2, the package retains its historical release-check functions, which allow upgrade routines to branch logic conditionally based on the source release being migrated from. These version predicates were essential when consolidating code paths across the 10.7, 11.0, 11.5, 11.5.10, and 12.x releases. The ETRM 12.2.2 metadata classifies the package under API classification OTHER, and it is referenced by zero other packages, confirming its role as a leaf-level utility rather than a shared API dependency.

Key Procedures and Functions

The package exposes twelve documented procedures and functions. The date functions return period boundaries for a given period and operating unit:

• GET_START_DATE — returns the start date of a period for a specified period and organization. Declared with PRAGMA RESTRICT_REFERENCES (...,WNDS,WNPS), so it performs no writes.
• GET_END_DATE — returns the end date of a period for a specified period and organization, also restricted from writes.

The release-check functions return a numeric indicator: typically 1 when the current release matches, 0 when it is a different valid release, and -1 when the release is not recognized as valid.

• IS_RELEASE_107 — returns 1 if the current release is 10.7; 0 if it is 11.5, 3i, or 11.0; -1 if not a valid release. This is the function associated with the user's search term.
• IS_RELEASE_110 — tests for release 11.0.
• IS_RELEASE_115 — returns 1 if the current release is 11.5; 0 if 10.7, 3i, or 11.0.
• IS_RELEASE_11510 — returns 1 if the current release is 11.5.10; 0 if 10.7, 3i, 11.0, or 11.5.
• IS_RELEASE_120 — returns 1 if the current release is 120; -1 if not valid.
• IS_RELEASE_3I — tests for the 3i (Applications 3i) release.
• IS_RELEASE_121 — tests for release 12.1.

Three additional routines — CNCMAUPD_R1212, CNCMHUPD_R1212, and CNSRPTXN_R1212 — are release 12.1.2 upgrade procedures, presumably handling commission header, commission line, and SRP transaction data migration respectively.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• CN_COMMISSION_HEADERS_ALL and CN_COMMISSION_LINES_ALL — commission transaction headers and lines, updated during R12.1.2 upgrade processing.
• CN_COMM_LINES_API_ALL — the API shadow table for commission lines.
• CN_PERIOD_STATUSES_ALL — supplies period identifiers and open/closed status used by GET_START_DATE and GET_END_DATE.
• CN_SRP_PERIOD_QUOTAS_ALL — SRP period quota data migrated by CNSRPTXN_R1212.
• FND_PRODUCT_GROUPS, FND_PROFILE_OPTIONS, and FND_PROFILE_OPTION_VALUES — read to determine the installed release and profile-option settings that drive the IS_RELEASE_* predicates.

Usage Notes

CN_UPGRADE_UTL_PKG is not intended for direct end-user invocation. It is typically called from upgrade driver scripts, concurrent programs executed during patching, and internal Channel Revenue Management processing that must conditionally differentiate behavior by source release. Custom code should not depend on the IS_RELEASE_* functions for new development, since they encode obsolete release history (10.7 through 12.1); however, they remain present in 12.1.1 and 12.2.2 for backward compatibility with legacy upgrade paths. Because the object is flagged noship and referenced by no other package, it should be treated as internal infrastructure.