eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_MAINTENANCE SQL Statements

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

Line: 32


select ITEM_TYPE, ITEM_KEY
from   WF_ITEMS
where  OWNER_ROLE = l_oldname;

Line: 37


select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
from   WF_ITEM_ACTIVITY_STATUSES
where  ASSIGNED_USER =  l_oldname;

Line: 42


select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
from   WF_ITEM_ACTIVITY_STATUSES_H
where  ASSIGNED_USER =  l_oldname;

Line: 47


select NOTIFICATION_ID
from   WF_NOTIFICATIONS
where  RECIPIENT_ROLE     = l_oldname
or     ORIGINAL_RECIPIENT = l_oldname
or     more_info_role     = l_oldname
or     from_role          = l_oldname
or     responder          = l_oldname;

Line: 56


select PROCESS_ITEM_TYPE, PROCESS_NAME, PROCESS_VERSION,
       INSTANCE_LABEL, INSTANCE_ID
from   WF_PROCESS_ACTIVITIES
where  PERFORM_ROLE = l_oldname;

Line: 62


select RULE_ID
from   WF_ROUTING_RULES
where  ROLE = l_oldname
or     ACTION_ARGUMENT = l_oldname;

Line: 68


select rowid
from   wf_comments
where  from_role = l_oldname
or     to_role = l_oldname
or     proxy_role = l_oldname;

Line: 75


select wiav.rowid
from   wf_item_attribute_values wiav, wf_item_attributes wia
where  wia.type = 'ROLE'
and    wia.item_type = wiav.item_type
and    wia.name = wiav.name
and    wiav.text_value = l_oldname;

Line: 127


 update WF_ITEMS
 set    OWNER_ROLE = l_newname
 where  ITEM_TYPE = i.item_type
 and    item_key = i.item_key;

Line: 137


 update WF_ITEM_ACTIVITY_STATUSES
 set    ASSIGNED_USER = l_newname
 where  ITEM_TYPE = ias.item_type
 and    ITEM_KEY = ias.item_key
 and    PROCESS_ACTIVITY = ias.process_activity;

Line: 148


 update WF_ITEM_ACTIVITY_STATUSES_H
 set    ASSIGNED_USER = l_newname
 where  ITEM_TYPE = iash.item_type
 and    ITEM_KEY = iash.item_key
 and    PROCESS_ACTIVITY = iash.process_activity;

Line: 159


 update WF_NOTIFICATIONS
 set    RECIPIENT_ROLE     = l_newname
 where  NOTIFICATION_ID    = ntf.notification_id
 and    RECIPIENT_ROLE     = l_oldname;

Line: 164


 update WF_NOTIFICATIONS
 set    ORIGINAL_RECIPIENT = l_newname
 where  NOTIFICATION_ID    = ntf.notification_id
 and    ORIGINAL_RECIPIENT = l_oldname;

Line: 169


update WF_NOTIFICATIONS
 set    MORE_INFO_ROLE     = l_newname
 where  NOTIFICATION_ID    = ntf.notification_id
 and    MORE_INFO_ROLE     = l_oldname;

Line: 174


update WF_NOTIFICATIONS
 set    FROM_ROLE          = l_newname
 where  NOTIFICATION_ID    = ntf.notification_id
 and    FROM_ROLE          = l_oldname;

Line: 179


 update WF_NOTIFICATIONS
 set    RESPONDER          = l_newname
 where  NOTIFICATION_ID    = ntf.notification_id
 and    RESPONDER          = l_oldname;

Line: 189


 update WF_PROCESS_ACTIVITIES
 set    PERFORM_ROLE = l_newname
 where  PROCESS_ITEM_TYPE = pact.process_item_type
 and    PROCESS_NAME = pact.process_name
 and    PROCESS_VERSION = pact.process_version
 and    INSTANCE_LABEL = pact.instance_label
 and    INSTANCE_ID = pact.instance_id;

Line: 202


 update WF_ROUTING_RULES
 set    ROLE = l_newname
 where  RULE_ID = rr.rule_id
 and    ROLE = l_oldname;

Line: 207


 update WF_ROUTING_RULES
 set    ACTION_ARGUMENT = l_newname
 where  RULE_ID = rr.rule_id
 and    ACTION_ARGUMENT = l_oldname;

Line: 216


 update WF_COMMENTS
 set    FROM_ROLE = l_newname,
        FROM_USER = l_roleInfoTAB(1).display_name
 where  rowid = wcom.rowid
 and    FROM_ROLE = l_oldName;

Line: 222


 update WF_COMMENTS
 set    TO_ROLE = l_newname,
        TO_USER = l_roleInfoTAB(1).display_name
 where  rowid = wcom.rowid
 and    TO_ROLE = l_oldName;

Line: 228


 update WF_COMMENTS
 set    PROXY_ROLE = l_newname
 where  rowid = wcom.rowid
 and    PROXY_ROLE = l_oldName;

Line: 237


  update WF_ITEM_ATTRIBUTE_VALUES
  set    TEXT_VALUE = l_newname
  where  rowid = rAttr.rowid;

Line: 279


                            p_UpdateWho in BOOLEAN,
                            p_parallel_processes in number) is

  ColumnsMissing      EXCEPTION;

Line: 343


  l_updateDateTAB       dateTAB;

Line: 345


  l_updatedByTAB        numTAB;

Line: 346


  l_updateLoginTAB      numTAB;

Line: 361


    select user_name, role_name, -1, start_date, expiration_date,
           created_by, creation_date, last_updated_by, last_update_date,
           last_update_login, user_start_date, role_start_date,
           user_end_date, role_end_date, partition_id,
           effective_start_date, effective_end_date, user_orig_system,
           user_orig_system_id, role_orig_system, role_orig_system_id,
           parent_orig_system, parent_orig_system_id, owner_tag
    from wf_local_user_roles wur
    where not exists (select null
                      from wf_user_role_assignments wura
                      where wura.user_name = wur.user_name
                      and wura.role_name = wur.role_name);

Line: 376


    select wu.rowid, wu.orig_system old_orig_system,
           wu.orig_system_id old_orig_system_id,
           decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER') new_orig_system,
           nvl(fu.employee_id, fu.user_id)
    from   wf_local_roles partition (FND_USR) wu, fnd_user fu
    where  wu.name = fu.user_name
    and    (wu.orig_system <> decode(nvl(fu.employee_id, -1),-1,'FND_USR','PER')
      or    wu.orig_system_id <> nvl(fu.employee_id, fu.user_id));

Line: 388


   select wu.orig_system, wu.orig_system_id,
          wur.role_orig_system, wur.role_orig_system_id,
          wur.partition_id, wur.rowid
   from   wf_local_user_roles wur,
          wf_local_roles partition (FND_USR) wu
   where  wu.name = wur.user_name
   and    wur.user_orig_system in ('FND_USR','PER')
   and    (wur.user_orig_system <> wu.orig_system
    or     wur.user_orig_system_id <> wu.orig_system_id
   --check for role_orig_system in case of self-reference
    or (wur.partition_id=1 and  (wur.role_orig_system <> wu.orig_system
    or     wur.role_orig_system_id <> wu.orig_system_id)));

Line: 406


    select wura.rowid, wur.rowid, wu.start_date, wu.expiration_date,
           wu.orig_system, wu.orig_system_id
    from   wf_local_user_roles partition (FND_USR) wur,
           wf_local_roles partition (FND_USR) wu,
           wf_user_role_assignments partition (FND_USR)  wura
    --Equi-joins to select the proper relationships between the tables
    where  wura.partition_id = wu.partition_id
    and    wura.partition_id = wu.partition_id
    and    wur.user_name = wu.name
    and    wur.role_name = wu.name
    and    wura.assigning_role = wu.name
    and    wura.user_name = wu.name
    and    wura.role_name = wu.name
    --Criteria to select records that need to be corrected, beginning with
    --broad checks (if effective dates are null, no reason to check further)
    --and working down to more specific checks between the orig_system/id
    and    ((wur.effective_start_date is null or
             wur.effective_end_date is null or
             wura.effective_start_date is null or
             wura.effective_end_date is null)
      or    ((wur.user_orig_system <> wu.orig_system) or
             (wur.user_orig_system_id <> wu.orig_system_id) or
             (wur.role_orig_system <> wu.orig_system) or
             (wur.role_orig_system_id <> wu.orig_system_id))
      or    (wura.user_orig_system is null or wura.role_orig_system is null or
             wura.user_orig_system_id is null or
             wura.user_orig_system_id is null)
      or    (wura.user_orig_system <> wu.orig_system)
      or    (wura.user_orig_system_id <> wu.orig_system_id)
      or    (wura.role_orig_system <> wu.orig_system)
      or    (wura.role_orig_system_id <> wu.orig_system_id)
      or    (wu.start_date is null and
              (wur.start_date is not null or
               wur.user_start_date is not null or
               wur.role_start_date is not null or
               wur.effective_start_date <> to_date(1,'J')))
      or    (wu.start_date is not null and
              (wur.start_date is null or wur.user_start_date is null or
               wur.role_start_date is null or wur.start_date <> wu.start_date or
               wur.user_start_date <> wu.start_date or
               wur.role_start_date <> wu.start_date or
               wur.effective_start_date <> wu.start_date))
      or    (wu.expiration_date is null and
              (wur.expiration_date is not null or
               wur.user_end_date is not null or wur.role_end_date is not null or
               wur.effective_end_date <> to_date('9999/01/01','YYYY/MM/DD')))
      or    (wu.expiration_date is not null and
              (wur.expiration_date is null or wur.user_end_date is null or
               wur.role_end_date is null or
               wur.expiration_date <> wu.expiration_date or
               wur.user_end_date <> wu.expiration_date or
               wur.role_end_date <> wu.expiration_date or
               wur.effective_end_date <> wu.expiration_date)));

Line: 464


      select rowid, wura_id,wur_id,role_name,user_name,
      assigning_role, start_date, end_Date,role_start_date,
      role_end_date, user_start_date,user_end_date,
      role_orig_system,role_orig_system_id,
      user_orig_system, user_orig_system_id,
      assigning_role_start_date, assigning_role_end_date,
      effective_start_date, effective_end_date,
      relationship_id
      from wf_ur_validate_stg
      order by  ROLE_NAME, USER_NAME;

Line: 476


    select rowid
    from   wf_local_user_roles
    where  user_name not in (select name from wf_local_roles)
    or     role_name not in (select name from wf_local_roles);

Line: 482


    select rowid
    from   wf_user_role_assignments
    where  user_name not in (select name from wf_local_roles)
    or     role_name not in (select name from wf_local_roles);

Line: 523


          DELETE from WF_LOCAL_USER_ROLES
          WHERE  rowid = l_rowIDTAB(i);

Line: 540


  l_rowIDTAB.DELETE;

Line: 550


          DELETE from WF_USER_ROLE_ASSIGNMENTS
          WHERE  rowid = l_rowIDTAB(i);

Line: 567


  l_rowIDTAB.DELETE;

Line: 576


        l_userSrcTAB.DELETE;

Line: 580


            l_createdByTAB, l_createDateTAB, l_updatedByTAB, l_updateDateTAB,
            l_updateLoginTAB, l_userStartSrcTAB, l_roleStartSrcTAB,
            l_userEndSrcTAB, l_roleEndSrcTAB, l_partTAB, l_effStartSrcTAB,
            l_effEndSrcTAB, l_userOrigSrcTAB, l_userOrigIDSrcTAB,
            l_roleOrigSrcTAB, l_roleOrigIDSrcTAB, l_parentOrigTAB,
            l_parentOrigIDTAB, l_ownerTAGS
            limit l_maxRows;

Line: 592


              insert into WF_USER_ROLE_ASSIGNMENTS (USER_NAME,
                ROLE_NAME, RELATIONSHIP_ID, ASSIGNING_ROLE, START_DATE,
                END_DATE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,
                LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, USER_START_DATE,
                ROLE_START_DATE, ASSIGNING_ROLE_START_DATE, USER_END_DATE,
                ROLE_END_DATE, ASSIGNING_ROLE_END_DATE, PARTITION_ID,
                EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, USER_ORIG_SYSTEM,
                USER_ORIG_SYSTEM_ID, ROLE_ORIG_SYSTEM, ROLE_ORIG_SYSTEM_ID,
                PARENT_ORIG_SYSTEM, PARENT_ORIG_SYSTEM_ID, OWNER_TAG)
                values (l_userSrcTAB(i), l_roleSrcTAB(i), l_relIDTAB(i),
                 l_roleSrcTAB(i), l_startSrcTAB(i), l_endSrcTAB(i),
                 l_createdByTAB(i), l_createDateTAB(i), l_updatedByTAB(i),
                 l_updateDateTAB(i), l_updateLoginTAB(i), l_userStartSrcTAB(i),
                 l_roleStartSrcTAB(i), l_roleStartSrcTAB(i), l_userEndSrcTAB(i),
                 l_roleEndSrcTAB(i), l_roleEndSrcTAB(i), l_partTAB(i),
                 l_effStartSrcTAB(i), l_effEndSrcTAB(i), l_userOrigSrcTAB(i),
                 l_userOrigIDSrcTAB(i), l_roleOrigSrcTAB(i),
                 l_roleOrigIDSrcTAB(i), l_parentOrigTAB(i),
                 l_parentOrigIDTAB(i), l_ownerTAGS(i));

Line: 648


      l_rowIDTAB.DELETE;

Line: 658


            UPDATE WF_LOCAL_ROLES
            SET    orig_system = l_userOrigDestTAB(i),
                   orig_system_id = l_userOrigIDDestTAB(i)
            WHERE  rowid = l_rowIDTAB(i);

Line: 666


              delete from wf_local_roles
              where  rowid = l_rowIDTAB(l_eIndex);

Line: 693


      l_rowIDTAB.DELETE;

Line: 714


            UPDATE WF_LOCAL_USER_ROLES
            SET    user_orig_system = l_userOrigSrcTAB(i),
                   user_orig_system_id = l_userOrigIDSrcTAB(i),
                   role_orig_system = l_roleOrigSrcTAB(i),
                   role_orig_system_id = l_roleOrigIDSrcTAB(i)
            WHERE  rowid = l_rowIDTAB(i);

Line: 725


               delete from wf_local_user_roles
               where  rowid = l_rowIDTAB(l_eIndex);

Line: 773


     if (p_UpdateWho is not null and p_UpdateWho) then
      forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST save exceptions
        update  WF_USER_ROLE_ASSIGNMENTS
        set     ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_START_DATE = l_StartSrcTAB(tabIndex),
                USER_END_DATE = l_EndSrcTAB(tabIndex),
                START_DATE    = l_StartSrcTAB(tabIndex),
                END_DATE      = l_EndSrcTAB(tabIndex),
                EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
                                           to_date(1,'J')),
                EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
                                         to_date('9999/01/01', 'YYYY/MM/DD')),
                ASSIGNING_ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ASSIGNING_ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
                ROLE_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
                USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
                ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
                LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                LAST_UPDATE_DATE = SYSDATE,
                LAST_UPDATE_LOGIN  = FND_GLOBAL.LOGIN_ID
        where   rowid = l_rowIDTAB(tabIndex);

Line: 798


        update  WF_USER_ROLE_ASSIGNMENTS
        set     ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_START_DATE = l_StartSrcTAB(tabIndex),
                USER_END_DATE = l_EndSrcTAB(tabIndex),
                START_DATE    = l_StartSrcTAB(tabIndex),
                END_DATE      = l_EndSrcTAB(tabIndex),
                EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
                                           to_date(1,'J')),
                EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
                                         to_date('9999/01/01', 'YYYY/MM/DD')),
                ASSIGNING_ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ASSIGNING_ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
                ROLE_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
                USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
                ROLE_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex)
        where   rowid = l_rowIDTAB(tabIndex);

Line: 823


             delete from wf_user_role_assignments
             where rowid = l_rowIDTAB(l_eIndex);

Line: 836


      if (p_UpdateWho is not null and p_UpdateWho) then
       forall tabIndex in l_rowIDSrcTAB.FIRST..l_rowIDSrcTAB.LAST save exceptions
        update wf_local_user_roles partition (FND_USR)
        set     ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_START_DATE = l_StartSrcTAB(tabIndex),
                USER_END_DATE = l_EndSrcTAB(tabIndex),
                START_DATE    = l_StartSrcTAB(tabIndex),
                EXPIRATION_DATE  = l_EndSrcTAB(tabIndex),
                EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
                                           to_date(1,'J')),
                EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
                                         to_date('9999/01/01', 'YYYY/MM/DD')),
                LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                LAST_UPDATE_DATE = SYSDATE,
                LAST_UPDATE_LOGIN  = FND_GLOBAL.LOGIN_ID
         where  rowid = l_rowIDSrcTAB(tabIndex);

Line: 855


        update wf_local_user_roles partition (FND_USR)
        set     ROLE_START_DATE = l_StartSrcTAB(tabIndex),
                ROLE_END_DATE = l_EndSrcTAB(tabIndex),
                USER_START_DATE = l_StartSrcTAB(tabIndex),
                USER_END_DATE = l_EndSrcTAB(tabIndex),
                START_DATE    = l_StartSrcTAB(tabIndex),
                EXPIRATION_DATE  = l_EndSrcTAB(tabIndex),
                EFFECTIVE_START_DATE = nvl(l_StartSrcTAB(tabIndex),
                                           to_date(1,'J')),
                EFFECTIVE_END_DATE = nvl(l_EndSrcTAB(tabIndex),
                                         to_date('9999/01/01', 'YYYY/MM/DD'))
         where  rowid = l_rowIDSrcTAB(tabIndex);

Line: 875


      l_rowIDTAB.DELETE;

Line: 890


  l_rowIDTAB.delete;

Line: 891


  l_rowIDSrcTAB.delete;

Line: 892


  l_startSrcTAB.delete;

Line: 893


  l_endSrcTAB.delete;

Line: 894


  l_userOrigSrcTAB.delete;

Line: 895


  l_userOrigIDSrcTAB.delete;

Line: 908


  select min(to_number(value))
  into   l_defaultParProc
  from   v$parameter
  where  name in ('parallel_max_servers','cpu_count');

Line: 925


  'INSERT /*+ append parallel(WF_UR_VALIDATE_STG,'|| l_parallelProc ||') */
  INTO WF_UR_VALIDATE_STG (WURA_ID, WUR_ID , ROLE_NAME , USER_NAME ,
  ASSIGNING_ROLE , START_DATE , END_DATE , ROLE_START_DATE, ROLE_END_DATE
  , USER_START_DATE , USER_END_DATE , ROLE_ORIG_SYSTEM ,
  ROLE_ORIG_SYSTEM_ID , USER_ORIG_SYSTEM , USER_ORIG_SYSTEM_ID ,
  ASSIGNING_ROLE_START_DATE , ASSIGNING_ROLE_END_DATE ,
  EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , RELATIONSHIP_ID )
  SELECT /*+ ordered parallel(WURA,'|| l_parallelProc ||') parallel(WR,'|| l_parallelProc ||
          ') parallel (wu,'|| l_parallelProc ||')
             parallel (WAR,'|| l_parallelProc ||') parallel(WUR,'|| l_parallelProc ||') */
         WURA.ROWID, WUR.ROWID, WURA.ROLE_NAME, WURA.USER_NAME,
         WURA.ASSIGNING_ROLE,
         DECODE(WURA.USER_NAME, WURA.ROLE_NAME, WU.START_DATE,
                WURA.START_DATE) START_DATE,
         DECODE(WURA.USER_NAME, WURA.ROLE_NAME, WU.EXPIRATION_DATE,
                WURA.END_DATE) END_DATE,
         WR.START_DATE, WR.EXPIRATION_DATE, WU.START_DATE,
         WU.EXPIRATION_DATE, WR.ORIG_SYSTEM, WR.ORIG_SYSTEM_ID,
         WU.ORIG_SYSTEM, WU.ORIG_SYSTEM_ID, WAR.START_DATE,
         WAR.EXPIRATION_DATE,
         GREATEST(NVL(WURA.START_DATE, TO_DATE(1,''J'')),
                  NVL(WURA.USER_START_DATE, TO_DATE(1,''J'')),
                  NVL(WURA.ROLE_START_DATE, TO_DATE(1,''J'')),
                  NVL(WURA.ASSIGNING_ROLE_START_DATE,
                      TO_DATE(1,''J''))) EFFECTIVE_START_DATE,
         LEAST(NVL(WURA.END_DATE, TO_DATE(''9999/01/01'', ''YYYY/MM/DD'')),
               NVL(WURA.USER_END_DATE, TO_DATE(''9999/01/01'', ''YYYY/MM/DD'')),
               NVL(WURA.ROLE_END_DATE, TO_DATE(''9999/01/01'', ''YYYY/MM/DD'')),
               NVL(WURA.ASSIGNING_ROLE_END_DATE,
                   TO_DATE(''9999/01/01'', ''YYYY/MM/DD''))) EFFECTIVE_END_DATE,
         WURA.RELATIONSHIP_ID
    FROM
         WF_USER_ROLE_ASSIGNMENTS WURA,
         WF_LOCAL_USER_ROLES WUR ,
         WF_LOCAL_ROLES WAR,
         WF_LOCAL_ROLES WU,
         WF_LOCAL_ROLES WR
   WHERE WURA.PARTITION_ID = WAR.PARTITION_ID
     AND WURA.ASSIGNING_ROLE=WAR.NAME
     AND WURA.USER_NAME= WUR.USER_NAME
     AND WURA.ROLE_NAME=WUR.ROLE_NAME
     AND WUR.USER_NAME = WU.NAME
     AND WUR.USER_ORIG_SYSTEM=WU.ORIG_SYSTEM
     AND WUR.USER_ORIG_SYSTEM_ID= WU.ORIG_SYSTEM_ID
     AND WUR.ROLE_NAME = WR.NAME
     AND WUR.ROLE_ORIG_SYSTEM= WR.ORIG_SYSTEM
     AND WUR.ROLE_ORIG_SYSTEM_ID= WR.ORIG_SYSTEM_ID
     AND WUR.PARTITION_ID = WR.PARTITION_ID
     AND WUR.PARTITION_ID <> 1
     AND WAR.PARTITION_ID <> 1
     AND ( ( WUR.EFFECTIVE_START_DATE IS NULL or
             WUR.EFFECTIVE_END_DATE IS NULL or
             WURA.EFFECTIVE_START_DATE IS NULL or
             WURA.EFFECTIVE_END_DATE IS NULL )
      OR ( WURA.EFFECTIVE_START_DATE <> GREATEST(NVL(WURA.START_DATE,
         TO_DATE(1,''J'')), NVL(WURA.USER_START_DATE, TO_DATE(1,''J'')), NVL(
         WURA.ROLE_START_DATE, TO_DATE(1,''J'')), NVL(
         WURA.ASSIGNING_ROLE_START_DATE, TO_DATE(1,''J''))) )
      OR ( WURA.EFFECTIVE_END_DATE <> LEAST(NVL(WURA.END_DATE, TO_DATE(
         ''9999/01/01'', ''YYYY/MM/DD'')), NVL(WURA.USER_END_DATE, TO_DATE(
         ''9999/01/01'', ''YYYY/MM/DD'')) , NVL(WURA.ROLE_END_DATE, TO_DATE(
         ''9999/01/01'', ''YYYY/MM/DD'')), NVL(WURA.ASSIGNING_ROLE_END_DATE,
         TO_DATE(''9999/01/01'', ''YYYY/MM/DD''))))
      OR (WURA.USER_NAME = WURA.ROLE_NAME and
          (nvl(wura.start_date, to_date(1,''J'')) <>
           nvl(wu.start_date, to_date(1,''J'')) or
           nvl(wura.end_date, to_date(''9999/01/01'', ''YYYY/MM/DD'')) <>
           nvl(wu.expiration_date, to_date(''9999/01/01'', ''YYYY/MM/DD''))))
      OR ( ( WUR.ASSIGNMENT_TYPE IS NULL )
      OR WUR.ASSIGNMENT_TYPE NOT IN (''D'', ''I'', ''B'') )
      OR ( WURA.USER_ORIG_SYSTEM IS NULL
      OR WURA.ROLE_ORIG_SYSTEM IS NULL
      OR WURA.USER_ORIG_SYSTEM_ID IS NULL
      OR WURA.ROLE_ORIG_SYSTEM_ID IS NULL )
      OR ( WURA.USER_ORIG_SYSTEM <> WU.ORIG_SYSTEM
      OR WURA.USER_ORIG_SYSTEM_ID <> WU.ORIG_SYSTEM_ID
      OR WURA.ROLE_ORIG_SYSTEM <> WR.ORIG_SYSTEM
      OR WURA.ROLE_ORIG_SYSTEM_ID <> WR.ORIG_SYSTEM_ID )
      OR ( ( WU.START_DATE IS NULL
     AND ( WUR.USER_START_DATE IS NOT NULL
      OR WURA.USER_START_DATE IS NOT NULL ) )
      OR ( WU.START_DATE IS NOT NULL
     AND ( WUR.USER_START_DATE IS NULL
      OR WUR.USER_START_DATE <> WU.START_DATE
      OR WURA.USER_START_DATE IS NULL
      OR WURA.USER_START_DATE <> WU.START_DATE ) )
      OR ( WU.EXPIRATION_DATE IS NULL
     AND ( WUR.USER_END_DATE IS NOT NULL
      OR WURA.USER_END_DATE IS NOT NULL ) )
      OR ( WU.EXPIRATION_DATE IS NOT NULL
     AND ( WUR.USER_END_DATE IS NULL
      OR WUR.USER_END_DATE <> WU.EXPIRATION_DATE
      OR WURA.USER_END_DATE IS NULL
      OR WURA.USER_END_DATE <> WU.EXPIRATION_DATE ) ) )
      OR ( ( WR.START_DATE IS NULL
     AND ( WUR.ROLE_START_DATE IS NOT NULL
      OR WURA.ROLE_START_DATE IS NOT NULL ) )
      OR ( WR.START_DATE IS NOT NULL
     AND ( WUR.ROLE_START_DATE IS NULL
      OR WUR.ROLE_START_DATE <> WR.START_DATE
      OR WURA.ROLE_START_DATE IS NULL
      OR WURA.ROLE_START_DATE <> WR.START_DATE ) )
      OR ( WR.EXPIRATION_DATE IS NULL
     AND ( WUR.ROLE_END_DATE IS NOT NULL
      OR WURA.ROLE_END_DATE IS NOT NULL ) )
      OR ( WR.EXPIRATION_DATE IS NOT NULL
     AND ( WUR.ROLE_END_DATE IS NULL
      OR WUR.ROLE_END_DATE <> WR.EXPIRATION_DATE
      OR WURA.ROLE_END_DATE IS NULL
      OR WURA.ROLE_END_DATE <> WR.EXPIRATION_DATE ) ) )
      OR ( ( WAR.START_DATE IS NULL
     AND WURA.ASSIGNING_ROLE_START_DATE IS NOT NULL )
      OR ( WAR.START_DATE IS NOT NULL
     AND ( WURA.ASSIGNING_ROLE_START_DATE IS NULL
      OR WURA.ASSIGNING_ROLE_START_DATE <> WAR.START_DATE ) )
      OR ( WAR.EXPIRATION_DATE IS NULL
     AND WURA.ASSIGNING_ROLE_END_DATE IS NOT NULL )
      OR ( WAR.EXPIRATION_DATE IS NOT NULL
     AND ( WURA.ASSIGNING_ROLE_END_DATE IS NULL
      OR WURA.ASSIGNING_ROLE_END_DATE <> WAR.EXPIRATION_DATE ) ) ) )' ;

Line: 1073


    if (p_UpdateWho is not null and p_UpdateWho) then
     forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
      update  WF_USER_ROLE_ASSIGNMENTS
      set     ROLE_START_DATE = l_roleStartSrcTAB(tabIndex),
              ROLE_END_DATE = l_roleEndSrcTAB(tabIndex),
              USER_START_DATE = l_userStartSrcTAB(tabIndex),
              USER_END_DATE = l_userEndSrcTAB(tabIndex),
              START_DATE = l_startSrcTAB(tabIndex),
              END_DATE = l_endSRcTAB(tabIndex),
              EFFECTIVE_START_DATE = l_effStartSrcTAB(tabIndex),
              EFFECTIVE_END_DATE = l_effEndSrcTAB(tabIndex),
              ASSIGNING_ROLE_START_DATE = l_asgStartSrcTAB(tabIndex),
              ASSIGNING_ROLE_END_DATE = l_asgEndSrcTAB(tabIndex),
              USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
              ROLE_ORIG_SYSTEM=l_roleOrigSrcTAB(tabIndex),
              USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
              ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex),
              LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
              LAST_UPDATE_DATE = SYSDATE,
              LAST_UPDATE_LOGIN  = FND_GLOBAL.LOGIN_ID
      where   rowid = l_rowIDTAB(tabIndex);

Line: 1096


      update  WF_USER_ROLE_ASSIGNMENTS
      set     ROLE_START_DATE = l_roleStartSrcTAB(tabIndex),
              ROLE_END_DATE = l_roleEndSrcTAB(tabIndex),
              USER_START_DATE = l_userStartSrcTAB(tabIndex),
              USER_END_DATE = l_userEndSrcTAB(tabIndex),
              START_DATE = l_startSrcTAB(tabIndex),
              END_DATE = l_endSRcTAB(tabIndex),
              EFFECTIVE_START_DATE = l_effStartSrcTAB(tabIndex),
              EFFECTIVE_END_DATE = l_effEndSrcTAB(tabIndex),
              ASSIGNING_ROLE_START_DATE = l_asgStartSrcTAB(tabIndex),
              ASSIGNING_ROLE_END_DATE = l_asgEndSrcTAB(tabIndex),
              USER_ORIG_SYSTEM=l_userOrigSrcTAB(tabIndex),
              ROLE_ORIG_SYSTEM=l_roleOrigSrcTAB(tabIndex),
              USER_ORIG_SYSTEM_ID=l_userOrigIDSrcTAB(tabIndex),
              ROLE_ORIG_SYSTEM_ID=l_roleOrigIDSrcTAB(tabIndex)
      where   rowid = l_rowIDTAB(tabIndex);

Line: 1134


         if (p_UpdateWho is not null and p_UpdateWho) then
           forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
            UPDATE WF_LOCAL_USER_ROLES wur
            SET    ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
                   ROLE_END_DATE   = l_roleEndDestTAB(destTabIndex),
                   USER_START_DATE = l_userStartDestTAB(destTabIndex),
                   USER_END_DATE = l_userEndDestTAB(destTabIndex),
                   START_DATE = l_startDestTAB(destTabIndex),
                   EXPIRATION_DATE = l_endDestTAB(destTabIndex),
                   EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
                   EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
                   ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
                   LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
                   LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
                   LAST_UPDATE_DATE  = SYSDATE
             WHERE rowid = l_rowIDDestTAB(destTabIndex);

Line: 1152


            UPDATE WF_LOCAL_USER_ROLES wur
            SET    ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
                   ROLE_END_DATE   = l_roleEndDestTAB(destTabIndex),
                   USER_START_DATE = l_userStartDestTAB(destTabIndex),
                   USER_END_DATE = l_userEndDestTAB(destTabIndex),
                   START_DATE = l_startDestTAB(destTabIndex),
                   EXPIRATION_DATE = l_endDestTAB(destTabIndex),
                   EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
                   EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
                   ASSIGNMENT_TYPE = l_assignTAB(destTabIndex)
             WHERE rowid = l_rowIDDestTAB(destTabIndex);

Line: 1164


          l_roleStartDestTAB.DELETE;

Line: 1165


          l_roleEndDestTAB.DELETE;

Line: 1166


          l_userStartDestTAB.DELETE;

Line: 1167


          l_userEndDestTAB.DELETE;

Line: 1168


          l_effStartDestTAB.DELETE;

Line: 1169


          l_effEndDestTAB.DELETE;

Line: 1170


          l_assignTAB.DELETE;

Line: 1171


          l_startDestTAB.DELETE;

Line: 1172


          l_endDestTAB.DELETE;

Line: 1173


          l_roleDestTAB.DELETE;

Line: 1174


          l_userDestTAB.DELETE;

Line: 1175


          l_userOrigDestTAB.DELETE;

Line: 1176


          l_userOrigIDDestTAB.DELETE;

Line: 1177


          l_roleOrigDestTAB.DELETE;

Line: 1178


          l_roleOrigIDDestTAB.DELETE;

Line: 1179


          l_rowIDDestTAB.DELETE;

Line: 1218


      else  --Record is already in the summary table so update effective dates
      if l_effStartSrcTAB(tabIndex) < l_effStartDestTAB(sumTabIndex) then
        l_effStartDestTAB(sumTabIndex) := l_effStartSrcTAB(tabIndex);

Line: 1296


      l_rowIDTAB.DELETE;

Line: 1305


   if (p_UpdateWho is not null and p_UpdateWho) then
    forall destTabIndex in l_roleDestTab.FIRST..l_roleDestTab.LAST
      UPDATE WF_LOCAL_USER_ROLES wur
      SET    ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
             ROLE_END_DATE   = l_roleEndDestTAB(destTabIndex),
             USER_START_DATE = l_userStartDestTAB(destTabIndex),
             USER_END_DATE = l_userEndDestTAB(destTabIndex),
             EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
             EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
             START_DATE = l_startDestTAB(destTabIndex),
             EXPIRATION_DATE = l_endDestTAB(destTabIndex),
             ASSIGNMENT_TYPE = l_assignTAB(destTabIndex),
             LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
             LAST_UPDATE_LOGIN = FND_GLOBAL.Login_Id,
             LAST_UPDATE_DATE  = SYSDATE
       WHERE rowid = l_rowIDDestTAB(destTabIndex);

Line: 1323


      UPDATE WF_LOCAL_USER_ROLES wur
      SET    ROLE_START_DATE = l_roleStartDestTAB(destTabIndex),
             ROLE_END_DATE   = l_roleEndDestTAB(destTabIndex),
             USER_START_DATE = l_userStartDestTAB(destTabIndex),
             USER_END_DATE = l_userEndDestTAB(destTabIndex),
             EFFECTIVE_START_DATE = l_effStartDestTAB(destTabIndex),
             EFFECTIVE_END_DATE = l_effEndDestTAB(destTabIndex),
             START_DATE = l_startDestTAB(destTabIndex),
             EXPIRATION_DATE = l_endDestTAB(destTabIndex),
             ASSIGNMENT_TYPE = l_assignTAB(destTabIndex)
       WHERE rowid = l_rowIDDestTAB(destTabIndex);