3:
4: TYPE SYNC_REC_TYPE IS RECORD
5: (
6: USER_NAME WF_LOCAL_USER_ROLES.USER_NAME%TYPE,
7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
4: TYPE SYNC_REC_TYPE IS RECORD
5: (
6: USER_NAME WF_LOCAL_USER_ROLES.USER_NAME%TYPE,
7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
5: (
6: USER_NAME WF_LOCAL_USER_ROLES.USER_NAME%TYPE,
7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
6: USER_NAME WF_LOCAL_USER_ROLES.USER_NAME%TYPE,
7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%TYPE,
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%TYPE,
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
18: );
11: TERRITORY WF_LOCAL_ROLES.TERRITORY%TYPE,
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
18: );
19: TYPE SYNC_TBL_TYPE IS TABLE OF SYNC_REC_TYPE INDEX BY PLS_INTEGER;
12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%TYPE,
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
18: );
19: TYPE SYNC_TBL_TYPE IS TABLE OF SYNC_REC_TYPE INDEX BY PLS_INTEGER;
20:
13: FAX WF_LOCAL_ROLES.FAX%TYPE,
14: STATUS WF_LOCAL_ROLES.STATUS%TYPE,
15: START_DATE WF_LOCAL_ROLES.START_DATE%TYPE,
16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%TYPE,
17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE
18: );
19: TYPE SYNC_TBL_TYPE IS TABLE OF SYNC_REC_TYPE INDEX BY PLS_INTEGER;
20:
21: --------------------------------------