Skip to main content
Solved

Object Connection Transformation Variables

  • January 12, 2021
  • 1 reply
  • 346 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!

This topic has been closed for replies.

1 reply

baris.halici
Hero (Customer)
Forum|alt.badge.img+12
  • Author
  • Hero (Customer)
  • Answer
  • January 13, 2021

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!