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 973: WF_EVENT.setErrorInfo(p_event, 'ERROR');

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;

Line 997: -- p_event ([WF_EVENT_T])

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,

Line 1002: p_event in out NOCOPY WF_EVENT_T )

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;

Line 1587: -- p_event WF_EVENT_T

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)

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

Line 1864: -- p_event ([WF_EVENT_T])

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)

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

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

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;

Line 2887: -- p_event ([WF_EVENT_T])

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,

Line 2892: p_event in out NOCOPY WF_EVENT_T )

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:

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

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: