DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_UTIL dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 2329: FROM WF_NOTIFICATION_ATTRIBUTES na,

2325: SELECT na.NAME
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

Line 8323: FROM WF_NOTIFICATION_ATTRIBUTES na,

8319: AND ntf.GROUP_ID = orig_ntf.GROUP_ID
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

Line 9910: , WF_NOTIFICATION_ATTRIBUTES wfna

9906: SELECT COUNT(*)
9907: INTO l_code_count
9908: FROM ENG_CHANGE_ROUTE_PEOPLE RoutePeople
9909: , EGO_USER_V UserV
9910: , WF_NOTIFICATION_ATTRIBUTES wfna
9911: , WF_NOTIFICATIONS wn
9912: WHERE RoutePeople.assignee_id = UserV.party_id
9913: AND RoutePeople.response_condition_code = 'MANDATORY'
9914: AND RoutePeople.step_id = StepId

Line 11142: FROM WF_NOTIFICATION_ATTRIBUTES na,

11138: AND wias.ITEM_TYPE = p_item_type
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