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 8359: WF_MESSAGE_ATTRIBUTES ma

8355: AND ntf.NOTIFICATION_ID <> orig_ntf.NOTIFICATION_ID
8356: AND orig_ntf.NOTIFICATION_ID = p_orig_ntf_id
8357: AND EXISTS (SELECT 1
8358: FROM WF_NOTIFICATION_ATTRIBUTES na,
8359: WF_MESSAGE_ATTRIBUTES ma
8360: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
8361: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
8362: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
8363: AND ma.NAME = na.NAME

Line 11219: WF_MESSAGE_ATTRIBUTES ma

11215: AND wias.ITEM_KEY = p_item_key
11216: AND ntf.RECIPIENT_ROLE = p_responder
11217: AND EXISTS (SELECT 1
11218: FROM WF_NOTIFICATION_ATTRIBUTES na,
11219: WF_MESSAGE_ATTRIBUTES ma
11220: WHERE na.NOTIFICATION_ID = ntf.NOTIFICATION_ID
11221: AND ma.MESSAGE_NAME = ntf.MESSAGE_NAME
11222: AND ma.MESSAGE_TYPE = ntf.MESSAGE_TYPE
11223: AND ma.NAME = na.NAME