Skip to main content
Solved

Object Connection Transformation Variables

  • January 12, 2021
  • 1 reply
  • 333 views

baris.halici
Hero (Customer)
Forum|alt.badge.img+12

Instead of the DN-XL constant value, I need to get the technical class code of each part.

What is your suggestion?

object_connection_transformation
part technical class DN-XL
part technical class DN-AS-N

Thanks..

Best answer by baris.halici

I found the solution. I want to share with you.

 

@UncheckedAccess
FUNCTION Part_No_To_Technical_Class (
   target_key_ref_   IN VARCHAR2,
   service_name_     IN VARCHAR2 ) RETURN VARCHAR2
IS
   source_key_ref_ VARCHAR2(100);
BEGIN
   $IF (Component_Appsrv_SYS.INSTALLED) $THEN
      source_key_ref_:= 'TECHNICAL_CLASS=' || Technical_Object_Reference_API.Get_Technical_Class_With_Key('PartCatalog', 
         'PART_NO=' || Client_SYS.Get_Key_Reference_Value(target_key_ref_,'PART_NO') || '^') || '^';
   $END
   --error_sys.record_general('', source_key_ref_);
   RETURN source_key_ref_;
END Part_No_To_Technical_Class;
technical_class

Good luck!

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

baris.halici
Hero (Customer)
Forum|alt.badge.img+12

I found the solution. I want to share with you.

 

@UncheckedAccess
FUNCTION Part_No_To_Technical_Class (
   target_key_ref_   IN VARCHAR2,
   service_name_     IN VARCHAR2 ) RETURN VARCHAR2
IS
   source_key_ref_ VARCHAR2(100);
BEGIN
   $IF (Component_Appsrv_SYS.INSTALLED) $THEN
      source_key_ref_:= 'TECHNICAL_CLASS=' || Technical_Object_Reference_API.Get_Technical_Class_With_Key('PartCatalog', 
         'PART_NO=' || Client_SYS.Get_Key_Reference_Value(target_key_ref_,'PART_NO') || '^') || '^';
   $END
   --error_sys.record_general('', source_key_ref_);
   RETURN source_key_ref_;
END Part_No_To_Technical_Class;
technical_class

Good luck!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings