DECLARE
  I_OWNER VARCHAR2(32767);
  I_TABLE_NAME VARCHAR2(32767);
  I_ID_NAME VARCHAR2(32767);
  I_ID_VALUE NUMBER;
  I_UPDATING_COLUMNS SYNC.CORE_APP_UTILS.string_table;
  I_UPDATING_VALUES SYNC.CORE_APP_UTILS.string_table;

BEGIN
  I_OWNER := 'SYNC';
  I_TABLE_NAME := 'ZPATCH_HDIM';
  I_ID_NAME := 'ZPATCH_ID';
  I_ID_VALUE := 468;

  SELECT 'PARENT_ID'    BULK COLLECT INTO I_UPDATING_COLUMNS FROM dual;
  SELECT 'ZPATCHSTATUS' BULK COLLECT INTO I_UPDATING_COLUMNS FROM dual;

  SELECT '318'    BULK COLLECT INTO I_UPDATING_COLUMNS FROM dual;
  SELECT 'READY'  BULK COLLECT INTO I_UPDATING_COLUMNS FROM dual;

  SYNC.CORE_APP_UTILS.P_UPDATE ( I_OWNER, I_TABLE_NAME, I_ID_NAME, I_ID_VALUE, I_UPDATING_COLUMNS, I_UPDATING_VALUES );
  COMMIT;
END;