Can someone help me to understand where decode value is actually being stored?

Let’s use the following function as example:

When we pass the value to Decode function. for example ‘N’, then the fuction return ‘Not Cyclic Counting’

Inventory_Part_Count_Type_API.Decode(cycle_code) cycle_code

I found that this function called Domain_SYS.Decode_(Domain_SYS.Get_Translated_Values(lu_name_), Get_Db_Values___, db_value_);

FUNCTION Decode (
   db_value_ IN VARCHAR2 ) RETURN VARCHAR2
IS
   
   FUNCTION Base (
      db_value_ IN VARCHAR2 ) RETURN VARCHAR2
   IS
   BEGIN
      RETURN Domain_SYS.Decode_(Domain_SYS.Get_Translated_Values(lu_name_), Get_Db_Values___, db_value_);
   END Base;

BEGIN
   RETURN Base(db_value_);
END Decode;

 

As i further dig into it, it called Domain_SYS.Get_Translated_Values:

FUNCTION Get_Translated_Values (
   domain_ IN VARCHAR2,
   lang_code_ IN VARCHAR2 DEFAULT Fnd_Session_API.Get_Language) RETURN VARCHAR2
IS
BEGIN
   RETURN(coalesce(Get_Ctx_Values___(domain_, lang_code_), Get_Client_Values___(domain_)));
END Get_Translated_Values;

 

as i drill in furhter, it seems like it called Domain_SYS.Get_Ctx_Values___

FUNCTION Get_Ctx_Values___ (
   domain_ IN VARCHAR2,
   value_  IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2
IS
   client_id_     CONSTANT VARCHAR2(64) := Sys_Context('USERENV', 'CLIENT_IDENTIFIER');
   context_       CONSTANT VARCHAR2(30) := domain_ ||suffix_;
   context_value_          VARCHAR2(4000);
BEGIN
   -- We would like to have this check, but it is causing a lot of problems right now.
   -- Raise an error if the domain name is not in the Dictionary
   --IF (NOT Dictionary_SYS.Logical_Unit_Is_Installed(domain_)) THEN 
   --   Error_SYS.Appl_General(service_, 'NOT_A_LU: The domain  :P1] is not a LU in the Dictionary.', domain_);
   --END IF;
   -- The use of global context does not handle when Client Identifier is set, therefore we need to unset it when fetching from the context
   -- If client identifier is set
   IF (client_id_ IS NOT NULL) THEN
      -- Clear client identifier
      Dbms_Session.Clear_Identifier;
      context_value_ := Sys_Context(context_, nvl(value_, 'PROG'), ctx_length_); -- Use PROG if no language
      -- Set back Client identifier
      Dbms_Session.Set_Identifier(client_id_);
   ELSE
      context_value_ := Sys_Context(context_, nvl(value_, 'PROG'), ctx_length_);  -- Use PROG if no language
   END IF;
   RETURN(context_value_);
EXCEPTION
   -- What ever happens make sure that Client Identifier is set to its original value
   WHEN OTHERS THEN
      Dbms_Session.Set_Identifier(client_id_);
      RAISE;
END Get_Ctx_Values___;

 

And from here, then i begin to confuse and not sure how the system decode the ‘N’ to ‘Not Cyclic Counting’

 

Appreciate if anyone can give me some hints.