DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_EVENT

Line 43: WF_EVENT.AddParameterToList('RELATIONSHIP_ID', p_relationshipID, l_params);

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);

Line 44: WF_EVENT.AddParameterToList('SUPER_NAME', p_superName, 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',

Line 45: WF_EVENT.AddParameterToList('SUB_NAME', p_subName, l_params);

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);

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 48: WF_EVENT.AddParameterToList('SECURITY_GROUP_ID',

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);

Line 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:

Line 54: WF_EVENT.AddParameterToList('DEFER_PROPAGATION', 'FALSE', 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:
57: WF_EVENT.Raise(P_EVENT_NAME=>p_eventName,
58: P_EVENT_KEY=>p_relationshipID, P_PARAMETERS=>l_params);

Line 57: WF_EVENT.Raise(P_EVENT_NAME=>p_eventName,

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,

Line 370: -- p_event ([WF_EVENT_T])

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,

Line 375: p_event in out NOCOPY WF_EVENT_T )

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;

Line 950: WF_EVENT.setErrorInfo(p_event, 'ERROR');

946: else
947: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',
948: p_event.getEventName( ), p_sub_guid);
949:
950: WF_EVENT.setErrorInfo(p_event, 'ERROR');
951:
952: return 'ERROR';
953:
954: end if;

Line 974: -- p_event ([WF_EVENT_T])

970: -- Rule function to handle events when a relationship is created or
971: -- expired
972: -- IN
973: -- p_sub_guid (RAW)
974: -- p_event ([WF_EVENT_T])
975: -- RETURNS
976: -- VARCHAR2
977:
978: function Propagate_RF ( p_sub_guid in RAW,

Line 979: p_event in out NOCOPY WF_EVENT_T )

975: -- RETURNS
976: -- VARCHAR2
977:
978: function Propagate_RF ( p_sub_guid in RAW,
979: p_event in out NOCOPY WF_EVENT_T )
980: return VARCHAR2 is
981:
982: l_rel VARCHAR2(10);
983: l_cp_ID NUMBER;

Line 1559: -- p_event WF_EVENT_T

1555: -- Denormalize_UR_Assignments(PRIVATE)
1556: -- Procedure to update the user and role dates and
1557: -- effective dates of user/role assignments.
1558: -- IN OUT
1559: -- p_event WF_EVENT_T
1560:
1561:
1562:
1563: procedure Denormalize_UR_Assignments( p_event in out NOCOPY WF_EVENT_T)

Line 1563: procedure Denormalize_UR_Assignments( p_event in out NOCOPY WF_EVENT_T)

1559: -- p_event WF_EVENT_T
1560:
1561:
1562:
1563: procedure Denormalize_UR_Assignments( p_event in out NOCOPY WF_EVENT_T)
1564: is
1565:
1566:
1567: l_UserName VARCHAR2(320);

Line 1836: -- p_event ([WF_EVENT_T])

1832: -- Rule Function to update WF_LOCAL_USER_ROLES as
1833: -- summary table of WF_USER_ROLE_ASSIGNMENTS
1834: -- IN
1835: -- p_sub_guid (RAW)
1836: -- p_event ([WF_EVENT_T])
1837: -- returns
1838: -- VARCHAR2
1839: function Aggregate_User_Roles_RF ( p_sub_guid in RAW,
1840: p_event in out NOCOPY WF_EVENT_T)

Line 1840: p_event in out NOCOPY WF_EVENT_T)

1836: -- p_event ([WF_EVENT_T])
1837: -- returns
1838: -- VARCHAR2
1839: function Aggregate_User_Roles_RF ( p_sub_guid in RAW,
1840: p_event in out NOCOPY WF_EVENT_T)
1841: return VARCHAR2 is
1842:
1843: l_UserName VARCHAR2(320);
1844: l_RoleName VARCHAR2(320);

Line 2309: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2305:
2306: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',
2307: p_event.getEventName( ), p_sub_guid);
2308:
2309: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2310: return 'ERROR';
2311:
2312:
2313: end Aggregate_User_Roles_RF;

Line 2927: -- p_event ([WF_EVENT_T])

2923: -- Rule function to update the user and role dates of user/role
2924: -- relationships as well as assignments.
2925: -- IN
2926: -- p_sub_guid (RAW)
2927: -- p_event ([WF_EVENT_T])
2928: -- RETURNS
2929: -- VARCHAR2
2930:
2931: function Denormalize_User_Role_RF ( p_sub_guid in RAW,

Line 2932: p_event in out NOCOPY WF_EVENT_T )

2928: -- RETURNS
2929: -- VARCHAR2
2930:
2931: function Denormalize_User_Role_RF ( p_sub_guid in RAW,
2932: p_event in out NOCOPY WF_EVENT_T )
2933: return VARCHAR2 is
2934:
2935:
2936:

Line 2953: WF_EVENT.setErrorInfo(p_event, 'ERROR');

2949:
2950: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',
2951: p_event.getEventName( ), p_sub_guid);
2952:
2953: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2954: return 'ERROR';
2955: end Denormalize_User_Role_RF;
2956:
2957: