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_ROLE_HIERARCHY dependencies on WFA_SEC

Line 46: WF_EVENT.AddParameterToList('USER_ID', WFA_SEC.USER_ID, l_params);

42:
43: WF_EVENT.AddParameterToList('RELATIONSHIP_ID', p_relationshipID, l_params);
44: WF_EVENT.AddParameterToList('SUPER_NAME', p_superName, l_params);
45: WF_EVENT.AddParameterToList('SUB_NAME', p_subName, l_params);
46: WF_EVENT.AddParameterToList('USER_ID', WFA_SEC.USER_ID, l_params);
47: WF_EVENT.AddParameterToList('LOGIN_ID', WFA_SEC.LOGIN_ID, l_params);
48: WF_EVENT.AddParameterToList('SECURITY_GROUP_ID',
49: WFA_SEC.SECURITY_GROUP_ID, l_params);
50:

Line 47: WF_EVENT.AddParameterToList('LOGIN_ID', WFA_SEC.LOGIN_ID, l_params);

43: WF_EVENT.AddParameterToList('RELATIONSHIP_ID', p_relationshipID, l_params);
44: WF_EVENT.AddParameterToList('SUPER_NAME', p_superName, l_params);
45: WF_EVENT.AddParameterToList('SUB_NAME', p_subName, l_params);
46: WF_EVENT.AddParameterToList('USER_ID', WFA_SEC.USER_ID, l_params);
47: WF_EVENT.AddParameterToList('LOGIN_ID', WFA_SEC.LOGIN_ID, l_params);
48: WF_EVENT.AddParameterToList('SECURITY_GROUP_ID',
49: WFA_SEC.SECURITY_GROUP_ID, l_params);
50:
51: if (p_defer) then

Line 49: WFA_SEC.SECURITY_GROUP_ID, l_params);

45: WF_EVENT.AddParameterToList('SUB_NAME', p_subName, l_params);
46: WF_EVENT.AddParameterToList('USER_ID', WFA_SEC.USER_ID, l_params);
47: WF_EVENT.AddParameterToList('LOGIN_ID', WFA_SEC.LOGIN_ID, l_params);
48: WF_EVENT.AddParameterToList('SECURITY_GROUP_ID',
49: WFA_SEC.SECURITY_GROUP_ID, l_params);
50:
51: if (p_defer) then
52: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'TRUE', l_params);
53: else

Line 401: l_CreatedBy NUMBER := WFA_SEC.USER_ID;

397: l_SupStartDate DATE;
398: l_SupEndDate DATE;
399: l_EffStartDate DATE;
400: l_EffEndDate DATE;
401: l_CreatedBy NUMBER := WFA_SEC.USER_ID;
402: l_CreationDate DATE;
403: l_LastUpdatedBy NUMBER := WFA_SEC.USER_ID;
404: l_LastUpdateDate DATE;
405: l_LastUpdateLogin NUMBER := WFA_SEC.LOGIN_ID;

Line 403: l_LastUpdatedBy NUMBER := WFA_SEC.USER_ID;

399: l_EffStartDate DATE;
400: l_EffEndDate DATE;
401: l_CreatedBy NUMBER := WFA_SEC.USER_ID;
402: l_CreationDate DATE;
403: l_LastUpdatedBy NUMBER := WFA_SEC.USER_ID;
404: l_LastUpdateDate DATE;
405: l_LastUpdateLogin NUMBER := WFA_SEC.LOGIN_ID;
406: l_RoleOrigSystem VARCHAR2(30);
407: l_RoleOrigSystemID NUMBER;

Line 405: l_LastUpdateLogin NUMBER := WFA_SEC.LOGIN_ID;

401: l_CreatedBy NUMBER := WFA_SEC.USER_ID;
402: l_CreationDate DATE;
403: l_LastUpdatedBy NUMBER := WFA_SEC.USER_ID;
404: l_LastUpdateDate DATE;
405: l_LastUpdateLogin NUMBER := WFA_SEC.LOGIN_ID;
406: l_RoleOrigSystem VARCHAR2(30);
407: l_RoleOrigSystemID NUMBER;
408: l_UserOrigSystem VARCHAR2(30);
409: l_UserOrigSystemID NUMBER;

Line 594: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),

590: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
591: update WF_USER_ROLE_ASSIGNMENTS
592: set START_DATE = l_StartDate,
593: END_DATE = l_EndDate,
594: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
595: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
596: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
597: CREATION_DATE = nvl(l_CreationDate,CREATION_DATE),
598: CREATED_BY = nvl(l_CreatedBy, CREATED_BY),

Line 596: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

592: set START_DATE = l_StartDate,
593: END_DATE = l_EndDate,
594: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
595: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
596: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
597: CREATION_DATE = nvl(l_CreationDate,CREATION_DATE),
598: CREATED_BY = nvl(l_CreatedBy, CREATED_BY),
599: EFFECTIVE_START_DATE = l_effStartTAB(tabIndex),
600: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)

Line 607: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),

603: forall tabIndex in l_rowIDTAB.FIRST..l_rowIDTAB.LAST
604: update WF_USER_ROLE_ASSIGNMENTS
605: set START_DATE = l_StartDate,
606: END_DATE = l_EndDate,
607: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
608: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
609: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
610: EFFECTIVE_START_DATE = l_effStartTAB(tabIndex),
611: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)

Line 609: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

605: set START_DATE = l_StartDate,
606: END_DATE = l_EndDate,
607: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
608: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
609: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
610: EFFECTIVE_START_DATE = l_effStartTAB(tabIndex),
611: EFFECTIVE_END_DATE = l_effEndTAB(tabIndex)
612: where rowid = l_rowIDTAB(tabIndex);
613: else -- Donot update WHO columns

Line 656: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),

652: ASSIGNING_ROLE_END_DATE = l_EndDate,
653: EFFECTIVE_END_DATE = l_effEndDate,
654: CREATION_DATE = nvl(l_CreationDate, SYSDATE),
655: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
656: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
657: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
658: where USER_NAME = l_UserName
659: and ROLE_NAME = USER_NAME
660: and RELATIONSHIP_ID = -1;

Line 657: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)

653: EFFECTIVE_END_DATE = l_effEndDate,
654: CREATION_DATE = nvl(l_CreationDate, SYSDATE),
655: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
656: LAST_UPDATED_BY = nvl(l_LastUpdatedBy,WFA_SEC.USER_ID),
657: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
658: where USER_NAME = l_UserName
659: and ROLE_NAME = USER_NAME
660: and RELATIONSHIP_ID = -1;
661: end if;

Line 727: nvl(l_CreatedBy,WFA_SEC.User_ID),

723: l_UserStartDate,
724: l_UserEndDate,
725: l_RoleStartDate,
726: l_RoleEndDate,
727: nvl(l_CreatedBy,WFA_SEC.User_ID),
728: nvl(l_CreationDate,SYSDATE),
729: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
730: nvl(l_LastUpdateDate,SYSDATE),
731: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

Line 729: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),

725: l_RoleStartDate,
726: l_RoleEndDate,
727: nvl(l_CreatedBy,WFA_SEC.User_ID),
728: nvl(l_CreationDate,SYSDATE),
729: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
730: nvl(l_LastUpdateDate,SYSDATE),
731: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
732: l_partitionID,
733: l_effStartDate,

Line 731: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

727: nvl(l_CreatedBy,WFA_SEC.User_ID),
728: nvl(l_CreationDate,SYSDATE),
729: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
730: nvl(l_LastUpdateDate,SYSDATE),
731: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
732: l_partitionID,
733: l_effStartDate,
734: l_effEndDate,
735: l_UserOrigSystem,

Line 850: nvl(l_CreatedBy,WFA_SEC.User_ID),

846: l_SupStartDate,
847: l_SupEndDate,
848: l_RoleStartDate,
849: l_RoleEndDate,
850: nvl(l_CreatedBy,WFA_SEC.User_ID),
851: nvl(l_CreationDate,SYSDATE),
852: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
853: nvl(l_LastUpdateDate,SYSDATE),
854: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

Line 852: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),

848: l_RoleStartDate,
849: l_RoleEndDate,
850: nvl(l_CreatedBy,WFA_SEC.User_ID),
851: nvl(l_CreationDate,SYSDATE),
852: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
853: nvl(l_LastUpdateDate,SYSDATE),
854: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
855: l_partitionID,
856: l_EffStartDate,

Line 854: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

850: nvl(l_CreatedBy,WFA_SEC.User_ID),
851: nvl(l_CreationDate,SYSDATE),
852: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
853: nvl(l_LastUpdateDate,SYSDATE),
854: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
855: l_partitionID,
856: l_EffStartDate,
857: l_EffEndDate,
858: l_UserOrigSystem,

Line 879: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),

875: ASSIGNING_ROLE_START_DATE = l_RoleStartDate,
876: ASSIGNING_ROLE_END_DATE = l_RoleEndDate,
877: EFFECTIVE_START_DATE = l_EffStartDate,
878: EFFECTIVE_END_DATE = l_EffEndDate,
879: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
880: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
881: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
882: CREATED_BY = nvl(l_CreatedBy,CREATED_BY),
883: CREATION_DATE = nvl(l_CreationDate, CREATION_DATE)

Line 881: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

877: EFFECTIVE_START_DATE = l_EffStartDate,
878: EFFECTIVE_END_DATE = l_EffEndDate,
879: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
880: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
881: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
882: CREATED_BY = nvl(l_CreatedBy,CREATED_BY),
883: CREATION_DATE = nvl(l_CreationDate, CREATION_DATE)
884: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
885: AND USER_NAME = l_UserName

Line 900: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),

896: ASSIGNING_ROLE_START_DATE = l_RoleStartDate,
897: ASSIGNING_ROLE_END_DATE = l_RoleEndDate,
898: EFFECTIVE_START_DATE = l_EffStartDate,
899: EFFECTIVE_END_DATE = l_EffEndDate,
900: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
901: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
902: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
903: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
904: AND USER_NAME = l_UserName

Line 902: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)

898: EFFECTIVE_START_DATE = l_EffStartDate,
899: EFFECTIVE_END_DATE = l_EffEndDate,
900: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
901: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
902: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
903: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
904: AND USER_NAME = l_UserName
905: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
906: AND ASSIGNING_ROLE = l_RoleName;

Line 1235: LAST_UPDATED_BY = WFA_SEC.user_id,

1231: update WF_LOCAL_USER_ROLES
1232: set ASSIGNMENT_TYPE = l_assignmentType,
1233: EFFECTIVE_START_DATE= l_effStartDate,
1234: EFFECTIVE_END_DATE = l_effEndDate,
1235: LAST_UPDATED_BY = WFA_SEC.user_id,
1236: LAST_UPDATE_DATE = sysdate,
1237: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1238: where USER_NAME = l_userTAB(userIND)
1239: and ROLE_NAME = l_roleTAB(userIND);

Line 1237: LAST_UPDATE_LOGIN = WFA_SEC.login_id

1233: EFFECTIVE_START_DATE= l_effStartDate,
1234: EFFECTIVE_END_DATE = l_effEndDate,
1235: LAST_UPDATED_BY = WFA_SEC.user_id,
1236: LAST_UPDATE_DATE = sysdate,
1237: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1238: where USER_NAME = l_userTAB(userIND)
1239: and ROLE_NAME = l_roleTAB(userIND);
1240: end if;
1241: end loop;

Line 1355: WFA_SEC.user_id,

1351: l_uorigSysTAB(userIND),
1352: l_uorigSysIDTAB(userIND),
1353: l_rorigSysTAB(roleIND),
1354: l_rorigSysIDTAB(roleIND),
1355: WFA_SEC.user_id,
1356: sysdate,
1357: WFA_SEC.user_id,
1358: sysdate,
1359: WFA_SEC.login_id,

Line 1357: WFA_SEC.user_id,

1353: l_rorigSysTAB(roleIND),
1354: l_rorigSysIDTAB(roleIND),
1355: WFA_SEC.user_id,
1356: sysdate,
1357: WFA_SEC.user_id,
1358: sysdate,
1359: WFA_SEC.login_id,
1360: l_rpartIDTAB(roleIND));
1361: exception

Line 1359: WFA_SEC.login_id,

1355: WFA_SEC.user_id,
1356: sysdate,
1357: WFA_SEC.user_id,
1358: sysdate,
1359: WFA_SEC.login_id,
1360: l_rpartIDTAB(roleIND));
1361: exception
1362: when DUP_VAL_ON_INDEX then
1363: --This can happen if there is a parallel branch.

Line 1376: LAST_UPDATED_BY = WFA_SEC.user_id,

1372: ASSIGNING_ROLE_START_DATE = trunc(l_aStartDateTAB(userIND)),
1373: ASSIGNING_ROLE_END_DATE = trunc(l_aEndDateTAB(userIND)),
1374: EFFECTIVE_START_DATE = l_effStartDate,
1375: EFFECTIVE_END_DATE = l_effEndDate,
1376: LAST_UPDATED_BY = WFA_SEC.user_id,
1377: LAST_UPDATE_DATE = sysdate,
1378: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1379: where USER_NAME = l_userTAB(userIND)
1380: and ROLE_NAME = l_roleTAB(roleIND)

Line 1378: LAST_UPDATE_LOGIN = WFA_SEC.login_id

1374: EFFECTIVE_START_DATE = l_effStartDate,
1375: EFFECTIVE_END_DATE = l_effEndDate,
1376: LAST_UPDATED_BY = WFA_SEC.user_id,
1377: LAST_UPDATE_DATE = sysdate,
1378: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1379: where USER_NAME = l_userTAB(userIND)
1380: and ROLE_NAME = l_roleTAB(roleIND)
1381: and RELATIONSHIP_ID = l_relIDTAB(roleIND)
1382: and ASSIGNING_ROLE = l_assignTAB(userIND);

Line 1463: WFA_SEC.user_id,

1459: l_effEndDate,
1460: NULL,
1461: l_rpartIDTAB(roleIND),
1462: l_ownerTAB(userIND),
1463: WFA_SEC.user_id,
1464: sysdate,
1465: WFA_SEC.user_id,
1466: sysdate,
1467: WFA_SEC.login_id,

Line 1465: WFA_SEC.user_id,

1461: l_rpartIDTAB(roleIND),
1462: l_ownerTAB(userIND),
1463: WFA_SEC.user_id,
1464: sysdate,
1465: WFA_SEC.user_id,
1466: sysdate,
1467: WFA_SEC.login_id,
1468: l_AssignmentType);
1469: exception

Line 1467: WFA_SEC.login_id,

1463: WFA_SEC.user_id,
1464: sysdate,
1465: WFA_SEC.user_id,
1466: sysdate,
1467: WFA_SEC.login_id,
1468: l_AssignmentType);
1469: exception
1470: when DUP_VAL_ON_INDEX then
1471: --The record already exists, so we will just update the

Line 1497: LAST_UPDATED_BY = WFA_SEC.user_id,

1493: ROLE_START_DATE = trunc(l_rStartDateTAB(roleIND)),
1494: ROLE_END_DATE = trunc(l_rEndDateTAB(roleIND)),
1495: EFFECTIVE_START_DATE = l_effStartDate,
1496: EFFECTIVE_END_DATE = l_effEndDate,
1497: LAST_UPDATED_BY = WFA_SEC.user_id,
1498: LAST_UPDATE_DATE = sysdate,
1499: LAST_UPDATE_LOGIN = WFA_SEC.login_id,
1500: ASSIGNMENT_TYPE = l_AssignmentType
1501: where USER_NAME = l_userTAB(userIND)

Line 1499: LAST_UPDATE_LOGIN = WFA_SEC.login_id,

1495: EFFECTIVE_START_DATE = l_effStartDate,
1496: EFFECTIVE_END_DATE = l_effEndDate,
1497: LAST_UPDATED_BY = WFA_SEC.user_id,
1498: LAST_UPDATE_DATE = sysdate,
1499: LAST_UPDATE_LOGIN = WFA_SEC.login_id,
1500: ASSIGNMENT_TYPE = l_AssignmentType
1501: where USER_NAME = l_userTAB(userIND)
1502: and ROLE_NAME = l_roleTAB(roleIND)
1503: and USER_ORIG_SYSTEM = l_uorigSysTAB(userIND)

Line 1759: l_lastUpdLogTAB(tabIndex):=nvl(l_lastUpdateLogin,WFA_SEC.Login_ID);

1755: l_asgEndTAB(tabIndex) := l_endDate;
1756: l_startTAB(tabIndex) := l_startDate;
1757: l_endTAB(tabIndex) := l_endDate;
1758: -- also update WHO columns in case of self-reference
1759: l_lastUpdLogTAB(tabIndex):=nvl(l_lastUpdateLogin,WFA_SEC.Login_ID);
1760: l_lastUpdByTAB(tabIndex):=nvl(l_lastUpdatedBy, WFA_SEC.User_ID);
1761: l_lastUpdDtTAB(tabIndex):=nvl(l_lastUpdateDate,SYSDATE);
1762: end if;
1763: end if;

Line 1760: l_lastUpdByTAB(tabIndex):=nvl(l_lastUpdatedBy, WFA_SEC.User_ID);

1756: l_startTAB(tabIndex) := l_startDate;
1757: l_endTAB(tabIndex) := l_endDate;
1758: -- also update WHO columns in case of self-reference
1759: l_lastUpdLogTAB(tabIndex):=nvl(l_lastUpdateLogin,WFA_SEC.Login_ID);
1760: l_lastUpdByTAB(tabIndex):=nvl(l_lastUpdatedBy, WFA_SEC.User_ID);
1761: l_lastUpdDtTAB(tabIndex):=nvl(l_lastUpdateDate,SYSDATE);
1762: end if;
1763: end if;
1764:

Line 2678: WFA_SEC.USER_ID,

2674: values
2675: ( l_RelationshipID,
2676: p_sub_name,
2677: p_super_name,
2678: WFA_SEC.USER_ID,
2679: sysdate,
2680: WFA_SEC.USER_ID,
2681: sysdate,
2682: WFA_SEC.LOGIN_ID,

Line 2680: WFA_SEC.USER_ID,

2676: p_sub_name,
2677: p_super_name,
2678: WFA_SEC.USER_ID,
2679: sysdate,
2680: WFA_SEC.USER_ID,
2681: sysdate,
2682: WFA_SEC.LOGIN_ID,
2683: l_enabled,
2684: WFA_SEC.SECURITY_GROUP_ID,

Line 2682: WFA_SEC.LOGIN_ID,

2678: WFA_SEC.USER_ID,
2679: sysdate,
2680: WFA_SEC.USER_ID,
2681: sysdate,
2682: WFA_SEC.LOGIN_ID,
2683: l_enabled,
2684: WFA_SEC.SECURITY_GROUP_ID,
2685: l_partitionID,
2686: l_superPartitionID);

Line 2684: WFA_SEC.SECURITY_GROUP_ID,

2680: WFA_SEC.USER_ID,
2681: sysdate,
2682: WFA_SEC.LOGIN_ID,
2683: l_enabled,
2684: WFA_SEC.SECURITY_GROUP_ID,
2685: l_partitionID,
2686: l_superPartitionID);
2687: exception
2688: when DUP_VAL_ON_INDEX then

Line 2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,

2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2712: end if;
2713: -- If we are here then the ENABLED_FLAG is being changed, so we update
2714: update WF_ROLE_HIERARCHIES set
2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2716: LAST_UPDATE_DATE = sysdate,
2717: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2718: ENABLED_FLAG = l_enabled,
2719: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID

Line 2717: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,

2713: -- If we are here then the ENABLED_FLAG is being changed, so we update
2714: update WF_ROLE_HIERARCHIES set
2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2716: LAST_UPDATE_DATE = sysdate,
2717: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2718: ENABLED_FLAG = l_enabled,
2719: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID
2720: where SUB_NAME = p_sub_name
2721: and SUPER_NAME = p_super_name

Line 2719: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID

2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2716: LAST_UPDATE_DATE = sysdate,
2717: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2718: ENABLED_FLAG = l_enabled,
2719: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID
2720: where SUB_NAME = p_sub_name
2721: and SUPER_NAME = p_super_name
2722: returning RELATIONSHIP_ID into l_relationshipID;
2723: end;

Line 2829: set LAST_UPDATED_BY = WFA_SEC.USER_ID,

2825: g_modulePkg||'.ExpireRelationship.Update',
2826: 'Updating record');
2827: end if;
2828: update WF_ROLE_HIERARCHIES
2829: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2830: LAST_UPDATE_DATE = sysdate,
2831: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2832: ENABLED_FLAG = 'N'
2833: where SUB_NAME = p_sub_name

Line 2831: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,

2827: end if;
2828: update WF_ROLE_HIERARCHIES
2829: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2830: LAST_UPDATE_DATE = sysdate,
2831: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2832: ENABLED_FLAG = 'N'
2833: where SUB_NAME = p_sub_name
2834: and SUPER_NAME = p_super_name
2835: and ENABLED_FLAG = 'Y'