Search Results cn_mod_obj_depends_s

Overview

CN_UTILS is a shared utility package in the Oracle E-Business Suite Applications (APPS) schema that supports the Oracle ETRM (Enterprise Tax and Regulatory Management) product family. It is classified as an OTHER API, distinguishing it from public transactional APIs such as those used for tax computation or document maintenance. Rather than exposing business transactions, CN_UTILS provides the internal plumbing used consistently across the ETRM codebase: session context handling, string and report formatting helpers, process auditing and logging, and dependency resolution for the ETRM object repository. It is a foundation package, so its stability is critical; changes ripple across every package that depends on it.

Key Procedures and Functions

• SET_ORG_ID / UNSET_ORG_ID — Establish and clear the organizational context (ORG_ID) for an ETRM session, ensuring subsequent queries against multi-org objects return the correct data.
• PKG_INIT / PROC_INIT / INIT_CODE — Initialization entry points that prepare a package or procedure for execution, setting internal state and defaults.
• PKG_END / PKG_END_BOILERPLATE — Standardized cleanup and termination routines invoked at the close of processing.
• INDENT / UNINDENT / APPEND / APPIND / APPENDCR / APPINDCR / STRIP / STRIP_PREV / DUMP_LINE — Text- and output-formatting helpers for generating indented, line-by-line diagnostic or script output. These support the package's role in producing readable trace and code-generation results.
• RECORD_PROCESS_START / RECORD_PROCESS_SUCCESS / RECORD_PROCESS_EXCEPTION — Write audit rows tracking process execution lifecycle, enabling administrators to monitor ETRM background jobs.
• DELETE_MODULE — Removes a module definition and, per the dependency graph, its associated object and dependency records, supporting ETRM repository housekeeping.

In total 52 documented procedures and functions exist; the entries above represent the principal ones relevant to session, audit, and formatting behavior.

Tables Accessed

CN_UTILS reads and writes through APPS synonyms. Repository and metadata tables include CN_MODULES, CN_OBJECTS and CN_OBJECTS_S, CN_MOD_OBJ_DEPENDS and CN_MOD_OBJ_DEPENDS_S, CN_OBJ_PACKAGES_V, CN_OBJ_PROCEDURES_V, CN_REPOSITORIES, CN_DIM_HIERARCHIES, and the CN_SOURCE family (CN_SOURCE, CN_SOURCE_ALL, CN_SOURCE_S). Audit and period tables include CN_PROCESS_AUDITS and CN_PROCESS_AUDITS_S, CN_PERIODS, CN_PERIOD_STATUSES_ALL, and CN_EVENTS. DBMS_LOB supplies LOB handling. These accesses reflect the package's dual purpose: maintaining the ETRM object/module repository and recording process auditing and period information.

Usage Notes

CN_UTILS is not intended for direct end-user invocation. It is called internally by nine other ETRM packages and is not referenced by any database object, confirming its role as a leaf-level utility rather than a top-level entry point. As a valid, compiled package body in APPS, there are no standalone parameters to document here; developers should invoke the wrapper APIs of the dependent packages instead. Because the package underpins ETRM session context and auditing, customization or replacement of its routines is inadvisable and should follow standard EBS patching practice under Oracle support guidance for 12.1.1 and 12.2.2 environments.