The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure INSERT_ROW (
X_ROWID in out nocopy varchar2,
X_GUID in raw,
X_NAME in varchar2,
X_MASTER_GUID in raw,
X_DISPLAY_NAME in varchar2,
X_DESCRIPTION in varchar2
) is
cursor C is select rowid
from wf_systems
where guid = X_GUID;
insert into wf_systems (
guid,
name,
master_guid,
display_name,
description
) values (
X_GUID,
X_NAME,
X_MASTER_GUID,
X_DISPLAY_NAME,
X_DESCRIPTION
);
wf_core.context('Wf_Systems_Pkg', 'Insert_row', x_guid, x_name);
end INSERT_ROW;
procedure UPDATE_ROW (
X_GUID in raw,
X_NAME in varchar2,
X_MASTER_GUID in raw,
X_DISPLAY_NAME in varchar2,
X_DESCRIPTION in varchar2
) is
begin
update wf_systems
set name = X_NAME,
master_guid = X_MASTER_GUID,
display_name = X_DISPLAY_NAME,
description = X_DESCRIPTION
where guid = X_GUID;
wf_event.raise('oracle.apps.wf.event.system.update',x_guid);
wf_core.context('Wf_Systems_Pkg', 'Update_row', x_guid, x_name);
end UPDATE_ROW;
procedure DELETE_ROW (
X_GUID in raw
) is
begin
wf_event.raise('oracle.apps.wf.event.system.delete',x_guid);
delete from wf_systems
where guid = X_GUID;
wf_core.context('Wf_Systems_Pkg', 'Delete_row', x_guid);
end DELETE_ROW;
WF_SYSTEMS_PKG.UPDATE_ROW (
X_GUID => X_GUID,
X_NAME => X_NAME,
X_MASTER_GUID => X_MASTER_GUID,
X_DISPLAY_NAME => X_DISPLAY_NAME,
X_DESCRIPTION => X_DESCRIPTION);
WF_SYSTEMS_PKG.INSERT_ROW(
X_ROWID => row_id,
X_GUID => X_GUID,
X_NAME => X_NAME,
X_MASTER_GUID => X_MASTER_GUID,
X_DISPLAY_NAME => X_DISPLAY_NAME,
X_DESCRIPTION => X_DESCRIPTION);
select name, master_guid, display_name, description
into l_name, l_master_guid, l_display_name, l_description
from wf_systems
where guid = x_guid;
l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW
l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL
l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID