APPS.WF_PROCESS_ACTIVITY SQL Statements

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

Line: 68

  select INSTANCE_ID
  into instid
  from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
  where A.ITEM_TYPE = itemtype
  and A.NAME = 'ROOT'
  and actdate >= A.BEGIN_DATE
  and actdate < NVL(A.END_DATE, actdate+1)
  and PA.PROCESS_NAME = 'ROOT'
  and PA.PROCESS_ITEM_TYPE = itemtype
  and PA.PROCESS_VERSION = A.VERSION
  and PA.INSTANCE_LABEL = process;

Line: 118

    select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
           WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
           WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
           WPA.START_END, WPA.DEFAULT_RESULT
    into   WF_CACHE.ProcessActivities(actid)
    from   WF_PROCESS_ACTIVITIES WPA
    where  WPA.INSTANCE_ID = actid;

Line: 171

  select
  WPA.INSTANCE_ID
  into instid
  from WF_PROCESS_ACTIVITIES WPA
  where WPA.INSTANCE_LABEL = StartInstanceId.label
  and WPA.PROCESS_ITEM_TYPE = StartInstanceId.itemtype
  and WPA.PROCESS_NAME = StartInstanceId.process
  and WPA.PROCESS_VERSION = StartInstanceId.version
  and WPA.START_END = wf_engine.eng_start;

Line: 261

    select WPA.INSTANCE_ID
    into instid
    from WF_PROCESS_ACTIVITIES WPA
    where WPA.INSTANCE_LABEL = activeinstanceid.label
    and WPA.PROCESS_NAME = nvl(activeinstanceid.process, WPA.PROCESS_NAME)
    and WPA.INSTANCE_ID = activeinstanceid.cur_actid;

Line: 269

    select WPA.INSTANCE_ID
    into instid
    from WF_ITEM_ACTIVITY_STATUSES WIAS, WF_PROCESS_ACTIVITIES WPA
    where WIAS.ITEM_TYPE = activeinstanceid.itemtype
    and WIAS.ITEM_KEY = activeinstanceid.itemkey
    and WIAS.ACTIVITY_STATUS = nvl(activeinstanceid.status,
                                   WIAS.ACTIVITY_STATUS)
    and WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
    and WPA.INSTANCE_LABEL = activeinstanceid.label
    and WPA.PROCESS_NAME = nvl(activeinstanceid.process, WPA.PROCESS_NAME);

Line: 323

    select WPA2.INSTANCE_ID, WPA2.ACTIVITY_ITEM_TYPE, WPA2.ACTIVITY_NAME
    from WF_PROCESS_ACTIVITIES WPA1,
         WF_ACTIVITIES WA,
         WF_PROCESS_ACTIVITIES WPA2
    where WPA1.INSTANCE_ID = parentid
    and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
    and WPA2.PROCESS_NAME = WA.NAME
    and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE
    and WA.NAME = WPA1.ACTIVITY_NAME
    and actdate >= WA.BEGIN_DATE
    and actdate < NVL(WA.END_DATE, actdate+1)
    and WPA2.PROCESS_VERSION = WA.VERSION;

Line: 351

    select WA.ITEM_TYPE, WA.NAME, WA.VERSION, WA.TYPE, WA.RERUN,
           WA.EXPAND_ROLE, WA.COST, WA.ERROR_ITEM_TYPE, WA.ERROR_PROCESS,
           WA.FUNCTION, WA.FUNCTION_TYPE,  WA.MESSAGE, WA.BEGIN_DATE,
           WA.END_DATE, WA.DIRECTION, WPA.PROCESS_ITEM_TYPE,
           WPA.PROCESS_NAME, WPA.PROCESS_VERSION, WPA.ACTIVITY_ITEM_TYPE,
           WPA.ACTIVITY_NAME, WPA.INSTANCE_ID, WPA.INSTANCE_LABEL,
           WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE, WPA.START_END,
           WPA.DEFAULT_RESULT

    into   WF_CACHE.Activities(waIND).ITEM_TYPE,
           WF_CACHE.Activities(waIND).NAME,
           WF_CACHE.Activities(waIND).VERSION,
           WF_CACHE.Activities(waIND).TYPE,
           WF_CACHE.Activities(waIND).RERUN,
           WF_CACHE.Activities(waIND).EXPAND_ROLE,
           WF_CACHE.Activities(waIND).COST,
           WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE,
           WF_CACHE.Activities(waIND).ERROR_PROCESS,
           WF_CACHE.Activities(waIND).FUNCTION,
           WF_CACHE.Activities(waIND).FUNCTION_TYPE,
           WF_CACHE.Activities(waIND).MESSAGE,
           WF_CACHE.Activities(waIND).BEGIN_DATE,
           WF_CACHE.Activities(waIND).END_DATE,
           WF_CACHE.Activities(waIND).DIRECTION,
           WF_CACHE.ProcessActivities(rootid).PROCESS_ITEM_TYPE,
           WF_CACHE.ProcessActivities(rootid).PROCESS_NAME,
           WF_CACHE.ProcessActivities(rootid).PROCESS_VERSION,
           WF_CACHE.ProcessActivities(rootid).ACTIVITY_ITEM_TYPE,
           WF_CACHE.ProcessActivities(rootid).ACTIVITY_NAME,
           WF_CACHE.ProcessActivities(rootid).INSTANCE_ID,
           WF_CACHE.ProcessActivities(rootid).INSTANCE_LABEL,
           WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE,
           WF_CACHE.ProcessActivities(rootid).PERFORM_ROLE_TYPE,
           WF_CACHE.ProcessActivities(rootid).START_END,
           WF_CACHE.ProcessActivities(rootid).DEFAULT_RESULT

    from   WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA

    where  WPA.INSTANCE_ID = rootid
    and    WA.ITEM_TYPE = WPA.ACTIVITY_ITEM_TYPE
    and    WA.NAME = WPA.ACTIVITY_NAME
    and    actdate >= WA.BEGIN_DATE
    and    actdate < NVL(WA.END_DATE, actdate+1);

Line: 417

      select WPA.INSTANCE_ID
      into errid
      from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA
      where WPA.PROCESS_ITEM_TYPE = WF_CACHE.Activities(waIND).ERROR_ITEM_TYPE
      and WPA.PROCESS_NAME = 'ROOT'
      and WPA.PROCESS_VERSION = WA.VERSION
      and WA.ITEM_TYPE = WPA.PROCESS_ITEM_TYPE
      and WA.NAME = WPA.PROCESS_NAME
      and actdate >= WA.BEGIN_DATE
      and actdate < NVL(WA.END_DATE, actdate+1)
      and WPA.INSTANCE_LABEL = WF_CACHE.Activities(waIND).ERROR_PROCESS;

Line: 512

    select WPA2.PROCESS_NAME, WPA2.INSTANCE_ID, WPA2.INSTANCE_LABEL
    from WF_PROCESS_ACTIVITIES WPA1,
         WF_ACTIVITIES WA,
         WF_PROCESS_ACTIVITIES WPA2
    where WPA1.INSTANCE_ID = parentid
    and WPA2.PROCESS_ITEM_TYPE = WA.ITEM_TYPE
    and WPA2.PROCESS_NAME = WA.NAME
    and WA.ITEM_TYPE = WPA1.ACTIVITY_ITEM_TYPE
    and WA.NAME = WPA1.ACTIVITY_NAME
    and actdate >= WA.BEGIN_DATE
    and actdate < NVL(WA.END_DATE, actdate+1)
    and WPA2.PROCESS_VERSION = WA.VERSION;

Line: 548

    select WPA.PROCESS_ITEM_TYPE, WPA.PROCESS_NAME, WPA.PROCESS_VERSION,
           WPA.ACTIVITY_ITEM_TYPE, WPA.ACTIVITY_NAME, WPA.INSTANCE_ID,
           WPA.INSTANCE_LABEL, WPA.PERFORM_ROLE, WPA.PERFORM_ROLE_TYPE,
           WPA.START_END, WPA.DEFAULT_RESULT
    into   WF_CACHE.ProcessActivities(parentid)
    from   WF_PROCESS_ACTIVITIES WPA
    where  WPA.INSTANCE_ID = parentid;