39: p_relationshipID||', '||p_superName||', '||
40: p_subName||')');
41: end if;
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);
40: p_subName||')');
41: end if;
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',
41: end if;
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);
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:
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
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
52: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'TRUE', 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
54: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'FALSE', l_params);
55: end if;
56:
50:
51: if (p_defer) then
52: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'TRUE', l_params);
53: else
54: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'FALSE', l_params);
55: end if;
56:
57: WF_EVENT.Raise(P_EVENT_NAME=>p_eventName,
58: P_EVENT_KEY=>p_relationshipID, P_PARAMETERS=>l_params);
53: else
54: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'FALSE', l_params);
55: end if;
56:
57: WF_EVENT.Raise(P_EVENT_NAME=>p_eventName,
58: P_EVENT_KEY=>p_relationshipID, P_PARAMETERS=>l_params);
59:
60: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
61: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_PROCEDURE,
366: -- Rule function to cascade changes according to the active hierarchy
367: -- when a user/role relationship is assigned or revoked.
368: -- IN
369: -- p_sub_guid (RAW)
370: -- p_event ([WF_EVENT_T])
371: -- RETURNS
372: -- VARCHAR2
373:
374: function Cascade_RF ( p_sub_guid in RAW,
371: -- RETURNS
372: -- VARCHAR2
373:
374: function Cascade_RF ( p_sub_guid in RAW,
375: p_event in out NOCOPY WF_EVENT_T )
376: return VARCHAR2 is
377:
378: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
379: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
969: else
970: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',
971: p_event.getEventName( ), p_sub_guid);
972:
973: WF_EVENT.setErrorInfo(p_event, 'ERROR');
974:
975: return 'ERROR';
976:
977: end if;
993: -- Rule function to handle events when a relationship is created or
994: -- expired
995: -- IN
996: -- p_sub_guid (RAW)
997: -- p_event ([WF_EVENT_T])
998: -- RETURNS
999: -- VARCHAR2
1000:
1001: function Propagate_RF ( p_sub_guid in RAW,
998: -- RETURNS
999: -- VARCHAR2
1000:
1001: function Propagate_RF ( p_sub_guid in RAW,
1002: p_event in out NOCOPY WF_EVENT_T )
1003: return VARCHAR2 is
1004:
1005: l_rel VARCHAR2(10);
1006: l_cp_ID NUMBER;
1583: -- Denormalize_UR_Assignments(PRIVATE)
1584: -- Procedure to update the user and role dates and
1585: -- effective dates of user/role assignments.
1586: -- IN OUT
1587: -- p_event WF_EVENT_T
1588:
1589:
1590:
1591: procedure Denormalize_UR_Assignments( p_event in out NOCOPY WF_EVENT_T)
1587: -- p_event WF_EVENT_T
1588:
1589:
1590:
1591: procedure Denormalize_UR_Assignments( p_event in out NOCOPY WF_EVENT_T)
1592: is
1593:
1594:
1595: l_UserName VARCHAR2(320);
1860: -- Rule Function to update WF_LOCAL_USER_ROLES as
1861: -- summary table of WF_USER_ROLE_ASSIGNMENTS
1862: -- IN
1863: -- p_sub_guid (RAW)
1864: -- p_event ([WF_EVENT_T])
1865: -- returns
1866: -- VARCHAR2
1867: function Aggregate_User_Roles_RF ( p_sub_guid in RAW,
1868: p_event in out NOCOPY WF_EVENT_T)
1864: -- p_event ([WF_EVENT_T])
1865: -- returns
1866: -- VARCHAR2
1867: function Aggregate_User_Roles_RF ( p_sub_guid in RAW,
1868: p_event in out NOCOPY WF_EVENT_T)
1869: return VARCHAR2 is
1870:
1871: l_UserName VARCHAR2(320);
1872: l_RoleName VARCHAR2(320);
2333:
2334: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',
2335: p_event.getEventName( ), p_sub_guid);
2336:
2337: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2338: return 'ERROR';
2339:
2340:
2341: end Aggregate_User_Roles_RF;
2883: -- Rule function to update the user and role dates of user/role
2884: -- relationships as well as assignments.
2885: -- IN
2886: -- p_sub_guid (RAW)
2887: -- p_event ([WF_EVENT_T])
2888: -- RETURNS
2889: -- VARCHAR2
2890:
2891: function Denormalize_User_Role_RF ( p_sub_guid in RAW,
2888: -- RETURNS
2889: -- VARCHAR2
2890:
2891: function Denormalize_User_Role_RF ( p_sub_guid in RAW,
2892: p_event in out NOCOPY WF_EVENT_T )
2893: return VARCHAR2 is
2894:
2895:
2896:
2909:
2910: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',
2911: p_event.getEventName( ), p_sub_guid);
2912:
2913: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2914: return 'ERROR';
2915: end Denormalize_User_Role_RF;
2916:
2917: