APPS.WF_SYSTEMS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 8

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;

Line: 20

  insert into wf_systems (
    guid,
    name,
    master_guid,
    display_name,
    description
  ) values (
    X_GUID,
    X_NAME,
    X_MASTER_GUID,
    X_DISPLAY_NAME,
    X_DESCRIPTION
  );

Line: 45

    wf_core.context('Wf_Systems_Pkg', 'Insert_row', x_guid, x_name);

Line: 48

end INSERT_ROW;

Line: 50

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;

Line: 68

    wf_event.raise('oracle.apps.wf.event.system.update',x_guid);

Line: 72

    wf_core.context('Wf_Systems_Pkg', 'Update_row', x_guid, x_name);

Line: 74

end UPDATE_ROW;

Line: 76

procedure DELETE_ROW (
  X_GUID  in  raw
) is
begin
  wf_event.raise('oracle.apps.wf.event.system.delete',x_guid);

Line: 82

  delete from wf_systems
  where  guid  = X_GUID;

Line: 93

    wf_core.context('Wf_Systems_Pkg', 'Delete_row', x_guid);

Line: 95

end DELETE_ROW;

Line: 107

    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);

Line: 118

      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);

Line: 148

  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;

Line: 197

  l_message := WF_EVENT_SYNCHRONIZE_PKG.SetGUID(l_message); -- update #NEW

Line: 198

  l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSYSTEMGUID(l_message); -- update #LOCAL

Line: 199

  l_message := WF_EVENT_SYNCHRONIZE_PKG.SetSID(l_message); -- update #SID