Search Results fk_id_is_valid




Overview
Explore in AI Chat

Overview

JTF_CTM_UTILITY_PVT is a private PL/SQL utility package in the Oracle E-Business Suite, shipped under the APPS schema with the source file jtfvutlb.pls (version 120.0, last updated 2005/06/02). It belongs to the CRM/TeleSales/Interaction Center (JTF) technology stack and provides the shared validation and string-handling routines used across that product family. The package is classified as a Private API (PVT), meaning it is intended for internal consumption by other EBS packages and is not a published integration interface. First created in August 1999 and maintained through April 2000 and March 2004 (bug fix 3511203), it reflects a long-standing pattern in EBS: small, reusable "helper" packages that centralize common logic such as foreign-key validation, lookup verification, message retrieval, and text formatting.

Key Procedures and Functions

  • FK_ID_IS_VALID — Returns TRUE if the primary-key value supplied exists in the target foreign-key table, otherwise FALSE. It builds a dynamic query against the indicated table and column, and on failure optionally logs a debug message (JTF_TERR_INVALID_FOREIGN_KEY) via FND_MSG_PUB.
  • LOOKUP_CODE_IS_VALID — This is the routine most relevant to the search term "lookup_code_is_valid". It verifies that a given lookup value is valid for an item, returning a Boolean-style indicator. It is the standard mechanism used by TeleSales and Territory Management components to confirm that a code exists in the appropriate Oracle lookup before it is stored or processed.
  • TRANSLATE_ORDERBY — Converts or translates an ORDER BY expression, typically mapping user-supplied sort criteria into a form usable in a dynamic SQL statement.
  • SPLIT — Splits a delimited string into its component values, supporting list processing used by calling code.
  • FORMAT_VIEW_TEXT — Formats and renders view text, applying the display conventions required by the JTF user interface.
  • GET_MESSAGES — Retrieves messages from the EBS message dictionary, added in the 04/19/00 revision to centralize message handling within the package.

Tables Accessed

  • FND_NEW_MESSAGES — Read to obtain message text and tokens, supporting the GET_MESSAGES and validation routines.
  • FND_ORACLE_USERID — Used for user/session identification in conjunction with FND_GLOBAL calls.
  • ALL_VIEWS — Queried to resolve view definitions, typically in support of dynamic SQL construction.
  • PLITBLM — The PL/SQL intermediate table indexed by line and message, used for message storage and splitting operations.
  • USER_TAB_COLUMNS — Read to determine column names and structure when validating foreign-key or lookup values dynamically.

Usage Notes

Because JTF_CTM_UTILITY_PVT is a Private package, it is not called directly from forms or concurrent programs by end users. Instead, it is referenced by five other packages within the JTF/CRM codebase, which invoke its validation, string-splitting, and message-retrieval routines. Custom developers who need the same validation semantics—particularly lookup-code and foreign-key validation—should call the owning public API rather than this package, and should be aware that the package signature is not guaranteed across releases. The routine depends on FND_GLOBAL session context (application, login, program, user, and request identifiers captured as package globals) and on FND_API.G_TRUE/G_FALSE return conventions.