DBA Data[Home] [Help]

APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_EXCEPTION_PREFERENCES

Line 15: from MSC_EXCEPTION_PREFERENCES ep,

11: --function returns 0 if a user has selected a exception for notifiaction else returns 1
12: function validate_block_notification(p_user_name in varchar2, p_exception_type in number) return number is
13: cursor check_user(p_user in varchar2, p_excep_type number) is
14: select 1
15: from MSC_EXCEPTION_PREFERENCES ep,
16: fnd_user u
17: where ep.user_id = u.user_id
18: and u.user_name = p_user
19: and exception_type_lookup_code = p_excep_type