DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_EVENT_T

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