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 704: nvl(l_CreatedBy,WFA_SEC.User_ID),

700: l_UserStartDate,
701: l_UserEndDate,
702: l_RoleStartDate,
703: l_RoleEndDate,
704: nvl(l_CreatedBy,WFA_SEC.User_ID),
705: nvl(l_CreationDate,SYSDATE),
706: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
707: nvl(l_LastUpdateDate,SYSDATE),
708: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

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

702: l_RoleStartDate,
703: l_RoleEndDate,
704: nvl(l_CreatedBy,WFA_SEC.User_ID),
705: nvl(l_CreationDate,SYSDATE),
706: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
707: nvl(l_LastUpdateDate,SYSDATE),
708: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
709: l_partitionID,
710: l_effStartDate,

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

704: nvl(l_CreatedBy,WFA_SEC.User_ID),
705: nvl(l_CreationDate,SYSDATE),
706: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
707: nvl(l_LastUpdateDate,SYSDATE),
708: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
709: l_partitionID,
710: l_effStartDate,
711: l_effEndDate,
712: l_UserOrigSystem,

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

823: l_SupStartDate,
824: l_SupEndDate,
825: l_RoleStartDate,
826: l_RoleEndDate,
827: nvl(l_CreatedBy,WFA_SEC.User_ID),
828: nvl(l_CreationDate,SYSDATE),
829: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
830: nvl(l_LastUpdateDate,SYSDATE),
831: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),

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

825: l_RoleStartDate,
826: l_RoleEndDate,
827: nvl(l_CreatedBy,WFA_SEC.User_ID),
828: nvl(l_CreationDate,SYSDATE),
829: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
830: nvl(l_LastUpdateDate,SYSDATE),
831: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
832: l_partitionID,
833: l_EffStartDate,

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

827: nvl(l_CreatedBy,WFA_SEC.User_ID),
828: nvl(l_CreationDate,SYSDATE),
829: nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
830: nvl(l_LastUpdateDate,SYSDATE),
831: nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
832: l_partitionID,
833: l_EffStartDate,
834: l_EffEndDate,
835: l_UserOrigSystem,

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

852: ASSIGNING_ROLE_START_DATE = l_RoleStartDate,
853: ASSIGNING_ROLE_END_DATE = l_RoleEndDate,
854: EFFECTIVE_START_DATE = l_EffStartDate,
855: EFFECTIVE_END_DATE = l_EffEndDate,
856: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
857: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
858: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
859: CREATED_BY = nvl(l_CreatedBy,CREATED_BY),
860: CREATION_DATE = nvl(l_CreationDate, CREATION_DATE)

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

854: EFFECTIVE_START_DATE = l_EffStartDate,
855: EFFECTIVE_END_DATE = l_EffEndDate,
856: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
857: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
858: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID),
859: CREATED_BY = nvl(l_CreatedBy,CREATED_BY),
860: CREATION_DATE = nvl(l_CreationDate, CREATION_DATE)
861: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
862: AND USER_NAME = l_UserName

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

873: ASSIGNING_ROLE_START_DATE = l_RoleStartDate,
874: ASSIGNING_ROLE_END_DATE = l_RoleEndDate,
875: EFFECTIVE_START_DATE = l_EffStartDate,
876: EFFECTIVE_END_DATE = l_EffEndDate,
877: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
878: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
879: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
880: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
881: AND USER_NAME = l_UserName

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

875: EFFECTIVE_START_DATE = l_EffStartDate,
876: EFFECTIVE_END_DATE = l_EffEndDate,
877: LAST_UPDATED_BY = nvl(l_LastUpdatedBy, WFA_SEC.User_ID),
878: LAST_UPDATE_DATE = nvl(l_LastUpdateDate,SYSDATE),
879: LAST_UPDATE_LOGIN = nvl(l_LastUpdateLogin,WFA_SEC.LOGIN_ID)
880: WHERE RELATIONSHIP_ID = l_superiors(l_count).RELATIONSHIP_ID
881: AND USER_NAME = l_UserName
882: AND ROLE_NAME = l_superiors(l_count).SUPER_NAME
883: AND ASSIGNING_ROLE = l_RoleName;

Line 1209: LAST_UPDATED_BY = WFA_SEC.user_id,

1205: update WF_LOCAL_USER_ROLES
1206: set ASSIGNMENT_TYPE = l_assignmentType,
1207: EFFECTIVE_START_DATE= l_effStartDate,
1208: EFFECTIVE_END_DATE = l_effEndDate,
1209: LAST_UPDATED_BY = WFA_SEC.user_id,
1210: LAST_UPDATE_DATE = sysdate,
1211: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1212: where USER_NAME = l_userTAB(userIND)
1213: and ROLE_NAME = l_roleTAB(userIND);

Line 1211: LAST_UPDATE_LOGIN = WFA_SEC.login_id

1207: EFFECTIVE_START_DATE= l_effStartDate,
1208: EFFECTIVE_END_DATE = l_effEndDate,
1209: LAST_UPDATED_BY = WFA_SEC.user_id,
1210: LAST_UPDATE_DATE = sysdate,
1211: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1212: where USER_NAME = l_userTAB(userIND)
1213: and ROLE_NAME = l_roleTAB(userIND);
1214: end if;
1215: end loop;

Line 1327: WFA_SEC.user_id,

1323: l_uorigSysTAB(userIND),
1324: l_uorigSysIDTAB(userIND),
1325: l_rorigSysTAB(roleIND),
1326: l_rorigSysIDTAB(roleIND),
1327: WFA_SEC.user_id,
1328: sysdate,
1329: WFA_SEC.user_id,
1330: sysdate,
1331: WFA_SEC.login_id,

Line 1329: WFA_SEC.user_id,

1325: l_rorigSysTAB(roleIND),
1326: l_rorigSysIDTAB(roleIND),
1327: WFA_SEC.user_id,
1328: sysdate,
1329: WFA_SEC.user_id,
1330: sysdate,
1331: WFA_SEC.login_id,
1332: l_apartIDTAB(userIND));
1333: exception

Line 1331: WFA_SEC.login_id,

1327: WFA_SEC.user_id,
1328: sysdate,
1329: WFA_SEC.user_id,
1330: sysdate,
1331: WFA_SEC.login_id,
1332: l_apartIDTAB(userIND));
1333: exception
1334: when DUP_VAL_ON_INDEX then
1335: --This can happen if there is a parallel branch.

Line 1348: LAST_UPDATED_BY = WFA_SEC.user_id,

1344: ASSIGNING_ROLE_START_DATE = trunc(l_aStartDateTAB(userIND)),
1345: ASSIGNING_ROLE_END_DATE = trunc(l_aEndDateTAB(userIND)),
1346: EFFECTIVE_START_DATE = l_effStartDate,
1347: EFFECTIVE_END_DATE = l_effEndDate,
1348: LAST_UPDATED_BY = WFA_SEC.user_id,
1349: LAST_UPDATE_DATE = sysdate,
1350: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1351: where USER_NAME = l_userTAB(userIND)
1352: and ROLE_NAME = l_roleTAB(roleIND)

Line 1350: LAST_UPDATE_LOGIN = WFA_SEC.login_id

1346: EFFECTIVE_START_DATE = l_effStartDate,
1347: EFFECTIVE_END_DATE = l_effEndDate,
1348: LAST_UPDATED_BY = WFA_SEC.user_id,
1349: LAST_UPDATE_DATE = sysdate,
1350: LAST_UPDATE_LOGIN = WFA_SEC.login_id
1351: where USER_NAME = l_userTAB(userIND)
1352: and ROLE_NAME = l_roleTAB(roleIND)
1353: and RELATIONSHIP_ID = l_relIDTAB(roleIND)
1354: and ASSIGNING_ROLE = l_assignTAB(userIND);

Line 1435: WFA_SEC.user_id,

1431: l_effEndDate,
1432: NULL,
1433: l_rpartIDTAB(roleIND),
1434: l_ownerTAB(userIND),
1435: WFA_SEC.user_id,
1436: sysdate,
1437: WFA_SEC.user_id,
1438: sysdate,
1439: WFA_SEC.login_id,

Line 1437: WFA_SEC.user_id,

1433: l_rpartIDTAB(roleIND),
1434: l_ownerTAB(userIND),
1435: WFA_SEC.user_id,
1436: sysdate,
1437: WFA_SEC.user_id,
1438: sysdate,
1439: WFA_SEC.login_id,
1440: l_AssignmentType);
1441: exception

Line 1439: WFA_SEC.login_id,

1435: WFA_SEC.user_id,
1436: sysdate,
1437: WFA_SEC.user_id,
1438: sysdate,
1439: WFA_SEC.login_id,
1440: l_AssignmentType);
1441: exception
1442: when DUP_VAL_ON_INDEX then
1443: --The record already exists, so we will just update the

Line 1469: LAST_UPDATED_BY = WFA_SEC.user_id,

1465: ROLE_START_DATE = trunc(l_rStartDateTAB(roleIND)),
1466: ROLE_END_DATE = trunc(l_rEndDateTAB(roleIND)),
1467: EFFECTIVE_START_DATE = l_effStartDate,
1468: EFFECTIVE_END_DATE = l_effEndDate,
1469: LAST_UPDATED_BY = WFA_SEC.user_id,
1470: LAST_UPDATE_DATE = sysdate,
1471: LAST_UPDATE_LOGIN = WFA_SEC.login_id,
1472: ASSIGNMENT_TYPE = l_AssignmentType
1473: where USER_NAME = l_userTAB(userIND)

Line 1471: LAST_UPDATE_LOGIN = WFA_SEC.login_id,

1467: EFFECTIVE_START_DATE = l_effStartDate,
1468: EFFECTIVE_END_DATE = l_effEndDate,
1469: LAST_UPDATED_BY = WFA_SEC.user_id,
1470: LAST_UPDATE_DATE = sysdate,
1471: LAST_UPDATE_LOGIN = WFA_SEC.login_id,
1472: ASSIGNMENT_TYPE = l_AssignmentType
1473: where USER_NAME = l_userTAB(userIND)
1474: and ROLE_NAME = l_roleTAB(roleIND)
1475: and USER_ORIG_SYSTEM = l_uorigSysTAB(userIND)

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

1727: l_asgEndTAB(tabIndex) := l_endDate;
1728: l_startTAB(tabIndex) := l_startDate;
1729: l_endTAB(tabIndex) := l_endDate;
1730: -- also update WHO columns in case of self-reference
1731: l_lastUpdLogTAB(tabIndex):=nvl(l_lastUpdateLogin,WFA_SEC.Login_ID);
1732: l_lastUpdByTAB(tabIndex):=nvl(l_lastUpdatedBy, WFA_SEC.User_ID);
1733: l_lastUpdDtTAB(tabIndex):=nvl(l_lastUpdateDate,SYSDATE);
1734: end if;
1735: end if;

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

1728: l_startTAB(tabIndex) := l_startDate;
1729: l_endTAB(tabIndex) := l_endDate;
1730: -- also update WHO columns in case of self-reference
1731: l_lastUpdLogTAB(tabIndex):=nvl(l_lastUpdateLogin,WFA_SEC.Login_ID);
1732: l_lastUpdByTAB(tabIndex):=nvl(l_lastUpdatedBy, WFA_SEC.User_ID);
1733: l_lastUpdDtTAB(tabIndex):=nvl(l_lastUpdateDate,SYSDATE);
1734: end if;
1735: end if;
1736:

Line 2719: WFA_SEC.USER_ID,

2715: values
2716: ( l_RelationshipID,
2717: p_sub_name,
2718: p_super_name,
2719: WFA_SEC.USER_ID,
2720: sysdate,
2721: WFA_SEC.USER_ID,
2722: sysdate,
2723: WFA_SEC.LOGIN_ID,

Line 2721: WFA_SEC.USER_ID,

2717: p_sub_name,
2718: p_super_name,
2719: WFA_SEC.USER_ID,
2720: sysdate,
2721: WFA_SEC.USER_ID,
2722: sysdate,
2723: WFA_SEC.LOGIN_ID,
2724: l_enabled,
2725: WFA_SEC.SECURITY_GROUP_ID,

Line 2723: WFA_SEC.LOGIN_ID,

2719: WFA_SEC.USER_ID,
2720: sysdate,
2721: WFA_SEC.USER_ID,
2722: sysdate,
2723: WFA_SEC.LOGIN_ID,
2724: l_enabled,
2725: WFA_SEC.SECURITY_GROUP_ID,
2726: l_partitionID,
2727: l_superPartitionID);

Line 2725: WFA_SEC.SECURITY_GROUP_ID,

2721: WFA_SEC.USER_ID,
2722: sysdate,
2723: WFA_SEC.LOGIN_ID,
2724: l_enabled,
2725: WFA_SEC.SECURITY_GROUP_ID,
2726: l_partitionID,
2727: l_superPartitionID);
2728: exception
2729: when DUP_VAL_ON_INDEX then

Line 2739: LAST_UPDATED_BY = WFA_SEC.USER_ID,

2735: '.AddRelationship.Insert.DUP_VAL_ON_INDEX',
2736: 'Updating expired relationship');
2737: end if;
2738: update WF_ROLE_HIERARCHIES set
2739: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2740: LAST_UPDATE_DATE = sysdate,
2741: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2742: ENABLED_FLAG = 'Y',
2743: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID

Line 2741: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,

2737: end if;
2738: update WF_ROLE_HIERARCHIES set
2739: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2740: LAST_UPDATE_DATE = sysdate,
2741: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2742: ENABLED_FLAG = 'Y',
2743: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID
2744: where SUB_NAME = p_sub_name
2745: and SUPER_NAME = p_super_name

Line 2743: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID

2739: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2740: LAST_UPDATE_DATE = sysdate,
2741: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2742: ENABLED_FLAG = 'Y',
2743: SECURITY_GROUP_ID = WFA_SEC.SECURITY_GROUP_ID
2744: where SUB_NAME = p_sub_name
2745: and SUPER_NAME = p_super_name
2746: and ENABLED_FLAG = 'N'
2747: returning RELATIONSHIP_ID into l_relationshipID;

Line 2869: set LAST_UPDATED_BY = WFA_SEC.USER_ID,

2865: g_modulePkg||'.ExpireRelationship.Update',
2866: 'Updating record');
2867: end if;
2868: update WF_ROLE_HIERARCHIES
2869: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2870: LAST_UPDATE_DATE = sysdate,
2871: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2872: ENABLED_FLAG = 'N'
2873: where SUB_NAME = p_sub_name

Line 2871: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,

2867: end if;
2868: update WF_ROLE_HIERARCHIES
2869: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2870: LAST_UPDATE_DATE = sysdate,
2871: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2872: ENABLED_FLAG = 'N'
2873: where SUB_NAME = p_sub_name
2874: and SUPER_NAME = p_super_name
2875: and ENABLED_FLAG = 'Y'