Hello Expert, I want to update / copy Instance id to instance number, Can we update Instance number

@C_INSTANCE_NUM

Hello All,

I am trying to update Instance Number by Instance Id through apps.CSI_ITEM_INSTANCE_PUB.update_item_instance but getting error :

can you please help me its very urgent.

CREATE OR REPLACE PROCEDURE UPD_ITEM_INSTANCE_NUM_POC AS

  CURSOR @C_INSTANCE_NUM IS

  SELECT INSTANCE_ID,INSTANCE_NUMBER,object_version_number

    FROM CSI_ITEM_INSTANCES

   WHERE INSTANCE_ID IN (11068);--,11069);

  X_RETURN_STATUS VARCHAR2(50);

  X_MSG_COUNT     NUMBER;

  X_MSG_DATA      VARCHAR2(4000);

  V_INSTANCE_REC CSI_DATASTRUCTURES_PUB.INSTANCE_REC;

  V_EXTEND_ATTRIB_VALUES_TBL CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

  V_PARTY_TBL CSI_DATASTRUCTURES_PUB.PARTY_TBL;