43: X_ACTION_ID number;
44: begin
45: select AME_ACTIONS_S.NEXTVAL
46: into X_ACTION_ID
47: from dual;
48:
49: insert into AME_ACTIONS
50: (ACTION_ID
51: ,ACTION_TYPE_ID
72: X_LAST_UPDATED_BY,
73: X_LAST_UPDATE_DATE,
74: X_LAST_UPDATE_LOGIN,
75: X_OBJECT_VERSION_NUMBER
76: from dual
77: where not exists (select null
78: from AME_ACTIONS
79: where ACTION_TYPE_ID = X_ACTION_TYPE_ID
80: and PARAMETER = X_PARAMETER