Search Results compare_rcsid

Overview

FND_IMP_CONV_PKG is a utility package in the Oracle E-Business Suite Application Object Library (FND) schema that supports the internal infrastructure used to identify, compare, and manage RCS identifiers (RCSIDs) associated with imported or patched objects. In Oracle EBS releases 12.1.1 and 12.2.2, the FND_IMP family of packages underpins the import and installation machinery that tracks which version or branch of a source object (historically maintained in RCS, the Revision Control System) has been applied within the database. FND_IMP_CONV_PKG provides the conversion and comparison primitives that allow this machinery to reason about RCSIDs and RCS names in a consistent fashion.

The package is classified as OTHER under the documented API classification, indicating it is an internal utility rather than a public, supported extension point. Its header carries a "noship" designation in the source control comment, a common marker for objects that are not shipped to customers directly but are part of the application's own dependency and patching framework. The package is referenced by three other packages, confirming its role as a shared low-level service rather than a standalone application-facing API.

Key Procedures and Functions

The documented interface exposes seven functions and procedures. Several are overloaded, allowing the same logical operation to be performed against either a textual RCS name or a structured RCS identifier type.

• compare_rcsid — Two overloaded functions that compare RCS identifiers. One accepts two RCS names as varchar2 arguments; the other accepts two values of the FND_IMP_RCSID type. Both return an INTEGER indicating the ordering or equivalence relationship between the two inputs.
• get_rcsid — Returns the structured FND_IMP_RCSID value corresponding to a supplied RCS name (varchar2). This allows callers holding a textual reference to obtain the canonical identifier used internally.
• get_rcsname — The inverse operation: given an RCS name, it returns a VARCHAR2 representation. This supports round-tripping between the textual and internal representations.
• check_branching — Two overloaded functions that determine whether two RCS identifiers, or two RCS names, lie on divergent branches of the version tree. Each returns an INTEGER indicating the branching relationship.
• uninstall — A procedure that reverses the package's own installation artifacts, supporting cleanup during deinstallation or patch rollback.

Tables Accessed

The only documented table reference, accessed via APPS synonyms, is ALL_OBJECTS. This data dictionary view is used to enumerate and validate database objects during comparison and branching checks, allowing the package to correlate RCS metadata with objects that actually exist in the current schema. No application data tables are read or written, which is consistent with the package's role as internal infrastructure.

Usage Notes

FND_IMP_CONV_PKG is not intended for direct invocation by end users or standard forms. It is called by the import and patching subsystems and by the three dependent packages identified in the metadata. Custom code should treat it as unsupported and insensitive to the "noship" marker. Its behaviour is version-specific: the 120.1 source revision documented here reflects the 12.1.1 lineage, and although the same object remains present in 12.2.2, its consumers and surrounding import framework differ between the two releases. The user search term "compare_rcsid" corresponds directly to the overloaded comparison functions documented above, which are the most likely entry points of interest when diagnosing import or version-comparison behaviour.