CREATE TABLE "PARTY"
  (
    "PARTY_CODE" NUMBER NOT NULL ENABLE
  )
  CREATE
OR REPLACE TRIGGER "BI_PARTY" before
INSERT ON "PARTY" FOR EACH row BEGIN IF :NEW."PARTY_CODE" IS NULL THEN
SELECT "PARTY_SEQ".nextval INTO :NEW."PARTY_CODE" FROM dual;
END IF;
END;
/

CREATE TABLE "LISA"."PARTY_IN_GROUP"
  (
    "PARTY_GROUP" VARCHAR2( 4000  BYTE) NOT NULL ENABLE,
    "PARTY"       NUMBER NOT NULL ENABLE
  )
  CONSTRAINT "ЛИЦО_ГРУППА_FK" FOREIGN KEY
  (
    "PARTY"
  )
  REFERENCES "PARTY"
  (
    "PARTY_CODE"
  )
  ON

begin
insert 
into party (PARTY_CODE)
values (:P54_PARTY_CODE);

insert 
into party_in_group
(PARTY)
values
(:P54_PARTY_CODE);

commit;
end;

DECLARE
  PARTY_ID PARTY.PARTY_CODE%TYPE;
begin
insert 
into party (PARTY_CODE)
values (:P54_PARTY_CODE)

RETURNING PARTY_CODE INTO PARTY_ID;

insert
into party_in_group
(PARTY)
values
(PARTY_ID);

commit;
end;