Results for “get_thsid_byname”

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

Overview

CTXSYS.DRITHSL is an Oracle Text (interMedia Text) internal package body that belongs to the CTXSYS schema and is shipped with the Oracle database technology stack on which Oracle E-Business Suite 12.1.1 and 12.2.2 are deployed. In the EBS architecture this package is not an Applications-owned object; it is a database-supplied component that supports the thesaurus management facilities of Oracle Text. The package name, DRITHSL, is a compressed form of a descriptive identifier relating to "DR" (the Oracle Text dr$ dictionary infrastructure) and "THS" (thesaurus). Its declared API classification within the ETRM repository is OTHER, reflecting that it is a supporting internal package rather than a public EBS business API. Functionally, DRITHSL provides the low-level primitives used to build, load, dump, and maintain thesaurus entries stored in the Oracle Text thesaurus tables. The package body is delivered in wrapped (obfuscated) form, as evidenced by the "PACKAGE BODY drithsl wrapped" header and the encoded payload reproduced in the ETRM source extract. Because the source is wrapped, the documented interface — the list of exposed subprograms and referenced objects — is the primary means by which its behavior can be described.

Key Procedures and Functions

The ETRM metadata documents ten subprograms in the package specification. Their names indicate the thesaurus-editing workflow they implement:

• CREATE_THESAURUS — Establishes a new thesaurus definition, creating the container record under which phrases and relationships are subsequently stored.
• GET_THSID_BYNAME — Resolves a thesaurus name to its internal thesaurus identifier (THSID), which other routines use as a key.
• INSERT_PHRASE — Adds a phrase (term) to an existing thesaurus identified by its THSID.
• INSERT_BT — Inserts a "broader term" (BT) relationship, one of the standard thesaurus relation types used in Oracle Text thesauri.
• INSERT_FPHRASE — Inserts a related phrase entry, supporting the associative and equivalence relationships of the thesaurus model.
• UPDATE_PHRASE — Modifies an existing phrase record, such as correcting a term or changing its attributes.
• ALLOCATE_IDS — Generates and reserves the internal identifier values required when new thesaurus rows are created.
• DUMP_THESAURUS — Produces a serialized textual dump of a thesaurus, used for export, migration, or diagnostic inspection.
• NEXT_DUMP_LINE — Retrieves the successive line of the dump produced by DUMP_THESAURUS, allowing the output to be consumed incrementally by a calling program or client tool.
• CREATE_PHRASE — Higher-level convenience routine that creates a phrase entry, likely coordinating identifier allocation and insertion.

Parameter lists are not reproduced in the ETRM extract and are therefore not stated here; the descriptions above are limited to the documented purpose implied by each program unit name.

Tables Accessed

The documented table references for this package, resolved through APPS synonyms, are DBMS_ASSERT and DUAL. DUAL is the standard single-row Oracle dictionary table, typically used for expression evaluation and for retrieving generated or sequence-like values during identifier allocation and dump generation. DBMS_ASSERT is the Oracle-supplied PL/SQL package used to validate schema and object names supplied as input, guarding against SQL injection when dynamic SQL is constructed from user- or administrator-supplied thesaurus names. The actual thesaurus data is held in Oracle Text dictionary tables in the CTXSYS schema, which are managed internally by the package; the ETRM metadata does not enumerate those underlying tables, so they are not itemized here. No Applications product tables are referenced.

Usage Notes

Because DRITHSL is an internal CTXSYS component rather than an EBS API, it is not invoked directly by Oracle E-Business Suite forms, concurrent programs, or standard application logic. The ETRM metadata records zero packages referencing it, confirming that no shipped EBS package declares a dependency on it. In practice it is exercised indirectly: when an administrator creates or loads an Oracle Text thesaurus — for example, through the thesaurus creation and loading utilities provided by Oracle Text, or when a text index that references a thesaurus is built or synchronized — the underlying CTXSYS routines, including those in DRITHSL, perform the catalog updates. Custom code should not call these subprograms directly; the supported entry points are the Oracle Text thesaurus management interfaces and the CTX_DDL-style APIs. The wrapped state of the body further discourages direct dependency, since the implementation is not readable and is subject to change between database releases. The presence of this package in an EBS 12.1.1 or 12.2.2 environment is therefore an artifact of the underlying database's Oracle Text feature set, not of the Applications schema itself.