DBA Data[Home] [Help]

APPS.HZ_WF_SYNCH dependencies on WF_LOCAL_ROLES

Line 7: DISPLAY_NAME WF_LOCAL_ROLES.DISPLAY_NAME%TYPE,

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,

Line 8: DESCRIPTION WF_LOCAL_ROLES.DESCRIPTION%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,

Line 9: NOTIFICATION_PREF WF_LOCAL_ROLES.NOTIFICATION_PREFERENCE%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,

Line 10: LANGUAGE WF_LOCAL_ROLES.LANGUAGE%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,

Line 11: TERRITORY WF_LOCAL_ROLES.TERRITORY%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,

Line 12: EMAIL_ADDRESS WF_LOCAL_ROLES.EMAIL_ADDRESS%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,

Line 13: FAX WF_LOCAL_ROLES.FAX%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

Line 14: STATUS WF_LOCAL_ROLES.STATUS%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: );

Line 15: START_DATE WF_LOCAL_ROLES.START_DATE%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: );
19: TYPE SYNC_TBL_TYPE IS TABLE OF SYNC_REC_TYPE INDEX BY PLS_INTEGER;

Line 16: EXPIRATION_DATE WF_LOCAL_ROLES.EXPIRATION_DATE%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;
20:

Line 17: SYSTEM_ID WF_LOCAL_ROLES.ORIG_SYSTEM_ID%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:
21: --------------------------------------