DBA Data[Home] [Help]

APPS.WF_ENGINE_UTIL dependencies on WF_MESSAGE_ATTRIBUTES

Line 2690: from WF_MESSAGE_ATTRIBUTES

2686: -- to be responded to.
2687: begin
2688: select 1 into dummy from sys.dual where exists
2689: (select null
2690: from WF_MESSAGE_ATTRIBUTES
2691: where MESSAGE_TYPE = msgtype
2692: and MESSAGE_NAME = msg
2693: AND SUBTYPE = 'RESPOND');
2694:

Line 2811: from WF_MESSAGE_ATTRIBUTES

2807: NAME,
2808: TEXT_DEFAULT,
2809: NUMBER_DEFAULT,
2810: DATE_DEFAULT
2811: from WF_MESSAGE_ATTRIBUTES
2812: where MESSAGE_TYPE = ntf_row.MESSAGE_TYPE
2813: and MESSAGE_NAME = ntf_row.MESSAGE_NAME
2814: and name not in
2815: (select name

Line 2877: wf_message_attributes ma

2873: ma.TEXT_DEFAULT, ma.NUMBER_DEFAULT, ma.DATE_DEFAULT,
2874: n.notification_id
2875: from wf_item_activity_statuses_h ias,
2876: wf_notifications n,
2877: wf_message_attributes ma
2878: where ias.item_type = itemtype
2879: and ias.item_key = itemkey
2880: and ias.notification_id = n.notification_id
2881: and ma.message_type = n.message_type