7: ******************************************************************************/
8: type UsersWEmailList is Record
9: (
10: --email fnd_user.email_address%type,
11: --role_name WF_LOCAL_ROLES.name%type,
12: user_name FND_USER.USER_NAME%TYPE,
13: notification_preference WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%type
14: );
15:
9: (
10: --email fnd_user.email_address%type,
11: --role_name WF_LOCAL_ROLES.name%type,
12: user_name FND_USER.USER_NAME%TYPE,
13: notification_preference WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%type
14: );
15:
16: type UsersWEmail is table of UsersWEmailList
17: index by binary_integer;