DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on WF_MESSAGE_ATTRIBUTES

Line 2330: WF_MESSAGE_ATTRIBUTES ma,

2326: , na.TEXT_VALUE
2327: , na.NUMBER_VALUE
2328: , na.DATE_VALUE
2329: FROM WF_NOTIFICATION_ATTRIBUTES na,
2330: WF_MESSAGE_ATTRIBUTES ma,
2331: WF_NOTIFICATIONS ntf
2332: WHERE ntf.NOTIFICATION_ID = p_orig_ntf_id
2333: AND na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
2334: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME

Line 8324: WF_MESSAGE_ATTRIBUTES ma

8320: AND ntf.NOTIFICATION_ID <> orig_ntf.NOTIFICATION_ID
8321: AND orig_ntf.NOTIFICATION_ID = p_orig_ntf_id
8322: AND EXISTS (SELECT 1
8323: FROM WF_NOTIFICATION_ATTRIBUTES na,
8324: WF_MESSAGE_ATTRIBUTES ma
8325: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
8326: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8327: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
8328: AND ma.NAME = na.NAME

Line 11143: WF_MESSAGE_ATTRIBUTES ma

11139: AND wias.ITEM_KEY = p_item_key
11140: AND ntf.RECIPIENT_ROLE = p_responder
11141: AND EXISTS (SELECT 1
11142: FROM WF_NOTIFICATION_ATTRIBUTES na,
11143: WF_MESSAGE_ATTRIBUTES ma
11144: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
11145: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
11146: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
11147: AND ma.NAME = na.NAME