APPS.WF_AGENT_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_agent_groups
              where  group_guid  = X_GROUP_GUID
              and    member_guid = X_MEMBER_GUID;

Line: 16

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

Line: 36

    wf_core.context('Wf_Agent_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_agent_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.agent.group.update',x_group_guid||'/'||x_member_guid);

Line: 60

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

Line: 63

end UPDATE_ROW;

Line: 71

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

Line: 78

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

Line: 90

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

Line: 97

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

Line: 107

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

Line: 111

end DELETE_ROW;

Line: 210

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

Line: 211

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

Line: 212

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

Line: 233

       Select guid
       into   l_group_guid
       from   wf_agents
       where  name=l_value;

Line: 238

       Select guid
       into   l_member_guid
       from   wf_agents
       where  name=l_value;