APPS.WF_EVENT_GROUPS_PKG SQL Statements

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

Line: 6

procedure INSERT_ROW (
  X_ROWID           in out nocopy  varchar2,
  X_GROUP_GUID      in      raw,
  X_MEMBER_GUID     in      raw
) is
  cursor C is select rowid
              from   wf_event_groups
              where  group_guid  = X_GROUP_GUID
              and    member_guid = X_MEMBER_GUID;

Line: 16

  insert into wf_event_groups (
    group_guid,
    member_guid
  ) values (
    X_GROUP_GUID,
    X_MEMBER_GUID
  );

Line: 36

    wf_core.context('Wf_Event_Groups_Pkg', 'Insert_Row', x_group_guid, x_member_guid);

Line: 39

end INSERT_ROW;

Line: 41

procedure UPDATE_ROW (
  X_GROUP_GUID      in      raw,
  X_MEMBER_GUID     in      raw
) is
begin
  update wf_event_groups set
    group_guid      = X_GROUP_GUID,
    member_guid     = X_MEMBER_GUID
  where  group_guid  = X_GROUP_GUID
   and    member_guid = X_MEMBER_GUID;

Line: 55

    wf_event.raise('oracle.apps.wf.event.group.update',x_group_guid||'/'||x_member_guid);

Line: 60

    wf_core.context('Wf_Event_Groups_Pkg', 'Update_Row', x_group_guid,
        x_member_guid);

Line: 63

end UPDATE_ROW;

Line: 71

  WF_EVENT_GROUPS_PKG.UPDATE_ROW (
    X_GROUP_GUID  => X_GROUP_GUID,
    X_MEMBER_GUID => X_MEMBER_GUID
  );

Line: 79

    WF_EVENT_GROUPS_PKG.INSERT_ROW(
      X_ROWID       => row_id,
      X_GROUP_GUID  => X_GROUP_GUID,
      X_MEMBER_GUID => X_MEMBER_GUID
    );

Line: 91

procedure DELETE_ROW (
  X_GROUP_GUID  in  raw,
  X_MEMBER_GUID in  raw
) is
begin
  wf_event.raise('oracle.apps.wf.event.group.delete',x_group_guid||'/'||x_member_guid);

Line: 98

  delete from wf_event_groups
  where  group_guid  = X_GROUP_GUID
  and    member_guid = X_MEMBER_GUID;

Line: 108

    wf_core.context('Wf_Event_Groups_Pkg', 'Delete_Row', x_group_guid,
       x_member_guid);

Line: 112

end DELETE_ROW;

Line: 158

   Select 1 into event_count
   from   WF_EVENTS
   where  guid=X_MEMBER_GUID;

Line: 186

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

Line: 187

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

Line: 188

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

Line: 209

       select guid
       into   l_group_guid
       from   wf_events
       where  name = l_value
       and    type = 'GROUP';

Line: 215

       select guid
       into   l_member_guid
       from   wf_events
       where  name = l_value;