8: ---------------------------------------------------------------------------------
9: --Private Functions
10: ---------------------------------------------------------------------------------
11: FUNCTION HAS_NOTIFIED(
12: pSubID IN FND_OAM_BIZEX_SUBSCRIP.SUBSCRIPTION_ID%TYPE
13: , pUniqueExId IN FND_LOG_EXCEPTIONS.UNIQUE_EXCEPTION_ID%TYPE
14: )
15: RETURN BOOLEAN
16: IS
84: * ERROR
85: * WARNING
86: * ANY
87: *
88: * These are stored in FND_OAM_BIZEX_SUBSCRIP and are passed in to the
89: * function below as pItemSub.
90: *
91: *
92: *
335:
336:
337: CURSOR subs_cur is
338: SELECT subscription_id, role_id, component_type, severity, category, component_id
339: FROM FND_OAM_BIZEX_SUBSCRIP
340: WHERE
341: (application_id = l_app_id)
342: OR(application_id IS NULL)
343: ;